# How To Calculate a Balloon Amount

## A Step-by-Step TutorialTutorial 7

Calculate balloon payment for a mortgage or loan due after a series of regular payments. When the periodic payments is not large enough to fully amortize a loan in the time allotted, the final payment will be larger than the periodic payment. The final payment, in this case, is known as a balloon payment. This tutorial illustrates the setup to solve this financial question.

Note: Asking the questions "What it the balloon payment at period 48?" and "What is the remaining balance at period 48?" are two different questions and a financial calculator should calculate two different results. The former question is asking what the payment amount due is at period 48 including the accrued interest. The latter question is asking what is the loan balance after the payment has been made and there is no accrued interest due. Many financial calculators on the web frankly get this wrong.

All users should work through the more detailed first tutorial to understand the Ultimate Financial Calculator's (UFC) basic concepts and settings.

To create a loan schedule when the balloon payment amount is unknown, follow these steps:

1. Set "Schedule Type" to "Loan"
• Or click the [New] button to clear any previous entries.
2. Set "Rounding" to "Open balance — no adjustment" by clicking on the {Settings} {Rounding Options}
3. In the header section, make the following settings:
1. For "Calculate Method" select "Normal".
2. Set "Initial Compounding" to "Monthly".
3. Enter 6.75 for the "Initial Interest Rate".
1. In row one of the cash flow input area, create a "Loan" series
1. Set the "Date" to July 1, 2020
2. Set the "Amount" to 365,000.00
3. Set the "# Periods" to 1
• Note: Since the number of periods is 1, you will not be able to set a frequency. If a frequency is set, it will be cleared when you leave the row
1. Move to the second row of the cash flow input area. Select "Payment" for the "Series" type. For this example, we will assume we want to create a schedule for a mortgage that has a balloon payment which is due after 5 years (at the 60th monthly payment). We will also assume that the monthly payment is calculated based on a 30-year (360 monthly payments) loan.
1. Set the "Date" to August 1, 2020
2. Set the "Amount" to "Unknown" by typing "U"
3. Set the "# Periods" to "360". This sets the calculator to calculate the payment as if the payment were based on a 30-year loan.
1. Calculate the unknown. The result is \$2,367.38.
1. Calculate the final balloon payment amount
1. Change the 360 number entered in the 2nd row for "# Periods" to "60"
2. Move to the third row of the cash flow input area. Select "Payment" for the "Series"
3. Set the date to "August 1, 2025" if it isn't already (end of the 5th year)
4. Set the "Amount" to "Unknown"
5. Set the "# Periods" to "1"