Question
free cash flow
1-3. Free Cash Flow; WACC; NPV (3 questions) 2016 2015 2017 2018 2019 2020 2021 M&A 1 2 Revenue 142343 152235 106364 144978 1
1. Calculate free cash flow in 2020 and 2021. Show your work. 1.1. FCF in 2020 (2 Points) 12. FCF in 2021 (2 Points) 2. Calcu
4.2. Real FCF in 2021 (2 points) 5. Calculate PV at 10 % of WACC (3 points) 6-7. IRR 6. You plan to purchase a Pizza Store fo
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1]

FCF = EBIT after tax - capital expenditure + depreciation and amortization - change in net working capital.

1.1]

FCF = 1275

Α 1 2 Revenue 3 EBIT after tax 4 Capex 5 Dep. & Amort. 6 NWC Change 7 FCF | 2020 205309 4314 2395 1045 1689 1275) fac =G3-G4+

1.2]

FCF = 2041

fac =H3-H4+H5-16 A 2 Revenue 3 EBIT after tax 4 Capex 5 Dep. & Amort. 6 NWC Change 7 FCF 2020 2021 205309 213635 4314 5835 23

2]

WACC = (weight of debt * after-tax cost of debt) + (weight of equity * cost of equity)

after-tax cost of debt = interest rate * (1 - tax rate) = 5% * (1 - 35%) = 3.25%.

weight of debt = bank loan / total capital = 1200 / (1200 + 800) = 0.60.

weight of equity = equity investment / total capital = 800 / (1200 + 800) = 0.40.

WACC = (0.60 * 3.25%) + (0.40 * 10%) = 5.95%.

3]

NPV = present value of FCF - initial investment

Present value of each FCF = FCF * discount factor.

Discount factor each year = 1 / (1 + WACC)year

NPV is 8451.

B13 fx =B11-B12 C 2015 2016 D 2017 E 2018 F 2019 А 1 2 Revenue 3 EBIT after tax 4 Capex 5 Dep. & Amort. 6 NWC Change 7 FCF 8

A 2015 2016 2017 2018 2019 2 Revenue 3 EBIT after tax 4 Capex 5 Dep. & Amort. 6 NWC Change 7 FCF н 2020 2021 205309 213635 43

