Examples for business, study, careers, love, and more...
Examples :: Excel Templates :: Sample of Balloon Loan Template

Examples of Balloon Loan Template


Balloon Loan Calculator


Loan Date 03/13/08
Loan Type ____________Loan
 


Financial Details
Loan Amount $20,000.00
Interest Rate 3.00%
Loan Period 5
Balloon Loan length 2
Financial Summary
Monthly Payment $359.37
Total Interest Paid $982.57
Total Payments $8,624.97
Balloon Payment $12,357.60

 

Amortization Schedule
  Date Monthly Payment Interest Principal Ending Balance Total Monthly Payments
03/13/08 - - - $20,000.00 -
04/13/08 $359.37 $50.00 $309.37 $19,690.63
05/13/08 $359.37 $49.23 $310.14 $19,380.48
06/13/08 $359.37 $48.45 $310.92 $19,069.56
07/13/08 $359.37 $47.67 $311.70 $18,757.85
08/13/08 $359.37 $46.89 $312.48 $18,445.37
09/13/08 $359.37 $46.11 $313.26 $18,132.11
10/13/08 $359.37 $45.33 $314.04 $17,818.06
11/13/08 $359.37 $44.55 $314.82 $17,503.24
12/13/08 $359.37 $43.76 $315.61 $17,187.63
01/13/09 $359.37 $42.97 $316.40 $16,871.22
02/13/09 $359.37 $42.18 $317.19 $16,554.03
03/13/09 $359.37 $41.39 $317.98 $16,236.04
First year $4,312.49
04/13/09 $359.37 $40.59 $318.78 $15,917.26
05/13/09 $359.37 $39.79 $319.58 $15,597.68
06/13/09 $359.37 $38.99 $320.38 $15,277.29
07/13/09 $359.37 $38.19 $321.18 $14,956.11
08/13/09 $359.37 $37.39 $321.98 $14,634.13
09/13/09 $359.37 $36.59 $322.78 $14,311.34
10/13/09 $359.37 $35.78 $323.59 $13,987.75
11/13/09 $359.37 $34.97 $324.40 $13,663.34
12/13/09 $359.37 $34.16 $325.21 $13,338.13
01/13/10 $359.37 $33.35 $326.02 $13,012.11
02/13/10 $359.37 $32.53 $326.84 $12,685.26
03/13/10 $359.37 $31.71 $327.66 $12,357.60
Second Year $4,312.49


Notes on Balloon Loan Template Example

A Balloon Loan, is a loan usually with a low interest rate. Payments are made for a set time, and then a final large
payment is made at the end of the Balloon Loan period.

To use this Balloon Loan Calculator, fill in the Date, Loan Amount, Interest Rate, Loan Period, and Balloon Loan
length fields.
If you need to add additional years, copy a previous section of years and paste below the last dates row.

Disclaimer: Examplesof.com makes every effort to ensure the functional integrity of all downloadable materials posted on the site. The information, methodologies and processes contained in these materials are provided according to built-in software and formulas. We are unable to guarantee that these materials will necessarily be suitable for individual purposes. We are unable to guarantee that these materials will necessarily be free of functional issues which may affect their performance. Important: These materials are offered for purchase and use in good faith in "as is" condition. Full disclaimer is here disclaimer

Limited Use Policy : These templates provided by ExamplesOf.com, may be downloaded and customized for your personal or company use only. You may download copies, make archival copies and customize the template to be distributed and used within your company. This template or any document produced from this template may NOT be sold, redistributed, or uploaded to the internet for distribution.EULA

Download Excel Version of Balloon Loan example
Download Example Balloon Loan Excel Template