Internal Rate of Return

156 views 1 replies
Mr. X going to buy construction equipment costing Rs. 43,50,000/-. He has 2 proposal from different financer H & A. Financer offer are as under.
Financer H
Loan Rs. 43,50,000/-
Loan Tenure - 3 years (36 Month).
Loan Rate (IRR) - 8.5%.
Moratorium Period - 1 Month.
Return Back 1% of loan amount at the beginning of the year to the Mr.X.
Processing fees - Rs. 3000/-
Stamp Duty - 0.25 % of loan amount + Rs. 400/-

Financer A
Loan Rs. 43,50,000/-
Loan Tenure - 3 years (36 Month).
Loan Rate (IRR) - 8.25%.
Moratorium Period - 1 Month.
Processing fees - Rs. 3000/-
Stamp Duty - 0.25 % of loan amount + Rs. 400/-

Mr. X has a confusion about following point.
1) Out of this 2 Financer's proposal which proposal going to chose and WHY?
2) what is the Actual or Effective Rate of Loan (IRR), considering extra expenses and indirect income (Return Back amount)?
3) how to plot this example in excel?
Replies (1)
Is anybody over there to resolve my problem?


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

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 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

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