Questions Uploads

portfolio

/in /by

I need my question solved in excel so I can see how the problem is constructed. I seen that they question was asked before; however, I did not see how a person can solve the problem in excel, can someone help me? I know the answer like I said, but I need the answer in excel so I can see how a person can solve this question. Thanks

  • (P2-43) An investor is considering three different television news stocks to complement his portfolio: British Broadcasting Company (BBC), Canadian Broadcasting Company (CBC), and Australian Broadcasting Company (ABC). His broker has given him the following information:
Short-Term Growth (per $ invested)Intermediate Growth (per $ invested)Dividend Rate
BBC0.391.598%
CBC0.261.704%
ABC0.421.456%

The investor’s criteria are as follows: (1) The investment should yield short-term growth of at least $1,000; (2) the investment should yield intermediate-term growth of at least $6,000; and (3) the dividends should be at least $250 per year. Determine the least amount the investor can invest and how that investment should be allocated between the three stocks.

Invest $2,555.25 in BBC and $1,139.50 in CBC Total investment = $3,694.75

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

Module 5 – Solution

/in /by

Hello, I seen that you all answered a question that I have. It is dealing with Module 5 – Solution.rar This question was completed on 01-16-16. 

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

probability

/in /by

Now, let’s say that you know just enough of these obscure languages to translate the first question in T1:

What time is it? (Klingon)

(Swahili): From dawn to setting sun. (Navajo)

(Swahili): Flowers grow around my house (Esperanto) so all of you may come in. (Klingon)

(Swahili): The sandwich will be eaten (Esperanto) because we are Klingons! (Klingon)

(Swahili): It’s mid-afternoon. (Navajo) [correct answer]

Now the probability of passing T1 has changed because you only have to guess correctly on one of the two remaining questions in the first section, a one-in-two chance.

What is the new probability for T1?

Now what is the overall probability of passing the entire test?

And what is the probability of passing section T3, given that you have already passed sections T1 and T2?

The kicker: How do you explain the difference between 4c and 5c? Can you relate this to a larger context about conditional probability and making decisions?

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

multiple choice test

/in /by

multiple choice test. If each question has four choices and you guess on each question, what is the probability of getting one question correct? [Hint: This is a binomial in the form of 10 choose 1 with p=.25.] Problem 2: What is the probability of getting seven questions correct? [Hint: This is a binomial as Q1 with modified choose value.] Problem 3: What are your chances of answering seven questions correctly if you can reliably eliminate one possible answer from each question? [Hint: This is a binomial as Q2 with a modified p value.] Problem 4: Let’s say, instead, that the test is an adaptive test; you get to answer more questions based on your previous success.

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"