The company name: Walmart.

Part 1

From the company's annual reports, you will pull the financial statements from the last three years (balance sheet and income statement). Calculate the liquidity, efficiency, profitability, market value, and leverage ratios for the past three years. Analyze the trends of the ratios over the past three years.

Prompt: Milestone One should contain the following critical elements:

II. Current Financial Status: Analyze the position of the firm and whether the company regressed or improved financially over the past three years. Be sure to situate your company within the broader economy and its specific industry, particularly with respect to major competitors and industry and market trends. Your analysis, supported by relevant spreadsheets and graphs, must include, but need not be limited to, the following:

A. Liquidity

B. Efficiency

C. Profitability

D. Market Value

E. Leverage

Guidelines for Submission: Your draft must contain all of the elements listed above. It should be at least 4 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 2:

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 company's financial statements, your analysis, and any additional evidence, project the company's 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 firm's 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 company's 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 3

International Market Analysis: Analyze the market positioning of the firm in one foreign market. Examples of foreign markets can be found in the firm's annual report. From secondary sources, pull the exchange rates between the U.S. dollar and the foreign market currency and use linear regression to predict the exchange rates for the next year. Lastly, analyze the different risk management tools used by the firm (for example, hedging, insurance, and so on).

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:

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 company's 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.