 |
| Home | Mortgage Calculator | Car Loan Calculator | Recast Calculator | HELOC Calculator | Refinance Calculator | Excel |
Balloon Mortgage Calculator With Amortization Schedule
Balloon Mortgage Calculator With Amortization Schedule excel is used to calculate monthly payment for your balloon mortgage. The balloon loan calculator comes with an amortization schedule that shows each of your monthly payment and the final balloon payment.
Balloon Mortgage Calculator Results |
|
Monthly Payment: |
$1,411.64 |
Balloon Payment: |
$232,409.51 |
Total Principal Paid: |
$250,000.00 |
Total Interest Paid: |
$65,696.25 |
Total Payment: |
$315,696.25 |
Balloon Loan Amortization Schedule |
||||||
| Payment Date | Payment # | Interest Paid | Principal Paid | Total Payment | Remaining Balance | |
|---|---|---|---|---|---|---|
| Jan, 2023 | 1 | $1,135.42 | $276.22 | $1,411.64 | $249,723.78 | |
| Feb, 2023 | 2 | $1,134.16 | $277.48 | $1,411.64 | $249,446.30 | |
| Mar, 2023 | 3 | $1,132.90 | $278.74 | $1,411.64 | $249,167.56 | |
| Apr, 2023 | 4 | $1,131.64 | $280.00 | $1,411.64 | $248,887.56 | |
| May, 2023 | 5 | $1,130.36 | $281.28 | $1,411.64 | $248,606.28 | |
| Jun, 2023 | 6 | $1,129.09 | $282.55 | $1,411.64 | $248,323.73 | |
| Jul, 2023 | 7 | $1,127.80 | $283.84 | $1,411.64 | $248,039.89 | |
| Aug, 2023 | 8 | $1,126.51 | $285.13 | $1,411.64 | $247,754.77 | |
| Sep, 2023 | 9 | $1,125.22 | $286.42 | $1,411.64 | $247,468.35 | |
| Oct, 2023 | 10 | $1,123.92 | $287.72 | $1,411.64 | $247,180.63 | |
| Nov, 2023 | 11 | $1,122.61 | $289.03 | $1,411.64 | $246,891.60 | |
| Dec, 2023 | 12 | $1,121.30 | $290.34 | $1,411.64 | $246,601.26 | |
| Jan, 2024 | 13 | $1,119.98 | $291.66 | $1,411.64 | $246,309.60 | |
| Feb, 2024 | 14 | $1,118.66 | $292.98 | $1,411.64 | $246,016.62 | |
| Mar, 2024 | 15 | $1,117.33 | $294.31 | $1,411.64 | $245,722.30 | |
| Apr, 2024 | 16 | $1,115.99 | $295.65 | $1,411.64 | $245,426.65 | |
| May, 2024 | 17 | $1,114.65 | $296.99 | $1,411.64 | $245,129.66 | |
| Jun, 2024 | 18 | $1,113.30 | $298.34 | $1,411.64 | $244,831.31 | |
| Jul, 2024 | 19 | $1,111.94 | $299.70 | $1,411.64 | $244,531.62 | |
| Aug, 2024 | 20 | $1,110.58 | $301.06 | $1,411.64 | $244,230.56 | |
| Sep, 2024 | 21 | $1,109.21 | $302.43 | $1,411.64 | $243,928.13 | |
| Oct, 2024 | 22 | $1,107.84 | $303.80 | $1,411.64 | $243,624.33 | |
| Nov, 2024 | 23 | $1,106.46 | $305.18 | $1,411.64 | $243,319.15 | |
| Dec, 2024 | 24 | $1,105.07 | $306.57 | $1,411.64 | $243,012.59 | |
| Jan, 2025 | 25 | $1,103.68 | $307.96 | $1,411.64 | $242,704.63 | |
| Feb, 2025 | 26 | $1,102.28 | $309.36 | $1,411.64 | $242,395.27 | |
| Mar, 2025 | 27 | $1,100.88 | $310.76 | $1,411.64 | $242,084.51 | |
| Apr, 2025 | 28 | $1,099.47 | $312.17 | $1,411.64 | $241,772.34 | |
| May, 2025 | 29 | $1,098.05 | $313.59 | $1,411.64 | $241,458.75 | |
| Jun, 2025 | 30 | $1,096.63 | $315.01 | $1,411.64 | $241,143.74 | |
| Jul, 2025 | 31 | $1,095.19 | $316.45 | $1,411.64 | $240,827.29 | |
| Aug, 2025 | 32 | $1,093.76 | $317.88 | $1,411.64 | $240,509.41 | |
| Sep, 2025 | 33 | $1,092.31 | $319.33 | $1,411.64 | $240,190.08 | |
| Oct, 2025 | 34 | $1,090.86 | $320.78 | $1,411.64 | $239,869.30 | |
| Nov, 2025 | 35 | $1,089.41 | $322.23 | $1,411.64 | $239,547.07 | |
| Dec, 2025 | 36 | $1,087.94 | $323.70 | $1,411.64 | $239,223.37 | |
| Jan, 2026 | 37 | $1,086.47 | $325.17 | $1,411.64 | $238,898.21 | |
| Feb, 2026 | 38 | $1,085.00 | $326.64 | $1,411.64 | $238,571.56 | |
| Mar, 2026 | 39 | $1,083.51 | $328.13 | $1,411.64 | $238,243.44 | |
| Apr, 2026 | 40 | $1,082.02 | $329.62 | $1,411.64 | $237,913.82 | |
| May, 2026 | 41 | $1,080.53 | $331.11 | $1,411.64 | $237,582.70 | |
| Jun, 2026 | 42 | $1,079.02 | $332.62 | $1,411.64 | $237,250.09 | |
| Jul, 2026 | 43 | $1,077.51 | $334.13 | $1,411.64 | $236,915.96 | |
| Aug, 2026 | 44 | $1,075.99 | $335.65 | $1,411.64 | $236,580.31 | |
| Sep, 2026 | 45 | $1,074.47 | $337.17 | $1,411.64 | $236,243.14 | |
| Oct, 2026 | 46 | $1,072.94 | $338.70 | $1,411.64 | $235,904.44 | |
| Nov, 2026 | 47 | $1,071.40 | $340.24 | $1,411.64 | $235,564.20 | |
| Dec, 2026 | 48 | $1,069.85 | $341.79 | $1,411.64 | $235,222.41 | |
| Jan, 2027 | 49 | $1,068.30 | $343.34 | $1,411.64 | $234,879.07 | |
| Feb, 2027 | 50 | $1,066.74 | $344.90 | $1,411.64 | $234,534.18 | |
| Mar, 2027 | 51 | $1,065.18 | $346.46 | $1,411.64 | $234,187.71 | |
| Apr, 2027 | 52 | $1,063.60 | $348.04 | $1,411.64 | $233,839.68 | |
| May, 2027 | 53 | $1,062.02 | $349.62 | $1,411.64 | $233,490.06 | |
| Jun, 2027 | 54 | $1,060.43 | $351.21 | $1,411.64 | $233,138.85 | |
| Jul, 2027 | 55 | $1,058.84 | $352.80 | $1,411.64 | $232,786.05 | |
| Aug, 2027 | 56 | $1,057.24 | $354.40 | $1,411.64 | $232,431.65 | |
| Sep, 2027 | 57 | $1,055.63 | $356.01 | $1,411.64 | $232,075.64 | |
| Oct, 2027 | 58 | $1,054.01 | $357.63 | $1,411.64 | $231,718.01 | |
| Nov, 2027 | 59 | $1,052.39 | $359.25 | $1,411.64 | $231,358.75 | |
| Dec, 2027 | 60 | $1,050.75 | $231,358.75 | $232,409.51 | $0.00 | |
Amortization Schedule With Balloon Payment
Amortization schedule with balloon payment is useful for borrowers who need to calculate short term ballon loans. The balloon loan amortization schedule excel is downloadable.
What is a balloon mortgage?
A balloon mortgage is a mortgage where the borrower is allowed to make low or interest-only payments initially and at the end, he is required to pay off the full balance in a lump sum. Balloon mortgages are usually for short-term borrowers who are expected to pay the lump sum in 5 to 7 years. The interest rate is usually lower in the initial period compared to a fixed 30-year mortgage making them useful for homeowners who are only planning to stay in their homes for a short period of time. The homeowners are not looking to stay in the same house for 30 years. However, a balloon mortgage could be risky as the lump sum payment due at the end of the term is a huge amount compared to the regular monthly payments.
Balloon mortgage pros and cons?
There are benefits and disadvantages of getting a balloon mortgage, following are the balloon mortgage pros and cons.
Pros of a balloon mortgage
Lower Monthly Payment - The monthly payment is lower for balloon mortgages because their interest rate is usually lower during the initial period than a fixed-interest mortgage or variable-interest mortgage. Lower Overall Costs - The costs for financing a balloon mortgage are much lower than a traditional mortgage with a 30-year term because the mortgage is much shorter and borrowers will pay less in interest payments. Planning to Move - A balloon mortgage is useful for homeowners that are planning to move or relocate in a few years. There is no reason to pay higher fees and higher monthly payments for a traditional mortgage when these borrowers are looking to sell their house in a few years. Rising Income - Borrowers who expect their income to rise sharply in the coming years may consider a balloon mortgage. They can take advantage of the lower monthly payment initially and then refinance before the balloon payment is due. With their rising income, they will be able to afford a higher monthly payment after refinancing their mortgage. A balloon mortgage allows these buyers to buy a house that they cannot otherwise afford. As with anything else in life, when something sounds too good to be true, there are drawbacks to a balloon mortgage.
Cons of a balloon mortgage
Large Lump Sum Payment - After the initial low monthly payment is over, borrowers are faced with large lump sum payments to pay off the mortgage at once. High Risk - If a borrower is counting on a rising income or a bonus from work to afford the large lump sum payment when it comes due, he could lose his home if his salary doesn't rise enough to afford the payment. Even worse, if he loses his job, not only he won't be able to afford the large payment, he won't be able to refinance it either. The house could be foreclosure. Building Equity Slowly - With a low monthly payment, homeowners are building equity slowly. Harder to Refinance - Lenders may not be willing to refinance a balloon mortgage when the balloon payment is due unless the homeowner has good equity in their house. Since homeowners are building equity slowly by making minimum payments on their balloon mortgage, lenders may decline their application for refinancing. Even if the borrower finds a lender who is willing to refinance his mortgage, the interest rate may be high. Declining House Price - In an environment where house price is declining, the borrower may owe more on their mortgage than the value of his home. This is especially troublesome when the borrower is planning to refinance his mortgage when the balloon payment is due.
Loan Calculator
Boat Loan Calculator
15 Year
30 Year
Annual Amortization Calculator
Amortization Calculator
Biweekly Mortgage Calculator
Weekly Amortization Schedule
Extra Payment Loan Calculator
Reverse Mortgage Calculator
Balloon Loan Calculator
Refinance Calculator
Cash Out Refinance Calculator
Recasting Calculator
HELOC Loan Calculator
USDA Loan Calculator
VA Loan Calculator
FHA Loan Calculator
Loan Payoff Calculator
Land Loan Calculator
Interest Only Loan Calculator
Payment Calculator
Credit Card Calculator
Amortization Table
Amortization Chart
Personal Loan Amortization Calculator
RV Loan Calculator
Student Loan Calculator
Commercial Loan Calculator
Construction Loan Calculator
Mortgage Amortization Calculator
Mortgage Points Calculator
ARM Mortgage Calculator
How Much House Can I Afford
Home Equity Loan Calculator
Amortization Schedule Excel
Amortization Schedule | Terms | Privacy | Disclaimer | Contact
©2023 Amortization Schedule