Question

In: Finance

Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $2,875.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,228.0 2,125.0
Depreciation and amortization 65.0 50.0
    Earnings before interest and taxes $582.0 $325.0
Less Interest 62.0 54.0
    Pre-tax income $520.0 $271.0
Taxes (40%) 208.0 108.4
Net income available to common stockholders $312.0 $162.6
Common dividends $281.0 $130.0

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

2016 2015
Assets
Cash $44.0 $38.0
Short-term investments 15.0 13.0
Accounts receivable 390.0 300.0
Inventories 690.0 600.0
    Total current assets $1,139.0 $951.0
Net plant and equipment 650.0 500.0
Total assets $1,789.0 $1,451.0
Liabilities and Equity
Accounts payable $228.0 $175.0
Accruals 173.0 150.0
Notes payable 58.0 50.0
    Total current liabilities $459.0 $375.0
Long-term debt 575.0 500.0
    Total liabilities $1,034.0 $875.0
Common stock 675.0 527.0
Retained earnings 80.0 49.0
    Total common equity $755.0 $576.0
Total liabilities and equity $1,789.0 $1,451.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

Solution 1:

NOPAT = EBIT (1 - tax rate)

NOPAT = $582 (1 - 0.40)

NOPAT = $349.2

Hence, the NOPAT for 2016 is $349.2

Solution 2:

2015

First, we compute operating current assets

Operating current assets = Cash + Accounts Receivable + Inventories

Operating current assets = $38 + $300 + $600

Operating current assets = $938

Now, compute operating current liabilities

Operating current liabilities = Accounts payable + Accruals

Operating current liabilities = $175 + $150

Operating current liabilities = $325

Therefore, net operating working capital for 2015 is

Net operating working capital = Operating current assets - Operating current liabilities

Net operating working capital = $938 - $325

Net operating working capital = $613

2016

First, we compute operating current assets

Operating current assets = Cash + Accounts Receivable + Inventories

Operating current assets = $44 + $390 + $690

Operating current assets = $1124

Now, compute operating current liabilities

Operating current liabilities = Accounts payable + Accruals

Operating current liabilities = $228 + $173

Operating current liabilities = $401

Therefore, net operating working capital for 2015 is

Net operating working capital = Operating current assets - Operating current liabilities

Net operating working capital = $1124 - $401

Net operating working capital = $723

Solution 3:

2015

Total net operating capital = NOWC + operating long term assets

Total net operating capital = $613 + $500

Total net operating capital = $1113

2016

Total net operating capital = NOWC + operating long term assets

Total net operating capital = $723 + $650

Total net operating capital = $1373

Solution 4:

2016

Free cash flow = NOPAT - Net Investment in Operating capital

Free cash flow = $349.2 - ($1373 - $1113)

Free cash flow = $89.2


Related Solutions

Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $9,000.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $9,000.0 $7,500.0 Operating costs excluding depreciation 7,200.0 6,375.0 Depreciation and amortization 233.0 203.0     Earnings before interest and taxes $1,567.0 $922.0 Less Interest 193.0 161.0     Pre-tax income $1,374.0 $761.0 Taxes (40%) 549.6 304.4 Net income available to common stockholders $824.4 $456.6 Common dividends $742.0 $365.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $123.0 $98.0 Short-term investments 46.0 38.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $10,800.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $10,800.0 $9,000.0 Operating costs excluding depreciation 8,910.0 7,650.0 Depreciation and amortization 293.0 234.0     Earnings before interest and taxes $1,597.0 $1,116.0 Less Interest 232.0 194.0     Pre-tax income $1,365.0 $922.0 Taxes (40%) 546.0 368.8 Net income available to common stockholders $819.0 $553.2 Common dividends $737.0 $443.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $119.0 $108.0 Short-term investments 54.0 45.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $9,000.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $9,000.0 $7,500.0 Operating costs excluding depreciation 6,750.0 6,375.0 Depreciation and amortization 173.0 150.0     Earnings before interest and taxes $2,077.0 $975.0 Less Interest 193.0 161.0     Pre-tax income $1,884.0 $814.0 Taxes (40%) 753.6 325.6 Net income available to common stockholders $1,130.4 $488.4 Common dividends $1,017.0 $391.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $108.0 $98.0 Short-term investments 46.0 38.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $9,000.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $9,000.0 $7,500.0 Operating costs excluding depreciation 6,750.0 6,375.0 Depreciation and amortization 173.0 150.0     Earnings before interest and taxes $2,077.0 $975.0 Less Interest 193.0 161.0     Pre-tax income $1,884.0 $814.0 Taxes (40%) 753.6 325.6 Net income available to common stockholders $1,130.4 $488.4 Common dividends $1,017.0 $391.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $108.0 $98.0 Short-term investments 46.0 38.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2015 2014 Sales $10,200.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2015 2014 Sales $10,200.0 $8,500.0 Operating costs excluding depreciation 7,905.0 7,225.0 Depreciation and amortization 253.0 230.0 Earnings before interest and taxes $2,042.0 $1,045.0   Less: Interest 219.0 183.0 Pre-tax income $1,823.0 $862.0   Taxes (40%) 729.2 344.8 Net income available to common stockholders $1,093.8 $517.2 Common dividends $984.0 $414.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2015 2014 Assets Cash $154.0 $128.0 Short-term investments 52.0 43.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2015 2014 Sales $10,400.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2015 2014 Sales $10,400.0 $8,000.0 Operating costs excluding depreciation 7,800.0 6,800.0 Depreciation and amortization 230.0 200.0 Earnings before interest and taxes $2,370.0 $1,000.0 Less: Interest 224.0 172.0 Pre-tax income $2,146.0 $828.0 Taxes (40%) 858.4 331.2 Net income available to common stockholders $1,287.6 $496.8 Common dividends $1,159.0 $397.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2015 2014 Assets Cash $132.0 $120.0 Short-term investments 52.0 40.0...
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...
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...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $8,400.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $8,400.0 $7,000.0 Operating costs excluding depreciation 6,510.0 5,950.0 Depreciation and amortization 228.0 182.0     Earnings before interest and taxes $1,662.0 $868.0 Less Interest 181.0 151.0     Pre-tax income $1,481.0 $717.0 Taxes (40%) 592.4 286.8 Net income available to common stockholders $888.6 $430.2 Common dividends $800.0 $344.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 2017 Assets Cash $101.0 $84.0 Short-term investments 42.0 35.0...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT