Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Bar graph showing cost components from EBITDA -> Net Income

This is a discussion on Bar graph showing cost components from EBITDA -> Net Income within the Excel Questions forums, part of the Question Forums category; Hello! I am new to this board. Today I was asked to prepare a bar graph from 2005 to 2012 ...

  1. #1
    New Member
    Join Date
    Apr 2013
    Posts
    8

    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
    Blackboys, East Sussex, UK
    Posts
    10,554

    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

    Blog: Excel Evolution Blog | Twitter: @ExcelEvo | Facebook: Follow me here

    English is a weird language. It can be understood through tough thorough thought, though!

  3. #3
    New Member
    Join Date
    Apr 2013
    Posts
    8

    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
    Blackboys, East Sussex, UK
    Posts
    10,554

    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

    Blog: Excel Evolution Blog | Twitter: @ExcelEvo | Facebook: Follow me here

    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
    Blackboys, East Sussex, UK
    Posts
    10,554

    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

    Blog: Excel Evolution Blog | Twitter: @ExcelEvo | Facebook: Follow me here

    English is a weird language. It can be understood through tough thorough thought, though!

  6. #6
    New Member
    Join Date
    Apr 2013
    Posts
    8

    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

    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
    Blackboys, East Sussex, UK
    Posts
    10,554

    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

    Blog: Excel Evolution Blog | Twitter: @ExcelEvo | Facebook: Follow me here

    English is a weird language. It can be understood through tough thorough thought, though!

  9. #9
    New Member
    Join Date
    Apr 2013
    Posts
    8

    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
    Blackboys, East Sussex, UK
    Posts
    10,554

    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

    Blog: Excel Evolution Blog | Twitter: @ExcelEvo | Facebook: Follow me here

    English is a weird language. It can be understood through tough thorough thought, though!

Page 1 of 2 12 LastLast

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
  •  


DMCA.com