Plant and Machinery Worksheets

Use the Plant and Machinery worksheets to track the age and value of your equipment. Monitor the depreciation in the equipment’s value. Forecast when you want to buy new equipment.

Items that you add the Plant and Machinery worksheets will be subtotaled in your assets in your Statement of Position report. You will also be able to see the income or expense for equipment in your monthly cash forecast.

1.Plant Type

Type a category for the upcoming group of plant or machinery

2.Item

Type a name describing the plant or machinery

3.Particulars

Type the model, brand or model number to identify the specific machine or plant

4.Year New

Type the year the plant or machinery was built

5.Purchase Price $

If purchased this year, type the amount paid for the plant or machinery

6.Opening Market Value

Type the estimated dollar value of the vehicle or machinery this year

7.Sell This Year $

If you are selling this year, type the price you expect to get for the plant or machinery

Forecast a Sale or Purchase

Plan the sale or purchase of equipment around your seasonal needs or predicted cash flow.

Month F5

If you are selling the item in this row: Press F5 and pick

·Any 1,2,3 or 4 months

·The month you plan to sell the plant or machinery

·Agrimaster Cash Book Code (for tracking income)

·Bank account the money will be deposited to

Click on the green tick to OK

Leave this box blank if you are not selling the item this year

If you are expecting to buy or sell a piece of equipment within a window of several months, pick the earliest month for the transaction.

The worksheet can be updated when a more specific date can be forecasted. Or, you can leave the forecasted date as is and compare your estimated activity to your actual income and expenses.

Finish the Plant and Machinery Worksheet

1.Buy This Year $

Optional: If you are buying this plant or machinery this year, type the dollar amount you expect to pay

2.Month F5

If you are buying plant or machinery this year, press F5 and pick

·Any 1,2,3 or 4 months

·Month the purchase will be made

·Agrimaster Cash Book Code (for tracking costs)

·Bank account the money will be deducted from

Click on the green tick to OK

Leave this box blank if this row lists existing plant or machinery

3.Depreciation %

Ask your accountant for the depreciation percentage for your machinery and vehicles

Type the percentage without the percentage symbol (example 10% is 10.0)

4.Total Depreciation

Agrimaster calculates the depreciation of the value over the year by multiplying Opening Market Value x Depreciation

5.Closing Market Value

Agrimaster calculates the market value at the end of the year by subtracting Opening Market Value – Total Depreciation

Vehicles sold this year will have no depreciation

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