The Loan Repayment Calculator is a starter designed to calculate the interest rate and interest for the year, as well as the current and non-current portions of a client's loan (including hire purchases and chattel mortgages).
To use the Loan Repayment Calculator, download the starter file from the Smart Suite website or open from HowNow Knowledge. Make sure the date on the Home sheet is the correct year that you wish to calculate the loan for.
In the Loans section of the Index sheet, insert the 'H11 Loan Repayment Schedule' worksheet. You will need one worksheet per loan. Change the name of the loan on the Index in the Worksheet Title column.
This name will automatically flow through to the Loan description on the Loan Repayment Schedule worksheet.
Complete all of the Loan details in column N, and press the blue Calculate Loan button. There is also an option to have either the nominal or effective interest rate calculated.
This will calculate the interest rate and the total interest of the loan, as well as populating the Loan summary in column S.
The Calculate Loan button also populates the Year End Journals section.
Note: The Amounts currently in the trial balance need to be completed for this section to work correctly.
You will also be provided with both a yearly summary and a full schedule of the loan.
Once you have completed the loan repayment schedule for each loan, go back to the Index and click the blue REFRESH the Summary button. This will populate the current and non-current amounts for each loan, as well as give a total of all loans for the year.
This worksheet can then be linked to your end of year Accounts and Tax or Connected Workpapers starter files by using the Copy Worksheet from another file option when inserting a worksheet.