Barbara Garcia, the chief financial officer with Gladstone Investments, is faced with investing $1 million of funds for clients. The fund has a balanced goal of immediate yield with long-range appreciation, while maintaining acceptable risks. After a preliminary study of available investments, Garcia decides to invest the total amount in common stocks and Certificates of deposit (CDs). Further study narrows the choices of investments to the following. This table lists the projected annual rates of yield and appreciation:

Investment	Projected Yield, %/Year	Projected Rate of Appreciation, %/Year
CDs	7.3	0.0
Shenangoah Power Company	8.7	4.2
Nantucket Gas & Light	7.6	5.2
Fairview Public Utility	8.1	4.4
Dentrex Biotechnology	3.4	15.4
Grodymore Clones	2.6	24.8
Bugadoom and Associates	2.9	19.2

To balance yield and appreciation with risk, Garcia uses the following guidelines:

1. The total investment in the three utilities (Shenandoah, Nantucket, & Fairview) cannot exceed four times the investment in CDs.
2. The total investment in the three biotechnology firms (Dentrex, Grodymore, & Bugadoom) cannot exceed twice the combined investments in CDs and utility stocks.
3. At least 30% of the investment must be in Utilities.
4. At least 20% of the investment must be in Biotechnology firms.
5. The total investment in any single stock cannot exceed twice the sum of the other two stocks in the same industry.

The twin goals of the fund are to provide a yield rate of 8% per year and a growth rate of 15% per year. Prepare a well-labeled table that allows the results of the following parts to be easily compared:

1. What amounts should be invested in CDs and the six stocks? What will be the rates of yield and appreciation for the portfolio selected? Assume shortfalls from both goals of yield and growth are equally important.
2. How do your responses to part (a) change if the shortfall from the goal of an 8% yield is five times as important as the shortfall from the goal of 15% growth?
3. How do your responses to part (a) change if the shortfall from the goal of 15% growth is five times as important as the shortfall from the goal of an 8% yield?
4. How do your responses to part (a) change if your only goal is to maximize the yield rate of the portfolio selected?
5. How do your responses to part (a) change if your only goal is to maximize the growth rate of the portfolio selected?