FIN2030 week 5 assignment 2 (Graded A+) - use as a guide only - 34456

Solution Posted by
arsalanahmed

arsalanahmed

Rating : (80)A
Solution Detail
Price: $30.00
  • From: Finance,
  • Posted on: Fri 29 Nov, 2013
  • Request id: None
  • Purchased: 5 time(s)
  • Average Rating: (98) A+
Request Description

Part One: The CAPM

Olter, Inc. is starting its risk management program for the company and has asked for your help in determining critical risk measurements for the firm. The company has identified several factors in the market that they believe are critical for your tasks:

  • The risk-free rate is 6%
  • The required return on the average stock is 13%
  • Olter’s average return is 13%

Required:

1.     What is Olter’s beta coefficient?

2.     How does the beta coefficient influence the firm’s stock value?

3.     What is the required rate of return for Olter?

4.     In terms of risk, how does Olter compare to the average firm in the market?

5.     If Olter’s beta increased to 1.6, what would you expect to happen to the required rate of return and what does this mean for the firm?

Deliverable:

By Tuesday, May 14, 2013Use a Microsoft Excel spreadsheet that illustrates your calculations. You may use the formulas embedded in Microsoft Excel and/or a financial calculator for these calculations.

Part Two: Final Project 4: Portfolio Return and Risk; Report and Presentation

Part A: Portfolio Return and Risk

Required:

Select four stocks from finance.yahoo.com, google.finance.com, or moneycentral.msn.com. One should be a clothing manufacturer, one should be a retailer, one should be an automobile manufacturer, and one should be a restaurant or food producer.

1.     Obtain the closing price, the change in price from the previous day, and the beta.

2.     Calculate the return on holding the stock for a day (this should be the change in price over the closing price without the change).

3.     Calculate a portfolio return with weights of 0.25 for each stock.

4.     Calculate a weighted beta with weights of 0.25 for each stock.

5.     Summarize the implications of the portfolio return and risk with respect to what you learned about beta and the CAPM.

Deliverable:

By Tuesday, May 14, 2013, Use a Microsoft Excel spreadsheet that illustrates your calculations. You may use the formulas embedded in Microsoft Excel and/or a financial calculator for these calculations.

Part B: Report and Presentation

Required:

Combine all the research and data you have completed for the Final Project assignments from Weeks 2–4, along with your results from this week:

  • Week 2: Amortization
  • Week 3: Portfolio Analysis
  • Week 4: Government Securities
  • Week 5: Portfolio Return and Risk

Analyze and present your findings in a comprehensive final report.

Deliverables:

1.     Create a comprehensive report using Microsoft Word. Include a Microsoft Excel document that illustrates your calculations for all weeks. You may use the formulas embedded in Microsoft Excel and/or a financial calculator for these calculations.

By Tuesday, May 14, 2013,

2.     By Tuesday, May 14, 2013, create a 10–15 slide Microsoft PowerPoint presentation that summarizes your findings for all Final Project assignments completed in Weeks 2–5. Submit it to the Discussion Area by Tuesday, May 14, 2013. Be prepared to answer questions and comment on at least two other presentations. 

Solution Description

A++++++++++

Attachments
Week 5 Assignment 2 - Answer.docx
Week 5 Assignme...
Week 5 Assignment 2 - Calculations.xlsx
Week 5 Assignme...
Report (1).docx
Report (1).docx
Calculations.xlsx
Calculations.xl...
Final Presentation.pptx
Final Presentat...