I have a similar problemWorried)

Bond A: 9.5% return/long maturity/high risk/tax free yes
Bond B: 8.0/short/low/yes
Bond C: 9.0/long/low/no
Bond D: 9.0/long/high/yes
Bond E: 9.0/short/high/no

AT LEAST 50% of money must be in short-term
NO MORE THAN 50% in high risk
AT LEAST 30% should be tax free
AT LEAST 40% of total annual return should be tax free

Maximize ROI: How much should be invested in each bond?

Here's what I have so far:

Max ROI: .095A+.08B+.09C+.09D+.09E

a+b+c+d+e = 100,000
Short term: B+E greaten than or equal to 50,000
High Risk: A+D+E less than equal to 50,000
Tax Free: A+B+D greater than equal to 30,000
40% tax free return: .40(A+B+C+D+E greater than equal to A+B+D

Is this right so far??? Especially the 40% tax free return part???

I don't understand how to input this into excel solver to get the answer and sensitivity report????? I copied my excel below ... hopefully it shows up on the post...

Your help is greatly appreciated!!!!!


Bond A
Bond B
Bond C
Bond D
Bond E

Return Quantity 0 0 0 0 0
0
Rates of Return 0.095 0.08 0.09 0.09 0.09









Bond A - X1 1 0 0 0 0

Bond B - X2 0 1 0 0 0

Bond C - X3 0 0 1 0 0

Bond D - X4 0 0 0 1 0

Bond E - X5 0 0 0 0 1









Short Term 0 1 0 0 1

High Risk 1 0 0 1 1

Tax Free Inv. 1 1 0 1 0

Total 1 1 1 1 1