Within the ratio tab, you need to show 3 things for each of the ratios: 1. Written formula 2. Detailed numbers for the calculation 3. Result of the calculation Calculations to Perform (on the most recent year): 1. Prepare a horizontal (trend) analysis for the balance sheet - 1 point 2. Prepare a horizontal (trend) analysis for the income statement - 1 point 3. Prepare a vertical (common size) analysis for the balance sheet - 1 point 4. Prepare a vertical (common size) analysis for the income statement - 1 point 5. Net profit margin - 2 points 6. Gross profit percentage - 2 points 7. Fixed asset turnover ratio - 3 points 8. Return on Equity (ROE) - 3 points 9. Earnings per Share (EPS) - 3 points 10. Price / Earnings Ratio (P/E) - 2 points 11. Receivables turnover ratio and days to collect - 4 points 12. Inventory turnover ratio and days to sell - 4 points 13. Current ratio - 2 point 14. Debt-to-assets ratio - 3 points 15. Times interest earned - 3 points Target Company Ratio Analysis: Target Company Ratio Analysis Net Profit Margin = Current Year = = Gross Profit Margin = Current Year Fixed Asset Turnover Current Year Return on Equity (ROE) = Current Year EPS Current Year Price / Earnings Ratio Current Year Receivables Turnover = Current Year Days to Collect Current Year Inventory Turnover Current Year Days to Sell Current Year 11 Current Ratio Current Year = Debt-to-Assets Current Year Times Interest Earned Current Year = = = Consolidated Statements of Financial Position February 1, 2020 $ 2,577 8,992 1,333 12,902 (millions, except footnotes) January 30, 2021 Assets Cash and cash equivalents $ 8,511 Inventory 10,653 Other current assets 1,592 Total current assets 20,756 Property and equipment Land 6,141 Buildings and improvements 31,557 Fixtures and equipment 5,914 Computer hardware and softw 2,765 Construction-in-progress 780 Accumulated depreciation (20,278) Property and equipment, net 26,879 Operating lease assets 2,227 Other noncurrent assets 1,386 Total assets $ 51,248 Liabilities and shareholders' inv Accounts payable $ 12,859 Accrued and other current liabi 6,122 Current portion of long-term de 1,144 Total current liabilities 20,125 6,036 30,603 6,083 2,692 533 (19,664) 26,283 2,236 1,358 42,779 $ $ 9,920 4,406 161 14,487 $ $ Accounts payable $ Accrued and other current liabi Current portion of long-term de Total current liabilities Long-term debt and other borre Noncurrent operating lease liab Deferred income taxes Other noncurrent liabilities Total noncurrent liabilities Shareholders' investment Common stock Additional paid-in capital Retained earnings Accumulated other comprehen Total shareholders' investment Total liabilities and shareholder $ 12,859 6,122 1,144 20,125 11,536 2,218 990 1,939 16,683 9,920 4,406 161 14,487 11,338 2,275 1,122 1,724 16,459 42 6,329 8,825 (756) 14,440 51,248 42 6,226 6,433 (868) 11,833 42,779 $ Consolidated Statements of Operations 2019 $ 2018 $ (millions, except per share data 2020 Sales $ Other revenue Total revenue Cost of sales Selling, general and administrat Depreciation and amortization Operating income Net interest expense Net other (income) / expense Earnings from continuing opera Provision for income taxes Net earnings from continuing o Discontinued operations, net of - Net earnings $ Basic earnings per share Continuing operations $ Discontinued operations Net earnings per share $ Diluted earnings per share Continuing operations $ Discontinued operations Net earnings per share $ 92,400 1,161 93,561 66,177 18,615 2,230 6,539 977 16 5,546 1,178 4,368 77,130 982 78,112 54,864 16,233 2,357 4,658 477 (9) 4,190 921 3,269 12 3,281 74,433 923 75,356 53,299 15,723 2,224 4,110 461 (27) 3,676 746 2,930 7 2,937 4,368 $ $ 8.72 $ $ 6.39 0.02 5.54 0.01 5.55 8.72 $ 6.42 $ 8.64 $ 6.34 $ 0.02 6.36 5.50 0.01 5.51 8.64 $ $ 8.64 $ 6.34 $ 0.02 5.50 0.01 5.51 8.64 $ 6.36 $ Diluted earnings per share Continuing operations $ Discontinued operations Net earnings per share $ Weighted average common sha Basic Diluted Antidilutive shares 500.60 505.40 510.90 515.60 528.60 533.20 Within the ratio tab, you need to show 3 things for each of the ratios: 1. Written formula 2. Detailed numbers for the calculation 3. Result of the calculation Calculations to Perform (on the most recent year): 1. Prepare a horizontal (trend) analysis for the balance sheet - 1 point 2. Prepare a horizontal (trend) analysis for the income statement - 1 point 3. Prepare a vertical (common size) analysis for the balance sheet - 1 point 4. Prepare a vertical (common size) analysis for the income statement - 1 point 5. Net profit margin - 2 points 6. Gross profit percentage - 2 points 7. Fixed asset turnover ratio - 3 points 8. Return on Equity (ROE) - 3 points 9. Earnings per Share (EPS) - 3 points 10. Price / Earnings Ratio (P/E) - 2 points 11. Receivables turnover ratio and days to collect - 4 points 12. Inventory turnover ratio and days to sell - 4 points 13. Current ratio - 2 point 14. Debt-to-assets ratio - 3 points 15. Times interest earned - 3 points Target Company Ratio Analysis: Target Company Ratio Analysis Net Profit Margin = Current Year = = Gross Profit Margin = Current Year Fixed Asset Turnover Current Year Return on Equity (ROE) = Current Year EPS Current Year Price / Earnings Ratio Current Year Receivables Turnover = Current Year Days to Collect Current Year Inventory Turnover Current Year Days to Sell Current Year 11 Current Ratio Current Year = Debt-to-Assets Current Year Times Interest Earned Current Year = = = Consolidated Statements of Financial Position February 1, 2020 $ 2,577 8,992 1,333 12,902 (millions, except footnotes) January 30, 2021 Assets Cash and cash equivalents $ 8,511 Inventory 10,653 Other current assets 1,592 Total current assets 20,756 Property and equipment Land 6,141 Buildings and improvements 31,557 Fixtures and equipment 5,914 Computer hardware and softw 2,765 Construction-in-progress 780 Accumulated depreciation (20,278) Property and equipment, net 26,879 Operating lease assets 2,227 Other noncurrent assets 1,386 Total assets $ 51,248 Liabilities and shareholders' inv Accounts payable $ 12,859 Accrued and other current liabi 6,122 Current portion of long-term de 1,144 Total current liabilities 20,125 6,036 30,603 6,083 2,692 533 (19,664) 26,283 2,236 1,358 42,779 $ $ 9,920 4,406 161 14,487 $ $ Accounts payable $ Accrued and other current liabi Current portion of long-term de Total current liabilities Long-term debt and other borre Noncurrent operating lease liab Deferred income taxes Other noncurrent liabilities Total noncurrent liabilities Shareholders' investment Common stock Additional paid-in capital Retained earnings Accumulated other comprehen Total shareholders' investment Total liabilities and shareholder $ 12,859 6,122 1,144 20,125 11,536 2,218 990 1,939 16,683 9,920 4,406 161 14,487 11,338 2,275 1,122 1,724 16,459 42 6,329 8,825 (756) 14,440 51,248 42 6,226 6,433 (868) 11,833 42,779 $ Consolidated Statements of Operations 2019 $ 2018 $ (millions, except per share data 2020 Sales $ Other revenue Total revenue Cost of sales Selling, general and administrat Depreciation and amortization Operating income Net interest expense Net other (income) / expense Earnings from continuing opera Provision for income taxes Net earnings from continuing o Discontinued operations, net of - Net earnings $ Basic earnings per share Continuing operations $ Discontinued operations Net earnings per share $ Diluted earnings per share Continuing operations $ Discontinued operations Net earnings per share $ 92,400 1,161 93,561 66,177 18,615 2,230 6,539 977 16 5,546 1,178 4,368 77,130 982 78,112 54,864 16,233 2,357 4,658 477 (9) 4,190 921 3,269 12 3,281 74,433 923 75,356 53,299 15,723 2,224 4,110 461 (27) 3,676 746 2,930 7 2,937 4,368 $ $ 8.72 $ $ 6.39 0.02 5.54 0.01 5.55 8.72 $ 6.42 $ 8.64 $ 6.34 $ 0.02 6.36 5.50 0.01 5.51 8.64 $ $ 8.64 $ 6.34 $ 0.02 5.50 0.01 5.51 8.64 $ 6.36 $ Diluted earnings per share Continuing operations $ Discontinued operations Net earnings per share $ Weighted average common sha Basic Diluted Antidilutive shares 500.60 505.40 510.90 515.60 528.60 533.20