I am using the Mortgage template in Excell 2007. The priod of the mortgage
is 15 1/2 years. The template is not accepting fractions of a year in the
period box, example if I enter 15.5. Is there a work around that anyone know
of? After all, not all mortgae periods are whole numbers.

There are several mortgage (loan payment) templates available from
Microsoft. All I'm familiar with work in periods, usually months, not
fractions of years. So 15.5 years would be186 months.

Tyro

"Rawle" wrote in message
...
I am using the Mortgage template in Excell 2007. The priod of the mortgage
is 15 1/2 years. The template is not accepting fractions of a year in the
period box, example if I enter 15.5. Is there a work around that anyone
know
of? After all, not all mortgae periods are whole numbers.

Thanks Tyro but where can I get one. I found one called Simple loan
Calculator which accepted fraction of years but it does not include the
addtitional facility to include for amounts paid over and above the
calculated loan payments.

"Tyro" wrote:

There are several mortgage (loan payment) templates available from
Microsoft. All I'm familiar with work in periods, usually months, not
fractions of years. So 15.5 years would be186 months.

Tyro

"Rawle" wrote in message
...
I am using the Mortgage template in Excell 2007. The priod of the mortgage
is 15 1/2 years. The template is not accepting fractions of a year in the
period box, example if I enter 15.5. Is there a work around that anyone
know
of? After all, not all mortgae periods are whole numbers.

MS has lots of templates at:
http://officeupdate.microsoft.com/TemplateGallery

And there's always google!

Rawle wrote:

Thanks Tyro but where can I get one. I found one called Simple loan
Calculator which accepted fraction of years but it does not include the
addtitional facility to include for amounts paid over and above the
calculated loan payments.

"Tyro" wrote:

There are several mortgage (loan payment) templates available from
Microsoft. All I'm familiar with work in periods, usually months, not
fractions of years. So 15.5 years would be186 months.

Tyro

"Rawle" wrote in message
...
I am using the Mortgage template in Excell 2007. The priod of the mortgage
is 15 1/2 years. The template is not accepting fractions of a year in the
period box, example if I enter 15.5. Is there a work around that anyone
know
of? After all, not all mortgae periods are whole numbers.




--

Dave Peterson

Thanks gentlemen, much appreciated.

"Dave Peterson" wrote:

MS has lots of templates at:
http://officeupdate.microsoft.com/TemplateGallery

And there's always google!

Rawle wrote:

Thanks Tyro but where can I get one. I found one called Simple loan
Calculator which accepted fraction of years but it does not include the
addtitional facility to include for amounts paid over and above the
calculated loan payments.

"Tyro" wrote:

There are several mortgage (loan payment) templates available from
Microsoft. All I'm familiar with work in periods, usually months, not
fractions of years. So 15.5 years would be186 months.

Tyro

"Rawle" wrote in message
...
I am using the Mortgage template in Excell 2007. The priod of the mortgage
is 15 1/2 years. The template is not accepting fractions of a year in the
period box, example if I enter 15.5. Is there a work around that anyone
know
of? After all, not all mortgae periods are whole numbers.




--

Dave Peterson