Prepare Financial Forecast Using eVal Model
This project is closely aligned with the Course Outcomes and Finance Program Objectives. Completion of this project can be used as part of a portfolio to show potential employers the student is skilled at performing company valuations and financial statement analysis and can be included on the student’s resume.
Evaluation: The Assignment #2 is 20% of final course grade.
No more than 20% of the text of the project should be made up of quotes.
For this assignment, use the company that was previously assigned for you by your professor for all three class assignments.
Please note that if you missed the assignment #1 it is probably too late to submit the written report for the assignment #1. But you need to go to Content – Assignment #1, read the Project Description of the Assignment #1, download the Excel file with eVal model, and get the data for your company from the database. You have to complete the necessary steps described in the Assignment #1 to complete the model for the company assigned for you. Assignment #2 is a continuation of the Assignment #1.
The actual eVal Excel forecasting model must be submitted with the assignment.
Open eVal model and go to the “Forecasting Assumptions” worksheet. You will see 5 years of historical data on each of forecasting assumptions lines and 11 years of forecast data in shaded cells. The model calculated 5 years of historical data based on the company’s information you entered while completing the assignment #1. Your job is to fill in shaded cells of forecast assumptions.
Play with the model a bit to see how forecast changes.
YOUR SPECIFIC ASSIGNMENT IS:
You analysis should be based on your findings Step 1 in the Assignment #1. Remember, the part of the assignment #1 was STEP 1: Collecting information and data about the company and projections of the company’s future financial performance. What do your forecasts indicate for the future sales growth rates? How will the industry forecast affect future sales growth rates? What will be the firm-specific influences on sales growth rates forecast?
Justify the terminal growth rate. Note: it is difficult to justify terminal or long-term growth rates that exceed the long-term growth rate of the economy, e.g., about 3%; in the short-run, higher rates may be appropriate. It was the part of your assignment #1 (Step 2 of the assignment #1) to find the forecast of the U.S. economy growth rates (short-term and long-term). Please use your findings of the forecast of long-term growth rates of the U.S. economy to justify the terminal sales growth rates of the company. You should reference the source of the information about U.S. economy growth rates.
It is important to check that your terminal sales growth rate assumption is not greater than the cost of equity capital (See the number in cell B20 on “Model Summary” worksheet). If your terminal sales growth rate assumption is greater than the cost of equity capital, the model will not work, and you will get error messages.
Include an explanation of all other assumptions related to future operating performance including costs, margins, efficiency, capitalization, etc. that appears on the “Forecasting Assumptions” worksheet of eVal model for the next 11 years. Any changes in the assumptions should be explained and analyzed.
Note: We provided an Excel worksheet titled “Analysis of eVal Assumptions Forecast”. This worksheet is posted in Content – Assignment #2 and must be submitted with the assignment.
All assumptions used in the forecast need to be explained in the written analysis. An Excel worksheet “Analysis of eVal Assumptions Forecast” should be incorporated as a “table” in the written analysis.
Click on the Ratio Analysis and Cash flow Analysis tabs and see a complete ratios and cash flows implied with your assumptions. Do these forecasted ratios correspond to your finding and your views about the firm’s future? What do your forecasts imply for the future ratios and cash flows? How reasonable ratio and free cash flow analysis of the future financial statements are?
Please also include in your written report the analysis of the “Implied Return of Equity” that appears on the line 11 of the “Forecasting Assumptions” worksheet of the eVal model.
Organization, Presentation, Spelling, punctuation, and grammar totally are 15% of the assignment grade.
The discussion portion of the analysis should be about 5-7 pages in length (more is OK!), 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 (explains the purpose of the paper and provides an overview of the contents that follow) and then proceed to examine the four topics outlined in the previous section.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more