Internal Rate of Return

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?

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
21 October 2026
CA INTER/ BCOM WITH EXPERIENCE

CA S KUMAR GUPTA & CO

Amritsar

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details