Forecasting Loan Interest Payments
Using FUTRLI Formula Method, we can quickly and simply forecast Loan Interest payments. In this guide we’re going to walkthrough entering a simple Loan Interest payment.
Written by Ross MacLeod
Now you can quickly and accurately forecast loans using our new Loans forecasting wizard. You can click here to find out more about it!
Using FUTRLI’s Formula Method, you can quickly and simply forecast Loan Interest payments. In this guide we’re going to walkthrough entering a simple Loan Interest payment and then demonstrate how to set this interest against the value of the loan.
Forecasting a Loan Interest Payment
Within the Scenario, navigate to the Interest Expense line and create a new Forecast Item. You will need to use FUTRLI’s Forecast Formula method to enter the Interest Payments:
In this example we’re going to be forecasting the payment of a £100,000 loan over 3 years with 5% annual rate of interest payable monthly. Using FUTRLI formula method, we can quickly and simply enter our Interest Expense calculation:
- Type in the formula: £100,000 multiplied by 0.05 gives the annual interest payment, dividing by 12 makes this a monthly figure of £417:
- It is a monthly calculation so select ‘monthly periods’.
- Set the first invoice date as the first loan repayment date.
- Set the VAT to zero.
- ‘Repetition Pattern’ – select yes to make the calculation repeat and set to end after 36 periods (3 years in this example):
Hit Save Changes and the Interest Expense will be calculated and applied to the Forecast:
The balancing entry to this expense can be seen in the default bank account:
Adding the interest to the value of the loan
If the interest payable on the loan is added to the value of the loan outstanding, then you will not want your bank account affected. For this we use the Advanced Options, found in the bottom right of the window:
Click advanced options on the initial Forecast screen. If you have already saved you can access the same screen by selecting edit on an existing Forecast:
Here simply select no cash and choose the Account you wish to be credited rather than the bank.