this need to be solved using solver function. please do attach the formulas do thats helpful

a minimuan of 16% of the porthilo muit be heit in moner maret hanth. 4. What is the allocatici of her porthle in stork, bondr and moon mant tundi and what is her ewpected annual portfolio return? 8. The investor is curioun what return a high rikk allocation might provide. Under this scenario, a min of 5 of the porfolio must be invested in money market funds and the max allocation in stocks is raised to 60x. What is the new afocation and expected aneaal return? Problem Statement: United Bank of Scotiand has $2,500,000 in funds from a private investor that it just received. As a new account manager, your boss wants you to take this on as a new assignment. The investor says she wants an asset allocation as follows: equities/stocks (expected 12% return), money market (1.5\%s return) and bonds (5\% return). The investor indicates she is willing to take moderate risk, and therefore the max allocation to equities is capped at 45% of her total investment aND a minimum of 10% of the portfolio must be held in money market funds. A. What is the allocation of her portfolio in stocks, bonds and money market funds and what is her expected annual portfolio return? 8. The investor is curious what return a high risk allocation might provide. Under this scenario, a min of 5% of the porfolio must be invested in money market funds and the max allocation in stocks is raised to 60%. What is the new allocation and expected annual return