Using the Application


Software Environment




Hoadley Factor Analyzer
Fama-French and CAPM exposure analysis software


Hoadley Factor AnalyzerThe Capital Asset Pricing Model (CAPM) seeks to explain the equilibrium rate of return on all risky assets in terms of their exposure to a single market factor.  The Fama-French (FF) model builds on the CAPM by adding size and value factors (3-factor model) plus profitability and investment factors (5-factor model) to the market factor with the objective of more comprehensively explaining stock and fund performance. 

Using historical data compiled by Fama-French, and Yahoo Finance, or user-supplied returns data, the Hoadley Factor Analyzer will analyze the exposure of individual US equity assets (stocks, funds, ETFs), and user-defined portfolios of assets, to both the Fama-French three or five factor model, and the Capital Asset Pricing Model. 

The Excel application provides a flexible and very simple-to-use way of evaluating the extent to which the Fama-French model improves on the CAPM in explaining the performance of any combination of US equity assets over any time period.

Fund manager performance can also be easily assessed using the Hoadley Factor Analyzer.  If you suspect an active fund manager, while beating the market, is actually adding little value on a risk adjusted basis and are concerned you might be paying active fees for index performance, the Factor Analyzer will help you spot a closet indexer a mile off.

Using the Hoadley Factor Analyzer

The only inputs required are the ticker symbols of stocks and funds to be included in the analysis, their weights in the portfolio (optional) and the range of dates to be included in the analysis.  The application then downloads the data and produces all analyses with a single button click.  Alternatively users can supply their own returns data if preferred.

The analyses produced by the application are extensive and include, for individual assets/funds and user defined portfolios:


Factor basics: Factor premiums (Arithmetic returns, geometric returns (CAGR)) and volatilities for each factor, plus factor correlations.


Asset exposures: Arithmetic returns, geometric returns and volatilities, annualized alpha, exposure to the Fama-French factors (3 or 5 factors), coefficient of determination (R-Squared), and risk decomposed into systematic and specific risk based on the FF model. Market exposure, R-Squared and risk decompositions are also shown for the CAPM for comparative purposes.
This lets you see at a glance whether or not the FF factor models do a significantly better job of explaining returns and variances than the CAPM.  Information is shown for individual assets and in total for the portfolio. 
Asset risk factor exposures can also be used in the Hoadley Portfolio Optimizer to construct portfolios with factor constraints or targets (eg RM-Rf between 1.3 and 1.5 and SMB between 0.6 and 0.9).


Performance attribution: The contribution of each factor and alpha to total returns are shown by asset  and for user defined portfolios.  Performance attribution is expressed in terms of annualized returns.


Drill-down: Right clicking an individual asset, fund, or portfolio on the analysis will produce detailed regression diagnostics, including standard errors, t-stats, p-values and 95% confidence intervals, both for the selected Fama-French model and the CAPM.  Statistically insignificant factor exposures are highlighted for both models.


Rolling window analysis: Rolling window charts are produced showing the exposure of each asset, fund or portfolio to each of the Fama-French factors (Rm-Rf, SMB, HML, RMW, CMA), and for the coefficient of determination to provide a visual indication of how exposures to these factors have changed over time.


Drawdown analysis:  A comprehensive drawdown analysis both in table and chart form can be produced to reveal additional performance characteristics for each asset or fund over the selected time period.

Software Environment

See Finance Add-in for Excel system requirements.

Download the Hoadley Factor Analyzer

The Hoadley Factor Analyzeris available for download to users who have purchased the Hoadley Finance Add-in for Excel and are still within their one year free download period.

Register and download