Prepare dfcf stock valuation

Assignment Help Financial Accounting

Reference no: EM131545404

The name of the company to evaluate is COSTCO.

Prepare DFCF Stock Valuation (Discounted Free Cash Flow Stock Valuation) and EVA/MVA Analysis

Students may elect to use the eVal Financial Forecasting Model or Prof. Stevens' Excel Discounted Free Cash Flow Valuation Model for the DCF Stock Valuation part of this assignment. If the eVal model is selected, make sure that financial information is available for the company that is selected for the assignment (See: https://www.lundholmandandsloan.com). Similarly, if Prof. Stevens' model is used for the assignment make sure that financial information is available (e.g., Yahoo Finance, etc.). (Note: Alternatively, the ValuePro.net model may be used for the DCF valuation but the final score for the assignment will be reduced by 20% if that alternative is selected.)

The actual Excel forecasting model (either eVal or Prof. Stevens' model) must be submitted with the assignment.

The instructor's EVA/MVA Excel Model must be used for the EVA/MVA analysis. That model must be submitted with the assignment, too.

Assignment: 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 either: (a) the eVal Excel Model and the projections developed in Week 2, or, (b) Professor Stevens' Excel Financial Forecasting Model.Both of the models have an embedded worksheet that accommodates the Discounted Free Cash Flow stock valuation.

Make sure that the stock valuation model is submitted with the written analysis.

Discuss, interpret and explain the assumptions (variables) used in the analysis.

Discuss, interpret and explain the results of the analysis. This involves comparing the intrinsic value of the company's stock valuation to the current stock price and carefully explaining any differences.

2. EVA & MVA Analysis -
Prepare an analysis of EVA and MVA for the selected company. An Excel model is provided by the instructor. Explain the results.

Make sure that the EVA/MVA Excel model is submitted with the written analysis.

CONTENT OF THE ANALYSIS

The analysis associated with the two parts of 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 discounted free cash flow stock valuation and EVA/MVA analysis. All assumptions used in preparing the projections for the project need to be presented and 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.

Reference no: EM131545404

Questions Cloud

Maximum bid price that the investor would offer on the land : what is the maximum bid price that the investor would offer on the land?

Briefly summarize the literature you reviewed : Begin by reading the American Association of Colleges of Nursing's (AACN) position statement on nursing research.

What are prevalent attitudes toward education : What are prevalent attitudes toward education? What role does religion play in the culture? What are the intergenerational issues of families in this culture?

Dilemma of trust existing between agents and constituents : Explain and evaluate the dilemma of trust existing between agents and constituents. How effective are the use of agents in a negotiation

Prepare dfcf stock valuation : Prepare DFCF Stock Valuation and EVA/MVA Analysis - Explain the results of the analysis and Prepare an analysis of EVA and MVA for the selected company.

Explain the development of cardiovascular diseases : For each risk factor, briefly discuss what you might include in an educational plan for your patient who has yet to develop heart disease.

What is the expected increase in the share price of the firm : What is the expected increase in the share price of the firm? How many shares would the firm repurchase?

What is the equipment after-tax salvage value : What is the equipment's after-tax salvage value?

A brief description of two ethical challenges : A brief description of two ethical challenges related to record keeping and/or reporting when the legal system is involved.

Reviews

len1545404

6/27/2017 1:34:43 AM

5. 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 discuss future MVA results and what variables can affect those results either positively or negatively. Virtually no effort to explain the data used in the MVA valuation analysis or to interpret the results; or, section not completed. 6. Writing, Grammar, Spelling, & Presentation - Logical and Smooth Flowing Transitions and Relationships Among Sections of the Written Report. Avoidance of Personal Pronouns; Avoidance of Referring to Company as They, Their, or Them; etc. Appropriate use of reference citations. Paper is poorly written and presented; not worthy of a passing evaluation. May have failed to use appropriate subheadings for the assignment.

len1545404

6/27/2017 1:34:39 AM

3. 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. Virtually no effort to examine and explain the results of the analysis; or, section not completed. 4. Explanation of the Data Used for the EVA 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. Virtually no effort to explain the data used in the EVA valuation analysis or to interpret the results; or, section not completed.

len1545404

6/27/2017 1:34:14 AM

1. Introduction - Provide a brief overview of the assignment and include a preview of the contents of the report. Introduction is not presented or undeserving of credit. 2. 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. Virtually no effort to explain the variables used in the DCF valuation analysis; or, section not completed. 3. 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. Virtually no effort to examine and explain the results of the analysis; or, section not completed.

len1545404

6/27/2017 1:33:48 AM

the name of the company to evaluate is COSTCO. and the analysis part of the assignment has to be 7 pages in length.please if you need more information about the assignment contact me asap.

Write a Review

Required(*) Message

Financial Accounting Questions & Answers

Transactions in the capital projects fund

Geneva County authorized the issuance of bonds and contracted with the Chessie Construction Company (CCC) to build a new convention center. During 2013, 2014, and 2015, the county engaged in the transactions that follow. All were recorded in the coun..

Estimate of inventory amounts immediately preceding the fire

Martinez Lumber Company handles three principal lines of merchandise with these varying rates of gross profit on cost. Lumber 25% Millwork 30% Hardware and fittings 40% On August 18, a fire destroyed the office, lumber shed, and a considerable portio..

Show activity based costing

Each ticket entitles the visitor to attend the IMAX giant screen sense around movie as well as the traditional planetarium.

Cost to be allocated to the building in accounting records

A company purchased property for $105,000. The property included a building, equipment and land. The building was appraised at $64,000, the land at $46,000, and the equipment at $19,000 for a total appraised value of $129,000. What is the amount of c..

Does the firm have positive or negative financial leverage

Compute the profit margin on sales ratio, the return on equity and the return on assets, rounding calculations to two decimal places. Does the firm have positive or negative financial leverage? Briefly explain.

Describe characteristic of process costing

Which of the following does not describe a characteristic of process costing? All units of production receive precisely the same amount of material, labor, and overhead.

How much is net cash flow from financing activities

During 2011, Tommy's Toys reported the following: short-term borrowings of $419 million; long-term borrowings of $147 million; long-term debt repayments of $45 million; interest paid, $128 million; and treasury shares repurchased $632 million.

Illustrate what is the total cost of the ending inventory

FIFO, LIFO Costs Under Perpetual Inventory System. What is the total cost of the ending inventory according to FIFO? Illustrate what is the total cost of the ending inventory according to LIFO?

Journalize the annual adjusting entries that were made

Journalize the annual adjusting entries that were made.- Prepare an income statement and a retained earnings statement for the year ended December 31.

Agreements make certain demands on the business

Lindsey Contractors' borrowing agreements make certain demands on the business. Lindsey's Long-Term Debt may not exceed Stockholder's Equity, and the current ratio may not fall below 1.50. If Lindsey fails to meet this requirement, the company's lend..

How many unit must be sold each month to make monthly profit

How many units must be sold each month to make a monthly profit of $10,962? Compute the total fixed costs to be covered if more than 30,900 units are produced.

Shares of preferred stock issued

As of January 2, 2012, The Triple J Company had (i) 12,000 shares of preferred stock issued, with a par value of $7, an annual dividend of $2, and 3,000 shares in the treasury, and (ii) 24,000 shares of common stock issued, with a stated value of $5 ..

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!

Submit Assignment

User Account

All Pages