1.  Complete the attached transaction analysis and financial statement excel sheet.

2. Using the attached Ratios-Calculator excel sheet, complete the Ratios-Calculator for Pepsi and Coke. Only the cells highlighted in yellow.  The financial statements for Pepsi and Coke are attached. 
Explain how each ratio is calculated and what the ratio means.
Evaluate Pepsi vs Coke for each ratio highlighted in yellow.