Discussion
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
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
This explains how to use the formulas https://www.excel-easy.com/examples/loan-amortizat...
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


