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.

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter3: Data Visualization
Section: Chapter Questions
Problem 6P: The file MutualFunds contains a data set with information for 45 mutual funds that are part of the...
icon
Related questions
icon
Concept explainers
Question
100%
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
Investment Description
Cash and Cash Equivalents
Fixed Income - Domestic Bonds
Fixed Income - International Bonds
Equities Large Cap Growth
Equities - Large Cap Value
Equities- Mid/Small Cap Growth
Equities - Mid/Small Cap Value
Equities International
Total
S
Balance on
7/15/2022
12,000,000
32,000,000
10,000,000
13,000,000
25,000,000
11,000,000
12,000,000
S 115.000.000
Current
Allocation %
10.4%
27.8%
8.7%
11.3%
21.7%
9.6%
10.4%
0.0%
100.0%
Your calculated
Re-balanced
Amounts
5.0%
?
22.0%
?
12.0%
?
11.0%
?
23.0%
?
11.0%
?
10.0%
?
6.0%
?
100.0% $ 115,000,000
Future Desired
Allocation
Transcribed Image Text: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 Investment Description Cash and Cash Equivalents Fixed Income - Domestic Bonds Fixed Income - International Bonds Equities Large Cap Growth Equities - Large Cap Value Equities- Mid/Small Cap Growth Equities - Mid/Small Cap Value Equities International Total S Balance on 7/15/2022 12,000,000 32,000,000 10,000,000 13,000,000 25,000,000 11,000,000 12,000,000 S 115.000.000 Current Allocation % 10.4% 27.8% 8.7% 11.3% 21.7% 9.6% 10.4% 0.0% 100.0% Your calculated Re-balanced Amounts 5.0% ? 22.0% ? 12.0% ? 11.0% ? 23.0% ? 11.0% ? 10.0% ? 6.0% ? 100.0% $ 115,000,000 Future Desired Allocation
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.
Transcribed Image Text: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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning