Which investments should be included in theos portfolio

Reference no: EM131686553

Problem - Theo Harris earns $55,000 a year and has $9,000 to invest in a portfolio. His investment alternatives and their expected returns are shown in the table below.

Investment	Description	Expected Return
A	IRA (retirement)	3.5%
B	Employer's retirement plan	4.5%
C	Deferred income (retirement)	8.0%
D	Unity mutual fund	7.0%
E	Liberty mutual fund	7.5%
F	Money market	5.5%

Theo's investment goals are as follows and can be ranked according to the weights shown inparenthesis. Which investments should be included in Theo's portfolio, and how much should he invest in each?

Goal 1: (25) Invest all funds available.

Goal 2: (20) Maximize the total annual return in dollars, with a target of $1,000.

Goal 3: (15) Invest at least 3% of salary in employer's retirement plan.

Goal 4: (15) Invest at least 10% of the total investment in the money market.

Goal 5: (10) Invest at most 25% of the total investment in retirement plans.

Goal 6: (10) Invest at least 50% of the total investment in non-retirement plans.

Goal 7: (5) Invest at most 50% of the total investment in mutual funds.

Which investments should be included in Theo's portfolio?

Just need the solution in excel. Thanks.

Reference no: EM131686553

Questions Cloud

Compute the rate of inflation during the year : Compute the rate of inflation during this year. Compute the real rates of return on each of the investments in your portfolio based on the inflation rate.

Variety of cultural backgrounds : If you look forward to working with individuals from a variety of cultural backgrounds, or perhaps even working in foreign countries

Innovative distribution strategy : Although cross-docking is an innovative distribution strategy, it has not been fully embraced by everyone.

Products-technologies and processes : Next, explain with relevant examples from various industries why businesses today need to rethink business models along with products, technologies.

Which investments should be included in theos portfolio : Theo's investment goals are as follows and can be ranked according to the weights shown inparenthesis. Which investments should be included in Theo's portfolio

Common initial feature of hodgkin disease : The most common initial feature of Hodgkin disease is painless, asymmetrical enlargement of cervical lymph nodes.

Calculate the current yield and capital gains yield : One year ago, Henderson Honey issued a 10-year bond for $1,000. The bond's coupon rate of interest is 4 percent, and interest is paid annually.

What role does the environment play in cognitive function : What role does the environment play in cognitive function? From the perspective of A-I theory, how are ‘creativity’ and ‘innovation’ related?

Major changes to a business : Customers must be informed of major changes to a business. Jay's Sporting Goods went through the bankruptcy process and was forced to close its stores.

User Account

All Pages