change loan periods in an amortization schedule

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

[Gary L Brown]

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

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
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?

[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


"Gary L Brown" <gary_brown@ge_NOSPAM.com> wrote in message
news:[email protected]...
> Example...
> Change the Length of Loan period from 30 years to 360 months.
>
> HTH,
> --
> Gary Brown
> gary_brown@ge_NOSPAM.com
> 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?