Value a Real Company Using DCF or Comparable Analysis
10 weeks · 0 milestones
Perform a full valuation of a real publicly traded or recently acquired company using either a discounted cash flow model or comparable company analysis — with fully documented assumptions, sensitivity analysis showing how the valuation changes under different scenarios, and an explicit investment thesis or price target conclusion. The valuation must be for a real company using real financial data. Proof requires review by a finance professional or university finance faculty member who can confirm the methodology is technically correct and the assumptions are documented.
Milestone map
Milestone map
3 milestones
Select a real publicly listed company and build the foundation of a Discounted Cash Flow (DCF) valuation. Gather the last five years of financial statements from the company's actual filings (10-K or Annual Report). Project free cash flows for the next five years based on stated assumptions grounded in historical performance and industry analysis.
Proof required
Submit: (a) the selected company and links to the actual financial filings used, (b) a five-year historical financial summary showing revenue, EBITDA, capital expenditure, and free cash flow, and (c) a five-year FCF projection with all key assumptions stated explicitly — revenue growth rates, EBITDA margins, capex intensity — with rationale for each assumption referenced to historical performance or industry benchmarks.
What gets checked
- Financial data is from actual company filings — not from a financial data aggregator that may have adjustment methodologies
- All projection assumptions are stated explicitly with rationale
- FCF definition is consistent (unlevered vs. levered is stated)