Question

In: Finance

Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...

Financial information for Powell Panther Corporation is shown below:

Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)

2018 2017
Sales $ 3,080.0 $ 2,800.0
Operating costs excluding depreciation and amortization 2,310.0 2,380.0
EBITDA $ 770.0 $ 420.0
Depreciation and amortization 73.0 56.0
Earnings before interest and taxes (EBIT) $ 697.0 $ 364.0
  Interest 68.0 62.0
Earnings before taxes (EBT) $ 629.0 $ 302.0
  Taxes (40%) 251.6 120.8
Net income $
377.4
$
181.2
Common dividends $
340.0
$
145.0

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

2018 2017
Assets
Cash and equivalents $ 55.0 $ 42.0
Accounts receivable 322.0 280.0
Inventories 837.0 644.0
  Total current assets $ 1,214.0 $ 966.0
Net plant and equipment 728.0 560.0
Total assets $ 1,942.0 $ 1,526.0
Liabilities and Equity
Accounts payable $ 185.0 $ 168.0
Accruals 101.0 84.0
Notes payable 62.0 56.0
  Total current liabilities $ 348.0 $ 308.0
Long-term bonds 616.0 560.0
  Total liabilities $ 964.0 $ 868.0
Common stock 886.6 604.0
Retained earnings 91.4 54.0
  Common equity $ 978.0 $ 658.0
Total liabilities and equity $
1,942.0
$
1,526.0

Write out your answers completely. For example, 25 million should be entered as 25,000,000. Round your answers to the nearest dollar, if necessary. Negative values, if any, should be indicated by a minus sign.

  1. What was net operating working capital for 2017 and 2018? Assume the firm has no excess cash.

    2017:  $  

    2018:  $  

  2. What was the 2018 free cash flow?

    $  

  3. How would you explain the large increase in 2018 dividends?
    1. The large increase in net income from 2017 to 2018 explains the large increase in 2018 dividends.
    2. The large increase in EBIT from 2017 to 2018 explains the large increase in 2018 dividends.
    3. The large increase in sales from 2017 to 2018 explains the large increase in 2018 dividends.
    4. The large increase in free cash flow from 2017 to 2018 explains the large increase in 2018 dividends.
    5. The large increase in retained earnings from 2017 to 2018 explains the large increase in 2018 dividends.

Solutions

Expert Solution

Answer : (a.) Calculation of Net Increase in Working Capital for 2017 :

Net Increase in Working Capital = Current assets - (Current Liabilities - Notes Payable)

= 966,000,000 - (308,000,000 - 56,000,000)

= 714,000,000

Calculation of Net Increase in Working Capital for 2018 :

Net Increase in Working Capital = Current assets - (Current Liabilities - Notes Payable)

= 1,214,000,000 - (348,000,000 - 62,000,000)

= 928,000,000

(b.) Free Cash Flow = EBIT * (1 - Tax Rate) + Depreciation - Capital Expenditure - Increase in Working Capital

= [697,000,000 * (1 - 0.40)] + 73,000,000 - 241,000,000 - 214,000,000

= 36,200,000

Capital expenditure =Net Fixed Assets in 2018 + Depreciation - Net Fixed Assets in 2017

= 728,000,000 + 73,000,000 - 560,000,000

= 241,000,000

Increase in Net Working Capital = 928,000,000 - 714,000,000 = 214,000,000

(c.) Correct option is The large increase in net income from 2017 to 2018 explains the large increase in 2018 dividends.


