Rex Electric has decided to move into low-rise (2 to 8 floors) commercial building electrical wiring. After great success in upscale residential and small commercial wiring, they have identified four independent and divisible investments, any or all of which will help make the move to the next level. Rex Electric’s MARR is 10 percent, and

$500,000 is available for investment immediately, with $175,000 available for follow-up investment the next year.

a. Determine the optimum portfolio, including which investments are fully or partially selected (if partial, give percentage). You may use Excel®; 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 at the end of year 0, (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 2 and 4 are indivisible, Investments 1 and 3 are divisible, and only $125,000 in investment capital will be available for follow-up investment at the end of year 1. Use Excel® and SOLVER.

Transcribed Image Text:

EOY CF(1) CF(2) CF(3) CF(4) 0 -$50,000 -$125,000 -$200,000 -$250,000 1 -$100,000 -$75,000 $50,000 $75,000 2 $50,000 $70,000 $50,000 $75,000 3 $50,000 $70,000 $50,000 $75,000 4 $50,000 $70,000 $50,000 $75,000 5 $50,000 $70,000 $75,000 $75,000 6 $50,000 $70,000 $75,000 $85,000 7 $50,000 $70,000 $75,000 $85,000 8 $50,000 $70,000 $75,000 $85,000 9 $50,000 $70,000 $75,000 $85,000 10 $75,000 $100,000 $75,000 $100,000