Guys could you please help me: I'm attaching AT&T's Balance Sheet and Income Statement for the analysis.I'd really appreciate help with the following:Perform a vertical financial analysis incorporatingi. Debt ratioii. Debt to equity ratioiii. Return on assetsiv. Return on equityv. Current ratiovi. Quick ratiovii. Inventory turnoverviii. Days in inventoryix. Accounts receivable turnoverx. Accounts receivable cycle in daysxi. Accounts payable turnoverxii. Accounts payable cycle in daysxiii. Earnings per share (EPS)xiv. Price to earnings ratio (P/E)xv. Cash conversion cycle (CCC), andxvi. Working capitalxvii. Explain Dupont identity, apply it to your selected company, interpret thecomponents in Dupont identity. BreakdownTTM12/31/202012/31/201912/31/2018> Total Revenue172920,000171760,000181193,000170,756,000Cost of Revenue81819,00079.920,00084141,00079.419,000Gross Profit91101,00091840,00097,052,00091337,000> Operating Expense65,764,00066.555,00067,639,00065 195,000Operating income25.337,00025.285,00029.413,00026.142,000> Net Non Operating Interest Inc.-7,957,000-7,777,000-7,925,0008,422,000> Other Income Expense-16617,00020.216,000-2,523,0006,688,000Pretax Income943,000-2,856,00018.468,00024.873,000Tax Provision1.785,000965,0003,493,0004.920,000> Net Income Common Stockhold.-2,447,000-5,369,00013.900,00019.370,000Auerage Dilution Eamings23,00023,00021,00019,000Dluted NI Available to Com Stock.-2,424,000-5,346,00013.921,00019.389,000Basic EPS0.75190285Diuted EPS0.751.892.85Basic Average Shares7,157,0007,319,0006,778,000Dluted Average Shares7,183,0007,348,0006,806,000Total Operating Income as Reported6.580,0006.405,00027,955,00025.096,000Total Expenses147,583,000145.475,000151780,000144.614,000Net Income from Continuing a Dis.-2,236,000-5,176,00013903,00019.370,000Normaliaed Income9,018,2008,606,40015.085,43819.406.892Interest Expense7,777,0007,925,0008,422,0007.957,000Net Interest Income-7,777,000-7,925,0008,422,000-7,957,000EBIT8,720,0005,069,00025.890,00032830,000EBITDA45.043,000Reconciled Cost of Revenue72599,00071317,00074554,00075.647,000Reconcied Depreciation36.323,00037,119,00037.804.00032.202.000Net Income from Continuing Oper.-2,236,000-5,176,00013903,00019.370,000Total Unusual Items Excluding Goo.-18.757,00018.880,000-1,458,000-46.000Total Unusual Items-18.757,000-18.880,000-1,458,00045,000Normaliand EBITDA63.800,00061.068,00066.152,00065.078,000Tax Rate for CalcsTax Etfect of Unusual Items-7,502,800-5,097,600275,5629,108 Breakdown12/31/202012/31/201912/31/201812/31/2017> Total Assets525,761,000551,669,000531,864,000444,097,000> Total Liabilities Net Minority Int.346,521,000349,735,000337,980,000302,090,000> Total Equity Gross Minority Inte.179,240,000201,934,000193,884,000142,007,000Total Capitalization313,601,000333,658,000350,339,000266,833,000Common Stock Equity161,673,000184,221,000184,089,000140,861,000Capital Lease Obligations24,238,00023,838,000Net Tangible Assets-119,902,000-119,637,000-126,108,000-78,864,000Working Capital-11,430,000-14,150,000-12,993,000-2,243,000Invested Capital316,882,000345,334,000360,594,000305,207,000Tangible Book Value-119,902,000-119,637,000-126,108,000-78,864,000Total Debt179,447,000184,951,000176,505,000164,346,000Net Debt145,469,000148,983,000171,301,000113,848,000Share Issued7,620,7497,620,7497,620,7496,495,231Ordinary Shares Number7,125,9227,254,5557,281,6296,139,425Preferred Shares Number118,00048,000Treasury Shares Number494,827366,193339,120355,807

Guys could you please help me: I'm attaching AT&T's Balance Sheet and Income Statement for the analysis. I'd really appreciate help with the following: Perform a vertical financial analysis incorporating i. Debt ratio ii. Debt to equity ratio iii. Return on assets iv. Return on equity v. Current ratio vi. Quick ratio vii. Inventory turnover viii. Days in inventory ix. Accounts receivable turnover x. Accounts receivable cycle in days xi. Accounts payable turnover xii. Accounts payable cycle in days xiii. Earnings per share (EPS) xiv. Price to earnings ratio (P/E) xv. Cash conversion cycle (CCC), and xvi. Working capital xvii. Explain Dupont identity, apply it to your selected company, interpret thecomponents in Dupont identity.

Guys could you please help me: I'm attaching AT&T's Balance Sheet and Income Statement for the analysis. I'd really appreciate help with the following: Perform a vertical financial analysis incorporating i. Debt ratio ii. Debt to equity ratio iii. Return on assets iv. Return on equity v. Current ratio vi. Quick ratio vii. Inventory turnover viii. Days in inventory ix. Accounts receivable turnover x. Accounts receivable cycle in days xi. Accounts payable turnover xii. Accounts payable cycle in days xiii. Earnings per share (EPS) xiv. Price to earnings ratio (P/E) xv. Cash conversion cycle (CCC), and xvi. Working capital xvii. Explain Dupont identity, apply it to your selected company, interpret thecomponents in Dupont identity.

Financial & Managerial Accounting

13th Edition

ISBN:9781285866307

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter13: Investments And Fair Value Accounting

Section: Chapter Questions

Problem 14EX

See similar textbooks

Similar questions

E23.10B (L0 1,4) (Classification of Transactions) Following are selected balance sheet accounts of BioLazer Corp. at December 31, 2020 and 2019, and the increases or decreases in each account from 2019 to 2020. Also presented is selected income statement information for the year ended December 31, 2020, and additional information. Increase Selected balance sheet accounts 2020 2019 (Decrease)AssetsAccounts receivable $154,000 $120,000 $34,000Property, plant, and equipment 631,000 581,000 50,000Accumulated…
#12 The summarized balance sheets of ROSE N' Company and GARDEN Company as of December 31, 2021, are as follows: ROSE N' CompanyBalance SheetDecember 31, 2021 Assets $2000000 Liabilities $220000 Capital stock 1000000 Retained earnings 780000 Total equities $2000000 GARDEN CompanyBalance SheetDecember 31, 2021 Assets $1480000 Liabilities $330000 Capital stock 990000 Retained earnings 160000 Total equities $1480000 If ROSE N' Company acquired a 30% interest in GARDEN Company on December 31, 2021 for $350000 and the equity method of accounting for the investment were used, the amount of the debit to Equity Investments (GARDEN) would have been $444000. $297000. $345000. $350000.
Xyz tradingCondensed comparative balance sheet 2021 2020 2019Assets:Current assets 468,000. 345,600. 300,000Property and equipment 600,000. 560,400. 500,400Other assets(advances ). 72,000. 126,000. 150,000Total assets. 1,140,000. 1,032,000. 950,400Liabilities and stockholders’ equityLiabilitiesCurrent liabilities 134,400. 112,800. 100,00012 % long-term notes payable. 240,000. 300,000 350,000Total liabilities. 374,400. 412,800. 450,000Stockholders’ equity10% preferred stock 120,000. 120,000. 120,000Common stock 300,000 240,000 200,000Additional paid in capital 84,000. 48,000 40,000Retained earnings…
1. The balance sheets at the end of each of the first two years of operations indicate the following:20172016Total current assets$600,000$560,000Total investments60,00040,000Total property, plant, and equipment900,000700,000Total current liabilities125,00080,000Total long-term liabilities350,000250,000Preferred 9% stock, $100 par100,000100,000Common stock, $10 par600,000600,000Paid-in capital in excess of par--common stock60,00060,000Retained earnings325,000210,000Based on the above information, if net income is $130,000 and interest expense is $40,000 for 2017, and the market price is $40, what is the price-earnings ratio on common stock (round to one decimal place)?a. 14.9b. 19.8c. 17.3d. 18.4
CONCORD INC.Comparative Balance SheetsDecember 31 Assets 2022 2021 Cash $80,500 $48,700 Accounts receivable 87,900 38,600 Inventory 111,900 102,100 Prepaid expenses 29,400 27,900 Long-term investments 139,800 113,700 Plant assets 284,200 241,900 Accumulated depreciation (47,700) (49,100) Total $686,000 $523,800 Liabilities and Stockholders’ Equity Accounts payable $106,000 $63,700 Accrued expenses payable 16,500 21,200 Bonds payable 117,100 149,500 Common stock 219,000 175,100 Retained earnings 227,400 114,300 Total $686,000 $523,800 CONCORD INC.Income StatementFor the Year Ended December 31, 2022 Sales revenue $382,500 Less: Cost of goods sold $135,600 Operating expenses, excluding…
Question Content Area Debt Management Ratios Financial statements for Steele Inc. follow. Steele Inc. Consolidated Income Statements (in thousands except per share amounts) 2023 2022 2021 Net sales $7,245,088 $6,944,296 $6,149,218 Cost of goods sold (5,286,253) (4,953,556) (4,355,675) Gross margin $1,958,835 $1,990,740 $1,793,543 General and administrative expenses (1,259,896) (1,202,042) (1,080,843) Special and nonrecurring items 2,617 0 0 Operating income $701,556 $788,698 $712,700 Interest expense (63,685) (62,398) (63,927) Other income 7,308 10,080 11,529 Gain on sale of investments 0 9,117 0 Income before income taxes $645,179 $745,497 $660,302 Provision for income taxes (254,000) (290,000) (257,000) Net income $391,179 $455,497 $403,302 Steele Inc. Consolidated Balance Sheets (in thousands) ASSETS Dec. 31, 2023 Dec. 31, 2022 Current assets: Cash and…
7. What amount of consolidated retained earnings will be reported? A.P 295,000 C. P 232,000B. P 268,000 D. P 205,0008. What amount of stockholders; equity will be reported?A. P 355,000 C. P 419,500B. P 397,000
Pharoah Corporation’s comparative balance sheet is presented below. PHAROAH CORPORATIONBalance SheetDecember 31 Assets 2021 2020 Cash $12,010 $8,980 Accounts receivable 17,810 19,660 Land 16,800 21,840 Buildings 58,800 58,800 Accumulated depreciation—buildings (12,600 ) (8,400 ) Total $92,820 $100,880 Liabilities and Shareholders’ Equity Accounts payable $10,390 $26,120 Common shares 63,000 57,960 Retained earnings 19,430 16,800 Total $92,820 $100,880 Additional information: 1. Profit was $19,010. Dividends declared and paid were $16,380. 2. No noncash investing and financing activities occurred during 2021. 3. The land was sold for cash of $4,120 resulting in a loss of $920 on the sale of the land. Prepare a cash flow statement for 2021 using the indirect method. Lu…
27. Presented below are data taken from the records of Shamrock Company. December 31,2020 December 31,2019 Cash $14,900 $8,100 Current assets other than cash 85,500 59,800 Long-term investments 10,000 52,700 Plant assets 334,100 216,500 $444,500 $337,100 Accumulated depreciation $20,200 $39,900 Current liabilities 39,600 22,200 Bonds payable 74,600 –0– Common stock 255,100 255,100 Retained earnings 55,000 19,900 $444,500 $337,100 Additional information: 1. Held-to-maturity debt securities carried at a cost of $42,700 on December 31, 2019, were sold in 2020 for $34,100. The loss (not unusual) was incorrectly charged directly to Retained Earnings. 2. Plant assets that cost $49,500 and were 80% depreciated were sold during 2020 for $8,100. The loss was incorrectly charged directly to Retained Earnings. 3. Net income as reported on…
The comparative balance sheet of Gus Company at December 31, 2024 and 2023 appears below:Assets:12/31/202412/31/2023Cash$ 53,000 $ 120,000 Accounts receivable (net)37,000 48,000 Inventories108,500 100,000 Equipment573,200 450,000 Accumulated depreciation-equipment (142,000) (176,000) $629,700 $542,000 Liabilities & Stockholders Equity: Accounts payable$ 62,500 $ 43,800 Bonds payable, due June 20240 100,000 Common stock, $10 par335,000 285,000 Paid-in capital in excess of par - Common stock74,000 55,000 Retained earnings 158,200 58,200 $629,700 $542,000 The income statement for the year ended December 31, 2024 appears below:Sales $625,700 Cost of merchandise sold 340,000 Gross profit 285,700 Operating expenses (includes $26,000 depreciation expense) 94,000 Operating Income 191,700 Interest expense 6,000Income before income tax 185,700 Income tax 60,700 Net income $125,000 Also in 2024, fully depreciated equipment costing $60,000 was scrapped at no salvage…
2018 Total industry assets = STANBIC + BARCLAYS = 6,205,018 + 8,994,562 = 15,199,580Concentration of STANBIC = 6,205,018 / 15,199,580 = 0.408236 = 0.41 = 41%Concentration of BARCLAYS = 8,994,562 / 15,199,580 = 0.591764 = 0.59 = 59% 2019Total industry assets = STANBIC + ASBA = 9,295,682 + 11,772,546 = 21,068,228Concentration of STANBIC = 9,295,682 / 21,068,228 = 0.441218 = 0.44 = 44%Concentration of ASBA = 11,772,546 / 21,068,228 = 0.558782 = 0.56 = 56% 2020Total industry assets = STANBIC + ASBA =12,742,132 + 12,546,473 = 25,288,605Concentration of STANBIC = 12,742,132 / 25,288,605 = 0.503869 = 0.50 = 50%Concentration of ASBA = 12,546,473 / 25,288,605 =0.496131= 0.50 = 50% Based on the five-firm concentration ratios calculated in above, determine the level of competition
Leverage Cook Corporation issued financial statements at December 31, 2019, that include the following information: Balance sheet at December 31,2019 Assets $8,000,000 Liabilities $1,200,000 Stockholders' equity (300,000 shares) $6,800,000 Income statement for 2019: Income from operations $1,200,000 Less: Interest expense (100,000) Income before taxes $1,100,000 Less: Income taxes expense (0,30) (330,000) Net income $ 770,000 The levels of assets, liabilities, stockholders' equity, and operating income have been stable in recent years; however, Cook Corporation is planning a 51,800,000 expansion program that will increase income from operations by $350,000 to $1,550,000, Cook is planning to sell 8.5% notes at par to finance the expansion. Required: What earnings per share does Cook report before the expansion?