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
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

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

CA S KUMAR GUPTA & CO

Amritsar

CA Inter

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details