← Back to all courses
Tier 2 — Financial Analysis·Course 05·CIRE Level 1 — Financial Analysis
Building CRE Pro Formas in Excel
Model any CRE deal from a blank spreadsheet
A hands-on Excel workshop. You'll build a complete institutional-quality pro forma from scratch: rent roll, expense growth assumptions, debt service, levered and unlevered returns, sensitivity tables, and tornado charts. Downloadable template included.
⏱180 minutes
📚7 lessons
$Free forever
What you'll learn
- Structure a CRE pro forma with inputs, calcs, and outputs cleanly separated
- Model rent growth, vacancy, expense inflation, and reversion value
- Build a monthly loan amortization schedule and compute debt service coverage
- Create sensitivity tables on cap rate, rent growth, and loan terms
- Download and use the MaxLife pro forma template on your own deals
Lessons
🚧
Full lesson content is coming soon
We've published the course outline and learning outcomes above. The full lessons are on the writing roadmap — sign up free to get notified when they launch.
Get notified →Up next
Market & Submarket Analysis
How to pick the right MSA, the right submarket, and the right corner