 |
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 analysis will only accept an investment if the returns on the project exceed the hurdle rate. While this is a worthwhile exercise, it fails to consider the myriad of strategic options that are associated with many investments.
excel real options valuation template spreadsheet strategic financial pricing black bcholes binomial option nash equilibrium game theory strategic embedded analysis business project
|
|
|
 |
The Project Planning and Management template is designed as a generic solution to plan and manage any project. Building the budget as tasks are identified facilitates the processes of business case proposal, valuation and funding. Progress can be monitored from automatic creation and updating from remote participant workbooks. Project performance can be monitored with best practice Earned Value Analysis throughout the complete project lifecycle.
excel template spreadsheet business project planning management tasks earned value analysis gantt scheduling timing resources performance deadline participants
|
|
|
 |
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 calculate performance. Furthermore, incremental investment transactions undertaken during a period are fully accounted for in the period's performance calculations.
excel portfolio monitoring valuation management financial investments assets personal wealth stocks bonds shares market performance return transactions money weighted analysis business
|
 |
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.
excel portfolio optimisation optimization management asset allocation personal wealth fund management sharpe ratio risk optimal weightings return capital allocation analysis business
|
 |
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 validity of the analysis, results are summarized in text for ease of use. Once relationships have been identified, forecasting can be accomplished based on a range of available methodologies.
excel forecasting multiple regression template spreadsheet business planning plan proposal statistical testing multicolinearity auto correlation durbin-watson pearson coefficient value drivers indentification analysis business
|
 |
The Investment and Business Valuation template is ideal for evaluating a wide range of investment, and business case scenarios. While it is based on the traditional DCF method of valuation, its also provides ability to evaluate economic value added valuation, accounting impact, and a range of other evaluation parameters. Furthermore, the step-by-step input flow makes usage straightforward, gaining quick results to drive decision making.
excel investment financial valuation spreadsheet template eva dcf discounted cash flow economic value added analysis business evaluation npv proposal
|
