Nancy Carol Olter, Inc.

Nancy CarolOlter, 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:What is Olter's beta coefficient?How does the beta coefficient influence the firm's stock value?What is the required rate of return for Olter?In terms of risk, how does Olter compare to the average firm in the market?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, February 25, 2014, submit the completed assignment to the W5: Assignment 2 Dropbox. 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.Name your document SU_FIN2030_W5_A2_part1_LastName_FirstInitial.Part Two: Final Project 4: Portfolio Return and Risk; Report and PresentationPart A: Portfolio Return and RiskRequired: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.Obtain the closing price, the change in price from the previous day, and the beta.Calculate the return on holding the stock for a day (this should be the change in price over the closing price without the change).Calculate a portfolio return with weights of 0.25 for each stock.Calculate a weighted beta with weights of 0.25 for each stock.Summarize the implications of the portfolio return and risk with respect to what you learned about beta and the CAPM.Deliverable:By Tuesday, February 25, 2014, submit the completed assignment to the W5: Assignment 2 Dropbox. 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.Name your document SU_FIN2030_W5_A2_part2_LastName_FirstInitial.Part B: Report and PresentationRequired: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: AmortizationWeek 3: Portfolio AnalysisWeek 4: Government SecuritiesWeek 5: Portfolio Return and RiskAnalyze and present your findings in a comprehensive final report.Deliverables: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.Name your document SU_FIN2030_Final_Report_LastName_FirstInitial.By Tuesday, February 25, 2014, submit your responses to this Final Project assignment to the W5: Assignment 2 Dropbox.By Tuesday, February 25, 2014, 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, February 25, 2014. Be prepared to answer questions and comment on at least two other presentations.