WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Financial Calculators » Balloon Mortgage Calculator

Balloon Mortgage Calculator

By Harsh KataraHarsh Katara | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Balloon Mortgage Calculator

The Balloon Mortgage calculator is used to calculate the amount of balloon balance due at the end of the term of the loan. The formula to calculate a balloon balance is a similar formula that is used to calculate the outstanding balance on a mortgage loan.

Balloon Mortgage Calculator

PV x (1+r)n – P x [(1+r)n – 1 / r]


Wherein,
  • PV is the present value of Original Balance
  • P is the Payment
  • r is the rate of interest
  • n is the frequency of payments
Present Value of Original Balance
$
Payment
$
rate of interest
%
frequency of payments

How to Calculate?

One needs to follow the below steps in order to calculate the monthly installment amounts.

Step #1 – First, we will calculate the equal periodical installments assuming no balloon repayment, and we shall begin with the principal amount

P

Step #2 – Multiply the principal amount or the loan amount by a rate of interest.

PxR

Step #3 – Now, we need to compound the same by rate until the loan period.

Popular Course in this category
Sale
Financial Modeling Course (with 15+ Projects)
4.9 (927 ratings)
16 Courses | 15+ Projects | 90+ Hours | Full Lifetime Access | Certificate of Completion
View Course

PxRx(1+R)^N

Step #4 – We now need to discount the above result obtained in step 3 by the following:

N-1

Step #5 – After entering the above formula in excel, we shall obtain periodically installments, which are mostly monthly repayments.

Step #6 – Now, there would be a term wherein the loan would be required to pay in full. Take the Loan amount as Principal Value, installment amount as the payment, rate of interest, and insert the same in the above equation discussed above.

The resultant figure would be the balloon payment required to be made.

You can download this Balloon Mortgage Calculator Excel Template here – Balloon Mortgage Calculator Excel Template

Below are a few examples of the Balloon Mortgage Calculator.

Balloon Mortgage Examples

Example #1

Mr. Zee has taken a Balloon Mortgage loan, which states its term as 10/15, with an annual rate of 7.5% compounded monthly. The loan amount that was borrowed was $132,000. The monthly installment amount that Mr. Zee is supposed to pay comes around $1,223.66

Based on the above information, you are required to calculate the Balloon mortgage amount that shall be required to be paid at the end of the term.

Solution:

  • The term structure is the loan will be amortized for 15 years, and we need to find out what amount it shall pay at the end of 10 years as a lumpsum payment.
  • We can use the below formula to calculate the future value of the balloon payment to be made at the end of 10 years: FV = PV*(1+r)n–P*[(1+r)n–1/r]
  • The rate of interest per annum is 7.5%, and monthly it shall be 7.5%/12, which is 0.50%.

Balloon Mortgage Calculator Example #1

= 100,000*(1+0.50%)120–1,223.66 x [(1+0.50%)120–1/0.50%]

= 61,066.29

  • The remaining balance that shall be paid with the final payment will be $61,066.29, which is the balloon payment and has to pay at the end of 10 years.

Example #2

Company X wanted to buy new properties in a posh area in the city they operate in. But due to the recent hike in property prices, they are unwilling to invest a large amount. Hence, they opt for hiring the properties at lease. They were aware that if they hire property on lease, then the cash outflow will be too high for them. The market rate of interest at which they can borrow is 8%.

Further, they are anticipating higher cash flowers in the near future, say in the next 5 years, and they would be able to purchase the property. Henceforth, they decide to take it on lease and decide to purchase it after 5 years. The term structure of the loan is 5/12, and the value of the property is $270,000. Since the background of the company and directors is too good, they have been offered 100% financing. The monthly installment amount shall be 2,922.62

You are required to calculate the balloon payment that the company shall be required to be made at the end of 5 years, whereas a loan is amortized for 12 years?

Solution:

  • The term structure is the loan will be amortized for 12 years, and we need to find out what amount it shall pay at the end of 5 years as a lumpsum payment.
  • We can use the below formula to calculate the future value of the balloon payment to be made at the end of 5 years: FV = PV x (1+r)n – P x [ (1+r)n – 1 / r ]
  • The rate of interest per annum is 8.00%, and monthly it shall be 8.00%/12, which is 0.67%.

Balloon Mortgage Calculator Example #2

= 270,000 x (1+0.67%)60 – 2,922.62 x [ (1+0.67%)60 – 1 / 0.67% ]

= 187,513.27

  • The remaining balance that shall be paid with the final payment will be $187,513.27 which is the balloon payment and has to pay at the end of 5 years.

Conclusion

A balloon Mortgage calculator is generally seen in the mortgage market, and the benefit they have is that initially, the required lower payments. Balloon Mortgages can be preferable for those people or firms who have cash flow issues in the near-term, and further, they expect later somewhere in future higher cash flows when the payment for balloon would near. The borrower must be prepared at the end of the loan term to make their balloon payment

Recommended Articles –

This is a guide to Balloon Mortgage Calculator. Here we learn how to calculate the amount of balloon balance, which is due at the end of the term of the loan. You may learn more about finance from the following articles –

  • Calculate Mortgage with Taxes & Insurance
  • Auto Refinance Calculator
  • Formula of Mortgage
  • Mortgage APR vs Interest Rate
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Balloon Mortgage Calculator Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More