Question

In: Finance

FREE CASH FLOW Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income...

FREE CASH FLOW

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 $3,250.0 $2,600.0
Operating costs excluding depreciation and amortization 2,438.0 2,210.0
EBITDA $812.0 $390.0
Depreciation and amortization 94.0 75.0
Earnings before interest and taxes (EBIT) $718.0 $315.0
  Interest 72.0 57.0
Earnings before taxes (EBT) $646.0 $258.0
  Taxes (40%) 258.4 103.2
Net income
$387.6
$154.8
Common dividends
$349.0
$124.0

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

2016 2015
Assets
Cash and equivalents $31.0 $26.0
Accounts receivable 299.0 260.0
Inventories 748.0 650.0
  Total current assets $1,078.0 $936.0
Net plant and equipment 943.0 754.0
Total assets
$2,021.0
$1,690.0
Liabilities and Equity
Accounts payable $257.0 $234.0
Accruals 150.0 130.0
Notes payable 65.0 52.0
  Total current liabilities $472.0 $416.0
Long-term bonds 650.0 520.0
  Total liabilities $1,122.0 $936.0
Common stock 814.4 708.0
Retained earnings 84.6 46.0
  Common equity $899.0 $754.0
Total liabilities and equity
$2,021.0
$1,690.0

Write out your answers completely. For example, 25 million should be entered as 25,000,000.

  1. What was net operating working capital for 2015 and 2016?

    2015:  $  

    2016:  $  
  2. What was the 2016 free cash flow?

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

    -Select-IIIIIIIVV

Solutions

Expert Solution

a).Net Operating Working Capital = Current Assets - Accounts Payable - Accurals (Notes Payable are not part of Operating working capital)

Net Operating Working Capital of 2015 = $936 millions - $234 millions - $130 millions

= $572 millions

Net Operating Working Capital of of 2016 = $1078 millions - $257 millions - $150 millions

= $671 millions

b). Free cash Flow = EBIT*(1-Tax rate) + Depreciation - Change in Net Operating Working Capital - Net Capital Spending

where, Change in Net Operating Working Capital = Net Operating Working Capital of 2016 - Net Operating Working Capital of 2015

= $671 millions - $572 millions

= $99 millions

- Net Capital Spending of 2016 = Net Plant & Equipment of 2016 + depreciation of 2016 - Net Plant & Equipment of 2015

= $943 millions - $94 millions + $754 millions

= $283 millions

Free cash Flow = $718 million*(1-40%) + $94 million - $99 million - $283 million

Free cash Flow = $142.80 million

c). Ans- Option II.

As EBIT of 2016 increases drastically from 2015 which increased the Net income. Thus with increase in Net income Dividend increased.

Note- Sales Increased from 2015 to 2016 but at the same time Operating cost and depreciation decreased as proportion to increase in sales.

If you need any clarification, you can ask in comments.     

If you like my answer, then please up-vote as it will be motivating     


Related Solutions

FREE CASH FLOW Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income...
FREE CASH FLOW 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 $2,080.0 $1,600.0 Operating costs excluding depreciation and amortization 1,560.0 1,360.0 EBITDA $520.0 $240.0 Depreciation and amortization 51.0 46.0 Earnings before interest and taxes (EBIT) $469.0 $194.0 Interest 46.0 35.0 Earnings before taxes (EBT) $423.0 $159.0 Taxes (40%) 169.2 63.6 Net income $253.8 $95.4 Common dividends $228.0 $76.0 Powell Panther Corporation: Balance Sheets...
FREE CASH FLOW Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income...
FREE CASH FLOW 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 $2,200.0 $2,000.0 Operating costs excluding depreciation and amortization 1,705.0 1,700.0 EBITDA $495.0 $300.0 Depreciation and amortization 58.0 48.0 Earnings before interest and taxes (EBIT) $437.0 $252.0 Interest 48.0 44.0 Earnings before taxes (EBT) $389.0 $208.0 Taxes (40%) 155.6 83.2 Net income $233.4 $124.8 Common dividends $210.0 $100.0 Powell Panther Corporation: Balance Sheets...
FREE CASH FLOW Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income...
FREE CASH FLOW 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,560.0 $1,200.0 Operating costs excluding depreciation and amortization 1,170.0 1,020.0 EBITDA $390.0 $180.0 Depreciation and amortization 37.0 29.0 Earnings before interest and taxes (EBIT) $353.0 $151.0   Interest 34.0 26.0 Earnings before taxes (EBT) $319.0 $125.0   Taxes (40%) 127.6 50.0 Net income $191.4 $75.0 Common dividends $172.0 $60.0 Powell Panther Corporation: Balance Sheets...
FREE CASH FLOW Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income...
FREE CASH FLOW 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 $2,875.0 $2,500.0 Operating costs excluding depreciation and amortization 2,300.0 2,125.0 EBITDA $575.0 $375.0 Depreciation and amortization 84.0 68.0 Earnings before interest and taxes (EBIT) $491.0 $307.0   Interest 63.0 55.0 Earnings before taxes (EBT) $428.0 $252.0   Taxes (40%) 171.2 100.8 Net income $256.8 $151.2 Common dividends $231.0 $121.0 Powell Panther Corporation: Balance Sheets...
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...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT