WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Additional Payment Calculator

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

About Additional Payment Calculator

An additional Payment calculator is a type of calculator wherein the borrower can determine if they quick up their payments or start paying an additional amount periodically, then how much would they save and how their balance loan tenure shall be impacted.

The formula for calculating Additional Payment is not quite simple, and it requires certain steps per below:

First, find out the present value of the outstanding balance on the loan

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

Next would be to find out the tenure with the new installment amount

nPVA = Ln [ (1 – PV(r) / P)-1] / Ln (1+r)

then, nPVA x (Installment Amount + Additional Payment per Period)

Wherein,

  • FV is a future value of the balloon amount
  • PV is the present value of Outstanding Balance
  • P is the Payment
  • P’ is the new Payment
  • r is the rate of interest
  • n is the frequency of payments
  • nPVA is the number of periodical payments

The Additional Payment Calculator is very much useful to the borrower, especially when they are planning to increase their installment amount so that they save on interest payments and also pre-payment their loan early. This calculator shall help them to identify how much they shall save had they not made any additional payment. The borrower shall be able to determine whether his decision to make additional payment is worthwhile or not.

How to Use the Additional Payment Calculator?

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

Step #1 – First, a borrower needs to determine what is current loan outstanding balance, which is nothing but finding out the present value of the mortgage.

Step #2 – Now determine the new installment amount, which is the sum of the existing installment amount and the additional payment that the borrower is thinking to be made.

Step #3 – Use the nPVA formula to determine within what span of time the remaining loan would be paid off.

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 – Multiply the nPVA calculated in step 3 by the new installment calculated in step 2.

Step #5 – Calculate the total value of installment already paid by multiplying the existing installment by a number of periods for which the same has been paid.

 Step #6 – Take the sum of values arrived in step 4 and step 5, which shall be total outgo if additional payment is made.

Step #7 – Multiply the existing installment with a total number of periods.

Step #8 – Subtract Value arrived in step 7 by step 6, which shall yield the savings done by making additional payment.

You can download this Additional Payment Calculator Excel Template here – Additional Payment Calculator Excel Template

Example

Mrs. Yen Wen has taken a mortgage loan for $200,000 for a period of 30 years, and the rate of interest, which is applicable to the same, is 5%. Since she is an employee of the bank, she is eligible for a rebate on interest to the tune of 0.75%. Her monthly installment is $983.88 based on a current fixed rate. She would be eligible for promotion next year, and she is expecting a decent hike, and she feels that she would be able to increase the monthly installment by $200 and she feels that she would be able to save a substantial amount of interest and she would be able to close the loan earlier than current. It has been 4 years now since she has been paying the same installment every month, and she has not defaulted on any of the installments.

Based on the given information, you are required to calculate the savings she would make on her mortgage loan, and by what span can she expect to close the loan based on a new installment amount.

Note: You can ignore the time value of money since her additional payment starts from the end of year 5.

Solution:

We are given here; the existing monthly installment that she is paying is $983.88, which has to be paid until 30 years. Hence, here total outgo would if she continues to make the existing installment is $983.88 x 30 x 12, which is $354,196.72

Additional Payment Calculator Example 1

Now, after 5 years, she wants to increase the monthly installment amount, which is $983.88 + $ 200, which equals $1,183.88.

Additional Payment Calculator Example 1-1

We will now calculate what savings she shall make if this additional payment is made.

Rate of interest applicable on monthly basis = (5.00% – 0.75%) / 12 = 0.35%

The remaining period will be (30 * 12) – (5 * 12), which is 360 – 60, that is 300.

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

PV = P * (1 – (1+r)-n / r)

PV Example 1-2

  • = $983.88 * [1 – (1+0.35%)-300 / 0.35%]
  • = $181,615.43

Now since we have the Present Value of outstanding loan balance at the end of 5 years, we now need to Calculate the time period within which the loan can be close with the new installment amount.

nPVA = Ln [ (1 – PV(r) / P’)-1] / Ln (1+r)

npva Example 1-3

  • = Ln [ {(1- 181,615.43 x (0.35%) / 1,183.88}-1] / Ln (1+0.35%)
  • = 221.69

Now we shall calculate the total outgo with new installment which is

New installment * nPVA i.e. 1,183.88 * 221.69 which equals to $262,454.13 and amount that is already paid which is $983.88 x 60 which is $59,032.80, and therefore the total amount paid under additional payment installment shall be $262,454.13 + $59,032.80 which is equal to $321,486.93

total amount Example 1-4

Therefore, savings on this additional payment will be $354,196.72 less $321,486.93 which is $32,709.87.

Additional Payment Calculator Example 1-5

The number of periods of loan payment shall be reduced by 300 – 221.69, which is equal to 78.31 months, and in years it is 6 years and 6 months.

Conclusion

The additional payment calculator, as discussed, is useful for the borrower to calculate the savings he can make by repaying the loan earlier that is through an additional amount added in every installment. This shall help in saving the interest as well as reducing the loan term.

Recommended Articles

This has been a guide to the additional payment calculator. Here we discuss how to calculate the additional payment of loans to know the savings along with step by step examples. You may also take a look at the following useful articles –

  • Examples to  Calculate Simple Savings
  • CD Interest Calculations
  • Car Down Payment Calculations
  • Balloon Mortgage Calculations
  • Adjustable-Rate Mortgage 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 Additional Payment Calculator Excel Template

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