In: Finance
What will be the monthly payment on a loan of $602, amortized over 29 years , at an annual interest rate of 9%
Calculations-
Here, | ||
Fv is the future value of loan | ||
rate is the periodic interest rate | ||
nper is no. of periods | ||
pmt is the periodic payments | ||
Pv is the present value of loan | ||
type = 0 if the amount is paid at the end of the year ,1 if it is paid at the beginning. |
As no method was mentioned I have solved the problem using excel function.