This calculator estimates a level monthly payment and total interest for a fully amortizing loan, but it does not calculate a balloon payment or a balloon-loan schedule. Enter the loan amount, annual APR, and term to see those estimates; a balloon schedule needs an additional maturity date or balloon amount, so the standard-payment results below are a baseline, not a balloon-loan quote.
Formula
A standard amortization schedule with a balloon payment tracks each scheduled payment, the interest charged for that period, the amount applied to principal, and the remaining balance. In a balloon loan, the ordinary payments are not large enough to repay the full balance by maturity; the remaining balance is due as a final lump sum. The calculator above instead computes the payment for a fully amortizing loan, where the balance is designed to reach zero at the end of the stated term.
For a fixed monthly payment, the payment formula is:
PMT = P × r / [1 − (1 + r)−n], where r = APR / 1200 and n = years × 12.
Pis the starting principal, in dollars.APRis the annual percentage rate entered as a percentage, such as 8 for 8%.ris the monthly rate as a decimal.nis the number of monthly payments.PMTis the monthly payment, in dollars.
The total-interest estimate is PMT × n − P. Because the displayed payment is rounded to cents, the total uses that rounded payment. Actual loan schedules may adjust a final payment to account for rounding or contract terms.
Worked Example
Using the calculator’s default inputs—$20,000 principal, 8% APR, and a 5-year term:
- Convert APR to a monthly rate:
r = 8 / 1200 = 0.0066667. - Convert the term to payments:
n = 5 × 12 = 60. - Apply the payment formula:
PMT = 20,000 × 0.0066667 / [1 − (1.0066667)−60] ≈ $405.53. - Calculate interest using the rounded payment:
$405.53 × 60 − $20,000 = $4,331.80.
The calculator therefore shows a monthly payment of $405.53 and total interest of $4,331.80 for this fully amortizing example. These are not balloon-loan figures.
Assumptions
- The interest rate is fixed for the calculation period.
- Payments are monthly and made at the end of each period.
- Interest is compounded monthly at APR divided by 12.
- The calculation excludes fees, taxes, insurance, PMI, and escrow because they are not inputs.
How a Balloon Amortization Schedule Works
A balloon loan can have monthly payments calculated as though the debt will be repaid over a longer amortization period, while the actual contract requires the balance to be paid earlier. For example, a payment may be based on a 20-year repayment pattern even though the loan matures in 5 years. After the scheduled payments, the borrower still owes the unpaid principal, plus any interest or other amounts due under the contract.
Each row in a schedule usually follows the same accounting steps:
- Beginning balance: the amount owed before the payment.
- Interest: beginning balance multiplied by the applicable period rate.
- Principal paid: scheduled payment minus that period’s interest.
- Ending balance: beginning balance minus principal paid, before any additional charges or adjustments.
At maturity, the remaining balance is the balloon amount if the contract requires that balance as a lump sum. It is not necessarily equal to the original principal, and it is not simply the final ordinary payment. The exact calculation depends on the payment amount, rate, payment dates, fees or other contract terms, and any extra principal payments.
What You Need to Calculate the Balloon
To calculate a balloon schedule, first confirm the loan’s actual payment formula and the maturity date. A useful schedule needs the principal, interest rate and whether it can change, payment frequency, regular payment amount, first payment date, and number of payments due before maturity. It should also account for extra payments, payment timing, and any contract-specific charges that affect the balance.
For a fixed-rate loan with monthly payments, a balance after k payments can be estimated as:
Bk = P(1 + r)k − PMT × [(1 + r)k − 1] / r.
Here, Bk is the balance after k payments, P is principal, r is the monthly rate, and PMT is the regular payment. If the loan matures after that payment, the calculated balance is a starting estimate of the balloon. The contract or lender’s payoff statement may include accrued interest through a particular date and other amounts not represented by this formula.
How to Read and Check a Schedule
In the early rows of a typical fixed-rate schedule, interest is calculated on a relatively large outstanding balance, so a larger share of each payment may go to interest. As principal is paid down, the balance falls and the interest portion generally declines. A balloon schedule stops before that balance reaches zero, leaving a substantial amount due at maturity.
Check that the schedule’s opening balance matches the amount financed, that each interest amount follows the stated rate and timing, and that each payment reduces principal by payment minus interest. The final balance should reconcile with the stated balloon under the same assumptions. Small differences can arise from cent rounding, payment dates, daily interest calculations, or adjustments specified in the loan documents.
A common misconception is that “amortized over 20 years” means the loan lasts 20 years. It may describe only how the scheduled payment is calculated. The maturity date can be much earlier, with the unpaid balance then due. Another frequent error is to multiply an ordinary payment by the number of months and treat the result as total repayment; that ignores the separate balloon amount and may omit other charges.
Risks, Limits, and Alternatives
A balloon payment can be much larger than a regular monthly installment. The amount due may be difficult to predict if the rate varies, payments are missed or changed, extra principal is made, or the maturity date falls between payment dates. A refinance or asset sale may not be available when the balloon comes due; neither should be assumed in a calculation. The schedule describes arithmetic, not whether funds will be available or what options a contract permits.
Possible structures to compare in a neutral calculation include a fully amortizing loan that pays down to zero by maturity, a balloon structure with a specified regular payment and maturity balance, or a shorter-term schedule with a different payment. For a meaningful comparison, use the same principal and rate assumptions and include the full time horizon. Ask the lender for the contractual payment schedule and payoff amount for the relevant date, rather than relying on a simplified estimate.
This calculator cannot produce a balloon amount because it has no balloon maturity or regular balloon-loan payment input. Use the formula and schedule details above to understand what information is missing, then check the loan documents or obtain a lender-provided schedule. The result is an estimate, and the lender’s disclosure gives the exact figures.
Frequently Asked Questions
What is an amortization schedule with a balloon payment?
A period-by-period record of interest, principal, and remaining balance for a loan whose regular payments leave some balance unpaid at maturity. That remaining amount is due as the balloon, subject to the contract.
How do I calculate a balloon payment?
Calculate the remaining principal after the scheduled payments using the actual payment amount, interest rate, and number and timing of payments. Check whether accrued interest or other contract amounts are due on the maturity date.
Is the balloon payment the same as the final monthly payment?
No. It is generally a separate lump-sum balance due at maturity, in addition to any regular payment due then. The loan agreement determines how the maturity-date amount is collected.
Why does a balloon loan have a lower payment than a fully amortizing loan?
Its regular payment may be calculated over a longer repayment period than the time until maturity, so those installments do not repay the entire balance by the maturity date. The remaining principal becomes due as a balloon.
Does this calculator show a balloon payment?
No. It calculates a fully amortizing monthly payment and total interest from principal, APR, and term. A balloon calculation also needs the actual regular payment and the number of payments or maturity date.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- June Balance Date: What It Means for Loan Balances$405.53
- L&T Finance Gold Loan: How It Works and What to Check
- Journal Entry to Correct a Beginning Balance
- JS Bank Gold Loan: Eligibility, Process and Costs
- Journal Entry for a Bank Loan: Debit and Credit$20,000.00
- Journal Entry to Adjust Beginning Balance