Depreciation Schedules
A depreciation schedule allocates the cost of fixed assets across their useful lives in financial models. It’s critical for accurate income statement and balance sheet modeling—depreciation reduces taxable income, creates deferred tax liabilities, and ties directly to capex and free cash flow calculations.
Why Depreciation Matters in Financial Models
Depreciation is a non-cash expense that reduces reported earnings but provides a tax shield. In a three-statement model, depreciation appears on the income statement, affects the balance sheet’s property, plant, and equipment (PP&E), and reconciles cash flow because it’s added back in the operating cash flow section.
Without a proper depreciation schedule, your model will misstate taxable income, overstate or understate EBITDA margins, and incorrectly forecast unlevered free cash flow. The schedule also determines deferred tax assets or liabilities if book depreciation differs from tax depreciation.
Depreciation Methods
Different depreciation methods produce different expense patterns. The method you choose depends on asset type, company policy, and accounting standards (GAAP or IFRS).
| Method | Description | When to Use |
|---|---|---|
| Straight-Line | Equal annual expense over useful life | Buildings, office equipment, most book depreciation |
| Declining Balance | Higher expense early, declining over time | Vehicles, machinery with faster obsolescence |
| Units of Production | Expense tied to usage or output | Manufacturing equipment, delivery vehicles |
| MACRS | Modified accelerated cost recovery system (US tax only) | Tax depreciation on US fixed assets |
For most financial models, straight-line depreciation is the standard for book purposes. The formula is:
For example, a $100,000 machine with a 10-year useful life and $10,000 salvage value depreciates at ($100,000 − $10,000) ÷ 10 = $9,000 per year.
Linking Capex to Depreciation
The depreciation schedule must integrate with the capex forecast and PP&E balance sheet schedule. Every dollar of capex eventually becomes a depreciation expense stream.
The PP&E roll-forward works as follows:
In practice, you’ll forecast capex as a percentage of revenue or absolute amount. That capex then begins depreciating based on the asset’s useful life. If you add $50,000 in machinery in Year 1 with a 10-year life, it contributes $5,000 in annual depreciation starting in Year 1 (or Year 2, depending on your convention).
Building the Depreciation Schedule
There are two common approaches: the vintage method and the simple method.
Vintage Method: Track each capex addition by year and calculate depreciation separately. This is precise and handles mid-year purchases correctly, but requires more line items in the model.
Simple Method: Assume all capex occurs at year-end or mid-year, and calculate one depreciation line per year. Faster to build but less accurate if capex is irregular.
For LBO models and DCF valuation models, use the vintage method if capex is material and varies by year. For quick valuation scenarios or models where capex is stable, the simple method works fine. Always check your firm’s modeling standards.
Step-by-step build (simple method):
- Forecast capex as a percentage of revenue or absolute amount (e.g., 5% of sales).
- Assign a useful life to each asset class (e.g., machinery = 7 years, vehicles = 5 years, buildings = 30 years).
- Calculate beginning accumulated depreciation from historical financials.
- For each year, calculate depreciation on the current-year capex using a half-year convention (assume purchases occur mid-year).
- Add depreciation for prior-year capex cohorts still depreciating.
- Sum total depreciation and subtract from gross PP&E to get net PP&E for the balance sheet.
Amortization of Intangibles
Amortization is depreciation’s cousin—it applies to intangible assets like patents, software, customer relationships, and goodwill.
Like depreciation, amortization is a non-cash expense. But intangible asset useful lives are often longer and more arbitrary. In GAAP accounting, goodwill is not amortized; instead, it’s tested for impairment annually.
| Intangible Asset | Typical Useful Life |
|---|---|
| Patents | 5–20 years |
| Software | 3–7 years |
| Customer relationships | 10–15 years |
| Trademarks | 10–20 years |
| Goodwill | N/A (impairment tested annually) |
In your model, handle amortization separately from depreciation on the income statement but follow the same roll-forward approach on the balance sheet.
Tax Depreciation vs. Book Depreciation
US companies often use different depreciation methods for tax and book purposes. Book depreciation (typically straight-line) is used for financial reporting under GAAP. Tax depreciation uses MACRS (Modified Accelerated Cost Recovery System), which front-loads deductions.
When tax depreciation exceeds book depreciation, the company pays less tax today but creates a deferred tax liability on the balance sheet. When book depreciation exceeds tax depreciation (rare), a deferred tax asset forms. Your model must calculate both and reconcile the difference to the deferred tax line.
Section 179 expensing and bonus depreciation allow immediate deductions for certain assets, further complicating the book-vs.-tax split. Always consult tax guidance for your jurisdiction and company policy. In financial models, if the deferred tax impact is immaterial, you may skip it; if material, build a full deferred tax schedule.
Integration with Financial Statements
Depreciation flows through all three financial statements:
Income Statement: Depreciation and amortization appear as operating expenses, reducing EBIT (earnings before interest and taxes). This reduces taxable income and, consequently, tax expense.
Balance Sheet: The depreciation schedule updates gross PP&E (cumulative capex) and accumulated depreciation, netting to book value of PP&E. Intangible assets and goodwill are similarly shown net of accumulated amortization.
Cash Flow Statement: Depreciation is a non-cash expense, so it’s added back in the operating activities section of the cash flow statement. This is why EBITDA (earnings before depreciation and amortization) is a useful proxy for cash generation.
In a full three-statement model, ensure your depreciation schedule ties cleanly: income statement expense = accumulated depreciation change on the balance sheet, and operating cash flow adds it back.
Key Takeaways
- Depreciation is critical to financial modeling. It directly impacts taxable income, cash flow, and balance sheet valuation.
- Straight-line is the default for book purposes. It’s simple and appropriate for most models unless the company explicitly uses another method.
- Link depreciation to capex. Every capex dollar eventually depreciates; your schedule must track this linkage over the asset’s useful life.
- Use the vintage method for precision. When capex is material and variable, track depreciation by vintage year to avoid errors.
- Consider tax depreciation if material. MACRS and other accelerated methods create deferred tax items that affect valuation.
- Integrate across all three statements. Depreciation on the income statement, PP&E on the balance sheet, and add-back in cash flow must all reconcile.
- Amortization follows the same logic. Intangibles depreciate (or amortize) just like tangible assets, though useful lives and methods may differ.
Frequently Asked Questions
What’s the difference between depreciation and amortization?
Depreciation applies to tangible assets (buildings, equipment, vehicles). Amortization applies to intangible assets (patents, software, licenses). Both are non-cash expenses that reduce taxable income. The accounting treatment is identical; only the asset type differs.
Should I use straight-line or accelerated depreciation in my model?
Use straight-line for book depreciation in most models—it matches the company’s financial reporting. For tax depreciation, use MACRS in the US. If the company publishes financial statements using another method (e.g., declining balance), match that. Always check the company’s accounting policy note in the 10-K.
How do I handle mid-year capex?
The simplest approach is the half-year convention: assume all capex occurs mid-year, so depreciation begins at 50% in the purchase year. More precisely, use the vintage method and assign a specific acquisition date to each capex cohort. For most models, half-year is acceptable.
What useful lives should I assume?
Check the company’s 10-K or financial statement notes—they’ll disclose useful life assumptions by asset class. Common ranges: buildings 20–50 years, machinery 5–10 years, vehicles 3–7 years, software 3–5 years. If modeling a new company, research industry norms or use average ranges.
Why do I need to model deferred taxes if depreciation is non-cash?
Deferred taxes arise because tax depreciation (MACRS) typically exceeds book depreciation (straight-line) early in an asset’s life. This creates a deferred tax liability on the balance sheet—a real obligation to pay higher taxes later. If the deferred tax balance is material relative to equity value, it must be included in your model and DCF valuation.
Related Articles: Three-Statement Model, Expense Modeling, Working Capital Modeling, DCF Valuation Guide
Glossary Terms: Depreciation, Amortization, Capex, EBITDA, Free Cash Flow, Operating Cash Flow, Income Statement, Balance Sheet, Cash Flow Statement, Goodwill, GAAP
Cheat Sheets: Financial Statements Quick Reference