Mortgage Template

[Guest]

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.

 

[Tyro]

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

 

[Guest]

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.

 

[Dave Peterson]

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

And there's always google!

 

[Guest]

Thanks gentlemen, much appreciated.

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

And there's always google!