Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hatfield Medical Supplies: Balance Sheet (Millions of Dollars), 12/31/2013 Hatfield Medical Supplies: Income Statement (Millions of Dollars Except per Share) 2013 Cash $20 Sales $2,000.0

Hatfield Medical Supplies: Balance Sheet (Millions of Dollars), 12/31/2013 Hatfield Medical Supplies: Income Statement (Millions of Dollars Except per Share)
2013
Cash $20 Sales $2,000.0
Accts. rec. $280 Op. costs (excl. depr.) $1,800.0
Inventories $400 Depreciation $50.0
Total CA $700 EBIT $150.0
Net fixed assets $500 Interest $40.0
Total assets $1,200 Pretax earnings $110.0
Taxes (40%) $44.0
Accts. pay. & accruals $80 Net income $66.0
Line of credit $0
Total CL $80 Dividends $20.0
Long-term debt $500 Add. to RE $46.0
Total liabilities $580 Common shares 10.0
Common stock $420 EPS $6.6
Retained earnings $200 DPS $2.0
Total common equ. $620 Ending stock price $52.80
Total liab. & equity $1,200
Selected Ratios and Other Data, 2013
Hatfield Industry Hatfield Industry
Op. costs/Sales 90% 88% Total liability/Total assets 48.3% 36.7%
Depr./FA 10% 12% Times interest earned 3.8 8.9
Cash/Sales 1% 1% Return on assets (ROA) 5.5% 10.2%
Receivables/Sales 14% 11% Profit margin (M) 3.30% 4.99%
Inventories/Sales 20% 15% Sales/Assets 1.67 2.04
Fixed assets/Sales 25% 22% Assets/Equity 1.94 1.58
Acc. pay. & accr. / Sales 4% 4% Return on equity (ROE) 10.6% 16.1%
Tax rate 40% 40% P/E ratio 8.0 16.0
ROIC 8.0% 12.5%
NOPAT/Sales 4.5% 5.6%
Total op. capital/Sales 56.0% 45.0%
Additional Data 2014
Exp. Saled growth rate 10%
Interest rate on LT debt 8%
Target WACC 9%
e. Use the following assumptions to answer the questions below: (1) Operating ratios remain unchanged. (2) Sales will grow by 10%, 8%, 5%, and 5% for the next four years. (3) The target weighted average cost of capital (WACC) is 9%. This is the No Change scenario because operations remain unchanged.
e. (1) For each of the next four years, forecast the following items: sales, cash, accounts receivable, inventories, net fixed assets, accounts payable & accruals, operating costs (excluding depreciation), depreciation, and earnings before interest and taxes (EBIT).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Econometrics

Authors: Peijie Wang

1st Edition

0415426693, 978-0415426695

More Books

Students also viewed these Finance questions