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.