For one reason or another, there is a perfectly functioning and pretty valuable formula that can be utilized in Excel that Microsoft has chosen to exclude from Excel’s list of functions: the DateDif function. This function is a valuable tool that can instantly calculate the number of days, months, or years between two dates. While in […]
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 hotel development model is basically a hybrid of our Hotel Acquisition […]
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 model includes both monthly and annual cash flows, […]
This is an Excel model I originally built from scratch back in 2015 for quickly assessing multifamily redevelopment opportunities. It was designed to work best for scenarios where individual units will be rehabbed over the hold at varying times. It’s a simple way to quickly analyze the viability of this type of multifamily investment. Since […]
This post was inspired by a recent question on our real estate financial modeling Accelerator forum. Additionally, Spencer and I frequently get emails asking about this very issue, which is ‘why the IRR (internal rate of return) and XIRR (extended internal rate of return) functions provide different results on the same cash flow’. Both functions […]
In this post, I’m going to go over Index Match Match, which is a very useful Excel formula that is used in both the Hotel Valuation Model and the Hotel Acquisition Model – The Basic Model. This formula allows you to hone in on a specific target cell and return its value when two criteria […]
In this post, I walk you through the A.CRE Mixed Use Development Model for Condo and Retail projects. The model is basically a reworked and expanded version of the Condo Development Model, so if you are familiar with that, this should feel and operate very similarly. This model can also be used as a condo […]
Below is an overview of how LIHTC (low income housing tax credits) are calculated and applied to affordable housing projects. At the bottom of the post you will find downloadable excel files that correspond with the videos. LIHTC – An Overview LIHTC s are federal tax incentives given to the states who then award developers […]
This is a dynamic amortization schedule for debt that gives the user the capability to model a loan with an interest only period up front and an amortizing floating rate debt repayment period once the interest only period is over. This module also allows the user to model other more straightforward scenarios such as an […]
This is a 3 part mini-series on using data tables in Excel to perform real estate sensitivity analysis. In this series, I’ll walk you through how to build both one-variable and two-variable data tables in parts 1 and 2. And in Part 3, I’ll walk you through how to no longer limit your two-variable sensitivity […]
In the following video, I record my screen and narrative my steps as I build a basic construction draw schedule. I’ve also included the template and completed worksheets from this Watch Me Build exercise. Basic Construction Financing & Draw schedules: A Conceptual Overview A standard draw schedule with a basic capital stack of debt and […]
Spencer and I are excited to introduce the A.CRE Undergraduate Real Estate Series. Much like our series on top MBA in Real Estate and Masters in Real Estate programs, this series on Real Estate Undergraduate programs will provide our readers with a glimpse into not only what these programs have to offer, but insights from current or […]
While building out my hotel development model (currently underway), I decided to take a break and record a video about how I roll up the monthly cash flow line items on my Monthly Cash Flow sheet into annual cash flow line items on a separate sheet using only a single formula and simply copying and […]
After posting the construction draw module that demonstrates how to calculate the true LTC of a development loan, I decided that since we have yet to publish a condo development model, to build upon that module to create one. This condominium model has a lot of really great functionality that will allow the user to get a […]
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 proforma has turned out, there are many instances where that model may […]