Excel Business Operations Assignment
toller65
Excel.xlsxCompany Selection
| Company Type | Company Name | Industry | Trading Symbol | Trading Exchange |
| Focus Company | Amazon | |||
| Competitor Company 1 | Disney | |||
| Competitor Company 2 | Activision Blizzard |
CCC Analysis Focus Company
| Focus Company Analysis | 2020 | 2019 | 2018 | 2017 | 2016 | 2015 | 2010 | 2008 |
| Days Sales Outstanding | ||||||||
| Accounts Receivable | ||||||||
| Revenue | ||||||||
| Days Payable Outstanding | ||||||||
| Accounts Payable | ||||||||
| Cost of Goods Sold | ||||||||
| Days Inventory Outstanding | ||||||||
| Inventory | ||||||||
| Cost of Goods sold | ||||||||
| Cash Conversion Cycle | ||||||||
| Operating Cycle |
CCC Analysis Competitor 1
| Competitor 1 Analysis | 2020 | 2019 | 2018 | 2017 | 2016 | 2015 | 2010 | 2008 |
| Days Sales Outstanding | ||||||||
| Accounts Receivable | ||||||||
| Revenue | ||||||||
| Days Payable Outstanding | ||||||||
| Accounts Payable | ||||||||
| Cost of Goods Sold | ||||||||
| Days Inventory Outstanding | ||||||||
| Inventory | ||||||||
| Cost of Goods sold | ||||||||
| Cash Conversion Cycle | ||||||||
| Operating Cycle |
CCC Analysis Competitor 2
| Competitor 2 Analysis | 2020 | 2019 | 2018 | 2017 | 2016 | 2015 | 2010 | 2008 |
| Days Sales Outstanding | ||||||||
| Accounts Receivable | ||||||||
| Revenue | ||||||||
| Days Payable Outstanding | ||||||||
| Accounts Payable | ||||||||
| Cost of Goods Sold | ||||||||
| Days Inventory Outstanding | ||||||||
| Inventory | ||||||||
| Cost of Goods sold | ||||||||
| Cash Conversion Cycle | ||||||||
| Operating Cycle |
