WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Financial Calculators » Home Equity Loan Calculator

Home Equity Loan Calculator

Home Equity Loan Calculator

This home equity loan calculator helps you calculate home equity that can be used by the owner to borrow more funds in case you have future funds requirement, and if the bank is asking for collateral or security.

Home Equity Value

MV - OP


Wherein,
  • MV is the Market Value of the home or the property in question
  • OP is the outstanding principal balance of the loan that was taken for the property
Market Value of the home
$
outstanding principal balance of the loan
$

About Home Equity Loan Calculator

The home equity loan can be defined as the variance or difference between the current market value of the property and the outstanding loan balance, which was taken against it. The formula is per below:

Home Equity Value = MV – OP

Wherein,

  • MV is the Market Value of the home or the property in question
  • OP is the outstanding principal balance of the loan that was taken for the property

How to Calculate using Home Equity Loan Calculator?

The following steps need to be followed to calculate home equity.

Step #1 – First of all, find out the outstanding loan balance, which was taken specifically for the property in question.

Step #2 –  Now figure out the value of the property, which is nothing but the current market value of the property.

Step #3 – Now, subtract the value arrived in step 2 from the value arrived in step 1; the resulting figure would be the value of home equity.

You can download this Home Equity Loan Calculator Excel Template here – Home Equity Loan Calculator Excel Template

Home Equity Loan Calculator Example

Example #1

Mr. Kofi had purchased a house for $123,500 around 5 years ago with fully financed by the bank since he had a good credit score. The rate of interest was 6%, and the mortgage was for 15 years, and the current monthly installment he is paying is $1,042.16. The house measures 1000. Sq ft and the current market price of the property located in the same is $250 per Sq. Ft. Based on the given information; you are required to calculate the value of home equity.

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

Solution:

  • As a first step, we shall calculate the outstanding mortgage balance for the property in question.
  • Rate of interest applicable on monthly basis = 6.00% / 12 = 0.50%

Home equity calculator example 1 (Montly Rate)

  • The remaining period will be (15 x 12) – (5 x 12), which is 180 – 60, that is 120.

Home equity calculator example 1 (Outstanding loan tenture)

We need to calculate the present value of the current outstanding balance which can be calculated per below formula:

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

Home equity calculator example 1 (Outstanding Debt balance)

= $1,042.16 x [1 – (1+0.50%)-120 / 0.50%]

= $93,871.24

The outstanding debt on the property is $93,871.24.

Now we need to calculate the current market value of the property, which we are given on a per sq ft basis. The value is $250 per sq. ft. and total sq. ft. of the property is 1,000, and hence the current market value of the property is 1,000 x 250, which is $250,000.

Now we can use the below formula to calculate the value of home equity

Home Equity Value = MV – OP

Home equity calculator example 1 (Home Equity Value)

= 250,000 – 93,871.24

= 1,56,128.76

Since the value of the property has increased substantially and 1/3rd of the principal repayment is done, the owner is in a good position to repay the loan, and further, the worry of lender would be less as the property value is more than the loan.

Example #2

Mr. JBL has been recently met with a financial crunch and is already repaying the debt on his mortgage property for $1,231.66 when he got a loan for 95%, which was for $147,250, and the rate that was applied on loan was 8%, and it was taken for 20 years period. He is yet to pay for 10 years, and he has approached the bank to provide additional loans to him on the basis of home equity value. He has a requirement of $100,000, and the bank agrees to provide his loan for 85% of the home equity, which would be calculated. The value of the property has increased by 30% since last he purchased. On the basis of the given information, you are required to calculate whether funds required by Mr. JBL would finance fully by the bank, or he needs to resort to unsecured debt for any shortfall.

Solution:

  • As a first step, we shall calculate the outstanding mortgage balance for the property in question.
  • Rate of interest applicable on monthly basis = 8.00% / 12 = 0.67%

Home equity calculator example 2 (Monthly Rate)

  • The remaining period will be (20 x 12) – (10 x 12), which is 240 – 120, which is 120.

Example 2 (outstanding loan tenture)

We need to calculate the present value of the current outstanding balance which can be calculated per below formula:

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

Example 2 (outstanding debt balance)

= $1,231.66 x [1 – (1+0.67%)-120 / 0.67%]

= $101,515.08

The outstanding debt on the property is $ 101,515.08.

Now we need to calculate the current market value of the property, which we are given in % of the loan. A loan that was borrowed was $147,250, and it was financed by 95%. Therefore the value of the property will be $147,250 / 95%, which will be $155,000, and since then, it has increased by 30%. Therefore, the current market value of the property is $155,000 x (1+30%), which is $201,500.

Now we can use the below formula to calculate the value of home equity

Home Equity Value = MV – OP

example 2 (Home equity value)

= 201,500 – 101,515.08

= 99,984.92

  • Since the bank will finance only 85% of the home equity, which is 99,984.92 x 85%, that equals $84,987.19.

Example 2 (Funds financed by bank)

  • There is a shortfall for the funds required by Mr. JBL, and hence Mr. JBL needs to borrow funds from outside as unsecured debt, which is 100,000 – 84,987.19, which is $15,012.81

Example 2 (Unsecured Debt)

Conclusion

As discussed, the home equity loan calculator can be used to calculate the value of equity, which is the remaining value of the owner’s interest against which, if the owner desires, can borrow more funds against the same for his personal or any business use. If the value of home equity is quite high, the chances are that banks would easily fund 90% to 95% of the home equity, and if the case is opposite, then the bank would fund lower as below as 40% to 50%.

Recommended Articles

This has been a guide to Home Equity Loan Calculator. Here we provide you the calculator that is used to calculate the value of the home equity along with some examples for better understanding. You may also take a look at the following useful articles –

  • Gift of Equity Example
  • Auto Refinance Calculator
  • What are Prepayments?
  • Calculate Loan Principal
  • Compound Savings Calculator
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 Home Equity Loan Calculator Excel Template

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