Excel Spreadsheets

  1. 1Capital Budgeting Analysis (xls) - Basic program for doing capital budgeting analysis with inclusion of opportunity costs, working capital requirements, etc. - Aswath Damodaran
  2. 2Rating Calculation (xls) - Estimates a rating and cost of debt based on the coverage of debt by an organization - Aswath Damodaran
  3. 3LBO Valuation (xls) - Analyzes the value of equity in a leverage buyout (LBO) - Aswath Damodaran
  4. 4Synergy (xls) - Estimates the value of synergy in a merger and acquisition - Aswath Damodaran
  5. 5Valuation Models (xls) - Rough calculation for choosing the correct valuation model - Aswath Damodaran
  6. 6Risk Premium (xls) - Calculates the implied risk premium in a market. (uses macro's) - Aswath Damodaran
  7. 7FCFE Valuation 1 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with stable growth rates - Aswath Damodaran
  8. 8FCFE 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. 9FCFE 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. 10FCFF Valuation 1 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with stable growth rates - Aswath Damodaran
  11. 11FCFF 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. 12Time Value (xls) - Introduction to time value concepts, such as present value, internal rate of return, etc.
  13. 13Lease or Buy a Car (xls) - Basic spreadsheet for deciding to buy or lease a car.
  14. 14NPV & IRR (xls) - Explains Internal Rate of Return, compares projects, etc.
  15. 15Real Rates (xls) - Demonstrates inflation and real rates of return.
  16. 16Template (xls) - Template spreadsheet for project evaluation & capital budgeting.
  17. 17Free Cash Flow (xls) - Cash flow worksheets - subsidized and unsubsidized.
  18. 18Capital Structure (xls) - Spreadsheet for calculating optimal capital structures using different percents of debt.
  19. 19WACC (xls) - Calculation of Weighted Average Cost of Capital using beta's for equity.
  20. 20Statements (xls) - Generate a set of financial statements using two input sheets - operational data and financial data.
  21. 21Bond Valuation (zip) - Calculates the value or price of a 25 year bond with semi-annual interest payments.
  22. 22Buyout (zip) - Analyzes the effects of combining two companies.
  23. 23Cash Flow Valuation (zip) - Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows.
  24. 24Financial Projections (zip) - Spreadsheet model for generating projected financials along with valuation based on WACC.
  25. 25Leverage (zip) - Shows the effects on Net Income from using debt (leverage).
  26. 26Ratio Calculator (zip) - Calculates a standard set of ratios based on input of financial data.
  27. 27Stock Value (zip) - Calculates expected return on stock and value based on no growth, growth, and variable growth.
  28. 28CFROI (xls) - Simplified Cash Flow Return on Investment Model.
  29. 29Financial Charting (zip) - Add on tool for Excel 97, consists of 6 files.
  30. 30Risk Analysis (exe) - Analysis and simulation add on for excel, self extracting exe file.
  31. 31Black Scholes Option Pricing (zip) - Excel add on for the pricing of options.
  32. 32Cash Flow Matrix - Basic cash flow model.
  33. 33 Business Financial Analysis Template for start-up businesses from Small Business Technology Center
  34. 34Forex (zip) - Foreign market exchange simulation for Excel
  35. 35Hamlin (zip) - Financial function add-on's for Excel
  36. 36Tanly (zip) - Suite of technical analysis models for Excel
  37. 37Financial History Pivot Table - Microsoft Financials
  38. 38Income Statement What If Analysis
  39. 39Breakeven Analysis (zip) - Pricing and breakeven analysis for optimal pricing - Biz Pep.
  40. 40SLG Ratio Master (exe) - Excel workbook for creating 25 key performance ratios.
  41. 41DCF - 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. 42History - 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. 43Business Valuation Model (zip) - Set of tabbed worksheets for generating forecast / valuation outputs. Includes instruction sheet. Bizpep
  44. 44LBO Model - Excel model for leveraged buy-outs
  45. 45Comparable Companies - Excel valuation model comparing companies
  46. 46Combination Model - Excel valuation model for combining companies
  47. 47Balanced Scorecard - Set of templates for building a balanced scorecard.
  48. 48Cash Model - Template for calculating projected financials from CFO Connection
  49. 49Ratio Reminder (zip) - Simple worksheet of comparative financials and corresponding ratios
  50. 50Risk Analysis IT - Template for assessing risk of Information Technology - Audit Net
  51. 51Risk Analysis DW - Template for assessing risk of Data Warehousing - Audit Net
  52. 52Excel Workbook 1-2 - Set of worksheets for evaluating financial performance and forecasting - Supplemental Material for Short Course 1 and 2 on this website.
  53. 53Rule Maker Essentials - Excel Template for scoring a company by entering financial data - The Motley Fool
  54. 54Rule Maker Ranker - Excel Template for scoring a company by entering comparable data - The Motley Fool
  55. 55IPO Timeline - Excel program for Initial Public Offerings (must enable macros)
  56. 56Assessment Templates - Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.
  57. 57Cash Gap in Days - Spreadsheet for calculating number of days required for short-term financing.
  58. 58Cash Flow Template - Simple cash flow model with explanations of each cash flow component - Arkansas Small Business Development Center.
  59. 59Six Solver Workbook (zip) - Set of various spreadsheets for solving different business problems (inventory ordering, labor scheduling, working capital, etc.).
  60. 60Free Cash Flow Valuation - Basic Spreadsheet Valuation Model
  61. 61Finance Examples - Seven examples in Business Finance - Solver
  62. 62Capital Budgeting Workbook - Several examples of capital budgeting analysis, including the use of Solver to select optimal projects.
  63. 63Present 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.
  64. 64 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
  65. 65Cash Flow Sensitivity (xlt) - Sensitivity analysis spreadsheet - Small Business Store
  66. 66What If Analysis - Set of templates for sensitivity analysis using financial inputs.
  67. 67Risk Return Optimization - Optimal project selection (must enable macro's) - Metin Kilic
  68. 68 CI - Basics #1 - Basic spreadsheet illustrating competitive analysis - Business Tools Templates.
  69. 69 CI - Basics #2 - Basic spreadsheet illustrating competitive analysis - Business Tools Templates.
  70. 70 External Assessment - Assessment questions for organizational assessment (must enable macros).
  71. 71 Internal Assessment - Assessment questions for organizational assessment (must enable macros).
  72. 72 Formal Scorecard - Formal Balanced Scorecard Spreadsheet Model (3.65 MB / must enable macros).
  73. 73Project Plan - Project Scheduling Template currently setup for a Balanced Scorecard Project.
  74. 74Gantt Chart - Gantt chart for project management with work plan - Jim Chapman's Web Site | Simplified Version - Barnard of Fong's Eng & Manf
  75. 75E O Q Model - Simple Inventory Models for calculating Economic Order Quantity.
  76. 76Inventory Simulation Control Model - Formal model for simulating inventory shortages, delivery times, costs, backorders, and optimal inventory levels - John McClain
  77. 77Financial 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.
  78. 78Option Trading Workbook - Educational toolkit for using Excel for Options - Option Trading Tips
  79. 79Financial Model - A nice clean financial model driven by different calculators (such as Company, Market, Subscribers, etc.) developed by Bill Snow.

Excel Spreadsheets - continued

  1. 80Forecasting Model - Step by step financial model for forecasting financials created by Sam Gui
  2. 81Economic Evaluation - Step by step workbook for evaluating the economics of a system investment
  3. 82Project Management Templates - A collection of templates (charter, budget, risk register, issues log, etc.) for managing a project - International Association of Project and Program Management
  4. 83Project Cost Estimating Workbook - A workbook model for developing a cost estimate on a software development project - ProTrain China
  5. 84Risk Assessment Register - A workbook for establishing a risk management register - Emergency Preparedness Capacity Builders
  6. 85Simple ABC Model - A simple model that illustrates Activity Based Costing
  7. 86Six Sigma Tool Kit - A large collection of templates for doing six sigma tasks
  8. 87Project Management Tool Kit - Collection of useful templates for managing projects - Michael D. Taylor
  9. 88Intellectual Property Valuation Model - A simple and easy to use model to help assign value to intellectual assets such as patents, copyrights and trademarks
  10. 89IT Infrastructure Maturity Assessment - Maturity model for evaluating different segments of IT infrastructure
  11. 90EVA Model - Template worksheets for calculating Economic Value Added (EVA) - Zachary Scott
  12. 91EVA Tree Model - Economic Value Added drill-down model with charts - Manfred Grotheer
  13. 92Personal Finance Model - A simple and clean model to track personal wealth - ROI Team
  14. 93Financial Startup Model - A six parameter model to help organize financials for startup companies - ROI Team
  15. 94Performance Leadership Assessment - Simple and straight-forward tool for assessing leadership across five important categories - People Positive
  16. 95Due Diligence Assessment Model - Assessment of new business ventures across ten different dimensions - Affiliate Tips
  17. 96Management Diamond Assessment - A useful tool for developing human capital and teams - Geir Fuglaas | Management Diamond Overview | Management Diamond Book
  18. 97Performance Solution Tool Kit - Evaluation of performance issues related to knowledge gaps
  19. 98Ratio Tree - A simple yet comprehensive tree of ratios for most businesses - Strategy Expert
  20. 99Skills & Modeling Guide | Assessment Exercise Workbook - Two very good spreadsheet models to help you develop your spreadsheet modeling skills - Tykoh Training
  21. 100Breakeven Forecasting Model - A clean and contemporary spreadsheet tool for easily forecasting breakeven. Includes parameters for seasonality and start-up optimization - Ethos 360
  22. 101ROI IT Initiative Tool - A comprehensive business case model for evaluating technology projects - Hall Consulting
  23. 102Waterfall Distribution Model - Distribution of proceeds from a business venture using hurdles - Global iConnect
  24. 103LBO DCF Model - Leveraged Buyout Model with tabs for financials and analysis - Global iConnect
  25. 104Weekly Cash Flow - Rolling cash flow projections of purchases - Portal CFO
  26. 105Factoring Cash Flow - Weekly calculation of cash flows with factoring - MP Star Financial Invoice Factoring
  27. 106 Series of Commission Spreadsheets > Calculator | Template-Fixed | Template-Margin | Template Revenue
  28. 107Dashboard Report - Demonstrates countif, vlookup, and arrays - Bob Lopez
  29. 108Real Estate Investment Analysis - Workbook example developed by Dr. Greg Smersh
  30. 109 Rental Property Investment - Workbook for evaluating rental property - Globaliconnect
  31. 110 Valuation Utility Workbook | User Manual - A nice and simple valuation model with sensitivity charts - Tykoh Training
  32. 111 Monte Carlo Sales Forecast - Provides an example of Monte Carlo Simulation using a simple sales forecast model - Business Templates
  33. 112 Depreciation Schedules - Calculates annual depreciation using a variety of methods - Business Templates
  34. 113 NPV Calculator - Shows examples that use the NPV, IRR, XNPV, and XIRR functions - Business Templates
  35. 114 Basic Excel Course - Collection of 4 Excel files from the Basic Excel course offered by DeZyre > All 4 Files (zip) | How to Concatenate | How to Use Lookup | How to Filter Data | Excel Module
  36. 115 Financial Modeling Course - 12 different excel files from the financial modeling course offered by DeZyre > Download All 12 Files (zip) | Advanced Income | Analyzing Dominos-1 | Analyzing Dominos-2 | Balance Sheet Basics | Building Cash Flow Statement | Capex | Double Entry Accounting | Expense Recognition | Revenue-Gross Margin | Revenue Recognition | Tax | Summary|
  37. 116 BPM Tool Kit - 6 different comprehensive models from Best Practice Modeling > All 6 Files (zip) | Enterprise Valuation Example | Equity Valuation Example | Historical Forecast Model | Whole Business Plan Model | Project Summary | Multi Stack Waterfall Chart
  38. 117 Box IPO Model - A complete financial model developed by Dheeraj Vaidya - Wall Street Mojo
  39. 118 Bidder Comparison Matrix - Weighted scoring of bid competition based on proposal criteria - MyPM
  40. 119 Bid No Bid Worksheet - Captures comparative data on risks, partners, customer and competition - MyPM
  41. 120 Win Theme Development - Captures data on customer, solutions, proof points and discriminators - MyPM
  42. 121 Proposal Compliance Matrix - Tracks RFP requirements and corresponding proposal sections - MyPM

General Resources

Business Functions | Business Intelligence | Business Spreadsheets | Convert to Web App | Data Conversion | Excel Applications | Excel Auditor | Excel Business Users | Excel Cheat Sheets | Excel Courses | Excel Development | Excel Web Conv | Excel Exposure | ExcelFix | Excel Formulas | Excel Ideas | Excel Materials | Excel Mixer | Excel Programming Services | Excel Quantitative | Excel Recovery Tool | Excel Solutions | Excel Support | Excel Tutorial | Excel Unusual | Financial Modeling School | Financial Model Training | Financial Model Training-2 | Finance Models | Improve Excel | Invest Excel | Investment Related | Magic Workbooks | Model Answer | Mr Excel | Online Help | Process Simulation | Projected Financials | Quantrix Modeling [Quantrix Sample Models] | Real Estate Related | Secure Spreadsheets | Spreadsheet Comparer | Spreadsheet Database | Spreadsheet Guys | Spreadsheet Security | Stock Analyzer | Teach Excel | XL Modeling

Excel Templates

| High Quality Templates | Project Management |

Excel Add On's

Able Bits | Addin Directory | Analyze It | Brush Tools | Business Rules | Custom Add Ins | Database Manager | Dashboards | Decision Analysis | Derivative Analysis | EZ Analyze | EZ Forecaster | FinCad-Derivatives | Free Economic Add On's | Free Navigation Tool Bar | Model Builder | Monte Carlo Simulation | Monte Carlo - Easy | Monte Carlo-Tukhi | NumXL | Portfolio Optimization | Risk Modeling | Sensitivity Toolkit | Simul-Stats | Spreadsheet ML | Statistical Analysis | Recover Corrupted Files | Tree Plan | Utilities | Value at Risk | XL Modeler | XL Sim | XL Stats |

Six Sigma Spreadsheets

ASQ Tools | John Zorich | SPC for Excel | SPC XL | Robert Dallman | Six Sigma Project Files

Financial Modeling

Chandoo | Corality | Modeling Championship | Plum Solutions | Pristine | Strategize
Online Lessons in Financial Modeling (includes lesson workbook):
Lesson 1 - Cash Flow Modeling
Lesson 2 - Financial Model Design
Lesson 3 - Excel Financial Functions

Books on Excel

Analyzing Business Data | Balanced Scorecards in Excel | Business Analysis | Data Analysis | Excel Hacks | Financial Analysis | Financial Modeling | Finance with Excel | Managing Money | Spreadsheet Modeling |