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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money 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