Các mô hình phân tích tài chính và ứng dụng trong excel

23-01-2014 10:37 - Theo: vfpress.vn

Dưới đây là các mô hình và bảng tính excel mẫu (miễn phí, ngôn ngữ: tiếng Anh).

>> You can try to refresh the page by clicking
>> Want Cheap Stocks? Think Frontier Markets
>> Mời bạn nhập thông tin cá nhân theo mẫu bên dưới.
>> Hiển thị kết quả theo chủ đề

  1. (xls) – Basic program for doing capital budgeting analysis with inclusion of opportunity costs, working capital requirements, etc. –
  2. (xls) – Estimates a rating and cost of debt based on the coverage of debt by an organization –
  3. (xls) – Analyzes the value of equity in a leverage buyout (LBO) –
  4. (xls) – Estimates the value of synergy in a merger and acquisition –
  5. (xls) – Rough calculation for choosing the correct valuation model –
  6. (xls) – Calculates the implied risk premium in a market. (uses macro’s) –
  7. (xls) – Free Cash Flow to Equity (FCFE) Valuation Model for organizations with stable growth rates –
  8. (xls) – Free Cash Flow to Equity (FCFE) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth –
  9. (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 –
  10. (xls) – Free Cash Flow to Firm (FCFF) Valuation Model for organizations with stable growth rates –
  11. (xls) – Free Cash Flow to Firm (FCFF) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth –
  12. – Introduction to time value concepts, such as present value, internal rate of return, etc.
  13. – Basic spreadsheet for deciding to buy or lease a car.
  14. – Explains Internal Rate of Return, compares projects, etc.
  15. – Demonstrates inflation and real rates of return.
  16. – Template spreadsheet for project evaluation & capital budgeting.
  17. – Cash flow worksheets – subsidized and unsubsidized.
  18. – Spreadsheet for calculating optimal capital structures using different percents of debt.
  19. – Calculation of Weighted Average Cost of Capital using beta’s for equity.
  20. – Generate a set of financial statements using two input sheets – operational data and financial data.
  21. – Calculates the value or price of a 25 year bond with semi-annual interest payments.
  22. – Analyzes the effects of combining two companies.
  23. – Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows.
  24. – Spreadsheet model for generating projected financials along with valuation based on WACC.
  25. – Shows the effects on Net Income from using debt (leverage).
  26. – Calculates a standard set of ratios based on input of financial data.
  27. – Calculates expected return on stock and value based on no growth, growth, and variable growth.
  28. – Simplified Cash Flow Return on Investment Model.
  29. – Add on tool for Excel 97, consists of 6 files.
  30. – Analysis and simulation add on for excel, self extracting exe file.
  31. – Excel add on for the pricing of options.
  32. – Basic cash flow model.
  33. for start-up businesses from
  34. – Foreign market exchange simulation for Excel
  35. – Financial function add-on’s for Excel
  36. – Suite of technical analysis models for Excel
  37. – Microsoft Financials
  38. – Pricing and breakeven analysis for optimal pricing – .
  39. – Excel workbook for creating 25 key performance ratios.
  40. – Menu driven Excel program (must enable macros) for Discounted Cash Flow Analysis from the book Analysis for Financial Management by –
  41. – Menu driven Excel program (must enable macros) for Historical Financial Statements from the book Analysis for Financial Management by –
  42. – Set of tabbed worksheets for generating forecast / valuation outputs. Includes instruction sheet.
  43. – Excel model for leveraged buy-outs
  44. – Excel valuation model comparing companies
  45. – Excel valuation model for combining companies
  46. – Set of templates for building a balanced scorecard.
  47. – Template for calculating projected financials from
  48. – Simple worksheet of comparative financials and corresponding ratios
  49. – Template for assessing risk of Information Technology –
  50. – Template for assessing risk of Data Warehousing –
  51. – Set of worksheets for evaluating financial performance and forecasting – Supplemental Material for Short Course 1 and 2 on this website.
  52. – Excel Template for scoring a company by entering financial data –
  53. – Excel Template for scoring a company by entering comparable data –
  54. – Excel program for Initial Public Offerings (must enable macros)
  55. – Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.
  56. – Spreadsheet for calculating number of days required for short-term financing.
  57. – Simple cash flow model with explanations of each cash flow component – .
  58. – Set of various spreadsheets for solving different business problems (inventory ordering, labor scheduling, working capital, etc.).
  59. – Basic Spreadsheet Valuation Model
  60. – Seven examples in Business Finance –
  61. – Several examples of capital budgeting analysis, including the use of Solver to select optimal projects.
  62. – Set of present value tables written in rich text format, compatible with most word processors. Includes examples of how to use present value tables.
  63. – Valuation model of companies (30 Day Trial Model) from | Additional Trial Models from Business Spreadsheets > | |
  64. – Sensitivity analysis spreadsheet –
  65. – Set of templates for sensitivity analysis using financial inputs.
  66. – Optimal project selection (must enable macro’s) –
  67. – Basic spreadsheet illustrating competitive analysis – .
  68. – Basic spreadsheet illustrating competitive analysis – .
  69. – Assessment questions for organizational assessment (must enable macros).
  70. – Assessment questions for organizational assessment (must enable macros).
  71. – Formal Balanced Scorecard Spreadsheet Model (3.65 MB / must enable macros) – .
  72. – Project Scheduling Template currently setup for a Balanced Scorecard Project.
  73. – Gantt chart for project management with work plan – | – Barnard of
  74. – Simple Inventory Models for calculating Economic Order Quantity.
  75. – Formal model for simulating inventory shortages, delivery times, costs, backorders, and optimal inventory levels –
  76. – A comprehensive financial model for forecasting a complete set of financials with breakeven and valuation tabs developed by and at Leeds School of Business.
  77. – Educational toolkit for using Excel for Options –
  78. – A nice clean financial model driven by different calculators (such as Company, Market, Subscribers, etc.) developed by .
  79. – Step by step financial model for forecasting financials created by
  80. – Step by step workbook for evaluating the economics of a system investment
  81. – A collection of templates (charter, budget, risk register, issues log, etc.) for managing a project –
  82. – A workbook model for developing a cost estimate on a software development project –
  83. – A workbook for establishing a risk management register –
  84. – A simple model that illustrates Activity Based Costing
  85. – A large collection of templates for doing six sigma tasks
  86. – Collection of useful templates for managing projects –
  87. – A simple and easy to use model to help assign value to intellectual assets such as patents, copyrights and trademarks –
  88. – Maturity model for evaluating different segments of IT infrastructure
  89. – Template worksheets for calculating Economic Value Added (EVA) –
  90. l – Economic Value Added drill-down model with charts –
  91. – A simple and clean model to track personal wealth –
  92. – A six parameter model to help organize financials for startup companies –
  93. – Simple and straight-forward tool for assessing leadership across five important categories –
  94. – Assessment of new business ventures across ten different dimensions –
  95. – A useful tool for developing human capital and teams – | |
  96. – Evaluation of performance issues related to knowledge gaps –
  97. – A simple yet comprehensive tree of ratios for most businesses –
  98. | – Two very good spreadsheet models to help you develop your spreadsheet modeling skills –
  99. – A clean and contemporary spreadsheet tool for easily forecasting breakeven. Includes parameters for seasonality and start-up optimization –
  100. – A comprehensive business case model for evaluating technology projects –
  101. – Distribution of proceeds from a business venture using hurdles –
  102. – Leveraged Buyout Model with tabs for financials and analysis –
  103. – Rolling cash flow projections of purchases –
  104. – Weekly calculation of cash flows with factoring –
  105. Series of Commission Spreadsheets > | | |
  106. – Demonstrates countif, vlookup, and arrays – Bob Lopez
  107. – Workbook example developed by
  108. – Workbook for evaluating rental property –
  109. | – A nice and simple valuation model with sensitivity charts –
  110. – Provides an example of Monte Carlo Simulation using a simple sales forecast model –
  111. – Calculates annual depreciation using a variety of methods –
  112. – Shows examples that use the NPV, IRR, XNPV, and XIRR functions –
  113. Basic Excel Course – Collection of 4 Excel files from the Basic Excel course offered by > | | | |
  114. Financial Modeling Course – 12 different excel files from the financial modeling course offered by > | | | | | | | | | | | | |
  115. BPM Tool Kit – 6 different comprehensive models from > | | | | | |