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