Investment Style of Portfolio Management: Excel Applications

Sharpe (1988, 1992) introduces an objective style model based on asset classes (or factors). The impact of Sharpe's style analysis on practical applications has been extensive. The purpose of this paper is to educate readers in using Excel's Solver function to conduct Sharpe's style analysis. We also analyze style drifts and discuss their importance.