Up
 

Inputs

Outputs

Software Environment
 

Download 

Hoadley Portfolio Simulator

Portfolio optimizers, such as the Hoadley Portfolio Optimizer, and other asset allocation tools can be used to determine the combination of individual assets, mutual funds or asset classes in a portfolio which provides the maximum return per unit of risk. 

But this initial asset allocation is just the starting point for portfolio planning. 

Portfolio drift: A portfolio consists of multiple assets (individual assets, asset classes or  mutual funds), each with its own expected return, volatility and correlation with every other asset.  As a result, as soon as initial asset allocations are implemented the asset weightings in the portfolio will start to deviate from the intended allocations, usually significantly impacting long term portfolio returns and risks.   A portfolio might have an expected return of, say 10% pa and a volatility of 15% pa when it is first established, but after a few months this will no longer be the case. 

Rebalancing: A portfolio may be periodically rebalanced back to the initial optimal or strategic asset allocations.  But rebalancing may reduce returns and incur transaction costs which further impact long term portfolio performance. On the other hand, rebalancing less frequently, or only after the portfolio asset weights have drifted from the initial allocation by a specified amount, may reduce costs, but at the expense of increase risk.  What is the optimal rebalancing strategy?  Is it worth doing at all?

Uncertainty of returns: Portfolio planning must also recognize that there is no certainty about future portfolio returns. It is common to refer to expected portfolio returns as if these are the returns that will be realized over a five, ten or twenty year period, but in reality a wide range of returns is possible, each with a specific probability of occurring. The higher the portfolio volatility, the wider the range of returns and the lower the median compounded return will be.

Within a five year period, for example, there may be a 20% chance of the return for the period being negative even though the mean geometric return is 9% pa. It's important to understand what these risk are as well as just knowing the average expected return.

The Hoadley Portfolio Simulator uses Monte Carlo simulation to generate a large number of possible future portfolio outcomes over a multi-year time frame.  It then classifies the results into percentile groups, analyzes the frequency distribution of geometric (annually compounded) returns (as shown in the example below), and calculates rebalancing and other costs. 

The results can help the gain an understanding of such factors as the likelihood of achieving return targets, and the impact of different rebalancing strategies on future returns.

A key feature of the Hoadley Portfolio Monte Carlo Simulator is the generation of two scenarios for every simulation run: 

Importantly, both scenarios produced from every simulation run are based on the same underlying simulation data -- they both use the same asset price data set generated by the simulator.  They therefore represent different portfolio management responses to the same underlying "market conditions" and provide an effective way of modelling the impact of rebalancing on future portfolio performance.
 

The portfolio inputs to the Monte Carlo simulator are expected returns, volatilities, the correlations for each asset (or fund or asset class) in the portfolio, and the initial portfolio asset weights.

Returns, volatilities and correlations are exactly the same inputs required by the Hoadley Portfolio Optimizer.  See estimating volatilities, correlations and returns.

Portfolio asset weights may reflect a strategic asset allocation, or they may represent the optimal portfolio from a portfolio optimizer, such as the Hoadley Portfolio Optimizer.
 

Two sets of outputs are produced from each simulation run: one set for scenario 1 (with periodic rebalancing) and scenario 2 (with no rebalancing).  The outputs for each scenario are presented side by side for easy comparison, and include:

The Hoadley Portfolio Simulator will run on versions of Microsoft Excel 2002 and above on Microsoft Widows 2000 or above.

The Hoadley Finance Add-in for Excel version 10.1k or later must be installed before using the Simulator.
 

The Hoadley Portfolio Monte Carlo Simulator is free do 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.