Personal finance template
Rental Property Calculator Template
Check if a rental property pays off. Monthly cash flow, yearly yield and cash-on-cash return update as you edit.
Opening a template uses no credits.
What's inside
| Row | A | B |
|---|---|---|
| 1 | Input | Value |
| 2 | Purchase price | 3,000,000 |
| 3 | Down payment | 600,000 |
| 4 | Monthly rent | 16,000 |
| 5 | Mortgage payment | 9,500 |
| 6 | Other monthly costs | 2,500 |
| 7 | Monthly cash flow | =B4-B5-B6 |
| 8 | Gross yield | =B4*12/B2 |
| 9 | Cash-on-cash return | =B7*12/B3 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B7 =B4-B5-B6
Rent minus mortgage and other costs.
B8 =B4*12/B2
Yearly rent as a share of the price.
B9 =B7*12/B3
Yearly cash flow as a return on your own money.
Make it yours by asking
Try a request like this in Tabstra:
"Create a rental property calculator with price, down payment, rent, mortgage payment, costs, monthly cash flow, gross yield and cash on cash return"