Alfais Adilkhan
Case study

Take-Two Interactive, an equity report

A financial report on Take-Two Interactive (TTWO) for the Edinburgh University Trading & Investment Club: a valuation model, comparables and a recommendation, built in Excel and Capital IQ.

2024

A full valuation, built and defended

Role

Junior Analyst, Edinburgh University Trading & Investment Club.

Outcome

  • DCF, comparable-company and EBITDA valuations delivered

Constraints

  • Public-market data only, sourced and reconciled through Capital IQ
  • A club audience expecting a defensible thesis

Process

  1. Pulled and normalised financials in Capital IQ; built the model in Excel.
  2. Ran a DCF and a comparable-company analysis; bridged to an EBITDA view.
  3. Wrote the thesis and recommendation for the club.