Course Syllabus - TerpConnect
[pic]
GENEVA EXECUTIVE COURSES IN FINANCE
Performance Evaluation and Attribution (PEVA)
Theory and Practical Application
October 2 - 6, 2006
Professor Russ Wermers September 9, 2006
( 2006 R. Wermers
Lab Exercise #1, Part B: Computing and Comparing Bond Fund Styles,
and Measuring the Performance of Bond Funds
Objective: Our objective with this exercise is to compute the influence of different interest rate and market return measures upon different types of bond mutual funds, as well as to measure the “alpha” (performance) of these funds. An Excel data table is available for you to complete today’s task, titled “Lab 1B.xls”. This file contains data from April 1995 through March 2001 for the following:
A. “Fidelity Bal” -- The net returns for each of the following mutual funds
“Phoenix High Yield” minus the risk free rate: Fidelity Balanced Fund, Phoenix-
“Putnam Conv” Goodwin High Yield Fund, Putnam Convertible Income
“Putnam Muni” Growth Trust, Putnam Municipal Income Fund, and the
“Van Kamp Corp” Van Kampen Corporate Bond Fund
B. “RMRF” -- The monthly return of the S&P 500 minus the risk free
rate.
C. “FIRF” A Fixed Income Index representing general returns of
the fixed income markets minus the risk free rate.
NOTE: This sample actually is using the return series
of a mutual fund instead of an actual index, so an
actual index could lead to slightly different results.
D. “TERM” A measure of changes in the steepness of the yield curve.
Calculated as the yield difference between 10 year
treasuries and 3 month t-bills.
E. “DEFAULT” A measure of changes in the credit spread. Calculated as
The yield difference between 10 year treasuries and the
Moody’s Baa Corporate Index.
Please complete the following tasks:
1. Load the Excel spreadsheet described above. Ensure that the “Analysis Toolpak” Add-in is enabled. To do this, click Tools – Add-Ins – Analysis Toolpak – OK..
2. Conduct a regression analysis of each mutual fund against the data provided. The equation form of the regression should be: [pic]. Note that a regression can be created in Excel by clicking Tools – Data Analysis – Regression – OK.. Then input the parameters into the dialog box that appears.
3. Analyze the regression goodness of fit for each fund. Is the regression model a good fit for all of the funds in the sample?
4. Evaluate the regression coefficients and their statistical significance. Are the regression results consistent across funds? What might explain the why the different types of bond funds have different coefficient results?
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- english composition syllabus sample
- school syllabus in sinhala
- english 101 syllabus community college
- school syllabus sri lanka
- advanced level syllabus sri lanka
- school syllabus sri lanka 2016
- new syllabus biology 2019 pdf
- english 101 syllabus course outline
- high school course syllabus examples
- course syllabus example
- course syllabus examples
- business management course syllabus pdf