SQL Excel

Description: Excel Macro, package FREE – Simple Import external data in order to analyze in Excel  – Works with ODBC compliant data sources: SQL Server, Oracle, Sybase, Access, MySQL, Firebird, DB2, etc. … – Compatible with Excel 2000, 2002 (XP), 2003 and 2007 Date created: 11 Jun 2008 Size: 3 MB Type: exe Author: Al … Continue reading SQL Excel

StatistiXL

Description: Tool and statistical analysis to Excel. The data stored in spreadsheets can be immediately subject to various statistical tests (analysis of variance, correlation, contingency table, factor analysis, linear and circular descriptive statistics, etc..). The software also offers a wide selection of plots (scatter trace, normal probability plots, etc..). And as the results are placed … Continue reading StatistiXL

StatBoxPro Powerful statistical analysis

Description: Ms-Excel StatBoxPro transforms into a powerful statistical analysis (descriptive statistics, tests, factor analysis, classification, analysis of variance, …) It is fully integrated with MS-Excel. You select your data directly into Excel spreadsheets and graphs and the results are also placed in the leaves. email: info@grimmersoft.com File Type: Shareware Excel version required: Excel 97, 2000, … Continue reading StatBoxPro Powerful statistical analysis

Pareto dynamic

Excel file for checking whether a list of data values ​​and respect the Pareto principle (20-80).  The code allows for calculations, graphics and interpretation. This works regardless of the size of the list. Creation date: March 1, 2009  Size: 725 KB Type: xls Author: Francois Flament

Turnover calculation

Description: Three tables that calculate directly a turnover estimated thanks to the three known methods of linear fit:. the method of endpoints. Meyer’s method. the least squares method is ideal for business students.  email: mapa@tiscali.fr File Type: Freeware  Excel version required: All  OS supported: PCMac  Creation Date: 31 Aug 2007  Size: 49 KB  Author: Pascal STONE Website: … Continue reading Turnover calculation

Technical Analysis and Stock Information V2

V2 Technical Analysis: The Three Line Break (Break Line three), Bollinger, SAR, OVB The novelty of this second version is the famous Three Line Break in Excel developped and described by Steve Nison you can view it on a graph. Passionate trading and technical analysis, excel spreadsheet that will also allow you to develop your … Continue reading Technical Analysis and Stock Information V2

Stocks via MSN Course

This excel file to retrieve the site of MSN’s share price to update the valuation of a stock portfolio. This model excel facilietra manage your stock investments and your financial investments by accelerating the recovery of stock prices.  flyonets@yahoo.fr Creation date: 22 May 2007 Size: 25 KB Version: 1.2 Type: zip Author: Francois Launay

XlsCorrelation

Easily track the correlation, volatility and the historical max drawdown between two actions with this simple and effective application. XlsCorrelation : From two tickers Bloomberg XlsCorrelation: 1) Download the course of two actions 2) Calculate the correlation between the two actions within 3 year rolling 3) Calculate the maximum drawdown 4) Calculate historical volatility. Creation … Continue reading XlsCorrelation

Regression Forecasting – forecast analysis

The model of “Regression Forecasting” is an effective basis for identifying value drivers and forecast financial data as part of stock market investments. This excel file uses a range of statistical measures to examine the validity of the analysis results are summarized in text for ease of use. Once reports have been identified, financial projections may be … Continue reading Regression Forecasting – forecast analysis

EVA Model

Details : Excel template worksheets for calculating Economic Value Added (EVA). In corporate finance, Economic Value Added or EVA is an estimate of a firm’s economic profit – being the value created in excess of the required return of the company’s shareholders – where EVA is the profit earned by the firm less the cost … Continue reading EVA Model

DCF

Details : Menu driven Excel program (must enable macros) for Discounted Cash Flow Analysis from the book Analysis for Financial Management. Size : 382 ko Version : 6.0 Type : xls Author : Robert C. Higgins Web site : http://www.mhhe.com/higgins8e

Financial Projections Model

Details : A comprehensive financial model for forecasting a complete set of financials with breakeven and valuation tabs developed. Size : 787 ko Version : 6.8.4 Type : xls Author : Frank Moyes and Stephen Lawrence at Leeds School of Business Web site : http://leeds-faculty.colorado.edu/moyes and http://leeds-faculty.colorado.edu/lawrence

Income Statement What If Analysis

Details : Income Statement What If Analysis (Alternative term for sensitivity analysis). Simulation analysis in which key quantitative assumptions and computations (underlying a decision, estimate, or project) are changed systematically to assess their effect on the final outcome. Employed commonly in evaluation of the overall risk or in identification of critical factors, it attempts to … Continue reading Income Statement What If Analysis

Income Statement What If Analysis

Details : Income Statement What If Analysis (Alternative term for sensitivity analysis). Simulation analysis in which key quantitative assumptions and computations (underlying a decision, estimate, or project) are changed systematically to assess their effect on the final outcome. Employed commonly in evaluation of the overall risk or in identification of critical factors, it attempts to … Continue reading Income Statement What If Analysis

Hamlin’s Financial Addin for Excel

Details : An addin program for Microsoft Excel version 7.0 or higher (Excel for Windows 95, Excel 97 and Excel 2000). This addin includes the following functions: Adjusted Black Scholes valuation of Call and Put options. Calculation of Interest Expense based on average debt outstanding without ‘Circular Reasoning’ when the ending debt outstanding depends on … Continue reading Hamlin’s Financial Addin for Excel