Monthly cash flow
$150
Cash-on-cash return
2%
Cap rate
6%
Rental Property Deal Analyzer
Cash flow, cap rate, cash-on-cash, DSCR and a 10-year projection for any rental purchase.
5 free real estate investment property templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 5 spreadsheets from Property Investment. Start with Rental Property Deal Analyzer, Rental Property Portfolio Tracker and Capital Expenditure Reserve Planner: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Monthly cash flow
$150
Cash-on-cash return
2%
Cap rate
6%
Cash flow, cap rate, cash-on-cash, DSCR and a 10-year projection for any rental purchase.
Portfolio value
$1,380,000
Total equity
$471,000
Monthly cash flow
$2,440
Value, debt, equity, cash flow, cap rate and cash-on-cash return for every property you own.
Monthly reserve needed
$413
Due within 5 years
$32,200
Should already be saved
$48,386
Roofs, boilers and appliances wear out on schedule. Work out how much to set aside each month.
Total budget
$35,050
Spent so far
$16,180
Paid
$13,330
Plan renovation costs by room with quotes, actuals, contingency and payment status.
Deals analysed
4
Meeting the 70% rule
2
Best profit
$69,850
Test a renovation deal: all-in cost, profit, return on investment and the most you should offer.