Case study of target Series B company

Merry Xmas all, I am working on a case study for a VC fund that specializes in industrial SaaS that is evaluating a industrial SaaS company with $20M investment in a $100M Series B round with a premoney valuation of $350M. 

I need to complete the financial forecast for this company and prepare a 3 page presentation highlighting the financial health of this business and other insights. 

I was given a 8 quarters info of revenue segments, this company has recurring revenue, hardware revenue and professional services revenue - I have to give assumptions for: each quarter 

  1. S&M as % of revenue 

  2. R&D as % of revenue

  3. G&A as % of revenue

And also balance sheet assumptions: 

AR days

Inventory days

AP Days


I want to ask: 

  1. Would it be better to come up with an assumption based on industrial benchmarks (currently I am using median S&M/R&D/G&A % of revenue from companies of $20M-$50M ARR, which is where this company is currently at) or any methods would be better?

  2. The balance sheet assumptions are the ones that I am having tough time coming up with. I am also trying to look for benchmarks but Pitchbooks and CapIQ searches doesn't show such details in balance sheet of the companies

  3. To highlight the financial health of company, what type of chart should I show for: growth, margin profile and cash inflows/outflows over the next 8 quarters, and what type of insights would VC fund be interested in (currently I am thinking SaaS magic number and Rule of 40, based on the information that is available in the case study)


Thanks all!

 

Ah, the festive season of deal-making doesn't take a break, does it? Let's dive into your case study conundrum:

  1. Assumption Methodology for S&M, R&D, and G&A:

    • Using industrial benchmarks is a solid starting point, especially if you're looking at companies within the same ARR range. This gives you a comparative baseline that's grounded in reality.
    • However, consider the growth stage and specific strategies of the target company. If they're aggressively expanding, S&M might be higher than the median. If they're innovation-driven, R&D could be a larger slice of the pie.
    • Don't forget to factor in the company's historical spending patterns and any strategic shifts they may be planning post-funding.
  2. Balance Sheet Assumptions (AR Days, Inventory Days, AP Days):

    • Benchmarks can be elusive for these metrics, but you can infer some insights from the revenue segments and business model.
    • For AR days, consider the payment terms typically granted to customers in the industry and the company's historical collection efficiency.
    • Inventory days might be influenced by the production cycles and supply chain efficiency, especially for the hardware segment.
    • AP days will depend on the company's bargaining power with suppliers and its cash management strategies.
  3. Financial Health Presentation:

    • Growth: A compound annual growth rate (CAGR) chart for revenue segments can visually demonstrate growth trajectories.
    • Margin Profile: Use a waterfall chart to show the contribution of each revenue segment to the overall margin.
    • Cash Flows: A classic cash flow statement format or a bridge chart can illustrate the inflows and outflows effectively.
    • SaaS Metrics: Including the SaaS magic number and Rule of 40 is a great idea. These are key metrics that VCs love as they encapsulate efficiency and growth potential.

Remember, the VC fund will be keen on sustainability and scalability of the business model, so any insights that can highlight the company's path to profitability and market dominance will be valuable. Also, consider the qualitative aspects such as the management team's expertise, competitive positioning, and market trends that could impact future performance.

Good luck with your presentation, and may your forecasts be merry and bright!

Sources: Biotech finance part 2: valuation methodologies and modeling considerations, Idea Generation... and Why Wall Street Sucks at It, PE professional, what's your process while judging an investment?, Why a lack of advanced modeling techniques? Anyone who uses probabilistic modeling justification for this?, On the Job With Simple As… My Research Process

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

Nostrum accusantium mollitia aut aliquid omnis eius nesciunt. Error et deleniti quo minima nobis quasi esse. In dolor exercitationem aut. Et error eligendi expedita culpa sed.

Totam tempore omnis ut ut et necessitatibus. Deleniti in fugit animi laudantium. Et vitae quae molestiae omnis dicta odio. Non ea inventore natus quia. Aliquam maxime unde aut quam sed assumenda. Vel commodi voluptas quam perferendis.

Doloribus animi in aliquid nostrum. Veritatis rerum recusandae tempora eveniet rerum. Consequuntur sapiente molestias sapiente quas maxime nemo et. Sint totam ipsum porro omnis veritatis. Velit sit dolorum et quam veritatis recusandae.

Quod occaecati nihil quam. Enim rerum omnis perferendis qui cum blanditiis tempora. Labore adipisci dolor sit omnis.

Career Advancement Opportunities

April 2024 Investment Banking

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

Overall Employee Satisfaction

April 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

April 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

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
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...”