In: Finance
loan amount (Maturity of loan amount)=
1000000
Interest paid each year 3% = 1000000*3%=
30000
Market interest rate (i)= 6% or 0.06
Time (n)= 5
Present value of ínterest and Loan paid formula = ínterest amount *
(1 - (1/(1+i)^n)/i + loan/(1+i)^n
30000*(1-(1/(1+0.06)^5))/0.06 + 1000000/(1+0.06)^5
873629.0864
This is Present value of outflow that is
873629.0864
loan received (present value of inflow)=
1000000
NPV = present value of inflows - present value of
outflow
1000000 -873629.0864
126370.9136
So NPV of loan is $126,370.91
Please thumbs up.