Real Estate Financial Modeling

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

publish or post a commercial real estate job including acquisitions, development, asset management to the acre job board

, ,

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

All-in-One (Ai1) Underwriting Model for Real Estate Development and Acquisition (Updated 8.12.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…
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…
, ,

Excel Tips: Creating Data Tables Part 2: Two Variable Data Tables For CRE Underwriting

Back when we first started this website, I wrote a post with a downloadable excel file that walks the reader through how to create a one variable data table. This is a long overdue follow up to that post to show you how to create a two-variable…
, ,

All-in-One (Ai1) Walkthrough #7 - Ground Lease Valuation Module

This walkthrough, our seventh in the series, explains how the Ground Lease Valuation Module works and how to implement this tool into your analysis. The All-in-One Model includes two methods to account for a ground lease. The first is to simply…
Excel for Real Estate Certification
, , , , ,

Why I'm REFM Excel for Real Estate Certified

In the unlikely event you've visited my LinkedIn page lately or happened upon Bruce Kirsch's list of REFM Certification Holders, you might have noticed that over the last year I've completed my REFM Excel for Real Estate certification. In…