Real Estate Financial Modeling

All | Argus | All-in-One | Excel Models | Excel Tips | Stochastic Modeling

banner post a commercial real estate job to adventures in cre

, , , , , , , , , , , ,

All-in-One (Ai1) Underwriting Model for Real Estate Development and Acquisition (Updated 9.17.17)

As many of you recall, in 2015 I set out to build an Excel alternative to the widely-used (and now discontinued) ARGUS DCF. With career moves and a lot of other A.CRE-related side projects, this undertaking has been slow going. Alas, in 2016…
real estate professional using the income approach, a financial tool to value income producing property
, , , , ,

A.CRE 101: How to Use the Income Capitalization Approach to Value Income-Producing Property

In commercial real estate, there are a few generally accepted methods for appraising (or valuing) real property. The three most common are the Cost Approach, the Sales Comparison Method, and the Income Approach. The Income Approach includes…
, , , , ,

3 Tiered Waterfall Module Added to the Condo Development Model

After receiving a few requests, I've finally gotten around to adding an equity waterfall module to the Condominium Development Model. This module allows you to model partnership splits up to three tiers using either equity multiple hurdles or…
, ,

All-in-One (Ai1) Walkthrough #9 - Print Mode and the IRR Matrix Report

This walkthrough, our ninth in the series, touches on the newly added (beta v0.5.3) 'Print Mode' and IRR Matrix Report in our All-in-One (Ai1) model. Print mode further enhances the printability of the model while the IRR Matrix Report adds…
, ,

All-in-One (Ai1) Walkthrough #8 - Tenancy Analysis Report for Office, Retail, and Industrial

This walkthrough, our eight in the series, explains how the Tenancy Analysis report for office, retail, and industrial real estate underwriting works in our All-in-One (Ai1) model. The Tenancy Analysis report includes a tenant rollover schedule,…
sizing a mortgage loan amount
, , ,

How to Use Debt Yield to Calculate Loan Amount

In our glossary of commercial real estate terms, we recently answered the question: what is debt yield? As a follow up to that entry, I thought I’d expand on the concept of debt yield by showing you how lenders use debt yield to come up with…
, ,

Excel Pro Forma for Flipping Houses

Before moving to the principal side of the business, I began my career as a self-described real estate investment specialist, largely working as a land broker but dabbling in other areas including the popular "single-family flip" space. In all…
questions and answers related to the all-in-one model for underwriting real estate investments
,

New Support Forum for the All-in-One (Ai1) Underwriting Model

Since releasing the first beta version of the All-in-One Underwriting Model, we've fielded hundreds of emails related to the model. Inquiries range from questions to feature requests to thank yous. We welcome the chance to interact with our…
, , ,

Excel Tips: Creating Data Tables Part 3: Two Variable Data Tables - How To Display More Than One Return Metric Within a Cell

In the third part of this data table series, I'd like to show you how you can create data tables with multiple return metrics within each cell of the data table as shown in the image below.   The way to do this is actually quite…