Forecasting existing loans (amortisation)

Written by Andy Tyrrell

The Loans wizard allows you to forecast the receipt, fees interest and repayment of a loan with a simple convenient method. Using the Loan Wizard we can:

  • Forecast a new Loan
  • Forecast ongoing commitments to an existing Loan (Amortisation)
  • Track loan fees as an upfront or additional payment
  • Record overpayments reducing the term or repayments
  • Calculate interest only periods

Amortising an existing Loan

When forecasting an existing loan there are 2 options.

If you know the original loan details

If you have the full details for the original loan you can create a new loan forecast using those details, setting the appropriate dates in the past. The capital and interest repayments will continue from the date of your last actuals, and the result will be much the same as the above ‘New loan’ example.

If you don’t have full details

If you’re missing the full details of the original loan you can forecast the remaining repayments using the current balance. For this you’ll need to know:

  • The term remaining on the loan
  • The outstanding balance
  • The annual interest rate

Using the above example, let’s amortise our initial loan beginning in April. At this point the outstanding balance taken from our loan account is 83,670 and we know there are 10 months remaining (As repayments began in February our loan end date will be next February).

We’ll set the Loan amount at the closing balance at the end of the last known period (31st March in this example)

As we can see, our loan is now amortised with the capital repayments matching the original loan:

It’s always preferable to forecast loans using the original loan details as this ensures the calculations will accurate.


Leave a Reply

Your email address will not be published. Required fields are marked *