USE Table Below , questions are all relevant to same problem so not too long.
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 |
Free Cash Flows | |||||
(All dollar values are provided in millions.) | |||||
2018 | 2017 | ||||
Sales, ST Invest, Notes Pay, LT Debt factor increase | 1.25 | Sales | $6,500 | ||
Operating costs as % of sales | 75.00% | Cash as % of sales | 1.00% | ||
Cash factor increase | 1.25 | Accts Rec as % of sales | 12.00% | ||
Accts. Rec factor increase | 1.20 | Inventory as % of sales | 15.00% | ||
Inventory factor increase | 1.20 | Net Plant & Equip as % of sales | 28.00% | ||
Net Plant & Equip factor increase | 1.15 | Accts Pay as % of sales | 6.00% | ||
Accts Pay factor increase | 1.25 | Accruals as % of Sales | 4.00% | ||
Accruals factor increase | 1.10 | ||||
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 | $8,125.0 | $6,500.0 | |||
Operating costs excluding depreciation | 6,093.8 | 5,525.0 | |||
Depreciation and amortization | 209.3 | 182.0 | |||
Earnings before interest and taxes | $1,822.0 | $793.0 | |||
Less interest | 174.7 | 139.8 | |||
Pre-tax income | $1,647.3 | $653.3 | |||
Taxes | 658.9 | 261.3 | |||
Net income available to common stockholders | $988.4 | $392.0 | |||
Common dividends | $889.5 | $313.6 | |||
Balance Sheets: | 2018 | 2017 | |||
Assets | |||||
Cash | $81.3 | $65.0 | |||
Short-term investments | 40.6 | 32.5 | |||
Accounts receivable | 936.0 | 780.0 | |||
Inventories | 1,170.0 | 975.0 | |||
Total current assets | $2,227.9 | $1,852.5 | |||
Net plant and equipment | 2,093.0 | 1,820.0 | |||
Total assets | $4,320.9 | $3,672.5 | |||
Liabilities and Equity | |||||
Accounts payable | $487.5 | $390.0 | |||
Accruals | 286.0 | 260.0 | |||
Notes payable | 162.5 | 130.0 | |||
Total current liabilities | $936.0 | $780.0 | |||
Long-term debt | 1,625.0 | 1,300.0 | |||
Total liabilities | $2,561.0 | $2,080.0 | |||
Common stock | 1,543.5 | 1,474.9 | |||
Retained earnings | 216.4 | 117.6 | |||
Total common equity | $1,759.9 | $1,592.5 | |||
Total liabilities and equity | $4,320.9 | $3,672.5 | |||
FORMULAS | |||||
NOPAT2018 | #N/A | ||||
NOWC2018 | #N/A | ||||
NOWC2017 | #N/A | ||||
Total net operating capital2018 | #N/A | ||||
Total net operating capital2017 | #N/A | ||||
Free cash flow2018 | #N/A | ||||
ROIC2018 | #N/A | ||||
Uses of free cash flow: | |||||
After-tax interest payment | #N/A | ||||
Reduction (increase) in debt | #N/A | ||||
Payment of dividends | #N/A | ||||
Repurchase (issue) stock | #N/A | ||||
Purchase (sale) of short-term investments | #N/A | ||||
Total | #N/A |
Part a
NOPAT (2018) = EBIT*(1- tax rate) = 1822*(1-40%) = $1093.2
Part b
2018 |
2017 |
|
Cash |
81.3 |
65.0 |
Accounts receivable |
936.0 |
780.0 |
Inventories |
1170.0 |
975.0 |
Operating current assets (a) |
2187.3 |
1820.0 |
Accounts payable |
487.5 |
390.0 |
Accruals |
286.0 |
260.0 |
Operating current liabilities (b) |
773.5 |
650.0 |
Net operating working capital (NOWC) (a-b) |
1413.8 |
1170.0 |
Part C
2018 |
2017 |
|
Net operating working capital (NOWC) |
1413.8 |
1170.0 |
Net plant and equipment |
2093.0 |
1820.0 |
Total net operating capital |
$3506.80 |
$2990.0 |
Part D
2018 |
|
NOPAT |
1093.2 |
- Investment in total Net Operating capita |
299 |
Free cash flow |
$794.2 |
Part E
After-tax interest payment (174.7*(1-40%)) |
104.82 |
Reduction (increase) in debt (162.5-130)+(1625-1300) |
(357.5) |
Payment of dividends |
889.5 |
Repurchase (Issue) stock (1543.5-1474.9) |
(68.6) |
Purchase (Sale) of short-term investments |
$225.98 |
Free cash flow |
$794.2 |
USE Table Below , questions are all relevant to same problem so not too long. What...
The data for Rhodes Corporation's has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. 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. What are the amounts of net operating working capital for...
I am sorry I put the wrong picture now should be okay. The data for Rhodes Corporation's has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. What is the net operating profit after taxes (NOPAT) for 2018? Enter your answer in millions. For example, an answer or $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your...
Please give me the correct answer, what is the free cash flow for 2018? 1 Free Cash Flows 2 (All dollar values are provided in millions 2018 4 Sales, ST Invest, Notes Pay, LT Debt factor increase 1.20 Operating costs as % of sales Cash factor increase 6 1.20 1.10 1.25 1.10 1.25 1.15 7 Accts. Rec factor increase Inventory factor increase 9 Net Plant & Equip factor increase 10 Accts Pay factor increase 11 Accruals factor increase 12 13...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) Sales Operating costs excluding depreciation Depreciation and amortization Earnings before interest and taxes Less Interest Pre-tax income Taxes (40%) Net income available to common stockholders Common dividends 2018 $11,050.0 8,564.0 275.0 $2,211.0 238.0 $1,973.0 789.2 $1,183.8 $1,065.0 2017 $8,500.0 7,225.0 230.0 $1,045.0 183.0 $862.0 344.8 $517.2 $414.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 2017 $112.0 56.0 1,169.0 2,656.0 $3,993.0 2,754.0 $6,747.0 $102.0...
Problem 2-12 Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $7,800.0 $6,500.0 Operating costs excluding depreciation 6,630.0 5,525.0 Depreciation and amortization 226.0 189.0 Earnings before interest and taxes $944.0 $786.0 Less Interest 168.0 140.0 Pre-tax income $776.0 $646.0 Taxes (40%) 310.4 258.4 Net income available to common stockholders $465.6 $387.6 Common dividends $419.0 $310.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $118.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $9,775.0 $8,500.0 Operating costs excluding depreciation 8,309.0 7,225.0 Depreciation and amortization 287.0 221.0 Earnings before interest and taxes $1,179.0 $1,054.0 Less Interest 210.0 183.0 Pre-tax income $969.0 $871.0 Taxes (40%) 387.6 348.4 Net income available to common stockholders $581.4 $522.6 Common dividends $523.0 $418.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $122.0 $102.0 Short-term investments 49.0 43.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $2,875.0 $2,500.0 Operating costs excluding depreciation 2,156.0 2,125.0 Depreciation and amortization 81.0 68.0 Earnings before interest and taxes $638.0 $307.0 Less Interest 62.0 54.0 Pre-tax income $576.0 $253.0 Taxes (40%) 230.4 101.2 Net income available to common stockholders $345.6 $151.8 Common dividends $311.0 $121.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $42.0 $35.0 Short-term investments 15.0 13.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 22.0 2016 2015 Sales $1,100.0 $1,000.0 Operating costs excluding depreciation 908.0 850.0 Depreciation and amortization 25.0 21.0 Earnings before interest and taxes $167.0 $129.0 Less Interest 24.0 Pre-tax income $143.0 $107.0 Taxes (40%) 57.2 42.8 Net income available to common stockholders $85.8 $64.2 Common dividends $51.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 $77.0 $14.0 6.0 195.0 231.0 $446.0 252.0 $698.0 $11.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $1,100.0 $1,000.0 Operating costs excluding depreciation 908.0 850.0 Depreciation and amortization 25.0 21.0 Earnings before interest and taxes $167.0 $129.0 Less Interest 24.0 Pre-tax income $143.0 $107.0 Taxes (40%) 57.2 42.8 Net income available to common stockholders $85.8 $64.2 Common dividends $77.0 $51.0 22.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $14.0 $11.0 Short-term investments 6.0 5.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $6,325.0 $5,500.0 Operating costs excluding depreciation 5,376.0 4,675.0 Depreciation and amortization 207.0 160.0 Earnings before interest and taxes $742.0 $665.0 Less: Interest 136.0 118.0 Pre-tax income $606.0 $547.0 Taxes (40%) 242.4 218.8 Net income available to common stockholders $363.6 $328.2 Common dividends $327.0 $263.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $76.0 $61.0 Short-term investments 32.0 28.0...