Daidlice Dneels as of DecemDEN SI 2021 2020 Assets Cash and equivalents $ 14,000 $ 12,000...

Transcribed Image Text:

Daidlice Dneels as of DecemDEN SI 2021 2020 Assets Cash and equivalents $ 14,000 $ 12,000 Accounts receivable Inventories 35,000 30,000 34,845 29,000 Total current assets $ 83,845 $ 71,000 Net plant and equipment 49,000 46,000 Total assets $132,845 $117,000 Liabilities and Equity Accounts payable $ 10,500 $ 9,500 Accruals 8,000 5,000 Notes payable 6,600 5,300 Total current liabilities $ 25,100 $ 19,800 Long-term bonds 20,000 20,000 Total liabilities Common stock (4,000 shares) $ 45,100 $ 39,800 60,000 60,000 Retained earnings Common equity Total liabilities and equity 27,745 17,200 $ 87,745 $ 77,200 $132,845 $117,000 Income Statement for Year Ending December 31, 2021 Sales Operating costs excluding depreciation and amortization EBITDA Depreciation & amortization EBIT Interest EBT Taxes (25%) Net income Dividends paid $215,000 170,000 $ 45,000 7,000 $ 38,000 700 $ 37,300 9,325.00 $27,975.00 $17,430.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. a. 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 $ 2021 $ million million b. What was Arlington's 2021 free cash flow? $ million c. Construct Arlington's 2021 statement of stockholders' equity. Statement of Stockholders' Equity, 2021 Common Stock Retained Earnings Shares Amount Balances, 12/31/20 million $ million $ million S Total Stockholders' Equity million 2021 Net Income million Cash Dividends million Addition to retained million earnings Balances, 12/31/21 million $ million $ million $ million d. What was Arlington's 2021 EVA? Assume that its after-tax cost of capital is 10%. Round your answer to the nearest cent. $ million e. 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 Daidlice Dneels as of DecemDEN SI 2021 2020 Assets Cash and equivalents $ 14,000 $ 12,000 Accounts receivable Inventories 35,000 30,000 34,845 29,000 Total current assets $ 83,845 $ 71,000 Net plant and equipment 49,000 46,000 Total assets $132,845 $117,000 Liabilities and Equity Accounts payable $ 10,500 $ 9,500 Accruals 8,000 5,000 Notes payable 6,600 5,300 Total current liabilities $ 25,100 $ 19,800 Long-term bonds 20,000 20,000 Total liabilities Common stock (4,000 shares) $ 45,100 $ 39,800 60,000 60,000 Retained earnings Common equity Total liabilities and equity 27,745 17,200 $ 87,745 $ 77,200 $132,845 $117,000 Income Statement for Year Ending December 31, 2021 Sales Operating costs excluding depreciation and amortization EBITDA Depreciation & amortization EBIT Interest EBT Taxes (25%) Net income Dividends paid $215,000 170,000 $ 45,000 7,000 $ 38,000 700 $ 37,300 9,325.00 $27,975.00 $17,430.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. a. 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 $ 2021 $ million million b. What was Arlington's 2021 free cash flow? $ million c. Construct Arlington's 2021 statement of stockholders' equity. Statement of Stockholders' Equity, 2021 Common Stock Retained Earnings Shares Amount Balances, 12/31/20 million $ million $ million S Total Stockholders' Equity million 2021 Net Income million Cash Dividends million Addition to retained million earnings Balances, 12/31/21 million $ million $ million $ million d. What was Arlington's 2021 EVA? Assume that its after-tax cost of capital is 10%. Round your answer to the nearest cent. $ million e. 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