Categories : Business > Investment Tools

Portfolio Optimization 1.0

Publisher Business Spreadsheets Published Date 2006-12-01 License Shareware Price 18 USD Size 110 KB. The Portfolio Optimization model calculates the optimal capital weightings for a basket of financial investments that gives the highest return for the least risk. Results display action required and probability analysis through Monte Carlo simulation Download Now!

Description From Publisher 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 optimised portfolio; Unique 'Maintain Current Return Level' option to ensure that return is not deteriorated at the expense of risk; and Intuitive graphical result display with Monte Carlo simulation, including probability analysis on specified 'Target' return level. Supported OS Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Mac OS X,Mac OS X 10.4,M Related Keywords Excel  Excel  excel  portfolio  portfolio  portfolio  optimisation  optimisation  optimisation  optimization  optimization  optimization  management  management  management  asset  asset  asset  allocation  allocation  allocation  personal  personal  personal  wealth  wealth  wealth  fund  fund  fund  management  management  management  sharpe  sharpe  sharpe  ratio  ratio  ratio