Financial Reporting, Financial Statement Analysis and Valuation,
Design a spreadsheet and prepare a set of financial statement forecasts for Walmart for Year þ1 to Year þ5 using the assumptions that follow. Project the amounts in the order presented (unless indicated otherwise) beginning with the income statement, then the balance sheet, and then the statement of cash flows. For this portion of the problem, assume that Walmart will exercise its financial flexibility with the cash and cash equiva- lents account to balance the balance sheet.