1. Home
  2. Additional Resources

Additional Resources

Glossaries

Download all files
Brief Glossary of CRE Terms
DOC CRE Glossary Adapted from Blacks Guide
PDF Naiop-2024-terms-and-definitions
PDF

Click to download files.

Spreadsheets

DCF

How to use the DCF proforma

DCF Downloable Files

Download all files
Apartment Proforma by Malpezzi
XLSM DCF-Proforma and NPV 10 year proforma
XLS Proforma (7Yr)
XLSX

Click to download files.

Development

Development Downloable Files

Download all files
Development Building Envelope Worksheet Chapter 24
XLS Front Door Back Door by Malpezzi
XLS Land Development Assignment with Waterfalls by Miller
XLS Land Development Costs and Proforma by Jared Rodio
XLSM Land Residual Value Assignment and Analysis by Miller
XLSX

Click to download files.

Four Quandrant Model

Four Quandrant Model Downloable Files

4Q model numerical example
XLS

Click to download files.

Lease Analysis

Lease Analysis Downloable Files

Download all files
Buy Vs Lease Analysis
XLS Effective Lease Rate Rent Calculations with Various Terms
XLSX Lease by Lease Simulation up to 10 spaces for use with Chap
XLS

Click to download files.

Miscellaneous

Miscellaneous Downloable Files

Download all files
Conversion of rent to minimum affordable home or condo p(2)
XLS Derivative Pricing Model
XLSX Due Dilligence Checklist sample
XLSX NPV IRR EXCEL INTRO by Clayton
XLS

Click to download files.

Mortgage and Financing

Mortgage and Financing Downloable Files

Download all files
Construction loan example
XLSX Extra Mortgage Problems and Answers
DOC Mortgage-Calculation-and-Amortization (3)
XLS Mortgage Math notes
XLS

Click to download files.

Option Analysis

Option Analysis Downloable Files

Derivative Pricing Model and Options
XLSX

Click to download files.

Portfolio Analysis

Dr. Geltner on the PortfOptimizer ExcelDemo(MITcopyright)

Portfolio Analysis Downloable Files

Download all files
Geltner-et al Portfolio Optimizer Templates
XLS Global Port Management Exercise
XLS PORTFOLIO-Calculations Example
XLS Simple Portfolio Illustration Where Target Return Changes
XLS

Click to download files.

Valuation and Cap Rates

Valuation and Cap Rates Downloable Files

Download all files
4-Band-Mortgage-Equity-Capitalization-or-Atkerson-format-Ellwood-20151 (1)
XLSX Cap Rate Valuation Spread Model
XLSM

Click to download files.

Waterfall Partner Analysis

Waterfall Partner Analysis Downloable Files

Download all files
Waterfall Model by Jared Rodio
XLSX Waterfall Template three levels
XLSX

Click to download files.

Data and Data Links

Download all files
2412 RCACPPI US
XLSX 2505 RCACPPI US
PDF Real Estate Org and Data Links
XLSX

Click to download files.

Career Advice

Download all files
Blurred Lines Disruptions and the Future of Real Estate
PPTX Short Version of Blurred Lines%5EJ Disruptions and the Future of Real Estate in 15 minute summary
PPTX Tips-on-professional-presenting MSRE Class
PPT

Click to download files.

Video links