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...
Maggie’s Skunk Removal Corp.’s 2015 income statement listed net
sales of $13.8 million, gross profit of...
Maggie’s Skunk Removal Corp.’s 2015 income statement listed net
sales of $13.8 million, gross profit of $8.70 million, EBIT of $6.9
million, net income available to common stockholders of $4.5
million, and common stock dividends of $2.5 million. The 2015
year-end balance sheet listed total assets of $53.8 million and
common stockholders' equity of $22.3 million with 2.0 million
shares outstanding.
Calculate the profit margin. (Round your answer to 2
decimal places.)
Profit margin
%
Calculate the profit margin. (Round...
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...