A free real estate capital stack calculator in Excel
Two real estate capital stacks built live: a value-add deal with a senior loan and GP and LP equity, and a development stack of construction loan, mezzanine, preferred equity and common equity, with the blended cost and what leverage does to equity.
A $56 million value-add deal is funded by a 65% loan-to-cost senior loan and $19.6 million of equity. The loan covers its debt service 1.49x at stabilisation and the equity comes back 1.79x at exit. In the development stack, everything ahead of common equity costs 8.44% a year.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Real_Estate_Capital_Stack_Calculator.xlsx (22 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This model goes with Private Equity Real Estate, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
5 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.
Value-Add Stack
The $56M value-add stack the chapter sets out, live: $50M purchase, $5M renovation, $1M closing and reserves, a 65% loan-to-cost senior, and $19.6M of equity split between GP co-investment and fund capital.
Development Stack
The four-layer $100M development stack: 65% construction loan, 10% mezzanine at 11%, 5% preferred equity at 9%, 20% common. Includes the blended cost of capital, which is the number the chapter is implicitly arguing about.
Leverage Math
The 70% LTV example the chapter uses to show amplification, worked properly, with the full ladder from 0% to 85% leverage in both directions.
Mezz vs Pref
What the two junior layers actually cost across a range of outcomes, and where each one stops being worth it.
Checks
Every figure the chapter prints, against what this workbook computes.
What the worked case returns
Measure
Value
Value-add: total uses
$56,000,000
Senior loan
$36,400,000
Equity
$19,600,000
DSCR at stabilisation
1.49x
Debt yield at stabilisation
12.31%
Yield on cost
8.00%
Equity multiple at exit
1.79x
Development: total leverage (senior plus mezzanine)
75%
Blended cost of the priority capital
8.44%
Yield on cost needed to cover the priority layers
6.75%
Equity gain on a 10% value rise at 70% LTV
33.3%
At 70% loan to value, a 10% rise in the property's value lifts the equity by 33.3%, and the same fall takes it away. Leverage works both ways, and the junior layers sit closest to the loss.
How to use it on your own case
Enter the purchase price, renovation, loan to cost and loan terms on Value-Add Stack.
Enter the stabilised NOI and exit cap rate and read DSCR, debt yield and the equity multiple.
Build a development stack with construction loan, mezzanine, preferred and common equity and their rates.
Use Leverage Math and Mezz vs Pref to see what each layer costs across outcomes.
Questions people ask about it
What is a capital stack in real estate?
The layers of money that fund a deal, ranked by who is paid first: senior debt, then mezzanine, then preferred equity, then common equity.
What is the difference between mezzanine and preferred equity?
Mezzanine is debt secured on the ownership interests; preferred equity is equity with a priority return. Both sit between the senior loan and common equity, and the file compares their cost.
How does leverage change equity returns?
It amplifies them in both directions. With 70% debt, a 10% change in value is a much larger change in the equity.
Is this template really free?
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Go further
The free workbooks of Private Equity Real Estate go further: the full companion set, blank models and the worked cases of the book.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.