change loan periods in an amortization schedule
 

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?

change loan periods in an amortization schedule
 

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

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Barbara" wrote:

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?

change loan periods in an amortization schedule
 

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

HTH,
Bernie
MS Excel MVP


"Gary L Brown" wrote in message
...
Example...
Change the Length of Loan period from 30 years to 360 months.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Barbara" wrote:

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?