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 qualitative data has been described as voluminous

Question: Qualitative data has been described as voluminous and sometimes overwhelming to the researcher. In what ways could a researcher manage and organize the data? The response must be typed, single spaced, must be i ...

Discussion 1 screening and assessment toolswhat is

Discussion 1: Screening and Assessment Tools What is important to know and when is it important to know it? To intervene in a problem, a social worker must first identify the problem. Screening and initial assessment can ...

Question 1 guiding principles synthesize the fundamental

Question: 1. Guiding principles synthesize the fundamental philosophy or beliefs of an organization and reflect the kind of the company that an organization seeks to be. Access to the web site of Toyota and answer briefl ...

Topic and outline natural scientists have often been

Topic and Outline Natural scientists have often been confronted with ethical dilemmas as they make the connection between pure research and human application of the research. From our reading and our discussions, you sho ...

Assessment description this assessment aims to build

Assessment Description: This assessment aims to build analytical, team work and presentation skills. Students will form groups and will choose a country. Each group will provide a response to the question in reference to ...

Case study - domus developments to build or not to

Case Study - Domus Developments: To Build or Not to Build? Question: 1. Prepare a 24-month cash budget for building North Point, starting in May 2014. (no need to calculate just analysis the result, I have answer paper a ...

Question for this discussion find a couple of sources that

Question: For this discussion, find a couple of sources that explain cultural differences. These can be internet websites (this is on time you can use sources such as Wikipedia or other websites). Give an overview of sev ...

Discussion questions evaluate the importance of maritime

Discussion Questions: Evaluate the importance of maritime trade and the Maritime Transportation System to the world economies and compare the challenges associated with port security. As part of your discussion, highligh ...

Assignment 1 human sexuality throughout history

Assignment 1: Human Sexuality Throughout History Time-line Our readings describe the various historical-cultural influences that have affected human sexuality. These historical-cultural influences include such events as ...

Question topics consumer adoption market growth strategies

Question: TOPICS: Consumer Adoption, Market Growth Strategies, New Product Development, Product Management SUMMARY: Amazon is offering makers of electronics a small chip that would let people use their voice to command e ...

  • 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