Question

In: Finance

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 $  14,000 $  13,000
Accounts receivable 35,000 30,000
Inventories 30,280 28,000
  Total current assets $ 79,280 $ 71,000
Net plant and equipment 53,000 49,000
Total assets $132,280 $120,000
Liabilities and Equity
Accounts payable $ 10,200 $  8,000
Accruals 7,500 7,000
Notes payable 6,900 5,350
  Total current liabilities $ 24,600 $ 20,350
Long-term bonds 15,000 15,000
  Total liabilities $ 39,600 $ 35,350
Common stock (4,000 shares) 60,000 60,000
Retained earnings 32,680 24,650
  Common equity $ 92,680 $ 84,650
Total liabilities and equity $132,280 $120,000
Income Statement for Year Ending December 31, 2019
Sales $245,000
Operating costs excluding depreciation and amortization 200,000
EBITDA $ 45,000
Depreciation & amortization 4,000
EBIT $ 41,000
Interest 5,650
EBT $ 35,350
Taxes (25%) 8,837.50
Net income $ 26,512.50
Dividends paid 18,482.50

Enter your answers in millions. For example, an answer of $25,000,000,000 should be entered as 25,000. Round your answers to the nearest whole number, if necessary.

  1. What was net operating working capital for 2018 and 2019? Assume that all cash is excess cash; i.e., this cash is not needed for operating purposes.

    2018 $    million
    2019 $    million
  2. What was Arlington's 2019 free cash flow?

    $    million

  3. Construct Arlington's 2019 statement of stockholders' equity.

    Statement of Stockholders' Equity, 2019
    Common Stock Retained
    Earnings
    Total Stockholders'
    Equity
    Shares Amount
    Balances, 12/31/18   million $    million $    million $    million
    2019 Net Income   million
    Cash Dividends   million
    Addition to retained earnings   million
    Balances, 12/31/19   million $    million $    million $    million
  4. What was Arlington's 2019 EVA? Assume that its after-tax cost of capital is 10%. Round your answer to the nearest cent.

    $    million

  5. What was Arlington's MVA at year-end 2019? Assume that its stock price at December 31, 2019 was $25. Round your answer to the nearest cent.

    $    million

Solutions

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE.

SHAREHOLDERS' EQUITY WAS ROUNDED AS FIGURE IN BALANCE SHEET IS ROUNDED.


Related Solutions

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...
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 $  14,000 $  11,000 Accounts receivable 35,000 20,000 Inventories 31,230 18,000   Total current assets $ 80,230 $ 49,000 Net plant and equipment 48,000 46,000 Total assets $128,230 $95,000 Liabilities and Equity Accounts payable $ 10,700 $  8,000 Accruals 7,800 6,000 Notes payable 6,100 5,000   Total current liabilities $ 24,600 $ 19,000 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 $  15,000 $  12,000 Accounts receivable 35,000 25,000 Inventories 30,635 22,000   Total current assets $ 80,635 $ 59,000 Net plant and equipment 53,000 48,000 Total assets $133,635 $107,000 Liabilities and Equity Accounts payable $ 10,100 $  8,500 Accruals 8,000 6,000 Notes payable 6,200 5,500   Total current liabilities $ 24,300 $ 20,000 Long-term bonds 20,000 20,000   Total liabilities $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT