Balance Sheets as of December 31 2021 2020 Assets Cash and equivalents $ 12,000 $ 11,000 Accounts receivable 35,000 20,000 Inventories 30,935 17,000 Total current assets $ 77,935 $ 48,000 Net plant and equipment 47,000 46,000 Total assets $124,935 $94,000 Liabilities and Equity Accounts payable $ 10,200 $ 8,500 Accruals 8,000 6,000 Notes payable 6,400 5,350 Total current liabilities $ 24,600 $ 19,850 Long-term bonds 10,000 10,000 Total liabilities $ 34,600 $ 29,850 Common stock (4,000 shares) 50,000 50,000 Retained earnings 40,335 14,150 Common equity $ 90,335 $ 64,150 Total liabilities and equity $124,935 $94,000 Income Statement for Year Ending December 31, 2021 Sales $197,000 Operating costs excluding depreciation and amortization 150,000 EBITDA $ 47,000 Depreciation & amortization 8,000 EBIT $ 39,000 Interest 850 EBT $ 38,150 Taxes (25%) 9,537.50 Net income $28,612.50 Dividends paid $2,427.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. What was net operating working capital for 2020 and 2021? Assume that all cash is excess cash; i.e., this cash is not needed for operating purposes. 2020 $ million 2021 $ million What was Arlington's 2021 free cash flow? $ million Construct Arlington's 2021 statement of stockholders' equity. Statement of Stockholders' Equity, 2021 Common Stock RetainedEarnings Total Stockholders'Equity Shares Amount Balances, 12/31/20 million $ million $ million $ million 2021 Net Income million Cash Dividends million Addition to retained earnings million Balances, 12/31/21 million $ million $ million $ million What was Arlington's 2021 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 2021? Assume that its stock price at December 31, 2021 was $25. Round your answer to the nearest cent. $ million

Balance Sheets as of December 31 2021 2020 Assets Cash and equivalents $ 12,000 $ 11,000 Accounts receivable 35,000 20,000 Inventories 30,935 17,000 Total current assets $ 77,935 $ 48,000 Net plant and equipment 47,000 46,000 Total assets $124,935 $94,000 Liabilities and Equity Accounts payable $ 10,200 $ 8,500 Accruals 8,000 6,000 Notes payable 6,400 5,350 Total current liabilities $ 24,600 $ 19,850 Long-term bonds 10,000 10,000 Total liabilities $ 34,600 $ 29,850 Common stock (4,000 shares) 50,000 50,000 Retained earnings 40,335 14,150 Common equity $ 90,335 $ 64,150 Total liabilities and equity $124,935 $94,000 Income Statement for Year Ending December 31, 2021 Sales $197,000 Operating costs excluding depreciation and amortization 150,000 EBITDA $ 47,000 Depreciation & amortization 8,000 EBIT $ 39,000 Interest 850 EBT $ 38,150 Taxes (25%) 9,537.50 Net income $28,612.50 Dividends paid $2,427.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. What was net operating working capital for 2020 and 2021? Assume that all cash is excess cash; i.e., this cash is not needed for operating purposes. 2020 $ million 2021 $ million What was Arlington's 2021 free cash flow? $ million Construct Arlington's 2021 statement of stockholders' equity. Statement of Stockholders' Equity, 2021 Common Stock RetainedEarnings Total Stockholders'Equity Shares Amount Balances, 12/31/20 million $ million $ million $ million 2021 Net Income million Cash Dividends million Addition to retained earnings million Balances, 12/31/21 million $ million $ million $ million What was Arlington's 2021 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 2021? Assume that its stock price at December 31, 2021 was $25. Round your answer to the nearest cent. $ million

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Question

100%

Balance Sheets as of December 31
	2021	2020
Assets
Cash and equivalents	$ 12,000	$ 11,000
Accounts receivable	35,000	20,000
Inventories	30,935	17,000
Total current assets	$ 77,935	$ 48,000
Net plant and equipment	47,000	46,000
Total assets	$124,935	$94,000

Liabilities and Equity
Accounts payable	$ 10,200	$ 8,500
Accruals	8,000	6,000
Notes payable	6,400	5,350
Total current liabilities	$ 24,600	$ 19,850
Long-term bonds	10,000	10,000
Total liabilities	$ 34,600	$ 29,850
Common stock (4,000 shares)	50,000	50,000
Retained earnings	40,335	14,150
Common equity	$ 90,335	$ 64,150
Total liabilities and equity	$124,935	$94,000

Income Statement for Year Ending December 31, 2021
Sales	$197,000
Operating costs excluding depreciation and amortization	150,000
EBITDA	$ 47,000
Depreciation & amortization	8,000
EBIT	$ 39,000
Interest	850
EBT	$ 38,150
Taxes (25%)	9,537.50
Net income	$28,612.50
Dividends paid	$2,427.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.

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

2020 $ million

2021 $ million
What was Arlington's 2021 free cash flow?

$ million

Construct Arlington's 2021 statement of stockholders' equity.

Statement of Stockholders' Equity, 2021
	Common Stock	Retained Earnings	Total Stockholders' Equity
Shares	Amount
Balances, 12/31/20	million	$ million	$ million	$ million
2021 Net Income		million
Cash Dividends		million
Addition to retained earnings			million
Balances, 12/31/21	million	$ million	$ million	$ million

What was Arlington's 2021 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 2021? Assume that its stock price at December 31, 2021 was $25. Round your answer to the nearest cent.

$ million

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here