Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Homework Help/Study Tips Expert

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.

Homework Help/Study Tips, Others

  • Category:- Homework Help/Study Tips
  • Reference No.:- M92495251

Have any Question?


Related Questions in Homework Help/Study Tips

Question i understanding the flow of negotiations

Question: I. Understanding the Flow of Negotiations: Stages and Phases A. The typical steps or flow in a negotiation can be found in the phase models of negotiation: 1. Initiation. 2. Problem solving. 3. Resolution. Defi ...

Make sure this answer is original and has at least 120

Make sure this answer is ORIGINAL and has at least 120 words with correct grammar. Question: Some have criticized Judaism's concept of Jews being God's chosen people. Why do you think some might criticize this idea? Do y ...

In many ways juvenile probation is similar to adult

In many ways, juvenile probation is similar to adult probation. Both types of probation involve sanctions imposed by the court, necessitating close supervision of the offender, coupled with the looming threat of a more s ...

Question using the patient information provided respond to

Question: Using the patient information provided, respond to the following questions: (a) What cultural considerations are important for you to remember while you interview Ms. Li? (b) What is the abuse assessment screen ...

Is there any information that says children not exposed to

Is there any information that says children not exposed to language will be unable to communicate? Are children exposed to multiple languages more intelligent? What is most beneficial for language development?

Assignment - the judgment of leadersread this scenario and

Assignment - The Judgment of Leaders Read this scenario, and then prepare a succinct, 5-page essay, using the writing template, and a minimum of 5 references. Organizations are expected to encourage ethical behavior amon ...

Please answer each question separately each question must

Please answer each question separately. Each question must be 250-300 words each. Please be plagiarism free. 1. Discuss how understanding Biblical principles of planning influences decision making in healthcare. 2. As a ...

Question a shelter in place plan is used when there is

Question: A Shelter In Place plan is used when there is "reasonable assurance that movement of people will endanger them more than allowing them to remain in place" (Casserly & Bermudez, 2011). There is usually a natural ...

Assignment meritocracyexplain how the united states

Assignment : Meritocracy Explain how the United States compares to other countries with regards to social mobility rates. Are there differences between the United  States and other countries? Why? Which group in the soci ...

Be honest do you think you east a healthy diet and get all

Be Honest: do you think you east a healthy diet and get all of the vitamins and minerals mentioned in Chapter Readings? Have you even HEARD of all of them? What reasons are preventing you from eating healthy? Are they le ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As