Calculate the required rate of return for your investment

Assignment Help Corporate Finance
Reference no: EM131422018

You must show your work - Excel worksheet

Q1. Company ABT has asked you to calculate the beta for their portfolio.  The portfolio has the following stocks

Stock

$ Amount Invested

Beta for Each Stock

A

$ 350,000

   1.2

B

$ 125,000

      .75

C

$ 410,000

   1.9

D

$ 280,000

   1.7

Q2. Your friend has called you for some finance advice. Friend has heard you talk about the information that you have learned in your finance class.

Following is friend's question:  Assume that the stock market will be decreasing for the year and friend is interested in investing in one of the following stocks.

The two stocks are:

      Jumping High        Beta     1.75

       Going Long            Beta      -.8

Friend wants to maximize the value of the investment.  Which stock should friend acquire - please explain.

Q3. You have been given the following information:

a. The required return of the market is 14.5%

b. The risk free rate is 3.5%

c. The beta for your investment is .95

Required:

A. Calculate the required rate of return for your investment, with the above data

B. Assume that that the risk free rate has decreased to 2.5% and the slope remains constant; calculate the new required rate of return for your investment.

Q4. Congrats on your new job managing the company's investment fund.  The investment fund includes the following:

Stock

$ Amount Invested

Beta for Each Stock

A

$    600,000

    .8

B

$ 1,800,000

    1.4

C

$ 2,400,000

    1.7

D

$    700,000

     -.6

E

$ 3,000,000

     1.1

You have been asked by the CFO to calculate the required rate of return for their investment.

In your research you found that the market's required return for Year 2017 is 12% and the risk free rate is 3%.

Show your work 

A. Calculate the required rate of return for each stock in the portfolio

B. Calculate the required dollar return for each stock in the portfolio, based on your answer in A

C. Calculate the required rate of return for the entire portfolio

5. Here comes your friend again!!!  Friend has another question --- in regarding investing what is the importance of understanding the purpose of Beta.  How will you explain?

Attachment:- Assignment Files.rar

Reference no: EM131422018

Questions Cloud

Demonstrate your understanding of project management : In this assignment, you are going to demonstrate your understanding of project management and its role in the efficient and effective completion of projects.
Provide a brief analysis of your market : What evidence do you have to support your decision - How would you refute the people who chose an additional tool rather than one of the tools that you selected?
What assumptions must you make in order to use : What assumptions must you make in order to use these statistics for inference?- Write a 90% confidence interval for the mean daily income this parking garage will generate.
Write a research report review regarding recent research : Write a Research Report Review regarding recent research in the field of ergonomics and/or human factors design considerations. The Research Article Review will be very similar to the Module Case Studies you have written.
Calculate the required rate of return for your investment : Required: Calculate the required rate of return for your investment, with the above data Assume that that the risk free rate has decreased to 2.5% and the slope remains constant; calculate the new required rate of return for your investment
Explain clearly what your interval means : Find a 95% confidence interval for the mean sodium content of this brand of hot dog.- What assumptions have you made in this inference? Are the appropriate conditions satisfied?
Write a personal analysis century world exploration : Discuss from where you originate, where you are headed, why you are going there, who you discover and what they look and act like, what you bring back, and how your country of origin will react to your discoveries. Consider any other explorer that..
Solution of sodium benzoate : Calculate the pH of a 0.10 M solution of sodium benzoate (NaC6H5COO) given that the Ka of benzoic acid (C6H5COOH) is 6.50 x 10-5.
What have you learned from reading the courts decision : Based on the chapter reading, how would you have handled this conflict if you had been Hardison's manager? What have you learned from reading the court's decision?

Reviews

len1422018

3/10/2017 2:44:44 AM

Topic: Organizational Finance. Detailed Question: Here are the teacher's comments about the Week 6 Homework: "The attached worksheet include questions from Chapter 6. Each question on the exam was discussed during our Week 7 F2F class. Problem 4 on the exam was the very last problem that I finished/discussed at the end of class". I'm attaching the spreadsheet for Week 7 F2F. I'm attaching the last two worksheets that the professor posted for the study session for Week 7 & week 8. Please read those and make sure to press on the cells to see how he calculated the numbers. I have to show this work on the test per the professor's instructions.

Write a Review

Corporate Finance Questions & Answers

  Calculate net profit margin ratios using financial statement

Next, calculate the 12/31/15 and 12/31/14 ratios using the financial statements you printed, including all of the following:

  The overall impact on the monetary base

What would the overall impact be on the monetary base?  - What would be the impact, if any, on the exchange rate?

  Question first describe how financial intermediaries can

question first describe how financial intermediaries can overcome information asymmetries and information costs.second

  Produce and save employee employment details report

Produce and save Employee Employment Details Report. Check details carefully before processing any pays. Make any necessary corrections.

  Mr vasanth reddy whose accounts are recorded by single

mr. vasanth reddy whose accounts are recorded by single entry only with rs 10000 lent by his wife and rs 20000 of his

  Risk management and hedging strategy using options

Make a presentation to your board members about how you can use the Options market for Portfolio insurance with specific emphasis on its costs and benefits.

  A zero coupon bond with 100 face value is redeemable at par

a zero coupon bond with 100 face value is redeemable at par in exactly four years. you see from financial times that

  What is name of the outside auditing firm for your company

What is the name of the outside auditing firm for your company? How long after the company's year-end did the auditor's issue their opinion?

  Prepare a trend analysis of operating ratios

Prepare a trend analysis of operating ratios for at least 3 years' worth of financial data and perform a business analysis (both external and internal) for your company using the most recent information fromvarious sources.

  The following particulars were extracted from the books of

the following particulars were extracted from the books of x ltd. on 31 april 2011 the day on which a winding up order

  Scoto manufacturing is a matter firm in the machine tool

scoto manufacturing is a matter firm in the machine tool component industry the firms most recent common stock dividend

  What is long-term goal of the company

Budgeting in uncertainty is challenging. The decisions made by budget managers affect the direction and future of every company. Having a thorough understanding of the components of capital budgeting is essential to developing an appropriate budge..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd