|
|
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.
Download Portfolio Optimization (110.3 KB)
Anti Virus Report
Last updated: 2007-01-24
|
 |
Business Spreadsheets
Address: 23 Rue Joubert Le Mans Sarthe 72000 France
Email: contact@excelbusinesstools.com
|
|
|
Business Spreadsheets
The Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business case scenarios. Analysis performed includes accounting impact, Economic Value Added, and NPV of cash flows.
|
|
|
Business Spreadsheets
The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. Amount and timing of investment and divestment transactions are taken into account in performance calculations.
|
|
|
Business Spreadsheets
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
|
|
|
Business Spreadsheets
The Real Option Valuation model encompasses a suite of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Option pricing tools include Black-Scholes, Binomial, and Game Theory.
|
|
|
Business Spreadsheets
The Multiple Regression Analysis and Forecasting template provides a solid basis for identifying value drivers and forecasting business plan data. Advanced statistical tests performed include significance, auto correlation, and multi colinearity.
|
|
