WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Auto Refinance Calculator

Auto Refinance Calculator

An Auto Refinance calculator finds out the new monthly installment when the earlier borrowed loan, which was at a higher rate, is refinanced at a lower rate

Auto Refinance Calculator

[P* R * (1+R)^N]/[(1+R)^N-1]


Wherein,
  • P is the loan amount
  • R is the rate of interest per annum
  • N is the number of period or frequency wherein loan amount is to be paid
The loan Amount
$
Rate of Interest per annum
%
Number of period or frequency wherein loan amount is to be paid

About Auto Refinance Calculator

The formula for calculating Auto Refinance is per below steps:

First, we need to find out the outstanding principal balance just before the rate changes.

Auto Refinance New Installment = [P* R * (1+R)^N]/[(1+R)^N-1]

Wherein,

  • P is the loan amount
  • R is the rate of interest per annum
  • N is the number of period or frequency wherein the loan amount is to be paid

Most of the auto loans are initially financed at a higher rate due to the nature of the product and due to the credibility of the borrower. The loans are generally financed for 1 year to 5 years. If the borrower pays his installments timely, say for 10 to 12 installments, then he might be eligible to refinance the loan at a lower rate of interest as his creditability might have improved.

Either the dealer offers to refinance the same by charging some commission or the borrower wishes to lower his periodical installment or, as discussed, credit score has improved.

How to Calculate the Monthly Payments in Auto Refinance?

One needs to follow the below steps in order to calculate the Mortgage Points benefits.

Step #1: First of all, find out the existing installment, the existing rate of interest, and an outstanding period of the loan.

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 #2: Either the dealer or the bank would have offered to refinance the auto loan at a lower rate of interest. Calculate the outstanding principal balance just before the new installment will begin.

Step #3: Beginning with the 3rd step, one needs to enter the outstanding loan amount, which is the outstanding principal amount:

P

Step #4: Multiply the principal by the new lower rate of interest.

PxR

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

PxRx(1+R)^N

Step #6: We now need to discount the above result obtained in step 5 by the following:

N-1 

You can download this Auto Refinance Calculator Excel Template here – Auto Refinance Calculator Excel Template

Auto Refinance Calculator Example

Mr. Jain had purchased a luxury bike around 3 years ago for $45,000. The loan financed for 90%, and the rate of interest that was applicable initially was 9.00%, and he had taken the loan for 5 years. His monthly installment was $840.71, and he repaid his installments without making any default and on a timely basis. The dealer offered Mr. Jain that his loan can be refinanced at a lower rate of interest, which shall reduce his interest outgo and also his monthly installments amount. He was ready to do that and was told that the new rate of interest would be 7.5% for the remaining period.

On the basis of the given information, you are required to calculate the new installment amount for the rest of the loan period and what would be his savings be.

Solution:

We will see the summary as to what information we are given here.

Auto Refinance Calculator - Example 1.1

Now we will first calculate the outstanding principal balance or the loan amount per below:

Mr. Jain has repaid installments until the end of 3 years, and hence the outstanding balance shall be:

Auto Refinance Calculator - Example 1.2

The new monthly rate of interest will be 7.50%/12, which is 0.63%, and the outstanding principal balance is 18,402.50 with a loan tenure of 2 years remaining, which is 24 months.

Auto Refinance Calculator - Example 1.3

At end of 3 years

New EMI = [P x R x (1+R)^N]/[(1+R)^N-1] 

Auto Refinance Calculator - Example 1.4

= [$18,402.50 x 0.63% x (1 + 0.63%)^24 ] / [ (1 + 0.63%)^24 – 1 ]

= $828.10

Monthly Savings

Auto Refinance Calculator - Example 1.5

  • Savings monthly = Existing EMI – New EMI
  • = $840.71 – $828.10
  • = $12.61 per month 

Total Savings During Rest of Tenure

Auto Refinance Calculator - Example 1.6

  • Total savings during rest of tenure = savings per month x remaining loan tenure in months
  • = $12.61 x 24
  • = $302.60

As the dealer stated, he is saving in interest, and his monthly installment amount has been reduced.

Conclusion

An auto can be used to calculate the savings that the borrower can make while he refinances his auto loan at a lower rate of interest either due to his credibility has been improved, the dealer provides him option after charging a commission, or the borrower wishes to reduce his monthly installments, but that might not be necessary at a lower rate of interest, but here the tenure of the loan would have increased.

Recommended Articles

This has been a guide to the Auto Refinance Calculator. Here we provide you the calculator that is used to calculate the new installments when auto loan refinances at a lower rate of interest along with the examples. You may also take a look at the following useful articles –

  • Auto Repair Invoice Excel Template
  • Calculate Down Payment for Car Loan
  • Refinancing Risk
  • Calculate Cost of Refinancing
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 Auto Refinance Calculator Excel Template

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