Posts

vintage Walgreens on corner of two busy california streets
, , , , , , , , ,

Single Tenant NNN Lease Valuation Model (Updated 9.18.2018)

I originally built this single tenant net lease (NNN) valuation Excel model back in 2016. Based on some feedback from a few of our readers, I've since made a few updates. This model is an attempt to re-think how the industry underwrites single-tenant…
, , , , , ,

Real Estate Acquisitions Model - 2.0

I've decided to do a major overhaul of my last acquisitions model for office, industrial, and retail properties. There were a lot of things I wanted to change as well as add to the model and finally had a weekend to do it. This new and improved…
, , , ,

3-Tiered Acquisition Debt Module

This is a debt module that will allow the user to add one to three tiers of debt to his or her DCF model. This excel file should be fairly intuitive and easy to understand and the entire model is on one sheet. Download it from the link below…
,

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

Multifamily (Apartment) Acquisition Model in Excel

We haven't uploaded an apartment acquisition model to our Excel library of real estate models yet, and I didn't have anything worth sharing in my personal library that wasn't proprietary. So I thought I'd alter the real estate valuation model…
, , , , , ,

Acquisition Model for Office, Retail, Industrial Properties

I've been meaning for a while to create a simple real estate acquisition model in Excel for office, retail, and industrial deals. With the kids busy eating Halloween candy this weekend, and the wife occupied handing out goodies to trick-or-treaters,…
, ,

Update to Portfolio Acquisition Model

I've updated my Portfolio Acquisition Model to include the following changes: - Added an "Investor Level Returns" tab to the model, which uses my Real Estate Equity Waterfall Model to calculate the equity returns of the sponsor (GP) and the…
, , , ,

Real Estate Portfolio Acquisition Excel Model

I built, and would like to share, a real estate portfolio model for valuing a portfolio of up to 30 properties. This is a "roll-up" model, meaning you will need to model your property-level cash flows before financing in ARGUS or a separate…