All tools

Straight-line depreciation schedule

Compute the periodic charge and carrying amount from an asset's cost and useful life.

Result

Charge per period
21600.00
Depreciable amount
108000.00
Closing carrying amount
12000.00

Download the workbook

The method

  1. (Cost − residual value) ÷ number of periods = the charge per period.
  2. The carrying amount falls by the charge each period until it reaches the residual value exactly.
  3. The final charge absorbs the rounding difference so no fraction is left stranded.

Built forAn accountant reviewing an entry or balance before close

When you need it

You have connected figures that need testing before they enter the close file. Compute the periodic charge and carrying amount from an asset's cost and useful life.

The decision it supports

Use the result to decide whether the work can be accepted or a difference or classification needs tracing. The tool shows its method beside the result so you can review it.

What you receive

Straight-line depreciation schedule result

A shareable interactive result with findings, calculation method and an Excel workpaper carrying the same figures.

An example you can inspect

A ready-to-run example

The tool opens with: Asset cost = 120000.00, Residual value = 12000.00, Useful life = 5. Change any value to see its effect immediately.

Continue the workflow