Q:
# How Do You Calculate a Balloon Payment With an Amortization Schedule?

**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.

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.

Learn more about Personal Banking-
Q:
## How Do You Calculate a Commercial Loan Amortization Schedule?

A: To calculate a commercial loan amortization schedule, draw a four-column table, and label them payment amount, interest paid, principal paid and remaining ... Full Answer >Filed Under: -
Q:
## How Do You Create an Auto Loan Amortization Spreadsheet in Excel?

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: -
Q:
## Where Can You Find Some Free Bill Payment Templates?

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: -
Q:
## How Do You Find a 401(k) Account That You Have Not Accessed Recently?

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: