# Activity Based Depreciation Formula

**The Sln function can be used to calculate straight line depreciation in Excel during a single period of an assets useful life.**

**Activity based depreciation formula**.
This is similar to the straight-line method except for that life of the asset is estimated based on the activity driving the asset like a number of machine-hours the number of setups the number of units produced and etc.
The activity method calculation requires 2 equations.
What is activity method of depreciation.

Depreciation Base Cost Salvage value. Examples of such assets include vehicles and machines. Management accountants often use this method when it more closely matches economic reality.

There are various methods to calculate depreciation one of the most commonly used methods is the straight-line method keeping this method in mind the above formula to calculate depreciation rate annual has been derived. The unit of production or activity-based method results in varying depreciation amounts over the useful life of the assets. Straight line depreciation is the most basic type of depreciation.

Under the units of activity method the company will record 2 of depreciation whenever it finishes a product. The depreciation rate can also be calculated if the annual depreciation amount is known. In the unit of production method depreciation is charged according to the actual usage of the asset.

In accountancy this approach assumes that the depreciation should be determined in direct relation with the usage or the productivity of the asset and not by the traditional way that relates the amortization to the time usage. For example at the beginning of the year the asset has a remaining life of 8 years. Depreciation Base 25000 0 25000.

Company ABC bought machinery worth 1000000 which is a fixed asset for the business. In an accounting year when 8000 units are finished the depreciation will be 16000. Activity-based costing can be computed by assigning all the indirect cost which is incurred to the identified various types of cost umbrella So the formula for Activity Based Costing Activity Based Costing Cost Pool Total Cost Driver Examples of Activity Based Costing Formula With Excel Template.

Copyright by Brian R. 225000 - 25000 divided by the expected 100000 units of product. The depreciation rate is the annual depreciation amount total depreciable cost.