Hi Sammy,

I have looked for templates too & didn't see any that I liked so I
started putting this together when I was feeling creative - but never
really finished!

I haven't checked it over for quite some time & there are potentially
some hidden flaws in the logic - but I -think- it is quite valid so let
me know if you find any errors/have suggestions for enhancements.

It is set up to automatically update the payments when different terms
etc are added at the top of the sheets & has a page of graphs more for
curiousity than usefulness.

It may provide you with a useful starting point?

Rob Brockett
NZ
Always learning & the best way to learn is to experience...


+-------------------------------------------------------------------+
|Filename: Home Loan Finance (blank v5 for web).zip |
|Download: http://www.excelforum.com/attachment.php?postid=4242 |
+-------------------------------------------------------------------+

--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=502844