Gymnastics4Life (G4L) is a high-end facility for beginning, intermediate, and elite gymnasts. The latter are drawn from the nearby region for exclusive and dedicated training. In order to maintain their edge, G4L trustees wish to invest up to \(\$ 350,000\) in new methods for critical evaluation and training and are considering the following independent, indivisible, investments that guarantee return of the initial investment at the end of a 7-year planning horizon. In addition, G4L will receive annual returns as noted below. MARR is 12 percent.

For the original problem:

a. Which alternatives should G4L select to form the optimum portfolio?

b. What is the present worth for the optimum portfolio?

c. What is the IRR for the optimum investment portfolio?
During review, the G4L trustees judge Investments 2 and 5 to be mutually exclusive.

d. Which alternatives should now be selected?

e. What is the present worth for G4L's new optimum investment portfolio?

f. What is the IRR for the portfolio?
Consider the original problem using SOLVER for sensitivity analysis:
g. Determine the optimum portfolio (state the investments selected and the portfolio PW) using (1) the current limit on investment capital, (2) plus 20 percent, and (3) minus 20 percent.
h. Determine the optimum portfolio (state the investments selected and the portfolio PW) using (1) the current MARR, (2) plus 20 percent, and (3) minus 20 percent.

Transcribed Image Text:

Investment 1 2 3 4 5 Initial Investment $150,000 $130,000 $100,000 $160,000 $200,000 Annual Return $24,000 $22,000 $15,000 $25,000 $30,000