Doing revenue/cost drivers correctly?
I'm prepping technicals and building practice models (currently doing a Netflix standalone DCF). Want a gut check from people in seats on whether my mental model for the assumptions layer is sound, because the mechanics (WACC, 3-statement linkage, DCF layout, comps, football field) feel straightforward but the driver assumptions feel more like judgment than science and I want to know if that discomfort is a knowledge gap.
My current framework:
Revenue (segmented): Anchor year 1 to most recent actual growth, nudged for trend/base effects. Anchor final forecast year to where the segment sits relative to blended company maturity. Connect with a smooth, deceleration whose shape (front-loaded vs linear) depends on segment maturity. Each segment's driver is identified (price for mature markets, volume for under-penetrated, mix where relevant). No hard "evidence" for the intermediate years, just constraint + economic logic.
Costs: Two buckets. (1) Operating costs as % of revenue or operational ratios (DPO, COGS%, etc.) for a mature business. (2) Reinvestment projected explicitly (capex/content/WC), then cross-checked against the growth = reinvestment rate × ROIC identity, with terminal-period consistency enforced.
Questions for people actually doing this:
- Is the "anchor the endpoints, justify the shape, accept uncertainty in the middle" approach how you actually think about forecast-period revenue, or is there more rigor I'm not seeing? Would my logic pass the smell test in an interview?
- How much do you lean on the reinvestment/ROIC identity as a real check vs. it being academic?
- For the final forecast year before terminal - how do you defend that number beyond "converging toward maturity"? Is there anything more concrete?
- Am I overthinking the precision of intermediate-year assumptions?
Not looking for someone to build it for me, I just want to know if my reasoning is where it should be or if I'm missing a layer.
Your framework for revenue and cost drivers is solid and aligns with many of the best practices discussed in WSO's top-rated content on DCF modeling and valuation. Here's a breakdown of your approach and answers to your specific questions:
Revenue Drivers:
"Anchor the endpoints, justify the shape, accept uncertainty in the middle":
Intermediate-year precision:
Cost Drivers:
Operating costs and reinvestment:
Reinvestment/ROIC identity:
Defending the Final Forecast Year:
Smell Test in Interviews:
Final Tips:
Your reasoning is on the right track, and with a bit more emphasis on tying assumptions to data or qualitative insights, you'll be well-prepared for both modeling and interviews. Keep up the great work!
Sources: DCF Modeling Course ~ Pre-training text.pdf, DCF Myth 3.2: If you don't look, its not there!, Help with Writing ER Reports for Beginners (Value Investing)
Maybe you’re already doing this, but you shouldn’t be starting with revenue. In the case of Netflix, revenue could be a function of # of users and average subscription cost/ARPU, for example.
You need to independently forecast customer growth/churn and pricing changes such as inflation or price increases. This makes revenue forecasts more accurate and clearly shows how much growth comes from customers vs pricing.
Normally I would do that approach, but Netflix stopped disclosing ARPU and sub numbers. So I'd be estimating both numbers for FY2025 and wouldnt be able to verify either one going forward.
Thats why I'm going with the revenue approach that I am.
you know how much they made from streaming and how much a Netflix account costs at the same time, you can back into pretty much anything you want
Unde rem voluptates non dolorem rerum. Soluta quisquam non delectus aut non.
Sit aut est vitae quasi minus consectetur. Et et iure occaecati. Repellendus nemo quasi non quas. Neque sunt ut nihil amet non excepturi rem. Expedita impedit voluptas eos omnis sapiente.
Voluptatem iure sapiente doloremque possimus dicta. Ut autem quasi earum distinctio cupiditate. Cum et cupiditate veniam. Cum voluptatem sint vel aliquam incidunt.
Earum qui non voluptas eveniet consequatur. Itaque et ad sint incidunt maiores est. Repudiandae et consequatur qui fugiat hic.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...