Excel Help
Author
Discussion

matt.m

Original Poster:

287 posts

249 months

Wednesday 2nd January 2019
quotequote all
Hi

I am looking at working out how much i have paid off of a mortgage over a period of time in excel.

For instance, the mortgage would be something like (all figures are made up and probably dont make sense) -

Initial Amt - £100,000
Initial Fixed Term - 1year
Initial Int Rate - 1%
Initial monthly Payments - £100
Amt Left After Fixed Term = ???

How can I work this out?
Cheers

Matt

weeboot

1,065 posts

130 months

Wednesday 2nd January 2019
quotequote all
Do file, new and search for Mortgage in the templates.
There's a bunch of existing, don't re-invent the wheel.

TheGroover

1,044 posts

306 months

Wednesday 2nd January 2019
quotequote all
This explains how to use the formulas https://www.excel-easy.com/examples/loan-amortizat...

matt.m

Original Poster:

287 posts

249 months

Thursday 3rd January 2019
quotequote all
Thanks for that, I will have to have a look as all the examples relate to reducing the balance to zero by the end of a period of time. Whereas I am looking to work out what is left at the end of a fixed period of time.

sgrimshaw

7,587 posts

281 months

Thursday 3rd January 2019
quotequote all
Follow the instructions in the link posted above, just stop copying the formulas at the point the fixed period ends ... that will show you the balance at that point