Taylor and Francis Group is part of the Academic Publishing Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 3099067.


Foundations of Real Estate Financial Modelling

1st Edition

Welcome to the companion website for Foundations of Real Estate Financial Modelling.  Here you will find the solution pro forma models for which each chapter is based.  It is highly recommended that readers complete each pro forma individually prior to downloading the completed models.  This will ensure a stronger understanding of the structure or each model.

The chapters are structured to take the reader step-by-step through each model.  The final products are provided here, on the companion website.  After completing the model it is recommended that the readers model simple deals and “break” the models to best understand the mechanics, theory and results.  Please understand that these models cannot truly be “broken” as the base template will be housed here for repeated download, if required.

Enjoy the text and feel free to email me with questions, comments and suggestions. 

Foundations of Real Estate Financial Modelling is specifically designed to provide an overview of pro forma modelling for real estate projects. The book introduces students and professionals to the basics of real estate finance theory before providing a step-by-step guide for financial model construction using Excel. The idea that real estate is an asset with unique characteristics which can be transformed, both physically and financially, forms the basis of discussion.

Individual chapters are separated by functional unit and build upon themselves to include information on:

  • Amortization
  • Single-Family Unit
  • Multi-Family Unit
  • Development/Construction Addition(s)
  • Waterfall (Equity Bifurcation)
  • Accounting Statements
  • Additional Asset Classes

Further chapters are dedicated to risk quantification and include scenario, stochastic and Monte Carlo simulations, waterfalls and securitized products. This book is the ideal companion to core real estate finance textbooks and will boost students Excel modelling skills before they enter the workplace. The book provides individuals with a step-by-step instruction on how to construct a real estate financial model that is both scalable and modular.

A companion website provides the pro forma models to give readers a basic financial model for each asset class as well as methods to quantify performance and understand how and why each model is constructed and the best practices for repositioning these assets.

Roger Staiger (FRICS) is Managing Director for Stage Capital, LLC, a global advisory firm in real estate financial modelling, portfolio management and asset repositioning. He holds faculty positions in the real estate departments at Georgetown and Johns Hopkins University. Roger also holds a faculty position at George Washington University in the MS Finance programme. Professionally, he has held many senior positions including Managing Director for Constellation Energy’s Retail Commodity Division and CFO for America’s Best Builder 2006. Academically Roger has earned a degree in BS Electrical Engineering, MBA Investments, MA International Transactions and MS Finance.