Question

In: Finance

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 $54.0
Short-term investments 29.0 23.0
Accounts receivable 569.0 495.0
Inventories 1,139.0 990.0
    Total current assets $1,807.0 $1,562.0
Net plant and equipment 1,346.0 1,170.0
Total assets $3,153.0 $2,732.0
Liabilities and Equity
Accounts payable $338.0 $270.0
Accruals 347.0 315.0
Notes payable 113.0 90.0
    Total current liabilities $798.0 $675.0
Long-term debt 1,125.0 900.0
    Total liabilities $1,923.0 $1,575.0
Common stock 1,112.2 1,074.0
Retained earnings 117.8 83.0
    Total common equity $1,230.0 $1,157.0
Total liabilities and equity $3,153.0 $2,732.0

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

  1. 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
  2. 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
  3. 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
  4. 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
  5. What is the ROIC for 2016? Round your answer to two decimal places.
    %
  6. 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

a.  net operating profit after taxes (NOPAT) = operating income or earnings before interest & taxes(EBIT)*(1 - tax rate)

NOPAT for 2016 = $709*(1 - 0.40) = $709*0.60 = $425.4 million

NOPAT for 2016 is $425.4 million.

b. net operating working capital = current operating assets - current operating liabilities

Current operating assets = Cash+accounts receivable+inventories

Current operating liabilities = accounts payable+accrual+notes payable

  net operating working capital for 2015 = ($54+$495+$990) - ($270+$315+$90) = $1,539 - $675 = $864 million

  net operating working capital for 2016 = ($70+$569+$1139) - ($338+$347+$113) = $1,778 - $798 = $980 million

c. total net operating capital = net operating working capital + net plant and equipment

net operating working capital have been calculated in part b.

  total net operating capital for 2015 = $864 + $1,170 = $2,034 million

total net operating capital for 2016 = $980 + $1,346 = $2,326 million

d. free cash flow = net income + non-cash expenses - increase in working capital - capital expenditures

We have Depreciation and amortization as non-cash expenses in this question.

increase in working capital = (accounts receivable 2016 - accounts receivable 2015) + (inventory 2016 - inventory 2015) - (accounts payable 2016 - accounts payable 2015)

increase in working capital = ($569 - $495) + ($1,139 - $990) - ($338 - $270) = $74+$149-$68 = $155

Capital expenditures = (net plant and equipment 2016 - net plant and equipment 2015 + Depreciation and amortization 2016)

= ($1,346 - $1,170 + 135) = $311

Free cash flow for 2016 = $352.8 + $135 - $155 - $311 = $21.8 million


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 $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...
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,325.0 $5,500.0 Operating costs excluding depreciation 4,744.0 4,675.0 Depreciation and amortization 191.0 160.0     Earnings before interest and taxes $1,390.0 $665.0 Less Interest 136.0 118.0     Pre-tax income $1,254.0 $547.0 Taxes (40%) 501.6 218.8 Net income available to common stockholders $752.4 $328.2 Common dividends $677.0 $263.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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT