Advanced | Simple | Early Payoff | Refinance | HELOC | Recast | Interest Only | Biweekly | Extra Payments | Mortgage Rates | Free Widget |

**Balloon Mortgage Calculator** excel to calculate your monthly payment and get an amortization schedule with balloon payment excel. **Balloon payment calculator** to give you a monthly breakdown of interest, principal, and remaining balance as well as a summary of the total balloon payment and the total payment.

## Balloon Mortgage Calculator Results |
||||||

Monthly Payment: |
$1,610.46 | |||||

Balloon Payment: |
$277,096.66 | |||||

Total Principal Paid: |
$300,000.00 | |||||

Total Interest Paid: |
$72,114.09 | |||||

Total Payment: |
$372,114.09 | |||||

## Amortization Schedule With Balloon Payment |
||||||

Payment Date | Payment # | Interest Paid | Principal Paid | Total Payment | Remaining Balance | |
---|---|---|---|---|---|---|

Sep, 2023 | 1 | $1,250.00 | $360.46 | $1,610.46 | $299,639.54 | |

Oct, 2023 | 2 | $1,248.50 | $361.97 | $1,610.46 | $299,277.57 | |

Nov, 2023 | 3 | $1,246.99 | $363.48 | $1,610.46 | $298,914.09 | |

Dec, 2023 | 4 | $1,245.48 | $364.99 | $1,610.46 | $298,549.10 | |

Jan, 2024 | 5 | $1,243.95 | $366.51 | $1,610.46 | $298,182.59 | |

Feb, 2024 | 6 | $1,242.43 | $368.04 | $1,610.46 | $297,814.56 | |

Mar, 2024 | 7 | $1,240.89 | $369.57 | $1,610.46 | $297,444.99 | |

Apr, 2024 | 8 | $1,239.35 | $371.11 | $1,610.46 | $297,073.87 | |

May, 2024 | 9 | $1,237.81 | $372.66 | $1,610.46 | $296,701.22 | |

Jun, 2024 | 10 | $1,236.26 | $374.21 | $1,610.46 | $296,327.01 | |

Jul, 2024 | 11 | $1,234.70 | $375.77 | $1,610.46 | $295,951.24 | |

Aug, 2024 | 12 | $1,233.13 | $377.33 | $1,610.46 | $295,573.90 | |

Sep, 2024 | 13 | $1,231.56 | $378.91 | $1,610.46 | $295,195.00 | |

Oct, 2024 | 14 | $1,229.98 | $380.49 | $1,610.46 | $294,814.51 | |

Nov, 2024 | 15 | $1,228.39 | $382.07 | $1,610.46 | $294,432.44 | |

Dec, 2024 | 16 | $1,226.80 | $383.66 | $1,610.46 | $294,048.78 | |

Jan, 2025 | 17 | $1,225.20 | $385.26 | $1,610.46 | $293,663.52 | |

Feb, 2025 | 18 | $1,223.60 | $386.87 | $1,610.46 | $293,276.65 | |

Mar, 2025 | 19 | $1,221.99 | $388.48 | $1,610.46 | $292,888.17 | |

Apr, 2025 | 20 | $1,220.37 | $390.10 | $1,610.46 | $292,498.07 | |

May, 2025 | 21 | $1,218.74 | $391.72 | $1,610.46 | $292,106.35 | |

Jun, 2025 | 22 | $1,217.11 | $393.36 | $1,610.46 | $291,712.99 | |

Jul, 2025 | 23 | $1,215.47 | $394.99 | $1,610.46 | $291,318.00 | |

Aug, 2025 | 24 | $1,213.83 | $396.64 | $1,610.46 | $290,921.36 | |

Sep, 2025 | 25 | $1,212.17 | $398.29 | $1,610.46 | $290,523.07 | |

Oct, 2025 | 26 | $1,210.51 | $399.95 | $1,610.46 | $290,123.12 | |

Nov, 2025 | 27 | $1,208.85 | $401.62 | $1,610.46 | $289,721.50 | |

Dec, 2025 | 28 | $1,207.17 | $403.29 | $1,610.46 | $289,318.21 | |

Jan, 2026 | 29 | $1,205.49 | $404.97 | $1,610.46 | $288,913.23 | |

Feb, 2026 | 30 | $1,203.81 | $406.66 | $1,610.46 | $288,506.57 | |

Mar, 2026 | 31 | $1,202.11 | $408.35 | $1,610.46 | $288,098.22 | |

Apr, 2026 | 32 | $1,200.41 | $410.06 | $1,610.46 | $287,688.16 | |

May, 2026 | 33 | $1,198.70 | $411.76 | $1,610.46 | $287,276.40 | |

Jun, 2026 | 34 | $1,196.98 | $413.48 | $1,610.46 | $286,862.92 | |

Jul, 2026 | 35 | $1,195.26 | $415.20 | $1,610.46 | $286,447.72 | |

Aug, 2026 | 36 | $1,193.53 | $416.93 | $1,610.46 | $286,030.78 | |

Sep, 2026 | 37 | $1,191.79 | $418.67 | $1,610.46 | $285,612.11 | |

Oct, 2026 | 38 | $1,190.05 | $420.41 | $1,610.46 | $285,191.70 | |

Nov, 2026 | 39 | $1,188.30 | $422.17 | $1,610.46 | $284,769.53 | |

Dec, 2026 | 40 | $1,186.54 | $423.93 | $1,610.46 | $284,345.61 | |

Jan, 2027 | 41 | $1,184.77 | $425.69 | $1,610.46 | $283,919.92 | |

Feb, 2027 | 42 | $1,183.00 | $427.47 | $1,610.46 | $283,492.45 | |

Mar, 2027 | 43 | $1,181.22 | $429.25 | $1,610.46 | $283,063.21 | |

Apr, 2027 | 44 | $1,179.43 | $431.03 | $1,610.46 | $282,632.17 | |

May, 2027 | 45 | $1,177.63 | $432.83 | $1,610.46 | $282,199.34 | |

Jun, 2027 | 46 | $1,175.83 | $434.63 | $1,610.46 | $281,764.71 | |

Jul, 2027 | 47 | $1,174.02 | $436.45 | $1,610.46 | $281,328.26 | |

Aug, 2027 | 48 | $1,172.20 | $438.26 | $1,610.46 | $280,890.00 | |

Sep, 2027 | 49 | $1,170.37 | $440.09 | $1,610.46 | $280,449.91 | |

Oct, 2027 | 50 | $1,168.54 | $441.92 | $1,610.46 | $280,007.98 | |

Nov, 2027 | 51 | $1,166.70 | $443.76 | $1,610.46 | $279,564.22 | |

Dec, 2027 | 52 | $1,164.85 | $445.61 | $1,610.46 | $279,118.60 | |

Jan, 2028 | 53 | $1,162.99 | $447.47 | $1,610.46 | $278,671.13 | |

Feb, 2028 | 54 | $1,161.13 | $449.34 | $1,610.46 | $278,221.80 | |

Mar, 2028 | 55 | $1,159.26 | $451.21 | $1,610.46 | $277,770.59 | |

Apr, 2028 | 56 | $1,157.38 | $453.09 | $1,610.46 | $277,317.50 | |

May, 2028 | 57 | $1,155.49 | $454.98 | $1,610.46 | $276,862.53 | |

Jun, 2028 | 58 | $1,153.59 | $456.87 | $1,610.46 | $276,405.66 | |

Jul, 2028 | 59 | $1,151.69 | $458.77 | $1,610.46 | $275,946.88 | |

Aug, 2028 | 60 | $1,149.78 | $275,946.88 | $277,096.66 | $0.00 |

The **balloon loan calculator** offers a downloadable and printable loan amortization schedule with balloon payment that you can view and download as a PDF file. Simply enter the mortgage, loan terms, interest rate, and the balloon payment due to get started.

A balloon mortgage is a short-term mortgage, usually 5 to 10 years, but the payment is amortized based on a 30-year term. Borrowers are expected to pay off the mortgage after this period. Before the balloon payment is due, borrowers make regular monthly payments which are relatively small compared to the balloon payment that will be due later. Balloon mortgages are used for both residential and commercial properties and are common for commercial mortgages and business loans. Balloon mortgages are also available for auto loans although less common.

The balloon mortgage is designed to have lower monthly mortgage payments in exchange for making a big lump sum after certain years. Lenders expect the borrowers to repay the loan in the form of a balloon payment after the initial 5 - 10 years. For example, if a balloon payment is for 5 years, borrowers will make regular monthly payments for 4 years and 11 months, and then pay off the outstanding balance in the last payment.

There are many advantages and disadvantages of a balloon mortgage, following are the pros and cons.

**Lower monthly payment**- borrowers make a low monthly payment before the balloon payment is due.**Buy a house sooner**- balloon mortgages give borrowers to buy a house sooner since they will be making much smaller monthly payments before the balloon payment is due. Borrowers who expect to increase their income significantly such as a big bonus from work, salary jump, returns from another investment, or receiving an inheritance can take advantage of a balloon mortgage.**Short-term loan**- if you are planning to sell the house in a few years, it makes sense to get a short-term loan rather than a 30-year fixed mortgage.**Option to refinance**- if you are not able to make the balloon payment when it is due, you can refinance the mortgage into a longer-term mortgage.**Faster processing time**- unlike a traditional mortgage where it takes much longer to process, underwrite and approve, balloon mortgages usually have a shorter processing time.

**Large lump-sum payment**- The lump-sum payment that borrowers are required to pay is large when it is due.**Losing your house**- If borrowers cannot afford to pay the balloon payment, they face the risk of losing their house. Lenders will put the house in foreclosure if borrowers cannot repay their mortgage.**Higher interest rate**- since balloon payments are short term loans, the interest rate is higher than a conventional 30 year mortgage.**Build equity slowly**- Since the monthly payment is lower, the principal payment will also be lower, which means borrowers are building equity on their house much slower.**Need more money**- If circumference changes such as job loss or income cut, borrowers may not be able to pay off the balloon payment. They may need to borrow more money in the future to cover the payment for the balloon payment.

The balloon payment is calculated just like a regular mortgage or loan payment except for the last balloon payment. The balloon payment formula is given below.
**A = (P x i) / (1 - 1 / (1 + i)^ n))**
A = monthly payment
P = the mortgage amount
i = monthly interest rate in decimal
n = the number of months of the term
The above formula calculates the regular monthly payment for the balloon mortgage. At the end of the nth month, borrowers are required to pay back the outstanding mortgage amount.

Let's take a look at an example of how to calculate balloon payment. A $250,000 mortgage with 5% interest, a 30-year term, and the balloon payment is due in 5 years.
Mortgage - $250,000
Interest Rate - 5%
Term = 30 years
Balloon Payment Due = 5 years
Following the formula above, we get
**A = (P x i) / (1 - 1 / (1 + i)^ n)),**
Since we need to use the monthly interest rate in decimal form, we have to first divide the interest rate by 12 and 100. We also need to use the loan terms in months instead of years. Therefore,
**i = i / 12/ 100**
**n = 30 x 12 = 360**
A = 250,000 x 5/12/100/(1 - 1/(1 + 5/12/100) ^ 360)
A = 250,000 x 0.004167/(1 - 1/(1 + 0.004167) ^ 360)
A = 1,041.67/(1 - 1/1.004167^360)
A = 1,041.67/(1- 1/4.46828)
A = 1,041.67/(1 - 0.2238)
A = 1,041.67/(0.7762)
A = 1,342.05
Hence, $1,342.05 will be the monthly payment for the first 59 months, and borrowers will need to pay off whatever outstanding amount is left in month 60 when the balloon payment is due.
In this case, the outstanding balance is $230,913.88 after 5 years. You can use the balloon mortgage payment calculator to calculate the balance. In addition, you will get the monthly payment and the amortization schedule with balloon payment.

The balloon mortgage calculator can be used to calculate any type of balloon loan or mortgage payment. For conventional loans, please use the simple loan calculator or the advanced mortgage calculator. Following are the definitions of the balloon mortgage calculator.
**Mortgage Amount** - The mortgage that a borrower plans to take out.
**Loan Terms** - The number of years the balloon mortgage is based on.
**Balloon Payment Due** - In how many years is the borrower expected to pay off the outstanding balance.
**First Payment Date** - Borrowers are free to choose when the first payment date be. It could be a date from the past, present, or future.

