Be sure to let Excel do the computations for you. Do not just do the computations outside of Excel and place them in the cell. And be sure to set the printing on the spreadsheet to print on one page, in either your choice of landscape or portrait. 1. Assume that George Mason Medical Center has investments in a Building Replacement Fund with the following balances as of July 15,2023 , listed by category. The Investment Committee of the Board has approved a recommendation to reallocate these funds, and to include for the firsttime investments in real estate investment trusts (REITS). Assume that the portfolio will be rebalanced on August 1, 2023, to equal the Board's targeted desired allocation percentages. Question 1: What are the new balances of the investments after reallocating the total to match the new desired allocation percentages? Prepare a Microsoft Excel spreadsheet that is readable and in good form that will calculate this, using the future desired allocation \%. Assume that the total of the investments will not change from July 15. Format the spreadsheet to print on one page in landscape; show the new allocation percentages to one decimal point in a column; right justify the numbers in each column; use $ and % symbols however you choose; center a heading on the top of the schedule and put your name in a footer on your schedule. Be sure to upload this spreadsheet as a separate readable Excel formatted document in the Blackboard Assignment folder. Do not upload a PDF file. And include your completed work in your Bb Learning Portfolio. Question 2: In your opinion, what other investment categories could the Investment Committee have considered? Using Craig Israelsen's 7Twelve portfolio suggestions as a guide, or any other source you want, note at the bottom of your spreadsheet at least two additional asset groups, in your opinion, the Investment Committee could have considered when making these target allocations for their investments. Your score on this will be determined by: How well you followed the instructions to the problem. How well you prepared the Excel spreadsheet. How well you computed the new balances in the reallocated amount. low well you answered Question 2