Modeling the IS - in what order do you list the line items?
Started a new job at a bank, and love it, but I don't have too much experience in building an operating model. Would appreciate to hear from those with more experience.
Question: I'd like to know a good logical order to use to present the line items of the income statement.
- Do you usually put EBITDA before EBIT?
- Do you exclude D&A from COGS or from SG&A?
In Training the Street, they teach:
Sales
(COGS excl. depreciation)
= Gross Profit
(SG&A excl. amortization)
= EBITDA
Dep
Amort
= EBIT
That order is very logical, but getting (COGS-Dep.) and (SG&A-Amort.) is not always easy. Sometimes D&A is listed together, sometimes I'm not sure if that stuff was a component of COGS or SG&A, etc.
So I've sometimes used:
Sales
(COGS)
= Gross profit
(SG&A)
= EBIT
+ D&A
= EBITDA
.... then I take away tax, interest, etc. from EBIT. So EBITDA is sort of sticking out in the middle, and the logic doesn't flow quite as well as you move from the top to the bottom.
What do you guys do? Thx.
*(in the Training the Street version, obviously they're subtracting D&A to get to EBIT -- I forgot to put those in parentheses...) Thx again
*(in the Training the Street version, obviously they're subtracting D&A to get to EBIT -- I forgot to put those in parentheses...) Thx again
Never usually calculate EBIT, just go down to Net Income and then calc EBITDA below that. I always try to separate out D&A from the various line items in which it might be included.
Minima qui suscipit nulla voluptatibus consequatur et accusamus dolorum. Doloremque veritatis magni commodi quasi. Minima ut aperiam optio cupiditate. Et odit dolorem exercitationem nihil ipsa dolorem sapiente eum. Autem quibusdam est molestias accusantium rerum soluta sunt.
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...