BTL year-by-year cash flow with IRAS property tax (AV-based), HOA fees, sinking fund, 22% rental income tax. No CGT on resale.
| Yr | Gross rent | HOA+Sink | Prop tax | Mortgage | Income tax | Net cash | Cum cash | Value |
|---|---|---|---|---|---|---|---|---|
| 1 | $66,000 | $6,000 | $4,800 | $80,828 | $11,563 | $-39,831 | $-539,831 | $2.06M |
| 2 | $67,320 | $6,000 | $4,800 | $80,828 | $11,842 | $-38,843 | $-578,674 | $2.12M |
| 3 | $68,666 | $6,000 | $4,800 | $80,828 | $12,126 | $-37,835 | $-616,509 | $2.19M |
| 4 | $70,040 | $6,000 | $4,800 | $80,828 | $12,416 | $-36,806 | $-653,315 | $2.25M |
| 5 | $71,441 | $6,000 | $4,800 | $80,828 | $12,712 | $-35,757 | $-689,072 | $2.32M |
| 6 | $72,869 | $6,000 | $4,800 | $80,828 | $13,014 | $-34,687 | $-723,760 | $2.39M |
| 7 | $74,327 | $6,000 | $4,800 | $80,828 | $13,322 | $-33,596 | $-757,356 | $2.46M |
| 8 | $75,813 | $6,000 | $4,800 | $80,828 | $13,636 | $-32,483 | $-789,839 | $2.53M |
| 9 | $77,330 | $6,000 | $4,800 | $80,828 | $13,956 | $-31,348 | $-821,187 | $2.61M |
| 10 | $78,876 | $6,000 | $4,800 | $80,828 | $14,283 | $-30,190 | $-851,376 | $2.69M |