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.
Sep 13, 2011 19:57:36
Windows 95, Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP, Mac OS
Portfolio Optimization 1.0 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
Investment and Business Valuation 1.0 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.
Description: 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. The intuitive step-by-step usage flow enables you to develop strong forecasts for your projects in a timely manner. The key features of the Multiple Regression Analysis and Forecasting model include: Ease and flexibility of input, with embedded help prompts; User-friendly results display for the 'Non-statistician'; Multiple and Individual Regression of independent variables; Tests for statistical significance, auto-correlation, and multi-colinearity; and Quick forecasting process with options to employ 3rd polynomial, 2nd polynomial, exponential or linear trend lines on independent variables.