Answer:
The APR on this loan is 6.03% and the EAR on this loan is 6.20%
Explanation:
loan amount = $3700000*80%
= $2960000
use excel function to find the monthly rate of interest = RATE(nper,pmt,pv,fv)
nper is number of period which is 30*12 = 360 months
pmt is periodic payment which is 17800 in this case
pv is present value or loan amount
fv is future value
monthly rate of interest = RATE(30*12,-17800,2960000,0)
= 0.5023% per monthly rate
the APR on this loan = 0.5023%*12
= 6.03%
the EAR on this loan = (1 + 0.5023%)^12 - 1
= 6.20%
Therefore, The APR on this loan is 6.03% and the EAR on this loan is 6.20%