Estimate Revenue and Profitability for Share Workplace's Paid Tier

Q: Estimate Revenue and Profitability for Share Workplace's Paid Tier

This question evaluates revenue forecasting, unit-economics modeling, cohort and funnel analysis, and marketing ROI estimation for a freemium/subscription product.

Q: How do I approach Analytics & Experimentation interview questions?

Analytics & Experimentation questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master analytics & experimentation interviews.

Q: What difficulty level is this interview question?

This is a medium difficulty Analytics & Experimentation question, commonly asked during Technical Screen rounds at Capital One.

Q: What role is this question designed for?

This question is commonly asked for Data Scientist candidates at Capital One during technical interviews.

Question

Freemium + Subscription Sizing, Margins, and Marketing Impact (Year 3)

Context

You are evaluating a freemium enterprise collaboration app ("Share Workplace") three years after launch. Users flow through a funnel from site visits to sign-ups, to actives, to paid subscriptions. Both free and paid cohorts monetize (subscriptions for paid; ads/upsell for free). Variable COGS apply to both cohorts, and the company spends on paid marketing to drive a portion of visits.

Assume reasonable funnel, monetization, cost, and marketing parameters where not provided. Show clear formulas and step-by-step math. Keep unit economics visible.

Tasks

Size the annual revenue opportunity for the paid tier in Year 3 (12 months ending month 36).
Using separate ARPU assumptions for paid and free cohorts, compute:
- Cohort-level contribution margins (paid and free, excluding marketing).
- Total contribution margin (including marketing spend).
If marketing spend increases by 20% at the start of Year 3, estimate the impact on:
- Subscriber count (paid) and free MAU in Year 3.
- Profitability in Year 3 and at steady-state.
- Clearly state any assumptions.

Hint: Structure the funnel (site visits → sign-ups → active → paid), keep unit economics visible, show math clearly.

Estimate Revenue and Profitability for Share Workplace's Paid Tier

Quick Overview

Freemium + Subscription Sizing, Margins, and Marketing Impact (Year 3)

Context

Tasks

Solution

Comments (0)