Financial Modeling Dashboard
AA
Courses Enrolled
4
2 in progress, 0 completed
Hours Completed
42
of 120 total -- 35%
Models Built
6
3 DCF, 2 RE Pro Forma, 1 Comps
Real Estate Financial Modeling
45% complete
✓
Module 1: RE Finance Fundamentals
6 lessons -- 2.5 hours -- NOI, Cap Rate, GRM
Review
✓
Module 2: Building a Pro Forma from Scratch
8 lessons -- 4 hours -- Excel model walkthrough
Review
✓
Module 3: Rent Roll Analysis & Revenue Modeling
6 lessons -- 3 hours -- Unit mix, vacancy, escalations
Review
4
Module 4: Operating Expense Modeling
5 lessons -- 2.5 hours -- OpEx, management fees, CapEx
Continue
5
Module 5: Debt Sizing & Mortgage Analysis
7 lessons -- 3.5 hours -- LTV, DSCR, amortization
Start
6
Module 6: Cash Flow Waterfall & Equity Returns
6 lessons -- 3 hours -- IRR, equity multiple, promotes
Start
7
Module 7: Sensitivity & Scenario Analysis
4 lessons -- 2 hours -- Data tables, tornado charts
Start
8
Module 8: Case Study -- Minneapolis Multifamily
Capstone -- 4 hours -- Full model build from raw data
Capstone
Active Model: Minneapolis Multifamily Pro Forma
Open in Excel
BlackRoad_RE_ProForma_v3.xlsx Last saved 2h ago
Summary
Rent Roll
OpEx
Debt
Returns
Year 1
Year 2
Year 3
Year 4
Year 5
Gross Rent
$748,800
$771,264
$794,402
$818,234
$842,781
Vacancy (5%)
($37,440)
($38,563)
($39,720)
($40,912)
($42,139)
Eff. Gross Income
$711,360
$732,701
$754,682
$777,322
$800,642
Operating Expenses
($284,544)
($293,080)
($301,873)
($310,929)
($320,257)
NOI
$426,816
$439,621
$452,809
$466,393
$480,385
Debt Service
($312,000)
($312,000)
($312,000)
($312,000)
($312,000)
Cash Flow
$114,816
$127,621
$140,809
$154,393
$168,385
Purchase Price
$6,240,000
Going-in Cap
6.84%
Cash-on-Cash Y1
7.36%
5-Year IRR
14.2%
Certificates
View All
📄
Financial Modeling Fundamentals
Earned Mar 28, 2026 -- Credential #WSP-FM-2026-4821
Earned
📄
Excel for Finance Bootcamp
Earned Feb 12, 2026 -- Credential #WSP-EX-2026-3102
Earned
📄
Real Estate Financial Modeling
45% complete -- Est. completion May 2026
In Progress
📄
Valuation & DCF Modeling
28% complete
In Progress
📄
LBO Modeling
Not started
Locked
Case Studies
View All 24
Minneapolis Multifamily Acquisition
42-unit apartment -- $6.24M -- Value-add strategy
Office-to-Residential Conversion
Downtown MPLS -- $18M -- Adaptive reuse model
SaaS Company DCF Valuation
BlackRoad OS -- 5-year model -- Revenue multiple analysis
Leveraged Buyout -- Tech Services
$120M LBO -- Debt structure & exit analysis
Interview Prep
All Questions
"Walk me through a DCF."
Investment Banking -- Technical -- Difficulty: Medium
"How do you value a real estate asset?"
Real Estate PE -- Technical -- Difficulty: Hard
"What's the difference between IRR and MOIC?"
Private Equity -- Technical -- Difficulty: Medium