Depreciation is an important accounting concept that helps track the loss in value of an asset over its useful life. The IRS defines depreciation as the accounting for the aging of assets, i.e., the process of allocating the cost of an asset over the years it is used in business operations, allowing for deductions to recover that cost. Click here to learn more about the IRS guidelines on depreciation.
In this article, we’ll break down the steps to create a depreciation schedule, explain straight-line and accelerated depreciation methods, and explore the relationship between depreciation, deferred taxes, and financial reporting. By the end, you’ll have a comprehensive understanding of how to accurately calculate depreciation expense and use it effectively in financial modeling and planning.
What is a Depreciation Schedule?
A depreciation schedule is required to track the loss in value of an individual asset over its useful life or a company’s total fixed assets over their useful life. It includes essential components such as the original cost of the asset, the annual depreciation expense for each year, and the accumulated depreciation after each accounting period.
This schedule is required in financial modeling and financial reporting to ensure the value of a firm’s fixed assets is accurately represented on the balance sheet. Additionally, it plays a vital role in calculating tax depreciation, enabling businesses to claim depreciation deductions while planning future capital expenditures.
Understanding Depreciation: Straight-line Method
Understanding depreciation is crucial for accurate financial reporting. Depreciation occurs when the value of an economic asset declines over time due to wear and tear, obsolescence, or other factors. Depreciation is a non-cash expense that reflects the decline in the value of a company’s property, plant, and equipment (PP&E) on the balance sheet after subtracting depreciation expense.
Straight-line depreciation is the most common method of depreciation used under Generally Accepted Accounting Principles (GAAP), i.e., the method used in the financial statements of most publicly listed U.S. enterprises. It assumes that an asset depreciates evenly over its useful life, either to a value of zero or to a set salvage value, such as scrap parts that can be sold.
Depreciation Formula: How to Calculate Depreciation Expense on Fixed Assets
Calculating depreciation expense is a key step in preparing financial statements. The depreciation formula used for straight-line depreciation is:
Cost – Salvage Value / Useful Life
For example, if a fixed asset has an original cost of $50,000, a salvage value of $5,000, and a useful life of 10 years, the annual depreciation expense would be:
($50,000 – $5,000) / 10 = $4,500
Understanding Accelerated Depreciation Methods
Accelerated depreciation methods allocate a larger portion of the depreciation expense to the earlier years of an asset’s life. This approach reduces taxable income in the early years and increases it in later years, which can be beneficial for businesses seeking to defer tax liabilities. Common accelerated depreciation methods include:
Double-Declining Balance (DDB) Depreciation
This method applies a constant percentage to the remaining value of the asset, resulting in higher depreciation expenses in the early years. It follows this formula:
Since the depreciation is applied to the remaining value of the asset, rather than the original cost, the amount decreases each year. Unlike straight-line depreciation, the depreciation schedule is to give businesses a front-loaded expense, meaning less depreciation is recorded in later years. In the final year, depreciation is adjusted so the asset reaches its salvage value or zero.
Sum-of-Years’ Digits (SYD) Depreciation
This method allocates depreciation based on a declining fraction of the asset’s total useful life. The sum of the years’ digits is calculated as:
where n is the asset’s useful life in years. The depreciation expense for each year is determined by multiplying the remaining years of useful life by the asset’s cost, then dividing by the SYD total. This method results in a decreasing depreciation expense over time and maximizes depreciation tax benefits in the earlier years of the asset’s life.
Modified Accelerated Cost Recovery System (MACRS)
The MACRS method is the primary depreciation system used in the U.S. for tax purposes. It is a government-mandated system that applies different depreciation rates based on company’s fixed assets class and useful life, as defined by the IRS. MACRS allows businesses to claim larger depreciation tax benefits in the initial years of an asset’s use.
Under MACRS, the declining balance method is used for most asset classes, except for real property, which follows the straight-line method. MACRS also employs a mid-year convention, meaning assets are assumed to be placed in service at the midpoint of the tax year, regardless of the actual purchase date.
MACRS Depreciation Table (Mid-Year Convention)
The IRS provides predefined MACRS depreciation schedules for different asset classes. Below is a sample MACRS 5-Year Property Class Table (from IRS guidelines):
| Year | 3-Year Property | 5-Year Property | 7-Year Property | 10-Year Property |
|---|---|---|---|---|
| 1 | 33.33% | 20.00% | 14.29% | 10.00% |
| 2 | 44.45% | 32.00% | 24.49% | 18.00% |
| 3 | 14.81% | 19.20% | 17.49% | 14.40% |
| 4 | 7.41% | 11.52% | 12.49% | 11.52% |
| 5 | 0.00% | 11.52% | 8.93% | 9.22% |
| 6 | 0.00% | 5.76% | 8.92% | 7.37% |
(Source: IRS MACRS Depreciation Tables)
For assets that fall under 5-year property (e.g., computers, vehicles, and machinery), the depreciation schedule would allocate 20% in the first year, 32% in the second year, and so on, until the asset is fully depreciated. The bottom of the depreciation schedule often reflects near-zero depreciation as the asset nears the end of its useful life.
Understanding the schedule is crucial for financial forecasting, as businesses must account for future capex and depreciation expense when planning investments. Depreciation also plays a significant role in tax planning, as accelerated methods can significantly impact taxable income and cash flow.
Building an Asset Depreciation Schedule and a Tax Depreciation Schedule
Building a depreciation schedule is essential for tracking the decline in the value of a company’s assets. The depreciation schedule is a detailed record of the total amount of depreciation taken on an asset over its useful life.
Create a depreciation schedule by following these steps:
- Gather Asset Information: Determine the original cost of the asset, its estimated useful life, and its salvage value (if any).
- Determine Depreciation Method: Select the appropriate depreciation method you can use based on the type of asset and company policies.
- Calculate Annual Depreciation: Use the chosen depreciation method to calculate the annual depreciation expense for each year of the asset’s useful life.
- Track Accumulated Depreciation: Keep track of the total depreciation expense accumulated for the asset over time, i.e., the historical depreciation plus the last period’s depreciation amount. This can also be referred to as cumulative depreciation.
- Determine Asset Amounts: Subtract the accumulated depreciation from the original cost of the asset to determine the asset valuation at the end of each accounting period.
Using Excel to Create a Depreciation Schedule
Excel shortcuts can significantly speed up the process of building a depreciation schedule. You can use formulas to automate the calculations, making it easier to track depreciation and update the schedule as needed. Contact us for inquiries on finance-specific excel training.
Projecting Depreciation Using the Straight-Line Method of Depreciation and Accelerated Depreciation to Forecast Asset Values and Tax Deductions
When forecasting depreciation, analysts must make key assumptions about a company’s future capex, the useful life of the current asset base, and the useful life of new capex. For GAAP reporting, companies typically use the straight-line method, spreading costs evenly over an asset’s lifespan. For tax purposes, the MACRS method accelerates depreciation, allowing larger upfront deductions. The difference between these methods can create a deferred tax liability (DTL)—a temporary accounting difference where tax depreciation exceeds book depreciation. By projecting depreciation accurately, analysts ensure proper financial modeling, balancing cash flow impact, tax planning, and long-term asset valuation.
The Importance of Building a Depreciation Schedule
A solid depreciation schedule is vital for financial modeling, valuation, and business planning. It helps create the structure for tracking company’s depreciation on the balance sheet and connects financial statements in models. Various depreciation methods, such as the straight-line depreciation method or accelerated depreciation, are the basis for free cash flow projections and DCF valuation metrics.
For businesses and FP&A teams, a schedule based on accurate data aids tax planning by optimizing tax deduction and preparing depreciation expense forecasts. The first line item in the schedule typically reflects the assumption used in straight-line depreciation, ensuring consistency in financial reporting. The schedule includes insights for budgeting, forecasting, and capex as a percentage of revenue, helping manage different types of property, asset performance, and useful life.
Teams should prepare a section for capital expenditures, enabling them to calculate the depreciation and make decisions on asset replacement and resource allocation while ensuring operational and financial efficiency. A linear depreciation policy simplifies the process by using the straight-line approach, which is a common assumption used in straight-line depreciation. Since depreciation is typically recorded as a line item on the income statement, the depreciation schedule is to give businesses better visibility into asset valuation and financial planning.
Reporting Depreciation in Financial Statements
Reporting depreciation is an important part of the financial reporting process.
- Income Statement: Depreciation, a non-cash expense, is typically spread across COGS, Operating Expenses like SG&A, and other categories, reflecting the use of assets in operations. A good financial analyst will create a clean EBITDA by removing depreciation from these categories and listing them separately as Depreciation Expenses.
- Balance Sheet: The asset value is reported on the balance sheet after deducting accumulated depreciation. This reflects the carrying value of the asset.
- Cash Flow Statement: Depreciation is added back to net income in the operating activities section of the cash flow statement because it is a non-cash expense
Note: Each statement above includes a hyperlink to detailed article on our website including further information how depreciation impacts each financial statement individually.
Depreciation and Financial Performance
Depreciation has a significant impact on a company’s financial performance.
- Profitability: Depreciation is a non-cash expense that reduces a company’s net income. However, it also reduces the company’s taxable income, which can result in lower tax payments.
- Cash Flow: Depreciation is added back to net income in the cash flow statement, as it is a non-cash expense. This improves the company’s cash flow from operations.
- Asset Value: Depreciation reduces the value of a company’s assets on the balance sheet, which can affect the company’s overall financial position.
Depreciation and Asset Impairment
In some cases, the asset is used in a way that causes its value to decline more rapidly than the accurate depreciation recorded on the financial statements. This is known as asset impairment. When an asset is impaired, the company must write down the asset’s value to its fair market value.
An impairment expense would also hit the P&L and could be considered a non-recurring or extraordinary expense, depending on the probability of consistent reoccurrence.
At times, the impairment adjustment can significantly impact a company’s earnings, making it important to track both accurate depreciation and impairment losses. Unlike standard depreciation, impairment recognizes a sudden drop in value rather than a gradual reduction. The book value of the asset at the end of its useful life should reflect its recoverable amount unless the impairment renders it obsolete.
Depreciation and Capital Budgeting
Depreciation is an important consideration in capital budgeting decisions. When evaluating a new investment, companies must use depreciation to assess the impact on the project’s net present value and internal rate of return. The depreciation method used directly affects cash flow projections and tax benefits, making it a critical factor in financial modeling.
For instance, companies may apply straight-line depreciation rate for simplicity, spreading the cost evenly over an asset’s useful life. Alternatively, businesses might use double-declining balance depreciation to accelerate expense recognition in the early years. A possible approach for capital expenditures across many assets classes includes 5-year straight-line depreciation, which evenly distributes costs over five years.
When using the straight-line method, companies ensure predictable expense allocation, which helps in budgeting and financial forecasting. Regardless of the method chosen, understanding the asset’s depreciation pattern is key to making informed investment decisions.
Conclusion
Depreciation schedules chart the loss in value of an asset over its useful life. A well-maintained depreciation schedule is essential for accurate financial modeling & valuation, financial reporting, tax planning, and effective asset management. By understanding the different types of depreciation methods and following the steps outlined in this article, practitioners can build a depreciation schedule that meets their specific needs.
Curious about how to put these principles into practice? Download our free case study on the Financial Modeling LLC homepage, featuring a fully integrated 3-statement model. In this case study, you’ll learn how to build a detailed depreciation schedule and seamlessly integrate it into a dynamic financial model. Explore firsthand how depreciation impacts financial performance and enhance your modeling skills!
Do you have an inquiry? Schedule a free initial consultation