Nice spread sheet for calculating overpayments

Erewego

clarew wrote:

sounds a great template....my only problem is my computer doesn't have excel on it!!! (oh well, back to pen,paper,calculator and the funky gibbons link to overpayment calculators!!!) but thanks anyway!

Hi There Clarew,

If you want a complete office application that will also run this spread sheet go to http://download.openoffice.org/2.0.3/index.html

and down load this free software if you are on dial-up get a friend with broadband to do it for you though as it is rather big, if not use a download manager such as LeechGet so you can spread the down load over a few days.

Open Office requires Java to run all its components but its spreadsheet works with out it, if you want all its components download java from java.com. The OpenOffice web site explains all this.

Erewego

MrsV wrote:

Does this spreadsheet take into account variable interest rates?

Hi Mrs V
Never one to resist a challenge i've found an overpayment spreadsheet that does take into account variable interest rates.

http://www.mtgprofessor.com/spreadsheets.htm

Extra Payments on Adjustable Rate Mortgages.

Its american so its got dollars instead of pounds but that should not be a problem.

Hope it helps.

humfer

You could also try the link below - its an US site but don't that worry you (just substitute the $ for £), and it is the only site I have found that provides full amortisation tables together with ability to see what effect lump/regular/yearly overpayments make

http://www.loanbright.com/edirectlending/calc_amortization.html

stopthespends

hi

ive tried to use the spreadsheet but i dont undertsand this amoriz (?) thingy!!! can you help me please.

ive got £93000 over 23 years at 5.19%

thanks (sorry having a thick day!!!!!!!)