annuity/hire purchase template
 

Template that calculates and schedules both interest and capital elements of
monthly repayments for a loan. eg. £10000 borrowed at 10% apr over 36
months repaid by monthly instalments. Require for each month the repayment,
capital, interest and remaining capital outstanding value. Ideally this
could also show capital to be repaid within next 12 payments and capital to
be repaid after more than 12 months on a rolling basis.