Visit www.exinm.com/free_spreadsheets and get free finance spreadsheets
1.
Capital Budgeting Analysis (xls) - Basic program for doing capital budgeting analysis with inclusion of opportunity costs, working capital requirements, etc. -
Aswath Damodaran
2.
Rating Calculation (xls) - Estimates a rating and cost of debt based on the coverage of debt by an organization -
Aswath Damodaran
3.
LBO Valuation (xls) - Analyzes the value of equity in a leverage buyout (LBO) -
Aswath Damodaran
4.
Synergy (xls) - Estimates the value of synergy in a merger and acquisition -
Aswath Damodaran
5.
Valuation Models (xls) - Rough calculation for choosing the correct valuation model -
Aswath Damodaran
6.
Risk Premium (xls) - Calculates the implied risk premium in a market. (uses macro's) -
Aswath Damodaran
7.
FCFE Valuation 1 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with stable growth rates -
Aswath Damodaran
8.
FCFE Valuation 2 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth -
Aswath Damodaran
9.
FCFE Valuation 3 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with three stages of growth, high growth initially, decline in growth, and then stable growth -
Aswath Damodaran
10.
FCFF Valuation 1 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with stable growth rates -
Aswath Damodaran
11.
FCFF Valuation 2 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth -
Aswath Damodaran
12.
Time Value (xls) - Introduction to time value concepts, such as present value, internal rate of return, etc.
13.
Lease or Buy a Car (xls) - Basic spreadsheet for deciding to buy or lease a car.
14.
NPV & IRR (xls) - Explains Internal Rate of Return, compares projects, etc.
15.
Real Rates (xls) - Demonstrates inflation and real rates of return.
16.
Template (xls) - Template spreadsheet for project evaluation & capital budgeting.
17.
Free Cash Flow (xls) - Cash flow worksheets - subsidized and unsubsidized.
18.
Capital Structure (xls) - Spreadsheet for calculating optimal capital structures using different percents of debt.
19.
WACC (xls) - Calculation of Weighted Average Cost of Capital using beta's for equity.
20.
Statements (xls) - Generate a set of financial statements using two input sheets - operational data and financial data.
21.
Bond Valuation (zip) - Calculates the value or price of a 25 year bond with semi-annual interest payments.
22.
Buyout (zip) - Analyzes the effects of combining two companies.
23.
Cash Flow Valuation (zip) - Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows.
24.
Financial Projections (zip) - Spreadsheet model for generating projected financials along with valuation based on WACC.
25.
Leverage (zip) - Shows the effects on Net Income from using debt (leverage).
26.
Ratio Calculator (zip) - Calculates a standard set of ratios based on input of financial data.
27.
Stock Value (zip) - Calculates expected return on stock and value based on no growth, growth, and variable growth.
28.
CFROI (xls) - Simplified Cash Flow Return on Investment Model.
29.
Financial Charting (zip) - Add on tool for Excel 97, consists of 6 files.
30.
Risk Analysis (exe) - Analysis and simulation add on for excel, self extracting exe file.
31.
Black Scholes Option Pricing (zip) - Excel add on for the pricing of options.
32.
Cash Flow Matrix - Basic cash flow model.
33.
Business Financial Analysis Template for start-up businesses from
Small Business Technology Center
34.
Forex (zip) - Foreign market exchange simulation for Excel
35.
Hamlin (zip) - Financial function add-on's for Excel
36.
Tanly (zip) - Suite of technical analysis models for Excel
37.
Financial History Pivot Table - Microsoft Financials
38.
Income Statement What If Analysis
39.
Breakeven Analysis (zip) - Pricing and breakeven analysis for optimal pricing -
Biz Pep.
40.
SLG Ratio Master (exe) - Excel workbook for creating 25 key performance ratios.
41.
DCF - Menu driven Excel program (must enable macros) for Discounted Cash Flow Analysis from the book Analysis for Financial Management by
Robert C. Higgins -
Analysis for Financial Management
42.
History - Menu driven Excel program (must enable macros) for Historical Financial Statements from the book Analysis for Financial Management by
Robert C. Higgins -
Analysis for Financial Management
43.
Business Valuation Model (zip) - Set of tabbed worksheets for generating forecast / valuation outputs. Includes instruction sheet.
Bizpep
44.
LBO Model - Excel model for leveraged buy-outs
45.
Comparable Companies - Excel valuation model comparing companies
46.
Combination Model - Excel valuation model for combining companies
47.
Balanced Scorecard - Set of templates for building a balanced scorecard.
48.
Cash Model - Template for calculating projected financials from
CFO Connection
49.
Techniques of Financial Analysis - Workbook of 11 templates (breakeven, valuation, forecasting, etc.) from
ModernSoft
50.
Ratio Reminder (zip) - Simple worksheet of comparative financials and corresponding ratios
51.
Risk Analysis IT - Template for assessing risk of Information Technology -
Audit Net
52.
Risk Analysis DW - Template for assessing risk of Data Warehousing -
Audit Net
53.
Excel Workbook 1-2 - Set of worksheets for evaluating financial performance and forecasting - Supplemental Material for Short Course 1 and 2 on this website.
54.
Rule Maker Essentials - Excel Template for scoring a company by entering financial data -
The Motley Fool
55.
Rule Maker Ranker - Excel Template for scoring a company by entering comparable data -
The Motley Fool
56.
IPO Timeline - Excel program for Initial Public Offerings (must enable macros)
57.
Assessment Templates - Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.
58.
Cash Gap in Days - Spreadsheet for calculating number of days required for short-term financing.
59.
Cash Flow Template - Simple cash flow model with explanations of each cash flow component -
Arkansas Small Business Development Center.
60.
Six Solver Workbook (zip) - Set of various spreadsheets for solving different business problems (inventory ordering, labor scheduling, working capital, etc.).
61.
Free Cash Flow Valuation - Basic Spreadsheet Valuation Model
62.
Finance Examples - Seven examples in Business Finance -
Solver
63.
Capital Budgeting Workbook - Several examples of capital budgeting analysis, including the use of Solver to select optimal projects.
64.
Present Value Tables (rtf) - Set of present value tables written in rich text format, compatible with most word processors. Includes examples of how to use present value tables.
65.
Investment Valuation Model (zip) - Valuation model of companies (30 Day Trial Model) from
Business Spreadsheets | Additional Trial Models from Business Spreadsheets >
Real Option Valuation |
Portfolio Optimization |
Optimal Hedging Strategy
66.
Cash Flow Sensitivity (xlt) - Sensitivity analysis spreadsheet -
Small Business Store
67.
What If Analysis - Set of templates for sensitivity analysis using financial inputs.
68.
Risk Return Optimization - Optimal project selection (must enable macro's) -
Metin Kilic
69.
CI - Basics #1 - Basic spreadsheet illustrating competitive analysis -
Business Tools Templates.
70.
CI - Basics #2 - Basic spreadsheet illustrating competitive analysis -
Business Tools Templates.
71.
External Assessment - Assessment questions for organizational assessment (must enable macros).
72.
Internal Assessment - Assessment questions for organizational assessment (must enable macros).
73.
Formal Scorecard - Formal Balanced Scorecard Spreadsheet Model (3.65 MB / must enable macros) -
Madison Area Quality Improvement Network.
74.
Project Plan - Project Scheduling Template currently setup for a Balanced Scorecard Project.
75.
Gantt Chart - Gantt chart for project management with work plan -
Jim Chapman's Web Site |
Simplified Version - Barnard of
Fong's Eng & Manf
76.
E O Q Model - Simple Inventory Models for calculating Economic Order Quantity.
77.
Inventory Simulation Control Model - Formal model for simulating inventory shortages, delivery times, costs, backorders, and optimal inventory levels -
John McClain
78.
Financial Projections Model - A comprehensive financial model for forecasting a complete set of financials with breakeven and valuation tabs developed by
Frank Moyes and
Stephen Lawrence at Leeds School of Business.
79.
Option Trading Workbook - Educational toolkit for using Excel for Options -
Option Trading Tips
80.
Financial Model - A nice clean financial model driven by different calculators (such as Company, Market, Subscribers, etc.) developed by
Bill Snow.
81.
Forecasting Model - Step by step financial model for forecasting financials created by
Sam Gui
82.
Economic Evaluation - Step by step workbook for evaluating the economics of a system investment
83.
Project Management Templates - A collection of templates (charter, budget, risk register, issues log, etc.) for managing a project -
International Association of Project and Program Management
84.
Project Cost Estimating Workbook - A workbook model for developing a cost estimate on a software development project -
ProTrain China
85.
Risk Assessment Register - A workbook for establishing a risk management register -
Emergency Preparedness Capacity Builders
86.
Simple ABC Model - A simple model that illustrates Activity Based Costing
87.
Six Sigma Tool Kit - A large collection of templates for doing six sigma tasks
88.
Project Management Tool Kit - Collection of useful templates for managing projects -
Michael D. Taylor
89.
Intellectual Property Valuation Model - A simple and easy to use model to help assign value to intellectual assets such as patents, copyrights and trademarks -
My Patent
90.
IT Infrastructure Maturity Assessment - Maturity model for evaluating different segments of IT infrastructure
91.
EVA Model - Template worksheets for calculating Economic Value Added (EVA) -
Zachary Scott
92.
EVA Tree Model - Economic Value Added drill-down model with charts -
Manfred Grotheer
93.
Personal Finance Model - A simple and clean model to track personal wealth -
ROI Team
94.
Financial Startup Model - A six parameter model to help organize financials for startup companies -
ROI Team
95.
Performance Leadership Assessment - Simple and straight-forward tool for assessing leadership across five important categories -
People Positive
96.
Due Diligence Assessment Model - Assessment of new business ventures across ten different dimensions -
Affiliate Tips
97.
Management Diamond Assessment - A useful tool for developing human capital and teams -
Geir Fuglaas |
Management Diamond Overview |
Management Diamond Book
98.
Performance Solution Tool Kit - Evaluation of performance issues related to knowledge gaps -
Brent Norton
99.
Ratio Tree - A simple yet comprehensive tree of ratios for most businesses -
Strategy Expert
100.
Skills & Modeling Guide |
Assessment Exercise Workbook - Two very good spreadsheet models to help you develop your spreadsheet modeling skills -
Tykoh Training
101.
Breakeven Forecasting Model - A clean and contemporary spreadsheet tool for easily forecasting breakeven. Includes parameters for seasonality and start-up optimization -
Ethos 360
102.
ROI IT Initiative Tool - A comprehensive business case model for evaluating technology projects -
Hall Consulting
103.
Waterfall Distribution Model - Distribution of proceeds from a business venture using hurdles -
Global iConnect
104.
LBO DCF Model - Leveraged Buyout Model with tabs for financials and analysis -
Global iConnect
105.
Weekly Cash Flow - Rolling cash flow projections of purchases -
Portal CFO
106.
Factoring Cash Flow - Weekly calculation of cash flows with factoring -
MP Star Financial Invoice Factoring
107. Series of Commission Spreadsheets >
Calculator |
Template-Fixed |
Template-Margin |
Template Revenue
108.
Dashboard Report - Demonstrates countif, vlookup, and arrays - Bob Lopez
109.
Real Estate Investment Analysis - Workbook example developed by
Dr. Greg Smersh
110.
Rental Property Investment - Workbook for evaluating rental property -
Globaliconnect
111.
Valuation Utility Workbook |
User Manual - A nice and simple valuation model with sensitivity charts -
Tykoh Training
Technorati Tags:
Free Excel Spreadsheets,
Capital Analysis,
Valuation,
Analyzes,
Synergy Models,
Risk Premium,
FCFE,
Cash Model,
FCFF,
Lease,
IRR,
Internal Rate Return,
Finance Ratios,
Return Real Rates,
RRR,
Template,
Spreadsheet,
WACC,
Beta,
Bond,
Buyout,
Financial Projections,
Projections,
Leverage,
Income,
Ratio,
Stock,
CFROI,
Investment,
Black Scholes,
Option,
Matrix,
Forex,
Foreign,
Financials Statement,
Breakeven point,
Management,
Scorecard,
Templates,
Solver,
Finance,
Portfolio,
Optimization,
Optimal,
Strategy,
Project,
Plan,
Gantt Chart,
Chart,
Inventory,
Economic,
Simulation,
Options,
Company,
Market,
Evaluation,
International,
Sigma,
Infrastructure,
Startup,
Performance,
Diligence,
Affiliate,
Waterfall Distribution,
Distribution,
Global,
Margin,
Revenue,
Dashboard,
Estate,
costs,
debt,
organization,
organizations,
growth,
Worksheets,
Macros,
organizational,
Excel charts
Windows Live Tags:
Free Excel Spreadsheets,
Capital Analysis,
Valuation,
Analyzes,
Synergy Models,
Risk Premium,
FCFE,
Cash Model,
FCFF,
Lease,
IRR,
Internal Rate Return,
Finance Ratios,
Return Real Rates,
RRR,
Template,
Spreadsheet,
WACC,
Beta,
Bond,
Buyout,
Financial Projections,
Projections,
Leverage,
Income,
Ratio,
Stock,
CFROI,
Investment,
Black Scholes,
Option,
Matrix,
Forex,
Foreign,
Financials Statement,
Breakeven point,
Management,
Scorecard,
Templates,
Solver,
Finance,
Portfolio,
Optimization,
Optimal,
Strategy,
Project,
Plan,
Gantt Chart,
Chart,
Inventory,
Economic,
Simulation,
Options,
Company,
Market,
Evaluation,
International,
Sigma,
Infrastructure,
Startup,
Performance,
Diligence,
Affiliate,
Waterfall Distribution,
Distribution,
Global,
Margin,
Revenue,
Dashboard,
Estate,
costs,
debt,
organization,
organizations,
growth,
Worksheets,
Macros,
organizational,
Excel charts
WordPress Tags:
Free Excel Spreadsheets,
Capital Analysis,
Valuation,
Analyzes,
Synergy Models,
Risk Premium,
FCFE,
Cash Model,
FCFF,
Lease,
IRR,
Internal Rate Return,
Finance Ratios,
Return Real Rates,
RRR,
Template,
Spreadsheet,
WACC,
Beta,
Bond,
Buyout,
Financial Projections,
Projections,
Leverage,
Income,
Ratio,
Stock,
CFROI,
Investment,
Black Scholes,
Option,
Matrix,
Forex,
Foreign,
Financials Statement,
Breakeven point,
Management,
Scorecard,
Templates,
Solver,
Finance,
Portfolio,
Optimization,
Optimal,
Strategy,
Project,
Plan,
Gantt Chart,
Chart,
Inventory,
Economic,
Simulation,
Options,
Company,
Market,
Evaluation,
International,
Sigma,
Infrastructure,
Startup,
Performance,
Diligence,
Affiliate,
Waterfall Distribution,
Distribution,
Global,
Margin,
Revenue,
Dashboard,
Estate,
costs,
debt,
organization,
organizations,
growth,
Worksheets,
Macros,
organizational,
Excel charts
Blogger Labels:
Free Excel Spreadsheets,
Capital Analysis,
Valuation,
Analyzes,
Synergy Models,
Risk Premium,
FCFE,
Cash Model,
FCFF,
Lease,
IRR,
Internal Rate Return,
Finance Ratios,
Return Real Rates,
RRR,
Template,
Spreadsheet,
WACC,
Beta,
Bond,
Buyout,
Financial Projections,
Projections,
Leverage,
Income,
Ratio,
Stock,
CFROI,
Investment,
Black Scholes,
Option,
Matrix,
Forex,
Foreign,
Financials Statement,
Breakeven point,
Management,
Scorecard,
Templates,
Solver,
Finance,
Portfolio,
Optimization,
Optimal,
Strategy,
Project,
Plan,
Gantt Chart,
Chart,
Inventory,
Economic,
Simulation,
Options,
Company,
Market,
Evaluation,
International,
Sigma,
Infrastructure,
Startup,
Performance,
Diligence,
Affiliate,
Waterfall Distribution,
Distribution,
Global,
Margin,
Revenue,
Dashboard,
Estate,
costs,
debt,
organization,
organizations,
growth,
Worksheets,
Macros,
organizational,
Excel charts
![clip_image002[1]](http://lh5.ggpht.com/-SfVlhi0D6Rg/UY9xmG2lxeI/AAAAAAAAAfg/kO92kGSCRDI/s1600-h/clip_image002%25255B1%25255D%25255B7%25255D.jpg "clip_image002[1]")
