This is Part 5 of our five-part series on IAS 16 Property, Plant and Equipment. Parts 1 through 4 walked through recognition, initial and subsequent measurement, depreciation methods, component accounting, disposal, and disclosure. This part is a free, interactive Fixed Asset Schedule Generator — a calculator that takes an asset’s cost, salvage value, useful life, purchase date, and financial year end, and instantly builds a complete, correctly prorated year-by-year depreciation schedule using either the straight-line or declining-balance method.

Why Purchase Date and Financial Year End Matter

Most manually-built depreciation spreadsheets quietly get the first and last year wrong. If a $50,000 machine with a 9-year useful life is purchased on 15 July but the company’s financial year ends on 31 December, the first accounting period only covers roughly 5.5 months of that asset’s life — not a full year. Charging a full year’s depreciation in that first period overstates the expense (and understates net book value) for that period, and the error persists until the asset’s very last period, when it then understates the final charge to compensate. Over the life of one asset this might look immaterial, but multiply it across a full fixed asset register with hundreds of purchases spread across the year, and the distortion to any single period’s reported profit can be significant.

The generator below solves this by treating the purchase date and financial year end as first-class inputs, not an afterthought. It automatically works out how many days fall into the first (partial) accounting period, applies a proportional share of a full year’s depreciation to that period, then charges full periods until the asset’s useful life is nearly exhausted, and finally prorates the last period down to whatever time remains — so the schedule always lands exactly on the residual value you specified, in exactly as many periods as the asset’s useful life actually spans.

Fixed Asset Schedule Generator

Enter the asset’s cost, salvage (residual) value, and useful life in years, along with its purchase (in-service) date and your company’s financial year end. Choose straight-line or declining balance, and the schedule below updates instantly — showing each period’s date range, opening book value, depreciation expense, accumulated depreciation, and closing book value.

How to Read the Schedule

The first row will usually be a partial period running from the purchase date to the next financial year end, labelled with the number of months it covers. Every full row after that spans exactly one financial year (12 months). The final row is also partial — it runs from the last full financial year end to the date the asset's useful life is fully exhausted, and the tool forces its closing book value to land exactly on the salvage value you entered, so the schedule always reconciles precisely rather than leaving a small unexplained residual from rounding.

For the declining balance method, the tool defaults the rate to the "double-declining" convention (200% divided by useful life), which you can override with any rate your accounting policy specifies. As with straight-line, the residual value acts as a hard floor: once the declining charge would take the book value below salvage, that period's depreciation is capped so the asset never depreciates past its residual value.

This calculator is provided for illustration and planning purposes. It applies the mechanics described in Parts 1 through 4 of this series but does not replace professional accounting advice specific to your asset class, jurisdiction, and accounting policy — particularly where component depreciation, revaluation, or units-of-production methods are more appropriate than a simple time-based schedule.