PROBLEM 12.26
a LOAD THE PORTFOLIO FROM HIGHEST IRR TO LOWEST IRR
OPTIMAL PORTFOLIO 6 1 7 9 4 5 10
PERCENT 100% 100% 100.00% 100% 100% 100.00% 50%
TOTAL PW $1,058,608.60
TOTAL INVESTMENT $2,500,000.00
SEE BELOW FOR DETAILS
INVESTMENT OPPORTUNITY 1 2 3 4 5 6 7 8 9 10
INITIAL INVESTMENT $150,000.00 $200,000.00 $225,000.00 $275,000.00 $350,000.00 $400,000.00 $475,000.00 $500,000.00 $550,000.00 $600,000.00
ANNUAL RETURN $35,000.00 $38,000.00 $45,000.00 $60,000.00 $75,000.00 $95,000.00 $110,000.00 $85,000.00 $120,000.00 $125,000.00
SALVAGE VALUE $25,000.00 $50,000.00 $22,500.00 $27,500.00 $55,000.00 $75,000.00 $50,000.00 $100,000.00 $75,000.00 $75,000.00
PRESENT WORTH $74,698.43 $52,770.71 $60,180.24 $104,276.47 $132,047.41 $212,649.62 $220,179.55 $60,842.53 $216,263.80 $196,986.63
INTERNAL RATE OF RETURN 20.15% 15.37% 15.72% 17.99% 17.81% 20.73% 19.65% 12.56% 18.18% 16.91%
INTERNAL RATE OF RETURN 20.15% 15.37% 15.72% 17.99% 17.81% 20.73% 19.65% 12.56% 18.18% 16.91%
VALUE OF x 1 0 0 1 0.428571429 1 1 0 1 0
PORTFOLIO INVESTMENT $150,000.00 $0.00 $0.00 $275,000.00 $150,000.00 $400,000.00 $475,000.00 $0.00 $550,000.00 $0.00 $2,000,000.00
PORTFOLIO PRESENT WORTH $74,698.43 $0.00 $0.00 $104,276.47 $56,591.75 $212,649.62 $220,179.55 $0.00 $216,263.80 $0.00 $884,659.61
MARR 10% CAP CONSTRAINT $2,000,000.00
INVESTMENT PERIOD 10
REALIZED INITIAL INVESTMENT $150,000.00 $0.00 $0.00 $275,000.00 $150,000.00 $400,000.00 $475,000.00 $0.00 $550,000.00 $0.00 $2,000,000.00
d OPTIMAL PORTFOLIO 6 1 7 9 4 10 5
PERCENT 100% 100% 100% 100% 100% 100% 14.29%
TOTAL PW $1,043,918.42
TOTAL INVESTMENT $2,500,000.00
SEE BELOW FOR DETAILS
INVESTMENT OPPORTUNITY 1 2 3 4 5 6 7 8 9 10
INITIAL INVESTMENT $150,000.00 $200,000.00 $225,000.00 $275,000.00 $350,000.00 $400,000.00 $475,000.00 $500,000.00 $550,000.00 $600,000.00
ANNUAL RETURN $35,000.00 $38,000.00 $45,000.00 $60,000.00 $75,000.00 $95,000.00 $110,000.00 $85,000.00 $120,000.00 $125,000.00
SALVAGE VALUE $25,000.00 $50,000.00 $22,500.00 $27,500.00 $55,000.00 $75,000.00 $50,000.00 $100,000.00 $75,000.00 $75,000.00
PRESENT WORTH $74,698.43 $52,770.71 $60,180.24 $104,276.47 $132,047.41 $212,649.62 $220,179.55 $60,842.53 $216,263.80 $196,986.63
INTERNAL RATE OF RETURN 20.15% 15.37% 15.72% 17.99% 17.81% 20.73% 19.65% 12.56% 18.18% 16.91%