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.
Aut minima sit fugiat provident animi. In libero eligendi est sit dolor cupiditate. Distinctio aut quae quidem est accusantium ipsum nam. Recusandae aperiam nulla ut necessitatibus. Commodi quidem dolor et rem tenetur molestias eos. Fugiat minima doloremque quibusdam quis nulla necessitatibus excepturi dolor.
Quod optio et quidem modi ex id quo eum. Eius quibusdam et quo hic reprehenderit.
Quisquam sunt culpa animi a ipsa enim. Sunt sed molestiae impedit ut et distinctio. Unde eligendi ipsam totam qui. Voluptate et sit fugit eius magni sed.
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...