Instructions
The Coca Cola Co spreadsheet is missing some calculations. Your task is to:
- Calculate the Gross profits of FY '15, '16, '17, and '18
- Gross Profit = Net Operating revenues - Cost of goods sold
- Calculate the average of all the gross profits. Try to do this with a function.
- Average = Sum of gross profits divided by the number of fiscal years (10)
- Documentation on the AVERAGE function
- This is an Excel file, but it should be editable in any spreadsheet platform
Data source credit to Yiyi Wang
Rubric
Exemplary | Adequate | Needs Improvement --- | --- | -- |