Finding Verizon's and T-Mobile's income statements and balance sheets from their 2020 annual reports that are posted on thier websites or EDGAR.

1. (50 points) Access Verizon's and T-Mobile's income statements and balance sheets from their 2020 annual reports that are posted on their websites or in EDGAR. Using Excel, for both companies, set up the formulas and calculate all five efficiency ratios and three profitability ratios from the ratio definitions and formulas section above for the years ended 2019 and 2020. See the example below: Profitability Ratios Nuke e 2015 2016 1.271 30501 0107 OT Operating More Verloon Net Income 2015 13 2011 23160 140 0.100 2. (50 points) In Excel, summarize your efficiency and profitability results in separate tables. See the example below: 2015 Nike Veriton Profit Margin Return on Assets Return on Shareholders' Equity 0.107 0.152 0.258 0.140 0.075 1030 2016 Nike Verizon 0.116 0.100 0.176 0.09 0.307 0508 . . (60 points) Answer all of the following questions. Did company Verizon or T-Mobile have a better asset turnover ratio in 2020? Did it take T-Mobile more or less days on average to collect their receivables in 2020 compared to 2019? Which company is more efficientin managing its investment in inventory? How many days on average does Verizon hold its inventory before selling it in 2019 and 2020? Did T-Mobile's profit margin increase or decrease from 2019 to 2020? Is Verizon or T-Mobile more profitable in 2020 according to their profit margin ratios? Is a higher or lower return on assets ratio better? Does Verizon have a better return on assets in 2019 or 2020? Which company has the best return on shareholders' equity ratlo? in what year was their strongest ratio? Why would a company want a high recelvables turnoverratio? . a . . . (20 points) Write a short paragraph making an overall comparison between the profitability ratios of both companies. 1. (50 points) Access Verizon's and T-Mobile's income statements and balance sheets from their 2020 annual reports that are posted on their websites or in EDGAR. Using Excel, for both companies, set up the formulas and calculate all five efficiency ratios and three profitability ratios from the ratio definitions and formulas section above for the years ended 2019 and 2020. See the example below: Profitability Ratios Nuke e 2015 2016 1.271 30501 0107 OT Operating More Verloon Net Income 2015 13 2011 23160 140 0.100 2. (50 points) In Excel, summarize your efficiency and profitability results in separate tables. See the example below: 2015 Nike Veriton Profit Margin Return on Assets Return on Shareholders' Equity 0.107 0.152 0.258 0.140 0.075 1030 2016 Nike Verizon 0.116 0.100 0.176 0.09 0.307 0508 . . (60 points) Answer all of the following questions. Did company Verizon or T-Mobile have a better asset turnover ratio in 2020? Did it take T-Mobile more or less days on average to collect their receivables in 2020 compared to 2019? Which company is more efficientin managing its investment in inventory? How many days on average does Verizon hold its inventory before selling it in 2019 and 2020? Did T-Mobile's profit margin increase or decrease from 2019 to 2020? Is Verizon or T-Mobile more profitable in 2020 according to their profit margin ratios? Is a higher or lower return on assets ratio better? Does Verizon have a better return on assets in 2019 or 2020? Which company has the best return on shareholders' equity ratlo? in what year was their strongest ratio? Why would a company want a high recelvables turnoverratio? . a . . . (20 points) Write a short paragraph making an overall comparison between the profitability ratios of both companies