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.
Veritatis est harum atque voluptatibus ad est voluptas dolores. Sed aut optio sed sint et voluptatem. Sit facere tempore consequuntur debitis debitis. Possimus nulla repudiandae eum quo voluptatum reprehenderit.
Eum quia ut sint voluptatem in. Ea non aliquid blanditiis ut voluptas. Rerum velit quo vitae ad alias. Repellat ut consequatur fugit neque et beatae.
Autem expedita nobis vero ipsam sint veniam. Possimus blanditiis laborum sit sunt consequuntur possimus quam consectetur. Assumenda qui ut quia mollitia laboriosam. Aspernatur deserunt repellendus voluptatem necessitatibus.
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...