1 AssumethatGeorgeMasonMedicalCenterhasinvestmentsinaBuilding Replacement Fund with the following balances as of 4 30 20 listed by category The Investment Committee of the Board has approved a recommendation to reallocate these funds, and to include for the first time commonstocksfromnon UScompanies Assumethattheportfoliowillbe rebalanced on June 1, 2020 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 June 1, 2020 Balance on Current Future Desired Re balanced Investment Description 4 30 2020 Allocation Allocation Amounts Cash and Cash Equivalents $ 6,000,000 4 7 4 0 Fixed Income Domestic Bonds 42,000,000 32 8 33 0 Fixed Income International Bonds 15,000,000 11 7 10 0 Equities Large Cap Value 28,000,000 21 9 22 0 Equities Large Cap Growth 17,000,000 13 3 18 0 Equities Mid Small Cap Value 12,000,000 9 4 4 0 Equities Mid Small Cap Growth 8,000,000 6 3 4 0 Equities International 0 0 5 0 Total $ 128,000,000 100 0 100 0 $ 128,000,000 Part 1 Prepare a Microsoft Excel spreadsheet that is readable and in good form that will calculate the re balanced investments (assuming that the investment balances have not changed) on June 1 using the future desired allocation percentages 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 Portfolio Part 2 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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 27, 2024

1. AssumethatGeorgeMasonMedicalCenterhasinvestmentsinaBuilding Replacement Fund with the following balances as of 4/30/20 listed by category. The Investment Committee of the Board has approved a recommendation to

1. AssumethatGeorgeMasonMedicalCenterhasinvestmentsinaBuilding Replacement Fund with the following balances as of 4/30/20 listed by category. The Investment Committee of the Board has approved a recommendation to reallocate these funds, and to include for the first time commonstocksfromnon-UScompanies. Assumethattheportfoliowillbe rebalanced on June 1, 2020 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 June 1, 2020


	Balance on	Current	Future Desired	Re-balanced
Investment Description	4/30/2020	Allocation %	Allocation	Amounts
Cash and Cash Equivalents	$ 6,000,000	4.7%	4.0%	?
Fixed Income - Domestic Bonds	42,000,000	32.8%	33.0%	?
Fixed Income - International Bonds	15,000,000	11.7%	10.0%	?
Equities - Large Cap Value	28,000,000	21.9%	22.0%	?
Equities - Large Cap Growth	17,000,000	13.3%	18.0%	?
Equities - Mid/Small Cap Value	12,000,000	9.4%	4.0%	?
Equities - Mid/Small Cap Growth	8,000,000	6.3%	4.0%	?
Equities - International	-	0.0%	5.0%	?
Total	$ 128,000,000	100.0%	100.0%	$ 128,000,000

Part 1: Prepare a Microsoft Excel spreadsheet that is readable and in good form that will calculate the re-balanced investments (assuming that the investment balances have not changed) on June 1 using the future desired allocation percentages. 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 Portfolio

Part 2: 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.