Loan Calculator

This Simple Loan Calculator is useful for calculating periodical installment whether it be monthly quarterly, semi-annually or annually installments.

About Loan

[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

Loan Amount (P)

ROI per annum (R)

No. of Period (N)

About Loan Calculator

The formula for calculating the loan amount is –

[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

This considers the initial amount which is the principal amount or the loan amount, compounds the rate of interest depending upon the frequency of repayment. This calculator shall allow comparing loans across maturities and the user would be able to calculate what extra loan amount will be the outgo in the form of interest. This simple calculator is useful for computing installments for any product whether it be personal loans or educational loans.

How to Calculate the Loan Calculator?

One needs to follow the below steps in order to calculate the periodical installments of the loan.

Step #1 – Calculate the down payment if any and deduct same from the total value of the thing for which loan is taken, which shall provide the loan amount or in other words is the principal amount:

Step #2 – Multiply the principal by the rate of interest applicable to the loan product.

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

Step #4 – We now need to discount the above result obtained in step 3 by the following:

Step #5 – After entering the above formula in excel we shall obtain periodically installments for the loan in question.

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

Loan Calculator Examples

Example #1

Mr. Vince has the desire to purchase a Hyundai luxury car that shall cost him around $35,000. He enquired in the showroom and luckily the showroom had tied with a bank that provides instant loans for creditworthy customers. On inquiry with the banker, he was told that as per credit score, he is eligible for a 90% loan and rest has to be paid upfront in form of down payment. He agrees to the same and further he was told that the rate of interest applicable would be 11% and maximum tenure he can avail for is 5 years and has to be repaid on a monthly basis.

You are required to Calculate the installment amount on the loan that Mr. Vince is required to pay.

Solution:

We need to calculate EMI amount; the number of installments is 5 years but since it is monthly outgo hence the number of payments required to be paid is 12*5 which is 60 equally monthly installments and lastly the rate of interest is 11.00% fixed which shall be calculate monthly which is 11.00%/12 which is 0.92%.

Upfront Down-payment Calculation:

Loan Amount*(1 – loan percentage)

Loan amount will be

Now we shall use the below formula to Calculate the Loan amount.

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

Therefore, the EMI amount for this vehicle loan will be 648.89 for 5 years with monthly repayment.

Example #2

VJ has been excellent in his studies and he belongs to the middle-class family. He desires to study in a college where the fees are around $21,500 for 2 years. His father approaches the bank where the branch managers ask him to avail of an educational loan or he can take a personal loan. If he opts for a personal loan, then he would be getting loan amount as $18,000 with the rate of interest as 13% and if he opts for an educational loan then he can avail it fully at a rate of interest as 12.00%. He intends to avail of a loan for 7 years. You are required to advise VJ as to which loan should be preferred?

Solution:

We need to calculate the EMI amount for both the products. The number of installments is 7 years but since it is monthly outgo hence the number of payments required to be paid is 12*7 which is 84 equally installments and lastly the rate of interest is 13% and 12% fixed for personal and educational loan respectively which shall be calculated monthly which is 13%/12 which is 1.08% and 12%/12 which is 1%.

Upfront Payment Calculation for Personal Loan:

Fees – Loan Amount