Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Free Cash Flows ( All dollar values are provided in millions. ) 2 0 1 8 2 0 1 7 Sales, ST Invest, Notes Pay,

Free Cash Flows
(All dollar values are provided in millions.)
20182017
Sales, ST Invest, Notes Pay, LT Debt factor increase 1.1 Sales $1,500
Operating costs as % of sales 77.50% Cash as % of sales 1.00%
Cash factor increase 1.2 Accts Rec as % of sales 11.00%
Accts. Rec factor increase 1.1 Inventory as % of sales 16.00%
Inventory factor increase 1.15 Net Plant & Equip as % of sales 22.00%
Net Plant & Equip factor increase 1.1 Accts Pay as % of sales 9.00%
Accts Pay factor increase 1.25 Accruals as % of Sales 3.00%
Accruals factor increase 1.15
Operating cost as % of sales 85.00%
Depreciation as % of Net Plant & Equip 10.00% Depreciation as % of Net Plant & Equip 10.00%
Interest rate 10.00% Interest rate 10.00%
Tax rate 40.00% Tax rate 40.00%
Payout rate 90.00% Payout rate 80.00%
Short-term investments as % of sales 0.50%
Notes payable as % of sales 2.00%
Long-term debt as % of sales 20.00%
Retained earnings multiple factor 1.5
Income Statements: 20182017
Sales $1,650.00 $1,500.00
Operating costs excluding depreciation 1,278.801,275.00
Depreciation and amortization 36.333
Earnings before interest and taxes $335.00 $192.00
Less interest 35.532.3
Pre-tax income $299.50 $159.80
Taxes 119.863.9
Net income available to common stockholders $179.70 $95.90
Common dividends $161.70 $76.70
Balance Sheets: 20182017
Assets
Cash $18.00 $15.00
Short-term investments 8.37.5
Accounts receivable 181.5165
Inventories 276240
Total current assets $483.80 $427.50
Net plant and equipment 363330
Total assets $846.80 $757.50
Liabilities and Equity
Accounts payable $168.80 $135.00
Accruals 51.845
Notes payable 3330
Total current liabilities $253.50 $210.00
Long-term debt 330300
Total liabilities $583.50 $510.00
Common stock 216.5218.7
Retained earnings 46.728.8
Total common equity $263.30 $247.50
Total liabilities and equity $846.80 $757.50
FORMULAS
NOPAT2018 $201.00201
NOWC2018 $255.00 $254.90
NOWC2017 $330.00 $330.00
Total net operating capital2018 $618.00 $618.00
Total net operating capital2017 $660.00 $660.00
Free cash flow2018 $243.00 $243.00
ROIC201832.50%0.325242718
Uses of free cash flow: Amount Formula
After-tax interest payment
Reduction (increase) in debt
Payment of dividends
Repurchase (issue) stock
Purchase (sale) of short-term investments
Total

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

Mergers Acquisitions And Other Restructuring Activities

Authors: Donald DePamphilis

10th Edition

0128150750, 978-0128150757

More Books

Students also viewed these Finance questions

Question

Define object properties and methods.

Answered: 1 week ago

Question

9.8 Describe leadership development and its impact

Answered: 1 week ago

Question

9.6 Explain what management development is and why it is important.

Answered: 1 week ago