Loan Amortization Schedule

Page 1 of 18 Loan Amortization Schedule © 2005 Vertex42, LLC v 1.4 Download from Vertex42.com Inputs Summary Loan Amount 12,000 $ Rate (per period) 0.625% Annual Interest Rate 7.50% Total Payments $12,725.06 Term of Loan in Years 1.5 Total Interest $725.06 First Payment Date 9/28/2007 Interest Savings $0.02 Frequency of Payment Monthly . Payment (per period) $706.95 No. Due Date Payment Due Additional Payment Interest Principal Balance $12,000.00 1 9/28/2007 706.95 75.00 631.95 11,368.05 2 10/28/2007 706.95 71.05 635.90 10,732.15 3 11/28/2007 706.95 67.08 639.87 10,092.28 4 12/28/2007 706.95 63.08 643.87 9,448.41 5 1/28/2008 706.95 59.05 647.90 8,800.51 6 2/28/2008 706.95 55.00 651.95 8,148.56 7 3/28/2008 706.95 50.93 656.02 7,492.54 8 4/28/2008 706.95 46.83 660.12 6,832.42 9 5/28/2008 706.95 42.70 664.25 6,168.17 10 6/28/2008 706.95 38.55 668.40 5,499.77 11 7/28/2008 706.95 34.37 672.58 4,827.19 12 8/28/2008 706.95 30.17 676.78 4,150.41 13 9/28/2008 706.95 25.94 681.01 3,469.40 14 10/28/2008 706.95 21.68 685.27 2,784.13 15 11/28/2008 706.95 17.40 689.55 2,094.58 16 12/28/2008 706.95 13.09 693.86 1,400.72 17 1/28/2009 706.95 8.75 698.20 702.52 18 2/28/2009 706.91 4.39 702.52 0.00 Amortization Schedule http://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html © 2005 Vertex42 LLCLoan Amortization Schedule © 2005 Vertex42, LLC v 1.4 Download from Vertex42.com InputsLoan Amount 12,000 $ Annual Interest Rate 7.50% Term of Loan in Years 1.5 First Payment Date 9/28/2007 Frequency of Payment Monthly Summary Rate (per period) 0.625% Payment (per period) $706.95 Total Payments $2,213.90 Total Interest $1,192.71 . No. Due Date Payment Due Payment Interest Principal Balance $12,000.00 1 9/28/2007 706.95 706.95 75.00 631.95 11,368.05 2 10/28/2007 706.95 706.95 71.05 635.90 10,732.15 3 11/28/2007 706.95 800.00 67.08 732.92 9,999.23 4 12/28/2007 706.95 62.50 -62.50 10,061.73 5 1/28/2008 706.95 62.89 -62.89 10,124.62 6 2/28/2008 706.95 63.28 -63.28 10,187.90 7 3/28/2008 706.95 63.67 -63.67 10,251.57 8 4/28/2008 706.95 64.07 -64.07 10,315.64 9 5/28/2008 706.95 64.47 -64.47 10,380.11 10 6/28/2008 706.95 64.88 -64.88 10,444.99 11 7/28/2008 706.95 65.28 -65.28 10,510.27 12 8/28/2008 706.95 65.69 -65.69 10,575.96 13 9/28/2008 706.95 66.10 -66.10 10,642.06 14 10/28/2008 706.95 66.51 -66.51 10,708.57 15 11/28/2008 706.95 66.93 -66.93 10,775.50 16 12/28/2008 706.95 67.35 -67.35 10,842.85 17 1/28/2009 706.95 67.77 -67.77 10,910.62 18 2/28/2009 10,978.81 68.19 -68.19 10,978.81 Payment Schedule Recording Actual Payments This spreadsheet provides an alternate way to record the payments, assuming the same loan information as in the Schedule worksheet. The actual payment is recorded each pay period. Any amount above the payment due is used to pay off the principal. If no payment is made, the interest due is added to the balance. This assumes there are no penalties for late payments, missing payments, or prepayments. As payments are made, enter the amount paid in this column.