The Bank Loans template allows you to enter the details of your bank loan agreement/s in order to calculate and keep track of the repayment commitments. Here's how to complete it:
Input the details of the loan agreement for each of the relevant bank loans. You have the option to input details for multiple loans under the same bank loan nominal code.
Note: Although the 'Bank' and 'Account Number' fields are not mandatory, these fields pull into the Summary of Bank Loans template so are beneficial to include.
Bank: The bank from which the loan was granted
Account number: The account number of the bank
Date of loan agreement: Date that the loan was entered into
Loan amount: Value loaned by the bank
Less: Initial deposit paid: Deposit paid for the loan upon entering into the agreement
Interest spreading method: Sum of digits, straight line or fixed rate
Total finance costs including interest: Total financed costs per the bank loan agreement, including interest
Less: Initial admin fee: Value of the initial admin fee applied to the loan agreement, if relevant
Less: Final admin fee: Value of the final admin fee applied to the loan agreement, if relevant
Charges spread yearly: Total finance costs less initial admin fee less final admin fee (automatically calculated)
Total repayments: Sum of the total financed value and the yearly charges
Date of first payment: This only needs to be completed if the first payment date differs from the loan agreement date
Date of break clause: The date of break clause if applicable.
Periodic repayment amount: Enter the value of the period repayment
Are there any break clauses? Yes or No
Payment frequency: Monthly, quarterly, bi-annually or yearly
Are balances due after 5 years paid by installments?: Yes or No
Loan length (in months): Automated based on the date of first payment and date of last payment
Once all of the above details are filled in for each loan specified, it will automatically break down the repayment commitments of your loan. The current period will appear in a separate box at the top, and also in the full table below in bold.
Adjustments for the period can be input here.
The template will reconcile if the amount in the Capital C/F box matches the repayment commitment in the nominal code for that period.
How to reconcile if the amounts due within and after 1 year is within the same nominal code:
Select the Total option under Amounts Reconciled To. This will reconcile this template to the Capital C/F amount.
How to reconcile if the amounts due within and after 1 year is split into two different nominal codes:
Select the Due within 1 year option under Amounts Reconciled To. This will reconcile this template to the amount due within one year.
Use the Summary of Bank Loans as explained below to reconcile the details for due within 1 year, and due after 1 year amounts.
Summary of Bank Loans
This template reconciles the details of all of your bank loans (entered into bank loans template mentioned above) to the value of the bank loan nominal account/s, for due within 1 year, and due after 1 year.
The relevant bank loan account nominal account code/s need to be pulled in for each bank loan/line item using the # functionality. The remainder of the template is automated based on the loan agreement details entered into the previous template.