Các mô hình tài chính mẫu

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.

1Capital Budgeting Analysis (xls) – Basic program for doing capital budgeting analysis with inclusion of opportunity costs, working capital requirements, etc. – Aswath Damodaran

2Rating Calculation (xls) – Estimates a rating and cost of debt based on the coverage of debt by an organization – Aswath Damodaran

3LBO Valuation (xls) – Analyzes the value of equity in a leverage buyout (LBO) – Aswath Damodaran

4Synergy (xls) – Estimates the value of synergy in a merger and acquisition – Aswath Damodaran

5Valuation Models (xls) – Rough calculation for choosing the correct valuation model – Aswath Damodaran

6Risk Premium (xls) – Calculates the implied risk premium in a market. (uses macro’s) – Aswath Damodaran

7FCFE Valuation 1 (xls) – Free Cash Flow to Equity (FCFE) Valuation Model for organizations with stable growth rates – Aswath Damodaran

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

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

10FCFF Valuation 1 (xls) – Free Cash Flow to Firm (FCFF) Valuation Model for organizations with stable growth rates – Aswath Damodaran

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

12Time Value (xls) – Introduction to time value concepts, such as present value, internal rate of return, etc.

13Lease or Buy a Car (xls) – Basic spreadsheet for deciding to buy or lease a car.

14NPV & IRR (xls) – Explains Internal Rate of Return, compares projects, etc.

15Real Rates (xls) – Demonstrates inflation and real rates of return.

16Template (xls) – Template spreadsheet for project evaluation & capital budgeting.

17Free Cash Flow (xls) – Cash flow worksheets – subsidized and unsubsidized.

18Capital Structure (xls) – Spreadsheet for calculating optimal capital structures using different percents of debt.

19WACC (xls) – Calculation of Weighted Average Cost of Capital using beta’s for equity.

20Statements (xls) – Generate a set of financial statements using two input sheets – operational data and financial data.

21Bond Valuation (zip) – Calculates the value or price of a 25 year bond with semi-annual interest payments.

22Buyout (zip) – Analyzes the effects of combining two companies.

23Cash Flow Valuation (zip) – Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows.

24Financial Projections (zip) – Spreadsheet model for generating projected financials along with valuation based on WACC.

25Leverage (zip) – Shows the effects on Net Income from using debt (leverage).

26Ratio Calculator (zip) – Calculates a standard set of ratios based on input of financial data.

27Stock Value (zip) – Calculates expected return on stock and value based on no growth, growth, and variable growth.

28CFROI (xls) – Simplified Cash Flow Return on Investment Model.

29Financial Charting (zip) – Add on tool for Excel 97, consists of 6 files.

30Risk Analysis (exe) – Analysis and simulation add on for excel, self extracting exe file.

31Black Scholes Option Pricing (zip) – Excel add on for the pricing of options.

32Cash Flow Matrix – Basic cash flow model.

33 Business Financial Analysis Template for start-up businesses from Small Business Technology Center

34Forex (zip) – Foreign market exchange simulation for Excel

35Hamlin (zip) – Financial function add-on’s for Excel

36Tanly (zip) – Suite of technical analysis models for Excel

37Financial History Pivot Table – Microsoft Financials

38Income Statement What If Analysis

39Breakeven Analysis (zip) – Pricing and breakeven analysis for optimal pricing – Biz Pep.

40SLG Ratio Master (exe) – Excel workbook for creating 25 key performance ratios.

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

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

43Business Valuation Model (zip) – Set of tabbed worksheets for generating forecast / valuation outputs. Includes instruction sheet. Bizpep

44LBO Model – Excel model for leveraged buy-outs

45Comparable Companies – Excel valuation model comparing companies

46Combination Model – Excel valuation model for combining companies

47Balanced Scorecard – Set of templates for building a balanced scorecard.

48Cash Model – Template for calculating projected financials from CFO Connection

49Ratio Reminder (zip) – Simple worksheet of comparative financials and corresponding ratios

50Risk Analysis IT – Template for assessing risk of Information Technology – Audit Net

51Risk Analysis DW – Template for assessing risk of Data Warehousing – Audit Net

52Excel Workbook 1-2 – Set of worksheets for evaluating financial performance and forecasting – Supplemental Material for Short Course 1 and 2 on this website.

53Rule Maker Essentials – Excel Template for scoring a company by entering financial data – The Motley Fool

54Rule Maker Ranker – Excel Template for scoring a company by entering comparable data – The Motley Fool

55IPO Timeline – Excel program for Initial Public Offerings (must enable macros)

56Assessment Templates – Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.

57Cash Gap in Days – Spreadsheet for calculating number of days required for short-term financing.

58Cash Flow Template – Simple cash flow model with explanations of each cash flow component – Arkansas Small Business Development Center.

59Six Solver Workbook (zip) – Set of various spreadsheets for solving different business problems (inventory ordering, labor scheduling, working capital, etc.).

60Free Cash Flow Valuation – Basic Spreadsheet Valuation Model

61Finance Examples – Seven examples in Business Finance – Solver

62Capital Budgeting Workbook – Several examples of capital budgeting analysis, including the use of Solver to select optimal projects.

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 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

65Cash Flow Sensitivity (xlt) – Sensitivity analysis spreadsheet – Small Business Store

66What If Analysis – Set of templates for sensitivity analysis using financial inputs.

67Risk Return Optimization – Optimal project selection (must enable macro’s) – Metin Kilic

68 CI – Basics #1 – Basic spreadsheet illustrating competitive analysis – Business Tools Templates.

69 CI – Basics #2 – Basic spreadsheet illustrating competitive analysis – Business Tools Templates.

70 External Assessment – Assessment questions for organizational assessment (must enable macros).

71 Internal Assessment – Assessment questions for organizational assessment (must enable macros).

72 Formal Scorecard – Formal Balanced Scorecard Spreadsheet Model (3.65 MB / must enable macros) – Madison Area Quality Improvement Network.

73Project Plan – Project Scheduling Template currently setup for a Balanced Scorecard Project.

74Gantt Chart – Gantt chart for project management with work plan – Jim Chapman’s Web Site | Simplified Version – Barnard of Fong’s Eng & Manf

75E O Q Model – Simple Inventory Models for calculating Economic Order Quantity.

76Inventory Simulation Control Model – Formal model for simulating inventory shortages, delivery times, costs, backorders, and optimal inventory levels – John McClain

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.

78Option Trading Workbook – Educational toolkit for using Excel for Options – Option Trading Tips

79Financial Model – A nice clean financial model driven by different calculators (such as Company, Market, Subscribers, etc.) developed by Bill Snow.

80Forecasting Model – Step by step financial model for forecasting financials created by Sam Gui

81Economic Evaluation – Step by step workbook for evaluating the economics of a system investment

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

83Project Cost Estimating Workbook – A workbook model for developing a cost estimate on a software development project – ProTrain China

84Risk Assessment Register – A workbook for establishing a risk management register – Emergency Preparedness Capacity Builders

85Simple ABC Model – A simple model that illustrates Activity Based Costing

86Six Sigma Tool Kit – A large collection of templates for doing six sigma tasks

87Project Management Tool Kit – Collection of useful templates for managing projects – Michael D. Taylor

88Intellectual Property Valuation Model – A simple and easy to use model to help assign value to intellectual assets such as patents, copyrights and trademarks – My Patent

89IT Infrastructure Maturity Assessment – Maturity model for evaluating different segments of IT infrastructure

90EVA Model – Template worksheets for calculating Economic Value Added (EVA) – Zachary Scott

91EVA Tree Model – Economic Value Added drill-down model with charts – Manfred Grotheer

92Personal Finance Model – A simple and clean model to track personal wealth – ROI Team

93Financial Startup Model – A six parameter model to help organize financials for startup companies – ROI Team

94Performance Leadership Assessment – Simple and straight-forward tool for assessing leadership across five important categories – People Positive

95Due Diligence Assessment Model – Assessment of new business ventures across ten different dimensions – Affiliate Tips

96Management Diamond Assessment – A useful tool for developing human capital and teams – Geir Fuglaas | Management Diamond Overview | Management Diamond Book

97Performance Solution Tool Kit – Evaluation of performance issues related to knowledge gaps

98Ratio Tree – A simple yet comprehensive tree of ratios for most businesses – Strategy Expert

99Skills & Modeling Guide | Assessment Exercise Workbook – Two very good spreadsheet models to help you develop your spreadsheet modeling skills – Tykoh Training

100Breakeven Forecasting Model – A clean and contemporary spreadsheet tool for easily forecasting breakeven. Includes parameters for seasonality and start-up optimization – Ethos 360

101ROI IT Initiative Tool – A comprehensive business case model for evaluating technology projects – Hall Consulting

102Waterfall Distribution Model – Distribution of proceeds from a business venture using hurdles – Global iConnect

103LBO DCF Model – Leveraged Buyout Model with tabs for financials and analysis – Global iConnect

104Weekly Cash Flow – Rolling cash flow projections of purchases – Portal CFO

105Factoring Cash Flow – Weekly calculation of cash flows with factoring – MP Star Financial Invoice Factoring

106 Series of Commission Spreadsheets > Calculator | Template-Fixed | Template-Margin | TemplateRevenue

107Dashboard Report – Demonstrates countif, vlookup, and arrays – Bob Lopez

108Real Estate Investment Analysis – Workbook example developed by Dr. Greg Smersh

109Rental Property Investment – Workbook for evaluating rental property – Globaliconnect

110Valuation Utility Workbook | User Manual – A nice and simple valuation model with sensitivity charts – Tykoh Training

111Monte Carlo Sales Forecast – Provides an example of Monte Carlo Simulation using a simple sales forecast model – Business Templates

112Depreciation Schedules – Calculates annual depreciation using a variety of methods – Business Templates

113NPV Calculator – Shows examples that use the NPV, IRR, XNPV, and XIRR functions – Business Templates

114Basic 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

115Financial 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|

116BPM 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

117 Box IPO Model – A complete financial model developed by Dheeraj Vaidya – Wall Street Mojo

Chia sẻ bài này với bạn bè

Bình luận