Balloon Payment Calculator
Commercial Funding Network, Inc
Balloon Payment Loan Calculator
COMMERCIAL FUNDING NETWORK, INC
Inputs
Assumptions
* Interest compounds monthly
Loan Amount $500,000
* Payments made at end of month
Annual Interest Rate 6.00%
* Balloon amount paid a month after the
Amortization Period 180 months
last regular monthly payment
# of Regular Payments 59 months
Begin Date 10/15/2009
Summary
Monthly Payment $4,219.28 0
Balloon Payment $ 384,264.40
Balloon Payment w/Rounding
$ 384,265.10
Total Payments $ 633,202.62
Total Interest Paid $ 133,202.62
Amorzaon Schedule
Month Date Payment Interest Principal
10/15/2009 -
- -
1 11/15/2009 4,219.28 2,500.00 1,719.28
2 12/15/2009 4,219.28 2,491.40 1,727.88
3 1/15/2010 4,219.28 2,482.76 1,736.52
4 2/15/2010 4,219.28 2,474.08 1,745.20
5 3/15/2010 4,219.28 2,465.36 1,753.92
6 4/15/2010 4,219.28 2,456.59 1,762.69
7 5/15/2010 4,219.28 2,447.77 1,771.51
8 6/15/2010 4,219.28 2,438.92 1,780.36
9 7/15/2010 4,219.28 2,430.01 1,789.27
10 8/15/2010 4,219.28 2,421.07 1,798.21
11 9/15/2010 4,219.28 2,412.08 1,807.20
12 10/15/2010 4,219.28 2,403.04 1,816.24
13 11/15/2010 4,219.28 2,393.96 1,825.32
14 12/15/2010 4,219.28 2,384.83 1,834.45
15 1/15/2011 4,219.28 2,375.66 1,843.62
16 2/15/2011 4,219.28 2,366.44 1,852.84
17 3/15/2011 4,219.28 2,357.18 1,862.10
18 4/15/2011 4,219.28 2,347.87 1,871.41
19 5/15/2011 4,219.28 2,338.51 1,880.77
20 6/15/2011 4,219.28 2,329.11 1,890.17
21 7/15/2011 4,219.28 2,319.66 1,899.62
22 8/15/2011 4,219.28 2,310.16 1,909.12
23 9/15/2011 4,219.28 2,300.61 1,918.67
24 10/15/2011 4,219.28 2,291.02 1,928.26
25 11/15/2011 4,219.28 2,281.38 1,937.90
26 12/15/2011 4,219.28 2,271.69 1,947.59
27 1/15/2012 4,219.28 2,261.95 1,957.33
28 2/15/2012 4,219.28 2,252.16 1,967.12
29 3/15/2012 4,219.28 2,242.33 1,976.95
Interest Only
Page 1/16
Free Download
Balloon Payment Calculator XLS
Favor this template? Just fancy it by voting!
(0 Votes)
0.0
Related Forms
