Financial Excel Template

Financial Modelling:

Listed below are several spreadsheets written in Microsoft Excel. These spreadsheets were collected from various web sites. Please be advised of the following: All spreadsheets are designed to work with Windows. xls files are downloaded by right clicking on your mouse and saving the target file to your hard drive. NOTE: If you left click on your mouse, the excel spreadsheet may come up on-line. zip files are downloaded by left clicking on your mouse. You will need to install a program to unzip the file, such as WinZip or attachment opener. If you have security protection installed on your computer (such as Norton System Works), you may need to disable it in order to download the files.

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 (xls) - Basic cash flow model.

BFAT - 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 (xls) - Microsoft Financials

Income Statement What If Analysis (xls) - Microsoft Financials

Exl-Plan Super (zip) - Generates financial projections including ratio analysis. Uses excel templates with numerous menu options.

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 (xls) - Excel model for leveraged buy-outs

Comparable Companies (xls) - Excel valuation model comparing companies

Combination Model (xls) - Excel valuation model for combining companies

Balanced Scorecard - Set of templates for building a balanced scorecard. (Supplemental Material for Short Course 11 in the Training Center).

Cash Model (xls) - Template for calculating projected financials from CFO Connection.

Techniques of Financial Analysis - Workbook of 11 templates (breakeven, valuation, forecasting, etc.) from ModernSoft | Companion Book

Ratio Reminder (zip) - Simple worksheet of comparative financials and corresponding ratios from Agilicor.

Risk Analysis IT (xls) - 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 (xls) - Set of worksheets for evaluating financial performance and forecasting. (Supplemental Material for Short Courses 1 & 2 in the Training Center).

Rule Maker Essentials (xls) - Excel Template for scoring a company by entering financial data - The Motley Fool

Rule Maker Ranker (xls) - Excel Template for scoring a company by entering comparable data - The Motley Fool

IPO Timeline (xls) - 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. (Supplemental Material for Short Course 10 in the Training Center).

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 - 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. (Supplemental Material for Short Course 3 in the Training Center).

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 - Excel Business Tools

Cash Flow Sensitivity - Sensitivity analysis spreadsheet - Small Business Store

Bold Hyperlink - Spreadsheet is unique to this website. All other spreadsheets are from other sources