Consider Elena who wants to invest $100,000 for a span of 2 years. After the end of two years, Elena will use this money (both the principal and interest) to pay for her sons college tuition. She has hired you to help her invest this money in the following set of assets: Equities, Real Estate, Short-Term Deposits, Cash and Long-Term Deposits. Based on past historical trends, the returns are as follows:

Before investing, Elena is uncertain on what return she would get from each asset. She believes that the return could be low with 33% chance, medium with 34% chance and high with 33% chance. For instance, if the returns turn out to be low, then Elena loses 5% in equities, gains 5.67% in real estate and so on.

After investing, Elena realizes the return from each asset at the end of the first year. At this point of time, she may rearrange her portfolio if she wishes to do so. Specifically, if she had invested 20,000 dollars in equities in the first year, she may choose to increase/decrease her investments in the equities for the second year based upon the realized returns.

Each asset is further categorized with respect to the risk level, whether the asset is traded domestically or globally, and the market capitalization. For instance, real estate is a risky asset, is only traded domestically and has a large market capitalization. Elena has asked you to make sure that, every time investments are made, it must be the case that:

A. The investments in risky category be at most 60% of the total invested amount.

B. The investments in the global category be at least 20% of the total invested amount.

C. The investments in the large market capitalization category be at least 40% of the total invested amount.

Use this info in order to answer the question below and please show your work:

Question 1. (Wait and See) Suppose that Elena does not invest any amount in the first year and waits to see the returns before investing in the second year. Use excel to find the optimal solution under this Wait and See Approach? Does this solution make sense? In expectation, how much would Elena get at the end of the second year?

Returns Location (1 Market Risky (1-Yes, Global, 0 Capitalization (1 0-No) High 20.00% 10.97% 9.71% 0.10% 8.65% Domestic) large, o-small) Assets Equities Real Estate Short Term Deposits Cash Long Term Deposits Low -5.00% 5.67% 4.33% 0.10% 7.54% Medium 4.00% 8.35% 7.82% 0.10% 8.10%