Related Solutions

Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,300.0 $ 3,000.0 Operating costs excluding depreciation and amortization 2,475.0 2,550.0 EBITDA $ 825.0 $ 450.0 Depreciation and amortization 86.0 66.0 Earnings before interest and taxes (EBIT) $ 739.0 $ 384.0   Interest 72.6 66.0 Earnings before taxes (EBT) $ 666.4 $ 318.0   Taxes (25%) 266.6 127.2 Net income $ 399.8 $ 190.8 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,190.0 $ 2,900.0 Operating costs excluding depreciation and amortization 2,712.0 2,465.0 EBITDA $ 478.0 $ 435.0 Depreciation and amortization 73.0 64.0 Earnings before interest and taxes (EBIT) $ 405.0 $ 371.0   Interest 70.2 63.8 Earnings before taxes (EBT) $ 334.8 $ 307.2   Taxes (25%) 133.9 122.9 Net income $ 200.9 $ 184.3 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,105.0 $ 2,700.0 Operating costs excluding depreciation and amortization 2,562.0 2,295.0 EBITDA $ 543.0 $ 405.0 Depreciation and amortization 81.0 65.0 Earnings before interest and taxes (EBIT) $ 462.0 $ 340.0   Interest 68.3 59.4 Earnings before taxes (EBT) $ 393.7 $ 280.6   Taxes (25%) 157.5 112.2 Net income $ 236.2 $ 168.4 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,480.0 $ 2,900.0 Operating costs excluding depreciation and amortization 2,871.0 2,465.0 EBITDA $ 609.0 $ 435.0 Depreciation and amortization 109.0 84.0 Earnings before interest and taxes (EBIT) $ 500.0 $ 351.0   Interest 76.6 63.8 Earnings before taxes (EBT) $ 423.4 $ 287.2   Taxes (25%) 169.4 114.9 Net income $ 254.0 $ 172.3 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 2,420.0 $ 2,200.0 Operating costs excluding depreciation and amortization 1,997.0 1,870.0 EBITDA $ 423.0 $ 330.0 Depreciation and amortization 48.0 44.0 Earnings before interest and taxes (EBIT) $ 375.0 $ 286.0   Interest 53.2 48.4 Earnings before taxes (EBT) $ 321.8 $ 237.6   Taxes (25%) 128.7 95.0 Net income $ 193.1 $ 142.6 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 1,440.0 $ 1,200.0 Operating costs excluding depreciation and amortization 1,116.0 1,020.0 EBITDA $ 324.0 $ 180.0 Depreciation and amortization 42.0 32.0 Earnings before interest and taxes (EBIT) $ 282.0 $ 148.0   Interest 31.7 26.4 Earnings before taxes (EBT) $ 250.3 $ 121.6   Taxes (25%) 100.1 48.6 Net income $ 150.2 $ 73.0 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,480.0 $ 2,900.0 Operating costs excluding depreciation and amortization 2,610.0 2,465.0 EBITDA $ 870.0 $ 435.0 Depreciation and amortization 96.0 87.0 Earnings before interest and taxes (EBIT) $ 774.0 $ 348.0   Interest 76.6 63.8 Earnings before taxes (EBT) $ 697.4 $ 284.2   Taxes (25%) 279.0 113.7 Net income $ 418.4 $ 170.5 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,240.0 $ 2,700.0 Operating costs excluding depreciation and amortization 2,430.0 2,295.0 EBITDA $ 810.0 $ 405.0 Depreciation and amortization 71.0 62.0 Earnings before interest and taxes (EBIT) $ 739.0 $ 343.0   Interest 71.3 59.4 Earnings before taxes (EBT) $ 667.7 $ 283.6   Taxes (25%) 267.1 113.4 Net income $ 400.6 $ 170.2 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $1,680.0 $1,400.0 Operating costs excluding depreciation and amortization 1,344.0 1,190.0 EBITDA $336.0 $210.0 Depreciation and amortization 37.0 29.0 Earnings before interest and taxes (EBIT) $299.0 $181.0 Interest 37.0 31.0 Earnings before taxes (EBT) $262.0 $150.0 Taxes (40%) 104.8 60.0 Net income $157.2 $90.0 Common dividends $141.0 $72.0 Powell Panther Corporation: Balance Sheets as of December...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 1,320.0 $ 1,100.0 Operating costs excluding depreciation and amortization 990.0 935.0 EBITDA $ 330.0 $ 165.0 Depreciation and amortization 36.0 33.0 Earnings before interest and taxes (EBIT) $ 294.0 $ 132.0   Interest 29.0 24.2 Earnings before taxes (EBT) $ 265.0 $ 107.8   Taxes (25%) 106.0 43.1 Net income $ 159.0 $ 64.7 Common dividends...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT