Free Excel Spreadsheets
Note: All spreadsheets are made by financial experts, if you want to Download then click on
“bold” like symbol and you will gwt your desired tool. 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 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. 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 SLG Ratio Master (exe) - Excel workbook for creating 25 key performance ratios. 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. Ratio Reminder (zip) - Simple worksheet of comparative financials and corresponding ratios Excel Workbook 1-2 - Set of worksheets for evaluating financial performance and forecasting - Supplemental Material for Short Course 1 and 2 on this website. 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. 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 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 (30 Day Trial Model) from Business Spreadsheets | Additional Trial Models from Business Spreadsheets > Real Option Valuation | Portfolio Optimization | Optimal Hedging Strategy What If Analysis - Set of templates for sensitivity analysis using financial inputs. External Assessment - Assessment questions for organizational assessment (must enable macros). Internal Assessment - Assessment questions for organizational assessment (must enable macros). Project Plan - Project Scheduling Template currently setup for a Balanced Scorecard Project. E O Q Model - Simple Inventory Models for calculating Economic Order Quantity. 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. 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 - International Association of Project and Program Management 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 IT Infrastructure Maturity Assessment - Maturity model for evaluating different segments of IT infrastructure Master Budget Model - A multi-period multi-product budget model for a fictional bicycle manufacturing company - Jason Porter, PhD at University of Idaho and Teresa Stephenson, PhD at University of Wyoming.
Disclaimer: These all are copyrighted Materials dont further use for commercial need. And special thanks goes to www.exinfm.com.