Question

In: Finance

FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here....

FREE CASH FLOW

Arlington Corporation's financial statements (dollars and shares are in millions) are provided here.

Balance Sheets as of December 31
2016 2015
Assets
Cash and equivalents $  15,000 $  13,000
Accounts receivable 30,000 25,000
Inventories 26,815 23,000
  Total current assets $ 71,815 $ 61,000
Net plant and equipment 46,000 45,000
Total assets $117,815 $106,000
Liabilities and Equity
Accounts payable $ 10,800 $  9,500
Accruals 7,800 6,000
Notes payable 6,200 5,200
  Total current liabilities $ 24,800 $ 20,700
Long-term bonds 20,000 20,000
  Total liabilities $ 44,800 $ 40,700
Common stock (4,000 shares) 50,000 50,000
Retained earnings 23,015 15,300
  Common equity $ 73,015 $ 65,300
Total liabilities and equity $117,815 $106,000
Income Statement for Year Ending December 31, 2016
Sales $242,000
Operating costs excluding depreciation and amortization 200,000
EBITDA $ 42,000
Depreciation & amortization 3,000
EBIT $ 39,000
Interest 2,900
EBT $ 36,100
Taxes (40%) 14,440
Net income $ 21,660
Dividends paid 13,945

Enter your answers in millions. For example, an answer of $25,000,000,000 should be entered as 25,000.

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

  2. What was Arlington's 2016 free cash flow?

    $ million
  3. Construct Arlington's 2016 statement of stockholders' equity.
    Common Stock Retained
    Earnings
    Total Stockholders'
    Equity
    Shares Amount
    Balances, 12/31/15 million $ million $ million $ million
    2016 Net Income million
    Cash Dividends million
    Addition to retained earnings million
    Balances, 12/31/16 million $ million $ million $ million
  4. What was Arlington's 2016 EVA? Assume that its after-tax cost of capital is 10%. Round your answer to two decimal places.

    $   million

  5. What was Arlington's MVA at year-end 2016? Assume that its stock price at December 31, 2016 was $25.

    $   million

Solutions

Expert Solution


Related Solutions

FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here....
FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents $  14,000 $  13,000 Accounts receivable 35,000 30,000 Inventories 33,265 27,000   Total current assets $ 82,265 $ 70,000 Net plant and equipment 49,000 45,000 Total assets $131,265 $115,000 Liabilities and Equity Accounts payable $ 10,800 $  9,500 Accruals 7,700 7,000 Notes payable 6,000 5,000   Total current liabilities $ 24,500 $ 21,500 Long-term bonds 15,000 15,000...
FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here....
FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents $ 15,000 $ 14,000 Accounts receivable 35,000 30,000 Inventories 34,420 27,000 Total current assets $ 84,420 $ 71,000 Net plant and equipment 52,000 49,000 Total assets $136,420 $120,000 Liabilities and Equity Accounts payable $ 10,300 $ 9,000 Accruals 7,300 6,000 Notes payable 7,000 5,100 Total current liabilities $ 24,600 $ 20,100 Long-term...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2019 2018 Assets Cash and equivalents $  15,000 $  11,000 Accounts receivable 25,000 20,000 Inventories 22,945 19,000   Total current assets $ 62,945 $ 50,000 Net plant and equipment 50,000 47,000 Total assets $112,945 $97,000 Liabilities and Equity Accounts payable $ 10,600 $  8,500 Accruals 7,900 6,000 Notes payable 6,200 5,450   Total current liabilities $ 24,700 $ 19,950 Long-term bonds 15,000 15,000   Total liabilities $...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2019 2018 Assets Cash and equivalents $  13,000 $  11,000 Accounts receivable 35,000 30,000 Inventories 30,625 28,000   Total current assets $ 78,625 $ 69,000 Net plant and equipment 51,000 46,000 Total assets $129,625 $115,000 Liabilities and Equity Accounts payable $ 10,700 $  8,000 Accruals 7,500 5,000 Notes payable 6,200 5,150   Total current liabilities $ 24,400 $ 18,150 Long-term bonds 10,000 10,000   Total liabilities $...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2019 2018 Assets Cash and equivalents $  13,000 $  11,000 Accounts receivable 25,000 20,000 Inventories 24,685 17,000   Total current assets $ 62,685 $ 48,000 Net plant and equipment 49,000 47,000 Total assets $111,685 $95,000 Liabilities and Equity Accounts payable $ 10,500 $  9,500 Accruals 7,600 5,000 Notes payable 6,900 5,450   Total current liabilities $ 25,000 $ 19,950 Long-term bonds 15,000 15,000   Total liabilities $...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2018 2017 Assets Cash and equivalents $  13,000 $  12,000 Accounts receivable 30,000 25,000 Inventories 27,115 24,000   Total current assets $ 70,115 $ 61,000 Net plant and equipment 52,000 48,000 Total assets $122,115 $109,000 Liabilities and Equity Accounts payable $ 10,400 $  9,000 Accruals 8,000 7,000 Notes payable 6,900 5,450   Total current liabilities $ 25,300 $ 21,450 Long-term bonds 10,000 10,000   Total liabilities $...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2019 2018 Assets Cash and equivalents $  13,000 $  11,000 Accounts receivable 35,000 25,000 Inventories 33,205 24,000   Total current assets $ 81,205 $ 60,000 Net plant and equipment 54,000 49,000 Total assets $135,205 $109,000 Liabilities and Equity Accounts payable $ 10,100 $  8,000 Accruals 7,200 7,000 Notes payable 6,600 5,250   Total current liabilities $ 23,900 $ 20,250 Long-term bonds 15,000 15,000   Total liabilities $...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2019 2018 Assets Cash and equivalents $  13,000 $  12,000 Accounts receivable 30,000 20,000 Inventories 28,650 18,000   Total current assets $ 71,650 $ 50,000 Net plant and equipment 49,000 45,000 Total assets $120,650 $95,000 Liabilities and Equity Accounts payable $ 10,700 $  8,500 Accruals 7,700 7,000 Notes payable 6,700 5,050   Total current liabilities $ 25,100 $ 20,550 Long-term bonds 20,000 20,000   Total liabilities $...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents $  14,000 $  13,000 Accounts receivable 35,000 30,000 Inventories 34,660 27,000   Total current assets $ 83,660 $ 70,000 Net plant and equipment 50,000 49,000 Total assets $133,660 $119,000 Liabilities and Equity Accounts payable $ 10,700 $  9,000 Accruals 7,100 5,000 Notes payable 6,200 5,400   Total current liabilities $ 24,000 $ 19,400 Long-term bonds 20,000 20,000   Total liabilities $...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents $ 13,000 $ 11,000 Accounts receivable 35,000 30,000 Inventories 32,880 28,000 Total current assets $ 80,880 $ 69,000 Net plant and equipment 51,000 48,000 Total assets $131,880 $117,000 Liabilities and Equity Accounts payable $ 10,600 $ 8,000 Accruals 7,200 6,000 Notes payable 6,200 5,400 Total current liabilities $ 24,000 $ 19,400 Long-term bonds 15,000 15,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT