I don't need the actual homework problem done for me. I would like a template or an example of what the excel sheet should look like. Thank you.

1- Build a decision support system (DSS) for a small investor to manage an investment portfolio of 20 to 30 stocks. Total money allocated is 100,000. Begin by looking at Yahoo Finance website to select your stocks. OR 2- Instead portfolio of stocks you may develop a DSS to select a house from a list of 20. 3- You may use any resource: Microsoft website, or Youtube, to refresh your knowledge of excel 4- Be mindful that the assignment is to build a decision support system (DSS) using Excel NOT just to create a LIST only. 5- Spreadsheets are dynamic tables in which variables are connected via formulas and cell addresses. DSS uses what if analysis and logic for example, what to do when a stock value after a week drops 20%. Or what additional income I need to buy a house above $ 500,000. -- 6- In this course we assume that you have basic skills in EXCEL. In your DSS, you have to use formulas for calculations such as addition, %, multiplication, etc,. 7- It is up to you to decide on tables structure (variables to be included), on selection Criteria (what variables to use to select stocks, or houses) and Parameters (what variables to monitor) and Scenarios (2-3 portfolios)

It would be helpful for someone to do a template or maybe draw it out to know the items needed. Also opened to share a doc to get a step by step. Thank you