Depreciation of Capital Expenditures

1 minutes read
Last updated: August 23, 2023

As the company makes capital investments, these assets will also depreciate. Now, let’s add the depreciation associated with future capital expenditures. Our P&L only goes out to 2012, so to we forecast capex in further years by assuming by flat-lining capex as a percent of sales. We have also built into our model the flexibility to choose between our calculated depreciation expense and the depreciation expense forecasted by Wall Street analysts. Computing depreciation expense manually is more labor-intensive and requires more detailed information about the company. In the absence of such information, or to build the LBO model more quickly, you will want to use the analyst projections for depreciation expense rather than build this detailed depreciation schedule.

 

Download Template

Depreciation of Capital Expenditures

Try Macabacus for free to accelerate financial modeling in Excel.

Speed Up Financial Modeling with Macabacus

Watch the Macabacus Demo

Save 100s of hours annually with custom shortcuts, formula auditing and linking Excel to PowerPoint.

Watch a Demo Video

Discover more topics

Build an operating model
In this tutorial, we will walk through how to build a general industry business operating model.
Read more
Build an M&A model
In this section, we demonstrate how to model a merger of two public companies in Excel.
Read more
Build an LBO model
In this tutorial, we will walk you through building an LBO model in Excel.
Read more
Asset and Stock Deals
The first step in purchase price allocation, or PPA, is to determine the purchase price.
Read more