I calculated the dupont model for Ford 2001 & GM 2001. I
calculated the profit margin,...
I calculated the dupont model for Ford 2001 & GM 2001. I
calculated the profit margin, asset turnover, financial leverage
and ROE to be as follows. Can someone verify the following to see
if I did it correctly:
Profit Margin (PM) = Net income / Sales
PM Ford 2001 = 65,453 / 162,412 = -0.336
PM GM 2001 = 601 / 177,260 = .0033
Asset Turnover (AT) = Sales / Average total assets
AT Ford 2001 = 162,412 / ((276,543...
2) Compute the EBIT margin and its components – the
gross profit margin and selling, general,...
2) Compute the EBIT margin and its components – the
gross profit margin and selling, general, and administrative
expenses to revenue in 2018 and 2019. What caused the change in
EBIT margin? [You do not have to use the average method – i.e. you
can use year-end numbers in computing the ratios.]
ATC Company
Balance Sheet on December31 ($ millions)
2018
2019
Inventory
20
28
Accounts Receivable
36
26
Other
29
36
Cash
410
473
Total Current Assets
495
562...
what is the wacc for amerisourcebergen?
Income Statement
9/30/17
Sales
$153,144.00
Cost Of Goods
$148,598.00
Gross...
what is the wacc for amerisourcebergen?
Income Statement
9/30/17
Sales
$153,144.00
Cost Of Goods
$148,598.00
Gross Profit
$4,546.00
Selling & Adminstrative & Depr. & Amort Expenses
$3,486.00
Income After Depreciation & Amortization
$1,060.00
Non-Operating Income
$3.00
Interest Expense
$145.00
Pretax Income
$918.00
Income Taxes
$553.00
Minority Interest
$0.00
Investment Gains/Losses
$0.00
Other Income/Charges
$0.00
Income From Cont. Operations
$364.00
Extras & Discontinued Operations
$0.00
Net Income
$364.00
Depreciation Footnote
9/30/17
Income Before Depreciation & Amortization
$1,493.00
Depreciation & Amortization (Cash...
A) The firm has a gross profit of $100, operating income (EBIT)
of $70, taxable income...
A) The firm has a gross profit of $100, operating income (EBIT)
of $70, taxable income (EBT) of $65, net income of $45, total
assets of $4,000, total equity of $1,200, and total sales of $200.
What is net profit margin?
B)The company has net income of $30,000 for the year and paid
dividends of $40,000. At the beginning of the year, the
company had common stock of $50,000, paid-in surplus of $60,000,
and retained earnings of $70,000. At the end...
Please calculate the following based on the facts
provided:
a. Gross Margin Ratio: Net sales =...
Please calculate the following based on the facts
provided:
a. Gross Margin Ratio: Net sales =
$1,000,000.00 & Cost of Goods Sold =
$200,000.
b. Return on assets ratio (ROA): Net Income
= $350,000 & Average Total Assets = $2,500,000
c. Return on Equity (ROE): Net Income =
$350,000 & Shareholder's Equity = $5,000,000.
d. Customer Acquisition Cost (CAC):
Sales/Marketing Costs = $450,000 & number of new customers
1,000.
e. Current Liquidity Ratio: Current
Assets = $1,200,000 & Current Liabilities=...
Please compute the following ratios
using 237.65b market cap (if needed)
Asset turnover
Operating profit margin...
Please compute the following ratios
using 237.65b market cap (if needed)
Asset turnover
Operating profit margin
Long-term debt to equity ratio
Current ratio
The Home
Depot, Inc. Balance Sheet
All
numbers in thousands
Period
Ending
1/29/17
1/31/16
Current
Assets
Cash And
Cash Equivalents
2,538,000
2,216,000
Short
Term Investments
-
-
Net
Receivables
2,029,000
1,890,000
Inventory
12,549,000
11,809,000
Other
Current Assets
608,000
569,000
Total
Current Assets
17,724,000
16,484,000
Long
Term Investments
-
-
Property
Plant and Equipment
21,914,000
22,191,000
Goodwill
2,093,000...
Please compute the following ratios
using 237.65b market cap (if needed)
Asset turnover
Operating profit margin...
Please compute the following ratios
using 237.65b market cap (if needed)
Asset turnover
Operating profit margin
Long-term debt to equity ratio
Current ratio
The Home
Depot, Inc. Balance Sheet
All
numbers in thousands
Period
Ending
1/29/17
1/31/16
Current
Assets
Cash And
Cash Equivalents
2,538,000
2,216,000
Short
Term Investments
-
-
Net
Receivables
2,029,000
1,890,000
Inventory
12,549,000
11,809,000
Other
Current Assets
608,000
569,000
Total
Current Assets
17,724,000
16,484,000
Long
Term Investments
-
-
Property
Plant and Equipment
21,914,000
22,191,000
Goodwill
2,093,000...
INCOME STATEMENT:
2016
2017
Sales
$100,000.00
$120,300.00
Cost of Goods Sold
$60,000.00
$72,180.00
Gross Margin
$40,000.00...
INCOME STATEMENT:
2016
2017
Sales
$100,000.00
$120,300.00
Cost of Goods Sold
$60,000.00
$72,180.00
Gross Margin
$40,000.00
$48,120.00
Depreciation
$16,000.00
$19,200.00
Administrative Costs
$9,000.00
$10,800.00
EBIT
$15,000.00
$18,120.00
Interest
$4,000.00
$4,000.00
Pre-tax income
$11,000.00
$14,120.00
Taxes
$4,400.00
$5,648.00
Net Income
$6,600.00
$8,472.00
Dividends
$0.00
$5,083.20
Addition to Retained Earnings
$6,600.00
$3,388.80
BALANCE SHEET AS OF 12/31/2017:
ASSETS
2016
2017
Cash
$5,000.00
$6,000.00
Inventory
$15,000.00
$18,000.00
Accounts Receivable
$15,000.00
$18,045.00
Current Assets
$35,000.00
$42,045.00
Net PPE
$80,000.00
$92,000.00
Total Assets (TA)
$115,000.00...
Calculate Return on equity (ROE), Return on assets (ROA), Net
Profit Margin (NPM), Debt ratio, and...
Calculate Return on equity (ROE), Return on assets (ROA), Net
Profit Margin (NPM), Debt ratio, and Total assets turnover for 2018
and 2019. Explain why ROE is lower in 2019 than in 2018 (explain in
terms of each ratio in DuPont equation for ROE).
Income Statements ($ in millions)
Balance Sheets ($ in millions)
2018
2019
Assets
2018
2019
Sales Revenue
$2,580
$2,865
Cash
$70
$50
Less: Cost of goods sold
$1,060
$1,500
Short-Term investments
$35
$9
Less: Operating Expenses...
Please Calculate the following ratios:
Asset turnover
Operating profit margin
Long-term debt to equity ratio
Current...
Please Calculate the following ratios:
Asset turnover
Operating profit margin
Long-term debt to equity ratio
Current ratio
The Home Depot, Inc. Income Statement
All
numbers in thousands
Revenue
1/29/17
1/31/16
Total
Revenue
94,595,000
88,519,000
Cost of
Revenue
62,282,000
58,254,000
Gross
Profit
32,313,000
30,265,000
Operating
Expenses
Research
Development
-
-
Selling
General and Administrative
17,132,000
16,801,000
Non
Recurring
-
-
Others
1,754,000
1,690,000
Total
Operating Expenses
-
-
Operating Income or Loss
13,427,000
11,774,000
Income from
Continuing Operations
Total
Other Income/Expenses...