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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education