Explore BrainMass

Risk Return Analysis of a Stock and a Bond

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

I have to analyze two securities, a stock and a bond: General Electric (GE) and the selected bond is Santa Rosa, California Wastewater Series A. For each security, I need to answer the following questions and support it with mathematical calculations. (at least 600 words).

Investment Portfolio Project: Risk/Return analysis
In preparation for your Risk/Return Analysis, complete the following activities:

a. Conduct a risk assessment and return analyses on the investment vehicles included in your investment portfolio.

b. Select the weights of each vehicle in your investment portfolio, (e.g., the percentage of the portfolio each vehicle will make up).

c. Locate the Beta for each security (use .3 Beta for bonds and 0 for money market instruments).

d. Calculate the weighted average risk and return of your portfolio. Then, change the weights of the vehicles in your portfolio to emphasize the high-return performers.

e. Perform another risk assessment using these weightings. Change the weights of the vehicles in your portfolio to emphasize the low-risk performers. Perform another risk assessment using these weightings.

The selected bond issued by Santa Rosa, California Wastewater Series A. The maturity date for this bond is September 1, 2024. The interest rate is 4.375%, and the CUSIP # is 802649NT6.


Be sure to properly cite the source(s) of the data that you used for your calculations. I'm not very good with math so for computational problems please use either Word or Excel and show step by step on how you obtain the answers. Thanks.

© BrainMass Inc. brainmass.com October 25, 2018, 1:16 am ad1c9bdddf

Solution Summary

This solution shows step-by-step calculations in an Excel file to analyze a stock and a bond for General Electric. It calculates the averaged return, standard deviation, yield, and coefficient of correlation on bond and the stock.

See Also This Related BrainMass Solution

Risk Analysis in Investments

1) Graph and explain the risk profile for the following:

Risk Expected Return
0.10 0.07
0.14 0.10
0.20 0.15
0.30 0.25

2) Given the following two investment options, explain what an investor would choose and why:

Investment 1, an investment that is guaranteed a 6.5 percent return.

Investment 2, an investment that has a probability 0.25 of earning 5%, a 0.50 probability of earning 10%, and a 0.25 probability of earning 0%.

3) Explain which of the investments below are riskier and why:

Corporate stocks
Corporate bonds
Treasury bonds

4) For the class of investors below, explain which investment vehicle they are likely to choose based on its risk profile (stock, corporate bond, and Treasury bond):

A retiree that is looking for a safe investment
A 28-year-old MBA graduate looking for high returns
A forty-something professional looking for good investment income

View Full Posting Details