Question

In: Finance

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
Accounts receivable 1,350.0 1,125.0
Inventories 2,145.0 1,650.0
    Total current assets $3,649.0 $2,911.0
Net plant and equipment 1,725.0 1,500.0
Total assets $5,374.0 $4,411.0
Liabilities and Equity
Accounts payable $878.0 $675.0
Accruals 293.0 225.0
Notes payable 180.0 150.0
    Total current liabilities $1,351.0 $1,050.0
Long-term debt 1,800.0 1,500.0
    Total liabilities $3,151.0 $2,550.0
Common stock 1,963.6 1,715.0
Retained earnings 259.4 146.0
    Total common equity $2,223.0 $1,861.0
Total liabilities and equity $5,374.0 $4,411.0

1.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.

2.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.

3.Reduction (increase) in debt

Solutions

Expert Solution

1). FCF = NOPAT - Net investment in operating capital

NOPAT = EBIT*(1-Tax rate) = 2,077*(1-40%) = 1,246.2

Net investment in operating capital = Total operating capital in 2016 - Total operating capital in 2015

Total operating capital (TOC) = Net operating working capital (NOWC) + net fixed assets (NFA)

NOWC calculations:

2016 2015
Cash                 108.0                     98.0
A/C receivable              1,350.0               1,125.0
Inventory              2,145.0               1,650.0
Operating assets              3,603.0               2,873.0
A/C payable                 878.0                   675.0
Accruals                 293.0                   225.0
Operating liabilities              1,171.0                   900.0
NOWC              2,432.0               1,973.0

2016 TOC = 2,432 + 1,725 = 4,157

2015 TOC = 1,973 + 1,500 = 3,473

Net investment in operating capital = 4,157 - 3,473 = 684

FCF in 2016 = 1,246.2 - 684 = 562.2

2). 2016 ROIC = NOPAT/TOC = 1,246.2/4,157 = 29.98%

3).

Interest payment*(1-Tax rate) After-tax interest payment                 115.8
(LT debt + notes payable) in 2015 - (LT debt + notes payable) in 2016 Reduction (increase) in debt               (330.0)
2016 payment of dividends Payment of dividends              1,017.0
2015 common stock - 2016 common stock Repurchase (issue) stock               (248.6)
2016 S-T investments - 2015 S-T investments Purchase (sale) of short-term investments                      8.0
Sum of all line items above FCF                 562.2

As a cross-check, this FCF matches with the FCF calculated in part (1).


Related Solutions

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...
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 $7,700.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $7,700.0 $7,000.0 Operating costs excluding depreciation 6,160.0 5,950.0 Depreciation and amortization 177.0 154.0     Earnings before interest and taxes $1,363.0 $896.0 Less Interest 166.0 151.0     Pre-tax income $1,197.0 $745.0 Taxes (40%) 478.8 298.0 Net income available to common stockholders $718.2 $447.0 Common dividends $646.0 $358.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $89.0 $77.0 Short-term investments 39.0 35.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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT