THE Ultimate  Excel Portal         LINKS:  [ Popular | New | Editor's Picks | Top Rated ]
Home >> Previous Page >> Portfolio Optimization (link details)
Main Categories
Excel Add-ins
Excel Help
Excel Password Recovery
Excel Templates
Excel Tips & Tricks
Excel Tutorials
Excel VBA
Free Excel Add Ins
Spreadsheet Research
Create Excel Dashboard Reports with Plug-N-Play Reports
Newest Links
Ultimate Gradebook Template
Waterfall Chart Utility
Dot Plot Utility
Marimekko Chart Utility
Cluster Stack Chart Utility
Box and Whisker Plot Utility
Workbook Comparison Tool
Arixcel Accounts - Personal Finance Tool
Arixcel
ActiveData For Excel

Portfolio Optimization

Domain: www.business-spreadsheets.com
Categories: Finance





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 probability analysis through Monte Carlo simulation.

Rating: 0.00 (0 votes)
Added: 05-30-2004 - Updated: 01-27-2009 - Comments: 0 - Hits month/total: 8/1513
Report error

Version (if applicable): 97/2000/2002(XP)/2003
Rate This Link
Extremely Satisfied
Satisfied
Neutral
Confused
Disappointed

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.

Download Free Trial - Click Here

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.
  • Intuitive graphical result display with Monte Carlo simulation, including probability analysis on specified 'Target' return level.

Download Free Trial - Click Here


Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. This site is in no way associated with Microsoft.