Question

In: Accounting

An investor is considering allocating $10,000 among five investment alternatives. The five alternatives and their respective...

An investor is considering allocating $10,000 among five investment alternatives. The five alternatives and their respective fund categories, risk levels, and average annual returns are shown below:

Name of Fund Category of Fund Risk Level Average Annual Return

Adams Money Market Fund 1 4.50%

Barney Money Market Fund 2 5.62%

Chilton Bond Fund 2 6.80%

Dunster Bond Fund 3 10.15%

Excelsior Aggressive Growth Fund 5 20.60%

The risk level of each investment is rated on a scale of 1 to 5, where 1 is very conservative and 5 is very risky. The investor would like to maximize the average annual return on his investment subject to the following restrictions:

The weighted average risk level of the entire investment should not exceed 2.5, where the weight of each fund is proportional to the amount of money invested into the fund.

At least 30% of the investment should be placed in money market funds.

At most $2,000 should be invested in the aggressive growth fund.

Let A, B, C, D, E denote the amounts of money invested in Funds Adams, Barney, Chilton, Dunster and Excelsior, respectively. Construct the math model using the decision variables defined to solve this decision problem

Solve your math model using Excel solver to determine the optimal allocation of the investor’s money. To submit your answer, please provide numerical values as accurate as possible

The maximum average annual return is =

A =

B =

C =

D =

E =

Solve your math model using Excel solver to determine the optimal allocation of the investor’s money. To submit your answer, please provide numerical values as accurate as possible

The maximum average annual return is $1.

A = 2.

B = 3.

C = 4.

D = 5

b) How many binding constraints do we have at least to solve this problem?

c)What are the binding constraints for the optimal solution identified?

Solutions

Expert Solution


Related Solutions

ABC is considering two investment alternatives. Alternative A requires an initial investment of $10,000; it will...
ABC is considering two investment alternatives. Alternative A requires an initial investment of $10,000; it will yield incomes of $3000, $3500, $4000, and $4500 over its 4-year life. Alternative B requires an initial investment of $12,000; it is anticipated that the revenue received each year will increase at a rate of 10%/year (each year’s revenue is 10% higher than that of the preceding year). Based on an interest rate of 12% compounded annually, what must be the revenue at the...
ABC is considering two investment alternatives. Alternative A requires an initial investment of $10,000; it will...
ABC is considering two investment alternatives. Alternative A requires an initial investment of $10,000; it will yield incomes of $3000, $3500, $4000, and $4500 over its 4-year life. Alternative B requires an initial investment of $12,000; it is anticipated that the revenue received each year will increase at a rate of 10%/year (each year’s revenue is 10% higher than that of the preceding year). Based on an interest rate of 14% compounded annually, what must be the revenue at the...
Kopecky Industries Inc. is considering allocating a limited amount of capital investment funds among four proposals....
Kopecky Industries Inc. is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated income from operations, and net cash flow for each proposal are as follows: Project Name Sierra Tango Uniform Victor Investment $862,500 Investment $2,025,000 Investment $1,433,320 Investment $1,040,013 Year Income from Operations Net Cash Flows Income from Operations Net Cash Flows Income from Operations Net Cash Flows Income from Operations Net Cash Flows 1 $80,500 $230,000 $279,000 $900,000 $180,000...
. Suppose that an investor with a five-year investment horizon is considering purchasing a seven-year 9%...
. Suppose that an investor with a five-year investment horizon is considering purchasing a seven-year 9% coupon bond selling at par. The investor expects that he can reinvest the coupon payments at an annual interest rate of 9.4% and that at the end of the investment horizon two-year bonds will be selling to offer a yield to maturity of 11.2%. What is the five-year total return for this bond?
1. Can we use benefit-cost analysis to choose among alternatives in allocating funds for building projects?...
1. Can we use benefit-cost analysis to choose among alternatives in allocating funds for building projects? 2. Is the net-investment test the only way to accurately predict project borrowing? need the answer without plagarism
Suppose that an investor with a five-year investment horizon is considering purchasing a seven-year 9% coupon...
Suppose that an investor with a five-year investment horizon is considering purchasing a seven-year 9% coupon bond selling at par (semi-annual coupon payments). The investor expects that he can reinvest the coupon payments at an annual interest rate of 9.4% and that at the end of the investment horizon two-year bonds will be selling to offer a yield to maturity of 11.2%. What is the total of coupon and coupon reinvestment?  (Round your answer to 2 decimal points) What is the...
Suppose that an investor with a five-year investment horizon is considering purchasing a seven-year 7% coupon...
Suppose that an investor with a five-year investment horizon is considering purchasing a seven-year 7% coupon bond selling at par. The investor expects that he can reinvest the coupon payments at an annual interest rate of 9.4% and that at the end of the investment horizon two-year bonds will be selling to offer a yield to maturity of 11.2%. What is the total return on this investment? Extra information: Draw the cashflows of the 7 year bond. Using Par Value...
Five investment alternatives have the following returns and standard deviations of returns.        Alternatives Returns: Expected...
Five investment alternatives have the following returns and standard deviations of returns.        Alternatives Returns: Expected Value Standard Deviation A $ 1,110 $ 1,270 B 3,970 820 C 3,970 1,330 D 5,790 2,650 E 12,500 7,350      Calculate the coefficient of variation and rank the five alternatives from lowest risk to the highest risk by using the coefficient of variation. (Round your answers to 3 decimal places.)   
If an investor pays $10,000 for an investment today that is anticipated to produce net sale...
If an investor pays $10,000 for an investment today that is anticipated to produce net sale proceeds of $28,300 at end of year 10, what is the anticipated IRR?
An investor pays $10,000 today to purchase an investment that returns $5,000 at the end of...
An investor pays $10,000 today to purchase an investment that returns $5,000 at the end of each of years 2, 4, and 5. The returns are immediately reinvested at an annual interest rate of 5%. Calculate the annual effective yield rate for the investor at the end of the fifth year. (a) 9.91% (b) 12.00% (c) 12.45% (d) 13.11% (e) 15.13%
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT