Interest On Loan ?

2327 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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 28 June 2026
Article Assistant

Sharma Chetan And Company

Gurgaon

CA Inter

View Details
Company
ARTICLESHIP 07 July 2026
Articleship

Jawahar and Associates Chartered Accountants

Hyderabad

CA Inter

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details
Company
20 June 2026
Chartered Accountant

ANV & Company

New Delhi

CA

View Details
Company
06 July 2026
Chartered Accountant (Indirect Taxation)

Gowra Ventures Pvt Ltd

Hyderabad

CA

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details
Company
25 June 2026
Accounts & Taxation Executive

Dindukurthy & Associates

Hyderabad

MBA

View Details
Company
29 June 2026
Accountant (Finance & Compliance)

TRIEYEZ

Kolkata

CA

View Details