FIL 246 Forecasting Spreadsheet Assignment (Optional) Attempt 1 Due 5/7/2024

1. Using the file WMT forecast data.xls, create a spreadsheet which will forecast the income statement and balance sheet for Walmart (WMT) for the year ended January 31, 2024. Grading will be as follows:

Correct Answers: 9 points User Friendliness: 9 points Discussion: 9 points. 2. For the discussion part, answer the following questions: a. (4.5 points) On the first pass, why does forecasted assets not usually equal forecasted liabilities and equity? b. (4.5 points) What do we mean by financing feedback?

3. NOTE THE FOLLOWING: a. Enter the required cell formulas in the blue shaded cells only. DO NOT enter anything into any of the cells that are not shaded blue. b. For up to 3 points extra credit, change the numbers for forecasted gross property, plant, and equipment, accumulated depreciation, and total assets to the appropriate cell formulas. Note that gross property, plant, and equipment and accumulated depreciation are to be forecasted as a percentage of total assets. This is something I did not go over in class.