In: Finance
2018 | 2017 | ||||
Sales, ST Invest, Notes Pay, LT Debt factor increase | 1.10 | Sales | $7,000 | ||
Operating costs as % of sales | 77.50% | Cash as % of sales | 1.20% | ||
Cash factor increase | 1.15 | Accts Rec as % of sales | 11.00% | ||
Accts. Rec factor increase | 1.25 | Inventory as % of sales | 21.00% | ||
Inventory factor increase | 1.15 | Net Plant & Equip as % of sales | 28.00% | ||
Net Plant & Equip factor increase | 1.25 | Accts Pay as % of sales | 6.00% | ||
Accts Pay factor increase | 1.20 | Accruals as % of Sales | 6.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.50 | ||||
Income Statements: | 2018 | 2017 | |||
Sales | $7,700.0 | $7,000.0 | |||
Operating costs excluding depreciation | 5,967.5 | 5,950.0 | |||
Depreciation and amortization | 245.0 | 196.0 | |||
Earnings before interest and taxes | $1,487.5 | $854.0 | |||
Less interest | 165.6 | 150.5 | |||
Pre-tax income | $1,322.0 | $703.5 | |||
Taxes | 528.8 | 281.4 | |||
Net income available to common stockholders | $793.2 | $422.1 | |||
Common dividends | $713.9 | $337.7 | |||
Balance Sheets: | 2018 | 2017 | |||
Assets | |||||
Cash | $96.6 | $84.0 | |||
Short-term investments | 38.5 | 35.0 | |||
Accounts receivable | 962.5 | 770.0 | |||
Inventories | 1,690.5 | 1,470.0 | |||
Total current assets | $2,788.1 | $2,359.0 | |||
Net plant and equipment | 2,450.0 | 1,960.0 | |||
Total assets | $5,238.1 | $4,319.0 | |||
Liabilities and Equity | |||||
Accounts payable | $504.0 | $420.0 | |||
Accruals | 483.0 | 420.0 | |||
Notes payable | 154.0 | 140.0 | |||
Total current liabilities | $1,141.0 | $980.0 | |||
Long-term debt | 1,540.0 | 1,400.0 | |||
Total liabilities | $2,681.0 | $2,380.0 | |||
Common stock | 2,351.2 | 1,812.4 | |||
Retained earnings | 205.9 | 126.6 | |||
Total common equity | $2,557.1 | $1,939.0 | |||
Total liabilities and equity | $5,238.1 | $4,319.0 |
What is the net operating profit after taxes (NOPAT) for 2018? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answer to one decimal place.
$ million
What are the amounts of net operating working capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answers to one decimal place.
2018 $ million
2017 $ million
What are the amounts of total net operating capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answers to one decimal place.
2018 $ million
2017 $ million
What is the free cash flow for 2018? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answer to one decimal place.
$ million
What is the ROIC for 2018? Round your answer to one decimal places.
%
How much of the FCF did Rhodes use for each of the following purposes: after-tax interest, net debt repayments, dividends, net stock repurchases, and net purchases of short-term investments? (Hint: Remember that a net use can be negative.) Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answers to one decimal place.
After-tax interest payment | $ million |
Reduction (increase) in debt | $ million |
Payment of dividends | $ million |
Repurchase (Issue) stock | $ million |
Purchase (Sale) of short-term investments | $ million |
a) NOPAT Formula = EBIT (1-Tax)
2017 |
2018 |
|
EBIT |
854 |
1,488 |
Tax Rate |
40% |
40% |
NOPAT |
512.4 |
893 |
b&c) We are not including short term investments and notes payable in the current operating assets and liabilities, respectively. Short term investments and notes payable are not the part of operating activities.
Assets |
2018 |
2017 |
Cash |
96.6 |
84.0 |
Accounts receivable |
962.5 |
770.0 |
Inventories |
1690.5 |
1470.0 |
Total operating current assets |
2749.6 |
2324.0 |
Liabilities and Equity |
||
Accounts payable |
504.0 |
420.0 |
Accruals |
483.0 |
420.0 |
Total current operating liabilities |
987.0 |
840.0 |
Net operating working capital |
1762.6 |
1484.0 |
Net plant and equipment |
2450.0 |
1960.0 |
Net Operating Capital |
4212.6 |
3444.0 |
d) FCFF Formula = NOPAT+D&A-CAPEX-Change in WC
Capex= 2,450-1960+245=735
Change in NWC= (2,788.1-1,141)-(2,359-980)=268.1
2018 |
|
NOPAT |
630.0 |
D&A |
245.0 |
Less: Capex |
735.0 |
Less: Change in NWC |
268.1 |