Activision Blizzard DCF (Discounted Cash Flow) Model
Originally published: 03/10/2016 15:52
Publication number: ELQ-89903-1
View all versions & Certificate

Activision Blizzard DCF (Discounted Cash Flow) Model

A simple DCF Model based on Operating and Working Capital Assumptions (example: Activision Blizzard)

INPUTS (Historical and Projected):


- Revenue Items : Product Sales, Subscription & Licensing
- COGS (Cost of Goods Sold): Product Costs, Software Royalties, Intellectual Property Licences, COGS MMORPG
- SG&A Items: Product Development, Sales & Marketing, Restructuring Costs, General & Administrative
- Depreciation & Amortization
- Capital Expenditures

Working Capital

- Working Capital Assets: Accounts Receivable, Inventories, Softare Development & Intellectual Prop Licenses, Other Working Capital Assets
- Working Capital Liabilities: Deferred Revenues, Accounts Payable, Accrued Expenses & Other Liabilities


- Terminal Value Calculation: Terminal Enterprise Value, Discounted Terminal Value, Enterprise Value, Enterprise Value Net Debt, Projected Share Price
- Discounted Rate (WACC): Equity (Market Cap), Cost of Debt, Cost of Equity
- Cost of Equity (CAPM): Risk Free Rate, Beta, Rm-Rf

This Best Practice includes
1 Excel Model

Erin Chan Parker offers you this Best Practice for free!

download for free

Add to bookmarks




Any questions on Activision Blizzard DCF (Discounted Cash Flow) Model?

The user community and author are here to help. Go ahead!

4.2 / 5 (11 votes)

please wait...