下載目錄
音頻
多媒體與設計
應用工具
軟體開發
桌面增強
家庭教育
其他軟體
商業和財務
商業財務
倉儲系統
其他軟體
應用軟體
專案管理
法律
個人資訊管理
個人財務
資料庫管理
電子表格
文字處理
演講工具
網路創作
遊戲
互聯網
廣告
下載 Portfolio Optimization
The Portfolio Optimization model calculates the optimal capital weightings for a basket of 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 Optimisation 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 optimised portfolio.
- Unique 'Maintain Current Return Level' option to ensure that return is not deteriorated at the expense of risk.
- Modify correlation matrix and portfolio dynamics before optimization process.
- Intuitive graphical result display with Monte Carlo simulation, including probability analysis on specified 'Target' return level.
(Requires Microsoft Excel 97 or above)
The key features of the Portfolio Optimisation 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 optimised portfolio.
- Unique 'Maintain Current Return Level' option to ensure that return is not deteriorated at the expense of risk.
- Modify correlation matrix and portfolio dynamics before optimization process.
- Intuitive graphical result display with Monte Carlo simulation, including probability analysis on specified 'Target' return level.
(Requires Microsoft Excel 97 or above)


