Amortization Schedule | ||||||
Prepared for Sample J. Borrower | ||||||
Generated on 7/1/2013 | ||||||
Purchase Price: | $200,000.00 | |||||
Down Pmt Pct: | 20.00% | |||||
Down Pmt: | $40,000.00 | |||||
Loan Amount: | $160,000.00 | |||||
Term (Months): | 180 | |||||
Interest Rate: | 5.00% | |||||
First Payment: | 6/19/2013 | |||||
Pmt No. | Year | Month | Payment | Interest | Principal | Balance |
1 | 2013 | 6 | $1,265.27 | $666.67 | $598.60 | $159,401.40 |
2 | 2013 | 7 | $1,265.27 | $664.17 | $601.10 | $158,800.30 |
3 | 2013 | 8 | $1,265.27 | $661.67 | $603.60 | $158,196.70 |
4 | 2013 | 9 | $1,265.27 | $659.15 | $606.12 | $157,590.58 |
5 | 2013 | 10 | $1,265.27 | $656.63 | $608.64 | $156,981.94 |
6 | 2013 | 11 | $1,265.27 | $654.09 | $611.18 | $156,370.76 |
7 | 2013 | 12 | $1,265.27 | $651.54 | $613.72 | $155,757.04 |
8 | 2014 | 1 | $1,265.27 | $648.99 | $616.28 | $155,140.75 |
9 | 2014 | 2 | $1,265.27 | $646.42 | $618.85 | $154,521.90 |
10 | 2014 | 3 | $1,265.27 | $643.84 | $621.43 | $153,900.47 |
11 | 2014 | 4 | $1,265.27 | $641.25 | $624.02 | $153,276.46 |
12 | 2014 | 5 | $1,265.27 | $638.65 | $626.62 | $152,649.84 |
1st Year Totals | $15,183.24 | $7,833.08 | $7,350.16 | $152,649.84 |
- Dashboard
- ExcelWriter v9 Docs
- …
- ExcelWriter Introduction
- ExcelWriter Learning Center
- Samples
- ExcelApplication Samples
- Data Validation
- Attachments
- DataValidation_output.xlsx
DataValidation_output.xlsx
Overview
Content Tools