Latest News

Units of Production Depreciation Method with Formula in Excel

By Ramanand

units of production depreciation

You can’t simply pre-determine an automated entry to account for depreciation as you would with timeline based depreciation methods since you cannot predict the level of production for future years. This method is also not accepted for tax purposes so using units of production to determine depreciation will need a conversion to the tax depreciation expense. Units of Production Depreciation, also known as the Units of Activity Depreciation, is a method of calculating depreciation expense for an asset based on its usage or production output rather than the passage of time.

  • Deskera can also help with your inventory management,  customer relationship management, HR, attendance and payroll management software.
  • The units of production depreciation technique is used in two instances below to compute depreciation for fixed assets.
  • This means your tax depreciation won’t line up exactly with your book depreciation, but as long as you are aware of this and know why the two amounts don’t match, it won’t cause a problem.
  • Thus, a business may charge more depreciation in periods when there is more asset usage, and less depreciation in periods when there is less usage.
  • Content sponsored by Kovar Wealth Management LLC (DBA “Finance Strategists”).
  • This is well suited for companies owning equipment and machinery that accumulates wear and tear depending on production.

Likewise, the company can calculate units of production depreciation after it has appropriately measured the output as a result of the fixed asset usage during the period. There are four allowable methods for calculating depreciation, and which one a company chooses to use depends on that company’s specific circumstances. Small businesses looking for the easiest approach might choose straight-line depreciation, which simply calculates the projected average yearly depreciation of an asset over its lifespan.


Not calculating depreciation will keep you away from realizing the actual value of the asset at that time. An over-recorded value will show higher profits and hide the incurred losses. Moreover, the profit uncertainty could mislead the prospective investors and will eventually impede the overall business performance.

This formula is best for production-focused businesses with asset output that fluctuates due to demand. This formula is best for companies with assets that lose greater value in the early years and that want larger depreciation deductions sooner. This formula is best for small businesses seeking a simple method of depreciation. Such companies require to see through the profit and loss picture clearly which the method presents them with.

What is the Unit of Production method?

Time is usually a key component of how to calculate depreciation of an asset (as seen in the straight line or the accelerated methods). The name of the method is a pretty good giveaway, this method of depreciation depends on the number of units produced by an asset during a financial period. To start, a company must know an asset’s cost, useful life, and salvage value. Then, it can calculate depreciation using a method suited to its accounting needs, asset type, asset lifespan, or the number of units produced. The units of production depreciation is suitable for the type of fixed asset that produces the output of usage or production differently from one period to another. This is because the process of allocating the cost of the fixed asset under the units of production depreciation should result in the fluctuation of depreciation expense from one period to another.

It’s calculated by subtracting the original cost from what it would have been worth if sold at a certain point in time and then dividing that number into how many years passed since its release date. Depreciable cost can be determined by using the cost of the fixed asset deducting its estimated salvage value. Deskera Books is an online accounting software that your business can use to automate the process of journal entry creation and save time. The double-entry record will be auto-populated for each sale and purchase business transaction in debit and credit terms. Deskera has the transaction data consolidate into each ledger account.

Posts from: Depreciation Formula in Excel

Annual depreciation is derived using the total of the number of years of the asset’s useful life. The SYD depreciation equation is more appropriate than the straight-line calculation if an asset loses value more quickly, or has a greater production capacity, during its earlier years. The four depreciation methods include straight-line, declining balance, sum-of-the-years’ digits, and units of production.

  • The main objective of this article is to explain how to calculate the Units of Production Depreciation method with formula in Excel.
  • Realistically, the depreciation expense shown using this method considers the percentage of the asset’s capacity that was used up for that year.
  • I will use this dataset to show you the step-by-step procedures to calculate the Units of Production Depreciation method with formula in Excel.
  • You may use QuickBooks to keep track of all of your fixed asset acquisitions so you don’t have to start from zero with a depreciation plan.
  • Suppose a manufacturing company is tracking its depreciation expense under the units of production method.