Loan Calculator Template

Page 1 of 2 Boat Loan Calculator © 2007 Vertex42, LLC v 1.0 http://www.vertex42.com/Calculators/boat-loan-calculator.html Inputs Effect of Extra Payments Boat Loan Amount 45,000 $ Total Payments 64,098.87 $ Annual Interest Rate 7.50% Total Interest 19,098.87 $ Term of Loan in Years 10 Reduced Interest None First Payment Date 1/1/2007 Number of Payments 120 Frequency of Payment Monthly Last Payment Date 12/1/2016 Summary (with no extra payments) Number of Payments 120 Rate (per period) 0.625% Payment (per period) $534.16 Total Interest $19,098.96 Total Payments $64,098.96 . No. Due Date Payment Due Additional Payment Interest Principal Balance $45,000.00 1 1/1/2007 534.16 0.00 281.25 252.91 44,747.09 2 2/1/2007 534.16 0.00 279.67 254.49 44,492.60 3 3/1/2007 534.16 0.00 278.08 256.08 44,236.52 4 4/1/2007 534.16 0.00 276.48 257.68 43,978.84 5 5/1/2007 534.16 0.00 274.87 259.29 43,719.55 6 6/1/2007 534.16 0.00 273.25 260.91 43,458.64 7 7/1/2007 534.16 0.00 271.62 262.54 43,196.10 8 8/1/2007 534.16 0.00 269.98 264.18 42,931.92 9 9/1/2007 534.16 0.00 268.32 265.84 42,666.08 10 10/1/2007 534.16 0.00 266.66 267.50 42,398.58 11 11/1/2007 534.16 0.00 264.99 269.17 42,129.41 12 12/1/2007 534.16 0.00 263.31 270.85 41,858.56 13 1/1/2008 534.16 0.00 261.62 272.54 41,586.02 14 2/1/2008 534.16 0.00 259.91 274.25 41,311.77 15 3/1/2008 534.16 0.00 258.20 275.96 41,035.81 16 4/1/2008 534.16 0.00 256.47 277.69 40,758.12 17 5/1/2008 534.16 0.00 254.74 279.42 40,478.70 18 6/1/2008 534.16 0.00 252.99 281.17 40,197.53 19 7/1/2008 534.16 0.00 251.23 282.93 39,914.60 20 8/1/2008 534.16 0.00 249.47 284.69 39,629.91 21 9/1/2008 534.16 0.00 247.69 286.47 39,343.44 22 10/1/2008 534.16 0.00 245.90 288.26 39,055.18 23 11/1/2008 534.16 0.00 244.09 290.07 38,765.11 24 12/1/2008 534.16 0.00 242.28 291.88 38,473.23 25 1/1/2009 534.16 0.00 240.46 293.70 38,179.53 26 2/1/2009 534.16 0.00 238.62 295.54 37,883.99 27 3/1/2009 534.16 0.00 236.77 297.39 37,586.60 28 4/1/2009 534.16 0.00 234.92 299.24 37,287.36 29 5/1/2009 534.16 0.00 233.05 301.11 36,986.25 -10,0000 10,000 20,000 30,000 40,000 50,000 Jan-07 Jan-08 Jan-09 Jan-10 Jan-11 Jan-12 Jan-13 Jan-14 Jan-15 Jan-16 Balance No Extra Payments http://www.vertex42.com/Calculators/auto-loan-calculator.html © 2007 Vertex42 LLCPage 2 of 2 30 6/1/2009 534.16 0.00 231.16 303.00 36,683.25 31 7/1/2009 534.16 0.00 229.27 304.89 36,378.36 32 8/1/2009 534.16 0.00 227.36 306.80 36,071.56 33 9/1/2009 534.16 0.00 225.45 308.71 35,762.85 34 10/1/2009 534.16 0.00 223.52 310.64 35,452.21 35 11/1/2009 534.16 0.00 221.58 312.58 35,139.63 36 12/1/2009 534.16 0.00 219.62 314.54 34,825.09 http://www.vertex42.com/Calculators/auto-loan-calculator.html © 2007 Vertex42 LLC