Foundations of Real Estate Financial Modelling: 2nd Edition (Paperback) book cover

Foundations of Real Estate Financial Modelling

2nd Edition

By Roger Staiger


542 pages

Purchasing Options:$ = USD
Paperback: 9781138046184
pub: 2018-05-11
SAVE ~$16.39
Hardback: 9781138046139
pub: 2018-05-15
SAVE ~$36.00
eBook (VitalSource) : 9781315171524
pub: 2018-05-11
from $40.98

FREE Standard Shipping!


Foundations of Real Estate Financial Modelling, Second Edition is specifically designed to provide the scalable basis of pro forma modelling for real estate projects. The book introduces students and professionals to the basics of real estate finance theory prior to providing a step-by-step guide for financial real estate model construction using Excel. The book introduces an innovative new financial metric, P(Gain), which quantifies the probability of a Return of Capital and answers the most basic question for investing, "What is the probability I get my money back?". 

This new second edition has been fully revised and expanded. The book is separated into three functional units: (1) Real Estate Valuation Basics, Theory and Skills, (2) Real Estate Pro Forma Modelling, (3) Real Estate Pro Forma (Enhancements). New and enhanced Chapters cover: 

  • Interest rates
  • Amortization
  • Single- and multi-family unit
  • Development module
  • Rent roll module
  • Waterfall (equity bifurcation)
  • Hotel, retail/office and townhouse.  

In addition, this new edition includes problem sets and solutions at the end of each chapter as well as case studies underpinning the chapter topics. Further chapters are dedicated to risk quantification and include scenario, stochastic and Monte Carlo simulations, equity waterfalls, and adding U.S. GAAP financial statements to existing real estate pro forma models.

This book is the ideal textbook for a Real Estate Finance class, providing the theoretical basis of real estate finance as well as valuable modelling skills for the workplace. This book provides individuals with a step-by-step instruction on how to construct a real estate financial model starting with a new spreadsheet. The resultant model is portable, scalable, and modular. A companion website provides the pro forma models to readers as a reference for their own constructed models.

Companion web material available at:

Table of Contents

PART 1 Real estate valuation basics, theory, and skills

1. Real estate basics

2. Asset valuation defined

3. Real estate characteristics defined

4. Interest rates

5. Amortization

PART 2 Real estate pro forma modelling

6. Single-family rental (single page)

7. 5-unit multifamily

8. "N"-unit rent roll

9. Development page

10. N-unit for sale

11. Hotel

PART 3 Real estate pro forma (enhancements)

12. Accounting statement(s)

13. Waterfall

14. Schochastic modelling (Crystal Ball)

15. Organization (OptQuest)

About the Author

Roger Staiger is an investor, author, and philanthropist. He is the owner of P(Gain), LLC, an international real estate investment and advisory firm that develops, owns and manages real estate and operating businesses in the Washington DC metropolitan area and the Caribbean. On a limited basis, P(Gain) advises clients in areas of global portfolio management, real estate financial modelling, and asset repositioning.

The P(Gain) Foundation provides University scholarships for Nevisian graduating seniors. Further, through the Roger P. Staiger Faculty Development Fund, Mr. Staiger personally provides grants for academic research studies.

Mr. Staiger has worked in a number of industries at senior levels. He was Managing Director for a Fortune 500 Energy Company’s commodity division, CFO for America’s Best Mid-Sized Builder 2006, and a Senior Portfolio Manager for a large commingled pension fund in New York.

Mr. Staiger has earned multiple degrees including BS Electrical Engineering, MBA Investments, MA International Transactions and a MS Finance. He holds or has held university faculty positions in the real estate departments at Georgetown University (Outstanding Faculty Award, 2011), Johns Hopkins University, and University of Maryland in the United States. Mr. Staiger also holds a faculty position in the MS Finance Programme and Finance Department at The George Washington University.

Mr. Staiger provides numerous capital markets and economic presentations to organizations internationally. He also appears regularly on television and is often quoted in national periodicals. Mr. Staiger is recognized globally as an expert in Financial Modelling, often providing presentations on Best Practices for Real Estate modelling.

Mr. Staiger resides in the Washington DC area and Nevis.

Subject Categories

BISAC Subject Codes/Headings:
BUSINESS & ECONOMICS / Corporate Finance
BUSINESS & ECONOMICS / Corporate Finance / Private Equity
BUSINESS & ECONOMICS / Finance / Financial Risk Management
BUSINESS & ECONOMICS / Finance / Wealth Management
BUSINESS & ECONOMICS / Investments & Securities / Real Estate
BUSINESS & ECONOMICS / Investments & Securities / Portfolio Management
BUSINESS & ECONOMICS / Personal Finance / Investing
BUSINESS & ECONOMICS / Real Estate / Commercial
BUSINESS & ECONOMICS / Business Mathematics
TECHNOLOGY & ENGINEERING / Construction / General