Help please! I am not sure how to set this up in excel.

Your job is to manage an investment portfolio over a 6-year time horizon. You begin with $1000, and at various times you can invest in one or more of the following securities, each security can be bought in any denomination. Savings account X, annual yield 5%. You can make savings deposits or withdrawals anytime. Security Y, 2-year maturity, total yield 12% if bought now, 11% thereafter. You can buy Security Y any year but year 3. Security Z, 3-year maturity, total yield 18%. You can buy Security Z anytime after the first year. Security W, 4-year maturity, total yield 24%. Security W, now available, is a one-time opportunity. See the diagram in worksheet Q2 of the data file. Determine the investments that will maximize the value of the portfolio at the end of year 6