Question

1 Approved Answer

Posted on Aug 22, 2024

QUestion: is accounts receivable growing faster than revenue? (NEED years 2019, 2018, 2017) 3 Months Ended Jun 30, 2018 Mar. 31, 2018 12 Months Ended

QUestion: is accounts receivable growing faster than revenue? (NEED years 2019, 2018, 2017)

3 Months Ended Jun 30, 2018 Mar. 31, 2018 12 Months Ended Mar. 31, 2018 Mar. 31, 2019 Dec 31, 2018 Sep 30, 2018 Dec 31, 2017 Sep. 30, 2017 Jun 30, 2017 Mar. 31, 2019 Mar 31, 2017 $22.857,000,000 5.605.000.000 5,137.000.000 33.600.000.000 $23.834,000,000 4.524.000.000 4.048.000.000 32.406.000.000 $25,368,000,000 4,684 000.000 3.295 000.000 3 3,347.000.000 $ 8.441.000.000 $8.601,000,000 $8.433.000.000 $ 8.125,000,000 $8.083.000.000 $8.239.000.000 $7.927.000.000 $8,157.000.000 6,801,000,000 493 000.000 6.109.000.000 8 087 000.000 7.861.000.000 975 000 000 6.583.000.000 7,994 000 000 6,654,000,000 643 000 000 6.082.000.000 7,774.000.000 2.000.000.000 4,538 000 000 4.245.000.000 608 000 000 2.000.000.000 (648 000 000) 33.202.000.000 398,000,000 3.792 000 000 3.976.000.000 812,000,000 CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) shares in Millions Revenues (Abstract] Service Revenue, equipment sales, net Revenue, equipment rentals, net Inter-segment revenues Net operating expenses: Cost of services (exclusive of depreciation and amortization included below) Cost of equipment rentals Cost of equipment sales Selling general and administrative Impairments Depreciation equipment rentals Depreciation, network and other Amortization Goodwill impairment Loss Other Operating Income Expense) Net Total costs and expenses Operating loss) income Other (expense) income: Interest expense Other income (expense), net Nonoperating income (expense) Income (loss) before income taxes income tax benet expense) Netloss Income (Loss) from Continuing Operations Net of Tax Including Portion Attributable to Noncontrolling interest Net Income (Loss) Attributable to Noncontrolling interest Earnings Per Share Basic Eamings Per Share, Diluted Weighted Average Number of Shares Outstanding. Basic Weighted Average Number of Shares Outstanding, Diluted 3. 116 000 000 3.982.000.000 1,052 000 000 (391,000,000) 29.679.000.000 2.727.000.000 20.000.000 31.583.000.000 1,764.000.000 (1.674 000 000) 479.000.000 778,000,000 8 15.000.000 236.000.000 727.000.000 601.000.000 1.163 000 000 (2.563,000,000) 187.000.000 (2.376.000.000) (1.978.000.000) 35 000 000 (1,943.000.000) 2.365.000.000) (59.000.000) (2.424 000 000) 303,000,000 7.074,000,000 7.389.000.000 (2.495.000.000) (40.000.000) 2 535.000.000) (771.000.000) (435 000 000) (1206.000.000) 12.174) (141) $196 $ 176 $0 $0 $0 (1.943.000.000) 7.377.000.000 (1.206.000.000) $ 0.02 $ 1053) $(530 000) $10.03) S (30,000) $ 0.08 $ 50.000 $ 0.04 $ 40,000 $ 1.79 $ 1.750.000 S (0.01) S (10,000) SOOS $ 50.000 $ 12,000,000 $ 1.85 $ 1.81 3.999 $ 0.48) $10.48) 4,057 $ 20,000 50 $(0:30) $0.30) 3.981 4,057 4,078 3.981 67 575 CONSOLIDATED BALANCE SHEETS - USD ($) Mar. 31, 2019 Mar. 31, 2018 $ in Millions Current assets Cash and cash equivalents $ 6,982 $6,610 Short-term investments 2,354 Accounts and notes receivable, net 3,554 3,711 Device and accessory inventory 999 1,003 Prepaid expenses and other current 1,289 assets Total Current Assets 12.891 14,253 Property, plant and equipment, net 21,201 19,925 Capitalized Contract Cost, Net 1,559 Intangible assets Goodwill 4,598 6,586 FCC licenses and other 41,465 41.309 Definite-lived intangible assets, net 1,769 2,465 Other assets 1,118 921 Total assets 84,601 85,459 Current liabilities Accounts payable 3,961 3,409 Accrued expenses and other current 3,597 3,962 liabilities Current portion of long-term debt, 3,429 financing and capital lease obligations Total Current Liabilities 12,115 10,800 Long-term debt, financing and capital 35,366 37,463 lease obligations Deferred tax liabilities 7,556 7,294 Other liabilities 3,437 3,483 Total liabilities 58,474 59,040 Commitments and contingencies Stockholders' equity Common stock, voting, par value $0.01 per share, 9.0 billion authorized, 4.005 billion and 3.989 billion issued at March 31, 2018 and 2017 Paid-in capital 28,306 27,884 Accumulated deficit (1,883) (1,255) Accumulated other comprehensive loss (392) (313) Total stockholders' equity 26.072 26,356 Stockholders' Equity Attributable to 55 63 Noncontrolling Interest Stockholders' Equity, Including Portion 26,127 26,419 Attributable to Noncontrolling Interest Total Liabilities and Stockholders' equity $ 84,601 $ 85,459 4,557 40 Mar. 31, 2019 Mar. 31, 2018 CONSOLIDATED BALANCE SHEETS (Parentheticals) - $ / shares Statement of Financial Position [Abstract] Common stock, par value Common shares, shares authorized (in shares) Common stock, shares, issued $ 0.01 $ 0.01 9,000,000,000 4,081,000,000 9,000,000,000 4,005,000,000 93 0 (302) 140 (223) 457 CONSOLIDATED STATEMENTS OF 12 Months Ended CASH FLOWS - USD ($) $ in Millions Mar. 31, 2019 Mar. 31, 2018 Mar. 31, 2017 Cash flows from operating activities: Income (Loss) from Continuing Operations, Net of Tax, Including Portion $(1,943) $7,377 $(1,206) Attributable to Noncontrolling Interest Adjustments to reconcile net loss to net cash provided by (used in) operating activities: Impairments 2,000 0 Depreciation and amortization 9,391 8,580 8,150 Provision for losses on accounts 394 362 555 receivable Share-based and long-term incentive 132 182 compensation expense Deferred income tax (benefit) expense (85) (7,119) Gains from asset dispositions and 479 exchanges Loss on early extinguishment of debt 65 Amortization and accretion of long-term (112) (158) debt premiums and discounts Loss on disposal of property, plant and 1,135 868 509 equipment Litigation and other contingencies 74 (13) Contract terminations 111 Deferred purchase price from sale of (1,140) (10,498) receivables Other changes in assets and liabilities: Accounts and notes receivable (150) 83 (1.017) Inventories and other current assets 279 705 Accounts payable and other current (142) 57 (365) liabilities Non-current assets and liabilities, net (728) 271 (308) Othernet 407 426 312 Net cash provided by (used in) operating 10,429 10.062 (3.290) activities Cash flows from investing activities: Capital expenditures - network and other (4,963) (3,319) (1.950) Capital expenditures - leased devices (7,441) (7,461) (4.976) Expenditures relating to FCC licenses (163) (115) (83) Proceeds from sales and maturities of 7,197 7,202 4,621 short-term investments Purchases of short-term investments (5,165) (4,112) (10,065) Proceeds from sale of assets and FCC 591 527 219 licenses Proceeds from Sale and Collection of 223 1,140 10,498 Receivables Proceeds from Life Insurance Policy 110 2 Other, net 30 Net cash used in investing activities (9,542) (6,135) (1.695) Cash flows from financing activities: Proceeds from debt and financings 9,307 8.529 10,966 Repayments of debt financing and capital (9,764) (8.518) (5,417) lease obligations Debt financing costs (321) (93) (358) Call premiums paid on debt redemptions 0 131 0 Proceeds from issuance of common stock 291 21 50 and warrants, net Other, net (18) 45 Net cash provided by (used in) financing (483) (210) 5,286 activities Net increase (decrease) in cash, cash 1 3,717 301 equivalents and restricted cash Cash, cash equivalents and restricted 6,659 cash, beginning of period 2,942 2,641 Cash, cash equivalents and restricted cash, end of period $ 7,063 $6.659 $2.942 % 11 404 3 Months Ended Jun 30, 2018 Mar. 31, 2018 12 Months Ended Mar. 31, 2018 Mar. 31, 2019 Dec 31, 2018 Sep 30, 2018 Dec 31, 2017 Sep. 30, 2017 Jun 30, 2017 Mar. 31, 2019 Mar 31, 2017 $22.857,000,000 5.605.000.000 5,137.000.000 33.600.000.000 $23.834,000,000 4.524.000.000 4.048.000.000 32.406.000.000 $25,368,000,000 4,684 000.000 3.295 000.000 3 3,347.000.000 $ 8.441.000.000 $8.601,000,000 $8.433.000.000 $ 8.125,000,000 $8.083.000.000 $8.239.000.000 $7.927.000.000 $8,157.000.000 6,801,000,000 493 000.000 6.109.000.000 8 087 000.000 7.861.000.000 975 000 000 6.583.000.000 7,994 000 000 6,654,000,000 643 000 000 6.082.000.000 7,774.000.000 2.000.000.000 4,538 000 000 4.245.000.000 608 000 000 2.000.000.000 (648 000 000) 33.202.000.000 398,000,000 3.792 000 000 3.976.000.000 812,000,000 CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) shares in Millions Revenues (Abstract] Service Revenue, equipment sales, net Revenue, equipment rentals, net Inter-segment revenues Net operating expenses: Cost of services (exclusive of depreciation and amortization included below) Cost of equipment rentals Cost of equipment sales Selling general and administrative Impairments Depreciation equipment rentals Depreciation, network and other Amortization Goodwill impairment Loss Other Operating Income Expense) Net Total costs and expenses Operating loss) income Other (expense) income: Interest expense Other income (expense), net Nonoperating income (expense) Income (loss) before income taxes income tax benet expense) Netloss Income (Loss) from Continuing Operations Net of Tax Including Portion Attributable to Noncontrolling interest Net Income (Loss) Attributable to Noncontrolling interest Earnings Per Share Basic Eamings Per Share, Diluted Weighted Average Number of Shares Outstanding. Basic Weighted Average Number of Shares Outstanding, Diluted 3. 116 000 000 3.982.000.000 1,052 000 000 (391,000,000) 29.679.000.000 2.727.000.000 20.000.000 31.583.000.000 1,764.000.000 (1.674 000 000) 479.000.000 778,000,000 8 15.000.000 236.000.000 727.000.000 601.000.000 1.163 000 000 (2.563,000,000) 187.000.000 (2.376.000.000) (1.978.000.000) 35 000 000 (1,943.000.000) 2.365.000.000) (59.000.000) (2.424 000 000) 303,000,000 7.074,000,000 7.389.000.000 (2.495.000.000) (40.000.000) 2 535.000.000) (771.000.000) (435 000 000) (1206.000.000) 12.174) (141) $196 $ 176 $0 $0 $0 (1.943.000.000) 7.377.000.000 (1.206.000.000) $ 0.02 $ 1053) $(530 000) $10.03) S (30,000) $ 0.08 $ 50.000 $ 0.04 $ 40,000 $ 1.79 $ 1.750.000 S (0.01) S (10,000) SOOS $ 50.000 $ 12,000,000 $ 1.85 $ 1.81 3.999 $ 0.48) $10.48) 4,057 $ 20,000 50 $(0:30) $0.30) 3.981 4,057 4,078 3.981 67 575 CONSOLIDATED BALANCE SHEETS - USD ($) Mar. 31, 2019 Mar. 31, 2018 $ in Millions Current assets Cash and cash equivalents $ 6,982 $6,610 Short-term investments 2,354 Accounts and notes receivable, net 3,554 3,711 Device and accessory inventory 999 1,003 Prepaid expenses and other current 1,289 assets Total Current Assets 12.891 14,253 Property, plant and equipment, net 21,201 19,925 Capitalized Contract Cost, Net 1,559 Intangible assets Goodwill 4,598 6,586 FCC licenses and other 41,465 41.309 Definite-lived intangible assets, net 1,769 2,465 Other assets 1,118 921 Total assets 84,601 85,459 Current liabilities Accounts payable 3,961 3,409 Accrued expenses and other current 3,597 3,962 liabilities Current portion of long-term debt, 3,429 financing and capital lease obligations Total Current Liabilities 12,115 10,800 Long-term debt, financing and capital 35,366 37,463 lease obligations Deferred tax liabilities 7,556 7,294 Other liabilities 3,437 3,483 Total liabilities 58,474 59,040 Commitments and contingencies Stockholders' equity Common stock, voting, par value $0.01 per share, 9.0 billion authorized, 4.005 billion and 3.989 billion issued at March 31, 2018 and 2017 Paid-in capital 28,306 27,884 Accumulated deficit (1,883) (1,255) Accumulated other comprehensive loss (392) (313) Total stockholders' equity 26.072 26,356 Stockholders' Equity Attributable to 55 63 Noncontrolling Interest Stockholders' Equity, Including Portion 26,127 26,419 Attributable to Noncontrolling Interest Total Liabilities and Stockholders' equity $ 84,601 $ 85,459 4,557 40 Mar. 31, 2019 Mar. 31, 2018 CONSOLIDATED BALANCE SHEETS (Parentheticals) - $ / shares Statement of Financial Position [Abstract] Common stock, par value Common shares, shares authorized (in shares) Common stock, shares, issued $ 0.01 $ 0.01 9,000,000,000 4,081,000,000 9,000,000,000 4,005,000,000 93 0 (302) 140 (223) 457 CONSOLIDATED STATEMENTS OF 12 Months Ended CASH FLOWS - USD ($) $ in Millions Mar. 31, 2019 Mar. 31, 2018 Mar. 31, 2017 Cash flows from operating activities: Income (Loss) from Continuing Operations, Net of Tax, Including Portion $(1,943) $7,377 $(1,206) Attributable to Noncontrolling Interest Adjustments to reconcile net loss to net cash provided by (used in) operating activities: Impairments 2,000 0 Depreciation and amortization 9,391 8,580 8,150 Provision for losses on accounts 394 362 555 receivable Share-based and long-term incentive 132 182 compensation expense Deferred income tax (benefit) expense (85) (7,119) Gains from asset dispositions and 479 exchanges Loss on early extinguishment of debt 65 Amortization and accretion of long-term (112) (158) debt premiums and discounts Loss on disposal of property, plant and 1,135 868 509 equipment Litigation and other contingencies 74 (13) Contract terminations 111 Deferred purchase price from sale of (1,140) (10,498) receivables Other changes in assets and liabilities: Accounts and notes receivable (150) 83 (1.017) Inventories and other current assets 279 705 Accounts payable and other current (142) 57 (365) liabilities Non-current assets and liabilities, net (728) 271 (308) Othernet 407 426 312 Net cash provided by (used in) operating 10,429 10.062 (3.290) activities Cash flows from investing activities: Capital expenditures - network and other (4,963) (3,319) (1.950) Capital expenditures - leased devices (7,441) (7,461) (4.976) Expenditures relating to FCC licenses (163) (115) (83) Proceeds from sales and maturities of 7,197 7,202 4,621 short-term investments Purchases of short-term investments (5,165) (4,112) (10,065) Proceeds from sale of assets and FCC 591 527 219 licenses Proceeds from Sale and Collection of 223 1,140 10,498 Receivables Proceeds from Life Insurance Policy 110 2 Other, net 30 Net cash used in investing activities (9,542) (6,135) (1.695) Cash flows from financing activities: Proceeds from debt and financings 9,307 8.529 10,966 Repayments of debt financing and capital (9,764) (8.518) (5,417) lease obligations Debt financing costs (321) (93) (358) Call premiums paid on debt redemptions 0 131 0 Proceeds from issuance of common stock 291 21 50 and warrants, net Other, net (18) 45 Net cash provided by (used in) financing (483) (210) 5,286 activities Net increase (decrease) in cash, cash 1 3,717 301 equivalents and restricted cash Cash, cash equivalents and restricted 6,659 cash, beginning of period 2,942 2,641 Cash, cash equivalents and restricted cash, end of period $ 7,063 $6.659 $2.942 % 11 404