Question In your opinion, what other investment categories could theInvestment Committee have considered? Using Craig Israelsen's 7Twelveportfolio suggestions as a guide, or any other source you want, note at thebottom of your spreadsheet at least two additional asset groups, in youropinion, the Investment Committee could have considered when makingthese target allocations for their investments. 1. Assume that George Mason Medical Center has investments in a BuildingReplacement Fund with the following balances as of July 15, 2022 listedby category. The Investment Committee of the Board has approved arecommendation to reallocate these funds, and to include for the first-timecommon stocks from non-US companies. Assume that the portfolio will berebalanced on August 1, 2022, to equal the Board's targeted desiredallocation percentages.George Mason Medical CenterRecommended Asset Allocation for Building Replacement FundRebalancing of Investment Portfolio as of July 15, 2022Investment DescriptionCash and Cash EquivalentsFixed Income - Domestic BondsFixed Income - International BondsEquities Large Cap GrowthEquities Large Cap ValueEquities - Mid/Small Cap GrowthEquities Mid/Small Cap ValueEquities InternationalTotalSBalance on7/15/202212,000,00032,000,00010,000,00013,000,00025,000,00011,000,00012,000,000S 115.000.000CurrentAllocation %10.4%27.8%8.7%11.3%21.7%9.6%10.4%0.0%100.0%Future DesiredAllocation5.0%22.0%12.0%11.0%23.0%11.0%10.0%6.0%100.0%Your calculatedRe-balancedAmounts????????$ 115,000,000

Investment Description Current Allocation Balance on 7/15/2022 Future Desired allocation Balance on…

Question In your opinion, what other investment categories could the Investment Committee have considered? 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.

Question In your opinion, what other investment categories could the Investment Committee have considered? 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.

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...

See similar textbooks

Similar questions

