Problem 2Financial planner Minnie Margin has a substantial number of clients who wish to own a mutual fund portfolio that matches, as a whole, the performance of the Russell 2000 index. Her task is to determine what proportion of the portfolio should be invested in each of the five mutual funds listed below so that the portfolio most closely mimics the performance of the Russell 2000 index. Annual Returns Year 1Year 2Year 3Year 4International Stock22.3726.734.862.17Large-Cap Value15.4819.6411.50-5.25Mid-Cap Value17.4220.07-4.97-1.69Small-Cap Growth23.1812.363.253.81Short-Term Bond9.268.816.154.04Russell 2000 Index202282 Write out the (non-linear) program that would produce a portfolio that most closely mimics the performance of the Russell 2000 Index.Use Excel's Solver with "GRG Non-Linear" as the solution algorithm: what is the optimal solution, i.e., what percentages should be invested in each of the five funds?

Mutual funds are similar to large investment pools to which many participants contribute.…

Answered: Problem 2 Financial planner Minnie…

PFIN (with PFIN Online, 1 term (6 months) Printed Access Card) (New, Engaging Titles from 4LTR Press)

6th Edition

ISBN:9781337117005

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter13: Investing In Mutual Funds, Etfs, And Real Estate

Section: Chapter Questions

Problem 8FPE

See similar textbooks

Related questions

Question

Problem 2

Financial planner Minnie Margin has a substantial number of clients who wish to own a mutual fund portfolio that matches, as a whole, the performance of the Russell 2000 index. Her task is to determine what proportion of the portfolio should be invested in each of the five mutual funds listed below so that the portfolio most closely mimics the performance of the Russell 2000 index.

	Annual Returns
	Year 1	Year 2	Year 3	Year 4
International Stock	22.37	26.73	4.86	2.17
Large-Cap Value	15.48	19.64	11.50	-5.25
Mid-Cap Value	17.42	20.07	-4.97	-1.69
Small-Cap Growth	23.18	12.36	3.25	3.81
Short-Term Bond	9.26	8.81	6.15	4.04
Russell 2000 Index	20	22	8	2

Write out the (non-linear) program that would produce a portfolio that most closely mimics the performance of the Russell 2000 Index.
Use Excel's Solver with "GRG Non-Linear" as the solution algorithm: what is the optimal solution, i.e., what percentages should be invested in each of the five funds?

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 8 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.