Financial analysis essay for Walmart. 6 pages . APA Project (Company Financial Analysis): Each student will provide an in-depth analysis on a Public Company/ financial performance. In 5-7 pages, write your analysis in a Microsoft Word document and clearly identify each letter items to which you are responding. In addition, present an overview of your findings in a video that includes PowerPoint and your face on camera, not to exceed 5 minutes. The purpose of the video is to provide an objective and unbiased overview of your findings to a group of potential investors who are knowledgeable businesspeople, but don’t know much about the financials of this business. Part of your grade will be based on the organization of your project. Where calculations are involved, show them in your responses. Paper should be formatted according to APA requirements. Be sure to familiarize yourself with the grading rubric (below) to make sure that you address all points. Briefly discuss the firm’s background, vision, mission, product lines, and trends (one page or less). Review the Management’s Discussion, Analysis of Financial Condition and Results of Operations. Discuss significant financial impact the firm is facing both positive and negative. Analyze only the “consolidated” income statement, balance sheet and cash flow of this firm and provide answers to the following questions What was the net income for the previous year? What was the gross profit for each of the previous two years? What was the amount of income before income taxes for each of the previous two years? What was the amount of selling, general, and administrative expenses in the previous year? How much in dividends on common stock was paid per share and in total in the previous year? How much was the net cash provided (or used) by operating activities in each of the previous 2 years? How much was the net cash provided (or used) by investing activities in the each of the previous two years? How much was the cash provided by the issuances of debt in each of the previous two years? What was the total amount of inventories on closing day in each of the previous two years? What were the principal categories of inventory on these dates? What were the total assets on closing day last year? What were the current liabilities on closing day last year? What are the company’s operating segments? Using chapter 3 as a guide and only the “consolidated” income statement and balance sheet, conduct a financial ratio analysis by using previous year’s financial data. Provide one type of ratio from each of the following categories: Liquidity ratios Debt ratios Profit ratios Put a conclusion together discussing why or why not you would recommend or not recommend these companies to creditors and investors.