How can I solve this problem using excel?

You would like to sell enough shares of stock today to generate $10,000 to use as part of a down payment on a new home. You need to decide how many shares of which stocks to sell in order to generate $10,000, after taxes and transaction costs, while maximizing the estimated value of your stock portfolio next year. We will formulate this problem as a linear optimization problem.

Describe the decision variables for this problem. How many are there?

We'll assume for this problem that you can't sell more shares of stock than you

own, and you can't buy additional shares. How would you constrain the values of

the decision variables to account for this?

Your objective is to maximize the estimated value of your stock portfolio next

year. To do this, you should sum the estimated value of each stock next year. Suppose you sell shares of your stock in Microsoft. What is the estimated value of your Microsoft stock next year?

Write out the objective function of this problem in terms of your decision variables.

In addition to the upper and lower bounds on your decision variables, you need to add one constraint to your model to make sure you get $10,000 in cash from selling your stocks, after taxes and transaction costs. Write down this constraint in terms of your decision variables.