Follow

Term Loans Worksheets

Keep an eye on the time of year that the big payments are due. Monitor the amount of interest accrued on loans throughout the year. 


1.    Purpose

 

Type a name to describe the term loan

2.    Company

 

Type the name of the institution giving the loan

3.    Date Started

 

Type the month and year the loan started

4.    Original Amount $

 

Type the starting dollar amount of the term loan

5.    Opening Balance $

 

Type the balance as of the start of this year

6.    New Loan

 

If this is a new loan this year, type the amount of the loan

7.    Interest Rate %

 

Type the interest rate (per annum)

8.    Interest This Year

 

Type the amount interest to be paid this year 

Or, press F3 to open the calculator

Click EX on the calculator to transfer the answer to the box

9.    Month F5

 

Press F5 to enter the months that the interest is applied by picking 

·         Monthly

·         First month the interest will be applied

·         Agrimaster Cash Book Code
(such as Term Loans Interest)

·         Bank account the interest payments will be
deducted from

Click on the green tick to OK

 

10.  Term In Years

 

Type the number of years for the loan as it was identified when it started (for example type 20 for a 20 year loan that started 5 years ago)

11.  Capital Amount Due

 

Type the dollar amount of the capital payment due this year

 

12.  Month F5

 

Press F5 and pick the loan repayment(s) details 

·         Any 1,2,3 or 4 months

·         Month the loan payment is made

·         Agrimaster Cash Book Code for the payment

·         Bank account the interest payments are made from

Click on the green tick to OK

 

13.  Closing Balance $

 

Agrimaster calculates the balance of the loan at the end of the year Opening Balance $Capital Amount Due

 

  After all data is entered, click on the green tick to save the Worksheets

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments