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