Creating a Balloon Loan Payment Plan

An Excel file that teaches how to perform Creating a Balloon Loan Payment Plan operation.

Excel Format: Creating A Balloon Loan Payment Plan

Interest, maturity and balloon rate are parameters. Monthly installments and the final balloon amount are calculated. The remaining principal is updated every period. The payment schedule is printed on the table. The graph shows the decrease in debt.

Hope it is useful.