1. Assume that George Mason Medical Center has investments in a Building Replacement Fund with the following balances as of July 15, 2022 listed by category. The Investment Committee of the Board has approved a recommendation to reallocate these funds, and to include for the first-time common stocks from non-US companies. Assume that the portfolio will be rebalanced on August 1, 2022, to equal the Board's targeted desired allocation percentages. George Mason Medical Center Recommended Asset Allocation for Building Replacement Fund Rebalancing of Investment Portfolio as of July 15, 2022 Your calculated Investment Description Balance on 7/15/2022 Current Allocation% Future Desired Re-balanced Allocation Amounts Cash and Cash Equivalents Fixed Income Domestic Bonds Fixed Income - International Bonds Equities Large Cap Growth $ 12,000,000 10.4% 5.0% ? 32,000,000 27.8% 22.0% 2 10,000,000 8.7% 12.0% ? 13,000,000 11.3% 11.0% ? Equities - Large Cap Value 25,000,000 21.7% 23.0% ? Equities Mid/Small Cap Growth 11,000,000 9.6% 11.0% ? Equities - Mid/Small Cap Value 12,000,000 10.4% 10.0% ? Equities International 0.0% 6.0% ? Total $ 115.000.000 100.0% 100.0% $ 115.000.000 Question What are the new balances of the investments after reallocating the total to match the new 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 has not changed from July 15