The Simple Dollar. Digging Into Buffett's Numbers. Discounted Cash Flow (DCF)The concept of Discounted Cash Flow model valuation is straightforward: We discount all future cash flows the company will produce to the present day, add them up, and voila, we have our company valuation.
With that, I present The Discounted Cash Flow Equation! DCF = CF0 x SUM[(1 + g)/(1 + r)]n (for x = 0 to n) Free Excel Spreadsheets. Customized Templates | Financial Templates | High Quality Templates | Project Management | Able Bits | Addin Directory | Analyze It | Brush Tools | Business Rules | Custom Add Ins | Database Manager | Dashboards | Decision Analysis | Derivative Analysis | EZ Analyze | EZ Forecaster | FinCad-Derivatives | Free Economic Add On's | Free Navigation Tool Bar | Model Builder | Monte Carlo Simulation | Monte Carlo - Easy | Monte Carlo-Tukhi | NumXL | Portfolio Optimization | Risk Modeling | Sensitivity Toolkit | Simul-Stats | Spreadsheet ML | Statistical Analysis | Recover Corrupted Files | Tree Plan | Utilities | Value at Risk | XL Modeler | XL Sim | XL Stats | ASQ Tools | Baran-Systems | John Zorich | SPC for Excel | SPC XL | Robert Dallman | Six Sigma Project Files Analyzing Business Data | Balanced Scorecards in Excel | Best Practices | Business Analysis | Data Analysis | Excel Hacks | Financial Analysis | Financial Modeling | Finance with Excel | Managing Money | Spreadsheet Modeling |
Spreadsheet programs. Business Insider.