Dr. David Nawrocki
VILLANOVA UNIVERSITY
Villanova School of Business
Department of Finance
Fall 2008
Office: 2020 Bartley Hall next to Finance Department OfficeOffice Hours: Th 1:00pm - 2:30pm or Fridays by appt.
Phone: 610-519-4323
Course Website: http://www.homepage.villanova.edu/david.nawrocki E-mail: David.Nawrocki@villanova.edu
TEXTS
1. Modern Portfolio Theory, Most Recent Edition, Elton & Gruber (EG), Required.
2. Tuva or Bust, Ralph Leighton and Richard Feynman, Required.
3. Surely You're Joking, Mr. Feynman, Richard Feynman and Ralph Leighton, Required.
4. Portfolio Management Software Package., David Nawrocki, Computer Handholders, Required.
Course Description
This course will cover advanced topics in investment management and modern portfolio theory (MPT) including regression analysis, risk measurement, portfolio allocation algorithms, decision systems, international diversification and utility theory. Much of this material is covered in Level 3 of the CFA exam. The course stresses application of statistical techniques through the use of appropriate computer packages. The student is expected to use the computer heavily in order to apply and learn the techniques that are covered in class. The course places a heavy stress on teaching yourself how to learn. The emphasis is on learning!!!!!
Prerequisites include Investments I, Stat I and II, Financial Markets, Computers in Management, and Senior Year Standing.
It is the students responsibility to be certain that the prerequisites have been successfully completed. If at any time during the semester it is determined that a student has not completed the prerequisites, the student can be administratively dropped from the course without credit or tuition refund.
Attendance is expected and heavily recommended. The computer projects and the final exam are from classroom lecture material. Textbook and handout materials are for reference. I reserve the right to make changes in the assignments. Please make sure that you attend class to keep up-to-date with any changes.
Topics:
1. Modeling and Decision Systems ...............Lecture
a. Decision Support Systems, Learning, Artificial Intelligence
2. Portfolio Management
a. Macroeconomic (Business) Cycles...........Lecture
b. Fundamental Screening of Stocks...........Lecture
c. Measuring Return, Sources of Information..(EG)Ch.1,2,3
d. Efficient Frontier Diversification........(EG) Ch.4,5,6,7,8,9
e. Utility Theory............................(EG) Ch.10,11
f. Portfolio Evaluation......................(EG) Ch.24,25,26
g. Adjustments for Forecasts.................Lecture, (EG) Ch 19
h. International Diversification.............(EG) Ch. 12
i. Option Pricing and Portfolio Insurance....(EG) Ch.22,Lecture
j. Bond Management, Duration, and Futures....(EG) Ch.20,21,23
Grading
30% First Term Paper - Read both Feynman books - Write a book report/essay on learning and portfolio theory.
30% Second Term Paper - MarketBase and PMSPP - One Period Portfolio Optimization.
40% Third Term Paper - Using MarketBase, PMSPP, REVISE - Portfolio Revision.
Method of Instruction - Class Lecture, Outside Reading, Outside Preparation of Projects.
Late Policy
All papers are due by 4:30 on the due date. The final paper is due during finals week. The date will be set later in the semester. Late papers will have reduced grades based on degree of lateness (12% penalty per week). The Finance departmental office will accept papers and time/date stamp them. There will be NO acceptable excuses for late papers or missed exams. All papers handed in when I am not present have to be date/time stamped by a secretary or faculty member. Incomplete papers will have reduced grades based on the degree of completeness.
Teams
You ARE to work in teams of two (with one group of three if we have an odd number of students). Papers with similar computer results or with similar presentations or similar styles will be downgraded at the discretion of the professor. The professor reserves the right to give an F Grade to any paper that he feels has violated the conditions as stated on this course outline. There will NOT be a group grade on the term papers unless all members of the group sign a petition for a group grade. Each student's grade will be based on their section of the paper. Dishonesty in these assignments WILL result in a grade of F.
Honor Statement
You are expected to operate according to professional standards of ethics. On each paper, a statement to the effect that the paper contains only your work (and not the work of other students both past and present) is required for BOTH PAPERS. In addition, each student has to sign or initial his/her section of the paper. Each section of the paper has to be identified as the work of a particular student. The person who signs for a section of the paper is solely responsible for that section (all of the good and all of the BAD). Papers without an honor statement will be considered late until the honor statement is submitted. Your senior year is NOT the time to be taking ethical short-cuts. I will put a hold on your diploma for cheating.
The Code of Academic Integrity of Villanova University addresses cheating, fabrication of submitted work, plagiarism, handing in work completed for another course without the instructors approval, and other forms of dishonesty. For the first offense, a student who violates the Code of Villanova University will receive 0 points for the assignment. The violation will be reported by the instructor to the Deans office and recorded in the students file. In addition, the student will be expected to complete an education program. For the second offense, the student will be dismissed from the University and the reason noted on the students official transcript.
Paper Format
The papers are to be typed, double spaced with any references and footnotes collected at the end of the paper. Information from computer printouts should be organized into tables and graphs which are to be integrated into the text of the paper. Appendices are UNACCEPTABLE. Failure to meet these standards as well as poor grammar and spelling will result in letter grade drops for each violation. Papers are as long as you need them to be to convey the desired information. Papers that provide class notes or tutorials in statistics or contain extraneous information are unacceptable (An F grade will be assigned.) You are expected to provide the statistical results from the computer using tables and graphs. Papers without results are not completed papers.
Other Issues
I will not tolerate any disruption of class by beeping computers or ringing cell phones. Surfing the internet is to be on your own time not classroom time.
Computer Programs
You will use the PMSPP Student Package which you have a legal license to use upon purchase of the manual. You will have access to CRSP Dataset for stock prices from January 1926 to December 2007. By late February 2009, the CRSP database will be updated to December 2008. You will also have access to the Morningstar Equities (MarketBase) and DRI Basic Economics databases and Global Insight Economic Dataset. None of the data will have to be gathered and typed. You will not be required to do any programming in a computer language. The copying of any computer software or data from the databases is expressly prohibited. All of the computer resources used in this course are copyrighted material. Please respect these copyrights. The software for the CRSP access is available on the WRDS access site which can accessed from the Bartley network connections and from the Mendel computer lab. The PMSPP manual is available from the bookstore. The software can be used in any Microsoft Windows compatible computer. You may not use the PMSP software unless you have purchased a manual.
Disability Statement
It is the policy of Villanova to make reasonable academic accommodations for qualified individuals with disabilities. If you are a person with a disability please contact me after class or during office hours and make arrangements to register with the Learning Support Office by contacting 610-519-5636 or at nancy.mott@villanova.edu as soon as possible. Registration with the Learning Support Office is required in order to receive accommodations.
Outline for Second Term Paper
NOTE: The CRSP dataset will be current to December 2007
I. Set Investment Goals
II. Stock Selection - Best in Industry - MBASE97
III. Portfolio Selection - January 1992 (794) to March 1997 (856).
You could also use January 1991 (782) or January 1993 (806).
IV. Evaluation of Portfolio Performance - April 1997 (857) to December 1999 (889).
You could also use December 2001 (913). CRSP calendar dates in parenthesis.
All Four Parts have to be completed for the paper to be considered a complete paper.
Outline for Third Term Paper
I. Macro Analysis
Use a real variable for FMBASE by dividing it by the CPI. Use
initial unemployment claims, nonfarm payroll, and fed funds rate as is.
Either convert to percentage change or graph the raw data using semilog
charts. Use the data from 1991 to 2007 to detect changes in the phases
of the business cycle as per the classroom handout. I recommend
accessing the XLS sheets BASICM.XLS, BASICA.XLS, and BASICQ.XLS
using EXCEL. The Citibase files as they are currently updated to September 2004.
For data through 2007, use Global Insight or FRED.
II. Industry Analysis and Stock Selection
Pick 4 industries from each phase and the 2 or 3 best stocks from each
industry. When you go to CRSP, you want to make sure that each stock
has data available from January 1987 to December 2007. You want 20 stocks total,
one from each industry. Download to disk. Use MBASE90 to select stocks.
III.Use PMSP to generate an investment portfolio from an efficient frontier
every 6 months starting in December 1990 and ending in June 2007. You
will need to change your historic period using the SETUP option in PMSP.
Write down the stocks and allocations for each portfolio. Make sure
that your 8-10 stocks are drawn from the industries that are appropriate
for the current phase of the business cycle. Put allocations and stock
returns into the summary table discussed in class.
IV. Use the REVISE program to generate the performance results of a buy and
hold strategy, a rebalance strategy, and a controlled revision strategy
where you revise the portfolio every 6 months. Save the portfolio results
to a disk file.
V. Input the portfolio returns into PMSP and evaluate the performance of
strategies using Correl or EVAL.
Period Date Investment as of: 1-48 12/90 1/91 7-54 6/91 7/91 13-60 12/91 1/92 19-66 6/92 7/92 25-72 12/92 1/93 31-78 6/93 7/93 37-84 12/93 1/94 43-90 6/94 7/94 49-96 12/94 1/95 55-102 6/95 7/95 61-108 12/95 1/96 67-114 6/96 7/96 73-120 12/96 1/97 79-126 6/97 7/97 85-132 12/97 1/98 91-138 6/98 7/98 97-144 12/98 1/99 103-150 6/99 7/1999 109-156 12/1999 1/2000 115-162 6/2000 7/2000 121-168 12/2000 1/2001 127-174 6/2001 7/2001 133-180 12/2001 1/2002 139-186 6/2002 7/2002 145-192 12/2002 1/2003 151-198 6/2003 7/2003 157-204 12/2003 1/2004 163-210 6/2004 7/2004 169-216 12/2004 1/2005 175-222 6/2005 7/2005 181-228 12/2005 1/2006 187-234 6/2006 7/2006 193-240 12/2006 1/2007 199-246 6/2007 7/2007
All five parts have to be completed to be considered a complete paper.

Download 1 (10.8mb) Citibase Excel Sheets
Download 2 ( 2.1mb) Marketbase December 1990 Download 3 ( 4.2mb) Marketbase March 1997 Download 4 ( 3.0mb) CRSPMNTH