Purchase Solution

Treynor Ratio or Sharpes Ratio

Not what you're looking for?

Ask Custom Question

See attached.

Stock Quantity Shares FMV Annual Dividend Beta Tax Basis Recent returns
2009 Recent returns
2010 Recent returns 2011 Recent returns 2012 Recent returns 2013
A
100 30,000 1.00 1.20 19,150 8 10 10 11 8
B
300 75,000 0.30 1.40 52,452 9 5 (3) 12 15
C
400 60,000 0.70 0.90 43,187 6 7 7 8 6
D
250 35,000 0.00 1.15 23,389 7 8 8 9 10

The coefficient of correlation between the market and the stock portfolio is 0.7% over the past 5 years. The market has yielded a geometric return of 6.8%

I'd like to see what the either the Sharpe Ratio is, or the Treynor Ratio. I'd like it in spreadsheet form as well. I'd also like to see which would be the best stock to sell. Do I look at recent returns or do I look at Tax basis and why?

Attachments
Purchase this Solution

Solution Summary

This solution helps to answer related with stock valuation. Treynor ratios and sharpes ratios are analyzed. The expert provides an Excel file.

Solution Preview

Get the answer with the attachment.

Coefficient of correlation between market return and stock portfolio 0.70%
Market rate of ...

Solution provided by:
Education
  • MBA, Indian Institute of Finance
  • Bsc, Madras University
Recent Feedback
  • "I've posted a similar question for another course. It's post 657940, and it's a practice problem that I'd like to use for the final exam. Your help will be greatly appreciated. "
  • "thank you!"
  • "Thank you again Jayant. You are super fast. "
  • "Thank you Jayant. You are appreciated. "
  • "Again, thank you Jayant. You are wonderful. "
Purchase this Solution


Free BrainMass Quizzes
Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.