Question
The company i have chosed is Walmart There are no numbers, it is a research project.. Part 2 Overview: The final project for this
The company i have chosed is " Walmart" There are no numbers, it is a research project..
Part 2
Overview: The final project for this course is the creation of a financial analysis and planning report, including a presentation to the executive management team. For Milestone Two, submit a draft of your financial projections (Component 1: Section III).
Project the next three years financial statements and free cash flows. Using the projected cash flows, use the cost of capital as a discounting rate to obtain the present value of the firm. Analyze the projections compared to the current market value of the firm.
Prompt: Milestone Two should contain the following sections:
III. Projections: Based on the companys financial statements, your analysis, and any additional evidence, project the companys performance for the next three years. Are there any areas of concern? Is the company in good financial shape for moving forward? Discuss a best-case, worst-case, and most likely scenario, including a sustainable growth rate for sales based on existing financial statements and any macroeconomic and financial market conditions that might impact the firms strategic objectives. You must thoroughly address the assumptions behind your predictions, supported by spreadsheet calculations. At a minimum, your analysis must cover:
A. Weight of equity
B. Weight of debt
C. Cost of debt
D. Cost of equity
E. Tax rate
F. Value of the companys stock compared to your forecasted value and free cash flow
Guidelines for Submission: Your draft must contain all of the elements listed above. It should be at least 5 pages in length (excluding the title page, references, supporting calculations, and appendices) and should follow APA guidelines. You must include calculations and appropriate graphs, tables, references, and other appendices as needed to support your written analysis. Cite your sources within the text of your paper and on the reference page.
Part 4
Overview: The final project for this course is the creation of a financial analysis and planning report, including a presentation to the executive management team. For Milestone Four, submit a draft of your executive summary (Component 1: Section I) and recommendations (Component 1: Section V).
From the financial analysis and planning report, provide a summary of your analysis. You will also provide recommendations to the firms executives. The recommendations should be based both on your analysis and current market conditions.
Prompt: Milestone Four should contain the following critical elements:
I. Executive Summary: Briefly provide the bottom line of your financial analysis and key recommendations to a busy executive audience.
V. Recommendations: Provide high-level, strategic recommendations for your company for the upcoming three years. Based on your analysis and interpretations, where are there opportunities for growth? What risks does the company face, and how might it mitigate them? Apply relevant principles of asset allocation and portfolio diversification in making your suggestions and assess the risks and returns for each individually as well as the group of suggestions as a whole. You should also consider how changing market conditions might affect your recommendations and how the recommendations fit with the companys investment needs and priorities.
Guidelines for Submission: Your draft must contain all of the elements listed above. It should be at least 2 pages in length (excluding the title page, references, supporting calculations, and appendices) and should follow APA guidelines. You must include calculations and appropriate graphs, tables, references, and other appendices as needed to support your written analysis. Cite your sources within the text of your paper and on the reference page.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started