Question

3-7: Free Cash Flow Problem Walk-Through Free Cash Flow Bailey Corporations 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 30,100 Total current liabilities Long-term bonds Total debtCommon stock (5,000 shares) 40,000 35,605 75,605 $110,505 40,000 22,900 62,900 $93,000 Retained earnings Common equity Total assets Income Statement for Year Ending December 31, 2014 $202,000 150,000 52,000 8,000 $ 44,000 7,550 $ 36,450 14,580 s 21,870 9,165 Sales Operating costs excluding depreciation and amortization EBITDA Depreciation & amortization EBIT Interest EBT Taxes (40%) Net income Dividends paid Enter your answers in millions. For example, an answer of $25,000,000,000 should be entered as 25,000 a. What was net operating working capital for 2013 and 2014? 2013 $33000 million 2014 $43505 millionb. What was Baileys 2014 free cash flow? million c. Construct Baileys 2014 statement of stockholders equity Common Stock Retained Total Stockholders Earnings Equity Shares Amount Balances, 12/31/13 million $ milion $ milion $ million 2014 Net Income million Cash Dividends million Addition (Subtraction) to retained earnings million Balances, 12/31/14 mllion $ mllion $ million $ million d, what was Baileys 2014 EVA? Assume that its weighted average cost of capital is 10%. Round your answer to the nearest cent. million e. What was Baileys MVA at year-end 2014? Assume that its stock price at December 31, 2014 was $20 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 Cut Σ AutoSum ー E ゴWrap Text aCopy B า 프 . Ej- a-Δ. : rーー 逻锂函Merge & Center. $ % , to: conditional Format . Cell Insert Delete Formsat Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard Alignment Number Cells Edting 0 34 35 36 37 38 39 40 41 42 43 BAILEY CURRENT ASSETS (CURRENT LIABILITIES NOTES PAYABLE) NET OPERATING WORKING CAPITAL= NET OPERATING WORKING CAPITAL 2013 48000 (20100-5100)- 2014 61505 24900 6900)- 33000 43505 CHANGE IN NET OPERATING WORKING CAPITAL 43505 33000 10505 CAPITAL EXPENDITURE- NET FIXED ASSETS IN 2014 DEPRECIATION FOR 2014 - NET FIXED ASSETS IN 2013 49000 + 8000-45000 12000 FREE CASH FLOW-EBIT(1-t) DEPRECIATION CAPITAL EXPENDITURE - CHANGE IN NET OPERATING WORKING CAPITAL 45 46 47 48 49 44000*(1-0.40) + 8000-12000-10505- 11895 FREE CASH FLOW- 11895 STATEMENT OF SHAREHOLDERS EQUITY RETAINED SHAREHOLDERS EVA MVA LEVERAGED BUY SWAP distress BRIGHAN CAP GAIN 51 COMMON STOCK i1 1 H I ( EV PE EPS DIV ABNORMAL . APV ROSS i deberk ( MARGIN MONEY al tax . PB ROPİ 福 130% 08:01 09-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text aCopy B า 프 . Ej- a-Δ. : rーー 逻锂函Merge & Center. $ % , to: conditional Format . Cell Insert Delete Formsat Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard Alignment Number Cells Edting 0 STATEMENT OF SHAREHOLDERS EQUITY 50 51 52 53 COMMON STOCK SHARES AMOUNT RETAINED EARNINGS SHAREHOLDERS EQUITY BALANCE, 12/31/13 2014 NET INCOME CASH DIVIDEND ADDITION TO RETAINED EARNINGS BALANCE, 12/31/14 500040000 22900 21870 9165 62900 56 57 58 59 60 61 62 63 64 65 12705 75605 5000 40000 35605 CALCULATION OF EVA TOTAL INVESTED CAPITAL-NOTES PAYABLE + LONG TERM DEBT + EQUITY TOTAL INVESTED CAPITAL = 6900 + 10000 + 75605 92505 EVA- EBIT(1-t) (TOTAL INVESTED CAPITAL X AFTER TAX COST OF CAPITAL) EVA (44000(1-0.40)) - (92505 x 0.10)- 17149.50 MVA = MVA- (MARKET PRICE X NO OF SHARES OUTSTANDING)-BOOK VALUE OF EQUITY (20 X 5000) - 75605-24395.00 67 i1 1 İ (EV PE EPS DIV ABNORMAL . APV ROSS i deberk ( MARGIN MONEY al tax . PB ROPİ EVA MVA LEVERAGED BUY SWAP distress BRIGHAN CAP GAIN 福 130%

Add a comment
Know the answer?
Add Answer to:
3-7: Free Cash Flow Problem Walk-Through Free Cash Flow Bailey Corporation's financial statements (dollars and shares...
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 $  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...

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

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

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

  • sidual who is working on hung her Fundamental Concepts in Financial Management 3-17 FREE CASH FLOW...

    sidual who is working on hung her Fundamental Concepts in Financial Management 3-17 FREE CASH FLOW Financial information for Powell Panther Corporation is shown here. Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2015 2014 51.0000 $1.200.0 1.020,0 $ 1800 300 51500 250 Sales Operating costs excluding depreciation and amortization EBITDA Depreciation & amortization Earnings before interest and taxes (EBIT) Interest Earnings before taxes (EBT) Taxes (40%) Net income $ 1500 21.7 $ 1283 513...

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