WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Total Loan Cost Calculator

Total Loan Cost Calculator

Total Loan Cost Calculator can be used to calculate what shall be the cost of the loan after repaying the same until the end of the period.

Total Loan Cost Calculator

(L * R * (1+R)n*F ) / ((1+R)n*F-1)


Wherein,
  • L is the loan amount
  • R is the total outstanding amount.
  • n is the number of periods for which loan is required to be paid
  • F is the frequency for which interest is going to be paid out
loan amount
$
total outstanding amount
%
number of periods
$
frequency for which interest
$

About Total Loan Cost Calculator

The formula for calculating Total Loan Cost is per below:

(L * R * (1+R)n*F) / ((1+R)n*F-1)

Wherein,

  • L is the loan amount
  • R is the rate of interest per annum
  • n is the number of periods for which loan is required to be paid
  • F is the frequency for which interest is going to be paid out

People dream of buying houses, luxury cars, etc. but however, not everyone is fortunate to have funds to buy them, and thus, they opt for a loan wherein there the cost is involved in it. The cost comes in the form of interest, which again varies from financial institution to financial institution. The loan could be borrowed for the house, vehicle, education, etc. This calculator can be used to calculate the total cost of the loan, which is what shall be the amount paid in total versus what the amount was borrowed, and the difference would be interest payment.

How to Calculate Using Total Loan Cost Calculator?

One needs to follow the below steps in order to calculate the total cost of the loan.

Step #1 – First of all, determine the loan amount that has to be borrowed. A financial institution generally lends more loans amounts to those who have a better credit score and lends lower amounts to those who don’t have a good credit score. Enter the loan amount as required.

Step #2 – Determine the rate of interest which shall be applicable and also the frequency and accordingly find out the rate to calculate the cost of interest. For example, if the rate of interest is 12% per annum, and if the compound frequency is monthly, then the rate of interest would be 12% / 12, which is 1%.

Step #3 – Multiply the loan amount by the equivalent rate of interest that was determined in step 2.

Step #4 – Now, we need to compound the same by the rate that was determined in step 2 until the end of the loan period.

Step #5 – We now need to discount the above result obtained in step 4 as given in the formula

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 #6 – After entering the formula, which was discussed above, we shall obtain installments periodically.

Step #7 – Now multiply the installments by a number of periods and frequency to determine the total cost of the loan.

You can download this Total Loan Cost Calculator Excel Template here – Total Loan Cost Calculator Excel Template

Example #1

Mr. N wants to set up a business wherein the biggest expenditure is the cost of machinery and for which he doesn’t have funds. Hence, he approaches the bank for a term loan for $150,000 and provides machinery as collateral. The bank agrees to provide term loans for a period of 15 years, and the rate of interest will be 7.55% that will be compounded on a monthly basis. However, due to the festive offer, the bank will not charge any processing fees of the loan.

Based on the given information, you are required to calculate what shall be the cost of the loan to Mr. N for purchasing machinery on the term loan.

Solution:

We need to calculate the Installment amount; for that first, we shall calculate the loan amount, which is $150,000. The number of periods it is required to be paid in 15 years, but since here Mr. N is going to pay on a monthly basis hence the number of payments that he shall be required to be paid is 15*12, which is 180 equally installments and lastly, the rate of interest is 7.55% fixed which shall be calculated monthly which is 7.55%/12 which is 0.63%.

Example 1 (Given Data)

Now we shall use the below formula to calculate the installment amount.

Loan Installment = (L * R * (1+R)n*F ) / ((1+R)n*F-1) 

Total Loan cost Calculator Example 1-1

  • = (150,000 * 0.63% * (1 + 0.63%)15*12 ) / ( (1 + 0.63%)15*12 – 1 )
  • = 1,394.78

Therefore, the Installment amount for Mr. N for 15 years on the loan amount 150,000 shall be 1,394.78

The calculation of the total loan amount for Mr. N is as follows:

Total Loan cost Calculator Example 1-2

  • = 1,394.78 * 15 * 12
  • = $251,061.11

Example #2

Mr. Gomzi wants to pursue higher education in a renowned university wherein the total estimated cost will be $35,640. However, since he lacks funds, he approaches a bank to borrow a loan. The bank charges 11% interest per annum, which shall be compounded quarterly, and the loan period will be for 8 years. The bank has no charges system for an education loan, but however, it charges 3% pre-penalty charges.

Based on the given information, you are required to calculate the total cost of the loan, and what amount would Mr. Gomzi be paying only in the form of interest?

Solution:

We need to calculate the Installment amount; for that first, we shall calculate the loan amount, which is $35,640. The number of periods it is required to be paid in 8 years, but since here Mr. Gomzi is going to pay on a quarterly basis hence the number of payments that he shall be required to be paid 8*4, which is 32 equally installments and lastly, the rate of interest is 11.00% fixed which shall be calculated quarterly which is 11.00%/4 which is 2.75%.

Example 2-1 (Given Data)

Now we shall use the below formula to calculate the installment amount.

Loan Installment = (L * R * (1+R)n*F) / ((1+R)n*F-1)

Total Loan cost Calculator Example 2-1

  • = (35,640 *2.75% * (1 + 2.75%)8*4)/ ((1 + 2.75%)8*4 – 1 )
  • = 1,689.07

Therefore, the Installment amount for Mr. Gomzi for 8 years on the loan amount 35,640 shall be 1,689.07

The calculation of the total loan amount for Mr. Gomzi is as follows:

Total Loan cost Calculator Example 2-2

  • = 1,689.07 * 8 * 4
  • = $54,050.3

Total interest outgo equals to $54,050.35 – $35,640 which is $18,410.35

Conclusion

This is a superset calculator for all kinds of loans wherein a fixed rate of interest is applied, and that includes Home loan, Student Loan, Car loan, education loan, etc. This calculator will calculate the installment amount as well the total loan cost by multiplying the installment amount with a number of years and frequency for which that shall be paid.

Recommended Articles

This has been a guide to Total Loan Cost Calculator. Here we provide you the calculator that is used to calculate the total loan amount until the end of the period with some examples. You may also take a look at the following useful articles –

  • Business Loan Calculator
  • Auto Loan Calculator
  • Investment Calculator
  • Loan Repayment Calculator
18 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 Total Loan Cost Calculator Excel Template

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