Dcf forecast

Assignment Help Finance Basics
Reference no: EM133123099

Part 1: DCF Forecast

1. Select a publicly held company of your choice. MICROSOFT

2. Perform a DCF with Terminal Value (5 years only) to determine your estimate of the value of the company.

3. Make sure that you state your assumptions on the same excel spreadsheet.

4. For your cash flow numbers use the formula used in the text, page 548: NOPAT + Depr - CAPEX - Increase in NWC

5. How does your calculation compare to the current share price?

6. Try to explain WHY your numbers match or do not match the current market value

Part 2: Market Multiples to Determine Terminal Value

1. Then, determine the Enterprise Value/EBIT.

2. Compare it to two competitors' EV/EBIT

Research in webs like yahoo finances for the numbers

Reference no: EM133123099

Questions Cloud

Will mary be successful in achieving her goal : Will Mary be successful in achieving her goal of $75,000.00 by the end of Year 10? Why or why not, explain your answer
What is diversification : 1..The two major sources of long-term capital for a corporate organization are Debt and Equity. Bonds are the major instruments of debt for companies. How are b
What is the weighted average cost of capital : (a) A firm has a $250,000 (nominal value) bond issue outstanding that is selling at 92 percent of face value. The coupon rate is 8% and the yield-to-maturity i
Compute the discount rate : Compute the discount rate. (Do not round intermediate calculations. Input your answer as a percent rounded up to the nearest whole percent.)
Dcf forecast : 1. Select a publicly held company of your choice. MICROSOFT
How much interest will have been earned : Suppose he leaves the accumulated contributions for another 6 years in the RRSP at 3.4% compounded monthly. How much interest will have been earned
Discuss the procedures for the preservation of evidence : Discuss the procedures for the preservation of evidence; be sure to connect this work with the chain of custody. Describe consequences
What is the yield on this 5-year corporate bond : What is the yield on this 5-year corporate bond? Round your answer to two decimal places.
What amount be reported as appropriated retained earnings : Nancy Company issued 200,000 shares of P5 par value at P10 per share. What amount should be reported as appropriated retained earnings at year-end

Reviews

Write a Review

Finance Basics Questions & Answers

  Company with an international company

a. What risks are inherent in companies that grow rapidly and how can those risks be mitigated?

  What is the value at exercise of the option

When Allen waited an additional two weeks, the stock price climbed to $510. Allen, feeling a bit of anxiety, decides to exercise the option and realize some gains.-In exercising this option, what price is Allen getting the stock for?

  Main elements to achieve their entrepreneurial goals

Successful entrepreneurs follow a multi-step process that is based on four main elements to achieve their entrepreneurial goals. A clear understanding of the entrepreneurial process is an important step in understanding the functions of a business..

  Why would a corporation have multiple stock share classes

Why would a corporation have multiple stock share classes? Explain

  The bid by walmart raises a number of interesting issues

in mid-january 2003 walmart the u.s. leading retailer announced a bid for safeway plc the fourth largest supermarket

  Explain the inverse relationship between bond prices

Explain the inverse relationship between bond prices and yield and define yield to maturity.

  Compute the net present value if cost of capital is given

The Horizon Company will invest $99,000 in a temporary project that will generate the following cash inflows for the next three years.

  Crypto venture firm dragonfly

Provide in memo format the new venture capital Crypto Venture Firm Dragonfly. Describe the drivers of the transactions (what is the investment objective, who ar

  Estimate the company wacc-marshall inc

To estimate the company's WACC, Marshall Inc. recently hired you as a consultant. You have obtained the following information. (1) The firm's noncallable bonds

  What does duration measure

What does duration measure? How is duration different from maturity of a bond?

  Find hedge exchange rate risk

Today is August 20, the CFO of a corporation (based in Italy) knows that the company will receive $5 million USD in four months, will receive 2.5 million pounds

  What is the npv of the project if required return is given

What is the IRR for this project? If the required return is 10 percent, should the firm accept the project? What is the NPV of this project?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd