Excel workbook .xlsx

Fixed Asset and Depreciation Calculator

Calculate straight-line depreciation and year-end book values from your asset register.

$449 USD

Purchase now

What’s inside

  • Asset cost, residual value, and useful life inputs
  • Straight-line depreciation starting in the service month
  • Opening accumulated depreciation and closing book value

Frequently asked questions

Which depreciation method does the workbook use?

It uses straight-line depreciation starting in the month the asset enters service. Enter cost, residual value, and the useful life in whole months.

What file format is included?

The template is a Microsoft Excel .xlsx workbook. It includes a Start Here tab with setup instructions and a worked example.

Which cells can I edit?

Use the blue cells for your entries. Green cells contain formulas and update as you enter your data.