If you refinance or sell your home before the balloon payment period is up, you may be able to save money. Enter the payment figure into the other worksheets, then save it in the worksheets for later use. If it’s not a negative number, it’s possible that you mistyped some information.

The cell where you entered your equation should display the result. Enter variables like =PMT (rate, nper, pv,, and type). It will assist you in determining whether to keep your loan for an extended period of time, increase your monthly payment, or switch from a fixed rate to a variable rate.

To account for a different interest rate or payment amount, the variables should be adjusted. You must ensure that everything is correct and that your equation does not contain any errors. You must enter all of the variables you have set. =FV(rate, nper, pmt, is used to generate these variables. To calculate a balloon payment or payment to a specific amount, you can use Microsoft Excel. Balloon payments are usually found in fixed-rate or adjustable-rate mortgages, as are balloon payments. There may be loans that are set up so that an extra payment is due at the end. For example, if the loan amount is $10,000, the interest rate is 5%, and the number of payments is 60, the balloon payment would be $2,500. Finally, to calculate the balloon payment, use the PV function. For example, if the loan amount is $10,000, the interest rate is 5%, and the number of payments is 60, the total amount paid would be $13,889.58. To calculate the total amount paid over the life of the loan, use the FV function. For example, if the loan amount is $10,000, the interest rate is 5%, and the number of payments is 60, the total interest paid would be $3,889.58. To calculate the total interest paid over the life of the loan, use the IPR function. For example, if the loan amount is $10,000, the interest rate is 5%, and the number of payments is 60, the monthly payment would be -$193.33. To calculate the monthly payment, use the PMT function. For example, if the loan amount is $10,000, the interest rate is 5%, and the number of payments is 60, the balloon payment amount would be $2,500. Then, enter the loan information into the appropriate cells. In the first row of each column, enter the appropriate label (e.g., “Date,” “Loan Amount,” etc.). First, open a new workbook in Excel and name it something like “Balloon Payment.” Next, create columns for the date, loan amount, interest rate, number of payments, and balloon payment amount. Making a balloon payment in Excel is a relatively simple process.

Balloon amortization schedule excel