Subhuday

Data Modeling
Home
Metaphysics
Numerology
Quary From SUBHASH
Create Ur Love Story
About Us
Favorite Links
Bonus Act
Gratuity Act
Contact Us
Data Modeling
EPF Act
Picture Gallery
Kavita
Taxation

Here You Can Learn Data Modeling In EXCEL

www.exinfm.com/free_spreadsheets.html

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

Note: Most of the spreadsheets on this web page are from different sources. Where possible, a link has been provided back to the source. If you have questions, please contact the source. Only four spreadsheets were created by Matt H. Evans (No's 48, 54, 58, 64).
Top Five - Five most popular files downloaded from this web page.

General Resources on Microsoft Excel

Agilecor | Analysis Tools | Business Functions | Business Intelligence | Cash Flow Workbooks | CEO Tools | Decision Trees | Excel Ad-Ins | Excel Applications | Excel Automation-Integration | Excel Business Users | Excel Development | Excel Everywhere | Excel Links | Excel Materials | Excel Presentations | Excel Interactive Presentations | Excel Recovery | Excel Solutions | ExcelWriter | FinCalc | Financial Metrics | Finance Formulas | Finance Package | Formulas & Functions | Investment Related | Magic Workbooks | Master Excel | McGraw Hill Course | Model Advisor | Mr Excel | MyWorkTools | Option Models | Process Simulation | Quantitative Methods| Quantrix Modeling [Quantrix Sample Models] | Real Estate Related | Risk Related | Spreadsheet Comparer | Spreadsheet Page | Spreadsheet Tester | Stock Analyzer | Web Based Spreadsheet

Excel Templates

Basic Business Templates | Business Templates | CFM Templates | Excel Templates | Finance Templates | KMT Templates | Microsoft Templates | Office Templates | Process Improvement Templates | Project Management |

Add On's for Microsoft Excel

Addin Directory | Analyze It | Business Rules | CashFlow Wizard | Custom Add Ins | Derivative Analysis | EZ Forecaster | FinCad-Derivatives | Insight XLA | Monte Carlo Simulation | Recover Corrupted Files | Tree Plan | Vega Excel | Web Service Integration with Excel

Six Sigma Spreadsheets

Baran-Systems | Business Statistics | Dan Feliciano | SPC for Excel | SPC XL | Stephen Sawin | Robert Dallman | Robust Systems Strategy | Thomas Little | University of Michigan |

Leading Experts on Microsoft Excel

Bill Jelen | Dick Kusleika | David McRitchie | Jon Pearson | Jon Peltier | Andy Pope | John Walkenbach | Allen Wyatt

Books on Microsoft Excel

Analyzing Business Data | Best Practices | Business Analysis | Data Analysis | Excel Hacks | Financial Analysis | Financial Modeling | Managing Data | Managing Money | Modeling Textbook | Spreadsheet Modeling | Advanced Reporting