Explore BrainMass
Share

# Portfolio Questions

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

Attached is an excel sheet on a portfolio.

What is the current yield on the equities portfolio?
a. 2.02 b. 2.03 c. 2.06 d. 2.86
CY = annual income / price
I tabulated Annual Inc/Share = 5.145
I then divided by the price of all equities = 69.9.
Do I need to take the annual income * shares / divide by the FMV = .042?

What is the weighted geometric average return of the equities in portfolio?
a. -1.4 b. 3.22 c. 3.71 d. 4.22 e. 7.61
I need to take the square root of the 2011 returns

What is the weighted beta of portfolio?
Divide individual Cost Basis by 134000

Find Treynor performance measure index and rank from highest to lowest. (Using the geometric average return over the 5 year period.)
What I am unable to calculate is the geometric average over the 5-yr period. Please advise.
From there, T = r(p)-r(free)/Beta
Wouldn't Risk free rate be .0006? - 3month t-bill?

What is the YTM of the Texas Instruments Bond?
P = pmt/(1+i)^n
I need to find the payment. I don't know how to do that. From there, I think I can find it. Is this correct?

#### Solution Preview

Note that I reformatted the Excel file for easier computation. I highlighted the cells I changed with GREY.

Question 1. What is the current yield on the equities portfolio?
2.02 b. 2.03 c. 2.06 d. 2.86
Current yield = Annual income/Current price
Since we are computing for the current yield of the equities portfolio, we replace annual income per share with Total Annual Income for the entire portfolio which I computed and highlighted with YELLOW in the Excel file. The current price is to be replaced by the portfolio's fair market value
Given this the formula for the current yield is
CY = \$5,667/\$134,000 = 4.23%

Now, may I ask where you got the data - FMV and Annual Income Per Share - from?
I checked the price of the stocks at the end of December 31, 2011 and the values in the FMV are not the market values of these stocks at the end of 2011. For example, on December 31, 2011 Boeing has a market price per share of \$70.80 which translates to an FMV of \$28,320 for 400 shares

Please verify your input data. If FMV are different, you only need to change these figures and the current yield, highlighted in ORANGE, ...

#### Solution Summary

The current yield on the equities portfolio are analyzed.

\$2.19