MBA520 University of Missouri Columbia Walmart Company Analysis I need an in-depth analysis of a company (Walmart) as outlined in the instructions attached

MBA520 University of Missouri Columbia Walmart Company Analysis I need an in-depth analysis of a company (Walmart) as outlined in the instructions attached. Southern New Hampshire University
MBA 520 Milestone Three Guidelines and Rubric
Overview: You now know how to evaluate the equity of a company and analyze the market economy’s behavior. Using this knowledge, you will predict your
company’s future behavior through forecasting, identify and describe business opportunities that the company should pursue, and explain the benefits and
costs of these decisions.
Prompt: In this milestone, you have two tasks. First, predict your company’s future behavior through forecasting, projecting its likely performance based on
the most recent year of financial information. Then, explain the incremental impact of a hypothetical but reasonable and simple new investment project,
such as a new product or facility or a cost-cutting investment, as an initial step in thinking about the future. To justify your findings and projections, you
need to include accurate and relevant data tables that explain how the numbers were informed by existing information and model different scenarios. Be
sure to address the following critical elements:
IV.
Projections: Using what you know about the company’s financial health and performance, forecast its future performance. In particular, you
should:
A. Project the company’s likely consolidated financial performance for each of the next three years. Support your analysis with an appendix
spreadsheet showing actual results for the most recent year, along with your projections and assumptions. Remember that your
supervisor is interested in fresh perspectives, so you should not just replicate existing financial statements: You should add other relevant
calculations or disaggregations to help inform decisions.
B. Modify your projections for the coming year to show a best-and worst-case scenario based on the potential success factors and risks you
identified. As with your initial projections, support your analysis with an appendix spreadsheet, specifying your assumptions and including
relevant calculations and disaggregations beyond those in the existing financial reports.
C. Discuss how your assumptions, forecasting methodology, and information gaps affect your projections. Why are your projections
appropriate? For example, are they consistent with the company’s mission and priorities? Aggressive but achievable? How would changing
your assumptions change your projections?
Rubric
Guidelines for Submission: Use the Final Project Template to complete this assignment. Your report should be approximately 5-7 pages long (excluding the
title page, spreadsheets and graphs, and the references list). It should be double spaced, with 12-point Times New Roman font and one-inch margins, and use
the latest guidelines for APA formatting for references and citations. Please include your name, course name, and report title on the title page.
Critical Elements
Projections: Likely
Performance
Value
30
Proficient (100%)
Projects the likely
consolidated financial
performance for next three
years, supported by
spreadsheet showing actual
results for most recent year,
projections, and assumptions
Needs Improvement (70%)
Not Evident (0%)
Projects the likely consolidated financial Does not project the likely
performance for next three years, consolidated financial
supported by spreadsheet showing performance for next three
actual results for most recent year, years or support with
projections, and assumptions, but spreadsheet showing actual
response contains inaccuracies or faulty results for most recent year,
assumptions or omits key details projections, and assumptions
Southern New Hampshire University
Value
30
Critical Elements
Proficient (100%)
Needs Improvement (70%)
Not Evident (0%)
Projections: Best- and Modifies projections to show Modifies projections to show best- and Does not modify projections to
Worst-Case best- and worst-case scenarios worst-case scenarios based on success show best and worst-case
for coming year based on factors and risks identified, supported by scenarios based on success
success factors and risks spreadsheet with assumptions and factors and risks identified,
identified, supported by additional information, but response supported by spreadsheet with
spreadsheet with assumptions contains inaccuracies or faulty
assumptions and information
and relevant information assumptions, or additional information beyond existing financial
beyond existing financial included is not relevant
reports
reports
Projections: Discuss Discusses how assumptions, Discusses how assumptions,
Does not discuss how
Projections forecasting methodology, and methodology, and information gaps assumptions, forecasting
information gaps affect affect projections and why projections methodology, and information
projections and why
are appropriate, but discussion is cursory gaps affect projections and
projections are appropriate or illogical or contains inaccuracies why projections are
appropriate
Articulation of Submission has no major Submission has major errors related to Submission has critical errors
Response rrors related to citations, citations, Br spelling, syntax, or related to citations,
grammar, spelling, syntax, or organization that negatively impact spelling, syntax, or
organization
readability and articulation of main ideas organization that prevent
understanding of ideas
Total
30
10
100%

Purchase answer to see full
attachment