Tag Archive for: Excel Model

, , ,

Real Estate Financial Modeling Accelerator (Updated Nov 2022)

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

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…
Sources and Uses
, , , ,

Construction Draw and Interest Calculation Model (Updated Sep 2022)

I originally uploaded this equity/construction loan draw and interest calculation tool to our library of real estate financial analysis models in 2016. Over the years, I've continued to update it as suggestions, comments, and requests…
, , , ,

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…
a shopping center with robust sales and low occupancy cost
, , , , , , ,

Tenant Sales and Occupancy Cost in Retail Underwriting (UPDATED JUNE 2022)

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

Forecasting After-Tax Cash Flow in Real Estate Analysis (UPDATED MAY 2022)

When modeling real estate investments, industry practice is generally to stop at before-tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and no two properties necessarily have…
, , , ,

Real Estate Development Tracker (UPDATED MAY 2022)

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

Real Estate Debt Module in Excel (Updated May 2022)

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

Physical Occupancy Calculation Model for Real Estate (UPDATED MAY 2022)

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

Single Family Residential Investment Analysis Model (Updated Feb 2022)

Pre-2008, I bought and sold my fair share of single family homes - both for investment purposes (rental or flips) and to live in. In those days, almost everyone was "investing" in residential real estate - hence the market crash. I personally…
, , ,

Refinance Risk Analysis Tool in Excel (Updated Feb 2022)

Generally speaking, equity real estate investors spend their time modeling the upside while their debt partners spend their time modeling the down side. Equity investors generally focus on an investment's internal rate of return, cash-on-cash…
, , ,

Real Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated Jan 2022)

Over the years, this real estate equity waterfall with annual periods and IRR or Equity Multiple hurdles has been one of the most popular models in our library of real estate Excel models. It's been downloaded thousands of times and we've received…
, , ,

Real Estate Equity Waterfall Model – Monthly Periods (Updated Jul 2021)

When I decided to share my real estate equity waterfall model in Excel, I never imagined it would be as popular as it has. The model has been downloaded thousands times and many of you have written to extend your thanks for sharing. It is gratifying…
, , , , , ,

Calculate Residual Land Value in Excel

Here's the scenario. You're a real estate developer. You spot a prime parcel of land that would be perfect for your real estate project. So you approach the owner of the land about selling and she says, "Okay, bring me an offer." How much do…
, , , , ,

Residential Land Development Pro Forma (Updated Apr 2021)

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

Best Practices in Real Estate Financial Modeling (Updated Mar 2021)

Before you use one of our real estate financial models (i.e. Excel templates), or before you set out to build your own real estate analysis tool in Excel, it's important to keep in mind a few real estate financial modeling best practices. This…