The above example shows a **5 year balloon mortgage calculator** that calculates balloon payments for 5 years. You can change the year to any number of years and calculate the balloon payment. This balloon mortgage calculator does not come with extra payments. You will need to use our regular mortgage calculator with PMI and extra payments for extra payments.

**15 year balloon mortgage calculator** calculates balloon payments for 15 years. Simply change the number of years to 15 and you will get the monthly payment information for the first 15 years with a big payment at the end of the term.

Check Today's Mortgage Rates

Today's Home Equity Rates

### Mortgage Calculators

### Refinance Calculators

### Early Mortgage Payoff Calculators

### Real Estate Investment Calculators

### Mortgage Related Calculators

### Auto Loan Calculators

### Loan Calculators

### Savings & Investments Calculators

### Credit Card Calculators

### Mortgage Guide

### Mortgage Calculator Widget

Today's Home Equity Rates

- Commercial Mortgage Calculator
- Mortgage Comparison Calculator
- 15 Year vs. 30 Year Mortgage Calculator
- Investment Property Calculator
- Home Improvement Loan Calculator
- Home Sale Net Proceeds Calculator
- Closing Costs Calculator
- Construction Loan Calculator
- Home Appreciation Calculator
- Real Estate Commission Calculator
- Commercial Real Estate Commission Calculator
- BRRRR Calculator
- Hard Money Loan Calculator
- 70% Rule Calculator
- Piggyback Loan Calculator
- Bridge Loan Calculator
- Seller Financing Calculator
- Real Estate Wholesaling Calculator
- Fix and Flip Calculator
- Interest Rate Calculator
- Home Sale Calculator
- Real Estate Capital Gain Tax Calculator

- Mortgage Interest Tax Deduction Calculator
- APR Calculator
- Property Tax Calculator
- Down Payment Calculator
- Mortgage Affordability Calculator
- Mortgage Balance Calculator
- Mortgage Points Break Even Calculator
- Jumbo Mortgage Calculator
- Mortgage Calculator App
- Monthly Mortgage Payment Calculator
- Reverse Mortgage Calculator
- How Much House Can I Afford
- Mortgage Prequalification Calculator
- HELOC Calculator
- HELOC Payment Calculator
- HELOC Payoff Calculator
- PMI Removal Calculator
- Home Equity Loan Calculator
- Home Equity Loan Payoff Calculator
- Home Equity Calculator
- Mortgage Insurance Calculator
- Amortization Schedule With Irregular Payments
- 15 Year Mortgage Calculator
- 30 Year Mortgage Calculator
- Manufactured Home Mortgage Calculator
- Condo Mortgage Calculator
- Coop Mortgage Calculator
- Weekly Mortgage Calculator
- Mortgage Calculator Canada
- Mortgage Calculator UK
- Mortgage Calculator By State
- Refinance Savings Calculator
- Mortgage Interest Calculator
- Mobile Home Mortgage Calculator
- Rent Vs. Buy Calculator

- Car Loan Amortization Schedule Excel
- Auto Loan Payoff Calculator
- Auto Loan Calculator with Trade in
- Auto Refinance Calculator
- Biweekly Auto Loan Calculator
- RV Loan Calculator
- Motorcycle Loan Calculator
- Car Lease Calculator
- Car Depreciation Calculator
- LTV Calculator Auto
- Reverse Auto Loan Calculator
- How Much Car Can I Afford

- Printable Amortization Schedule
- Amortization Schedule Excel
- Amortization Schedule With Extra Payments
- LTV Calculator
- Debt To Income Ratio Calculator
- Debt Payoff Calculator
- How Much Rent Can I Afford
- Boat Loan Calculator
- Student Loan Calculator
- Student Loan Payoff Calculator
- Student Loan Refinancing Calculator
- Personal Loan Calculator
- Personal Loan Payoff Calculator
- Personal Loan Refinance Calculator
- Land Loan Calculator
- Loan Payoff Calculator
- Loan Calculator Excel
- Reverse Loan Calculator
- Lump Sum Payment Calculator
- Biweekly Loan Calculator
- Loan Calculator With Extra Payments

Mortgage Calculator | Amortization Schedule | Terms | Privacy | Disclaimer | Contact

©2023 **Mortgage Calculator Excel**