Question

2018 2017 Assets Cash and equivalents $14,000 11,000 Accounts receivable 35,000 30,000 Inventories 30,120 27,000 Total currenEnter your answers in millions. For example, an answer of $25,000,000,000 should be entered as 25,000. Round your answers to

2018 2017 Assets Cash and equivalents $14,000 11,000 Accounts receivable 35,000 30,000 Inventories 30,120 27,000 Total current assets 79,120 68,000 Net plant and equipment 48,000 45,000 Total assets $127,120 $113,000 Liabilities and Equity Accounts payable 8,500 10,500 Accruals 7,600 6,000 Notes payable 6,100 5,150 $ 19,650 Total current liabilities 24,200 Long-term bonds 10,000 10,000 $29,650 Total liabilities 34,200 Common stock (4,000 shares) 50,000 50,000 Retained earnings 42,920 33,350 Common equity 92,920 83,350 Total liabilities and equity $127,120 $113,000 Income Statement for Year Ending December 31, 2018 Sales $245,000 Operating costs excluding depreciation and amortization 200,000 ЕBITDA $45,000 Depreciation & amortization 5,000 EBIT $40,000 Interest 3,750 EBT 36,250 Taxes (40%) 14,500 Net income $21,750 Dividends paid 12,180
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 2017 and 2018? Assume that all cash is excess cash; i.e., this cash is not needed for operating purposes. 2017 $ million 2018 $ million b. What was Arlington's 2018 free cash flow? million c. Construct Arlington's 2018 statement of stockholders' equity. Statement of Stockholders' Equity, 2018 Total Stockholders Retained Common Stock Earnings Equity Amount Shares Balances, 12/31/17 million million million million 2018 Net Income million Cash Dividends million Addition to retained earnings million million Balances, 12/31/18 million million million d. What was Arlington's 2018 EVA? Assume that its after-tax cost of capital is 10 % . Round your answer to two decimal places. million e. What was Arlington's MVA at year-end 2018? Assume that its stock price at December 31, 2018 was $25. Round your answer to two decimal places million
0 0
Add a comment Improve this question Transcribed image text
Answer #1

A. NOWC for 2017 is $53500

NOWC for 2018 is $61020

NOWC= (cash+inventory+AR) - (accruals + AP)

B. FCF= EBIT-tax + dep&A -CAPEX - change in WC

= $11830

C. for year 2017- SHARES 4000 AMOUNT $50,000 RETAINED EARNINGS $33350 shareholder's equity (shares+retained earnings) =$83350

net income for year 2018 is $21750

cash dividend paid is $12180

addition to retained earnings (42920-33350) =$9570

balance for year 2018 shares 4000 amount $50,000 retained earnings $42920 shareholder's equity $92920

D. EVA = NET INCOME - COST OF EQUITY CAPITAL

= 21750-(10% * 50000) = $16750

E. MVA= MARKET VALUE OF STOCK- TOTAL COMMON EQUITY

= (25*4000) - 92920 = $7080

Add a comment
Know the answer?
Add Answer to:
2018 2017 Assets Cash and equivalents $14,000 11,000 Accounts receivable 35,000 30,000 Inventories 30,120 27,000 Total...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2018 2017 Assets Cash and equivalents Accounts receivable Inventories Total current assets 999 991 Net plant...

    2018 2017 Assets Cash and equivalents Accounts receivable Inventories Total current assets 999 991 Net plant and equipment Total assets Liabilities and Equity 8 Accounts payable $ 11,000 8 Accruals 7,600 Notes payable 6,000 Total current liabilities Long-term bonds Total liabilities 99% 318 88 44,500 40,000 49,955 Common stock (4,000 shares) Retained earnings 40,000 49,955 35,100 Common equity $ 89,955 $75.100 Total liabilities and equity $134,555 $115,000 Income Statement for Year Ending December 31, 2018 Sales $225,000 Operating costs excluding...

  • Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories $15,000...

    Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories $15,000 14,000 30,000 .28,000 $81,235 $72,000 47,000 $119,000 35,000 31,235 Total current assets Net plant and equipment Total assets 50,000 $131,235 Liabilities and Equity Accounts payable Accruals Notes payable $10,000 7,100 7,000 8,500 7,000 5,150 Total current liabilities Long-term bonds Total liabilities Common stock (4,000 shares) Retained earnings 20,000 44,100 60,000 27,135 87,135 $131,235 $ 24,100 20,650 20,000 $40,650 60,000 18,350 $ 78,350 $119,000 Common...

  • Balance Sheets as of December 31 2016 2015 $ 14,000 1 Cash and equivalents Accounts receivable...

    Balance Sheets as of December 31 2016 2015 $ 14,000 1 Cash and equivalents Accounts receivable Inventories 12,000 25,000 23,000 $71.705 60,000 48,000 $120,705 $108,000 30,000 27,705 Total current assets Net plant and equipment Total assets 49,000 Liabilities and Equity $ 10.9008,500 7,000 5.050 s 25,20020,550 20,000 s 45.200 40.550 40,000 27.450 $75.5055 67450 $108.000 Accounts payable 7.500 Notes payable 6.800 Total current liabilities Long-term bonds 20,000 Total liabilities Common stock (4,000 shares) Retained earnings 40,000 Common equity Total liabilities...

  • Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories s13,000...

    Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories s13,000 35,000 34,620 82,620 50,000 $132,620 s 12,000 25,000 22,000 59,000 49,000 $108,000 Total current assets Net plant and equipment Total assets Enter your answers in millions. For example, an answer of $25,000,00D,000 should be entered as 25,000. a. What was net operating working capital for 2015 and 20167 2015 S million Liabiwties and Equity Accounts payable Accruals Notes payable 2016 million 10,800 8,000 6,200...

  • Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. 2019 2018 Assets...

    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) a Balance Sheets as of December...

    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...

  • Balance Sheets 2019 2018 Assets Cash and equivalents Accounts receivable Inventories Total current assets Net plant...

    Balance Sheets 2019 2018 Assets Cash and equivalents Accounts receivable Inventories Total current assets Net plant and equipment Total assets $70 275 375 $720 $55 300 250 $605 1,490 $2,095 $3,020 $85 $ 150 175 50 120 45 Liabilities and Equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Common stock Retained earnings Total liabilities and equity $345|| 450 1,225 1,000 $3,020 $180 290 1,225 400 $2,095 Income Statements Sales Operating costs excluding depreciation EBITDA Depreciation and amortization...

  • Assets 2017 2018 2018 Current assets Cash Accounts receivable Inventory Total $ 24,046 12,448 25,392 $...

    Assets 2017 2018 2018 Current assets Cash Accounts receivable Inventory Total $ 24,046 12,448 25,392 $ 61,886 $ 24, 255 15,235 27,155 $ 66,645 Liabilities and Owners' Equity 2017 Current liabilities Accounts payable $ 23, 184 Notes payable 12,000 Other 11,571 藍译此页 Total $ 46,755 Long-term debt $ 80,000 Owners' equity Common stock and paid-in surplus $ 40,000 Retained earnings 219,826 Total $ 259,826 Total liabilities and owners' equity $386,581 $ 27,420 10,800 15,553 $ 53, 773 $ 95,000 Fixed...

  • FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here....

    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....

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT