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?