change loan periods in an amortization schedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to change the loan period in an amortization schedule from years
to months. Any sugestions on how to do this in a template that was
downloaded?
 
You also need to divide the rate (the Annual Rate) by 12 to fit the monthly payment schedule.

HTH,
Bernie
MS Excel MVP
 
Back
Top