I need an expert to help this paper on company coscto and original and do 2 excels as required. I need in 6-7 hrs.

I will tip 80$ for timely and original work.

Name of Company Directions: Enter data in the yellow-coded cells. Do not cut and paste or otherwise make changes to the Excel spreadsheet. Estimate Basic Information & Growth Rates Initial Free Cash Flow Initial Period Annual Growth Rate Estimate Terminal Annual Growth Rate Estimate How Long is Initial Growth Period (Years) Number of Shares of Common Stock Tax Rate Estimated During Future Periods Total Interest-Bearing Permanent Debt Estimated During Period Total Assets $0.00 See Note 1 See Note 2 Years 0 Up to 20 Be very careful with entering the Number of Shares. Make sure that the decimal point is in the proper location. Estimate Free Cash Flow From Current Sales ($) Estimate Future Annual Sales ($) From Current EBIT Margin (%) Estimate Future EBIT Margin (%) EBIT Plus - Future Annual Estimated Depreciation Expense Less - Future Annual Estimated Capital Expenditures Less - Net Annual Estimated Change (Invest.) in Working Capital Equals Operating Cash Flow Less Taxes Equals Free Cash Flow Estimate Weighted Average Cost of Capital Cost of Equity Capital Before Tax Cost of Debt Estimated During Future Periods Market Risk Premium (RM-RF) Estimated During Future Periods Debt Ratio (Total Debt/Total Assets) Estimated During Future Periods Beta Estimated During Future Periods Risk-free Rate (Use L-T Treasury Rate) Estimated During Future Periods = Weighted Average Cost of Capital Year Free Cash Flow Terminal Value Total FCF Discounted FCF Net Present Value of FCF Net Present Value of FCF Minus Debt Per Share Value 0 1 $0 2 3 Computer Calculates $0.00 Computer Calculates $0.00 $0.00 $0.00 Computer Calculates Computer Calculates - See Note 3 Computer Calculates 7.450% Computer Calculates 7.000% #DIV/0! Computer Calculates 2.700% #DIV/0! Computer Calculates 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Note: Terminal Growth Rate Must be less than WACC for projections of 1 or more years; for valuations based on 0 years of projections, WACC must be > Growth Rate FREE CASH FLOW VALUATION MODEL #DIV/0! Notes: 1. Terminal Value is growing perpetuity of final year's Free Cash Flow [(FCF) / (WACC - Growth Rate)] 2. If Number of years of projected growth is "0", then Net Present Value of Free Cash Flows is growing perpetuity of Free Cash Flow [(FCF*(1+Growth Rate) / (WACC - Growth Rate) 3. Taxes are determined by multiplying the Tax Rate times EBIT. CALCULATION OF EVA AND MVA Name of Company Short-Term Debt From Balance Sheet - End of Previous Year Long-Term Debt From Balance Sheet - End of Previous Year Preferred Stock From Balance Sheet - End of Previous Year Common Stock Paid-In Capital Retained Earnings Total Invested Capital Price of Stock Number of Shares Outstanding EBIT Tax Rate Less: Taxes Equals NOPAT Rate on Short-Term Debt Rate on Long-Term Debt Market Risk Premium Risk-Free Rate (L/T Treasury bond) Debt to Equity Ratio Beta of Stock Cost of Preferred Stock Cost of Equity Capital WACC Preferred Dividend $ per share $0.00 From Balance Sheet - End of Previous Year From Balance Sheet - End of Previous Year From Balance Sheet - End of Previous Year $0.00 Computer Calculates Current Market Data Yahoo Finance From Income Statement - End of Previous Year Calculate from Income Statement (Taxes / Income Before Tax From Income Statement - End of Previous Year $0.00 Computer Calculates From Form 10K Report or Current S-T Bond Data From Form 10K Report or Current L-T Bond Data Normally 5% - 6%; Use 5.5% Current Rate on 10yr. Treasury Bond #DIV/0! Computer Calculates Yahoo Finance 0.00% Computer Calculates 7.450% % S-T Debt #DIV/0! #DIV/0! Analysis is Computer Generated CALCULATION OF EVA - ECONOMIC VALUE ADDED EBIT $0.00 Equals: Invested Capital Equals: NOPAT (Net Beginning of Less: Taxes Operating Profit After Tax) Period $0.00 $0.00 $0.00 Return on Invested Capital #DIV/0! #DIV/0! CALCULATION OF MVA - MARKET VALUE ADDED WACC #DIV/0! #DIV/0! Market Value of Equals: Market Minus: Total Equity Plus: Market Value of Debt Value of Firm Invested Capital $0.00 $0.00 $0.00 $0.00 Year ance Sheet - End of Previous Year Preferred Stock Price per share $0.00 ance Sheet - End of Previous Year ance Sheet - End of Previous Year ance Sheet - End of Previous Year ome Statement - End of Previous Year from Income Statement (Taxes / Income Before Taxes) ome Statement - End of Previous Year m 10K Report or Current S-T Bond Data m 10K Report or Current L-T Bond Data 5% - 6%; Use 5.5% Rate on 10yr. Treasury Bond % L-T Debt % Equity % Preferred Stock #DIV/0! #DIV/0! #DIV/0! EVA (NOPAT Capital Charge Capital Charge) #DIV/0! #DIV/0! (NOPAT/Inv. Capital) Equals: MVA $0.00 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: http://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 Evaluation:12.5% of final course grade. 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 papershould 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. GRADING RUBRIC FOR DCF & MVAEVA ANALYSIS Student: Description of Evaluation Failing, Passing, but undeserving below of credit standard Satisfactory, meets essential requirements Superior Work Work of and clearly Distinction above average Related Grade F D-, D, D+ C-, C, C+ B-, B, B+ A-, A, A+ 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. Only a superficial effort to develop the introduction. Satisfactory presentation of the introduction. Superior Distinctive and presentation of very thorough the presentation of introduction this first and clearly section. above average. 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. Marginally passing development and presentation of the description of the variables used in the DCF analysis. May be some significant weaknesses in the overall description and related financial data. Satisfactory development and presentation of the description of the variables used in the DCF valuation analysis. Superior development and presentation of the description of the variables used in the DCF valuation analysis. The analysis is understandabl e and the cash flows seem to be relatively realistic. Distinctive development and presentation of the description of the variables used in the DCF analysis. The assumptions and the cash flows are clear, realistic, and understandable . 3. Explanation and Interpretation of DCF Virtually no effort to examine and explain Passing effort to examine the results of the analysis. Satisfactory effort to examine the results of the Superior and reasonably comprehensive effort to Distinctive and comprehensive effort to explain and interpret Category Required Topics 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. the results of the analysis; or, section not completed. May be some errors or inconsistencie s with the explanation and interpretation of the results. analysis. May be some minor errors or inconsistencies . explain and interpret the results of the valuation analysis. the results of the valuation analysis. The analysis is careful, comprehensive, detailed, and consistent. 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. Marginally passing development and presentation of the data used in the EVA analysis and interpretation of the results. May be some significant weaknesses in the overall description and interpretation of the financial data and results. Satisfactory development and presentation of the data used in the EVA analysis and interpretation of the results. May be some weaknesses in the description of the data and interpretation of the results. Superior development and presentation of the description of the data used in the EVA analysis and interpretation of the results. The analysis is understandabl e and the results seem to be relatively realistic. Distinctive development and presentation of the description of the data used in the EVA analysis and interpretation of the results. The assumptions and results are clear, realistic, and understandable . 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. Marginally passing development and presentation of the data used in the MVA analysis and interpretation of the results. May be some significant weaknesses in the overall description and interpretation of the financial data and results. Satisfactory development and presentation of the data used in the MVA analysis and interpretation of the results. May be some weaknesses in the description of the data and interpretation of the results. Superior development and presentation of the description of the data used in the MVA analysis and interpretation of the results. The analysis is understandabl e and the results seem to be relatively realistic. Distinctive development and presentation of the description of the data used in the MVA analysis and interpretation of the results. The assumptions and results are clear, realistic, and understandable . 6. Writing, Grammar, Spelling, & Paper is poorly written and Passing written presentation; Satisfactorily written presentation Superior written presentation Distinctively written presentation PresentationLogical 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. presented; may have not worthy major of a passing weaknesses. evaluation. May have failed to use appropriate subheading s for the assignment. with some weaknesses. with very with no obvious limited minor weak weaknesses, omissions, etc