Mortgage Calculators
#1
Mortgage Calculators
I have tried searching the web and have got nowhere. Can anyone help me out with an excel template that will calculate my remaining mortgage, as and when i make overpayments to reduce the capital. It seems simple enough, but excel is not playing the same tune as me.
Many Thanks
Many Thanks
#4
Scooby Regular
iTrader: (15)
Join Date: Jul 2001
Location: Portsmouth
Posts: 8,606
Likes: 0
Received 0 Likes
on
0 Posts
there is a loan calculator in MSexcel, you need to go through the explore function though, rather than open new file from within the program
to test it I tried my own details and it was 100% to the penny, very tidy program as it shows you what just £100 extra a month does to the life of the mortgage
to test it I tried my own details and it was 100% to the penny, very tidy program as it shows you what just £100 extra a month does to the life of the mortgage
#5
Scooby Regular
Join Date: Feb 1999
Location: Cardiff. Wales
Posts: 11,758
Likes: 0
Received 0 Likes
on
0 Posts
Thread
Thread Starter
Forum
Replies
Last Post