Question

In: Accounting

Problem 2-12 Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of...

Problem 2-12
Free Cash Flows

Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)

2016 2015
Sales $7,150.0 $6,500.0
Operating costs excluding depreciation 5,363.0 5,525.0
Depreciation and amortization 187.0 156.0
Earnings before interest and taxes $1,600.0 $819.0
  Less: Interest 154.0 140.0
Pre-tax income $1,446.0 $679.0
  Taxes (40%) 578.4 271.6
Net income available to common stockholders $867.6 $407.4
Common dividends $781.0 $326.0

Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars)

2016 2015
Assets
Cash $118.0 $98.0
Short-term investments 36.0 33.0
Accounts receivable 822.0 715.0
Inventories 1,144.0 1,040.0
Total current assets $2,120.0 $1,886.0
Net plant and equipment 1,872.0 1,560.0
Total assets $3,992.0 $3,446.0
Liabilities and Equity
Accounts payable $598.0 $520.0
Accruals 423.0 325.0
Notes payable 143.0 130.0
Total current liabilities $1,164.0 $975.0
Long-term bonds 1,430.0 1,300.0
Total liabilities $2,594.0 $2,275.0
Common stock 1,189.4 1,049.0
Retained earnings 208.6 122.0
Total common equity $1,398.0 $1,171.0
Total liabilities and equity $3,992.0 $3,446.0

Using Rhodes Corporation's financial statements (shown above), answer the following questions.

What is the net operating profit after taxes (NOPAT) for 2016? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to one decimal place.
$    million

What are the amounts of net operating working capital for both years? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answers to one decimal place.
2016 $    million
2015 $    million

What are the amounts of total net operating capital for both years? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answers to one decimal place.
2016 $    million
2015 $    million

What is the free cash flow for 2016? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to one decimal place.
$    million

What is the ROIC for 2016? Round your answer to two 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 answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. 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

Solutions

Expert Solution

