Depreciation of Capital Expenditures

1 minutes read
Last updated: November 6, 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

Download Template

Depreciation of Capital Expenditures

Try Macabacus for free to accelerate financial modeling in Excel.

Create Financial Models 10x Faster with Macabacus

Gain access to 100+ shortcuts, formula auditing visualizations, easy Excel-to-PowerPoint linking and productivity tools to help you accelerate financial modeling and presentations.

Start your Free Trial
 

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