Scribd
Upload
34 views5 pages

Balloon

This document contains a loan calculator and amortization schedule for a $100,000 loan with an interest rate of 12% over 80 months. The loan payments are for the first 20 months, with monthly payments of $1,821.89. By the 20th payment, the balance will be $81,902.91.

Uploaded by

natanpasiga
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
34 views5 pages

Balloon

This document contains a loan calculator and amortization schedule for a $100,000 loan with an interest rate of 12% over 80 months. The loan payments are for the first 20 months, with monthly payments of $1,821.89. By the 20th payment, the balance will be $81,902.91.

Uploaded by

natanpasiga
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

BALLOON LOAN CALCULATOR

Loan Amount 100,000.00


Interest Rate (per Year) 12 %
Amortization Period (Month) 80 months
Payment Period (Month) 20 months
Payment Date 1-Jan-15

Monthly Payment 1,821.89 Total Interest


Total Payment 119,159.64 Loan Amount
Total Interest 19,159.64

AMORTIZATION SCHEDULE

Month Payment Date Balance Principal Interest Payment


100,000.00
1 1-Jan-15 99,178.11 821.89 1,000.00 1,821.89
2 1-Feb-15 98,348.01 830.10 991.78 1,821.89
3 1-Mar-15 97,509.61 838.40 983.48 1,821.89
4 1-Apr-15 96,662.82 846.79 975.10 1,821.89
5 1-May-15 95,807.56 855.26 966.63 1,821.89
6 1-Jun-15 94,943.75 863.81 958.08 1,821.89
7 1-Jul-15 94,071.30 872.45 949.44 1,821.89
8 1-Aug-15 93,190.13 881.17 940.71 1,821.89
9 1-Sep-15 92,300.15 889.98 931.90 1,821.89
10 1-Oct-15 91,401.26 898.88 923.00 1,821.89
11 1-Nov-15 90,493.39 907.87 914.01 1,821.89
12 1-Dec-15 89,576.44 916.95 904.93 1,821.89
13 1-Jan-16 88,650.32 926.12 895.76 1,821.89
14 1-Feb-16 87,714.94 935.38 886.50 1,821.89
15 1-Mar-16 86,770.20 944.74 877.15 1,821.89
16 1-Apr-16 85,816.02 954.18 867.70 1,821.89
17 1-May-16 84,852.30 963.72 858.16 1,821.89
18 1-Jun-16 83,878.93 973.36 848.52 1,821.89
19 1-Jul-16 82,895.84 983.10 838.79 1,821.89
20 1-Aug-16 81,902.91 992.93 828.96 1,821.89
21 1-Sep-16 - 81,902.91 819.03 82,721.94

You might also like