Soda Profits

Instructions

The Coca Cola Co spreadsheet is missing some calculations. Your task is to:

1. Calculate the Gross profits of FY ‘15, ‘16, ‘17, and ‘18

   • Gross Profit = Net Operating revenues - Cost of goods sold

2. 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

3. 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