WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Loan Prequalification Calculator

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

Loan Prequalification Calculator

Loan Prequalification Calculator can be used to calculate the Prequalification amount that the borrower would be able to borrow provided his annual income and his other factors such as whether any down payment would be made or any existing loans etc.

Loan Prequalification Calculator

L x [1 – (1+i)-n / i]


Wherein,
  • L is the Proposed Payment
  • n is the frequency of payments
  • i is the rate of interest
Proposed Payment
$
frequency of payments
ROI
%

About Loan Prequalification Calculator

The formula for calculating Loan prequalification that most of the financial institution use is given below:

Now one can determine the monthly installment that borrower can repay by deducting the debt portion and savings required, a post that uses the below formula for calculating Loan prequalification that can be recommended to borrow.

Loan Amount = L * (1 – (1+i)-n / i)

The formula to calculate GDPI Ratio that most of the financial institution use as one of the criteria is per below:

D / GPI * 100

Wherein,

  • D is the total debt payment per period, including the proposed loan repayment amount
  • GPI is the gross Periodical Income
  • PV is the present value of loan recommendation
  • L is the Proposed Payment
  • n is the frequency of payments
  • i is the rate of interest

There is no one mathematical formula that can determine the pre-qualification loan amount as it is based on quantitative and qualitative factors such as Debt to income ratio, which should be ideally less than 36%, then if any down payment is to be made by the borrower, or any default has been made by the borrower or the security that has been offered.

All these qualitative factors will be based on case to case basis and also depending upon the rules of the bank. This will also depend upon for what tenure is the borrower looking for the repayment as longer the duration, the riskier it becomes for the bank and accordingly impacts the loan amount or rate of interest. Further, the credit score and any existing loans also determine the loan amount.

How to Calculate Using Loan Prequalification Calculator?

One needs to follow the below steps in order to calculate the loan amount.

Step #1 – First of all, determine the funds required by the borrower and the term for which he is ready for.

Step #2- Check the terms and conditions and rules of the financial institution through which the loan is sought after.

Step #3 – Determine whether the borrower meets those qualitative requirements such as security needed, if any, number of dependents compliance, nature of income, payment for existing debts, number of sources of income, etc. This will depend on case to case, as stated earlier.

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

Step #4 – Now, do the quantitative calculations, such as calculating the periodical existing payments made by the borrower and the new periodical installments due to new loans.

Step #5 – Calculate the gross periodical income of the borrower, including all the sources of income.

Step #6 – Now divide the value arrived in step 4 by the value arrived in step 5, which shall yield the Debt to Income ratio that should be ideally less than 36% but again, it depends upon bank to bank.

Step #7 – Now calculate the monthly installment that the borrower is ready to pay from his GPI and deduct the debt and savings he wishes to keep.

Step #8 – Now use the present value formula to determine what loan amount would be eligible for the borrower to borrow.

You can download this Loan Prequalification Calculator Excel Template here – Loan Prequalification Calculator Excel Template

Example

Mr. Christopher is a qualified accountant and has been working in a multinational company for a couple of years and is now looking to borrow mortgage loans. His credit score has been in a range of 721 to 745 as the date of application of the loan. He will be providing his home as security to the bank, which values around $120,000. His loan requirement is $200,000.

He wants the tenure to be for 20 years and wants to make monthly payments of installments. Currently, he has $455 as his existing debt payment and, he has a credit debt of $5,000 as outstanding. He is ready to make a down payment of up to 20% of the value of the property. The bank has lain down below terms and conditions in order to know the eligible loan amount that Mr. Christopher can borrow.

Loan Prequalification Bank Details

The Bank’s marginal cost of the capital rate at the moment is 6.95%. Mr. Christopher wants to make payment of debt $455 towards debt, and he wants $500 out of his gross income to spend for home expenditure and the rest he can pay for mortgage debt. He currently earns $2,000 on a monthly basis.

Based on the given information, you are required to recommend what loan amount he can borrow and whether it meets its requirement of funds?

Solution:

We need to calculate the rate of interest first, which shall be applied towards his loan.

Below is the calculation of the same.

Loan Prequalification (Given Data)

We shall now determine what is the net income of Mr. Christopher before the proposed new debt payment.

$2,000 is his gross income, less existing debt payment $455, and $500 towards the home expenditure, and hence remaining net income would be $1,045, which he can use to pay the installment amount on the proposed loan.

Loan Prequalification Example 1

The Proposed installment amount will be the existing debt, which is $455, and the desire installment amount will be $2,000, less $455, and less $500 towards a home, which is $1,54,5 and we can use the below formula to calculate DGPI ratio.

DGPI Ratio = D / GPI * 100

Loan Prequalification Example 1-1

  • = ($455 + $1,045) / $2,000 x 100
  • =75%

Because of this loan amount will impact which we will calculate later on.

We now have a rate of interest as 6.95%, and if compounded monthly, then the rate would be 6.95%/12, which is 0.58%

Loan Amount Recommended = L * (1 – (1+i)-n / i)

Loan Prequalification Example 1-2

  • = 1,045 * [1 – (1+0.58%)-20*12 / 0.58%]
  • = $135,310.02

The desired loan will be reduced by 35% as his DGPI is greater than 36%, which shall be $200,000 x ( 1 – 0.35), which is $130,000

Desired loan Example 1-3

Since his credit score is in the range of 721 to 745, he can avail 95% of the loan. Hence net loan that will be offered by a bank is $130,000 x 95%, which is $123,500

Net Loan Example 1-4

Now, as per the quantitative requirement, he can avail loan of up to $135,310.02, whereas Bank will offer a net $123,500 only per qualitative and quantitative requirements and the difference he would need to arrange by himself or he can consider another bank for a loan.

Conclusion

As seen above, this is a multifaceted issue and cannot be just determined only on the basis of a formula that how much one can borrow. Both qualitative and quantitative rules apply, as discussed in the above example.

Recommended Articles

This has been a guide to the Loan Prequalification Calculator. Here we provide you the calculator that is used to calculate the Prequalification amount that the borrower would be able to borrow with an example. You may also take a look at the following useful articles –

  • Debt Consolidation Calculator
  • Calculate Car Down Payment
  • Auto Refinance Payment Calculator
  • Balloon Mortgage Payment 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 Loan Prequalification Calculator Excel Template

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