Question

Income Statement Sales/Revenue Total revenue 76,480,000,000 Cost of Revenue 25,110,000,000 Gross Profit 51,370,000,000 Operating Exp 31,810,000,000...

Income Statement
Sales/Revenue
Total revenue 76,480,000,000
Cost of Revenue 25,110,000,000
Gross Profit 51,370,000,000
Operating Exp 31,810,000,000
Selling General & Admin -
Other Operating Expense 3,390,000,000
Unusual Expense 16,180,000,000
EBIT after Unusual Expense 2,130,000,000
Non Operating Income/Expense 385,000,000
Equity in Affiliates (Pretax) 1,020,000,000
Interest Expense 17,670,000,000
Pretax Income 16,370,000,000
Other After Tax Income (Expense) 1,300,000,000
Consolidated Net Income -
Minority Interest Expense 1,300,000,000
Net Income -
Discontinued Operations 1,300,000,000
Net Income After Extraordinaries -
Preferred Dividends 1,300,000,000
Net Income Available to Common

480,000,000

Balance Sheet
Assets
Cash & Short Term Investments $ 18,300,000,000.00
Total Accounts Receivable $ 13,490,000,000.00
Inventories $     8,770,000,000.00
Other Current Assets $     2,540,000,000.00
Total Current Assets $ 43,090,000,000.00
Net Property, Plant & Equipment $ 17,010,000,000.00
Total Investments and Advances $        751,000,000.00
Long-Term Note Receivable -
Intangible Assets $ 85,130,000,000.00
Other Assets $     4,220,000,000.00
Total Assets $157,300,000,000.00
Liabilities & Shareholders' Equity
Accounts Payable $     7,310,000,000.00
Income Tax Payable $     1,850,000,000.00
Other Current Liabilities $ 17,470,000,000.00
Total Current Liabilities $ 30,540,000,000.00
Long-Term Debt $ 30,680,000,000.00
Stockholders' Equity
Other Liabilities $ 17,490,000,000.00
Total Liabilities $ 97,140,000,000.00
Common Equity (Total) $ 60,160,000,000.00
Total Shareholders' Equity $ 60,160,000,000.00
Total Equity $ 60,160,000,000.00
Liabilities & Shareholders' Equity $157,300,000,000.00
Current Ratio $               1.41
Inv Turnover $               8.72
Total asset turnover $               0.49
Debt Ratio $               0.19
Debt to Equity ratio $               1.61

6.  Basic earning power

7. ROE

8. P/E Ratio

9. Market to Book Ratio

10.  The Dupont Equation:

We decompose the ROE into three ratios:

ROE = (Net profit margin) (Total asset utilization)(Equity Multiplier)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

6)Basic earning power= EBIT/total assets
=2130000000/157300000000=1.35%
7)ROE=net income/equity
=480000000/60160000000=0.80%
8)P/E ratio= price per share/earning per share
=
9)Market to book ratio= price per share/book value per share
=

8 and 9 can not be found since market price per share not given
10)ROE=(net profit margin)*(total asset util)*(equity multiplier)
=(net profit/sales)*(sales/assets)*(assets/equity)
=(480000000/76480000000)*(76480000000/157300000000)*(157300000000/60160000000)
=(0.63%)*(0.49)*(2.61)
=0.80%

Add a comment
Know the answer?
Add Answer to:
Income Statement Sales/Revenue Total revenue 76,480,000,000 Cost of Revenue 25,110,000,000 Gross Profit 51,370,000,000 Operating Exp 31,810,000,000...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Income Statement Revenue Total revenue $470,100 Cost of Revenue $149,700 Gross Profit $320,100 Operating Exp Selling...

    Income Statement Revenue Total revenue $470,100 Cost of Revenue $149,700 Gross Profit $320,100 Operating Exp Selling General & Admin $57,800 other $17,400 Total Operating Exp $269,900 Operating Income or Loss $200,200 Income from Continuing Operations Expenses Net/Total other Income $114,400 Earnings before Int & Tax $200,200 Interest Exp -$32,200 Income before Tax $314,600 Income Tax Exp $100 Minority Interest $23,300 Net Income from Continuing Ops $314,500 Net Income   $295,300 Net Income applicable to common shares $230,700 Balance Sheet Current Assets...

  • Balance Sheet Assets Fiscal year is January-December. All values USD millions. 2017 Cash & Short Term...

    Balance Sheet Assets Fiscal year is January-December. All values USD millions. 2017 Cash & Short Term Investments 18.3B Total Accounts Receivable 13.49B Inventories 8.77B Other Current Assets 2.54B Total Current Assets 43.09B 2017 Net Property, Plant & Equipment 17.01B Total Investments and Advances 751M Long-Term Note Receivable - Intangible Assets 85.13B Other Assets 4.22B Total Assets 157.3B Liabilities & Shareholders' Equity 2017 ST Debt & Current Portion LT Debt 3.91B Accounts Payable 7.31B Income Tax Payable 1.85B Other Current Liabilities...

  • 11 pts INCOME STATEMENT Sales/Revenue COGS excluding D&A Depreciation & Amortization Expense Gross Income EBIT SG&A...

    11 pts INCOME STATEMENT Sales/Revenue COGS excluding D&A Depreciation & Amortization Expense Gross Income EBIT SG&A Expense Unusual Expense Interest Expense Pretax Income Income Tax - Current Domestic Consolidated Net Income 2020 19,974 11,990 1,067 6,917 5,705 104 207 901 159 691 2019 20,229 12,199 964 7,066 5,601 167 256 1,042 272 801 5-step DuPont CALCULATE DUPONT FOR 2020 ONLY Ue AVG Assets, Equity 2020 ONLY AVG ASSET TURNOVER INTEREST BURDEN TAX BURDEN EBIT MARGIN EQUITY MULTIPLIER BALANCE SHEET Cash...

  • What is the current ratio? (1:1) What is the debt ratio? (%) Show work please 1....

    What is the current ratio? (1:1) What is the debt ratio? (%) Show work please 1. What is the current ratio? (1:1) 2. What is the debt ratio? (%) *Income Statement Income StatementBalance SheetCash Flow Statement Annual Financials Annual Financials for Lowe's Cos. View Ratios Fiscal year is February January. All values USD millions 2019 Sales/Revenue 71.31B Cost of Goods Sold (COGS) incl. D&A 49.88B COGS excluding D&A 48.27B Depreciation & Amortization Expense 1.61B Depreciation 1.48B Amortization of Intangibles 130M...

  • INCOME STATEMENT (Figures in $ millions) Net sales $ 12,600 Cost of goods sold 3,760 Other...

    INCOME STATEMENT (Figures in $ millions) Net sales $ 12,600 Cost of goods sold 3,760 Other expenses 4,127 Depreciation 2,388 Earnings before interest and taxes (EBIT) $ 2,375 Interest expense 655 Income before tax $ 1,720 Taxes (at 30%) 602 Net income $ 1,118 Dividends $ 816 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Cash and marketable securities $ 83 $ 152 Receivables 2,082 2,370 Inventories 157 208 Other current assets 837 902 Total...

  • Sales Revenues Cost of Goods Sold Gross Profit s 1,000 600 400 Depreciation Expense Other Operating...

    Sales Revenues Cost of Goods Sold Gross Profit s 1,000 600 400 Depreciation Expense Other Operating Expenses S 100 50 Total Operating Expenses Earnings Before Interest& Taxes (EBIT) Interest Expense Eamings Before Taxes Income Tax Expense Net Income 150 250 50 200 100 S 100 Beginning Owner's Equity Net Income Dividends Ending Owner's Equity s 2,950 100 50 S 3,000 Cash Receivables Inventory s 1,000 100 900 Current Assets Long-Term Assets Total Assets s 2,000 7,000 S 9,000 Current Liabilities...

  • Income Statement 2014 2015 2016 2017 Sales/Revenue 55.87B 55.36B 59.39B 62.76B Cost of Goods Sold (COGS)...

    Income Statement 2014 2015 2016 2017 Sales/Revenue 55.87B 55.36B 59.39B 62.76B Cost of Goods Sold (COGS) incl. D&A 20.52B 20.65B 23.43B 23.8B COGS excluding D&A 11.97B 11.94B 15.64B 15.68B Depreciation & Amortization Expense 8.55B 8.71B 7.79B 8.13B Depreciation 7.38B 7.82B 6.27B 6.75B Amortization of Intangibles 1.17B 890M 1.52B 1.38B Gross Income 35.35B 34.7B 35.96B 38.96B 2014 2015 2016 2017 SG&A Expense 19.69B 19.84B 21.15B 20.62B Research & Development 11.56B 11.95B 12.75B 13.14B Other SG&A 8.14B 7.88B 8.4B 7.48B Other Operating...

  • What is the asset utilization for 2017 and 2018? 1 Annual Financials for Microsoft Corp. 2...

    What is the asset utilization for 2017 and 2018? 1 Annual Financials for Microsoft Corp. 2 Fiscal year is July-June. All values USD millions. Income Statement 2017 Sales Revenue 96.02 6 Cost of Goods Sold (COGS) incl. D&A 34.62 7 COGS excluding D&A 26.77 8 Depreciation & Amortization Expense 7.86 Depreciation 6.1 10 Amortization of Intangibles 1.76 Gross Income 61.4 2018 110.18 38.97 29.02 9.95 7.7 2.25 71.21 Fiscal year is October September. All values USD millions. Balance Sheet Assets...

  • Ratios 2016 2015 a. Gross profit margin (%) 39.4 39.1 b. Operating profit margin (%) 5.1...

    Ratios 2016 2015 a. Gross profit margin (%) 39.4 39.1 b. Operating profit margin (%) 5.1 7.5 c. Net profit margin (%) 2.4 4.0 d. Return on shareholders' equity (%) 14.1 25.2 e. Return on assets (%) 3.1 5.2 f. Times interest earned coverage 3.6 5.6 g. Long-term debt-to-equity ratio 1.5 3.8 h. Days of inventory 126.2 121.8 i. Inventory turnover ratio 2.9 3.0 j. Average collection period 7.4 7.5 1-From 2015 to 2016, Macy’s, Inc., return on equity and...

  • what is the dupont EBT using avg assets equity what is the tax burden? INCOME STATEMENT...

    what is the dupont EBT using avg assets equity what is the tax burden? INCOME STATEMENT Sales/Revenue COGS excluding D&A Depreciation & Amortization Expense Gross Income EBIT SG&A Expense Unusual Expense Interest Expense Pretax Income Income Tax - Current Domestic Consolidated Net Income 2020 19,974 11,990 1,067 6,917 5,705 104 207 901 159 691 2019 20,229 12,199 964 7,066 5,601 167 256 1,042 272 801 BALANCE SHEET Cash & Short Term Investments Total Accounts Receivable Inventories Other Current Assets Miscellaneous...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT