Polaris Industries has \(\$ 1,250,000\) available for additional innovations on the Victory Vision motorcycle. These include the five divisible, equal-lived alternatives, each of which guarantees the investment can be exited after 6 years with the initial investment returned. In addition, each year Polaris will receive an annual return as noted below. MARR is 15 percent.

a. Determine the optimum portfolio, including which investments are fully or partially selected (if partial, give percentage). You may use Excel \(\mathbb{R}\); do not use SOLVER.

b. Determine the optimum portfolio and its PW, specifying which investments are fully or partially (give percentage)
selected using (1) the current limit on investment capital, (2) plus 20 percent, and (3) minus 20 percent. Use Excel®
and SOLVER.

c. Determine the optimum portfolio and its PW, specifying which investments are fully or partially (give percentage) selected using (1) the current MARR, (2) plus 20 percent, and (3) minus 20 percent. Use Excel \(®\) and SOLVER.

d. Determine the optimum investment portfolio and its PW when Investments 1, 2, and 3 are indivisible and Investments 4 and 5 are divisible. Use Excel \(\Re\) and SOLVER.

Transcribed Image Text:

Investment 1 2 3 4 5 Initial Investment $350,000 $300,000 $250,000 $500,000 $400,000 Annual Return $90,000 $85,000 $75,000 $130,000 $115,000