EV decreases when increasing Sales

Hello everyone,

I have 2 sources of sales, one is sales of phones other is sales of chargers. This year we will lose 10% in sales of chargers, and when I project in 10 yrs, my COGS and SG&A are static - 80% COGS, 16% SG&A, 30% Taxes over EBIT. When i increase sales by 2% (USD) it loses value, however when i maintain it static at 0% growth, I gain EV.

Why could this be? How would you guys check this, becuase NPV in gross profit vs. 2% growth and 0% has a difference of US$5M. The problems become in my Working capital. Is there a way I can check anything. My working capital is based both in total sales & total costs, dont have a differentiated.
Thanks!

 
Most Helpful

Okay, bear with me here because we're trouble shooting over the internet on WSO.

That said, I'll give this a go since no one else has. As a general feature, I would try to build in some 'audit-ability' into your models. I don't think anyone here is going to be able to tell you exactly what's wrong, but we can try to help you figure out how to visualize where the problem is. Obviously, FCF can be broken down into its different components of:

Revenue - COGS - SG&A - Tax - Change in Working Capital - Capex.

It sounds like you already isolated the impact to working capital. But just to confirm, you should discount each of these components at your WACC for your base case, and then compare these NPVs to those when you increase your sales by 2%.

Is the result actually driven by a change in working capital? If so, why? What are your AR assumptions, and what are your AP assumptions?

Again, I don't think anyone here (based on the information given) is going to be able to say 'oh yeah, looks like you've got a bad XYZ assumption.' But I'd go through the exercise of seeing what components of your FCF actually changed, and try to reconcile that.

 

Hi Motley_accrual,

Thank you very much for your help. Actually it is new for me to check this way and it makes so much sense. Is another way to check and my boss is trying to make me think more managerial etc. However it wasnt a problem in the model, it was that my COGS increased in one line of business even staying flat it had a problem with the days in WK. So my total revenues increased also my COGS, but my WK was worst. So that is why it lowered my EV.

Thanks again, and if you have something where I could read how to change my chip from analyst to more managerial interpretations i would appreciate.

Cheers and thanks again

 

Nesciunt odit et nostrum amet. Quae et voluptatem sed fugit alias qui. Sequi sed nostrum possimus porro. Nihil id aut sapiente accusantium ut a ad.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”