Follow

Lease Worksheets

Know how much you owe on leased equipment and when the leases are complete. The information you enter on the Lease Worksheet is used in the Statement of Position Report. 

 


 

1.    Item

 

Type the name of the equipment or item such as a computer

2.    Company

 

Type the name of the leasing company

3.    Date Started

 

Type the month and year the lease started

4.    Date Residual Due

 

Type the month and year the lease is complete

5.    Residual Amount $

 

Type the amount left at the end of the lease including GST

6.    Periodic Payment Amount

 

Type the payment amount including GST

7.    Number Payments For Year

 

Type the number of payments to be made over the year, for example quarterly payments would be 4

8.    Total Payments For Year

 

Agrimaster calculates the total spend on the lease for the year by multiplying the Periodic Payment Amount x Number of Payments Per Year

9.    Month F5

 

Press F5 and select 

  • Monthly (or another interval)
  • Month of the first payment
  • Agrimaster Cash Book Code (for tracking costs)
  • Bank account the money will be deducted from 

Click on the green tick to OK

  

10.  Number Payments Remaining

 

Type the number of payments remaining in this lease

Or, press F3 to open the calculator

11.  Opening Balance $

 

Type the amount of money owing as shown at the beginning of the year

12.  Closing Balance $

 

Type the amount of money owing on the leased equipment at the end of the year 

Or, press F3 to open the calculator

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

 

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

  • Farm leases are operating leases and do not involve the acquisition of the underlying asset. Therefore, farm leases should be included in the Overheads section of the Fixed Costs worksheets. Finance leases involve the lessee acquiring the plant and equipment at the end of the lease period with payment of the residual amount.
  • Finance leases involve the lessee acquiring the plant and equipment at the end of the lease period with payment of the residual amount. 

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

Comments