I need help making a profit-and-loss statement for a three year period (For WalMart) including revenue projection and stated assumptions. I am having trouble figuring out the excel sheet for this her tip says.

7) Lastly, you need to give me 3 years worth of PROJECTED income statements. This means 2022-2024 or 2023-2025 depending on your firm's year end. Income statements should reflect the firm as a whole, not just your project. These are estimated figures. Go to your firm's Yahoo Finance page. Click on the Financials tab and the blue Income statement link. Use the last full year column as a base (not the TTM Column) and then project out for 3 more years UP THROUGH THE NET INCOME CATEGORY. Also, you need to provide a discussion as you did for WACC as to growth, assumptions, etc. In other words, you need to discuss how you arrived at your estimates and what your reasoning is based upon. Make sure you speak to % revenue, % gross profit and % net income increases as these are the most important categories