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)

2019 2018
Sales $ 2,970.0 $ 2,700.0
Operating costs excluding depreciation and amortization 2,525.0 2,295.0
EBITDA $ 445.0 $ 405.0
Depreciation and amortization 81.0 70.0
Earnings before interest and taxes (EBIT) $ 364.0 $ 335.0
  Interest 65.3 59.4
Earnings before taxes (EBT) $ 298.7 $ 275.6
  Taxes (25%) 119.5 110.2
Net income $ 179.2 $ 165.4
Common dividends $ 161.3 $ 132.3

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

2019 2018
Assets
Cash and equivalents $ 35.0 $ 30.0
Accounts receivable 386.0 297.0
Inventories 535.0 486.0
  Total current assets $ 956.0 $ 813.0
Net plant and equipment 807.0 702.0
Total assets $ 1,763.0 $ 1,515.0
Liabilities and Equity
Accounts payable $ 238.0 $ 216.0
Accruals 304.0 243.0
Notes payable 59.4 54.0
  Total current liabilities $ 601.4 $ 513.0
Long-term bonds 594.0 540.0
  Total liabilities $ 1,195.4 $ 1,053.0
Common stock 500.0 412.3
Retained earnings 67.6 49.7
  Common equity $ 567.6 $ 462.0
Total liabilities and equity $ 1,763.0 $ 1,515.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 net income from 2018 to 2019 explains the large increase in 2019 dividends.
    2. The large increase in EBIT from 2018 to 2019 explains the large increase in 2019 dividends.
    3. The large increase in sales from 2018 to 2019 explains the large increase in 2019 dividends.
    4. The large increase in retained earnings from 2018 to 2019 explains the large increase in 2019 dividends.
    5. The large increase in free cash flow from 2018 to 2019 explains the large increase in 2019 dividends.

    Solutions

    Expert Solution

    1.) Working Capital Formula is Current Assets- Current Liabilities.

    Following was the Working Capital for FY 2018

    Financial Year 2018 2019
    Cash and equivalents $ $   35,000,000.00 30000000
    Accounts receivable $ 386,000,000.00 297000000
    Inventories $ 535,000,000.00 486000000
       Total current assets (I) $ $ 956,002,018.00 813000000
    Liabilities and Equity
    Accounts payable $ $ 238,000,000.00 216000000
    Accruals $ 304,000,000.00 243000000
    Notes payable $   59,400,000.00 54000000
       Total current liabilities (II) $ $ 601,400,000.00 513000000
    Total Working Capital For FY 2018
    Total Cuurent Assets I - Total Current Liabilites II 354602018

    300000000

    C. Large increase in 2019 dividends is due to the increase in retained earnings and the increase in free cash flow expalins the reason for large increase in 2019 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) 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...
    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...
    ADVERTISEMENT
    ADVERTISEMENT
    ADVERTISEMENT