Balloon Payment Loan by heykiyut


More Info
									                          Balloon Payment Loan
This template calculates key figures for a balloon payment loan. A balloon loan
requires a large final payment on a future date. The advantage of such an
arrangement is that the borrower makes payments based on a traditional long-
term loan. For example, you could have a 5-year balloon loan with monthly
payments based on a 15-year loan. However, at the end of 5 years, you will
have a final large payment(balloon payment). The loan amortization is any
period you choose. You can lower the monthly payment by entering a longer
amortization period.
To view the template, click the worksheet tab labeled Template at the bottom
of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are
protected. Use the Tab key to move from one unprotected cell to the next.
         Balloon Payment Loan
                 <- Enter date in cell to the left
Loan Principal Amount
Annual Interest Rate
Amortization Period in Years
Years Until Balloon Payment

Key Financial Data
Monthly Payment
Total Monthly Payments
Total Amount Paid
Total Interest
Balloon Payment

To top