![]() |
|
|
|
|
Portfolio Analysis & Design
|
||||||||||||||||
| Overview |
A set of of modular Excel-based tools for the construction and analysis of investment portfolios.
The software toolset, for use by asset managers and other portfolio investors, comprises:
| Applications for
portfolio optimization, style analysis, the Monte Carlo simulation of
future risks and returns, and retirement planning. | |
| The Hoadley
Finance Add-in for Excel containing a comprehensive set of functions
for asset allocation, investment performance analysis, portfolio
optimization, and risk management. | |
| Additional samples available for download
which provide more examples (in addition to those provided with the
Finance Add-in for Excel) of using a number of the asset management
functions. See
Additional Samples for details. |
| Applications for Portfolio Analysis & Design |
| Hoadley Portfolio Optimizer |
An application for analyzing and optimizing a portfolio
of stocks and other assets using Modern Portfolio Theory (MPT) &
Capital Asset Pricing Model (CAPM) principles. Outputs include
an efficient frontier, a full set of active asset management statistics.
Price: Free (but requires the Finance
| Hoadley Portfolio Style Analyzer |
The
Style Analyzer
| Hoadley Portfolio Simulator |
An
application for analyzing the future risks and returns of a portfolio using
Monte Carlo simulation. Simulation can help gain an understanding of
the probabilities of achieving future returns and the impact of various
rebalancing strategies on future outcomes.
| Hoadley Retirement Planner |
The
Retirement Planner uses Monte Carlo simulation to produce a retirement plan
based on a pre-retirement savings and investment plan, and expected
expenditures during retirement
.
| Hoadley Finance Add-in for Excel |
The add-in's functions functions can be invoked directly from
spreadsheet cells or called from VBA modules/Macros.
Portfolio asset/sector
allocation, optimization & simulation functions
Value at Risk (VaRtools) functions
The
Hoadley Finance Add-in for Excel includes Excel functions for portfolio
analysis, asset allocation using Black-Litterman, portfolio optimization
(MVO), risk management (VaR),
volatility, correlation and covariance calculation, and more.
| Pricing & Purchase |
The Hoadley Finance Add-in for Excel is the analytical engine used by the Excel applications described below. It is only necessary to purchase the Finance Add-in for Excel; the Excel applications are included in the price of the Finance Add-in for Excel.
Private (non-business) use: Pricing & purchase on-line.
Corporate/commercial use:
Corporate/commercial enquiries.
| Software Platform |
These tools & applications will only run using Microsoft Excel 2002 - 2007 running under Microsoft Windows. No other platforms/operating systems are supported.