Purchase Solution

Financial Fundamental Calculator- CAGR, Sharpe, Beta & more

Not what you're looking for?

Ask Custom Question

Attached spreadsheet calculates:

Compound Annual Growth Rate (CAGR)
Sharpe Ratio
Beta
Treynor Ratio
Jensen's Alpha
Information Ratio
R-Squared

Required inputs:
Up to 5 price points or return levels for up to two separate investments
Up to 5 price points or return levels for a market index
Up to 5 price points or return levels for a risk-free rate of return

The Word document uses a simple, hypothetical comparison of two fictional funds as an example.

Attachments
Purchase this Solution
Solution Summary

Excel spreadsheet useful for calculating various investment benchmarks. Detailed formulas and references included.

Solution Preview

CAGR: The first unanswered assumption is how you want to assess each portfolio. I recommend calculating and using CAGR rather than simply averaging the annual returns. See here for why/how: http://www.investopedia.com/terms/c/cagr.asp#axzz1WzjdqB6H

Sharpe ratio: "The greater a portfolio's Sharpe ratio, the better its risk-adjusted performance has been.," (http://www.investopedia.com/terms/s/sharperatio.asp#ixzz1X6Ega0im)

Beta: is a measure of the volatility, or systematic risk, of a security or a portfolio in comparison to the market as a whole. A beta ...

Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Operations Management

This quiz tests a student's knowledge about Operations Management

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

View More Free Quizzes
Related BrainMass Solutions

  • Financial Performance Metrics: Detailed Spreadsheet

    Calculates CAGR, Sharpe Ratio, Treynor Ratio, Beta, Jensen's Alpha, Information Ratio, Tracking Error and R-Squared. Uses two hypothetical mutual funds ("Papa" and "Mama") as case study for comparison. Includes references.

  • Sharpe vs Treynor Measure for Diverse Portfolios with Known Beta

    425095 Sharpe vs Treynor Measure for Diverse Portfolios with Known Beta If an investor is able to determine a global beta for his portfolio and holds a portfolio that is well-diversified with international investments, which performance measure is more

  • Sharpe measure for Phoenix Fund and the Index Fund

    During the same period, the mean return on the market index was .08 with a standard deviation of .25 and beta of 1. While evaluating Phoenix Fund, you computed a standard deviation of returns .36, and a beta of 1.2.

  • Interpreting Sharpe Measure and Treynor Measure

    When comparing two assets each with return R against the same benchmark with return Rf, the asset with the higher Sharpe ratio gives more return for the same risk. Investors are often advised to pick investments with high Sharpe ratios.

  • Using the Sharpe and Treynor Indexes

    Beta of Crane stock = 0.8 ? Beta of Load stock = 1.1 Can you determine which stock has higher risk-adjusted returns when using the Sharpe index? Which stock has higher risk-adjusted returns when using the Treynor index?

  • Various Investment Concepts

    (Beta is usually used only for individual stocks, though some books use it for portfolios, as well.) 22-5f: The Sharpe Index measures the amount of return per unit of risk in a portfolio.

  • Risk-Adjusted Return Measurements

    of crane stock = 0.8 Beta of load stock = 1.1 Determine which stock has higher risk-adjusted returns when using the Sharpe index.

  • Calculating Alpha

    DEV. 11.20% Apr-93 7.85% VARIANCE 0.0126 Apr-94 2.65% CO-VAR. 0.97% Apr-95 9.34% BETA 0.9032 Apr-96 26.70% SHARPE RATIO 0.6822 Apr-97 20.21% ALPHA Apr-98 31.98% Apr-99 13.07% Apr-00 -4.97% WALLFLOWER Date

  • Portfolio Returns & Risk-Adjusted Performance

    However, since Sharpe and Treynor's measures provide different information, considering them both would provide a more adequate basis in evaluating portfolio performance. REFERENCE: Eiteman, David K. et al. (2007).

View More Related Solutions