An Excel workbook with rent rolls, comps, cap rates and expense benchmarks — plus ROI, cash-on-cash and IRR calculators with scenario tabs.
Problem, verified data scope, workbook architecture, use cases and licensing — in 60 seconds.
A normalized, comparable schema — with source links and a status stamp. Below is a live excerpt from the data file.
| unit | type | beds | sqft | market rent month | prior rent month | lease end | condition note | official source url |
|---|---|---|---|---|---|---|---|---|
| Unit 101 | 1BR/1BA | 1 | 720 | 1450 | 1380 | 2026-08-31 | Refreshed 2025: floors+p appliances | https://www.hud.gov/program_offices/housing/mfh |
| Unit 102 | 1BR/1BA | 1 | 720 | 1450 | 1450 | 2027-02-28 | Steady occupancy 24 months | https://www.hud.gov/program_offices/housing/mfh |
| Unit 103 | 2BR/1BA | 2 | 950 | 1750 | 1690 | 2026-11-30 | Mid-cycle renewal candidate | https://www.hud.gov/program_offices/housing/mfh |
| Unit 104 | 2BR/1BA | 2 | 950 | 1800 | 1720 | 2027-04-30 | Post-renovation premium | https://www.hud.gov/program_offices/housing/mfh |
| Unit 105 | 2BR/2BA | 2 | 1080 | 1950 | 1860 | 2026-12-31 | Corner unit; balcony | https://www.hud.gov/program_offices/housing/mfh |
| Unit 201 | 1BR/1BA | 1 | 760 | 1500 | 1420 | 2027-01-31 | Quiet side; new HVAC | https://www.hud.gov/program_offices/housing/mfh |
| Unit 202 | 2BR/1BA | 2 | 980 | 1780 | 1780 | 2026-09-30 | Renewal offer prepared | https://www.hud.gov/program_offices/housing/mfh |
| Unit 203 | 2BR/2BA | 2 | 1100 | 1990 | 1900 | 2027-03-31 | Highest-floor premium | https://www.hud.gov/program_offices/housing/mfh |
From data to decision — every step is wired into the workbook.
Unit-level rents, terms and conditions.
Comps, cap rates and NOI build-up.
Multi-year projection with sensitivity.
Expense and operating benchmarks.
Editable model drivers.
Every figure is compiled from official public sources, normalized into a single comparable schema, and each row carries the official URL to re-verify before you commit.
Get the Package — $29 →