Purchase Solution

Portfolio Questions

Not what you're looking for?

Ask Custom Question

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.
5.145/69.9 = .073 - Way off of the list of answers. Please advise.
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
√(1-[-.05])(1+[-.06])(1+[.01])(1+.03)(1+.02) = .9529 - once again, not close to answers. Please advise.

What is the weighted beta of portfolio?
Add FMV = 134000
Divide individual Cost Basis by 134000
Mult those answers by beta
Add those figures = 1.08

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?

Purchase this Solution

Solution Summary

The current yield on the equities portfolio are analyzed.

Solution Preview

Below is your tutorial.
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, ...

Purchase this Solution

Free BrainMass Quizzes

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Basics of corporate finance

These questions will test you on your knowledge of finance.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.