Q:

# How do you calculate a balloon payment with an amortization schedule?

A:

To calculate a balloon payment with an amortization schedule, enter the initial mortgage amount into a balloon mortgage calculator such as the one at Bankrate.com. Enter the interest rate and the number of years in the payment agreement, and the calculator then shows the monthly payment and the balloon payment amounts.

## Keep Learning

The total amount of money borrowed is repaid partially through monthly payments, and the remaining portion is paid as the balloon payment at the end of the term, explains Bankrate. The calculator shows how the term and interest rate affect the monthly payment and the balloon amount as the user changes the parameters or moves the sliders. The calculation using the Bankrate.com calculator assumes that the monthly payments are amortized over 30 years.

It is possible to generate reports of annual balances and see how the remaining balance decreases year by year depending on the interest rate, as shown by Bankrate. When the interest rate is smaller, the annual balance reduces faster and hence the final balloon payment becomes smaller. When the term is longer, the balloon payment is smaller.

For example, on a \$500,000 mortgage for a 5-year term at the rate of 4 percent, the monthly payment is \$2,387.08, based on the Bankrate balloon mortgage calculator. Part of this payment goes toward the interest accrued every month, and the remaining portion reduces the balance. The balance remaining at the end of the term becomes the balloon payment.

Sources:

## Related Questions

• A: Mortgage amortization is the payment of debt on a home using a schedule of fixed payments prescribed at the beginning of a mortgage loan period, explains I... Full Answer >
Filed Under:
• A: Use Excel's PMT function to calculate individual payments, determine the interest and principal components of each payment, and then set an amortization sc... Full Answer >
Filed Under:
• A: Free bill payment schedule templates are available at ExcelTemplates.net and MyFrugalHome.com. The templates on Excel Templates are primarily for use on th... Full Answer >
Filed Under:
• A: Finding an old 401(k) account that has not been accessed in the recent past may require searches with previous employers and multiple agencies including th... Full Answer >
Filed Under:
PEOPLE SEARCH FOR