P4 Software
/
activoHQ English
The Depreciation What-If simulator compares two depreciation scenarios side by side on the same chart: different methods, different useful lives or different cost assumptions. It exists to help you decide before the asset is registered, to support an Accounting policy, or to answer the classic committee question: how much does the expense change if I depreciate this over 5 years instead of 3?
It also includes a simple lease versus buy comparison.
Nothing entered on this screen is saved. It is an analysis tool: it does not change Assets, does not produce journal entries and does not affect the Depreciation runs.
Reports > Depreciation What-If
Direct URL: /Reports/depreciation-what-if
For each scenario, complete:
| Field | Description |
|---|---|
| Cost (required) | The assumed acquisition cost. |
| Salvage value | The salvage value at the end of the useful life. |
| Useful Life (months) (required) | Months of depreciation. |
| Depreciation method | Straight-line, Declining balance or Units of production. |
| Declining Balance Factor | Declining balance only. Blank is equivalent to 2.0 (double declining balance). |
| Total Estimated Units | Units of production only: the asset's total expected output. |
| Assumed units per period | Units of production only: because future usage is unknown, the projection assumes this constant quantity in every period. Fill in both unit fields for this method. |
| Half-year convention | Halves the depreciation charge of each of the first six months. |
Click Compare Scenarios. The comparison is also calculated when the page opens, with the default values, but it does not update as you type, so click the button again after every change. The Comparison section shows:
| Indicator | What it shows |
|---|---|
| Total depreciation over useful life | How much is depreciated in total in each scenario. |
| First-year charge | The impact on the first year's result. |
| Month NBV reaches near-zero | The month in which the Net Book Value gets down to the salvage value (within 0.01), that is, when the depreciable value runs out; it shows Not reached if that does not happen within the projected useful life. |
| Symptom | Likely cause | Resolution |
|---|---|---|
| The figures or the chart do not change after I edit a scenario. | The comparison is only recalculated when you click Compare Scenarios. | Click Compare Scenarios. |
| A Units-of-production scenario shows no result. | Total Estimated Units or Assumed units per period is blank. Load copies the total estimated units but not the assumed units per period. | Fill in both unit fields in the scenario, then click Compare Scenarios. |
| The two scenarios look identical. | They were loaded from the same asset and nothing was changed. | Change the method, the useful life or the cost in one of them. |
| The month indicator shows Not reached. | A Units-of-production scenario does not use up the depreciable value within the useful life with the assumed units per period. (Straight-line and declining balance always reach the salvage value in the last month.) | Raise Assumed units per period or lower Total Estimated Units to see when the value runs out, or compare against a straight-line scenario. |
| The results do not match the real run. | The real asset uses a different depreciation book or different in-service dates, or the scenario uses a declining balance factor other than 2.0 or the half-year convention, which real runs do not apply. | Compare against the asset's Depreciation Schedule. |
Was this page helpful?