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
Decid
DECID is intended for entrepreneurs, designers, students, training organizations, and expert advice. DECIDES, a uniform and structured approach to formalization of business project. DECIDES publishes Business Plan for your file and runs Microsoft Excel Tm. The downloadable version here is a version of presentation, it is complete and becomes fully operational on receipt of user code transmitted following … Continue reading Decid
Economic Monitoring
4 curves allow automated monitoring economic developments of a company, association, CA, PO … They can be displayed from one to 4 at a time, according to his needs. He now has a history of 22 years (2003-2025) which reverts to a graphical past. A Help topic allows to study the operation and the possibilities of personal changes.Fields … Continue reading Economic Monitoring
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
Evaluation of the cost of purchase
Description: This program assesses the resale price of products purchased, a coefficient multiplier. The VAT differential between purchase and sale, net and gross margins may also be targeted. The point is how to manage one or more products based on economic criteria, balance sheet, income statement, even. The program uses the VALUE TARGET, put it is automated. Useful … Continue reading Evaluation of the cost of purchase
Projects budget
For use by would-be creators wishing to have the status of TNS (not employees) Calculating a basic assumption; impacts of changes in key data; review of the cash the first months; break even … email: belleville@sobec.experts-comptables.fr File Type: Freeware Excel version required: Excel 97 + OS supported: PCMac Creation Date: 31 Aug 2007 Size: 239 … Continue reading Projects budget
Annual Budgets for Enterprise
New version 2.0, adding the concept of cost center. Implementation monitoring of annual budgets by cost centers and types of expenses Directorates and Departments of Enterprise. Carried out in Excel, the purpose of this application is to enable the monitoring of annual budgets by types of expenses Directorates and Departments of Enterprise. It allows you to … Continue reading Annual Budgets for Enterprise
Planning XLS FREE
FREE XLS-Planning (8.0) is a tool for management planning planning a team of up to 30 employees. The principle of this application based on the construction of cycles (of 1 to 12 weeks, according to the Labour Code) codes from predefined schedules. Just then choose the years and months of planning and a mouse click, … Continue reading Planning XLS FREE
Planning Pro XLS
XLS-Planning PRO (8.0) is a tool for management planning planning a team of up to 30 employees. The principle of this application based on the construction of cycles (of 1 to 12 weeks, according to the Labour Code) codes from predefined schedules. Just then choose the years and months of planning and a mouse click, the … Continue reading Planning Pro XLS
Activity Schedule
You can set this schedule with the actors and activities. Each sheet represents one month, and each day can be divided into two parts or not. To generate it, follow the instructions in the “Settings” page (it takes leap years). This new version contains a sheet “Stats” that recognizes activities in half-days per month and per year. … Continue reading Activity Schedule
Planning manage schedules
This application manages schedules over a period depending on a type of schedule you define. It ensures management of absences or tasks in a day or half day based on a list of codes, and print group schedules. Update 28/08/05: New version! Multiple sites and better code management absences email: d.sourbelle @ wanadoo.fr File Type: … Continue reading Planning manage schedules
Didier 2003 schedule
This schedule was created to manage a medical team of 37 officers while planning is the number of officers on duty at rest etc. .. it also calculates the total days worked, leave the rest of the illness and hours worked. email: lesaint _ didier @ club-internet .fr File Type: Freeware Excel version required: Excel … Continue reading Didier 2003 schedule
Annual Planning
Description: This program manages an annual schedule. It enables the recording of leave laid, the hours worked. One can generate several years with the French public holidays (can change the list of holidays). Features: – Ability to manage twelve codes of the absence or presence of custom. – Ability to define and implement a series of … Continue reading Annual Planning
Planning SSIAD V5-2
Description: This file is used to manage the planning of a nursing service (or other) of 51 individuals with monthly schedule for all service and print a schedule for each employee. creative planning with rolling. Included time management, the number of salaries required for the service. email: christian.raoux @ wanadoo.fr File Type: Freeware Excel version required: … Continue reading Planning SSIAD V5-2
Pental 30
Description: Here’s a spreadsheet to track the work attendant systematic work of a bottling company, and by minutes per section (s). It is unpretentious but it allows a daily monitoring of all interventions. I do not doubt for one moment that this sheet can be significantly improved, and I count on all of you to do … Continue reading Pental 30
Human Resources
Description: A protective sheet was made to protect only those cells that should not be changed for the smooth running of the program. However for a study there is no word sheet protecting it. After the services, service changes, hours Buying intentions and paid leave (or cpn cp-1) (Do not forget the day of rest by … Continue reading Human Resources
Calendar TOSS
Description: A new calendar to manage working time. Discover. News of January 29, 2005: Adding a menu to navigate through the various options. Help is available in sheet1. email: denjoly@wanadoo.fr File Type: Freeware Excel version required: Excel 2000 + OS supported: PCMac Creation Date: January 29, 2005 Size: 503 KB Type: zip Author: Denis Joly
Calendar DFConcept
Planning management of working time. email: denis.flamand @ wanadoo.fr File Type: Freeware Excel version required: Excel 97 + OS supported: PCMac Creation Date: 10 Apr 2006 Size: 608 KB Type: zip Author: Denis FLEMISH Version: 8.0 Website: denis.flamand @ wanadoo.fr
Payroll XLS
File to calculate a pay stub. This file may well be completed on the likings of the user. For adding new sheets or macros you can embed macros in a blank workbook and refer to xlscompta. email: renatom2@free.fr File Type: Freeware Excel version required: Excel 97 + OS supported: PC Date created: 21 Jun 2004 … Continue reading Payroll XLS
Salary
Description: This workbook created in Excel 97 is intended to facilitate the preparation of pay slips to a household employee. You will find, associated with the file 40.xls Salary, the text of the “National Collective Bargaining Agreement for employees of particular employer.” Version 4.0 now allows to choose between membership fee or real wages. Furthermore … Continue reading Salary
Payroll Plus
Description: Payroll Plus version 8 to edit payslips for a company with a maximum of 9 employees, as simply and as quickly as possible, while remaining the most effective. In this version display in Euro (EUR) takes priority. email: @ paie.plus netwizz.net File Type: Shareware Excel version required: Excel 5 + supported: PC Creation Date: … Continue reading Payroll Plus
Pay and contributions
Description: allows to calculate the various contributions with conditional formulas Creation Date: October 10, 2007 Size: 47.50 Kb Type: xls Author: ML59BTSCGO2 Version: 1.0
Control services
This application allows to calculate the benefit of staff members based on their schedule. Navigation between the sheets is done via a list UserFrom which leaves except the hidden sheet. Similarly a UserForm can remove the excess media (except the three sheets needed.) Code prevents a leaf without name is created (with the default name sheet1) … Continue reading Control services
Payroll for Marocco
Payroll for Marocco – Statement of pay for working in Marocco. Regime employer social security and income tax base overall 2008 for Marocco. Bareme WRI 2008. Creation Date: 25 June 2008 Size: 173.50 Kb Type: xls Author: A. BRAIKI
Payroll for Tunisia
Payroll for Tunisia – Statement of pay for working in Tunisia. Regime employer social security and income tax base overall 2008 for Tunisia. Bareme WRI 2008. Creation Date: 12 Mar 2010 Size: 173.50 Kb Type: xls Author: A. BRAIKI
Payroll Bulletin Algeria
Statement of pay for working in Algeria.Regime employer social security and income tax base overall 2008. Bareme WRI 2008. Creation Date: 06 Feb 2009 Size: 173.50 Kb Type: xls Author: A. BRAIKI
Expense Automation – management of costs
Euromatic Expense automates the management of costs in corporate notes, since the input to the Integration Accountant. Key Features: * Parameter setting spending limits for each category of employees, and according to their area of displacement. * Setting up accounts accounting, account titles, names of services, information about your procedure expense, etc … * Control … Continue reading Expense Automation – management of costs
Expense Note Cost
Description: NOTE Cost is a model of classical note costs that can easily be adapted to most companies. It appears automatically the tax amounts and generates accounting entries. Creation date: 27 May 2006 Size: 30 KB Type: zip Author: Euromatic Version: 1.0 Website: http://euromatic. online.fr/
Managing holiday vouchers
Description: An application to the management of holiday vouchers for the councils. Creation Date: 27 Aug 2005 Size: 236.48Kb Type: zip Author: Vincent Bourdeyron (Humansoft) version : 1.0
Payslip
Description: Here is a payslip on excel with the calculation of overtime and absences. Creation Date: January 24, 2009 Size: 507.00 Kb Version: 1.0 Type: xls Author: Lawrence DCG2 MILLIE. Lurçat Maubeuge
S3201 certificate sick pay
Description: The certificate of pay to complete and send to the CPAM when an employee is sick or is on maternity or paternity leave FDF format (PDF autoremplie). Creation date: March 24, 2009 Size: 158.05 Kb Version: 1.0 Type: zip Author: Claudusaix Website: http://claudusaix. spaces.live.com/ spaces.live.com /
Model for production order
This program Microsoft Excel provides a model of good manufacturing destined for a workshop. The separation of the specific costs of labor allows the foreman to optimize its resources. Furthermore a different VAT rates for parts and labor, costs of delivery and approach are possibly included in the final cost. This model excel allows you to … Continue reading Model for production order
Cash Register
Description: Cash Register to store ready to wear special auto entrepreneur, ie without VAT. Ability to save your accounts monthly. Size: 226 Kb Type: zip
Model of Service Offering
This program allows a company, an artisan or an individual to provide a synthesis of separate service offerings into two categories. The example offers some materials and some labor, but these categories can be changed at will. This model excel file provides the ability to archive your offers per issue. Size: 226 Kb Type: zip … Continue reading Model of Service Offering
Model urgently Fax
For a fax cover page to reach its destination as quickly as possible, your best interest to make it more attractive than others. That’s what this program offers. If you send your faxes from computer to computer and your modem allows it, you also take advantage of the colors! The major advantage is the ability to … Continue reading Model urgently Fax
Order Form
Stop spend hours doing and re-order forms. Through this program, you will gain in productivity. Size: 108 Kb Type: zip Author: ROBERT René Version: 1.0
SpreadSheet acceptance of loan
This program evaluates the amount of loan that a financial institution would be likely to grant you. It takes into account your income, your expenses, your expenses and any outstanding loans to repay. The evaluation criteria are subject to the definition of two acceptance rates that bankers can interpret as they please. Size: 46 Kb Type: … Continue reading SpreadSheet acceptance of loan
SpreadSheet monthly timesheet
The employee, supervisor or the director of human resources all need to know the number of hours worked per week weeks. While the goals are not the same for these three categories of people, but this program can meet the needs of each, especially since it provides a monthly statement. Demo version limited to 20 employees … Continue reading SpreadSheet monthly timesheet
SpreadSheet count biweekly schedule
This program allows you to schedule a count over a period of fifteen days in the light of that business days. The total hours worked (at ‘normal’ and overtime) is automatically deducted at the bottom of the sheet. Demo version limited to 20 employees Size: 70 Kb Type: zip Author: ROBERT René version : 1.0
Sheet weekly timesheet
The switch to 35 hours is not necessarily easy. Some companies will have to completely revise the schedules of working capital of their employees. Vous pouvez y passez des heures … You can spend hours … or take a few minutes to fill the grid for this program. Besides the different time periods during which the … Continue reading Sheet weekly timesheet
Model timetable
Your schedule is always changing and awash in temperatures and loads. Now thanks to this program, you will generate a sheet at any time that you only have to insert in your diary. The schedule is automatically set to five business days.Simply specify a start date … Size: 53 Kb Type: zip Author: ROBERT René … Continue reading Model timetable
Model of Fax
Description: Stop wasting time trying to write a fax in French, English and another one third in German. Pour faire face à la mondialisation, To cope with globalization, here is a sheet that allows to apply indiscriminately to francophones, anglophones and the Germanophones. Nothing more simple and effective to treat the image of your company, … Continue reading Model of Fax
Model specifications
This sheet will allow you to quickly offer your customers clear and professional estimate. After entering the information necessary header (recipient, delivery time, ect.), Just type in at least a certain quantity and unit price per item for a total cost. This cost may possibly reflect a percentage discount, with the option of archiving your quote … Continue reading Model specifications
Sample Invoice with carbon copy
It is not uncommon to have a double or a triple bill aimed at accounting services to your customer. This model can automatically fill the original and the copy just as you would have done with carbon paper. Duplicate invoice Size: 53 Kb Type: zip Author: ROBERT René Version: 1.0
Invoice with Packing List
Description: When you make the distance selling (mail order, e-commerce), you must provide an invoice with your package and a delivery order recalling in particular the requirements for release: fresh approach, VAT, dock dues , … etc. This program allows these functions to convert the sum total of the Euro (€) to other currencies … … Continue reading Invoice with Packing List
Invoice Template v2
Description: A database of pre-entered your customers and manufacture products easily Bills with the ability to archive it. Size: 474 Kb Type: zip Author: ROBERT René Version: 2.0
Price List Sheet with Order
Description: Your customers often ask you a price list. Why not send a purchase order together? On this program, you find the right part of the list prices, and on the left all that relates to a control. Size: 160 Kb Type: zip Author: ROBERT René Version: 1.0
Generate a list of addresses
Description: This file has to generate pages of addresses from an alphabetical list. Each page can then be inserted into the handheld organizer of your employees. Also possible to edit envelopes and labels according to your database of addresses. Size: 160 Kb Type: zip Author: ROBERT René Version: 1.0 Website:
Planning special leave
Description: Planning special leave, just put the start and end of holidays and the number of days absent this calculation automatically taking account of public holidays and Saturdays and Sundays. Size: 61 Kb Type: zip Author: ROBERT René Version: 1.0 Website:
Monthly Schedule of activities
Description: This file offers a monthly schedule that takes into account leap years and holidays. Size: 680 Kb Type: zip Author: ROBERT René Version: 1.0 Website: denis.flamand @ wanadoo.fr
Medical follow-up of company personnel
Description: This file “medical monitoring” allows a company to track and review your medical staff. Upon opening the file you will immediately be notified through an alert message of invitations to perform. Choose the number of days warning before the due date. Size: 125 Kb Type: zip Author: ROBERT René
Planning for monitoring appointments
Description: With this file follow your appointments. An embedded calendar and schedule are on hand to choose the dates of appointment, three forms are provided (New – List – Cancellation of appointment), Ability to print the list of appointments to the selected date. Size: 56 Kb Type: zip Author: ROBERT René Version: 1.0 Website:
Planning monitoring Reservation
Description: Planning special room reservation, simply set the start and end of the book to see the schedule will accrémenté. Ability to add the number of room of your choice. Reservations will be automatically deleted obsolete when opening the file. Automatic detection of whether or not a reservation according to the dates entered. Size: 223 … Continue reading Planning monitoring Reservation
Planning of site supervision
Description: Planning site supervision, just put the start and end of construction and the number of days is calculated automatically. Taille : 223 Kb Type: zip Author: ROBERT René Version: 1.0 Website:
Follow-up appointments 15 minutes
This file contains a follow-up appointment dates. Thanks to a built-in calendar, simply select the date and time and then “Submit” to your schedule is incremented. The range of appointment is 15 minutes Highlights: Automatic deletion of old appointments beyond two months before the current date and automatic detection of appointments already made. Size: 3248 Kb … Continue reading Follow-up appointments 15 minutes
Follow-up appointments 20 minutes
This file contains a follow-up appointment dates. Thanks to a built-in calendar, simply select the date and time and then “Submit” to your schedule is incremented. The range of appointment is 20 minutes Highlights: Automatic deletion of old appointments beyond two months before the current date and automatic detection of appointments already made. Size: 3248 Kb Type: … Continue reading Follow-up appointments 20 minutes
Follow-up appointments 30 minutes
This file contains a follow-up appointment dates. Thanks to a built-in calendar, simply select the date and time and then “Submit” to your schedule is incremented. The range of appointment is 30 minutes Highlights: Automatic deletion of old appointments beyond two months before the current date and automatic detection of appointments already made. Size: 3248 Kb Type: … Continue reading Follow-up appointments 30 minutes
Model of invoice and specifications for masonry
This workbook contains a quote convertible invoice, special masonry with a database of over 8255 rates (Batiprix) of different body (Structural work, plastering, carpentry, cleaning and many other), with a menu with forms down, make an estimate or invoice will be very simple and easy. Rates are changed with a single click with the increase of … Continue reading Model of invoice and specifications for masonry
Invoice Template
Invoice Template designed for designations to Vat 19.6% and 5.5%, according to a database of pre-entry of your customers and appointments, make your bills easily with the ability to archive it to them out at any time. Size: 2747 Kb Type: zip Author: ROBERT René Version: 1.0
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
Black and Scholes
This application allows calculation stock in Microsoft Excel to calculate the price of an option (call or put) from the formula for calculating (relatively complex) black and scholes. The formula for black and Scholes formula is a complex financial, but excel in this model hides the complexity so you can use it simply as part … Continue reading Black and Scholes
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
Monitoring Portfolio – Portfolio Management
Model “Portfolio Monitoring” allows continuous monitoring and periodic evaluation of a list of values and investments. The model excel to enter investment transactions for a period of monitoring and managing its portfolio optimally. Furthermore, incremental investment transactions undertaken during a period are fully explained in the calculations of the performance period. Turnover included in the model … Continue reading Monitoring Portfolio – Portfolio Management
Portfolio Optimization – Portfolio Optimization
Model “Portfolio Optimization” calculates the optimal capital weightings for a basket of investments that gives the return on investment for the higher risk whatsoever. High return on investment and risk monidre here is that stock market investors should satisfy the most demanding. The unique design allows it to be applied to brochures financial instrument or business. The ability … Continue reading Portfolio Optimization – Portfolio Optimization
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
Cash Budget Management and Receivables
This Excel tool is ideal for freelancers and small businesses. This excel file will allow you to track your open invoices and manage your cash and your monthly stastistiques. When you enter the date of your bills (open), the invoice amount will automatically appear in the right column. Creation Date: September 30, 2011 Size: 82 … Continue reading Cash Budget Management and Receivables
Absence Management in Excel
Whether for one department of a large company or an SME, this tool on Managing abences Excel will help you plan the vacation of employees and manage absenteeism. In this tool, you enter the start date and end of the absences of your employees with the reasons therefor; vacation, military service, illness, etc. .. Automatically, … Continue reading Absence Management in Excel
Real Option Valuation
The model of “Real Option Valuation” is a suite of tools assessing the option to measure the embedded strategic value for a range of investment scenarios. The financial analysis of investment expected traditional flow of money will only accept an investment if the returns on the project exceed the hurdle rate. While this is a … Continue reading Real Option Valuation
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
Accounting Balancesheet
Accounting Balancesheet Excel is an application compatible with open office. It will allow you to make the accounting of a non-accounting but only know the main principles. Already more than 5000 users in France, many clubs, once paid, the author now offers to all. WITHOUT ACCOUNTING, comptabilan will allow you to make write-offs, income statements, balance … Continue reading Accounting Balancesheet
Cooperative Accounting Class 22.1
This very accomplished Excel sheet was written to facilitate the bookkeeping of the cooperative class. It behaves much the structure of the specifications provided by the accounting OCCE. The bookkeeping are simplified to the maximum; ventilation and the production of the annual review are automatically generated, thereby eliminating the risk of potential errors. (Developed with Excel … Continue reading Cooperative Accounting Class 22.1
Doc AidCompta
Accounting assistance of a private doctor – Must be usable by any profession. Facilitates accounting tables requested by AGA Automates scales balancing items Allows calculation of driving costs (scales) allows the calculation of business tax actually due … Date created: 21 Jun 2004 Author: Jean-Luc Perrot jlperrot001@wanadoo.fr jlperrot001@wanadoo.fr Size: 32.3 KB Type: zip
Micro enterprise
Micro-enterprise, by the simplicity of administrative requirements, may have disadvantages: Absence of data to monitor management, Difficulties in the banking relationships because of the lack of papers. Inability to have a basis for discussion with an accountant asked for advice, counsel. This module allows to fulfill the basic obligations of the micro system: Bookkeeping Newspaper … Continue reading Micro enterprise
Calculation of reducing depreciation
This Excel file is designed for accounting professionals. It allows you to calculate depreciation, with French tax law. Creation Date: 01 Aug 2004 Author: Emmanuel BATT Size: 41 KB Type: zip
Ratio Tree
Details : A simple and comprehensive tree of ratios for most businesses in Excel. Size : 46 ko Type : xls Author : Strategy Expert Web site : http://www.strategyexpert.com/
Performance Solution Tool Kit
Details : Evaluation of performance issues related to knowledge gaps. Size : 176 ko Version : 2.0 Type : xls Author : Brent Norton Web site : http://www.brnorton.com/
Management Diamond Assessment
Details : A useful Excel tool for developing human capital and teams. Size : 51 ko Type : xls Author : Geir Fuglaas Web site : http://www.deltapi.no/
Due Diligence Assessment Model
Details : Assessment of new business ventures across ten different dimensions. Size : 60 ko Type : xls Author : AffiliateTips Web site : http://www.affiliatetips.com/
Performance Leadership Assessment
Details : Excel tool for assessing leadership across five important categories. Size : 123 ko Type : xls Author : PeoplePositive Web site : http://www.peoplepositive.co.uk/
Financial Startup Model
Details : Excel six parameter model to help organize financials for startup companies. Size : 391 ko Type : xls Author : ROI Team Web site : http://www.roi-team.com/
Personal Finance Model
Details : Excel files with a simple model to track personal wealth. Size : 290 ko Type : xls Author : ROI Team Web site : http://www.roi-team.com/
EVA Tree Model
Details : Economic Value Added (EVA) drill-down model with charts. Size : 55 ko Type : xls Author : Manfred Grotheer Web site : http://www.my-controlling.de/
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
Project Management Tool Kit
Details : Microsoft Excel workbook with a large collection of useful templates for managing projects. Size : 662 ko Type : xls Author : Michael D. Taylor Web site : http://www.projectmgt.com/
Risk Assessment Register
Details : Microsoft Excel workbook for establishing a risk management register. Size : 1 mo Type : xls Author : Emergency Preparedness Capacity Builders Web site : http://www.emergencyriskmanagement.com/
Project Cost Estimating Workbook
Details : A Microsoft EXcel workbook model for developing a cost estimate on a software development project. Size : 267 ko Type : xls Author : ProTrain China Web site : http://www.protrain-china.com/
Financial Model
Details : Excel financial model driven by different calculators (Company, Market, Subscribers, …) Size : 2.03 mo Type : xls Author : Bill Snow Web site : http://www.billsnow.com/
Gantt Chart
Details : Gantt chart for project management with work plan Size : 757 ko Version : 4.0 Type : xls Author : Jim Chapman Web site : http://www.hyperthot.com/project.htm
Project Plan
Details : Project Scheduling Template currently setup for a Balanced Scorecard Project. Project versus Business. The Finance perspective: Project Cost Overrun (PCO). The Customer perspective: On Time Delivery (OTD). The Process perspective: Resources Planning Accuracy (RPA). The Learning perspective: Project Management Quality (PMQ). Size : 170 ko Type : xls Author : Business-process-it.com Web site … Continue reading Project Plan
CI – Basics #2
Details : Basic spreadsheet illustrating competitive analysis. Example 2. Size : 58 ko Type : xls Author : Business Tools Templates Web site : http://www.business-tools-templates.com/
CI – Basics #1
Details : Basic spreadsheet illustrating competitive analysis. Example 1. Size : 72 ko Type : xls Author : Business Tools Templates Web site : http://www.business-tools-templates.com/
Cash Flow Sensitivity
Details : Sensitivity analysis excel spreadsheet Size : Type : zip Author : Small Business Store Web site : http://www.thesmallbusinessstore.com/
Investment Valuation Model
Details : Valuation model of companies. Size : 158 ko Type : zip Author : Business Spreadsheets Web site : http://www.business-spreadsheets.com/
Finance Examples
Details : Seven examples in Excel in Business Finance. Size : 112 ko Type : xls Author : Solver Web site : http://www.solver.com/
Rule Maker Essentials
Details : Excel Template for scoring a company by entering financial data. Size : 57 ko Type : xls Author : The Motley Fool Web site : http://www.fool.com/strategies.htm
Risk Analysis DW
Details : Template for assessing risk of Data Warehousing. Size : 58 ko Type : xls Author : Audit Net Web site : http://www.auditnet.org/
Risk Analysis IT
Details : Template for assessing risk of Information Technology. Size : 93 ko Type : xls Author : Audit Net Web site : http://www.auditnet.org/
Techniques of Financial Analysis
Details : Excel Workbook of 11 templates (breakeven, valuation, forecasting, etc.) from ModernSoft. Size : 182 ko Type : exe Author : ModernSoft Web site : http://www.modernsoft.com/
Cash Model
Details : Template for calculating projected financials from CFO Connection. Version : 1.4 Size : 48 ko Type : xls Author : CFO Connection Web site : http://www.thecfoconnection.com/
Business Valuation Model
Details : Set of tabbed worksheets for generating forecast / valuation outputs. Includes instruction sheet. Size : 639 ko Type : zip Author : Bizpep Web site : http://www.bizpeponline.com/
Proforma
Details : Menu driven Excel program (must enable macros) for Pro-forma Financial Statements from the book Analysis for Financial Management. Size : 398 ko Version : 7.0 Type : xls Author : Robert C. Higgins Web site : http://www.mhhe.com/higgins8e
History
Details : Menu driven Excel program (must enable macros) for Historical Financial Statements from the book Analysis for Financial Management. Size : 429 ko Version : 5.0 Type : xls Author : Robert C. Higgins Web site : http://www.mhhe.com/higgins8e
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
Breakeven Analysis
Details : Pricing and breakeven analysis for optimal pricing Size : 510 ko Type : zip Author : Biz Pep. Web site : http://www.bizpeponline.com/
Master Budget Model
Details : Excel sheets multi-period multi-product budget model for a fictional bicycle manufacturing company. Size : 168 ko Version : 2010 Type : xls Author : Jason Porter, PhD at University of Idaho and Teresa Stephenson, PhD at University of Wyoming Web site : jporter@uidaho.edu and teresas@uwyo.edu
IT Infrastructure Maturity Assessment
Details : Excel maturity model for evaluating different segments of IT infrastructure. Size : 206 ko Version : 4.2 Type : xls
Intellectual Property Valuation Model
Details : A simple and easy to use model to help assign value to intellectual assets such as patents, copyrights and trademarks. Size : 79 ko Type : xls Author : My Patent Web site : http://www.mypatent.co.za/
Six Sigma Tool Kit
Details : Microsoft Excel workbook with a large collection of templates for doing six sigma tasks. A business management strategy originally developed by Motorola, USA in 1986.As of 2010, it is widely used in many sectors of industry, although its use is not without controversy. Six Sigma seeks to improve the quality of process outputs … Continue reading Six Sigma Tool Kit
Simple ABC Model
Details : Microsoft Excel workbook with a simple model that illustrates Activity Based Costing. costing model that identifies activities in an organization and assigns the cost of each activity resource to all products and services according to the actual consumption by each: it assigns more indirect costs (overhead) into direct costs. In this way, an … Continue reading Simple ABC Model
Project Management Templates
Details : A collection of templates in Microsoft Excel with charts, budget, risk register, issues log, actions log, etc… for project management. Size : 1.54 mo Type : xls Author : International Association of Project and Program Management Web site : http://www.iappm.org/
Economic Evaluation
Details : Excel that explains step by step workbook for evaluating the economics of a system investment Size : 710 ko Type : xls
Forecasting Model
Details : Excel that explains step by step financial model for forecasting financials. Size : 672 ko Type : xls Author : Sam Gui Web site : http://www.esnips.com/doc/e043ef3b-bd95-4b04-afb6-24bb7731ba97/Financial-model
Option Trading Workbook
Details : Educational toolkit for using Excel for Options. Size : 323 ko Type : xls Author : Matt H.Evans
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
E O Q Model
Details : Simple Inventory Models for calculating Economic Order Quantity. Size : 67 ko Type : xls
Formal Scorecard
Details : Formal Balanced Scorecard Spreadsheet Model (this excel sheet contains macros). Size : 3.73 mo Type : xls Author : Madison Area Quality Improvement Network Web site : http://www.maqin.org/
Internal Assessment
Details : Assessment questions for organizational (internal review) assessment (You need to enable macros to use this excel worksheet). Size : 61 ko
External Assessment
Details : Assessment questions for organizational (external review) assessment (You need to enable macros to use this excel worksheet). Size : 121 ko Type : xls
Risk Return Optimization
Details : Optimal project selection (must enable macro’s). Size : 23 ko Type : zip Author : Metin Kilic Web site : http://www.metink.homestead.com/
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
Present Value Tables
Details : Set of present value tables written in rich text format, compatible with most word processors. Includes examples of how to use present value tables. Size : 66 ko Type : rtf
Capital Budgeting Workbook
Details : Several examples of capital budgeting analysis, including the use of Solver to select optimal projects. Size : 213 ko Type : xls Author : Matt H.Evans
Free Cash Flow Valuation
Details : Basic Spreadsheet Valuation Model. Size : 30 ko Type : zip
Six Solver Workbook
Details : Set of various spreadsheets for solving different business problems (inventory ordering, labor scheduling, working capital, etc.). Size : 149 ko Type : zip
Cash Flow Template
Details : Excel simple cash flow model with explanations of each cash flow component. Size : 51 ko Type : xls Author : Arkansas Small Business Development Center Web site : http://asbdc.ualr.edu/consulting/toolbox.asp
Cash Gap in Days
Details : Excel spreadsheet for calculating number of days required for short-term financing. Size : 41 ko Type : xls Author : Matt H.Evans
Assessment Templates
Details : Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model. The Malcolm Baldrige National Quality Award is an annual award that recognizes U.S. organizations in the business, health care, education, and nonprofit sectors for performance excellence. The Baldrige Award is the only formal recognition of the performance excellence of … Continue reading Assessment Templates
IPO Timeline
Details : Excel program for Initial Public Offerings (must enable macros). Size : 109 ko Type : xls
Ratio Reminder
Details : Simple Excel worksheets of comparative financials and corresponding ratios. Size : 11 ko Type : zip
Balanced Scorecard
Details : Set of templates for building a balanced scorecard. Size : 155 ko Type : xls Author : Matt H.Evans
Combination Model
Details : Excel valuation model for combining companies. Size : 826 ko Type : xls
Comparable Companies
Details : Excel valuation model comparing companies. Size : 1.34 mo Type : xls
LBO Model
Details : Excel model for leveraged buy-outs. Size : 361 ko Type : xls
SLG Ratio Master
Details : Excel workbook for creating 25 key performance ratios. Size : 47 ko Version : 2.1 Type : exe
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
Financial History Pivot Table
Details : Financial History Pivot Table. Size : 122 ko Type : xls
Tanly – technical Analysis Suite for Excel
Details : Suite of technical analysis models for Excel. Size : 35 ko Type : zip
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
Forex
Details : Foreign market exchange simulation for Excel. Size : 774 ko Type : zip
Business Financial Analysis Template
Details : Business Financial Analysis Template for start-up businesses from Small Business Technology Center. Size : 1,19 mo Version : 2.0 Type : exe
Cash Flow Matrix
Details : Basic cash flow model. Size : 50 ko Type : xls
Black Scholes Option Pricing
Details : Excel add on for the pricing of options. The Black–Scholes model is a mathematical description of financial markets and derivative investment instruments. The model develops partial differential equations whose solution, the Black–Scholes formula, is widely used in the pricing of European-style options. Size : 42 ko Version : 1.6 Type : zip
Risk Analysis
Details : Analysis and simulation add on for excel (risk analysis), self extracting exe file. Size : 826 ko Type : exe
Financial Charting
Details : This is an add on to Microsoft Excel that consist of 6 files (tool for Excel 97). Size : 131 ko Type : zip
Cash Flow Return on Investment Model
Details : Simplified Cash Flow Return on Investment Model with Excel. Size : 333 ko Type : zip
Stock Value
Details : Calculates expected return on stock and value based on no growth, growth, and variable growth with Excel. Size : 8 ko Type : zip
Excel financial ratio calculator
Details : Calculates a standard set of ratios based on input of financial data with Excel. Size : 12 ko Type : zip
Leverage effects
Details : Shows the effects on Net Income from using debt (leverage). Size : 5 ko Type : zip
Financial Projections
Details : Spreadsheet model for generating projected financials along with valuation based on WACC. Size : 26 ko Type : zip
Cash Flow Valuation
Details : Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows. Size : 8 ko Type : zip
Companies Buyout
Details : Excel workbook that analyzes the effects of combining two companies. Size : 7 ko Type : zip
Bond Valuation with semi-annual interest payments
Details : Excel spreadsheet that calculates the value or price of a 25 year bond with semi-annual interest payments. Size : 18 ko Type : zip
Financial statements
Details : Excel spreadsheet that generates a set of financial statements using two input sheets – operational data and financial data. Size : 68 ko Type : xls
Weighted Average Cost of Capital WACC
Details : Excel spreadsheet for calculation of Weighted Average Cost of Capital using beta’s for equity. Size : 35 ko Type : xls
Capital Structure Excel spreadsheet
Details : Excel spreadsheet for calculating optimal capital structures using different percents of debt. Size : 39 ko Type : xls
Free Cash flow worksheets
Details : Cash flow worksheets – subsidized and unsubsidized. Size : Type : xls
Template project evaluation
Details : Template spreadsheet for project evaluation & capital budgeting. Size : 42 ko Type : xls
Real Rates
Details : That excel file demonstrates inflation and real rates of return. Size : 22 ko Type : xls
Internal Rate of Return Excel Spreadsheet
Details : That excel file explains Internal Rate of Return, compares projects, portfolio project, etc. Size : 50 ko Type : xls
Lease or Buy a Car
Details : Basic spreadsheet for deciding to buy or lease a car. Size : 51 ko Type : xls
Time Value Template
Details : Introduction to time value concepts, such as present value, internal rate of return, etc. Size : 198 ko Type : xls
Free Cash Flow to Firm FCFF Valuation 2
Details : Excel worksheet that calculates the Free Cash Flow to Firm (FCFF) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth. Size : 48 ko Type : xls Author : Aswath Damodaran
Free Cash Flow to Firm FCFF Valuation 1
Details : Excel worksheet that calculates the Free Cash Flow to Firm (FCFF) Valuation Model for organizations with stable growth rates Size : 19 ko Type : xls Author : Aswath Damodaran
Free Cash Flow to Equity FCFE Valuation 3
Details : Free Cash Flow to Equity (FCFE) Valuation Model for organizations with several periods of growth, high growth and stable growth. Size : 42 ko Type : xls Author : Aswath Damodaran
Free Cash Flow to Equity FCFE Valuation 2
Details : Free Cash Flow to Equity (FCFE) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth. Size : 28 ko Type : xls Author : Aswath Damodaran
Free Cash Flow to Equity FCFE Valuation 1
Details : Free Cash Flow to Equity (FCFE) Valuation Model for organizations with stable growth rates. Size : 36 ko Type : xls Author : Aswath Damodaran
Market Risk Premium
Details : Excel sheet that calculates the implied risk premium in a market. That excel file uses macros. Size : 66 ko Type : xls Author : Aswath Damodaran
Valuation Models
Details : Excel spreadsheet with rough calculation for choosing the correct valuation model. Size : 22 ko Type : xls Author : Aswath Damodaran
Merger and Acquisition Value of Synergy
Details : Excel spreadsheet that estimates the value of synergy in a merger and acquisition Size : 17 ko Type : xls Author : Aswath Damodaran
Leverage Buyout LBO Valuation
Details : Excel files that analyzes the value of equity in a leverage buyout (LBO) Size : 41 ko Type : xls Author : Aswath Damodaran
Rating and Cost Debt Calculation
Details : This workbook estimates a rating and cost of debt based on the coverage of debt by an organization Size : Type : xls Author : Aswath Damodaran
Capital Budgeting Analysis
Details : This is a basic program for doing capital budgeting analysis with inclusion of opportunity costs, working capital requirements. Works fine. Size : 30 ko Type : xls Author : Aswath Damodaran
VeryGoodChoice Multi-Criteria Decision Analysis
Details : VeryGoodChoice is an advanced program for doing comparison and analysis of solutions regarding criteria. It is used in various professional context to make the right decision at the right time. Each time you need to compare alternatives, you can use VeryGoodChoice which is powered by a scientific algorithm. This algorithm reproduce the real … Continue reading VeryGoodChoice Multi-Criteria Decision Analysis