Financial Management Problem
Vipul Rathod (16 Points)
04 December 2017Financer 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?