Home Up Contents

Portfolio & Statistics
Banking Models Fin Statement Modeling Fixed Income Models Interest Rate Models Lattice Models Simulation Examples Portfolio & Statistics Student Models Less Serious Scripting Exercises Full Model List

 

 


 

bulletSample student solution portfolio assignment

Sample Solution Portfolio Assignment

bullet

prepared by Michael Strudwick (2001) »download

bullet

prepared by Ray Guo (2005) »download

These are a sample student solutions of an assignment that basically requires

  1. Determination of variance / covariance matrix given the historical returns of 6 NZ shares.

  2. Random generation of a large number of feasible portfolios and a plot of their risk/returns in a scatter chart.

There is no guarantee for the correctness of the solutions shown. Unfortunately, the code of the VBA project was hidden since this assignment will again be used in financial modeling courses at Waikato Management School and I am looking forward to new, creative solutions.

 

Send mail to kurthess@waikato.ac.nz with questions or comments about this web site.
Copyright © January, 2009 Kurt Hess, University of Waikato
Last modified: 13-Jan-2009