On October 24, 2020, the market value of the investments contained in the Global Investment Fund, a mutual fund, was $28,000,000. Liabilities for the fund were $2,800,000. If the fund had 1,340,000 shares outstanding, calculate the net asset value per share. Round your answer to the nearest cent.
The file MutualFunds contains a data set with information for 45 mutual funds that are part of the Morningstar Funds 500. The data set includes the following five variables: Fund Type: The type of fund, labeled DE (Domestic Equity), IE (International Equity), and FI (Fixed Income) Net Asset Value (): The closing price per share Five-Year Average Return (%): The average annual return for the fund over the past five years Expense Ratio (%): The percentage of assets deducted each fiscal year for fund expenses Morningstar Rank: The risk adjusted star rating for each fund; Morningstar ranks go from a low of 1 Star to a high of 5 Stars. a. Prepare a PivotTable that gives the frequency count of the data by Fund Type (rows) and the five-year average annual return (columns). Use classes of 09.99, 1019.99, 2029.99, 3039.99, 4049.99, and 5059.99 for the Five-Year Average Return (%). b. What conclusions can you draw about the fund type and the average return over the past five years?
On February 9, 2020, the market value of the investments contained in the All Star Stock Fund, a mutual fund, was $21,200,000. Liabilities for the fund were $2,544,000.If the fund had 970,000 shares outstanding, calculate the net asset value per share. Round your answer to the nearest cent.
l&P Asset Management initiated an open-end and a closed-end mutual fund a few years ago. If you want to invest in the funds today, you: must purchase shares of each fund in the secondary (stock) market may purchase shares of each fund in either the primary (from the investment company) market or the secondary (stock) market must purchase shares of the open-end fund in the secondary (stock) market, and shares of the closed-end fund in the primary (from the investment company) market must purchase shares of the open-end fund in the primary (from the investment company) market, and shares of the closed-end fund in the secondary (stock) market
Consider the following trading and performance data for four different equity mutual funds: Fund W Fund X Fund Y Fund Z Assets Under Management, $ 289.40 $ 653.70 $ 1,298.40 $ 5,567.30 Avg. for Past 12 Months (mil) Security Sales, Past 12 Months (mil) $ 37.20 $ 569.30 $ 1,453.80 $ 437.10 Expense Ratio 0.33% 0.71% 1.13% 0.21% Pretax Return, 3-Year Avg. 9.98% 10.65% 10.12% 9.83% Tax-Adjusted Return, 3-Year Avg. 9.43% 8.87% 9.34% 9.54% a. Calculate the portfolio turnover ratio for each fund. b. Which two funds are most likely to be actively managed and which two are most likely passive funds? Explain. c. Calculate the tax cost ratio for each fund. d. Which funds were the most and least tax efficient in the operations? Why?
(Using the CAPM to find expected returns) Sante Capital operates two mutual funds headquartered in Houston, Texas. The firm is evaluating the stock of four different firms for possible inclusion in its fund holdings. As part of their analysis, Sante's managers have asked their junior analyst to estimate the investor-required rate of return on each firm's shares using the CAPM and the following estimates: The rate of interest on short-term U.S. Treasury securities is currently 4 percent, and the expected return for the market portfolio is 10 percent. What should be the expected rates of return for each investment? Security Beta A 1.67 B 0.58 C 1.14 D 0.78 (Click on the icon in order to copy its contents into a spreadsheet.) Question content area bottom Part 1 a. The expected rate of return for security A, which has a beta of 1.67, is enter your response here%. (Round to two decimal places.) Part 2 b. The expected…
Consider the following trading and performance data for four different equity mutual funds: Fund W Fund x Fund y Fund z Assets under Management, $284.4 $662.1 $1,286.4 $5,564.6 Avg. for Past 12 months (mil) Security Sales, $44.6 $566.1 $1,455.6 $438.8 Past 12 months (mil) Expense Ratio 0.33% 0.75% 1.19% 0.24% Pretax Return, 3-year avg. 9.85% 10.65% 10.44% 9.73% Tax-adjusted Return, 3-year avg. 8.84% 8.84% 9.10% 9.04% Calculate the portfolio turnover ratio for each fund. Do not round intermediate calculations. Round your answers to two decimal places. Fund W: % Fund X: % Fund Y: % Fund Z: %
The Retired Fund is an open-ended mutual fund composed of $500 million in U.S. bonds and U.S. Treasury bills. This fund has had a portfolio duration (including T-bills) of between 3 and 9 years. Retired has shown first-quartile performance over the past five years, as measured by an independent fixed-income measurement service. However, the directors of the fund would like to measure the market timing skill of the fund’s sole bond investor manager. An external consulting firm has suggested the following three methods:a. Method I examines the value of the bond portfolio at the beginning of every year, then calculates the return that would have been achieved had that same portfolio been held throughout the year. This return would then be compared with the return actually obtained by the fund.b. Method II calculates the average weighting of the portfolio in bonds and T-bills for each year. Instead of using the actual bond portfolio, the return on a long-bond market index and T-bill index…
Carol Harrod is the investment officer for a $100 million U.S. pension fund. The fixed-income portion of the portfolio is actively managed, and a substantial portion of the fund’s large capitalization U.S. equity portfolio is indexed and managed by Webb Street Advisors.Harrod has been impressed with the investment results of Webb Street’s equity index strategy and is considering asking Webb Street to index a portion of the actively managed fixed-income portfolio.a. Describe the advantages and disadvantages of bond indexing relative to active bond management.b. Webb Street manages indexed bond portfolios. Discuss how an indexed bond portfolio is constructed under stratified sampling (cellular) methods.c. Describe the main source of tracking error for the cellular method.
An investor wants to select one of the following mutual funds for the coming year. Data showing the percentage annual return for each fund during five typical one-year periods are shown below. The assumption is that one of these five year periods will occur again during the coming year. Thus A, B, C, D and E are states of nature for the mutual fund decision. Outcomes Mutual Fund Year A Year B Year C Year D Year E Large Cap Stock 25.3 30.0 48.3 22.4 -19.8 Mid-Cap Stock 35.9 21.6 -9.9 62.3 -20.1 Small-Cap Stock 40.5 29.4 16.0 13.8 6.1 Energy Sector 35.4 23.2 -19.5 31.4 -12.2 Health Sector 49.1 5.5 89.5 70.4 -20.5 Tech Sector 46.2 37.2 46.9 40.5 -16.2 Real Estate Sector 18.9 35.0 -20.0 24.6 13.2 a) Assume the investor is conservative, what is the recommended fund?…
Consider a no-load mutual fund with $457 million in assets and 12 million shares at the start of the year, and $520 million in assets and 13.21 million shares at the end of the year. During the year investors have received income distributions of $2.25 per share, and capital gains distributions of $1.57 per share. Assume that the fund carries no debt. What is the NAV at the END of the year? Group of answer choices 39.36 37.97 38.65 43.65 33.34
The China Fund is a mutual fund that can be purchased on the New York Stock Exchange. The rates of total return provided by the fund for each year 2004 - 2008 were -17.75%, 18.75%, 11.25%, 12.5% and 5%. If your investment is worth $3, 626.67 at the end of 2008, what was your investment value at the beginning of 2004? For full marks your answer(s) should be rounded to the nearest cent