An investment company is looking for new opportunity to invest up to 4 million dollars for one year in international shares, CO2 futures, gold and Australian governmental bonds. The projected annual return on the investment in the international shares is 3%, CO2 futures are 2%, gold is 1.5%, and the Australian governmental bond is 1.8%. In anticipation of financial markets’ rebound, the company’s management imposed the following recommendations:
- The international shares and CO2 futures must not receive more than 60% of the total investment;
- Investment in CO2 futures and gold must not exceed 2 million dollars;
- No more than 40% of the funds invested in CO2 futures and gold can be invested in the Australian governmental bonds;
- No more than 25% of the funds invested in CO2 futures and the Australian governmental bonds can be invested into the international shares.
Formulate the linear program to maximize the projected annual return on the investment portfolio.
Linear program:

Formulas:

Solver:

Maximum return = 2.04% of the amount invested
An investment company is looking for new opportunity to invest up to 4 million dollars for...
i just need to know how to complete this problem step by
step.
2. (20 points) International Bank &Trust invests in trade credits, corporate bonds, gold stocks, and bonds, 14% government bonds. Annual rate of return are 7% for trade credits, 10% for corporate for gold stocks, and 5% for government bonds. The Trust has a maximum of $5 million available for investment. The Trust planning committee periodically decides investment policy regarding various investment options. The investment decision must comply...
3. [Investment, 27 pts) International City Trust (ICT) has $5 million available for investment and wishes to maximize the interest earned on its investment over the next year. The specifics of the investment possibilities are shown in the Table below. Investment Interest Earned (Return on Investment) Trade Credits 7% Corporate bonds 10% Gold stocks 19% Platinum stocks 12% Mortgage securities 8% Construction loans 14% To encourage diversified investment portfolio, the board of directors has placed several limits on the amount...
[Investment, 27 pts] International City Trust (ICT) has $5 million available for investment and wishes to maximize the interest earned on its investment over the next year. The specifics of the investment possibilities are shown in the Table below. 3. Fall 2019 MGSC 1205 Introduction to Quantitative Methods I Interest Earned (Return on Investment) Investment Trade Credits 7 % 10 % Corporate bonds Gold stocks 19 % Platinum stocks 12 % 8 % Mortgage securities Construction loans 14 % To...
The Top Investment Corporation is developing a mix of investments to meet the needs of a client with one million dollars to invest. A mix of five investments is being considered, with data on each as shown below:
The state laws and Top Investment policies impose the following restrictions on the composition of the investments: .
The total average return must be at least 12.5% where all the money must be invested.
Investments A and B together must not be...
nnis Investments manages funds for a number of companies and wealthy clients. The investment strategy is tailored to each client’s needs. For a new client, Innis has been authorized to invest up to $3 million in five investment funds: stock fund A, stock fund B, Bond fund A, Bond fund B and a money market fund. Stock fund A provides an annual rate of return of 15%, stock fund B provides an annual rate of return of 12.5%, Bond fund...
Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 5% for home loans, 13% for personal loans, and 8% for automobile loans. The bank’s planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal...
Please walk me through steps to enter into excel!
Thank you.
10. An investment advisor at Shore Financial Services wants to develop a model that can be used to allocate investment funds among four alternatives: stocks, bonds, mutual funds, and cash. For the coming investment period, the company developed estimates of the annual rate of return and the associated risk for each alternative. Risk is measured using an index between 0 and 1, with higher risk values denoting more volatility...
Max Welte has converted an industrial bond to cash and is now considering other investment opportunities for the $100,000 in his cash account. As his financial advisor, you have recommended that all new investments be made in the oil industry, in the steel industry, on in government bonds. Specifically, you have identified five investment opportunities and their projected annual rates of return. The investments and rates of return are shown in this table: Investment Projected Rate of Return (%) Atlantic...
The esteemed brokerage firm of Black, Scholes and Merton has just been instructed by one of its clients to invest $250,000 of her money obtained recently through the sale of Netflix, Inc. The client has a good deal of trust in the brokerage firm, but she also has her own ideas about the distribution of the funds being invested. In particular, she requests that the firm select whatever stocks and bonds they believe are well rated, but within the following...
Kuhn Co. is considering a new project that will require an initial investment of $4 million. It has a target capital structure of 35% debt, 2% preferred stock, and 63% common equity. Kuhn has noncallable bonds outstanding that mature in five years with a par value of $1,000, an annual coupon rate of 10%, and a market price of $1,050.76. The yield on the company's current bonds is a good approximation of the yield on any new bonds that it...