Looking for Underwriting Template or Pro Forma for Multifamily or SFR Deals

[Matt Powers]

Hi BP Community,

I’m currently working on analyzing a few potential investment opportunities and I’m looking for a solid underwriting template or pro forma model—ideally something built in Excel—for either multifamily or single-family rentals (SFRs).

I'd love a model that includes standard inputs like rent, expenses, vacancy, debt service, and ideally also IRR, cash-on-cash, and cap rate outputs. Bonus points if it includes sensitivity analysis or value-add projections.

If anyone is willing to share a template they've found useful or point me toward a reliable resource (free or paid), I’d really appreciate it.

Thanks in advance for your help!

[Vessi Kapoulian]

A great one to get started with is the Syndicated Deal Analyzer by Michael Blank.