, , ,

Real Estate Financial Modeling Accelerator (Updated March 2024)

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

Hotel Development Model (Updated February 2024)

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

Actual + Forecast Construction Draw Schedule with S-Curve (Updated Dec 2023)

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

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

Development Draw Schedule – Visually Customize Each Line Item (UPDATED APR 2022)

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

Case Study #5 – The Jefferson Branded Condo Development (Case Only)

This is the fifth in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice to master real estate financial modeling. The Jefferson Branded Condo Development puts you in the position…
, , , ,

Hotel Acquisition Model – The Basic Model (Updated 10.9.2019)

The initial goal for the original Hotel Acquisition Model was to design a hotel proforma that would enable users to get deep into the weeds of practically every line item in their hotel analysis. Although I am super happy with how that hotel…
, , , , ,

Tutorials For The Hotel Valuation Model (Updated 07.23.19)

Welcome to the A.CRE Hotel Valuation Model's Tutorial Page. On this page you will find all the tutorials for the A.CRE Hotel Valuation model in Excel. There is a lot to learn within this model and over time, I'd like to show you both how to…
, , ,

Hotel Proforma Basics – Hotel Cash Flow Projection

Hotels are a unique asset in the commercial real estate world and are underwritten differently as a result. Probably the most obvious difference is the duration of the 'lease term' of the tenant, which is usually daily to weekly. Another major…
, , , ,

Hotel Value-Add Assignment Example

I built this multi-scenario , value-add hotel investment model from scratch in Excel for an assignment in one of my real estate finance courses at Cornell. Keep in mind, this model is not plug-and-chug ready. However, with a few tweaks it works…