DavesAmort.xlsx
Sheet1
| Data |
| Mortgage | $100,000.00 |
| Interest/yr | 6.00% |
| Term (yrs) | 30 |
| Compounding | 12 |
| Payment | $599.55 |
| Starting Month | 1 |
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Expenses |
| Interest | $500.000 | $499.502 | $499.002 | $498.499 | $497.994 | $497.486 | $496.976 | $496.463 | $495.948 | $495.430 | $494.909 | $494.386 |
| Principal | $99.5505 | $100.0483 | $100.5485 | $101.0513 | $101.5565 | $102.0643 | $102.5746 | $103.0875 | $103.6029 | $104.1209 | $104.6416 | $105.1648 |
| OR | $99.5505 | $100.0483 | $100.5485 | $101.0513 | $101.5565 | $102.0643 | $102.5746 | $103.0875 | $103.6029 | $104.1209 | $104.6416 | $105.1648 |
Sheet2
| Data |
| Mortgage | 170000 |
| Interest/yr | 8% |
| Term (yrs) | 5 |
| Compounding | 12 |
| Payment | ($3,446.99) |
| Starting Month | 1 |
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Expenses |
| Interest | 1133.33 | 1117.91 | 1102.38 | 1086.75 | 1071.02 | 1055.18 | 1039.23 | 1023.18 | 1007.02 | 990.75 | 974.38 | 957.90 |
| Ammort |
| Principal | 2313.65 | 2329.08 | 2344.61 | 2360.24 | 2375.97 | 2391.81 | 2407.76 | 2423.81 | 2439.97 | 2456.23 | 2472.61 | 2489.09 |
| Check | 3446.99 | 3446.99 | 3446.99 | 3446.99 | 3446.99 | 3446.99 | 3446.99 | 3446.99 | 3446.99 | 3446.99 | 3446.99 | 3446.99 |
yugigogo09
