Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
Depreciation occurs as an economic asset is used up. Economic assets are different types of property, plant, and equipment (PP&E). As the assets are used, they begin to degrade and lose value. Different assets lose value at different rates. A depreciation schedule helps to calculate the differences.
The schedule will list the different classes of assets, the type of depreciation method they use, and the cumulative depreciation they’ve incurred at various points in time. The depreciation schedule may also include historic and forecasted capital expenditures (CapEx).
To begin, create the structure for the depreciation schedule as follows. The first line item to be referenced should be sales revenue. This is because sales revenue is a common driver for both capital expenditures and depreciation expense.
Below this, prepare a section for capital expenditures and reference historical CapEx from any available periods. Project future capital expenditures by using an appropriate forecasting assumption. Apply intuition to determine the proper forecasting assumption to use from the following:
CapEx as a percentage of sales
Fixed recurring amount
Reasonable “hard dollars” that one would expect a company to incur as they operate
This Forecast will Depend on the Type of Operation
If applying the CapEx as a percentage of sales method, divide CapEx by sales to find capital expenditure as a percentage of sales. Use these percentages to create an assumption about future capital expenditures as a percentage of sales. Multiply this against projected sales to find a forecast for capital expenditure.
Prepare a section for depreciation expense and reference historical depreciation expense for any available periods. With depreciation expense, if you are unable to determine the company’s depreciation policies, you may need to interpret what they are from historical data. Apply judgment based on the industry and business undertaken to select assumptions from the following:
Depreciation expense as a percentage of CapEx
Depreciation expense as a percentage of net PP&E
Depreciation expense as a percentage of sales
Reasonable growth rate
If it seems that the depreciation expense has remained constant, the company may be using a linear depreciation policy, such as the straight-line depreciation method. In such a case, it is handy to use depreciation expense as a percentage of net PP&E, or to simply roll forward the recurring depreciation amount.
Summarizing the Depreciation Schedule
At the bottom of the depreciation schedule, prepare a breakdown of the net change in PP&E. This begins with the beginning balance of PP&E, net of accumulated depreciation. From this beginning balance, add capital expenditures, subtract depreciation expense, and also subtract any sales or write-offs. The final total should be the ending balance of PP&E, already net of accumulated depreciation.
At this point, it may be prudent to smooth the projections. If it seems that the trend in the future is lumpy, or the relationship between future CapEx and depreciation expense becomes dissimilar, consider revisiting the forecasting assumptions for each item. Real estate is a specific industry that requires heavy use of the depreciation schedule.
While the three core statements are the backbone of a financial model, the depreciation schedule is one of many supporting schedules that help solidify the model. To keep advancing your career, the additional CFI resources below will be useful:
Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy.
A well rounded financial analyst possesses all of the above skills!
Additional Questions & Answers
CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation. CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path.
In order to become a great financial analyst, here are some more questions and answers for you to discover:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.