Our Services

Get 15% Discount on your First Order

risk-returnAssignment 2a. Use the year-end stock price data given to calculate annual returns for Bartman, Reynolds, and the Market Index, and the

risk-return

Assignment 2
a. Use the year-end stock price data given to calculate annual returns for Bartman, Reynolds, and the Market Index, and then calculate average returns over the five-year period. Remember, returns are calculated by subtracting the beginning price (previous year year-end price) from the ending price (current year year-end price) to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning price (previous year year-end price). Assume that dividends are already included in the index., so in your calculation of index return, you don’t need to add the dividend. Also, you cannot calculate the rate of return for 2002 because you do not have 2001 data.)
Data as given in the problem are shown below:
Bartman IndustriesReynolds IncorporatedMarket Index
YearStock PriceDividendStock PriceDividendIncludes Divs.
2007\$17.250\$1.150\$48.750\$3.00011,663.98
200614.7501.06052.3002.9008,785.70
200516.5001.00048.7502.7508,679.98
200410.7500.95057.2502.5006,434.03
200311.3750.90060.0002.2505,602.28
20027.6250.85055.7502.0004,705.97
We now calculate the rates of return for the two companies and the index:
BartmanReynoldsIndex
2007

Kenneth D. Jackson: Change in stock price plus any dividends, divided by the previous stock price
2006
2005
2004
2003
Average
Note: To get the average, you could get the column sum and divide by 5, but you could also use the function wizard, fx. Click fx, then statistical, then Average, and then use the mouse to select the proper range. Do this for Bartman and then copy the cell for the other items.
b. Calculate the standard deviation of the returns for Bartman, Reynolds, and the Market Index. (Hint: Use the sample standard deviation formula given in the chapter, which corresponds to the STDEV function in Excel.)
Use the function wizard to calculate the standard deviations.
BartmanReynoldsIndex
Standard deviation of returns
c. Now calculate the coefficients of variation Bartman, Reynolds, and the Market Index.
BartmanReynoldsIndex
Coefficient of Variation
d. Estimate Bartman’s and Reynolds’s betas as the slope of a regression with stock return on the vertical axis (y-axis) and market return on the horizontal axis (x-axis). (Hint: use Excel’s SLOPE function.)
Bartman’s beta =
Reynolds’ beta =
e. The risk-free rate on long-term Treasury bonds is 6.04%. Assume that the market risk premium is 5%. What is the expected return on the market? Now use the SML equation to calculate the two companies required returns.
Risk-free rate =6.040%
Expected return on market =Risk-free rate+Market risk premium
=+
=
Bartman:
Required return=+x
=
Reynolds:
Required return=+x
=
f. If you formed a portfolio that consisted of 50% Bartman and 50% Reynolds, what would be its beta and its required return?
The beta of a portfolio is simply a weighted average of the betas of the stocks in the portfolio, so this portfolio’s beta
would be:
Portfolio beta =
g. Suppose an investor wants to include Bartman Industries’ stock in his or her portfolio. Stocks A, B, and C are currently in the portfolio, and their betas are 0.769, 0.985, and 1.423, respectively. Calculate the new portfolio’s required return if it consists of 25 percent of Bartman, 15 percent of Stock A, 40 percent of Stock B, and 20 percent of Stock C.
BetaPortfolio Weight
Bartman25%
Stock A0.76915%
Stock B0.98540%
Stock C1.42320%
100%
Portfolio Beta =
Required return on portfolio:= Risk-free rate +Market Risk Premium * * Beta
=
=

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

MBA 6211 Managerial Decision Making Spring 2024 Final Exam Name ………………..……………….Show All Work, Box Final Answers. Dr.

MBA 6211 Managerial Decision Making Spring 2024 Final Exam Name ………………..………………. Show All Work, Box Final Answers. Dr. Nayebpour Note: This is an individual take home exam. Do not discuss, receive or help anyone for completion of this test. I am available via email for any question you may have.

1. A \$1,000 Expo Corp. bond has a coupon rate of 5%, pays interest semiannually, and matures in six years. If the yield to maturity is 7%, what is the bond’s

1. A \$1,000 Expo Corp. bond has a coupon rate of 5%, pays interest semiannually, and matures in six years. If the yield to maturity is 7%, what is the bond’s value today? 2 . A \$1,000 Omega Corp. bond has an 8% coupon rate that is paid semiannually. The bond matures

Example 4-3To compute the tax using the 2023 Percentage Method for Manual Payroll Systems With Forms W-4 From 2020 or Later

Example 4-3 To compute the tax using the 2023 Percentage Method for Manual Payroll Systems With Forms W-4 From 2020 or Later using Standard Withholding Rate Schedules, follow the steps illustrated below. Step 1 Determine the amount of gross wages earned, filing status, adjustments on Form W-4, and frequency of

2/29/24, Assignment InformationPage 1 of 2BUS 210 Project Two Guidelines and RubricCompetencyIn this project, you will demonstrate your mastery of the

