Balloon Payment Loan Template

Page 1 of 1 Balloon Payment Loan Calculator © 2005 Vertex42 LLC v. 1.3 Download from Vertex42.com Inputs Assumptions * Interest compounds monthly Loan Amount $10,000 * Payments made at end of month Annual Interest Rate 3.00% * Balloon amount paid a month after the Amortization Period 36 months last regular monthly payment # of Regular Payments 12 months Begin Date 12/1/2005 Summary Monthly Payment $290.81 FALSE Balloon Payment 6,782.89 $ Balloon Payment w/Rounding 6,782.98 $ Total Payments 10,272.70 $ Total Interest Paid 272.70 $ Month Date Payment Interest Principal Balance 12/1/2005 ---10,000.00 $ 1 1/1/2006 290.81 25.00 265.81 9,734.19 2 2/1/2006 290.81 24.34 266.47 9,467.72 3 3/1/2006 290.81 23.67 267.14 9,200.58 4 4/1/2006 290.81 23.00 267.81 8,932.77 5 5/1/2006 290.81 22.33 268.48 8,664.29 6 6/1/2006 290.81 21.66 269.15 8,395.14 7 7/1/2006 290.81 20.99 269.82 8,125.32 8 8/1/2006 290.81 20.31 270.50 7,854.82 9 9/1/2006 290.81 19.64 271.17 7,583.65 10 10/1/2006 290.81 18.96 271.85 7,311.80 11 11/1/2006 290.81 18.28 272.53 7,039.27 12 12/1/2006 290.81 17.60 273.21 6,766.06 13 1/1/2007 6,782.98 16.92 6,766.06 0.00 Amortization Schedule Interest Only http://www.vertex42.com/ExcelTemplates/balloon-loan-calculator.html © 2005 Vertex42 LLC