Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com
Learn how to create Excel dashboards.

Portfolio Optimization

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Calculates Optimal Capital Weightings. Highest Return for the Least Risk

Portfolio Optimization

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 optimization analysis to a portfolio of businesses represents an excellent framework for driving capital allocation, investment, and divestment decisions.

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

Requires Excel 97 or above | Download Demo

Portfolio Optimization Excel Template $18.00 Secure Payment Options 30 Day Money Back Guarantee

License Type:

Buy as part of the Portfolio Management Pack and save.

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

See Also: Excel Templates & Financial Software



Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

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

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS