Mgmt. Consulting

Build a market sizing model for online grocery delivery in 
London and New York.
1. Create a bottom-up plan for modeling TAM (all grocery) and 
   SAM (online grocery). Identify and list the key drivers: 
   population, grocery basket size, purchase frequencies, online 
   penetration, and any other material factors for each city.
   Research grocery and eating trends to inform your choice of drivers
2. Research and document baseline 2025 values and trajectories 
   towards 2035 for each driver identified in Step 1. Include 
   source or methodology for each data point.
3. Build a 2025-2035 market model in the workbook that calculates 
   TAM and SAM for each year using the drivers and assumptions 
   from Steps 1 and 2.

Create a competitive landscape analysis for Nordic fintech 
payments.
1. Identify the top 10 players by market share. List the key 
   dimensions to compare: revenue (est.), funding raised, key 
   products, target segments, pricing model, geographic coverage, 
   and key differentiators.
2. Research and document data for each competitor across the 
   dimensions identified in Step 1. Include sources for each 
   data point as a matrix on the side. Be critical on sources.
3. Add a summary section identifying ideas on white space 
   opportunities based on the analysis.

Build two analyses based on the customer data in the Data sheet 
for 2018-2025. Place output in Analysis sheet starting at cell B5.

1. Customer count waterfall: customers at beginning of year, 
   customers added, customers churned (lost), customers at 
   end of year.

2. NRR analysis: revenue at BoP, new revenue, revenue upsell, 
   full churn, contraction, revenue at EoP.

Below the two analyses, add a metrics section with: Logo churn %, 
Revenue churn excl contraction, Revenue churn incl contraction, 
Revenue expansion, Revenue growth from new logos.

Analyze the cost structure for this high-growth SaaS company.
1. Categorize all costs from the P&L on the Financials tab into: 
   COGS (direct), Sales & Marketing, R&D, G&A. Calculate each 
   as % of revenue and show trend over 3 years.
2. Research industry benchmarks for high-growth SaaS companies 
   for each cost category identified in Step 1. Document sources 
   for benchmark data.
3. Build a cost benchmarking analysis comparing our costs to 
   benchmarks from Step 2. Identify the 2-3 cost lines most 
   above benchmark and quantify the savings opportunity if 
   brought to median.