HW research on Verizon and T-Mobiles Balance Sheets and Income Statements. I also attached the Activity Ratio and Profitability Ratio chart that needs to be filled out with the given information from the balance sheet and statements.

5 questions due by 12pm

I will also reuploaded the questions if needed.

PLEASE HELP THANKS !!

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 . . 4. (20 points) Write a short paragraph making an overall comparison between the efficiency ratios of both companies. 5. (20 points) Write a short paragraph making an overall comparison between the profitability ratios of both companies. XI. 207-DA Project data (1) Pre File Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details Enable Editing L7 H 2019 110,305 21,563 131,868 A C D Consolidated Statements of Income 1 2 Verizon Communications Inc. and Subsidiaries 3 (dollars in millions, except per share amounts) 4 5 Years Ended December 31 2020 6 7 Operating Revenues 8 Service revenues and other 109,872 9 Wireless equipment revenues 18,420 10 Total Operating Revenues 128,292 11 12 Operating Expenses Cost of services (exclusive of items 13 shown below) 31,401 14 Cost of wels equipment 19.500 Selling, general and administrative 15 esperise 31,573 16 Depreciation and amortization expense 16,720 17 Media poodwill impairment 18 Total Operating Expenses 99.494 19 20 Operating Income 28.798 Equity in losses of unconsolidated 21 businesses -15 22 Other income (pesett 339 4,947 Income Before Provision For 24 Income Tases 23.967 Veron Income Statement Ver online she Bea 31,722 22954 29.896 16 682 186 101,490 30313 22 Intentespese 15 -2.900 4,730 22,133 Type here to search O XH9--1 File Home 207-DA Projed-data (1) Protect Insert Page Layout Formulas Data Review View Protected View This nile orginated from an internet location and might be unsafe. Click for more details Enable Eating L7 D F G $ 109.872 15420 128,292 110,303 21,563 131,868 31,401 19,800 31,772 22,954 31,573 16,720 29.896 16,682 156 101,490 99.494 A B & Service revenues and other $ 9 Wireless equipment revenues 10 Total Operating Revenues 11 12 Operating Expenses Cost of services (exclusive of items 13 shown below) 14 Cost of wireless equipe Selling general and administrative 15 expense 16 Depreciation and amortization expense 17 Medi poodwill impairment 18 Total Operating Expenses 19 20 Operating Income Equity in losses of unconsolidated 21 bones 22 Other income (expense), et 23 Interest expense Income Before Provision For 24 Income Taxes 25 Provision for income 26 Net Income 27 Net income attributable to 28 noncontrolling interest 29 Net income attributable to Veriton Net Income 30 28,798 30,378 -45 -339 4.247 -15 -2.900 23.967 -5,619 18.45 22.733 -2.945 19.755 as SA 347 17,801 19.263 18.45 19.755 Venxon Income Statement Vanes Type here to search XI H: |= 207-DA Project-data (1)xx [Protecte File Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details Enable Editing L7 G H 2019 2.594 26,162 1.152 733 25,429 B D E F 1 Consolidated Balance Sheets Verizon Communications Inc. and 2 Subsidiaries 3 4 (dollars in millions, except per share amounts) 5 At December 31, 2020 6 7 Assets 8 Current assets 9 Cash and cash equivalents 22,171 10 Accounts receivable 25.169 11 Less Allowance for credit losses 12 Lesowance for our ts 13 Accounts receivable, net (Note 1) 23,917 14 Inventories 1,796 15 Prepaid expenses and other 6,710 16 Total current assets 54,594 17 18 Property, plant and equipment 279,737 19 Less Accumulated depreciation 184.904 20 Property, plant and equipment, net 94,833 21 Investments in unconsolidated 22 businesses 589 23 Wireless licenses 96,097 24 Goodwill 21,773 25 Other intangible assets. net 9,113 26 Operating Itase right of us assets 22,531 17 Other AS Vergron Income Statement Veriton Balance Sheet Rady 3,028 37.473 265,734 173,819 91.915 358 95.059 24359 9.495 Type here to search EL XI. 207-DA Project-data (1) box [Prote File Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details Enable Editing L7 be A B D E F G H 26 Operating lease right-of-use assets 22,531 22,694 27 Other assets 13,651 10,141 28 Total assets 316,481 $ 291,727 29 30 Liabilities and Equity 31 Current liabilities 32 Debt maturing within one year 5,889 10,777 Accounts payable and accrued 33 liabilities 20,658 21.306 34 Current operating lease liabilities 3,485 3.261 35 Other current liabilities 9.628 9,034 36 Total current liabilities 39,660 44.865 37 38 Long-term debt 123,173 100,712 39 Employee benefit obligations 18,657 17.952 40 Deferred income taxes 35,711 34 703 41 Non-current operating lease Isabilities 18,000 15.393 42 Other abilities 7208 12.264 43 Total long-term liabilities 207,549 184024 44 Commitments and Contingencies 45 (Note 16 46 47 Equity Series preferred stock (50.10 par value, 250,000,000 shares 48 authorized, nont issued) Common stock (50.10 par value, 6.250,000,000 shares the inch Verson som sateen Vertron Balance Sheet Tora Statens THB -Ready Type here to search o EL 207-DA Project-data (1) box Protecte File Home Insert Page Layout Formulas Data Review View i Protected View This file originated from an Internet location and might be unsafe. Click for more details Enable Editing L7 f D E G H 123,173 18,657 35,711 18,000 12,008 207.519 100,712 17.952 34703 18.393 12.264 184004 A B 37 38 Long-term debt 39 Employee benefit obligations 40 Deferred income taxes 41 Non-current operating lease liabilities 42 Other liabilities 43 Total long-term liabilities 44 Commitments and Contingencies 45 (Note 16) 46 47 Equity Series preferred stock (50.10 par value, 250,000,000 shares authorized, none issued) Common stock (50.10 par value: 6,250,000,000 shares authorized in each 49 period, 4291,433,646 shares issued SO Additional paid in capital 51 Retained earnings Accumulated other comprehensive 52 income (loss) Common stock in treasury, at cost (133,304,088 and 155,603.527 share 53 s outstanding Deferred compensation - employer 54 stock ownership plans and other 55 Noncontrolling interest 56 Total equity 57 Total liabilities and equity 48 13,404 60,464 13.419 53.147 -71 998 -5.719 6.930 335 1.430 69,03 1.40 316,451 Vertron lance Sheet . Type here to search x .-= 207-DA Project-data () [Protected View] - File Home insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details Enable Editing L7 A B fo D T-Mobile US, Inc. Consolidated Statements of Comprehensive Income 1 2 3 Year Ended December 31, 2019 22.673 9,543 1.279 1.005 34 300 9.340 550 4 Year Ended December 31, (in millions, except share and per 5 share amounta) 2020 6 Revenues 7 8 Postpaid revenues 36,306 9 Prepaid revenue 9,421 10 Wholesale revenus 2.590 11 Roaming and other service even 2,078 12 13 Total servicere 50,395 14 Egipment reven 17.312 15 Other 690 16 17 Totale 69,392 18 Operating expenses 19 Cost of services, exclusive of depreciation and amortization shown 20 separately below 11,878 Cost of equipment was excluso depreciation and antortization shown 21 separately balos 16,385 22 Selling general and administrative 16.926 23 Impairment expert 24 Depreciation and amortization 14151 Vencon Income Stement Vernonce Shoes 44.995 bo 6,633 11899 14.139 6615 T-Mobile Income Statement File X - 1 207-DA Project-data (1)xx [Protecte Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details. Enable Editing L7 fr B D E G H 19 Cont of services, exclusive of depreciation and amortization shown 20 separately below 11,878 6,622 Cost of equipment sales, exclusive of depreciation and amortization shown 21 separately below 26,388 11.899 22 Selling peneral and administrative 18.926 14,139 23 Impairment expense 418 24 Depreciation and amortization 14,151 6,616 25 26 Total operating expenses 61,761 39.276 27 Operating income 6,636 5,722 28 Other income (expense) 29 30 Interest expense -2.483 -722 31 Interest expense to affiliates -247 -403 32 Interest income 29 33 Other expense, net -405 34 35 Total other expense, et 3.106 -1.119 36 Income from continuing operations 37 before income taxes 3,530 4,603 38 Income tax expense -786 -1.133 39 40 income from continuing operations 2.44 3.458 Income from descontinued operation 42 3,054 en 3.455 obile Income Statement Vereon Income Station Read Type here to search O XH- 207-DA Project-data (1)xlox [Protected View] - M File Home Insert Page Layout Formulas Data Review View i Protected View this file originated from an internet location and might be unsafe. Click for more details. Enable Editing L7 fo B D E G H T-Mobile US, Inc. 1 Consolidated Balance Sheets 2 3 December 31. 2020 December 31, 2019 MOND 4 (in millions, except share and per share 5 amounts) 6 Assets 7 Correntes 10,385 1.525 4.254 1.888 3.577 22 2.500 20 964 333 2.527 624 2,496 1.972 9,305 9 Cash and cash equivalenta $ Accounts receivable at of allowance 10 for credit loss of $194 and 561 Equipment installment plan receivables, net of allowance for credit 11 losses and impated discount of 12 Accounts receivable from affiliates 13 Inventory 14 Prepaid experts 15 Other correntes 16 17 Total current aus 18 Propety and equipment, 19 Operating last night of 20 Financing lase right-of-uset 21 Goodsalt 22 Spectrum en 23 Other instangible est Equipment installment plan receivables dos after one year net of alone for credit low and imputadducent of Verton Income Statement Read 23.885 41,175 28,021 3,028 21,934 10.993 2.7715 1.990 35,463 82,828 5293 Varron Bounce Sheet TO Inco content T-Mobile Balance Sheet Type here to search o - = 207-DA Project-data ()xlsx [Protected View] - File Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details. Enable Editing L7 D F H 3 K E 82,828 36,465 5,298 115 A B 22 Spectrum licenses 23 Other intangible anseta, net Equipment installment plan receivables doe after one year, net of allowance for credit comes and imputed discount of 24 $127 and 566 25 2,031 1,583 2,779 1,891 200,162 86.921 26 Other as 27 28 Total assets 29 Liabilities and Stockholders' Equity 30 Current liabilities 31 32 5 6,746 10.196 157 4,579 157 25 liabilities 33 Payable to affiliates 34 Short-term debt 35 36 Deferred revenue 37 Short-term operating lease liabilities 38 Short-term financing lease liabilities 39 40 Other carrentabilities 1,030 3.868 1,063 631 2.287 957 310 1.675 21.703 12.506 42 Total current liabilities 43 44 Long-term dabt 45 Long term debt to affiliates 46 Teste obligations 47 Deferred tax liabilities Vervon Income Statement Read 61 830 4,715 10.958 13.956 9.966 Verton Baance Sheet T-Moble Income Statement T-Mobile ce Sheet 11 Type here to search . 207-DA Project data (1).xlx [Protected View File Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more detail. Enable Editing L7 fy D F G H 1 E 4,716 3,028 9,966 26,719 1,444 13,986 2.236 5,507 10,599 1,345 5,412 954 113,115 45.626 A B 45 Long-term debt to affiliates 46 Tower obligations 47 Deferred tax liabilities 48 Operating lease liabilities 49 Financing lease liabilities 50 51 52 Other long-term liabilities 53 54 Total long-term liabilities Commitments and contingencies (Note 55 15) 56 Stockholders equity 57 58 Common Stock, par valoa $0.00001 per share, 2,000,000,000 shares authorised; 1.243,345,384 and 858,41 8,615 shares 59 sued 1,241,805,706 and 856,905 40 60 Additional paid in capital Treasury stock, at cost, 1,539,878 and 1.513,215 shares 61 IND 62 loss 63 Accumulated deficit 64 65 Total stockholders equity 66 aquity 72,772 39,495 - -11 -1.581 5836 -555 5.833 22.789 65.344 200,162 $8.927 Varuon Income Statement . The Income state T-Mobile Balance Sheet Ready Type here to search O IR- Ft Home 207 Data Analyties Proje SP22 (1) Protected View] - Microsoft Excel Insert Page Layout Formulas Data Review View This file originated from an internet location and might be unsafe. Click for more details Enable ting Protected View HS2 0 GI M 1 IN Activity Ratios Profitability Ratios Asset Turnover Revenues/Total Assets Profit Margin-Net Income / Net Sales Revenues Total Assets Asset Turnover Hevenges Verizon 2019 2020 Pratit Martin Verizon Net Income / 2019 2020 30 Operating Revenues Total Assets Asset Turnover T-Mobile 2019 2020 Profile Margin T-Mobile Net Income Operating Revenues 2019 2020 Decembles Tumover - Operating Revenue/Net Accounts Receivable Return on Assets - Net Income/Total Assess Nevenues Accounts Receivable net-Receivables Tumove Total Assets Verizon 2019 2020 Return on Assets Verizon Net Income 2019 2020 Operating Revenues Accounts Receivable net-Receivables Tumover Total Assets Return on Assets T-Mobile 2019 2020 T-Mobile Net Incomel/ 2019 2020 Average Collection Period365/Receivables Turnover Ratio Return on Shareholders' Equity Net Income / Shareholders Equity 355 Verizon 2019 2020 Receivables Turnoves 0.000 Ave. Collection Period 3657 365 Verizon Net Income / Shareholdere on Shareholders'Equity 2019 20201 355 Total Equity T-Mobile 2019 2020 - Turn on Shareholders Receivables Tumover Avg Collection Period 0.000 0.000 T-Mobile Net Incomel / 2019) 2020 3651 Answer Key Type here to search ZI Home insert 207-Data Analytics Project SP2Z () Protected View] - Microce View Page Layout Formular Review Hotected This file ongenated from an internet location and might be inte for more detail Esable Editing 149 AE G 2020 M M 0 P 0 2020 Collection P55/Receivables Turnover Natio Return on Seholders' uity Net Income / Shareholde quity Veriton 2019) Ave. Collection Period Hervables TV sel 0.000 3657 0.000 Verizon Net Income on Shareholders' Equity 2009 2020 20.30 365 Ave. Collection Period T-Mobile 2019 2020 Receivables Turnov 0.000 0000 Total Equity -unen Shareholders 365 1657 T-Mobile Net Income 2019 2020 Inventory umover Cottor Goods Sold/inntry Balance 2019 Cost of Sales horntories ventory Turnover Verizon 2019 2010 Verizon 2020 Ver Mb 000 T-Mobile 0.000 D1000 0.000 Proti Marcin Return on A on Shareholders Equity 0 000 0.000 Inventories tory Turnover Mobile Cost of Sales Coment 2019 20:30 Arnare av innentor 105nventory Turnoverato 365 Ave Days in Inventory Verizon 2019 2020 u Inventory Turnover 5654 365 Inventory Turnover Ant. Oavs In Inventory T-Mobile 2019 2020 s! 30 Anwer Key Type here to search o 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 . . 4. (20 points) Write a short paragraph making an overall comparison between the efficiency ratios of both companies. 5. (20 points) Write a short paragraph making an overall comparison between the profitability ratios of both companies. XI. 207-DA Project data (1) Pre File Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details Enable Editing L7 H 2019 110,305 21,563 131,868 A C D Consolidated Statements of Income 1 2 Verizon Communications Inc. and Subsidiaries 3 (dollars in millions, except per share amounts) 4 5 Years Ended December 31 2020 6 7 Operating Revenues 8 Service revenues and other 109,872 9 Wireless equipment revenues 18,420 10 Total Operating Revenues 128,292 11 12 Operating Expenses Cost of services (exclusive of items 13 shown below) 31,401 14 Cost of wels equipment 19.500 Selling, general and administrative 15 esperise 31,573 16 Depreciation and amortization expense 16,720 17 Media poodwill impairment 18 Total Operating Expenses 99.494 19 20 Operating Income 28.798 Equity in losses of unconsolidated 21 businesses -15 22 Other income (pesett 339 4,947 Income Before Provision For 24 Income Tases 23.967 Veron Income Statement Ver online she Bea 31,722 22954 29.896 16 682 186 101,490 30313 22 Intentespese 15 -2.900 4,730 22,133 Type here to search O XH9--1 File Home 207-DA Projed-data (1) Protect Insert Page Layout Formulas Data Review View Protected View This nile orginated from an internet location and might be unsafe. Click for more details Enable Eating L7 D F G $ 109.872 15420 128,292 110,303 21,563 131,868 31,401 19,800 31,772 22,954 31,573 16,720 29.896 16,682 156 101,490 99.494 A B & Service revenues and other $ 9 Wireless equipment revenues 10 Total Operating Revenues 11 12 Operating Expenses Cost of services (exclusive of items 13 shown below) 14 Cost of wireless equipe Selling general and administrative 15 expense 16 Depreciation and amortization expense 17 Medi poodwill impairment 18 Total Operating Expenses 19 20 Operating Income Equity in losses of unconsolidated 21 bones 22 Other income (expense), et 23 Interest expense Income Before Provision For 24 Income Taxes 25 Provision for income 26 Net Income 27 Net income attributable to 28 noncontrolling interest 29 Net income attributable to Veriton Net Income 30 28,798 30,378 -45 -339 4.247 -15 -2.900 23.967 -5,619 18.45 22.733 -2.945 19.755 as SA 347 17,801 19.263 18.45 19.755 Venxon Income Statement Vanes Type here to search XI H: |= 207-DA Project-data (1)xx [Protecte File Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details Enable Editing L7 G H 2019 2.594 26,162 1.152 733 25,429 B D E F 1 Consolidated Balance Sheets Verizon Communications Inc. and 2 Subsidiaries 3 4 (dollars in millions, except per share amounts) 5 At December 31, 2020 6 7 Assets 8 Current assets 9 Cash and cash equivalents 22,171 10 Accounts receivable 25.169 11 Less Allowance for credit losses 12 Lesowance for our ts 13 Accounts receivable, net (Note 1) 23,917 14 Inventories 1,796 15 Prepaid expenses and other 6,710 16 Total current assets 54,594 17 18 Property, plant and equipment 279,737 19 Less Accumulated depreciation 184.904 20 Property, plant and equipment, net 94,833 21 Investments in unconsolidated 22 businesses 589 23 Wireless licenses 96,097 24 Goodwill 21,773 25 Other intangible assets. net 9,113 26 Operating Itase right of us assets 22,531 17 Other AS Vergron Income Statement Veriton Balance Sheet Rady 3,028 37.473 265,734 173,819 91.915 358 95.059 24359 9.495 Type here to search EL XI. 207-DA Project-data (1) box [Prote File Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details Enable Editing L7 be A B D E F G H 26 Operating lease right-of-use assets 22,531 22,694 27 Other assets 13,651 10,141 28 Total assets 316,481 $ 291,727 29 30 Liabilities and Equity 31 Current liabilities 32 Debt maturing within one year 5,889 10,777 Accounts payable and accrued 33 liabilities 20,658 21.306 34 Current operating lease liabilities 3,485 3.261 35 Other current liabilities 9.628 9,034 36 Total current liabilities 39,660 44.865 37 38 Long-term debt 123,173 100,712 39 Employee benefit obligations 18,657 17.952 40 Deferred income taxes 35,711 34 703 41 Non-current operating lease Isabilities 18,000 15.393 42 Other abilities 7208 12.264 43 Total long-term liabilities 207,549 184024 44 Commitments and Contingencies 45 (Note 16 46 47 Equity Series preferred stock (50.10 par value, 250,000,000 shares 48 authorized, nont issued) Common stock (50.10 par value, 6.250,000,000 shares the inch Verson som sateen Vertron Balance Sheet Tora Statens THB -Ready Type here to search o EL 207-DA Project-data (1) box Protecte File Home Insert Page Layout Formulas Data Review View i Protected View This file originated from an Internet location and might be unsafe. Click for more details Enable Editing L7 f D E G H 123,173 18,657 35,711 18,000 12,008 207.519 100,712 17.952 34703 18.393 12.264 184004 A B 37 38 Long-term debt 39 Employee benefit obligations 40 Deferred income taxes 41 Non-current operating lease liabilities 42 Other liabilities 43 Total long-term liabilities 44 Commitments and Contingencies 45 (Note 16) 46 47 Equity Series preferred stock (50.10 par value, 250,000,000 shares authorized, none issued) Common stock (50.10 par value: 6,250,000,000 shares authorized in each 49 period, 4291,433,646 shares issued SO Additional paid in capital 51 Retained earnings Accumulated other comprehensive 52 income (loss) Common stock in treasury, at cost (133,304,088 and 155,603.527 share 53 s outstanding Deferred compensation - employer 54 stock ownership plans and other 55 Noncontrolling interest 56 Total equity 57 Total liabilities and equity 48 13,404 60,464 13.419 53.147 -71 998 -5.719 6.930 335 1.430 69,03 1.40 316,451 Vertron lance Sheet . Type here to search x .-= 207-DA Project-data () [Protected View] - File Home insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details Enable Editing L7 A B fo D T-Mobile US, Inc. Consolidated Statements of Comprehensive Income 1 2 3 Year Ended December 31, 2019 22.673 9,543 1.279 1.005 34 300 9.340 550 4 Year Ended December 31, (in millions, except share and per 5 share amounta) 2020 6 Revenues 7 8 Postpaid revenues 36,306 9 Prepaid revenue 9,421 10 Wholesale revenus 2.590 11 Roaming and other service even 2,078 12 13 Total servicere 50,395 14 Egipment reven 17.312 15 Other 690 16 17 Totale 69,392 18 Operating expenses 19 Cost of services, exclusive of depreciation and amortization shown 20 separately below 11,878 Cost of equipment was excluso depreciation and antortization shown 21 separately balos 16,385 22 Selling general and administrative 16.926 23 Impairment expert 24 Depreciation and amortization 14151 Vencon Income Stement Vernonce Shoes 44.995 bo 6,633 11899 14.139 6615 T-Mobile Income Statement File X - 1 207-DA Project-data (1)xx [Protecte Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details. Enable Editing L7 fr B D E G H 19 Cont of services, exclusive of depreciation and amortization shown 20 separately below 11,878 6,622 Cost of equipment sales, exclusive of depreciation and amortization shown 21 separately below 26,388 11.899 22 Selling peneral and administrative 18.926 14,139 23 Impairment expense 418 24 Depreciation and amortization 14,151 6,616 25 26 Total operating expenses 61,761 39.276 27 Operating income 6,636 5,722 28 Other income (expense) 29 30 Interest expense -2.483 -722 31 Interest expense to affiliates -247 -403 32 Interest income 29 33 Other expense, net -405 34 35 Total other expense, et 3.106 -1.119 36 Income from continuing operations 37 before income taxes 3,530 4,603 38 Income tax expense -786 -1.133 39 40 income from continuing operations 2.44 3.458 Income from descontinued operation 42 3,054 en 3.455 obile Income Statement Vereon Income Station Read Type here to search O XH- 207-DA Project-data (1)xlox [Protected View] - M File Home Insert Page Layout Formulas Data Review View i Protected View this file originated from an internet location and might be unsafe. Click for more details. Enable Editing L7 fo B D E G H T-Mobile US, Inc. 1 Consolidated Balance Sheets 2 3 December 31. 2020 December 31, 2019 MOND 4 (in millions, except share and per share 5 amounts) 6 Assets 7 Correntes 10,385 1.525 4.254 1.888 3.577 22 2.500 20 964 333 2.527 624 2,496 1.972 9,305 9 Cash and cash equivalenta $ Accounts receivable at of allowance 10 for credit loss of $194 and 561 Equipment installment plan receivables, net of allowance for credit 11 losses and impated discount of 12 Accounts receivable from affiliates 13 Inventory 14 Prepaid experts 15 Other correntes 16 17 Total current aus 18 Propety and equipment, 19 Operating last night of 20 Financing lase right-of-uset 21 Goodsalt 22 Spectrum en 23 Other instangible est Equipment installment plan receivables dos after one year net of alone for credit low and imputadducent of Verton Income Statement Read 23.885 41,175 28,021 3,028 21,934 10.993 2.7715 1.990 35,463 82,828 5293 Varron Bounce Sheet TO Inco content T-Mobile Balance Sheet Type here to search o - = 207-DA Project-data ()xlsx [Protected View] - File Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more details. Enable Editing L7 D F H 3 K E 82,828 36,465 5,298 115 A B 22 Spectrum licenses 23 Other intangible anseta, net Equipment installment plan receivables doe after one year, net of allowance for credit comes and imputed discount of 24 $127 and 566 25 2,031 1,583 2,779 1,891 200,162 86.921 26 Other as 27 28 Total assets 29 Liabilities and Stockholders' Equity 30 Current liabilities 31 32 5 6,746 10.196 157 4,579 157 25 liabilities 33 Payable to affiliates 34 Short-term debt 35 36 Deferred revenue 37 Short-term operating lease liabilities 38 Short-term financing lease liabilities 39 40 Other carrentabilities 1,030 3.868 1,063 631 2.287 957 310 1.675 21.703 12.506 42 Total current liabilities 43 44 Long-term dabt 45 Long term debt to affiliates 46 Teste obligations 47 Deferred tax liabilities Vervon Income Statement Read 61 830 4,715 10.958 13.956 9.966 Verton Baance Sheet T-Moble Income Statement T-Mobile ce Sheet 11 Type here to search . 207-DA Project data (1).xlx [Protected View File Home Insert Page Layout Formulas Data Review View Protected View This file originated from an Internet location and might be unsafe. Click for more detail. Enable Editing L7 fy D F G H 1 E 4,716 3,028 9,966 26,719 1,444 13,986 2.236 5,507 10,599 1,345 5,412 954 113,115 45.626 A B 45 Long-term debt to affiliates 46 Tower obligations 47 Deferred tax liabilities 48 Operating lease liabilities 49 Financing lease liabilities 50 51 52 Other long-term liabilities 53 54 Total long-term liabilities Commitments and contingencies (Note 55 15) 56 Stockholders equity 57 58 Common Stock, par valoa $0.00001 per share, 2,000,000,000 shares authorised; 1.243,345,384 and 858,41 8,615 shares 59 sued 1,241,805,706 and 856,905 40 60 Additional paid in capital Treasury stock, at cost, 1,539,878 and 1.513,215 shares 61 IND 62 loss 63 Accumulated deficit 64 65 Total stockholders equity 66 aquity 72,772 39,495 - -11 -1.581 5836 -555 5.833 22.789 65.344 200,162 $8.927 Varuon Income Statement . The Income state T-Mobile Balance Sheet Ready Type here to search O IR- Ft Home 207 Data Analyties Proje SP22 (1) Protected View] - Microsoft Excel Insert Page Layout Formulas Data Review View This file originated from an internet location and might be unsafe. Click for more details Enable ting Protected View HS2 0 GI M 1 IN Activity Ratios Profitability Ratios Asset Turnover Revenues/Total Assets Profit Margin-Net Income / Net Sales Revenues Total Assets Asset Turnover Hevenges Verizon 2019 2020 Pratit Martin Verizon Net Income / 2019 2020 30 Operating Revenues Total Assets Asset Turnover T-Mobile 2019 2020 Profile Margin T-Mobile Net Income Operating Revenues 2019 2020 Decembles Tumover - Operating Revenue/Net Accounts Receivable Return on Assets - Net Income/Total Assess Nevenues Accounts Receivable net-Receivables Tumove Total Assets Verizon 2019 2020 Return on Assets Verizon Net Income 2019 2020 Operating Revenues Accounts Receivable net-Receivables Tumover Total Assets Return on Assets T-Mobile 2019 2020 T-Mobile Net Incomel/ 2019 2020 Average Collection Period365/Receivables Turnover Ratio Return on Shareholders' Equity Net Income / Shareholders Equity 355 Verizon 2019 2020 Receivables Turnoves 0.000 Ave. Collection Period 3657 365 Verizon Net Income / Shareholdere on Shareholders'Equity 2019 20201 355 Total Equity T-Mobile 2019 2020 - Turn on Shareholders Receivables Tumover Avg Collection Period 0.000 0.000 T-Mobile Net Incomel / 2019) 2020 3651 Answer Key Type here to search ZI Home insert 207-Data Analytics Project SP2Z () Protected View] - Microce View Page Layout Formular Review Hotected This file ongenated from an internet location and might be inte for more detail Esable Editing 149 AE G 2020 M M 0 P 0 2020 Collection P55/Receivables Turnover Natio Return on Seholders' uity Net Income / Shareholde quity Veriton 2019) Ave. Collection Period Hervables TV sel 0.000 3657 0.000 Verizon Net Income on Shareholders' Equity 2009 2020 20.30 365 Ave. Collection Period T-Mobile 2019 2020 Receivables Turnov 0.000 0000 Total Equity -unen Shareholders 365 1657 T-Mobile Net Income 2019 2020 Inventory umover Cottor Goods Sold/inntry Balance 2019 Cost of Sales horntories ventory Turnover Verizon 2019 2010 Verizon 2020 Ver Mb 000 T-Mobile 0.000 D1000 0.000 Proti Marcin Return on A on Shareholders Equity 0 000 0.000 Inventories tory Turnover Mobile Cost of Sales Coment 2019 20:30 Arnare av innentor 105nventory Turnoverato 365 Ave Days in Inventory Verizon 2019 2020 u Inventory Turnover 5654 365 Inventory Turnover Ant. Oavs In Inventory T-Mobile 2019 2020 s! 30 Anwer Key Type here to search o