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 | $ 14,000 | |
Accounts receivable | 30,000 | 25,000 | |
Inventories | 27,640 | 22,000 | |
Total current assets | $ 72,640 | $ 61,000 | |
Net plant and equipment | 47,000 | 46,000 | |
Total assets | $119,640 | $107,000 | |
Liabilities and Equity | |||
Accounts payable | $ 10,200 | $ 8,500 | |
Accruals | 7,100 | 6,000 | |
Notes payable | 6,100 | 5,300 | |
Total current liabilities | $ 23,400 | $ 19,800 | |
Long-term bonds | 20,000 | 20,000 | |
Total liabilities | $ 43,400 | $ 39,800 | |
Common stock (4,000 shares) | 60,000 | 60,000 | |
Retained earnings | 16,240 | 7,200 | |
Common equity | $ 76,240 | $ 67,200 | |
Total liabilities and equity | $119,640 | $107,000 |
Income Statement for Year Ending December 31, 2019 | |
Sales | $210,000 |
Operating costs excluding depreciation and amortization | 160,000 |
EBITDA | $ 50,000 |
Depreciation & amortization | 8,000 |
EBIT | $ 42,000 |
Interest | 4,000 |
EBT | $ 38,000 |
Taxes (25%) | 9,500.00 |
Net income | $ 28,500.00 |
Dividends paid | 19,460.00 |
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.
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 |
What was Arlington's 2019 free cash flow?
$ million
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 |
What was Arlington's 2019 EVA? Assume that its after-tax cost of capital is 10%. Round your answer to the nearest cent.
$ million
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
a.
2019 | 2018 | |
Total current assets | 72,640 | 61,000 |
Total current liabilities | 23,400 | 19,800 |
Working capital | 49,240 | 41,200 |
Less: cash | 15,000 | 14,000 |
Net operating working capital | 34,240 | 27,200 |
b. Free cash flow = Net operating profit after taxes (NOPAT) - Net investment in operating capital
= Net income (excluding depreciation & interest) - Net investment in operating capital
= 28,500+ 8,000+4,000 = 40,500 - 7,040 = 33,460
c. Arlington's 2019 statement of stockholders' equity.
Statement of Stockholders' Equity, 2019 | |||||
Common Stock | Retained | Total Stockholders' | |||
Shares | Amount | Earnings | Equity | ||
Balances, 12/31/18 | 4000 | 60000 | 16240 | 76240 | |
2019 Net Income | 28500 | ||||
Cash Dividends | -19460 | ||||
Addition to retained earnings | |||||
Balances, 12/31/19 | 85280 |
d. Arlington's 2019 EVA = NOPAT - WACC(Total assets - current liabilities)
= 33,460 - 10%(119,640-23,400) = 33,360 - 9,624
= 23,836
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,890 26,000 Total current assets $ 79,890 $ 69,000 Net plant and equipment 50,000 46,000 Total assets $129,890 $115,000 Liabilities and Equity Accounts payable $ 10,800 $ 8,000 Accruals 7,800 5,000 Notes payable 6,300 5,250 Total current liabilities $ 24,900 $ 18,250 Long-term bonds 20,000 20,000...
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 $ 12,000 Accounts receivable 35,000 25,000 Inventories 31,040 23,000 Total current assets $ 80,040 $ 60,000 Net plant and equipment 49,000 48,000 Total assets $129,040 $108,000 Liabilities and Equity Accounts payable $ 11,000 $ 8,000 Accruals 7,700 6,000 Notes payable 6,500 5,150 Total current liabilities $ 25,200 $ 19,150 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 of December 31 2019 2018 Assets Cash and equivalents $ 13,000 $ 11,000 Accounts receivable 35,000 30,000 Inventories 30,380 26,000 Total current assets $ 78,380 $ 67,000 Net plant and equipment 46,000 45,000 Total assets $124,380 $112,000 Liabilities and Equity Accounts payable $ 10,300 $ 8,000 Accruals 7,700 6,000 Notes payable 6,300 5,050 Total current liabilities $ 24,300 $ 19,050 Long-term bonds 15,000 15,000 Total liabilities $...
Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. 2019 2018 Assets Cash and equivalents $ 15,000 $ 11,000 Accounts receivable 30,000 25,000 Inventories 28,480 24,000 Total current assets $ 73,480 $ 60,000 Net plant and equipment 53,000 48,000 Total assets $126,480 $108,000 Liabilities and Equity Accounts payable $ 10,800 $ 9,500 Accruals 7,500 6,000 Notes payable 6,700 5,100 Total current liabilities $ 25,000 $ 20,600 Long-term bonds 10,000 10,000 Total liabilities $ 35,000 $ 30,600...
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 15,000 Accounts receivable 30,000 35,000 33,070 29,000 Inventories $ 83,070 Total current assets $73,000 Net plant and equipment 50,000 46,000 Total assets $133,070 $119,000 Liabilities and Equity Accounts payable $10,500 9,000 Accruals 7,100 6,000 Notes payable 6,600 5,050 $ 24,200 20,050 Total current liabilities Long-term bonds 10,000 10,000 Total liabilities 34,200 30,050 Common stock...
Arlington Corporation's financial statements (dollars and shares are in millions) a Balance Sheets as of December 31 2018 2017 Assets Cash and equivalents $ 14,000 $ 13,000 Accounts receivable 30,000 20,000 Inventories 25,585 17,000 Total current assets $69,585 $50,000 Net plant and equipment 46,000 45,000 Total assets $115,58 $95,000 Liabilities and Equity Accounts payable $ 10,900 s 8,500 Accruals 7,100 5,000 Notes payable 6,800 5,050 Total current liabilities $ 24,800 s 18,550 Long-term bonds 10,000 10,000 $ 34,800 $ 28,550...
Help Arlington Corporation's financial statements (dollars and shares are in milions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories $ 15,00014,000 30,000 28,000 80,325 $72,000 49,000 $134,325 $121,000 35,000 30,325 Total current assets Net plant and equipment Total assets 54,000 Liabilities and Equity Accounts payable Accruals Notes payable $ 10,400 8,500 7,500 6,700 $24,600 6,000 5,300 $19,800 Total current liabilities Liabilities and Equity Accounts payable Accruals Notes payable $ 10,400...
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 $ 11,000 Accounts receivable 35,000 30,000 Inventories 31,975 28,000 Total current assets $ 80,975 $ 69,000 Net plant and equipment 50,000 45,000 Total assets $130,975 $114,000 Liabilities and Equity Accounts payable $ 10,500 $ 9,500 Accruals 7,800 7,000 Notes payable 6,700 5,250 Total current liabilities $ 25,000 $ 21,750 Long-term bonds 10,000 10,000...
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 $ 13,000 $ 11,000 Accounts receivable 25,000 20,000 Inventories 24,910 19,000 Total current assets $ 62,910 $ 50,000 Net plant and equipment 49,000 47,000 Total assets $111,910 $97,000 Liabilities and Equity Accounts payable $ 10,200 $ 8,000 Accruals 7,900 7,000 Notes payable 7,000 5,250 Total current liabilities $ 25,100 $ 20,250 Long-term bonds 20,000 20,000...
FINANCIAL STATEMENTS The Davidson Corporation's balance sheet and income statement are provided here. Davidson Corporation: Balance Sheet as of December 31, 2016 (Millions of Dollars) Assets Liabilities and Equity Cash and equivalents $10 Accounts payable $130 Accounts receivable 545 Accruals 210 Inventories 890 Notes payable 230 Total current assets $1,445 Total current liabilities $570 Net plant and equipment 2,495 Long-term bonds 1,520 Total liabilities $2,090 Common stock (100 million shares) 250 Retained...