| Excel Business Tools Programs |

|
 |
1 |
|
 |
| Portfolio Optimization |
Feb 7, 2004 |
225 downloads |
|
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 model enables it to be applied to either financial instrument or business portfolios.The ability to apply optimization a...
|
|
|
|
 |
| Portfolio Tracking & Monitoring |
Feb 7, 2004 |
104 downloads |
|
The Portfolio Monitoring template 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 calculate performance. Furthermore, incremental investment transactions undertaken...
|
|
|
|
 |
| Investment Valuation |
Feb 7, 2004 |
97 downloads |
|
The Investment 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, its also provides ability to evaluate economic value added valuation, accounting ...
|
|
|
|
 |
| Multiple Regression Forecasting |
Feb 7, 2004 |
94 downloads |
|
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 the analysis, results are summarized in text for ease of use.
Once relati...
|
|
|
|
 |
| Real Option Valuation |
Feb 7, 2004 |
93 downloads |
|
The Real Option Valuation template encompasses a suite of option pricing tools to quantify the embedded strategic value for a range of investment scenarios. Traditional discounted cash flow investment analysis will only accept an investment if the returns on the project exceed the hurdle rate.
Whil...
|
|
|
|
 |
| Project Planning and Management |
Aug 20, 2004 |
88 downloads |
|
The Project Planning and Management template is designed as a generic solution to plan and manage any project. The ability to build the project?s budget as tasks are identified facilitates the processes of business case proposal, valuation analysis, and securing the required funding. Project dynam...
|
|
|
|
 |