Assume that George Mason Medical Center 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...





Compute the budgeted “weighted average” annual investment return for dividends and interest for the fourth quarter of 2019. Prepare this spreadsheet so your calculations clearly show the reader your assumptions and how your calculations were made





Assume that George Mason Medical Center had investments in a Building Replacement<br>Fund with the following balances as of 9/18/19 listed by category. The Investment<br>Committee of the Board has approved a recommendation as to how to allocate these<br>funds. Assume that the portfolio was rebalanced on October 1, 2019 to equal the<br>Board's target allocation, and that the investment balances in total on October 1st<br>equaled the $72,250,000 noted on the schedule. Also assume that the following<br>interest and dividend annual percentage rates that are expected to be earned from<br>October 1 to December 31 for these investment categories:<br>Expected<br>Interest and<br>Dividend Rate<br>0.4%<br>4.3%<br>Description<br>Balance as of Future Desired<br>9/18/19<br>$ 4,385,000<br>28,685,000<br>13,051,000<br>11,226,000<br>4,395,000<br>3,525,000<br>6,983,000<br>Allocation<br>4.0%<br>40.0%<br>18.0%<br>Cash<br>Fixed Income<br>Large Cap Value<br>Large Cap Growth<br>Mid/Small Cap Value<br>Mid/Small Cap Growth<br>International Equity<br>Emerging Markets Equity<br>Total<br>1.8%<br>20.0%<br>5.0%<br>1.2%<br>0.8%<br>0.2%<br>5.0%<br>6.0%<br>2.0%<br>100.0%<br>2.1%<br>0.7%<br>$72,250,000<br>Average ?<br>

Extracted text: Assume that George Mason Medical Center 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: Expected Interest and Dividend Rate 0.4% 4.3% Description Balance as of Future Desired 9/18/19 $ 4,385,000 28,685,000 13,051,000 11,226,000 4,395,000 3,525,000 6,983,000 Allocation 4.0% 40.0% 18.0% Cash Fixed Income Large Cap Value Large Cap Growth Mid/Small Cap Value Mid/Small Cap Growth International Equity Emerging Markets Equity Total 1.8% 20.0% 5.0% 1.2% 0.8% 0.2% 5.0% 6.0% 2.0% 100.0% 2.1% 0.7% $72,250,000 Average ?

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here