Add a comment
Know the answer?
Add Answer to:
free cash flow 1-3. Free Cash Flow; WACC; NPV (3 questions) 2016 2015 2017 2018 2019...
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; wacc, npv. please show work 1-3. Free Cash Flow; WACC; NPV (3 questions)...

    free cash flow; wacc, npv. please show work 1-3. Free Cash Flow; WACC; NPV (3 questions) 2015 2016 2017 2018 2021 Revenue EBIT + After Tax Capital Expenditure Dep. & Amortization Net Working Capital Change Free Cash Flow 142343 152235 106364 452242252214 1577 1823 1088 437 575 622 144978 3214 1657 1026 2019 2020 M&A 186152 205309 36214314 2606 2395 1066 1045 213635 5835 3123 1087 0 3382 4808 6090 77854342 1689 1539 1044 903 1178 1758 Other information Your...

  • 1,275 2.041 -2,000 + (1+0.0595) * (Troosass -2,000 + 1203.39 + 18 17.31 = $1,020.7 4-5. Present Value; Inflation (2...

    1,275 2.041 -2,000 + (1+0.0595) * (Troosass -2,000 + 1203.39 + 18 17.31 = $1,020.7 4-5. Present Value; Inflation (2 questions) Assume the investment project in the previous question will generate $1,000 and $1,000 in free cash flows for two years (2020 (first year) and 2021 (Second year)), respectively. The forecasted annual inflation is 2 % a year. Show (4) the actual (or real) free cash flow (after inflation rate is considered) in 2020 (First Year) and 2021 (Second Year)....

  • Compute the Coca-Cola's free cash flow in 2019 using the Coca-Cola's cash flow statement in 2019....

    Compute the Coca-Cola's free cash flow in 2019 using the Coca-Cola's cash flow statement in 2019. Assume that only "Investments in property, plant and equipment" item in the investing activities section is operating-related. (Submit the number in million dollars E G H J K L M N o Р Q R A B с D 1 COCA-COLA BALANCE SHEET 2019 IN MILLION DOLLARS 2 Cash, Cash Equivalents & Short Term Investments 11,175 Current Liabilities 26,973 3 Receivables 3,971 Total Non...

  • 4) (3 pts) Assume that Company D's Free Cash Flow from assets has been estimated to...

    4) (3 pts) Assume that Company D's Free Cash Flow from assets has been estimated to be $80 million in 2020 and $90 million in 2021. The free cash flow is expected to grow at a constant rate of 5% after 2021. a) If the appropriate discount rate for Company D's FCF model is 7.7%, what is the horizon value at the end of 2021 for Company D using the Free Cash Flow Model? 2019 2020 2021 FCF $80 m...

  • Basic Stock Valuation: Free Cash Flow Valuation Model The recognition that dividends are dependent on earnings,...

    Basic Stock Valuation: Free Cash Flow Valuation Model The recognition that dividends are dependent on earnings, so a reliable dividend forecast is based on an underlying forecast of the firm's future sales, costs and capital requirements, has led to an alternative stock valuation approach, known as the free cash flow valuation model. The market value of a firm is equal to the present value of its expected future free cash flows: Market value of company FCF (1+WACC) + FCF (1+WACC)...

  • Please calculate the present value of Starbucks Corp. using it's free cash flow (FCF = cash...

    Please calculate the present value of Starbucks Corp. using it's free cash flow (FCF = cash flow from operating activities - cash flow from investment activities). Use it's cash flow statements from 2005 to 2019; Necessary Economic conditions are as follows: Discount rate 5%, Growth Rate 2%, Inflation Rate 2%. Provide 3 limitations of this method you found while applying it to Starbucks (e.g. limited application, assumptions on future, regression analysis, etc.) Be sure to provide rationales for why you...

  • Value of Operations: Constant FCF Growth EMC Corporation's current free cash flow of $400,000 and is...

    Value of Operations: Constant FCF Growth EMC Corporation's current free cash flow of $400,000 and is expected to grow at a constant rate of 4.5%. The weighted average cost of capital is WACC = 12%. Calculate EMC's estimated value of operations. Do not round intermediate calculations. Round your answer to the nearest dollar. Horizon Value of Free Cash Flows Current and projected free cash flows for Radell Global Operations are shown below. Actual Projected 2019 2020 2021 2022 $618.520 $679.200...

  • The free cash flow(in millions) shown below are forecast by Parker& Sons.If the weighted average cos...

    The free cash flow(in millions) shown below are forecast by Parker& Sons.If the weighted average cos of capital(WACC) is 11% and FCF is expected to grow at a rate of 5% after 2years.What is the year 0(Zero) value of operations in millions? Assume that the ROIC isexpected to remain constant in Year 2 and beyond.(and do not make any half year adjustments) Year            1              2 FCF            -$50       $100

  • eBook Horizon Value of Free Cash Flows Current and projected free cash flows for Radell Global...

    eBook Horizon Value of Free Cash Flows Current and projected free cash flows for Radell Global Operations are shown below. Actual 2018 $611.74 2019 $672.42 Projected 2020 $712.47 2021 $762.34 Free cash flow (millions of dollars) Growth is expected to be constant after 2020, and the weighted average cost of capital is 11.25%. What is the horizon (continuing) value at 2021 if growth from 2020 remains constant? Do not round intermediate calculations. Enter your answer in millions. For example, an...

  • Chapter 9/10/11 , 2019 Based upon the following facts calculate the Weighted Average Cost of Capital...

    Chapter 9/10/11 , 2019 Based upon the following facts calculate the Weighted Average Cost of Capital (WACC) for Student Success Corporation (SSC): PART 1 – WACC  Tax rate = 40%  Debt Financing: $10,000 Face Value 10-Year, 5% Coupon, Semiannual Non-Callable Bonds Selling for $11,040 New bonds will be privately placed with no flotation cost.  Common Stock: Current Price $40; Current Dividend = $3.00 and Growth Rate = 5%.  Common Stock: Beta = 1.1; Risk Free Rate...

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
Active Questions
ADVERTISEMENT