change loan periods in an amortization schedule

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

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:AC721FF0-D89B-45AF-AC64-(E-Mail Removed)...
> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
loan amortization schedule	nldilch	Microsoft Excel Worksheet Functions	3	15th Jan 2008 11:07 PM
Loan Amortization Schedule	=?Utf-8?B?TGluZGEgVg==?=	Microsoft Excel Worksheet Functions	1	9th Mar 2006 03:18 PM
Loan amortization schedule	=?Utf-8?B?QU1TMjI4?=	Microsoft Excel New Users	0	30th Apr 2005 02:56 AM
Loan Amortization Schedule	=?Utf-8?B?SmVmZg==?=	Microsoft Excel Misc	3	16th Feb 2004 03:16 AM
Re: Loan Amortization Schedule	barry kaplan	Microsoft Excel Worksheet Functions	2	6th Jul 2003 05:26 AM