Popular Examples
- Resumes
- Cover Letters
- CVs
- Idioms
- Excel Templates
- Business Examples
- Business Letters
- Love Letters
- Personal Letters
- Science
- Math Examples
More Excel Templates
- Blood Sugar Chart Excel Template
- Check Book Register Excel Template
- Class Schedule 15 Minute Excel Template
- Class Schedule 30 Minute Excel Template
- College Savings Worksheet Excel Template
- Daily Cash Sheet Excel Template
- Daily Exercise Log Excel Template
- Daily Food Log Excel Template
- Donation Form Excel Template
- Example of 24 Month Sales Forecast
- Example of 401K Planner
- Example of 401K Reallocation
- Example of Asset Tracking
- Example of Balance Sheet
- Example of Balanced Scorecard
- Example of Bill Organizer Template
- Example of Billing Statement
- Example of Blood Sugar Chart
- Example of BMI Calculator Template
- Example of Christmas Shopping List Template
- Example of Closing Cost
- Example of Contact List
- Example of Daily Cash Transaction Report Template
- Example of Debt To Income Ratio Sheet 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
