Excel Overpayment Calculator

Craig_A

Some time ago (probuably three months or so ago) there was a link posted here to a downloadable Excel spreadsheet which was basically ani advanced mortgage overpayment calculator.

I have been searching for ages but can no longer find it - does anyone know where I can get my hand on a copy?

Thanks in advance!!

chuckles1066

http://www.tomstickland.co.uk/mse/mo...verpayment.xls

Craig_A

Thanks, chuckles.

The link didn't work (it is this) but it gave me enough to use the search function and find it.

Unfortunately, however, it's not the one that I was looking forward to. The one that I remember was quite some piece of work with each payment listed individually on its own row. Therefore you could see exactly how much capital had been repaid monthly and how much interest. You could add monthly overpayments as well as part repayments and it would take all of it into account and tell you exactly where you were as well as showing you exactly where you are heading.

I know I wasn't imagining it...!!

Craig_A

Think I found it:

http://www.mtgprofessor.com/Spreadsheets/Xtrapmts.xls

Pretty good but not quite as refined as I thought, can anyone suggest a superior spreadsheet?

I'd really really like one that allows you to record each months payments for record, as per the example here, to vary the interest rate for given date ranges, add part-repayments on any date, change the date of the mortgage payment, etc.

Of course I'd have no clue where to start adapting an existing one and it's unlikely anyone else has put anything so specific together! But I'd be very pleased to hear if there is anything out there!

Thanks

roswell

look on the mocrisoft website for excel personnal templates the one you want is the Loan amorganization sheet.

Craig_A

Thanks for the suggestion. But that template actually does less than the one I downloaded earlier.