Question

In: Finance

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
Accounts receivable 1,274.0 980.0
Inventories 1,771.0 1,540.0
    Total current assets $3,188.0 $2,639.0
Net plant and equipment 2,275.0 1,820.0
Total assets $5,463.0 $4,459.0
Liabilities and Equity
Accounts payable $788.0 $630.0
Accruals 385.0 350.0
Notes payable 168.0 140.0
    Total current liabilities $1,341.0 $1,120.0
Long-term debt 1,680.0 1,400.0
    Total liabilities $3,021.0 $2,520.0
Common stock 2,224.4 1,810.0
Retained earnings 217.6 129.0
    Total common equity $2,442.0 $1,939.0
Total liabilities and equity $5,463.0 $4,459.0

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

  1. What is the net operating profit after taxes (NOPAT) for 2018? 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 answers in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answers to the nearest whole number.
    2018: $   million
    2017: $   million
  3. What are the amounts of total net operating capital for both years? Enter your answers in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answers to the nearest whole number.
    2018: $   million
    2017: $   million
  4. What is the free cash flow for 2018? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Cash outflow, if any, should be indicated by a minus sign. Round your answer to one decimal place.
    $    million
  5. What is the ROIC for 2018? 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

INCOME STATEMENTS
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
BALANCE SHEETS
Assets
Cash $            101.0 $              84.0
Short-term investments $              42.0 $              35.0
Accounts receivable $         1,274.0 $           980.0
Inventories $         1,771.0 $        1,540.0
    Total current assets $         3,188.0 $        2,639.0
Net plant and equipment $         2,275.0 $        1,820.0
Total assets $         5,463.0 $        4,459.0
Liabilities and Equity
Accounts payable $            788.0 $           630.0
Accruals $            385.0 $           350.0
Notes payable $            168.0 $           140.0
    Total current liabilities $         1,341.0 $        1,120.0
Long-term debt $         1,680.0 $        1,400.0
    Total liabilities $         3,021.0 $        2,520.0
Common stock $         2,224.4 $        1,810.0
Retained earnings $            217.6 $           129.0
    Total common equity $         2,442.0 $        1,939.0
Total liabilities and equity $         5,463.0 $        4,459.0
a] NOPAT = EBIT*(1-t) = 1662*(1-40%) = $                     997.2
b] NOWC = (Cash+AR+Inventories)-(AP+Accruals) $                 1,973.0 $                1,624.0
c] TNOC = Net fixed assets+NOWC = $                 4,248.0 $                3,444.0
d] FCF = NOPAT-Change in TNOC = 997.2-(4248.0-3444.0) = $                     193.2
e] USE OF FCF OF 2018:
After-tax interest payment [181*60%) $            108.6
Reduction (increase) in debt [(168+1680)-(140+1400)] = $           (308.0)
Payment of dividends $            800.0
Repurchase (Issue) stock (2224.4-1810.0) $           (414.4)
Purchase (Sale) of short-term investments (42-35) $                 7.0
Total $                     193.2

Related Solutions

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...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $2,200.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $2,200.0 $2,000.0 Operating costs excluding depreciation 1,870.0 1,700.0 Depreciation and amortization 55.0 50.0     Earnings before interest and taxes $275.0 $250.0 Less Interest 47.0 43.0     Pre-tax income $228.0 $207.0 Taxes (40%) 91.2 82.8 Net income available to common stockholders $136.8 $124.2 Common dividends $123.0 $99.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 2017 Assets Cash $30.0 $26.0 Short-term investments 11.0 10.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) 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) 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) 2018...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $9,200.0 $8,000.0 Operating costs excluding depreciation 6,900.0 6,800.0 Depreciation and amortization 246.0 224.0     Earnings before interest and taxes $2,054.0 $976.0 Less Interest 198.0 172.0     Pre-tax income $1,856.0 $804.0 Taxes (40%) 742.4 321.6 Net income available to common stockholders $1,113.6 $482.4 Common dividends $1,002.0 $386.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 2017 Assets Cash $146.0 $112.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 $9,200.0 $8,000.0 Operating costs excluding depreciation 6,900.0 6,800.0 Depreciation and amortization 246.0 224.0     Earnings before interest and taxes $2,054.0 $976.0 Less Interest 198.0 172.0     Pre-tax income $1,856.0 $804.0 Taxes (40%) 742.4 321.6 Net income available to common stockholders $1,113.6 $482.4 Common dividends $1,002.0 $386.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 2017 Assets Cash $146.0 $112.0 Short-term...
Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales...
Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $ 3,250.0 $ 2,600.0 Operating costs excluding depreciation and amortization 2,763.0 2,210.0 EBITDA $ 487.0 $ 390.0 Depreciation and amortization 90.0 78.0 Earnings before interest and taxes (EBIT) $ 397.0 $ 312.0   Interest 72.0 57.0 Earnings before taxes (EBT) $ 325.0 $ 255.0   Taxes (40%) 130.0 102.0 Net income $ 195.0 $ 153.0 Common dividends $ 176.0 $ 122.0 Powell Panther Corporation: Balance Sheets...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT