Question

In: Accounting

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 $  12,000
Accounts receivable 35,000 30,000
Inventories 32,135 29,000
  Total current assets $ 81,135 $ 71,000
Net plant and equipment 53,000 49,000
Total assets $134,135 $120,000
Liabilities and Equity
Accounts payable $ 10,200 $  9,500
Accruals 8,000 6,000
Notes payable 6,900 5,300
  Total current liabilities $ 25,100 $ 20,800
Long-term bonds 15,000 15,000
  Total liabilities $ 40,100 $ 35,800
Common stock (4,000 shares) 50,000 50,000
Retained earnings 44,035 34,200
  Common equity $ 94,035 $ 84,200
Total liabilities and equity $134,135 $120,000
Income Statement for Year Ending December 31, 2016
Sales $208,000
Operating costs excluding depreciation and amortization 160,000
EBITDA $ 48,000
Depreciation & amortization 6,000
EBIT $ 42,000
Interest 6,250
EBT $ 35,750
Taxes (40%) 14,300
Net income $ 21,450
Dividends paid 11,615

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

What was net operating working capital for 2015 and 2016?

2015 $    million
2016 $    million

What was Arlington's 2016 free cash flow?

$    million

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

What was Arlington's 2016 EVA? Assume that its after-tax cost of capital is 10%. Round your answer to two decimal places.

$    million

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

Solutions

Expert Solution

Net operating working capital = current assets - current liabilities - Notes Payable

For 2016, Net operating working capital = $81,135 - $(25,100 - 6,900) = $62,935

For 2015, Net operating working capital = $71,000 - $(20,800-5,300) = $55,500

2.

Free cash flow is calculated with the formula:

FCF = (EBIT(1-T) + Depreciation) - (Capital expenditure + change in net operating working capital)

= $(42,000(1-0.40) + 6,000) - $((53,000-49,000) + (62,935 - 55,500)

=$31,200-(4000+7435)

=19,765$

2)market value added (MVA) refers to total value of enquiry and long term debt minus total capital employed by boshareholders and long term debt holder

Here long term bond value is same

Then, MVA =CURRENT market value of equity -share holders fund

=100000(25*4000)-94,035

MVA=$ 5,965

3)

EVA refers to difference between net operating income and return on capital emlopyed

Step:1 net operating income

NET INCOME=$ 21,450

ADD:interest net of tax=$3750

Net operating income=$ 25,200

Step2:capital employed

Share holders fund =$ 94,035

Debt. =$15,000

Total = $1,09,035

Step3:EVA =25,200-10904(109035*10%)

EVA=$14,296


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