University Access

If you have purchased the book “Foundations of Real Estate Financial Modelling” you may access Excel files and companion PDFs at no additional cost.

For the 2nd Edition, click here.

The password to verify purchase is the 5th word of the first sentence of Chapter 2 in your book.

For the 3rd Edition, click here.

The password to verify purchase is the 5th word of the second sentence of Chapter 2 in your book.

If you have purchased the 1st edition, please contact us here.

Companion Excel Files for Book Owners - 2nd Edition

The password to verify 2nd edition purchase is the 5th word of the first sentence of Chapter 2 in your book.

Download “Amortization Table 2nd Edition (Chapter 5)”

Download “Single Family (Chapter 6)”

Download “5-Unit Multi-family (Chapter 7)”

Download “‘N’ Unit Rent Roll (Chapter 8)”

Download “N-unit basic sheet (Chapter 8)”

Download “Excel + Alt Valuation (Chapter 8)”

Download “Development Page (Chapter 9)”

Download “Development Standalone (Chapter 9)”

Download “N-Unit For Sale (Chapter 10)”

Download “For Sale Standalone (Chapter 10)”

Download “Hotel Asset (Chapter 11)”

Download “Accounting Statements (Chapter 12)”

Download “H2O Structure (Chapter 13)”

Download “H2O Bolt-On (Chapter 13)”

Download “Stochastic Modelling (Chapter 14)”

Download “Crystal Ball Sheet (Chapter 14)”

Download “Crystal Ball Add-On 5 Unit (Chapter 14)”

Download “Optimization (Chapter 15)”

Download “Optimization Excel (Chapter 15)”

Companion PDFs for Book Owners - 2nd Edition

Download “Chapter 1 – Descriptive Statistics”

Download “Chapter 1 – Discounted Cash Flow”

Download “Chapter 1 – Risk Return Portfolio”

Download “Chapter 2 – Capital Structure and Leverage”

Download “Chapter 2 – Project Valuation (Options)”

Download “Chapter 4 – Interest Rates”

Download “Chapter 5 – Amortization”

Download “Chapter 6 – Charting”

Download “Chapter 6 – Custom Functions (Bonus)”

Download “Chapter 6 – MSExcel”

Download “Chapter 7 – Residential Construction (Review)”

Download “Chapter 8 – Valuation of Income Properties”

Download “Chapter 9 – Financing Land Development”

Download “Chapter 9 – Financing Project Development”

Download “Chapter 9 – Leasing (during development)”

Download “Chapter 10 – For Sale (Buyer’s perspective)”

Download “Chapter 12 – Financial Statement Analysis”

Download “Chapter 12 – Financial Statement Overview”

Download “Chapter 13 – Waterfall”

Download “Chapter 14 – Crystal Ball”

Download “Chapter 14 – Simulation”

Download “Chapter 15 – OptQuest”

Companion Excel Files for Book Owners - 3rd Edition

The password to verify 3rd edition purchase is the 5th word of the second sentence of Chapter 2 in your book.

Download “Amortization Table for Chapter 4 (Amortization)”

Download “Single Page Model for Chapter 5 (Single-Family Rental)”

Download “Pro Forma Base Model for Chapter 6 (1 – 5 Units)”

Download “Pro Forma Base Model with Recapitalization included for Chapter 6 (1 – 5 Units)”

Download “Single Sheet Rent Roll for Chapter 7”

Download “Single Sheet Rent Roll with Seasonality added for Chapter 7”

Download “Pro Forma Base Model with Recapitalization and Rent Roll with Seasonality for Chapter 7”

Download “Single Sheet ADC (Acquisition, Development, Construction) for Chapter 8”

Download “Pro Forma Base Model with Recapitalization, Rent Roll, and ADC for Chapter 8”

Download “Single Sheet Waterfall (H2O) for Chapter 9”

Download “Pro Forma Base Model with Recapitalization, Rent Roll, ADC and Waterfall (H2O) for Chapter 9”

Download “Single Sheet For Sale for Chapter 10”

Download “Single Sheet Hotel for Chapter 11”

Download “Pro Forma Hotel Model for Chapter 11”