| Spreadsheet Name | Description | File(s) Included | Source(s) | Real-World Example(s) |
|---|---|---|---|---|
| Discounted Cash Flow (DCF) | Estimates stock value by discounting projected future cash flows to present value using a required rate of return. | Template | DCF Course, DCF Article | |
| Reverse DCF | Derives the implied growth rate or assumptions embedded in a stock’s current market price. | Template Example | DCF Course, Reverse DCF Article | Cloudflare (NET) |
| Discount Period Conventions | Adjusts cash flow timing (e.g., fiscal year-end, mid-year, stub periods) to refine present value accuracy. | Template | Mid-Year Conventions and Stub Periods Article | |
| Scenario and Sensitivity Analysis Models | Scenario analysis evaluates outcomes under different assumptions (e.g., best/worst case). Sensitivity analysis tests how changes to key variables (perpetual growth, discount rate, etc.) impact valuation. | Template Example | Scenario and Sensitivity Analysis Article | Coca-Cola (KO) |
Want access to ALL of StableBread's Excel models (including these DCF models) at a discount? Purchase our Premium Spreadsheet Models offer instead!
Note: If you have StableBread's DCF Course, these spreadsheets are included in the course.
