Question

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
  Total liabilities $ 35,000 $ 31,750
Common stock (4,000 shares) 50,000 50,000
Retained earnings 45,975 32,250
  Common equity $ 95,975 $ 82,250
Total liabilities and equity $130,975 $114,000
Income Statement for Year Ending December 31, 2016
Sales $207,000
Operating costs excluding depreciation and amortization 160,000
EBITDA $ 47,000
Depreciation & amortization 6,000
EBIT $ 41,000
Interest 5,800
EBT $ 35,200
Taxes (40%) 14,080
Net income $ 21,120
Dividends paid 7,395

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

  1. What was net operating working capital for 2015 and 2016?
    2015 $ million
    2016 $ million

  2. What was Arlington's 2016 free cash flow?

    $ million
  3. 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
  4. What was Arlington's 2016 EVA? Assume that its after-tax cost of capital is 10%. Round your answer to two decimal places.

    $   million

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

    $   million
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins as Cut ta copy. Σ AutoSum ー E ゴWrap Text в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard Alignment Number Cells F127 Formula Bar 126 127 128 129 130 131 a 132 133 134 135 136 137 138 139 140 141 142 143 b 144 i1 1 H İ STOCK DIV CURRENT ASSETS (CURRENT LIABILITIES NOTES PAYABLE) NET OPERATING WORKING CAPITAL NET OPERATING WORKING CAPITAL 2015 69000 (21750-5250) 2016 80975 -(25000-6700) 52500 62675 CHANGE IN NET OPERATING WORKING CAPITAL = 62675 52500 10175 CAPITAL EXPENDITURES NET FIXED ASSETS IN 2016DEPRECIATION FOR 2016 - NET FIXED ASSETS IN 2015 50000 + 6000-45000 = 11000 FREE CASH FLOW-EBIT (1-t) DEPRECIATION CAPITAL EXPENDITURE - CHANGE IN NET OPERATING WORKING CAPITAL 41000*(1-0.40) 6000 11000 10175- 9425 FREE CASH FLOW - 942 NAV HEDGE FUND MF | EV PE EPS DT, ABNORMAL APV ROSS deberk A MARGIN MONEY al tax 、PB ROPI EVA MVA AGED BUY 福 130% 09:58Home nert Page Layout Formulas Data Review View dd-Ins as Cut Σ AutoSum ー E ゴWrap Text copy ▼ в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard Alignment Number Cells H163 Formula Bar 145 C 146 147 148 149 150 151 152 153 154 d 155 156 157 158 159 160 161 e 162 163 il 1 I STOCK DIV NAV HEDGE FUND MF | EV PE EPS DİV . ABNORMAL STATEMENT OF SHAREHOLDERS EQUITY COMMON STOCK SHARES AMOUNT RETAINED EARNINGS SHAREHOLDERS EQUITY 82250 BALANCE, 12/31/15 2016 NET INCOME CASH DIVIDEND ADDITION TO RETAINED EARNINGS BALANCE, 12/31/16 400050000 32250 21120 7395 13725 95975 4000 50000 45975 CALCULATION OF EVA TOTAL INVESTED CAPITAL NOTES PAYABLE LONG TERM DEBT +EQUITY TOTAL INVESTED CAPITAL = 6700 + 10000 + 95975 = 112675 EVA = EBIT( 1-t)-(TOTAL INVESTED CAPITAL X AFTER TAX COST OF CAPITAL) EVA (41000(1-0.40))-(112675 X0.10)- 13332.50 MVA(MARKET PRICE X NO OF SHARES OUTSTANDING) BOOK VALUE OF EQUITY MVA (25 X 4000) 95975 = 4025 APV ROSS deberk A MARGIN MONEY al tax / PB ROPI EVA MVA AGED BUY 福 130% 09:58

Add a comment
Know the answer?
Add Answer to:
FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here....
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
  • 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...

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

  • Help Arlington Corporation's financial statements (dollars and shares are in milions) are provided here. Balance Sheets...

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

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

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

  • 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) 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,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) 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...

  • 3-7: Free Cash Flow Problem Walk-Through Free Cash Flow Bailey Corporation's financial statements (dollars and shares...

    3-7: Free Cash Flow Problem Walk-Through Free Cash Flow Bailey Corporation's financial statements (dollars and shares are in millions) are provided here Balance Sheets as of December 31 2014 2013 Assets $14,000 25,000 22,505 $61,505 49,000 $110,505 Cash and equivalents Accounts receivable Inventories $ 11,000 20,000 17,000 $ 48,000 45,000 $93,000 Total current assets Net plant and equipment Total assets Liabilities and Equity Accounts payable Notes payable Accruals 10,500 6,900 7,500 $24,900 10,000 34,900 $9,000 5,100 6,000 $ 20,100 10,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