Question
Assume that George Mason Medical Center (GMMC) had investments in a Building Replacement Fund with the following balances as of 9/18/19 listed by category. The
Assume that George Mason Medical Center (GMMC) had investments in a Building Replacement Fund with the following balances as of 9/18/19 listed by category. The Investment Committee of the Board has approved a recommendation as to how to allocate these funds. Assume that the portfolio was rebalanced on October 1, 2019, to equal the Board's target allocation and that the investment balances in total on October 1st equaled the $72,250,000 noted on the schedule. Also assume that the following interest and dividend annual percentage rates that are expected to be earned from October 1 to December 31 for these investment categories:
Prepare an Excel spreadsheet with two (2) tabs. The first tab will rebalance the investments and then estimate the amount of interest and dividends that this fund might be expected to earn from October 1 to December 31. Dont worry about the compounding of interest or dividends; make it simple. The second tab will be used to summarize your information in a highly readable format that will be presented to the GMMC CFO.
Description Cash Fixed Income Large Cap Value Large Cap Growth Mid/Small Cap Value Mid/Small Cap Growth International Equity Emerging Markets Equity Total Balance as of Future Desired 9/18/19 Allocation $ 4,385,000 4.0% 28,685,000 40.0% 13,051,000 18.0% 11,226,000 20.0% 4,395,000 5.0% 3,525,000 5.0% 6,983,000 6.0% 2.0% $72,250,000 100.0% Expected Interest and Dividend Rate 0.4% 4.3% 1.8% 1.2% 0.8% 0.2% 2.1% 0.7% AverageStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started