Các mô hình mẫu luôn là khởi đầu ý tưởng và là nguồn tham khảo quý giá để các bạn có thể tự xây dựng được mô hình cho riêng mình. Gửi tặng các bạn yêu thích các mô hình tài chính trong bảng tính Microsoft Excel. Tất cả mô hình đều miễn phí và có nguồn gốc từ địa chỉ này . Ngoài ra, trang web cũng chứa nhiều Add-on không thể thiếu dành cho sinh viên và người làm trong lĩnh vực tài chính khi phân tích dữ liệu tài chính.
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
Performance Solution Tool Kit – Evaluation of performance issues related to knowledge gaps
Dashboard Report – Demonstrates countif, vlookup, and arrays – Bob Lopez
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|
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