The Portfolio Optimization model calculates the optimal capital weightings for a basket of financial investments that gives the highest return for the least risk. The unique design of the model enables it to be applied to either financial instrument or business portfolios. The ability to apply optimization analysis to a portfolio of businesses represents an excellent framework for driving capital allocation, investment, and divestment decisions. The key features of the Portfolio Optimization model 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; Restrict analysis to downside risk only; Unique ‘Maintain Current Return Level’ option to ensure that return is not deteriorated at the expense of risk; Intuitive graphical result display with Monte Carlo simulation, including probability analysis on specified ‘Target’ return level; Download historical prices for financial market data
Recent Changes: Improved user interface design, work flow and cross platform compatibility.
Install Support: Install and Uninstall
Supported Languages: English
Additional Requirements: Requires Microsoft Excel 97 or higher
PAD file URL: http://www.business-spreadsheets.com/padfiles/portopt.xml
Portfolio Optimization 2.0
Program ID:
3097
Author:
Business Spreadsheets All programs by this author
Downloads:
16
License:
Shareware [?]
Cost:
$18.00 US
Operating Systems:
Size:
274K
Release Status:
update
Last Updated:
2011-01-01
Our Rating:
Users Rating:
(total votes: 0)
The Portfolio Optimization model calculates the optimal capital weightings for a basket of financial investments that gives the highest return for the least risk. The unique design of the model enables it to be applied to either financial instrument or business portfolios. The ability to apply optimization analysis to a portfolio of businesses represents an excellent framework for driving capital allocation, investment, and divestment decisions. The key features of the Portfolio Optimization model 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; Restrict analysis to downside risk only; Unique ‘Maintain Current Return Level’ option to ensure that return is not deteriorated at the expense of risk; Intuitive graphical result display with Monte Carlo simulation, including probability analysis on specified ‘Target’ return level; Download historical prices for financial market data
Recent Changes: Improved user interface design, work flow and cross platform compatibility.
Install Support: Install and Uninstall
Supported Languages: English
Additional Requirements: Requires Microsoft Excel 97 or higher
PAD file URL: http://www.business-spreadsheets.com/padfiles/portopt.xml