Students will: Find the Financial Statements (Income statement and Balance Sheet) from Yahoo Finance for the assigned company for the two most recent years. Calculate a common-size (vertical analysis) for the balance sheet and income statement for the most recent year Calculate trend analysis (horizontal analysis) for the most recent two years Calculate all the ratios found in chapter 9 under the following headings: o Liquidity o Solvency o Management Effectiveness (aka profitability) . 'Market Measures Track the common stock price for the most recent year (February 1, 2020- January 31, 2021) and show in graphical format I will assign 2 ratios to each group to be discussed when your group makes its presentation. Answer the question (two or three paragraphs): would you invest in this company? Why or why not based upon your calculations. Students should show calculations for the ratlos to ensure that they are not simply copying them from a website. Findings can be presented in an Excel format. wa WWW Anna Heport Annual Data 1 Millions of US except por share data 2020-12-31 2019-12-31 2018-12-31 2017-12-31 2016-12-31 2015-12-31 2014-12 EEEE $1,517.361 $52734 5805.974 $2823 $788.072 $708.714 $892 258 $313.165 $557 403 $652.546 $1,019.496 $384.183 $312.483 $809.67 $1,158.548 $256.978 $250.47 $822,685 $917.491 $174.507 $129.852 $433.638 $783.031 $152.242 $593 $279 S53 $87 M M $3,222.975 $658.678 $2,702 200 $792.148 $2,503.628 $826.888 $2,337 679 5885.774 $1,965.153 $804 211 $1,498.763 $538.531 $1,549 $305 $149 Cash On Hand Ponable Inventory Pre-Paid Spencer Other Current Amets Total Current Assets Property. Plant, And Equipment Long-Term investments Goodwill And Intangible Assets Other Long-Term Asset Total Long-Term Annet Tistal Assets Total Current Liabilities Long Term Debit Other Non Current abilities Total Cong Tom Lab Total abiti Common Stock Not Red Emign (Accumulated Deli Comorohonie Income Other Share Holders Equity Share Holder Equity Total Liabilities And Share Holders Equity EEEEE $57 $545 5515.500 $72.878 $1,507853 55,030,620 $1,413.278 $1.003.556 500.350 $1,041 359 $3,354.635 $0.15 $2,095 5421 LIN $586.523 $88.341 $2,141,322 84,843.531 $1.422.009 $502.687 SOB. 113 $1.271.435 52.693.444 $0.149 51.220.000 S-50.765 EEE $588,287 $123 819 $1,651,394 $4,245.022 $1,315 977 $703.834 $208.34 5912.174 $2,220.151 $0.140 $1,139,082 $38.002 $802.600 $97444 $1,668.688 $4,000.367 $1.030.375 $765.046 $162304 $92735 $1.907.725 $0.146 $1.184.441 S-30.211 $627.901 $110.204 $1,679.178 53,614.331 $685.816 $790 380 $137.227 5927.615 $1,613431 $0.145 $1,250.414 S-82.143 $660.367 $75.652 $1.387.207 $2,865,97 $478.8: $624,07 $94.860 S718.938 $1,197.748 $0.144 $1,078.533 $ 45.013 IM UM IM $25 $67 $323 $744 SO SASE 8.14 $673.35 5-10.105 IM 51,675,093 $5,030.620 32.150.007 $4,043.531 52,016,871 54,245.022 $2,010.642 54,006,367 02.030.0 $3,644.331 51,660.222 $2,065.97 51, $2,095 Annual Data 1 Millions of US $ except per share data 2020-12-31 2010-12-31 2018-12-31 2017.12.31 2018-12-31 2015-12-31 2014-12 Revenue Cost Of Goods Sold $4,474.657 $2,314.572 $2,160.095 $5,257.132 $2,798,500 52,470.533 $5,193.185 $2,852.714 M all $4,989.244 $2,797.83 $2,251.414 $4,833.338 $2,584.724 $2,248.614 $3,963,313 $2,057.766 $3,06 $1,572 $1,512 $2,340.471 $1,905,547 ht $2,171.934 $2,233.763 $2,182.339 $2,099.522 $1,831.143 $1,497 $1,158 $5.218.202 $4415.867 $5,030.382 $236.77 $3,554.766 3408.547 $-21 882 EEEEEE $5,088.105 S-613.438 $120.894 $4192.544 $49.387 S-541.931 S-25.017 $ 42.771 S-67.73a $20.552 5.47.236 $4,961 401 $27.843 $-38. 152 S-10.309 $37.951 $ 48.26 $-26.928 $209.842 $70,024 $139,818 $2,730 5353 S-11 $34 5417.471 $ 29.189 $388.282 $131.303 $256.979 $386.685 $154.112 S134 Gross Pro Resoch And Development Expenses SGSA Expenses Other Operating Income Or Expenses Operating Expenses Operating Income Total Non-Operating Incomo/Expono Pre-Tax Income Income Too Income After Taxe Other Income Income From Continuous Operation Income From Docontinued Operation Net Income EBITDA EBIT Base Share Outstanding S Outstanding Boste EPS EPS-Earnings Per Share $232 573 $208 Lihat S-5-09.177 892.139 $ 45,302 $-48.26 $256.979 $232.573 $208 $92.139 $232.573 $200 $423.449 $426 3-549.177 3-436,384 8-513.438 454 EEEEEEE $ 46,302 $152.005 $-25.017 446 S-48.26 $201.844 $27.843 445 $353 $197.979 $552.241 $417.471 436 445 $236.77 451 $509.487 $408.547 431 442 454 454 446 441 5.1.23 S0.45 $0.54 50.20 S0.20 S-0:10 S-0.10 -0.11 S-0.11 5-1.21 50.45 50.53 Students will: Find the Financial Statements (Income statement and Balance Sheet) from Yahoo Finance for the assigned company for the two most recent years. Calculate a common-size (vertical analysis) for the balance sheet and income statement for the most recent year Calculate trend analysis (horizontal analysis) for the most recent two years Calculate all the ratios found in chapter 9 under the following headings: o Liquidity o Solvency o Management Effectiveness (aka profitability) . 'Market Measures Track the common stock price for the most recent year (February 1, 2020- January 31, 2021) and show in graphical format I will assign 2 ratios to each group to be discussed when your group makes its presentation. Answer the question (two or three paragraphs): would you invest in this company? Why or why not based upon your calculations. Students should show calculations for the ratlos to ensure that they are not simply copying them from a website. Findings can be presented in an Excel format. wa WWW Anna Heport Annual Data 1 Millions of US except por share data 2020-12-31 2019-12-31 2018-12-31 2017-12-31 2016-12-31 2015-12-31 2014-12 EEEE $1,517.361 $52734 5805.974 $2823 $788.072 $708.714 $892 258 $313.165 $557 403 $652.546 $1,019.496 $384.183 $312.483 $809.67 $1,158.548 $256.978 $250.47 $822,685 $917.491 $174.507 $129.852 $433.638 $783.031 $152.242 $593 $279 S53 $87 M M $3,222.975 $658.678 $2,702 200 $792.148 $2,503.628 $826.888 $2,337 679 5885.774 $1,965.153 $804 211 $1,498.763 $538.531 $1,549 $305 $149 Cash On Hand Ponable Inventory Pre-Paid Spencer Other Current Amets Total Current Assets Property. Plant, And Equipment Long-Term investments Goodwill And Intangible Assets Other Long-Term Asset Total Long-Term Annet Tistal Assets Total Current Liabilities Long Term Debit Other Non Current abilities Total Cong Tom Lab Total abiti Common Stock Not Red Emign (Accumulated Deli Comorohonie Income Other Share Holders Equity Share Holder Equity Total Liabilities And Share Holders Equity EEEEE $57 $545 5515.500 $72.878 $1,507853 55,030,620 $1,413.278 $1.003.556 500.350 $1,041 359 $3,354.635 $0.15 $2,095 5421 LIN $586.523 $88.341 $2,141,322 84,843.531 $1.422.009 $502.687 SOB. 113 $1.271.435 52.693.444 $0.149 51.220.000 S-50.765 EEE $588,287 $123 819 $1,651,394 $4,245.022 $1,315 977 $703.834 $208.34 5912.174 $2,220.151 $0.140 $1,139,082 $38.002 $802.600 $97444 $1,668.688 $4,000.367 $1.030.375 $765.046 $162304 $92735 $1.907.725 $0.146 $1.184.441 S-30.211 $627.901 $110.204 $1,679.178 53,614.331 $685.816 $790 380 $137.227 5927.615 $1,613431 $0.145 $1,250.414 S-82.143 $660.367 $75.652 $1.387.207 $2,865,97 $478.8: $624,07 $94.860 S718.938 $1,197.748 $0.144 $1,078.533 $ 45.013 IM UM IM $25 $67 $323 $744 SO SASE 8.14 $673.35 5-10.105 IM 51,675,093 $5,030.620 32.150.007 $4,043.531 52,016,871 54,245.022 $2,010.642 54,006,367 02.030.0 $3,644.331 51,660.222 $2,065.97 51, $2,095 Annual Data 1 Millions of US $ except per share data 2020-12-31 2010-12-31 2018-12-31 2017.12.31 2018-12-31 2015-12-31 2014-12 Revenue Cost Of Goods Sold $4,474.657 $2,314.572 $2,160.095 $5,257.132 $2,798,500 52,470.533 $5,193.185 $2,852.714 M all $4,989.244 $2,797.83 $2,251.414 $4,833.338 $2,584.724 $2,248.614 $3,963,313 $2,057.766 $3,06 $1,572 $1,512 $2,340.471 $1,905,547 ht $2,171.934 $2,233.763 $2,182.339 $2,099.522 $1,831.143 $1,497 $1,158 $5.218.202 $4415.867 $5,030.382 $236.77 $3,554.766 3408.547 $-21 882 EEEEEE $5,088.105 S-613.438 $120.894 $4192.544 $49.387 S-541.931 S-25.017 $ 42.771 S-67.73a $20.552 5.47.236 $4,961 401 $27.843 $-38. 152 S-10.309 $37.951 $ 48.26 $-26.928 $209.842 $70,024 $139,818 $2,730 5353 S-11 $34 5417.471 $ 29.189 $388.282 $131.303 $256.979 $386.685 $154.112 S134 Gross Pro Resoch And Development Expenses SGSA Expenses Other Operating Income Or Expenses Operating Expenses Operating Income Total Non-Operating Incomo/Expono Pre-Tax Income Income Too Income After Taxe Other Income Income From Continuous Operation Income From Docontinued Operation Net Income EBITDA EBIT Base Share Outstanding S Outstanding Boste EPS EPS-Earnings Per Share $232 573 $208 Lihat S-5-09.177 892.139 $ 45,302 $-48.26 $256.979 $232.573 $208 $92.139 $232.573 $200 $423.449 $426 3-549.177 3-436,384 8-513.438 454 EEEEEEE $ 46,302 $152.005 $-25.017 446 S-48.26 $201.844 $27.843 445 $353 $197.979 $552.241 $417.471 436 445 $236.77 451 $509.487 $408.547 431 442 454 454 446 441 5.1.23 S0.45 $0.54 50.20 S0.20 S-0:10 S-0.10 -0.11 S-0.11 5-1.21 50.45 50.53