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
- 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
- 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
- History - Menu driven Excel program (must enable macros) for Historical Financial Statements from the book Analysis for Financial Management
- Business Valuation Model (zip) - Set of tabbed worksheets for generating forecast / valuation outputs
- 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
- Ratio Reminder (zip) - Simple worksheet of comparative financials and corresponding ratios
- Risk Analysis IT - Template for assessing risk of Information Technology
- Risk Analysis DW - Template for assessing risk of Data Warehousing
- Excel Workbook 1-2 - Set of worksheets for evaluating financial performance and forecasting
- Rule Maker Essentials - Excel Template for scoring a company by entering financial data
- Rule Maker Ranker - Excel Template for scoring a company by entering comparable data
- 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 cash flow model with explanations of each cash flow component
- 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
- 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
- Cash Flow Sensitivity (xlt) - Sensitivity analysis spreadsheet
- What If Analysis - Set of templates for sensitivity analysis using financial inputs
- Risk Return Optimization - Optimal project selection (must enable macro's)
- CI - Basics #1 - Basic spreadsheet illustrating competitive analysis
- CI - Basics #2 - Basic spreadsheet illustrating competitive analysis
- External Assessment - Assessment questions for organizational assessment (must enable macros)
- Internal Assessment - Assessment questions for organizational assessment (must enable macros)
- Formal Scorecard - Formal Balanced Scorecard Spreadsheet Model (3.65 MB / must enable macros)
- Project Plan - Project Scheduling Template currently setup for a Balanced Scorecard Project
- Gantt Chart - Gantt chart for project management with work plan
- E O Q Model - Simple Inventory Models for calculating Economic Order Quantity
- Inventory Simulation Control Model - Formal model for simulating inventory shortages, delivery times, costs, backorders, and optimal inventory levels
- Financial Projections Model - A comprehensive financial model for forecasting a complete set of financials with breakeven and valuation tabs
- Option Trading Workbook - Educational toolkit for using Excel for Options
- Financial Model - A nice clean financial model driven by different calculators (such as Company, Market, Subscribers, etc.)
- Forecasting Model - Step by step financial model for forecasting financials
- Economic Evaluation - Step by step workbook for evaluating the economics of a system investment
- Project Management Templates - A collection of templates (charter, budget, risk register, issues log, etc.) for managing a project
- Project Cost Estimating Workbook - A workbook model for developing a cost estimate on a software development project
- Risk Assessment Register - A workbook for establishing a risk management register
- Simple ABC Model - A simple model that illustrates Activity Based Costing
- Six Sigma Tool Kit - A large collection of templates for doing six sigma tasks
- Project Management Tool Kit - Collection of useful templates for managing projects
- Intellectual Property Valuation Model - A simple and easy to use model to help assign value to intellectual assets such as patents, copyrights and trademarks
- IT Infrastructure Maturity Assessment - Maturity model for evaluating different segments of IT infrastructure
- EVA Model - Template worksheets for calculating Economic Value Added (EVA)
- EVA Tree Model - Economic Value Added drill-down model with charts
- Personal Finance Model - A simple and clean model to track personal wealth
- Financial Startup Model - A six parameter model to help organize financials for startup companies
- Performance Leadership Assessment - Simple and straight-forward tool for assessing leadership across five important categories
- Due Diligence Assessment Model - Assessment of new business ventures across ten different dimensions
- Management Diamond Assessment - A useful tool for developing human capital and teams
- Performance Solution Tool Kit - Evaluation of performance issues related to knowledge gaps
- Ratio Tree - A simple yet comprehensive tree of ratios for most businesses
- Skills & Modeling Guide | Assessment Exercise Workbook - Two very good spreadsheet models to help you develop your spreadsheet modeling skills
- Breakeven Forecasting Model - A clean and contemporary spreadsheet tool for easily forecasting breakeven. Includes parameters for seasonality and start-up optimization
- ROI IT Initiative Tool - A comprehensive business case model for evaluating technology projects
- Waterfall Distribution Model - Distribution of proceeds from a business venture using hurdles
- LBO DCF Model - Leveraged Buyout Model with tabs for financials and analysis
- Weekly Cash Flow - Rolling cash flow projections of purchases
- Factoring Cash Flow - Weekly calculation of cash flows with factoring
- Dashboard Report - Demonstrates countif, vlookup, and arrays
- Real Estate Investment Analysis
- Rental Property Investment - Workbook for evaluating rental property
- Valuation Utility Workbook | User Manual - A nice and simple valuation model with sensitivity charts
- Monte Carlo Sales Forecast - Provides an example of Monte Carlo Simulation using a simple sales forecast model
- Depreciation Schedules - Calculates annual depreciation using a variety of methods
- NPV Calculator - Shows examples that use the NPV, IRR, XNPV, and XIRR functions
- Box IPO Model - A complete financial model developed by Dheeraj Vaidya
- Bidder Comparison Matrix - Weighted scoring of bid competition based on proposal criteria - MyPM
- Bid No Bid Worksheet - Captures comparative data on risks, partners, customer and competition - MyPM
- Win Theme Development - Captures data on customer, solutions, proof points and discriminators - MyPM
- Proposal Compliance Matrix - Tracks RFP requirements and corresponding proposal sections - MyPM
Excel Presentation Files
The following files are from a workshop I gave on Microsoft Excel:
- Core Presentation Workbook - Click Here to download the presentation workbook
- Financial Model - Click Here to download the comprehensive financial model
- Additional Files -
Sales - Text file used to demonstrate the OLAP / Cube feature of Excel.
NavBar - Add-In file for placing a navigation toobar into your worksheet