, , ,

Real Estate Financial Modeling Accelerator (Updated October 2019)

Since starting A.CRE, Michael and I have fielded email after email requesting a more structured real estate financial modeling training program on the site. Important Note: We're updating and adding to the Accelerator every week. Since launch,…
, , , , ,

Roll Up Your Monthly Cash Flow Line Items Into Annual Periods Using Only One Formula For The Whole Sheet

While building out my hotel development model (currently underway), I decided to take a break and record a video about how I roll up the monthly cash flow line items on my Monthly Cash Flow sheet into annual cash flow line items on a separate…
, ,

Graduate Real Estate Series: MIT MSRED

The Massachusetts Institute of Technology's Master of Science in Real Estate Development (MSRED) program is an eleven (or 16) month graduate program in real estate offered through MIT's Center for Real Estate. Espousing MIT's motto: Mens et…
, , , , , , ,

Watch Me Build a Residential Land Development Model

Over the years, we've created a sizable library of Watch Me Build videos covering Excel models for various real estate investment and property types. However, we've yet to create a Watch Me Build involving for-sale product. So this weekend,…
, , ,

A.CRE Flashcard Series - Sharpen Your Vocabulary (Updated 09.25.19)

As Spencer and I continue to flesh out the Adventures in CRE Glossary of Commercial Real Estate Terms, we thought it would be fun and useful to provide some of our readers who are just starting out in the industry with some practice flashcards.…
, ,

Best Practices in Real Estate Financial Modeling

Before you use one of our real estate financial models (i.e. Excel templates), or before you set out to build your own real estate analysis tool in Excel, it's important to keep in mind a few real estate financial modeling best practices. This…
, , , , , , ,

How to Run Monte Carlo Simulations in Excel

So you want to run Monte Carlo simulations in Excel, but your project isn't large enough or you don't do this type of probabilistic analysis enough to warrant buying an expensive add-in. Well, you've come to the right place. Excel's built-in…
, , , , , ,

Watch Me Build a 3-Tier Real Estate Equity Waterfall Model (Updated August 2019)

As I've mentioned in other Watch Me Build posts, one way to become a better real estate financial modeling professional, is to watch other professionals model. Thus, the more exposure you can get to other's methods, the more adept a real estate…
, , , , , , ,

Deep Dive: Careers in Commercial Real Estate

The real estate industry is enormous. In the United States alone, over 3.7 million jobs are tied to commercial real estate, 13% of GDP comes from the real estate industry, and the aggregate value of U.S. commercial real estate is approximately…
, , , , , ,

30/360, Actual/365, and Actual/360 - How Lenders Calculate Interest on CRE Loans – Some Important Insights

(Updated August 7, 2019 to include a Watch Me Build video and Downloadable file)Commercial real estate lenders commonly calculate loans in three ways: 30/360, Actual/365 (aka 365/365), and Actual/360 (aka 365/360). Real estate professionals…
, ,

Glossary of Commercial Real Estate Terms (Updated Aug 2019)

Glossary of Commercial Real Estate Terms Welcome to the new Glossary of Commercial Real Estate Terms on A.CRE. This will be an ever growing list of commercial real estate terms and definitions and we hope it will become a valuable resource…
, , , , ,

Tutorials For The Hotel Valuation Model (Updated 07.23.19)

Welcome to the A.CRE Hotel Valuation Model's Tutorial Page. On this page you will find all the tutorials for the A.CRE Hotel Valuation model in Excel. There is a lot to learn within this model and over time, I'd like to show you both how to…