, , ,

Real Estate Financial Modeling Accelerator (Updated Jan 2023)

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

A.CRE Apartment Development Model (Updated Jan 2023)

For several years now, our library of real estate models has been lacking a robust ground-up apartment development model. Sure, our All-in-One (Ai1) model has the capability to model multifamily development deals, but it's more a generalist…
, , , , ,

A.CRE Value-Add Apartment Acquisition Model (Updated Jan 2023)

We've shared a handful of apartment models over the years. Several of those are capable of analyzing apartment acquisitions (e.g. All-in-One, Apartment Valuation Model), but none was built for the express purpose of modeling value-add apartment…
, , , ,

Office Real Estate Development Model (Updated Jan 2023)

I'm excited to share my Office Development Model in Excel. This pro forma analysis tool comes as I've continued to build and share specialty real estate models, tailor-made for specific investment scenarios and property types. This model…
, , , ,

Retail Real Estate Development Model (Updated Dec 2022)

I'm excited to share my Retail Development Model in Excel. This pro forma analysis tool comes as I've continued to build and share specialty real estate models, tailor-made for specific investment scenarios and property types. This model…
, , , ,

A.CRE Self Storage Development Model (Updated Dec 2022)

We've received numerous requests over the years for a Self Storage Development Model in Excel. With strong investment and development activity in this niche property type, I recognize a self storage model on A.CRE is long overdue. But with so…
, , , , ,

Residential Land Development Pro Forma (Updated Dec 2022)

As many of you know, I started my career in residential land development first as a broker and later as a principal. During that time I built my fair share of residential land development Excel pro formas, modeling returns and forecasting cash…
, , , , , , , , , , , ,

All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated Nov 2022)

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

Student Housing Acquisition Model

I've spent a fair amount of my career analyzing privately-owned student housing investments. Nevertheless, I've yet to share a purpose-built, institutional-quality student housing acquisition model. So, I thought I'd take some time and build…
, , , ,

Hotel Development Model (Updated November 2022)

Excited to share the new A.CRE Hotel Development Model with everyone. As evidenced by the numerous requests we have gotten for this over the years, this model is long overdue so I'm quite happy to get it out there finally. At the core, the…
, , , ,

Industrial Real Estate Development Model (Updated Oct 2022)

Allow me to share my Industrial Development Model in Excel. Over the past year, I've been working to add more specialty real estate models to our library. While our All-in-One model certainly has its place, oftentimes really digging into the…
, , , ,

Loan Payment Schedule and Balance Tracking Tool (Updated Oct 2022)

A childhood friend called me this week and asked for a favor. He is the lender on a private real estate loan and was wanting a way to personally service the loan. Namely, he needed a tool to issue monthly invoices, track the principal vs interest…
, , , ,

Commercial Real Estate Lease Analysis Tool

The topic of analyzing commercial real estate leases from the perspective of the landlord and/or tenant has come up several times over the years. And while I generally respond to requests for new models or tools at A.CRE, I've been hesitant…
, , , , , ,

A.CRE Hotel Valuation Model in Excel (Updated Sept 2022)

I am excited to introduce our new Hotel Valuation (Acquisition) Model to underwrite both stabilized and value-add hotel opportunities. This hotel pro forma is designed to allow users to do everything from a quick back of the envelope exercise…
, , , ,

Real Estate Portfolio Valuation Model (Updated Aug 2022)

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 unlevered (before financing) property-level cash flows in a separate…
, , , ,

Self Storage Acquisition Model (Updated Aug 2022)

I've spent the past few weekends working on a purpose-built Self Storage Acquisition Model, and I'm now happy to share the result of that work with you. This is a model that's been requested by quite a few A.CRE readers over the past few years.…