Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. solve using excel abc's the most recent free cas

Solve using excel ABC's the most recent free cash flow (FCF.) is $200...

70.2K

Verified Solution

Question

Accounting

image
Solve using excel
ABC's the most recent free cash flow (FCF.) is $200 million. The free cash flow is expected to grow at a rate of 40 percent in next year and 20 percent in the second year. After two years, it is expected to grow forever at a constant rate of 5 percent. The cost of common stock (rs) is 12% and the weighted average cost of capital (WACC) is 8%. ABC's balance sheet shows $10 million in short-term investments (marketable securities) that are unrelated to operations and $10 million in minority investment in another company. The balance sheet also shows $100 million in debt, $50 million in preferred stocks, and $250 million in common stocks. If the company has 40 million shares of common stocks, what is your best estimate for the stock price per share today? Assume that company's book values of debt and preferred stocks are very close to the market values. Using Excel, calculate ABC's stock price using FCF based valuation model and using "Two Way Data Table" of the Excel, show the sensitivity of the stock prices to the growth rate and the discount rate. (Use the stable growth rate from 2% to 8% in 1% increment and use a discount rate from 5% to 11% in 1% increment.)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students