Portfolio Optimization Template by Business Spreadsheets   Portfolio Optimization Template

Financial asset & business capital weighting optimization

...Determining the optimal mix of products and businesses. Portfolio Optimization
Portfolio Optimization Template by Business Spreadsheets


Travel in New Zealand YOUR Way with NZYourWay.com
 
  The Portfolio Optimization template calculates the optimal capital weightings for a basket of investments that gives the highest return for the least risk. The unique design of the template enables it to be applied to either financial instrument or business portfolios. The ability to apply optimisation analysis to a portfolio of businesses represents an excellent framework for driving capital allocation, investment, and divestment decisions.
[Portfolio Optimization Screen Shot]

Key features of the Portfolio Optimization template include:
  • Ease and flexibility of input, with embedded help prompts.
  • Ability to specify the number of units held in each product or business.
  • Specify minimum and maximum constraints for the optimized portfolio.
  • Unique 'Maintain Current Return Level' option to ensure that return is not deteriorated at the expense of risk.
  • Ability to modify the correlation matrix and portfolio dynamics prior to the optimization process.
  • Intuitive graphical result display with Monte Carlo simulation, including probability analysis on specified 'Target' return level.

Download the Portfolio Optimization template
Purchase the Portfolio Optimization template
Support for the Portfolio Optimization template
Requirements
Windows: Excel 97-07
Mac OSX: Excel 2004
(US $18.00)
Secure Processing
 
Download the User Guide for the Portfolio Optimization template  (Included in the paper: "Empowering Business Decision Making with Business Spreadsheets")
(requires Acrobat)
Customers who bought the Portfolio Optimization template also bought:
Find more Excel Portfolio Optimization Solutions in the Financial Markets Section of the Excel Add-ins & Templates Directory. Sell the Portfolio Optimization template as an affiliate.
Share experiences with the Portfolio Optimization template in the Portfolio Optimization Section of the Excel Help Forums for Business.
 
Recommended Portfolio Optimization References
The Intelligent Asset Allocator: How to Build Your Portfolio to Maximize Returns and Minimize Risk The Intelligent Asset Allocator: How to Build Your Portfolio...
Efficient Asset Management: A Practical Guide to Stock Portfolio Optimization and Asset Allocation Efficient Asset Management: A Practical Guide to Stock Portfolio Optimization
Option Pricing and Portfolio Optimization: Modern Methods of Financial Mathematics (Graduate Studies in Mathematics, 31)
by Ralf Korn, Elke Korn
More Portfolio Optimization Books
Download the PDF Whitepaper:

Empowering Business
Decision Making

with Business Spreadsheets
A Practical User Guide
Recommended Resources: More Resources and Solutions
Download Market Data - Download historical market data directly into Excel.
ValueLine - 71 years of Proven Performance.
Elliot Wave International (EWI) - Provider of financial market data, research and technical analysis.
Portfolio Insight: Uncover Hidden Risks and Opportunties in Your Portfolio.
Portfolio Optimization Template      
  © 2002-2008 Business Spreadsheets. All Rights Reserved. Legal