Hi.
I would like to calculate payments for a 6 year loan with the first year on a repayment holiday.
I have a spreadsheet which works well, complete with amortisation table, for loans with a standard repayment structure. However, this is at present unable to calculate the interest which accrues over the twelve month repayment holiday.
Can anyone advise how this can be accomplished, or point me in the direction of a downloadable spreadsheet which will do this?
An illustrative loan;
£100,000 loan amount.
6 year total repayment period.
Year 1 repayment holiday (interest-only payments).
Monthly payments in arrears.
Thanks.
Bookmarks