Amortization Schedule | ||||||
Prepared for blank | ||||||
Generated on date | ||||||
Purchase Price: | $200,000.00 | |||||
Down Pmt Pct: | 20.00% | |||||
Down Pmt: | $40,000.00 | |||||
Loan Amount: | $160,000.00 | |||||
Term (Months): | 100 | |||||
Interest Rate: | 5.00% | |||||
First Payment: | 11/1/2003 | |||||
Pmt No. | Year | Month | Payment | Interest | Principal | Balance |
1 | 2003 | 11 | $1,959.70 | $666.67 | $1,293.03 | $158,706.97 |
2 | 2003 | 12 | $1,959.70 | $661.28 | $1,298.42 | $157,408.55 |
3 | 2004 | 1 | $1,959.70 | $655.87 | $1,303.83 | $156,104.72 |
4 | 2004 | 2 | $1,959.70 | $650.44 | $1,309.26 | $154,795.46 |
5 | 2004 | 3 | $1,959.70 | $644.98 | $1,314.72 | $153,480.74 |
6 | 2004 | 4 | $1,959.70 | $639.50 | $1,320.20 | $152,160.55 |
7 | 2004 | 5 | $1,959.70 | $634.00 | $1,325.70 | $150,834.85 |
8 | 2004 | 6 | $1,959.70 | $628.48 | $1,331.22 | $149,503.63 |
9 | 2004 | 7 | $1,959.70 | $622.93 | $1,336.77 | $148,166.86 |
10 | 2004 | 8 | $1,959.70 | $617.36 | $1,342.34 | $146,824.53 |
11 | 2004 | 9 | $1,959.70 | $611.77 | $1,347.93 | $145,476.60 |
12 | 2004 | 10 | $1,959.70 | $606.15 | $1,353.55 | $144,123.05 |
1st Year Totals | $23,516.38 | $7,639.43 | $15,876.95 | $144,123.05 |
FirstYearPayment.xlsx
Overview
Content Tools