Real Estate Education

All | A.CRE 101 | College Education | Special Topics | Book Reviews | CRE Terms | Find a Job

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated April 2024)

Prior to launching the Accelerator program, Michael and I fielded email after email requesting a more structured real estate financial modeling training program on the site. Over the years, we've covered hundreds of real estate modeling…
, ,

Analyzing a Real Estate Investment from the Perspective of an LP

We received a question from an A.CRE reader this week that I thought warranted a thorough response. The question was, and I paraphrase, "I am an LP looking for models to help vet syndication deals. Do you have any models that can be used…
, , , , ,

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,…
, , , , , , ,

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…
, , , , ,

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…
, , , , , , , ,

Watch Me Build a Dynamic Mortgage Amortization Table in Excel

There are a few basic, yet fundamental, real estate modeling skills you must master before anyone will take you seriously as a real estate professional. Building a mortgage amortization schedule is one of them. Virtually every model you…
, , , , ,

Through The Entitlement Process: Identifying Risks and Strategies For Mitigation

Investing in and developing an unentitled site, broadly speaking, is one of the riskiest, yet rewarding, endeavors in the commercial real estate industry. The entitlement process, in particular, is fraught with the potential for setbacks and…
, , , ,

Using the OFFSET Function in Real Estate Financial Modeling

In a previous post, I showed you how to use the OFFSET function to create dynamic lists in Excel. As you become more comfortable using this function in real estate financial modeling, you'll find that it has almost infinite applications when…
, ,

A.CRE 101 – Create Smart Drop-Down Menus in Real Estate Modeling

One Excel feature real estate financial modeling professionals use often is the data validation list. Where data validation is a method of limiting the possible inputs of a cell, the data validation list limits those inputs to a pre-defined…
, , ,

Deep Dive: Understanding Acquisitions: The Letter of Intent (LOI)

The Letter of Intent - Legal Issues The letter of intent is a critical document that is written up at the beginning of a potential real estate transaction between either a prospective buyer and seller or a prospective tenant and landlord.…