Homework Help is Here – Start Your Trial Now!
Business
Accounting
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 ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

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.

Breakdown TTM 12/31/2020 12/31/2019 12/31/2018 > Total Revenue 172920,000 171760,000 181193,000 170,756,000 Cost of Revenue 81819,000 79.920,000 84141,000 79.419,000 Gross Profit 91101,000 91840,000 97,052,000 91337,000 > Operating Expense 65,764,000 66.555,000 67,639,000 65 195,000 Operating income 25.337,000 25.285,000 29.413,000 26.142,000 > Net Non Operating Interest Inc. -7,957,000 -7,777,000 -7,925,000 8,422,000 > Other Income Expense -16617,000 20.216,000 -2,523,000 6,688,000 Pretax Income 943,000 -2,856,000 18.468,000 24.873,000 Tax Provision 1.785,000 965,000 3,493,000 4.920,000 > Net Income Common Stockhold. -2,447,000 -5,369,000 13.900,000 19.370,000 Auerage Dilution Eamings 23,000 23,000 21,000 19,000 Dluted NI Available to Com Stock. -2,424,000 -5,346,000 13.921,000 19.389,000 Basic EPS 0.75 190 285 Diuted EPS 0.75 1.89 2.85 Basic Average Shares 7,157,000 7,319,000 6,778,000 Dluted Average Shares 7,183,000 7,348,000 6,806,000 Total Operating Income as Reported 6.580,000 6.405,000 27,955,000 25.096,000 Total Expenses 147,583,000 145.475,000 151780,000 144.614,000 Net Income from Continuing a Dis. -2,236,000 -5,176,000 13903,000 19.370,000 Normaliaed Income 9,018,200 8,606,400 15.085,438 19.406.892 Interest Expense 7,777,000 7,925,000 8,422,000 7.957,000 Net Interest Income -7,777,000 -7,925,000 8,422,000 -7,957,000 EBIT 8,720,000 5,069,000 25.890,000 32830,000 EBITDA 45.043,000 Reconciled Cost of Revenue 72599,000 71317,000 74554,000 75.647,000 Reconcied Depreciation 36.323,000 37,119,000 37.804.000 32.202.000 Net Income from Continuing Oper. -2,236,000 -5,176,000 13903,000 19.370,000 Total Unusual Items Excluding Goo. -18.757,000 18.880,000 -1,458,000 -46.000 Total Unusual Items -18.757,000 -18.880,000 -1,458,000 45,000 Normaliand EBITDA 63.800,000 61.068,000 66.152,000 65.078,000 Tax Rate for Calcs Tax Etfect of Unusual Items -7,502,800 -5,097,600 275,562 9,108
Transcribed Image Text:Breakdown TTM 12/31/2020 12/31/2019 12/31/2018 > Total Revenue 172920,000 171760,000 181193,000 170,756,000 Cost of Revenue 81819,000 79.920,000 84141,000 79.419,000 Gross Profit 91101,000 91840,000 97,052,000 91337,000 > Operating Expense 65,764,000 66.555,000 67,639,000 65 195,000 Operating income 25.337,000 25.285,000 29.413,000 26.142,000 > Net Non Operating Interest Inc. -7,957,000 -7,777,000 -7,925,000 8,422,000 > Other Income Expense -16617,000 20.216,000 -2,523,000 6,688,000 Pretax Income 943,000 -2,856,000 18.468,000 24.873,000 Tax Provision 1.785,000 965,000 3,493,000 4.920,000 > Net Income Common Stockhold. -2,447,000 -5,369,000 13.900,000 19.370,000 Auerage Dilution Eamings 23,000 23,000 21,000 19,000 Dluted NI Available to Com Stock. -2,424,000 -5,346,000 13.921,000 19.389,000 Basic EPS 0.75 190 285 Diuted EPS 0.75 1.89 2.85 Basic Average Shares 7,157,000 7,319,000 6,778,000 Dluted Average Shares 7,183,000 7,348,000 6,806,000 Total Operating Income as Reported 6.580,000 6.405,000 27,955,000 25.096,000 Total Expenses 147,583,000 145.475,000 151780,000 144.614,000 Net Income from Continuing a Dis. -2,236,000 -5,176,000 13903,000 19.370,000 Normaliaed Income 9,018,200 8,606,400 15.085,438 19.406.892 Interest Expense 7,777,000 7,925,000 8,422,000 7.957,000 Net Interest Income -7,777,000 -7,925,000 8,422,000 -7,957,000 EBIT 8,720,000 5,069,000 25.890,000 32830,000 EBITDA 45.043,000 Reconciled Cost of Revenue 72599,000 71317,000 74554,000 75.647,000 Reconcied Depreciation 36.323,000 37,119,000 37.804.000 32.202.000 Net Income from Continuing Oper. -2,236,000 -5,176,000 13903,000 19.370,000 Total Unusual Items Excluding Goo. -18.757,000 18.880,000 -1,458,000 -46.000 Total Unusual Items -18.757,000 -18.880,000 -1,458,000 45,000 Normaliand EBITDA 63.800,000 61.068,000 66.152,000 65.078,000 Tax Rate for Calcs Tax Etfect of Unusual Items -7,502,800 -5,097,600 275,562 9,108
Breakdown 12/31/2020 12/31/2019 12/31/2018 12/31/2017 > Total Assets 525,761,000 551,669,000 531,864,000 444,097,000 > Total Liabilities Net Minority Int. 346,521,000 349,735,000 337,980,000 302,090,000 > Total Equity Gross Minority Inte. 179,240,000 201,934,000 193,884,000 142,007,000 Total Capitalization 313,601,000 333,658,000 350,339,000 266,833,000 Common Stock Equity 161,673,000 184,221,000 184,089,000 140,861,000 Capital Lease Obligations 24,238,000 23,838,000 Net Tangible Assets -119,902,000 -119,637,000 -126,108,000 -78,864,000 Working Capital -11,430,000 -14,150,000 -12,993,000 -2,243,000 Invested Capital 316,882,000 345,334,000 360,594,000 305,207,000 Tangible Book Value -119,902,000 -119,637,000 -126,108,000 -78,864,000 Total Debt 179,447,000 184,951,000 176,505,000 164,346,000 Net Debt 145,469,000 148,983,000 171,301,000 113,848,000 Share Issued 7,620,749 7,620,749 7,620,749 6,495,231 Ordinary Shares Number 7,125,922 7,254,555 7,281,629 6,139,425 Preferred Shares Number 118,000 48,000 Treasury Shares Number 494,827 366,193 339,120 355,807
Transcribed Image Text:Breakdown 12/31/2020 12/31/2019 12/31/2018 12/31/2017 > Total Assets 525,761,000 551,669,000 531,864,000 444,097,000 > Total Liabilities Net Minority Int. 346,521,000 349,735,000 337,980,000 302,090,000 > Total Equity Gross Minority Inte. 179,240,000 201,934,000 193,884,000 142,007,000 Total Capitalization 313,601,000 333,658,000 350,339,000 266,833,000 Common Stock Equity 161,673,000 184,221,000 184,089,000 140,861,000 Capital Lease Obligations 24,238,000 23,838,000 Net Tangible Assets -119,902,000 -119,637,000 -126,108,000 -78,864,000 Working Capital -11,430,000 -14,150,000 -12,993,000 -2,243,000 Invested Capital 316,882,000 345,334,000 360,594,000 305,207,000 Tangible Book Value -119,902,000 -119,637,000 -126,108,000 -78,864,000 Total Debt 179,447,000 184,951,000 176,505,000 164,346,000 Net Debt 145,469,000 148,983,000 171,301,000 113,848,000 Share Issued 7,620,749 7,620,749 7,620,749 6,495,231 Ordinary Shares Number 7,125,922 7,254,555 7,281,629 6,139,425 Preferred Shares Number 118,000 48,000 Treasury Shares Number 494,827 366,193 339,120 355,807
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Balance Sheet Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS