LOOK UP THE WALMART AND CVS HEALTH ANNUAL REPORT TO HELP YOU ANSWER THESE. You are completing the project for 2019 for both companies. So this year is 2019 and the last year is 2018. FILL OUT EVERYTHING EXCEPT THE ONES IN BLACK. WHEN DOING THE CALCULATIONS DO IT IN EXCEL FORMULA FORMAT WHERE IT SAYS CALCULATIONS ONLY

A B D E F G H 2 Walgreens INPUT Financial Information CVS Health INPUT Financial Information 3 3 2019 2018 2017 2019 2018 2017 4 5 6 Total Assets 7 Current Assets 8 Net Accounts Receivable 9 Inventory 10 Net Fixed Assets 11 Total Liabilities 12 Current Liabilities 13 Stockholder's Equity 14 Net Sales 15 Cost of Goods Sold 16 Gross Profit 17 Interest Expense 18 Pretax Income 19 Tax Expense 20 Net Income 21 EPS 22 Market Price Total Assets Current Assets Net Accounts Receivable Inventory Net Fixed Assets Total Liabilities Current Liabilities Stockholder's Equity Net Sales Cost of Goods Sold Gross Profit Interest Expense Pretax Income Tax Expense Net Income EPS Market Price 25 26 Walgreens Project Part 2 Calculations CVS Health Project Part 2 Calculations 27 Net Profit Margin Gross Profit Percentage Fixed Asset Turnover Return on Equity Earnings Per Share Price Earnings Ratio 28 29 30 Net Profit Margin 31 32 Gross Profit Percentage 33 34 Fixed Asset Turnover 35 36 Return on Equity 37 38 Earnings Per Share 39 40 Price Earnings Ratio 41 42 Receivables Turnover Ratio 43 44 Days to Collect 45 46 Inventory Turnover Ratio 47 48 Days to Sell 49 50 Current Ratio 51 52 Debt to Assets Ratio 53 54 Times Interest Earned 55 56 Receivables Turnover Ratio Days to Collect Inventory Turnover Ratio Days to Sell Current Ratio Debt to Assets Ratio Times Interest Earned 55 56 57 58 59 Walgreens Project Part 3 Calculations CVS Health Project Part 3 Calculations 60 Net Profit Margin THIS YEAR Net Profit Margin LAST YEAR Gross Profit Percentage THIS YEAR Gross Profit Percentage LAST YEAR Debt to Assets Ratio THIS YEAR Debt to Assets Ratio LAST YEAR 61 62 63 Net Profit Margin THIS YEAR 64 65 Net Profit Margin LAST YEAR 66 67 Gross Profit Percentage THIS YEAR 68 69 Gross Profit Percentage LAST YEAR 70 71 Debt to Assets Ratio THIS YEAR 72 73 Debt to Assets Ratio LAST YEAR 74 75 Net Sales Change THIS YEAR 76 77 Net Sales Change LAST YEAR 78 79 Net Income Change THIS YEAR 80 81 Net Income Change LAST YEAR 82 83 Total Assets Change THIS YEAR 84 85 Total Assets Change LAST YEAR 86 87 Net Sales Change THIS YEAR Net Sales Change LAST YEAR Net Income Change THIS YEAR Net Income Change LAST YEAR Total Assets Change THIS YEAR Total Assets Change LAST YEAR A B D E F G H 2 Walgreens INPUT Financial Information CVS Health INPUT Financial Information 3 3 2019 2018 2017 2019 2018 2017 4 5 6 Total Assets 7 Current Assets 8 Net Accounts Receivable 9 Inventory 10 Net Fixed Assets 11 Total Liabilities 12 Current Liabilities 13 Stockholder's Equity 14 Net Sales 15 Cost of Goods Sold 16 Gross Profit 17 Interest Expense 18 Pretax Income 19 Tax Expense 20 Net Income 21 EPS 22 Market Price Total Assets Current Assets Net Accounts Receivable Inventory Net Fixed Assets Total Liabilities Current Liabilities Stockholder's Equity Net Sales Cost of Goods Sold Gross Profit Interest Expense Pretax Income Tax Expense Net Income EPS Market Price 25 26 Walgreens Project Part 2 Calculations CVS Health Project Part 2 Calculations 27 Net Profit Margin Gross Profit Percentage Fixed Asset Turnover Return on Equity Earnings Per Share Price Earnings Ratio 28 29 30 Net Profit Margin 31 32 Gross Profit Percentage 33 34 Fixed Asset Turnover 35 36 Return on Equity 37 38 Earnings Per Share 39 40 Price Earnings Ratio 41 42 Receivables Turnover Ratio 43 44 Days to Collect 45 46 Inventory Turnover Ratio 47 48 Days to Sell 49 50 Current Ratio 51 52 Debt to Assets Ratio 53 54 Times Interest Earned 55 56 Receivables Turnover Ratio Days to Collect Inventory Turnover Ratio Days to Sell Current Ratio Debt to Assets Ratio Times Interest Earned 55 56 57 58 59 Walgreens Project Part 3 Calculations CVS Health Project Part 3 Calculations 60 Net Profit Margin THIS YEAR Net Profit Margin LAST YEAR Gross Profit Percentage THIS YEAR Gross Profit Percentage LAST YEAR Debt to Assets Ratio THIS YEAR Debt to Assets Ratio LAST YEAR 61 62 63 Net Profit Margin THIS YEAR 64 65 Net Profit Margin LAST YEAR 66 67 Gross Profit Percentage THIS YEAR 68 69 Gross Profit Percentage LAST YEAR 70 71 Debt to Assets Ratio THIS YEAR 72 73 Debt to Assets Ratio LAST YEAR 74 75 Net Sales Change THIS YEAR 76 77 Net Sales Change LAST YEAR 78 79 Net Income Change THIS YEAR 80 81 Net Income Change LAST YEAR 82 83 Total Assets Change THIS YEAR 84 85 Total Assets Change LAST YEAR 86 87 Net Sales Change THIS YEAR Net Sales Change LAST YEAR Net Income Change THIS YEAR Net Income Change LAST YEAR Total Assets Change THIS YEAR Total Assets Change LAST YEAR