N Netflix x e Home - Liferay X Mail - Brenda Gutierrez1 - Outloc X + Financial Statement Project - Goc X Content X + X -> C a docs.google.com/spreadsheets/d/1yBC6qp3kfulYOB2i_tZcKuizwU-Xhdv5WbrDWpcly1A/edit?pli=1#gid=0 B Financial Statement Project * 4 EB Share B File Edit View Insert Format Data Tools Add-ons Help Last edit was made 20 minutes ago by Johnny Davila 90% $ % .0 .00 123- Default (Ari... J2 fx B C D E F G H K 4 Amazon Walmart Formula for Calculation Calculation 2020 Calculation 2019 Ratio Value 2020 Ratio Value 2019 Calculation 2021 Calculation 2020 Ratio Value 2021 Ratio Value 2020 6 7 Working Captial - Current Assets - Current Liabilities $132,733 - $126,385 $96,334 - $87,812 $6,348 $8,522 $90,067 - $92,645 $61,806 - $77,790 -$2,578 -$15,984 10 Current Ratio = Current Assets $132,733.00 $96,344.00 105.0227% 109.7162% $90,067.00 $61,806.00 97.2173% 79.4524% 11 Current Liabilities $126,385.00 $87,812.00 $92,645.00 $77,790.00 12 13 Acid-test Ratio = Cash + Marketable securities + Accounts receivable $108,938.00 $75,837.00 86.1954% 86.3629% $24,257.00 $15,749.00 26.1827% 20.2455% 14 Current Liabilities $126,385.00 $87,812.00 $92,645.00 $77,790.00 15 16 Average Collection period = 365 days 365 days 365 days 21.47 days 24.33 days 365 days 365 days 4.2 days 3.97 days 17 Accounts receivable turnover 17 15 87 92 18 19 Total asset turnover = Sales $386,064.00 $280,522.00 141.30% 144.64% $555,233.00 $519,926.00 219.90% 219.85% 20 Average total assets $273,221.50 $193,948.00 $252,496.00 $236, 495.00 21 22 Debt-to-equity ratio = Total liabilities $31,816.00 $163, 188.00 34.06% 262.95% $164,965.00 $154,943.00 188.46% 189.99% 23 Stockholders' equity $93,404.00 $62,060.00 687,531.00 $81,552.00 24 25 mes interest earned ratio = Earnings before interest expense and income taxes $22,899.00 $15,562.00 1390.35% 972.63% $22,548.00 $22,526.00 1027.71% 934.69% 26 Interest expense $1,647.00 $1,600.00 $2, 194.00 $2,410.00 27 28 Equity multiplier = Average Total Assets $321, 195 6225,248 343.88% 362.95% $252,496.00 $236,495.00 288.46% 289.99% 29 Average Stockholders' Equity 693,404 $62,060 $87,531.00 $81,552.00 30 Amazon Walmart 31 Formula for Calculation Calculation 2020 Calculation 2019 Ratio Value 2020 Ratio Value 2019 Calculation 2021 Calculation 2020 Ratio Value 2021 Ratio Value 2020 + Financial Ratios Amazon Balance Sheet/Income Statement Walmart Balance Sheet/Income Statement + Type here to search O W ?) ~ D (1)) ENG 5:35 PM 5/5/2021N Netflix x e Home - Liferay X Mail - Brenda Gutierrez1 - Outloc X + Financial Statement Project - Goc X Content X + X -> C a docs.google.com/spreadsheets/d/1yBC6qp3kfulYOB2i_tZcKuizwU-Xhdv5WbrDWpcly1A/edit?pli=1#gid=0 B Financial Statement Project * 4 EB Share B File Edit View Insert Format Data Tools Add-ons Help Last edit was made 20 minutes ago by Johnny Davila 90 % $ % .0 .00 123 Default (Ari... J2 fx B C D E F G H K 30 Amazon Walmart 31 Formula for Calculation Calculation 2020 Calculation 2019 Ratio Value 2020 Ratio Value 2019 Calculation 2021 Calculation 2020 Ratio Value 2021 Ratio Value 2020 32 33 Earnings per share = Net income $21,331.00 $11,588.00 $0.00 $0.00 $1,351,000.00 $1,488, 100.00 $0.00 $0.00 34 Average number of common shares outstanding 500,500,000 494,500,000 2,826,500,000 2,855,000,000 35 36 Dividend Yield Ratio = Dividends per share $0.00 $0.00 0.00% 0.00% $2. 16 $2. 12 1.47% 1.47% 37 Market price per share $3,256.93 $1,847.84 $146.53 $144.15 38 39 Dividend Payout Ratio = Dividends per share $0.0 $0.00 0.00% 0.00% $2. 16 $2. 12 45.19% 40.69% 40 Earnings per share $42.62 $23.43 $4.78 $5.21 41 42 Price-Earnings Ratio = Market Price per share $3,256.93 $1,847.84 76.42 78.87 $135.83 $144.15 28.42 27.67 43 Earnings per share $42.62 $23.43 $4.78 $5.21 44 45 er share of common stock = Total Stockholders' Equity $93,404.00 $62,060.00 $0.00 $0.00 7,531,000,000.00 $81,552,000,000.00 $31.03 $28.80 46 Number of common shares outstanding 603,000,000 498,000,000 2,821,000,000 2,832,000,000 47 Amazon Walmart 48 Formula for Calculation Calculation 2020 Calculation 2019 Ratio Value 2020 Ratio Value 2019 Calculation 2021 Calculation 2020 Ratio Value 2021 Ratio Value 2020 49 50 t Profit Margin Percentage = Net income $21,331.00 $11,588.00 5.53% 4.13% $13,510.00 $14,881.00 2.43% 2.86% 51 Sales $386,064.00 $280,522.00 $555,233.00 $519,926.00 52 53 Return on Total Assets = Net Income + [Interest expense x (Tax rate) $40,831.50 $180,520.00 14.94% 9.30% $90,715.25 $78,374.50 37.10% 34.39% 54 Average Total Assets $273,221.00 $193,948.00 $244,496.00 $227,895.00 55 56 Return on Equity = Net Income $21,331.00 $11,588.00 27.44% 21.95% $13,510.00 $14,881.00 15.98% 18.46% ten onA En DOA CAA En + Financial Ratios Amazon Balance Sheet/Income Statement Walmart Balance Sheet/Income Statement + Type here to search O 9 W ?~ ( 1) ENG 6:36 PM 5/5/2021N Netflix x e Home - Liferay X Mail - Brenda Gutierrez1 - Outloc X + Financial Statement Project - Goc X Content X + X -> C a docs.google.com/spreadsheets/d/1yBC6qp3kfulYOB2i_tZcKuizwU-Xhdv5WbrDWpcly1A/edit?pli=1#gid=0 B Financial Statement Project * 4 EB L Share B File Edit View Insert Format Data Tools Add-ons Help Last edit was made 20 minutes ago by Johnny Davila 90 % $ % .0 .00 123 Default (Ari... J2 fx B C D E F G H J K 40 Earnings per share $42.62 $23.43 $4.78 $5.21 41 42 Price-Earnings Ratio = Market Price per share $3,256.93 $1,847.84 76.42 78.87 $135.83 $144. 15 28.42 27.67 43 Earnings per share $42.62 $23.43 $4.78 $5.21 44 45 er share of common stock = Total Stockholders' Equity $93,404.00 $62,060.00 $0.00 $0.00 $87,531,000,000.00 $81,552,000,000.00 $31.03 $28.80 46 Number of common shares outstanding 503,000,000 498,000,000 21,000,000 2,832,000,000 47 Amazon Walmart 48 Formula for Calculation Calculation 2020 Calculation 2019 Ratio Value 2020 Ratio Value 2019 Calculation 2021 Calculation 2020 Ratio Value 2021 Ratio Value 2020 49 50 t Profit Margin Percentage = Net income $21,331.00 $11,588.00 5.53% 4.13% $13,510.00 $14,881.00 2.43% 2.86% 51 Sales $386,064.00 $280,522.00 $555,233.00 $519,926.00 52 53 Return on Total Assets = Net Income + [Interest expense x (Tax rate)] $40,831.50 $180,520.00 14.94% 9.30% $90,715.25 $78,374.50 37.10% 34.39% 54 Average Total Assets $273,221.00 $193,948.00 $244,496.00 $227,895.00 55 56 Return on Equity = Net Income $21,331.00 $11,588.00 27.44% 21.95% $13,510.00 $14,881.00 15.98% 18.46% 57 Average Stockholders' Equity $77,732.00 $52,804.50 $84,541.50 $80,593.00 58 Amazon Positive or Negative Walmart Positive or Negative 59 Financial Leverage = Total Company Debt $354, 176.00 -$251,000.00 3.79% -4.04% -$257,610.00 -$232,733.00 -2.94% -2.85% 60 Shareholder's Equity $93,404.00 $62,060.00 $87,531.00 $81,552.00 61 2020 2019 2020 2019 2021 2020 2021 2020 62 Implied Tax Rate = Provision for Income Tax $2,863.00 -$565.00 -11.84% -4.04% $6,858.00 $4,915.00 33.35% 24.43% 63 Income before Income Tax $24, 178.00 $13,976.00 $20,564.00 $20, 116.00 64 65 66 67 + Financial Ratios Amazon Balance Sheet/Income Statement Walmart Balance Sheet/Income Statement + C a docs.google.com/spreadsheets/d/1yBC6qp3kfulYOB2i_tZcKuizwU-Xhdv5WbrDWpcly1A/edit?pli=1#gid=1173425067 B Financial Statement Project * 4 EB L Share B File Edit View Insert Format Data Tools Add-ons Help Last edit was made 20 minutes ago by Johnny Davila 90% $ % .0 .00 123 Default (Ari... 10 B9 fx | ='Financial Ratios' !D29/ 'Financial Ratios' !D28 B C D E F G H I J K 3 Common-Size Statements 5 Balance Sheet for Amazon (Each row is a ratio, or percentage): 2020 2019 6 Current Assets/Total Assets 41.3247% 42.7724% 7 Current Liabilities/Total Assets 39.3484% 38.9846% 8 Total Liabilities /Total Assets 70.9198% 72.4481% Stockholders' Equity/Total Assets 29.0802% 27.5519% 10 % Growth of Assets = Current Year Total Assets - Previous Year Total Assets 42.5962% 38.4880% 11 Previous Year Total Assets 12 13 Income Statement for Amazon (Each row is a ratio, or percentage): 2020 2019 14 Cost of Goods Sold/Revenue 60.4322% 59.0100% 15 Gross Profit/Revenue 39.5678% 40.9900% 16 Operating Expenses/Revenue 94.0686% 94.8164% 17 Earnings before Interest and Taxes/Revenue 5.9314% 5. 1836% 18 Income Tax Expense/Revenue 0.6180% 0.8463% 19 Net income/Revenue 5.5252% 4. 1309% 20 % Growth in Revenue = Current Year Revenue - Previous Year Revenue 37.6234% 20.4550% 21 Previous Year Revenue 22 % Growth in Profits = Current Year Earnings Before Taxes - Previous Year Earnings Before Taxes 57.4789% 17.0679% 23 Previous Year Earnings Before Taxes 24 25 26 27 28 29 + Financial Ratios Amazon Balance Sheet/Income Statement Walmart Balance Sheet/Income Statement + Type here to search O 9 W ? ~ D ( 1) ENG 6:36 PM 5/5/2021N Netflix x e Home - Liferay X Mail - Brenda Gutierrez1 - Outloc X + Financial Statement Project - Goc X Content X + X -> C a docs.google.com/spreadsheets/d/1yBC6qp3kfulYOB2i_tZcKuizwU-Xhdv5WbrDWpcly1A/edit?pli=1#gid=1739622545 B Financial Statement Project * 4 EB L Share B File Edit View Insert Format Data Tools Add-ons Help Last edit was made 20 minutes ago by Johnny Davila 90% $ % .0 .00 123 Default (Ari.. 10 " BISA OV E LY HV GO P Y - E . B19 fx =13510/555233 A B C D E F G H I J K 2 Walmart Financial Statement Analysis 3 Common-Size Statements 5 Balance Sheet for Walmart (Each row is a ratio, or percentage): 2021 2020 Current Assets/Total Assets 35.6707% 26.1342% Current Liabilities/Total Assets 36.6917% 32.8929% 8 Total Liabilities /Total Assets 65.3337% 65.5164% 9 Stockholders' Equity/Total Assets 34.6663% 34.4836% 10 % Growth of Assets = Current Year Total Assets - Previous Year Total Assets 6.7659% 7.8433% 11 Previous Year Total Assets 12 13 Income Statement for Walmart (Each row is a ratio, or percentage): 2021 2020 14 Cost of Goods Sold/Revenue 75.7007% 75.8964% 15 Gross Profit/Revenue 24.2993% 24.1036% 16 Operating Expenses/Revenue 20.9440% 20.9243% 17 Earnings before Interest and Taxes/Revenue 4.0610% 3.9559% 18 Income Tax Expense/Revenue 1.2352% 0.9453% 19 Net Income/Revenue 2.4332% 2.8621% 20 % Growth in Revenue = Current Year Revenue - Previous Year Revenue 6.7908% 1.8806% 21 Previous Revenue 22 % Growth in Profits = Current Year Earnings Before Taxes - Previous Year Earnings Before Taxes 9.6266% -6.3260% 23 Previous Year Earnings Before Taxes 24 25 26 27 + Financial Ratios Amazon Balance Sheet/Income Statement Walmart Balance Sheet/Income Statement + Type here to search O 9 W ? ~ D ( 1) ENG 6:36 PM 5/5/2021 E