Aerotron Radio Inc. has \(\$ 250,000\) available, and its engineering staff has proposed the following divisible investments. With each, Aerotron can exit at the end of its planning horizon of 5 years and have its initial investment returned. In addition, each year Aerotron will receive the annual return shown below. MARR is 12 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. (15.5)

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 divisible and Investments 4 and 5 are indivisible. Use Excel \(\Re\) and SOLVER.

Transcribed Image Text:

Investment 1 2 3 5 Initial Investment $75,000 $65,000 $50,000 $80,000 $100,000 Annual Return $10,800 $12,000 $7,500 $13,750 $15,750