Posts

, , ,

Real Estate Financial Modeling Accelerator (Updated June 2021)

Since starting A.CRE, Michael and I have 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 topics in our blog,…
, , , , ,

Multifamily Redevelopment Model (Updated June 2020)

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

Watch Me Build a Tenant Rollover Analysis Model

The feedback has been positive on the ‘Watch Me Build a Multifamily Model’ video I recorded earlier this year. So I thought I’d follow that up with another. This time I build a Real Estate Tenant Rollover Analysis Model and talk through…
, , , , , , , ,

Watch Me Build a Multifamily Real Estate Model (Updated Feb 2020)

One way to become a better real estate financial modeling professional, is to watch other professionals model. I know in my career being able to physically see how others tackle different modeling problems has shaped my methods and made me better…
, , , ,

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

3-Tiered Acquisition Debt Module

This is a 3-tiered debt module that will allow the user to add one to three tiers of debt to his or her real estate DCF model. Includes the option to layer in senior debt, secondary debt, and mezzanine debt; calculate interest on either…
real estate modeling
, , ,

Learning Real Estate Financial Modeling in Excel

We're often asked by our readers how we learned to be proficient in real estate financial modeling. The question usually arises because the person wants to know how to model real estate in Excel to either land a job in commercial real estate…
, , , , , ,

Back-of-the-Envelope Office, Retail, Industrial Acquisition Model (Updated 10.1.2018)

I’ve built a new acquisition model that I am excited to share with our readers. This is a back-of-the-envelope (BOE) valuation model that can be used for retail, office, and industrial properties. The goal was to create a sleek and clean look…
, , ,

A.CRE User Insights Survey

We need your help! As Adventures in CRE (A.CRE) has grown and evolved over the years, so have the needs of our readers. The challenge for Michael and I as we contemplate what new content to create, is knowing what resources will be most beneficial…
a shopping center with robust sales and low occupancy cost
, , , , , , ,

Tenant Sales and Occupancy Cost in Retail Underwriting

When underwriting a retail investment, rollover risk is an incredibly important consideration. You, as a prospective debt or equity investor in the property, need to understand how secure the cash flows you're buying are; or in other words,…
, , , ,

Real Estate Development Tracker

One of the many challenges of both analyzing real estate development deals and managing development projects is understanding and tracking the numerous differing but intertwining work streams. The more a development team takes the time…
a gantt chart for real estate built in Excel
,

Bonus Content – Gantt Chart and Weighted Average with Multiple Conditions

I have two updates/improvements to previous posts I thought I'd share with our readers today; call it, bonus content! The first, is a dynamic Gantt Chart tool I recently added to my Construction Draw and Interest Calculation Model. The second,…
, , , , , , ,

Physical Occupancy Calculation Model for Real Estate

As many of you know, I'm in the midst of moving my family from Milwaukee to Dallas, and quite frankly I'm getting sick of eating out and sleeping in hotel rooms. So what better way to unwind from hours of whining kids and tiresome travel, than…
, , ,

Waterfall Model For Real Estate Joint Ventures with Catch Up

I've just wrapped up a new JV waterfall model with catch up clause that I am excited to share on the site. This model was built as an addition to my back-of-the envelope retail/industrial/office acquisitions model I posted a few weeks back.…
, , , ,

Real Estate Debt Module in Excel

I thought I'd share the real estate debt module I built for the ARGUS alternative in Excel that I've been working on over the last few months. Most debt modules I've seen in real estate financial models only include the ability to model…
equity multiple
, , ,

Real Estate Waterfall Model – Equity Multiple Hurdles

I've created a companion to my real estate equity waterfall model to work with equity multiple hurdles, rather than IRR hurdles. It took me longer than I expected to build this, largely because I was over thinking it. I messed around with…