Interest On Loan ?

others 2287 views 6 replies

Hi Friends,

1. Hi can anyone suggest me regarding The Calculation method of Reducing rate of interest & Flat Rate Of Interest?.

2. How They Are Calculated. Recently my freinds has taken loan whose emi is 41748/- for one year for loan of 453000/-. Bank is charging me 19% of interest on Reducing Rate Of Interest but i am paying around 12% from my pocket. can you suggest me whether this deal is ok.

Regards

 

Replies (6)

Hi Sanjev

How many is this loan (i.e) your repayment term whether 48, 60 mths.

then we can find it out.

Regds

Balaji S.

Hi Balaji,

Its for 12Months.

Regards

 

 


emi of Rs. 41748 is fairly calculated as per information provided.

Because Present Value of 12 monthly Annuities Of Rs.  41748/- each, @ 19% p.a. comes to Rs. 453000/- which is your loan Amount.

Formula to calculate Present Value is

PV =  (Annuity/monthly interest rate)*(1-(1/(1+monthly interest rate))^No. of months)

 hereby i m attaching a xls file to calculate EMI as well as Loan Amount.

hope this will help u out.

now i come to your second ques. which is the best plan & why?

and the answer is reducing balance method is the best out of two under given situation b'coz at flat rate of interest it comes to Rs. 54360/- (i.e. 453000*12%)  while under reducing rate of interest it comes to Rs. 47976/- (i.e. 41748*12-453000). which saves your Rs.6384/-  under later option.

Now choice is yours.

Hi Naveen

I like to know how we need to use the formula in excel to calculate EMI

Regards,

Sathish

Hi Naveen,

Can you send me that spread sheet to my email address,

sathishrao_22 @ yahoo,com

sathishrao_22 @ rediffmail.com

Thanks,

Sathish


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details