Depreciation Worksheet

Company Letterhead

{{company_name}}

{{company_address}}

Phone: {{company_phone}}

Email: {{company_email}}

Website: {{company_website}}

Depreciation Worksheet for the Financial Year Ended {{financial_year_end_date}}

This worksheet details the depreciation calculations for fixed assets held by {{company_name}} for the financial year ending {{financial_year_end_date}}.

Asset Register Information

Asset ID: {{asset_id}}

Asset Name: {{asset_name}}

Description: {{asset_description}}

Acquisition Date: {{acquisition_date}}

Cost (ZAR): {{asset_cost}}

Salvage Value (ZAR): {{salvage_value}}

Depreciation Method and Useful Life

Depreciation Method: {{depreciation_method}} (e.g., Straight-Line, Diminishing Value)

Useful Life (Years): {{useful_life_years}}

Depreciation Rate (%): {{depreciation_rate}}

Date Placed in Service: {{date_placed_in_service}}

Annual Depreciation Calculation

**Straight-Line Method:**

Annual Depreciation = (Cost - Salvage Value) / Useful Life

Annual Depreciation (ZAR): {{annual_depreciation_amount_straight_line}}

**Diminishing Value Method:**

Annual Depreciation = (Book Value at beginning of year * Depreciation Rate)

Book Value at beginning of year (ZAR): {{beginning_book_value_diminishing}}

Annual Depreciation (ZAR): {{annual_depreciation_amount_diminishing}}

Total Annual Depreciation for current year (ZAR): {{total_current_year_depreciation}}

Accumulated Depreciation and Net Book Value

Accumulated Depreciation at prior year-end (ZAR): {{accumulated_depreciation_prior_year}}

Accumulated Depreciation at current year-end (ZAR): {{accumulated_depreciation_current_year}}

Net Book Value at current year-end (Cost - Accumulated Depreciation) (ZAR): {{net_book_value_current_year}}

Summary of Depreciation Schedule

| Year | Beginning Book Value (ZAR) | Depreciation Expense (ZAR) | Accumulated Depreciation (ZAR) | Ending Book Value (ZAR) |

|---|---|---|---|---|

| {{year_1}} | {{beginning_book_value_1}} | {{depreciation_expense_1}} | {{accumulated_depreciation_1}} | {{ending_book_value_1}} |

| {{year_2}} | {{beginning_book_value_2}} | {{depreciation_expense_2}} | {{accumulated_depreciation_2}} | {{ending_book_value_2}} |

| {{year_N}} | {{beginning_book_value_N}} | {{depreciation_expense_N}} | {{accumulated_depreciation_N}} | {{ending_book_value_N}} |

Notes and Remarks

{{notes_and_remarks}}

Prepared By

Name: {{preparer_name}}

Position: {{preparer_position}}

Date: {{preparation_date}}

Authorisation and Approval

Approved By:

_________________________

{{approver_name}}

{{approver_position}}

Date: {{approval_date}}