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 

Self-Review Guide