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