Does It Pencil? ADU Deal Analyzer
This is the spreadsheet I use to figure out if an ADU deal makes money before anyone spends a dollar on design.
Plug in your build cost, fees, rents and financing, and it tells you your total project cost, NOI, yield on cost, the equity you created, cash-on-cash return and DSCR. Then it gives you a verdict: pencils, tight, or doesn't pencil.
Compare up to 3 scenarios side by side (garage conversion, detached ADU, multifamily add-on), and use the sensitivity tab to see what happens if rents come in lower or the build runs over.
What's inside:
- Deal Analyzer with 3 side-by-side scenarios
- Sensitivity grid (rent vs. cost)
- Instructions and the 4 numbers I look at first
- Works in Excel and Google Sheets
For educational purposes only. Not financial, tax, legal or investment advice.