Prepare a dcf valuation of the selected company

Assignment Help Corporate Finance

Reference no: EM131099453

DCF Valuation and EVA/MVA Analysis

Using the company that was selected for the class, there are two parts to this assignment:

1. DCF Company Valuation -

Prepare a DCF Valuation of the selected company using the eVal model and the projections developed in Week 2.

Compare the intrinsic value of the company's stock (valuation) compared to the current stock price.

Interpret and explain the results.

2. EVA & MVA Analysis -

Prepare an analysis of EVA and MVA for the selected company. Excel models are provided by the instructor. Explain the results.
The analysis associated with the assignment needs to include:

1. Explanation of the Variables Used in the DCF Valuation - Explain and justify all of the variables used in the DCF valuation. These would include, but are not limited to, the growth rates, capitalization structure, cost of capital components, WACC, etc.

2. Explanation and Interpretation of DCF Valuation Results - Explain the results of the DCF analysis. This should include an analysis of any difference between the results of the DCF analysis and the current stock price.

3. Explanation of the Data Used for the EVA Analysis and Interpretation of Results- Present the results of the EVA analysis and explain what they mean. The analysis should discuss future EVA results and what variables can affect those results either positively or negatively.

4. Explanation of the Data Used for the MVA Analysis and Interpretation of Results- Present the results of the MVA analysis and explain what they mean. The analysis should explain a discussion of future MVA results and what variables can affect those results either positively or negatively.

Writing Instructions

The discussion portion of the analysis should be three to five pages in length, double spaced, and should employ APA style and format for reference citations. Supporting data (e.g., figures, tables, etc.) and references should be submitted limited to four separate attachments in an appendix after the written portion of the paper.

The paper should begin with a short introduction and then proceed to examine the four topics outlined in the previous section.

The subheadings used in the paper should be:

1.Introduction
2. Explanation of the Variables Used in the DCF Valuation
3. Explanation and Interpretation of DCF Valuation Results

(Including comparison and explanation of differences between the current stock price and results of the DCF valuation.)

4. Explanation of the Data Used for the EVA Analysis and Interpretation of Results
5. Explanation of the Data Used for the MVA Analysis and Interpretation of Results

Completeness of analysis: The analysis must demonstrate a solid understanding of capital budgeting and the analysis of corporate investments. All assumptions used in preparing the projections for the project need to be thoroughly explained.

Organization: The paper should be well-organized and follow a logical pattern of analysis and discussion.

Presentation: Papers should meet professional business standards and meet APA formatting requirements.

Spelling, punctuation, and grammar: There should be few errors in grammar and punctuation. All sentences must be complete and well-structured.

Submission and Format:The completed paper is to be submitted to the "Gradebook" location designated for the assignment. The paper must be in Word format otherwise no credit is earned for the assignment.

The paper is also to be submitted to the Online Classroom. This will allow students to examine and discuss the various projects.

USING EVAL FOR THE DCF STOCK VALUATION

To proceed with the Discounted Cash Flow valuation of the company, it will be necessary to update (and carefully explain) the Valuation Parameters in eVal. There is a separate worksheet titled "Valuation Parameters" (tab at the bottom of eVal Excel program).

1. It will be necessary to estimate the cost of equity capital. For that estimate, use the CAPM. Today, the risk free rate is around 2% to 3%. The equity risk premium should be between 5% and 6% (the historical average). To complete the estimate, find the beta of the stock (e.g., Yahoo Finance).

2. Let the value of contingent claims on common equity remain at 0.

3. Use today's date for the date of the valuation.

4. Let the value of the dilution factor for splits remain at 1.0.

5. For the cost of net debt use either the average cost of outstanding debt or use an estimate of what you think it would cost to issue new debt. Explain the assumption.

6. Enter the cost of preferred stock if any is outstanding, otherwise enter 0%.

7. For the cost of minority interest use the same percentage as you use for the WACC.

8. The model instructs you to adjust the WACC so that the two equity values are approximately equal.

ESTIMATED PRICE PER SHARE

The estimated price per share (intrinsic value) then appears in the Green-coded cell at the top of the worksheet.

WHAT TO DO IF ESTIMATED STOCK PRICE IS SIGNIFICANTLY DIFFERENT FROM CURRENT STOCK PRICE

If you find that the estimated stock price is unreasonable and can't be explained adequately, then you may want to adjust some of the forecasting assumptions that were used in developing the initial forecast.

Attachment:- Attachments.rar

Reference no: EM131099453

Questions Cloud

Announcements concerning its common stock today : Angelina's made two announcements concerning its common stock today. First, the company announced that its next annual dividend has been set at $2.26 a share. Secondly, the company announced that all future dividends will increase by 4% annually..

Rate of return is built into the annuity : Your girlfriend just won the Florida lottery. She has the choice of $16,600,000 today or a 20-year annuity of $1,050,000, with the first payment coming one year from today. What rate of return is built into the annuity?

Perform a swot analysis on your client product : Product - Kellogg's Special K Cereal. Perform a SWOT analysis on your client's product. Develop a survey of at least 5 questions to probe for customer feedback

Pay particular attention to evidence that supports problem : Write a paper (1,500-2,000 words) in which you analyze and appraise each of the (15) articles identified in Topic 1. Pay particular attention to evidence that supports the problem, issue, or deficit, and your proposed solution.

Prepare a dcf valuation of the selected company : Prepare a DCF Valuation of the selected company using the eVal model and the projections developed in Week 2. Compare the intrinsic value of the company's stock (valuation) compared to the current stock price.

Analysis of relationship between leadership and management : Write a paper that provides a definition of leadership and an analysis of the relationship between leadership and management as well as an evaluation of the key attributes of a project manager

University of florida marketing graduate : Marie Snell recently inherited some bonds (face value $200,000) from her father, and soon thereafter she became engaged to Sam Spade, a University of Florida marketing graduate.

Data on the horizontal line : The data that I want to reflect in my excel spreadsheet on Joe's Fly by night is not reading and placing the vertical value line properly. For example, I want the years to show as the vertical value but it is putting that data on the horizontal l..

Estimate standard error of the proportion of defective parts : Estimate the standard error of the proportion of defective parts and construct the 99% confidence interval for the proportion of defective parts.

User Account

All Pages