Hi Everyone
Could anyone inform me on how to calculate a redemption figure for a mortgage.
I can lay out an amortisation schedule in excel which gives me lots of information by month but I would like to be able to get to a specific day for the mortgage balance.
I understand there will be other costs associated with redemption that may vary but if I can get to a daily mortgage balance that would be great. If anyone could share knowledge on redemption costs added to a mortgage balance that would also be great.
Thanks!
J
Could anyone inform me on how to calculate a redemption figure for a mortgage.
I can lay out an amortisation schedule in excel which gives me lots of information by month but I would like to be able to get to a specific day for the mortgage balance.
I understand there will be other costs associated with redemption that may vary but if I can get to a daily mortgage balance that would be great. If anyone could share knowledge on redemption costs added to a mortgage balance that would also be great.
Thanks!
J