Question

In: Accounting

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

eBook

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,500.0 $ 2,800.0
Operating costs excluding depreciation and amortization 2,975.0 2,380.0
EBITDA $ 525.0 $ 420.0
Depreciation and amortization 67.0 56.0
Earnings before interest and taxes (EBIT) $ 458.0 $ 364.0
  Interest 77.0 61.6
Earnings before taxes (EBT) $ 381.0 $ 302.4
  Taxes (25%) 152.4 121.0
Net income $ 228.6 $ 181.4
Common dividends $ 205.7 $ 145.1

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

2019 2018
Assets
Cash and equivalents $ 53.0 $ 42.0
Accounts receivable 451.0 392.0
Inventories 665.0 532.0
  Total current assets $ 1,169.0 $ 966.0
Net plant and equipment 672.0 560.0
Total assets $ 1,841.0 $ 1,526.0
Liabilities and Equity
Accounts payable $ 235.0 $ 196.0
Accruals 129.0 112.0
Notes payable 70.0 56.0
  Total current liabilities $ 434.0 $ 364.0
Long-term bonds 700.0 560.0
  Total liabilities $ 1,134.0 $ 924.0
Common stock 629.6 547.5
Retained earnings 77.4 54.5
  Common equity $ 707.0 $ 602.0
Total liabilities and equity $ 1,841.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 2018 and 2019? Assume the firm has no excess cash.

    2018:  $  

    2019:  $  

  2. What was the 2019 free cash flow?

    $  

  3. How would you explain the large increase in 2019 dividends?

    1. The large increase in free cash flow from 2018 to 2019 explains the large increase in 2019 dividends.
    2. The large increase in net income from 2018 to 2019 explains the large increase in 2019 dividends.
    3. The large increase in EBIT from 2018 to 2019 explains the large increase in 2019 dividends.
    4. The large increase in sales from 2018 to 2019 explains the large increase in 2019 dividends.
    5. The large increase in retained earnings from 2018 to 2019 explains the large increase in 2019 dividends.

    -Select-IIIIIIIVV

Solutions

Expert Solution

a. 2018 - 658,000,000

2019 - 805,000,000

NOWC = Current assets - ( Current liabilities - Notes payable)

2019 2018
Total current assets         1,169,000,000              966,000,000
Less: Current assets
Accounts Payable            235,000,000              196,000,000
Accruals            129,000,000              112,000,000
Net operating working capital            805,000,000              658,000,000

b. Free cash flow = EBIT (1- Tax) + Depreciation - (Capital expenditures + Change in Net operating working capital)

Capital expenditure =  Net plant and equipment 2019 - Net plant and equipment in 2018 + Depreciation

= 672-560+ 67 = 179 million

Change in net operating working capital = 805 - 658 = 147

FCF = 458 *( 1-25%) + 67 - ( 179 +147)

=   84,500,000

c. Option I,The large increase in free cash flow from 2018 to 2019 explains the large increase in 2019 dividends.


Related Solutions

eBook Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for...
eBook 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,040.0 $ 1,700.0 Operating costs excluding depreciation and amortization 1,734.0 1,445.0 EBITDA $ 306.0 $ 255.0 Depreciation and amortization 39.0 36.0 Earnings before interest and taxes (EBIT) $ 267.0 $ 219.0   Interest 44.9 37.4 Earnings before taxes (EBT) $ 222.1 $ 181.6   Taxes (25%) 88.8 72.6 Net income $ 133.3 $ 109.0 Common...
4.) eBook Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements...
4.) eBook 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,640.0 $ 2,800.0 Operating costs excluding depreciation and amortization 3,094.0 2,380.0 EBITDA $ 546.0 $ 420.0 Depreciation and amortization 81.0 64.0 Earnings before interest and taxes (EBIT) $ 465.0 $ 356.0   Interest 80.1 61.6 Earnings before taxes (EBT) $ 384.9 $ 294.4   Taxes (25%) 154.0 117.8 Net income $ 230.9 $ 176.6...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT