| 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)
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%
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 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 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 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) 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 2/3/2018 1/28/2017 1/30/2016 1/31/2015 Revenue Total Revenue 42,151,000 39,403,000 39,528,000 40,339,000 Cost of Revenue 32,275,000 29,963,000 30,334,000 31,292,000 Gross Profit 9,876,000 9,440,000 9,194,000 9,047,000 Operating Expenses Selling General and Administrative 7,911,000 7,493,000 7,612,000 7,550,000 Operating Income or Loss 1,965,000 1,947,000 1,582,000 1,497,000 Income from Continuing Operations Add Total Other Income/Expenses Net -148,000 -131,000 -272,000 -110,000 Interest Expense 75,000 72,000 80,000 90,000 Income Before Tax 1,742,000 1,744,000 1,230,000 1,297,000 Income Tax Expense 818,000 609,000 503,000 141,000 Add Discontinued Operations...
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 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...
LOWE’S COMPANIES INC. Income Statement (In millions) For Fiscal Year Ended January 29, 2016 Net sales. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $59,074 Cost of sales. . . . . . . . . . . . . . . . ....
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...
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...