| Month # | Remaining loan | Monthly payment | (T) Tax benefits on P.Tax and Interest |
Actual mortgage after tax benefits | (R) Rent savings | (IR) Return from Down payment invst | Net (M-T-R + IR) | Savings if rented | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| (%) | Amount | (A) Principal | (B) Interest | (C) Property tax | (D) PMI | (M) Total A+B+C+D | |||||||
| 0 | 90.00 | 450,000 | 626 | 1,575 | 1,167 | 188 | 3,555 | -685 | 2,870 | -2,500 | 333 | 703 | 703 |
| 1 | 89.87 | 449,374 | 628 | 1,573 | 1,167 | 187 | 3,554 | -684 | 2,870 | -2,502 | 333 | 702 | 1,410 |
| 2 | 89.75 | 448,747 | 630 | 1,571 | 1,167 | 187 | 3,554 | -684 | 2,870 | -2,504 | 333 | 700 | 2,119 |
| 3 | 89.62 | 448,117 | 632 | 1,568 | 1,167 | 187 | 3,554 | -683 | 2,871 | -2,506 | 333 | 698 | 2,831 |
| 4 | 89.50 | 447,485 | 634 | 1,566 | 1,167 | 186 | 3,554 | -683 | 2,871 | -2,508 | 333 | 696 | 3,546 |
| 5 | 89.37 | 446,850 | 637 | 1,564 | 1,167 | 186 | 3,553 | -682 | 2,871 | -2,510 | 333 | 695 | 4,264 |
| 6 | 89.24 | 446,214 | 639 | 1,562 | 1,167 | 186 | 3,553 | -682 | 2,871 | -2,512 | 333 | 692 | 4,985 |
| 7 | 89.11 | 445,575 | 641 | 1,560 | 1,167 | 186 | 3,553 | -681 | 2,872 | -2,514 | 333 | 691 | 5,710 |
| 8 | 88.99 | 444,934 | 643 | 1,557 | 1,167 | 185 | 3,553 | -680 | 2,873 | -2,516 | 333 | 690 | 6,438 |
| 9 | 88.86 | 444,290 | 646 | 1,555 | 1,167 | 185 | 3,552 | -680 | 2,872 | -2,518 | 333 | 688 | 7,168 |
| 10 | 88.73 | 443,645 | 648 | 1,553 | 1,167 | 185 | 3,552 | -679 | 2,873 | -2,520 | 333 | 686 | 7,903 |
| 11 | 88.60 | 442,997 | 650 | 1,550 | 1,167 | 185 | 3,552 | -679 | 2,873 | -2,522 | 333 | 684 | 8,639 |
| 12 | 88.47 | 442,347 | 652 | 1,548 | 1,167 | 184 | 3,552 | -678 | 2,874 | -2,524 | 333 | 683 | 9,380 |