FinanceValuationDCFWACCSensitivity AnalysisExcel
M&A Investment Proposal: Netflix ⇢ Paramount
problem · Determine strategic viability and fair value of a $30B+ media acquisition to expand content infrastructure.
what shipped
- Aggregated 5 yrs of 10-K / 10-Q data to baseline revenue stability and debt obligations.
- Built a dynamic 5-year forecast model; normalized non-recurring items → 9.27% projected revenue growth.
- Ran DCF + sensitivity on WACC & Terminal Value, identifying 41% undervaluation ($18.58 implied vs $13.16 market).
- Recommended a $14.49/share final bid, defended the buy-side thesis in a faculty pitch deck.