D&A in 3-statement model
When forecasting a 3-statement model, is it standard practice to subtract D&A from COGS & SG&A expenses and have a line item for EBITDA then subtract out D&A below it to get to EBIT? Wouldn't this overstate the company's gross margin or is this considered a truer picture of the company's gross margin as it takes out the non-cash expenses? Also what do you do if d&a expense is different from d&a on the CFS? Would you take out the amount of D&A from the CFS?
First of all, let's start on forecasting depreciation. Overall, there's various methodologies when considering how to forecast depreciation in a three statement model (from what I've seen).Typically, in a simple model, you can either forecast depreciation by allocating the overall expense to a percentage of sales, a percentage of CapEx or setting it equal to CapEx.
As for amortization, this is typically done in a similar manner to depreciation in a simplified model. Although there could be some wrinkles here in advanced models pertaining to the amortization of intangibles arising from purchase accounting.
Moving into how this ties into the modeling, it really depends on the model, especially considering how companies show their depreciation and amortization expense on the income statement versus the statement of cash flows. Specifically, one thing we have to keep in mind for the income statement is the fact that some depreciation and amortization is housed within the operating expense line items - you should be able to find the precise figures relating to operating expenses (SGA, R&D, etc.) allocation to D&A expense as a note to the financial statements in their 10-Ks. As a result, the statement of cash flows will provide more comprehensive picture of these non-cash expenses. That being the case, when we're tackling this problem in the modeling, we have to be cognizant to either, 1.) remove the entrenched D&A from the income statement items in our forecast and the historical period for an apples to apples comparison, or 2.) assume the D&A expense will remain in those operating expense line items and not show the expense as a separate line item on the income statement, but as a memo to the income statement.
Consequently, in your modeling, the total D&A expense will be the exact same on the income statement and the statement of cash flows.
As for the EBITDA question, again, this really depends on the modeler, as well as the company. I've seen models that don't show EBITDA as a line item, but as a memo and I've seen models that show the progression from gross profit to EBITDA to EBIT and so on. So, the approach you choose to calculate D&A on the income statement will ultimately decide how you want to approach the line items on the income statement. By way of example, if you want to show D&A as a separate item on the income statement, you can subtract the operating expenses from gross profit to reach EBITDA, then subtract D&A and stock based compensation (SBC) to reach EBIT, and so on.
EBITDA is also known as a proxy for cash flow, due to the fact the non-cash expenses are stripped from the calculation. This can overstate the company's performance in a sense, depending on who you ask - Warren Buffet is on record saying he prefers EBIT due to the fact the the 'toothfairy' doesn't pay for capital expenditures (same logic can be applied to SBC). With that in mind, if you're of the mindset cash is king, EBITDA is without a doubt one of the more prevalent methodologies in pricing deals.
Odit corrupti ipsa voluptatibus rerum. Beatae non praesentium aut quo eum. Provident id facere iure dolore odio vero. Officiis maiores repudiandae quos dolores asperiores rerum fugiat. Porro voluptas nihil itaque quisquam ratione qui. Alias quibusdam itaque quae sed aliquam tempore totam minima. Aut deserunt eius a praesentium consectetur adipisci.
Nam doloremque qui ipsa et. Nam qui aut accusamus cum distinctio. Alias voluptas molestiae est consequatur dolorem amet mollitia veniam. Vero culpa nihil ut cumque. Inventore cum quibusdam nemo. Qui ut illum laboriosam voluptas vel id dolorem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...