1) NOPAT
EBIT $1,600 Millions
Less: Tax Rate 40% -$640 Millions
Net operating profit after taxes (NOPAT) $960 Millions
2)
Net Operating Working Capital = Operating Current Assets - Operating Current Liabilities 2016 2015
Operating Current Assets Millions Millions
Cash $118 $98
Accounts receivable 822 715
Inventories 1144 1040
Total Operating current assets $2,084 $1,853
Less: Operating Current Liabilities
Accounts payable $598 $520
Accruals $423 $325
Total Operating current liabilities $1,021 $845
NOWC = OCA - OCL $1,063 $1,008 Millions
3) 2016 2015
Total net operating capital Millions Millions
Net Operating Working Capital $1,063 $1,008
Add: Net plant and equipments $1,872 $1,560
Total net operating capital $2,935 $2,568 milions
4)
Free cash flow for 2016
NOPAT $960 millions
Less: Investment in total net operating Capital($2935 -$2568)millions -$367 millions
Free cash flow for 2016 $593 millions
5)
ROIC for 2016
Return on invested capital (ROIC) = NPOAT/Total net operating capital = $960/$2935 32.71%
6)
After-tax interest payment = ($154 x (1-40%) 92.4 millions
Reduction (increase) in debt = ($130 + $1,300) – ($143 + $1,430) -143 millions
Payment of dividends $781.00 millions
Repurchase (Issue) stock ($1189.4 - 1049) -140.4 millions
Purchase (Sale) of short-term investments 3 millions

Related Solutions

Problem 2-12 Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of...
Problem 2-12 Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $6,500.0 $5,000.0 Operating costs excluding depreciation 5,363.0 4,250.0 Depreciation and amortization 150.0 120.0     Earnings before interest and taxes $987.0 $630.0 Less Interest 140.0 108.0     Pre-tax income $847.0 $522.0 Taxes (40%) 338.8 208.8 Net income available to common stockholders $508.2 $313.2 Common dividends $457.0 $251.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $77.0...
Problem 2-12 Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of...
Problem 2-12 Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $4,025.0 $3,500.0 Operating costs excluding depreciation 3,220.0 2,975.0 Depreciation and amortization 96.0 77.0     Earnings before interest and taxes $709.0 $448.0 Less Interest 87.0 75.0     Pre-tax income $622.0 $373.0 Taxes (40%) 248.8 149.2 Net income available to common stockholders $373.2 $223.8 Common dividends $336.0 $179.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $51.0...
Problem 2-12 Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of...
Problem 2-12 Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $4,025.0 $3,500.0 Operating costs excluding depreciation 3,220.0 2,975.0 Depreciation and amortization 96.0 77.0     Earnings before interest and taxes $709.0 $448.0 Less Interest 87.0 75.0     Pre-tax income $622.0 $373.0 Taxes (40%) 248.8 149.2 Net income available to common stockholders $373.2 $223.8 Common dividends $336.0 $179.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $51.0...
Problem 2-12 Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of...
Problem 2-12 Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $5,625.0 $4,500.0 Operating costs excluding depreciation 4,781.0 3,825.0 Depreciation and amortization 135.0 117.0     Earnings before interest and taxes $709.0 $558.0 Less Interest 121.0 97.0     Pre-tax income $588.0 $461.0 Taxes (40%) 235.2 184.4 Net income available to common stockholders $352.8 $276.6 Common dividends $318.0 $221.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $70.0...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $3,300.0 $3,000.0 Operating costs excluding depreciation 2,558.0 2,550.0 Depreciation and amortization 73.0 63.0     Earnings before interest and taxes $669.0 $387.0 Less Interest 71.0 65.0     Pre-tax income $598.0 $322.0 Taxes (40%) 239.2 128.8 Net income available to common stockholders $358.8 $193.2 Common dividends $323.0 $155.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 2017 Assets Cash $49.0 $39.0 Short-term...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $10,400.0 $8,000.0 Operating costs excluding depreciation 8,320.0 6,800.0 Depreciation and amortization 264.0 240.0 Earnings before interest and taxes $1,816.0 $960.0   Less: Interest 224.0 172.0 Pre-tax income $1,592.0 $788.0   Taxes (40%) 636.8 315.2 Net income available to common stockholders $955.2 $472.8 Common dividends $860.0 $378.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $140.0 $112.0 Short-term...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016...
Free Cash Flows 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,218.0 4,675.0 Depreciation and amortization 176.0 160.0     Earnings before interest and taxes $931.0 $665.0 Less Interest 136.0 118.0     Pre-tax income $795.0 $547.0 Taxes (40%) 318.0 218.8 Net income available to common stockholders $477.0 $328.2 Common dividends $429.0 $263.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $79.0 $61.0 Short-term...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $3,750.0 $3,000.0 Operating costs excluding depreciation 2,813.0 2,550.0 Depreciation and amortization 94.0 78.0     Earnings before interest and taxes $843.0 $372.0 Less Interest 81.0 65.0     Pre-tax income $762.0 $307.0 Taxes (40%) 304.8 122.8 Net income available to common stockholders $457.2 $184.2 Common dividends $411.0 $147.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 2017 Assets Cash $38.0 $33.0 Short-term...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $6,900.0 $6,000.0 Operating costs excluding depreciation 5,175.0 5,100.0 Depreciation and amortization 151.0 126.0     Earnings before interest and taxes $1,574.0 $774.0 Less Interest 148.0 129.0     Pre-tax income $1,426.0 $645.0 Taxes (40%) 570.4 258.0 Net income available to common stockholders $855.6 $387.0 Common dividends $770.0 $310.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $72.0 $60.0 Short-term...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)   2018   2017 Sales $7,800.0   $6,000.0 Operating costs excluding depreciation 5,850.0   5,100.0 Depreciation and amortization 216.0   180.0     Earnings before interest and taxes $1,734.0   $720.0 Less Interest 168.0   129.0     Pre-tax income $1,566.0   $591.0 Taxes (40%) 626.4   236.4 Net income available to common stockholders $939.6   $354.6 Common dividends $846.0   $284.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars)   2018   2017 Assets Cash $90.0   $72.0 Short-term investments 39.0   30.0...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT