Question

In: Finance

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
Accounts receivable 1,530.0 1,275.0
Inventories 1,870.0 1,700.0
Total current assets $3,606.0 $3,146.0
Net plant and equipment 2,525.0 2,295.0
Total assets $6,131.0 $5,441.0
Liabilities and Equity
Accounts payable $748.0 $680.0
Accruals 880.0 765.0
Notes payable 204.0 170.0
Total current liabilities $1,832.0 $1,615.0
Long-term bonds 2,040.0 1,700.0
Total liabilities $3,872.0 $3,315.0
Common stock 1,994.2 1,971.0
Retained earnings 264.8 155.0
Total common equity $2,259.0 $2,126.0
Total liabilities and equity $6,131.0 $5,441.0

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

What is the net operating profit after taxes (NOPAT) for 2015? 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.
2015 $ .... million
2014 $ .... 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.
2015 $ ..... million
2014 $ ..... million

What is the free cash flow for 2015? 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 2015? 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

Net operating proft after taxes = Earnings before interest and tax*(1-tax rate)

=2042*(1-0.40) = $1225.20 million

2014 2015
Operating Current assets 128+1275+1870 3273 154+1530+1870 3554
Operating Current Liabilities 680+765 1445 748+880 1628
Net Operating working capital 1828 1926
Net operating capital = Net operating working capital + Net fixed assets
2014 2015
Net Operating working capital 1828 1926
Net Fixed Assets 2295 2525
Net operating capital 4123 4451
Free cash flow = Net operating profit after taxes - Net investment in operating capital
2015
Net Investment in operating capital = Operating capital 2015 - Operating capital 2014
4451-4123
328
$328 million
1225.20-328
897.2
$897.20 million
ROIC = Net operating profit after taxes/Total net operating capital
1225.20/4451 27.53%
2015
After-tax interest payment 131.4 219*(1-0.40)
Reduction (increase) in debt 340 2040-1700
Payment of dividends 984
Repurchase (Issue) stock 133 2259-2126
Purchase (Sale) of short-term investments 9 52-43

Related Solutions

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) 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 $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)
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...
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...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $3,250.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $3,250.0 $2,500.0 Operating costs excluding depreciation 2,438.0 2,125.0 Depreciation and amortization 60.0 53.0     Earnings before interest and taxes $752.0 $322.0 Less Interest 70.0 54.0     Pre-tax income $682.0 $268.0 Taxes (40%) 272.8 107.2 Net income available to common stockholders $409.2 $160.8 Common dividends $368.0 $129.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 2017 Assets Cash $42.0 $38.0 Short-term investments 17.0 13.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $1,725.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $1,725.0 $1,500.0 Operating costs excluding depreciation 1,294.0 1,275.0 Depreciation and amortization 41.0 33.0 Earnings before interest and taxes $390.0 $192.0 Less Interest 37.0 32.0 Pre-tax income $353.0 $160.0 Taxes (40%) 141.2 64.0 Net income available to common stockholders $211.8 $96.0 Common dividends $191.0 $77.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 2017 Assets Cash $24.0 $21.0 Short-term investments 9.0 8.0...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT