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 in Progress ... please wait.
If your download does not start, please click the following link:
Customer Invoice Template - The Customer Invoicing Template is an Excel invoice template with the ability to store invoices, products and customers and perform advanced invoice sales reporting. The database structure of the invoice system allows the...
Investment & Business Valuation - The Investment Valuation template is ideal for evaluating a wide range of investment, and business case scenarios. While it is based on the traditional discounted cash flow method of valuation, its also provides ability to...
Investment and Business Valuation - The Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business case scenarios. While it is based on the traditional discounted cash flow method of valuation,...
Multiple Regression Forecasting - The Multiple Regression Forecasting template provides a solid basis for identifying value drivers and forecasting business plan data. While it utilises a range of commonly employed statistical measures to test the validity of...
Portfolio Performance Monitoring - The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The model allows the entering of investment transactions during a reporting period to...
Project Planning and Management - The Project Planning and Management template is designed as a generic and affordable Excel based solution to plan and manage any project. The ability to build the project’s budget as tasks are identified facilitates the...
Real Option Valuation - 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. Traditional discounted cash flow investment...
Regression Analysis and Forecasting - The Multiple Regression Analysis and Forecasting model provides a solid basis for identifying value drivers and forecasting business plan data. While it utilises a range of commonly employed statistical measures to test the...