2/29/24, Assignment Information Page 1 of 2 BUS 210 Project Two Guidelines and Rubric Competency In this project, you will demonstrate your mastery of the following competency: Identify yourself as a leader and follower to be effective as an individual and team contributor Overview Many well-known leaders wrote and continue

Reconstruct the correct entries under accrual accounting principles and post the effects to T accounts

Reconstruct the correct entries under accrual accounting principles and post the effects to T accounts

Hello Class, Healthcare quality is a major factor within healthcare and the most focus, therefore antitrust laws are adopted by many healthcare service and

Hello Class, Healthcare quality is a major factor within healthcare and the most focus, therefore antitrust laws are adopted by many healthcare service and everyone want to improve.  As there are three types of antitrust laws; which the core U.S. antitrust law created three pieces of legislation:  the Sherman Anti-Trust

1. As we selected this real-world crisis below, which related to international financial management. Write a paper discussing the event and create a PowerPoint

1. As we selected this real-world crisis below, which related to international financial management. Write a paper discussing the event and create a PowerPoint presentation. Remember to include a chart in your paper, also ensure proper citation of your work, MLA format. 2. Explain the cause of this crisis, and

Reply at least 120 words(ONE) Methods of estimating costs Estimation of the costs is required in terms of showcasing the project cost for a business

Reply at least 120 words(ONE) Methods of estimating costs Estimation of the costs is required in terms of showcasing the project cost for a business organisation. There are several methods in terms of considering the different types of costs. Some common methods can be applied in the context of an

Exam Content 1. Top of Form As a program manager, you must establish practices that’ll best serve the projects you don’t directly oversee and strategize ways

Exam Content 1. Top of Form As a program manager, you must establish practices that’ll best serve the projects you don’t directly oversee and strategize ways to streamline organizational processes. You will use skills like project coordination to help you organize stakeholders and project team members, affirm their roles and responsibilities,

Session 2Literature Review – 2100 words · Contains the theoretical framework of your report project · The result of an

Session 2 Literature Review – 2100 words · Contains the theoretical framework of your report project · The result of an academic literature search; primarily derived from recognized ‘academic’ sources, e.g., Books and peer reviewed journals. · ‘Themed’ literature review – as opposed to chronological, alphabetical etc. · Translate ideas

Business Finance – Operations Management Scheduling resources using the assignment method

Business Finance – Operations Management Scheduling resources using the assignment method

1Relative and Private Company ValuationsINSTRUCTIONS: Turnitin is required. So, please show all work.1. First Safe Interstate Bank is a small, regional

1 Relative and Private Company Valuations INSTRUCTIONS: Turnitin is required. So, please show all work. 1. First Safe Interstate Bank is a small, regional bank that is trading at a price to book (equity) ratio of 1.50. The bank is in stable growth, with earnings and dividends expected to grow

Sheet1 Costing Ready Reckoner Fabric ready Reckoner Price per m US\$ From To Tshirt Jeans /Trousers Trs /Dress Jackets Denim Kids Adults Kids Adults Kids Adults Kids Adults Single jersey cotton Prices in US cents Cotton /poly jersey Thread 0.03 0.05 0.08 0.1 0.08 0.1 0.1 0.15 240g Brush /

Course Name 48500 01I Semester 2 2024Learning JournalUse this template like a recipe to do your journal assignment.

Course Name 48500 01I Semester 2 2024 Learning Journal Use this template like a recipe to do your journal assignment. Review the Brightspace item “Learning How to Learn: Guidance on Learning Journal Assignments.” Be sure to read the PDFs (embedded links) and watch the short videos (embedded links). Then, follow

Week 9 Assignment – An Ethical Quandary Overview In last week’s activity, you described how public health managers can effectively promote an “ethics-focused”

Week 9 Assignment – An Ethical Quandary Overview In last week’s activity, you described how public health managers can effectively promote an “ethics-focused” organizational culture. Even though an ethics-based culture may exist, applying ethics standards to scenarios presented in public health agencies is still necessary. Leaders need to have a

BUSI 601Learning Project: Contemporary Management Technique Research Paper Assignment Instructions Based on your evaluation of an

BUSI 601 Learning Project: Contemporary Management Technique Research Paper Assignment Instructions Based on your evaluation of an organization or a segment of an organization in the previous ( That is you must use the same company as used in the first project) Learning Project: Company Analysis and Evaluation Project Assignment,

Start with a brief overview of your business: company name and what you are selling (a maximum of 3 sentences). · Develop a 30-second elevator pitch for your

Start with a brief overview of your business: company name and what you are selling (a maximum of 3 sentences). · Develop a 30-second elevator pitch for your selected company using the formula provided in the article below (Do you know.. What we do.. So that.. ). · Read Robert

Discussion post 1-Explain the concept of time value of money. How would you use this in personal financial planning such as borrowing or saving for the future

Discussion post 1-Explain the concept of time value of money. How would you use this in personal financial planning such as borrowing or saving for the future? 2-Compare the process of compounding to determine future values and the process of discounting to determine present values.

You deserve a bonus!

Subscribe and get regular bonuses and discounts.