Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Bar graph showing cost components from EBITDA -> Net Income

  1. #1
    New Member
    Join Date
    Apr 2013
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Bar graph showing cost components from EBITDA -> Net Income

    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!

  2. #2
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,656
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Bar graph showing cost components from EBITDA -> Net Income

    Welcome to the board.

    I think if I were to show the key components between EBITDA and Net Profit I would probably go for a waterfall chart. Are you just looking at a single period (month/qtr/year)?

    See waterfall chart tutorial here.

    The "initial" would be EBITDA and the "final" net profit. Not knowing your P&L I would only be able to speculate what items fall below the line, but I presume you have a bunch of GL account codes that apply; and perhaps that you can further categorise.
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  3. #3
    New Member
    Join Date
    Apr 2013
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Bar graph showing cost components from EBITDA -> Net Income

    Thank you for the quick response! I thought about waterfall graph also, but the request was bar graph to show trend across the years (from 2005 to 2012). I am a bit stumped on this request.

  4. #4
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,656
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Bar graph showing cost components from EBITDA -> Net Income

    Is your net profit always positive, or do you have some losses an one or more periods?
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  5. #5
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,656
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Bar graph showing cost components from EBITDA -> Net Income

    Typically your EBITDA will always be greater than your Net Profit, unless you've got some strange happenings on the "below-the-line" GL's. So I would use a stacked bar chart where the 1st stack of a bar shows Net Profit. Then each stack on top of that will show the individual "below-the-line" items, finally ending at your EBITDA position. Each bar would represent a different period.
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  6. #6
    New Member
    Join Date
    Apr 2013
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Bar graph showing cost components from EBITDA -> Net Income

    The net profit is always positive; however, some cost components below EBITDA can be positive or negative depending on the year.

  7. #7
    New Member
    Join Date
    Apr 2013
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Bar graph showing cost components from EBITDA -> Net Income

    Thank you for the suggestions. Just now I tried the stack bar graph; however, it is adding up the EBITDA and "below-the-line" items. The final net income position on the graph is the total of EBITDA + below the line. This graph request may not be possible, so I will see what alternative graphs I can prepare instead. Thank you!

  8. #8
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,656
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Bar graph showing cost components from EBITDA -> Net Income

    You need to start with Net Profit, not EBITDA, and add on from that.
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  9. #9
    New Member
    Join Date
    Apr 2013
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Bar graph showing cost components from EBITDA -> Net Income

    Thanks a lot! I think I finally got it! I was including the EBITDA in the bar graph itself.
    When I remove the EBITDA amount, the amounts of Net Profit + Below the Line items = EBITDA.

    This will work! Thank you so much!

  10. #10
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,656
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Bar graph showing cost components from EBITDA -> Net Income

    Quote Originally Posted by ssiao View Post
    Thanks a lot! I think I finally got it! I was including the EBITDA in the bar graph itself.
    When I remove the EBITDA amount, the amounts of Net Profit + Below the Line items = EBITDA.

    This will work! Thank you so much!
    Bingo Good luck.
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •