Bar graph showing cost components from EBITDA -> Net Income

[ssiao]

Hello!

I am new to this board.
Today I was asked to prepare a bar graph from 2005 to 2012 showing the EBITDA and the other cost components below EBITDA to reach final Net Income. At first I thought it would be easy to prepare, but I now realize that to reach the Net Income, the other cost components must be taken out of EBITDA. So how can I make a bar graph that goes from EBITDA + Other Cost to Net Income?

I have been thinking about this graph most of the day today but could not come up with good solution.
If anyone can help, I would really apprecaite it.

Thank you!

 

[TheGreatGadsby]

Hi, I am also new to this board, and have found this thread extremely helpful, I would love to be able to use your net profit to EBITDA graph here, except that some of my net profits are negative, so my EBITDA for those years is incorrect. Anything i can do about this? Thanks in advance

 

[Jon von der Heyden]

Can you post a sample of the data you want to chart?

 

[TheGreatGadsby]

[TABLE="width: 533"]
<tbody>[TR]
[TD][/TD]
[TD="align: left"]2008
[/TD]
[TD="align: left"]2009
[/TD]
[TD="align: left"]2010
[/TD]
[TD="align: left"]2011
[/TD]
[TD="align: left"]2012
[/TD]
[/TR]
[TR]
[TD]Net Profit
[/TD]
[TD="align: left"] 190,814
[/TD]
[TD="align: left"] (449,268)
[/TD]
[TD="align: left"] (1,031,830)
[/TD]
[TD="align: left"] (493,996)
[/TD]
[TD="align: left"] (247,009)
[/TD]
[/TR]
[TR]
[TD]Tax
[/TD]
[TD="align: left"] 8,727
[/TD]
[TD="align: left"] -
[/TD]
[TD="align: left"] -
[/TD]
[TD="align: left"] -
[/TD]
[TD="align: left"] -
[/TD]
[/TR]
[TR]
[TD]Interest
[/TD]
[TD="align: left"] 703,923
[/TD]
[TD="align: left"] 488,377
[/TD]
[TD="align: left"] 437,166
[/TD]
[TD="align: left"] 484,902
[/TD]
[TD="align: left"] 356,926
[/TD]
[/TR]
[TR]
[TD]Depreciation
[/TD]
[TD="align: left"] 445,675
[/TD]
[TD="align: left"] 448,291
[/TD]
[TD="align: left"] 447,082
[/TD]
[TD="align: left"] 349,587
[/TD]
[TD="align: left"] 204,306
[/TD]
[/TR]
[TR]
[TD]EBITDA
[/TD]
[TD="align: left"] 1,349,139
[/TD]
[TD="align: left"] 487,400
[/TD]
[TD="align: left"] (147,582)
[/TD]
[TD="align: left"] 340,493
[/TD]
[TD="align: left"] 314,223
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jon von der Heyden]

Shouldn't your EBITDA be [Net Profit] - Sum([Tax], [Interest], Depreciation])

 

[TheGreatGadsby]

Hey Jon, thanks for your quick responses ! As far as i know, if I am calculating EBITDA from net income, I would add back the "ITDA" elements to the net income to reach EBITDA.. Am i missing your point?

 

[Jon von der Heyden]

Yes of course, whoops! Just having a dumb moment...