Post by ablrateandy on Oct 18, 2015 11:34:54 GMT
Amortise vs IO.xlsx (85.24 KB)
Amortise vs IO 97-03 version.xls (583 KB)
Try these. Enter amount, rate, tenor (in months) on the right sheet in B5, B6 and B7. Re-investment rate is assumed to be interest only so pop that in B12. Max tenor is 36 months.
Andy
Amortise vs IO 97-03 version.xls (583 KB)
Try these. Enter amount, rate, tenor (in months) on the right sheet in B5, B6 and B7. Re-investment rate is assumed to be interest only so pop that in B12. Max tenor is 36 months.
Andy
. I am a bit tied up for the next twelve hours with a couple of meetings to prepare for but will drop you a line tomorrow afternoon and then just feel free to give me a call if you want to run over anything