Interest On Loan ?

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details