Free Excel Spreadsheets
Capital Budgeting Analysis (xls) - Basic program for doing capital budgeting analysis with inclusion of opportunity costs, working capital requirements, etc.
Rating Calculation (xls) - Estimates a rating and cost of debt based on the coverage of debt by an organization.
LBO Valuation (xls) - Analyzes the value of equity in a leverage buyout (LBO).
Synergy (xls) - Estimates the value of synergy in a merger and acquisition.
Valuation Models (xls) - Rough calculation for choosing the correct valuation model.
Risk Premium (xls) - Calculates the implied risk premium in a market. (uses macro's).
FCFE Valuation 1 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with stable growth rates.
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.
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.
FCFF Valuation 1 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with stable growth rates.
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.
Time Value (xls) - Introduction to time value concepts, such as present value, internal rate of return, etc.
Lease or Buy a Car (xls) - Basic spreadsheet for deciding to buy or lease a car.
NPV & IRR (xls) - Explains Internal Rate of Return, compares projects, etc.
Real Rates (xls) - Demonstrates inflation and real rates of return.
Template (xls) - Template spreadsheet for project evaluation & capital budgeting.
Free Cash Flow (xls) - Cash flow worksheets - subsidized and unsubsidized.
Capital Structure (xls) - Spreadsheet for calculating optimal capital structures using different percents of debt.
WACC (xls) - Calculation of Weighted Average Cost of Capital using beta's for equity.
Statements (xls) - Generate a set of financial statements using two input sheets - operational data and financial data.
Bond Valuation (zip) - Calculates the value or price of a 25 year bond with semi-annual interest payments.
Buyout (zip) - Analyzes the effects of combining two companies.
Cash Flow Valuation (zip) - Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows.
Financial Projections (zip) - Spreadsheet model for generating projected financials along with valuation based on WACC.
Leverage (zip) - Shows the effects on Net Income from using debt (leverage).
Ratio Calculator (zip) - Calculates a standard set of ratios based on input of financial data.
Stock Value (zip) - Calculates expected return on stock and value based on no growth, growth, and variable growth.
CFROI (xls) - Simplified Cash Flow Return on Investment Model.
Financial Charting (zip) - Add on tool for Excel 97, consists of 6 files.
Risk Analysis (exe) - Analysis and simulation add on for excel, self extracting exe file.
Black Scholes Option Pricing (zip) - Excel add on for the pricing of options.
Cash Flow Matrix - Basic cash flow model.
Business Financial Analysis Template for start-up businesses from Small Business Technology Center
Forex (zip) - Foreign market exchange simulation for Excel
Hamlin (zip) - Financial function add-on's for Excel
Tanly (zip) - Suite of technical analysis models for Excel
Financial History Pivot Table - Microsoft Financials
Income Statement What If Analysis
Breakeven Analysis (zip) - Pricing and breakeven analysis for optimal pricing - Biz Pep.
SLG Ratio Master (exe) - Excel workbook for creating 25 key performance ratios.
DCF - Menu driven Excel program (must enable macros) for Discounted Cash Flow Analysis from the book Analysis for Financial Management by Robert C. Higgins
History - Menu driven Excel program (must enable macros) for Historical Financial Statements from the book Analysis for Financial Management by Robert C. Higgins
Proforma - Menu driven Excel program (must enable macros) for Pro-forma Financial Statements from the book Analysis for Financial Management by Robert C. Higgins
Business Valuation Model (zip) - Set of tabbed worksheets for generating forecast / valuation outputs. Includes instruction sheet. Bizpep
LBO Model - Excel model for leveraged buy-outs
Comparable Companies - Excel valuation model comparing companies
Combination Model - Excel valuation model for combining companies
Balanced Scorecard - Set of templates for building a balanced scorecard.
Cash Model - Template for calculating projected financials from CFO Connection
Techniques of Financial Analysis - Workbook of 11 templates (breakeven, valuation, forecasting, etc.) from ModernSoft
Ratio Reminder (zip) - Simple worksheet of comparative financials and corresponding ratios from Agilicor
Risk Analysis IT - Template for assessing risk of Information Technology - Audit Net
Risk Analysis DW - Template for assessing risk of Data Warehousing - Audit Net
Excel Workbook 1-2 - Set of worksheets for evaluating financial performance and forecasting - Supplemental Material for Short Course 1 and 2 on this website.
Rule Maker Essentials - Excel Template for scoring a company by entering financial data - The Motley Fool
Rule Maker Ranker - Excel Template for scoring a company by entering comparable data - The Motley Fool
IPO Timeline - Excel program for Initial Public Offerings (must enable macros)
Assessment Templates - Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.
Cash Gap in Days - Spreadsheet for calculating number of days required for short-term financing.
Cash Flow Template - Simple spreadsheet for calculating Free Cash Flow.
Six Solver Workbook (zip) - Set of various spreadsheets for solving different business problems (inventory ordering, labor scheduling, working capital, etc.).
Free Cash Flow Valuation - Basic Spreadsheet Valuation Model
Finance Examples - Seven examples in Business Finance - Solver
Capital Budgeting Workbook - Several examples of capital budgeting analysis, including the use of Solver to select optimal projects.
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.
Investment Valuation Model (zip) - Valuation model of companies (must enable macros) - Excel Business Tools
Cash Flow Sensitivity (xlt) - Sensitivity analysis spreadsheet - Small Business Store
What If Analysis - Set of templates for sensitivity analysis using financial inputs.
Risk Return Optimization - Optimal project selection - Metin Kilic (must enable macro's)