Real Estate Financial Modeling

All | Argus | All-in-OneExcel Models | Excel TipsStochastic Modeling

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Enroll for April 1st Start)

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.Over the years, we've covered hundreds of real estate modeling topics in our blog;…
adventures in cre real estate modeler creating cash-on-cash return equity waterfall
, , ,

Real Estate Equity Waterfall Model With Cash-on-Cash Return Hurdle (Updated 9.11.2018)

Over the years, Michael and I have built and shared numerous real estate equity waterfall models, all multi-tiered and most with internal rate of return (IRR) hurdles. And as our readers have downloaded those models, I've received dozens of…
, , ,

Real Estate Equity Waterfall Model - IRR and Equity Multiple Hurdles (Updated 9.4.2018)

Over the years, my real estate equity waterfall with annual periods and the [glossary_exclude]option[/glossary_exclude] of using either IRR or Equity Multiple Hurdles has been one of the most popular models download at Adventures in CRE. I've…
, , ,

Real Estate Equity Waterfall Model - Monthly Periods (Updated 9.3.2018)

When I decided to share my real estate equity waterfall model in Excel, I never imagined it would be as popular as it has. The model has been downloaded thousands times and many of you have written to extend your thanks for sharing. It is gratifying…
, , , ,

Single Family Residential Investment Analysis Model (Updated 9.1.2018)

Pre-2008, I bought and sold my fair share of single family homes - both for investment purposes (rental or flips) and to live in. In those days, almost everyone was "investing" in residential real estate - hence the market crash.I personally…
, , , ,

Understanding Treatment of Time 0 in the All-in-One Model

I received a very astute question/concern from a user of our All-in-One(Ai1) model in our Ai1 Support Forum late last month. I initially set out to answer the question in writing, but the more I thought about my response, the more I concluded…
, , , , , , ,

Using Boolean Logic to Model Multiple Generations of Tenant Improvements

Arguably the most powerful, and least appreciated and understood, functionality in Excel is its use of boolean logic. Or in other words, the use of TRUE and FALSE binary logic. This form of logic can be used to dramatically simplify formulas…
, , , , , , , , , , ,

Actual + Forecast Construction Draw Schedule with S-Curve

Several times in the last month, I've been asked to tackle an interesting real estate financial modeling challenge - pare actual construction draw cash flows with s-curve cash flow forecasts to create an Actuals + Forecast Construction Draw…
, , , , ,

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

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 should be aware of these methods if they want to understand the real interest…
, , ,

A.CRE User Insights Survey

We need your help! As Adventures in CRE (A.CRE) has grown and evolved over the years, so have the needs of our readers. The challenge for Michael and I as we contemplate what new content to create, is knowing what resources will be most beneficial…
, , , , , ,

Watch Me Build: Construction Draw Schedule

The video below and corresponding downloadable templates will walk you through how to build a basic construction draw schedule.Basic Construction Financing & Draw schedules: A Conceptual Overview A standard draw schedule with a basic…
, ,

Keyboard Shortcuts I Use Constantly When Modeling in Excel (Formatting)

The more you model real estate in Microsoft Excel, the faster and more accurate you become - and hopefully as a consequence the more valuable you become to real estate employers and investors. Part of the process of mastering real estate financial…
, , , , , , , , , , ,

Development Draw Schedule - Visually Customize Each Line Item

Working a lot with development draw schedules, I have always been looking for a catch all solution as to how one could easily model all the unique ways cash actually flows over time during the process. The norm for many is to model cash flows…
, , ,

How to Create Dynamic, In-Cell Buttons and Toggles in Microsoft Excel

Creating intuitive, user-friendly, visually appealing models is one aspect of mastering real estate financial modeling. One way to make your models easy for people to use and more attractive in general is to use dynamic, theme-appropriate, in-cell…
, , ,

Auto-Populate Latitude and Longitude in Excel (Updated 2018)

When analyzing real estate investments in Excel, it's often necessary to include the latitude and longitude coordinates of the properties we're modeling. To do this, most of us open up Google Maps, or some other mapping tool, and find the…
, , , ,

Convert Monthly Cash Flows to Quarterly and Annual Cash Flows

Over the past few years, I've been working to build an ARGUS DCF alternative in Excel - or otherwise known here as the A.CRE All-in-One (Ai1) Model. As I've worked on that model, I've been jotting down modeling techniques I use and think would…