From: "R P McMurphy" 
Newsgroups: uk.finance
Subject: Re: Mortgage calculate spreadsheet?
Date: Wed, 20 Aug 2003 15:06:10 +0100


"Mike Atkinson {reply address in .sig}"  wrote in
message news:1x4cz9scbhaff.dlg@abingdon.geoquest.slb.com...
| I'm looking for an Excel spreadsheet to allow me to play around with
| mortgage calculations. A search through Google shows that this request
| has been made before, but I've been unable to find any of the
| spreadsheets referred to - the links are mostly out of date.
|
| I'm aware that there are lots of web based calcualators, but these are
| generally inflexible, and I'd like to be able to check/tweak equations
| used. I'd like to play around with repayment/interest only fractions,
| overpayments, terms, etc, in addition to the normal interest rate
| inputs.
|
| Is this something I need to put together myself, or does such a
| spreadsheet exist already?
|
| TIA,
| Mike.
|

although not an excel sheet this might be of some use.
http://www.abbeynational.co.uk/index/mortgage_home/mortgages_products.htm?referer=LNAV.choosing_right_glance
click on 'illustrator' below flexible mortgages.

rpm