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 longteer 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 Assumptions 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