Merging macro views and industry/competitive analysis into valuation/accounting assumptions

brief introduction: I have become more and more accustomed to translate observations about the competitive strategy as well as the general demand/supply/new trends of the underlying industry into both accounting assumptions (revenue/COGS/D&A/Capex/etc) and valuation matters (risk/multiple analysis/reasonable LT growth rate/etc) but I am still failing to put the macroeconomic input in the midst.

example: I am trying to put into perspective the taxi market (Uber environment) and trying to gauge market share as well as the kind of contracts Uber can negotiate relative to the frequency users switch from normal taxis. good. i can read reports and market studies for this but they are inherently using some macroeconomic assumptions (GDP per capita/employment/trade balances/inflation/etc) that directly affect the number of total passengers (more unemployed means less business people getting into taxis).

what way (preferably rigorous & testable) would you devise to plug into the model such macro assumptions that do change the industry landscape? (=report says 30 mil passengers in US with CAGR 5% but I think workforce will shrink so how i do translate such estimate into changing those sensitive numbers)

 
Best Response

You need to build the model with changeable assumptions that the user can toggle. So if you are assuming 30 million growing at 5% a year, have a base value (30 Million) and make your growth rate changeable so you can can test it at 4% a year or even negative growth per year.

Is that what you are trying to get at? I mean it comes down to identifying the macro factors that you think will impact the company, and then create a 'waterfall' scenario for them. So if for example you believe that a company can capture 1% of any growth in the marketplace, you build that into your assumptions. So you have 30 million which grow at 5% (so, next year you have 31.5 million of which you captured one percent of the growth so the company picked up 15,000 new customers) and tie them together so that you can change the growth rate, acquisition rate, etc. Then tie that 15,000 number into whatever financials you have and flow it through them.

Again, i'm not quite sure if that is what you mean. At the end of the day, you need to make some assumptions you are comfortable with and then tie them into your model so that you can change those assumptions.

 

Est aut non cum tempora. Sit rem animi id vero unde animi molestias. Sed possimus molestiae error enim rerum.

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
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
kanon's picture
kanon
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
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...”