Balloon Loan Calculator Worksheet
PADD Loan Calculator Tool
Loan Amount: $ 468,000.00
Balloon Payment: $ -
Interest Rate (APR): 9.50%
Payment Rhythm: Monthly
Loan Term in Years: 10
Payments in Advance / Arrears: Arrears
Payment Amount (Monthly): $ 6,055.81
Loan Summary:
Payment Amount (Monthly): $ 6,055.81
Number of Loan Payments over Loan Term: 120
Total Interest Paid over Loan Term: $ 258,696.68
Total Amount Paid over Loan Term: $ 726,696.68
Time until Principal exceeds Interest Payments: 2 10/12 Years
First 12 Month Amortization Schedule Annual Amortization Schedule
Month Principal Interest Balance Year Principal Interest Balance
Total $ 29,470.96 $ 43,198.71 $ 438,529.04 Total $ 468,000.00 $ 258,696.68 -
1 $ 2,350.81 $ 3,705.00 $ 465,649.19 1 $ 29,470.96 $ 43,198.71 $ 438,529.04
2 $ 2,369.42 $ 3,686.39 $ 463,279.78 2 $ 32,395.88 $ 40,273.78 $ 406,133.15
3 $ 2,388.17 $ 3,667.63 $ 460,891.60 3 $ 35,611.10 $ 37,058.57 $ 370,522.06
4 $ 2,407.08 $ 3,648.73 $ 458,484.52 4 $ 39,145.41 $ 33,524.26 $ 331,376.64
5 $ 2,426.14 $ 3,629.67 $ 456,058.39 5 $ 43,030.50 $ 29,639.17 $ 288,346.14
6 $ 2,445.34 $ 3,610.46 $ 453,613.04 6 $ 47,301.17 $ 25,368.49 $ 241,044.97
7 $ 2,464.70 $ 3,591.10 $ 451,148.34 7 $ 51,995.70 $ 20,673.97 $ 189,049.27
8 $ 2,484.21 $ 3,571.59 $ 448,664.13 8 $ 57,156.15 $ 15,513.52 $ 131,893.12
9 $ 2,503.88 $ 3,551.92 $ 446,160.24 9 $ 62,828.76 $ 9,840.91 $ 69,064.36
10 $ 2,523.70 $ 3,532.10 $ 443,636.54 10 $ 69,064.36 $ 3,605.31 $ -
11 $ 2,543.68 $ 3,512.12 $ 441,092.86
12 $ 2,563.82 $ 3,491.99 $ 438,529.04
This calculator will give you just an estimate of your actual loan payment and amortization schedule. Your actual loan payment amount and amortization schedule will be determined at the time
of loan closing, when and if your loan application has been approved.
The PADD does not guarantee the correctness of any results.
Interest
Principal
Page 1/1
Free Download
Balloon Loan Calculator Worksheet XLS
Favor this template? Just fancy it by voting!
(0 Votes)
0.0
Related Forms
