change loan periods in an amortization schedule

B

Barbara

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?
 
G

Gary L Brown

Example...
Change the Length of Loan period from 30 years to 360 months.

HTH,
 
B

Bernie Deitrick

You also need to divide the rate (the Annual Rate) by 12 to fit the monthly payment schedule.

HTH,
Bernie
MS Excel MVP
 
Top