| Spreadsheet Name | Description | File(s) Included | Source(s) | Real-World Example(s) |
|---|---|---|---|---|
| Weighted Average Cost of Capital (WACC) | Blended cost of equity, preferred stock, and debt used to discount cash flows. | Template Example | DCF Course, WACC Article | Costco (COST) |
| Cost of Debt Methods | Calculates debt cost using methods like yield-to-maturity (YTM), weighted YTM, weighted current yield, debt ratings, synthetic ratings, or interest expense divided by total debt. | Template Example | DCF Course, Cost of Debt Article | Costco (COST) |
| Cost of Preferred Stock | Calculates cost by dividing preferred dividend per share by current price, or using weighted averages for multiple preferred series. | Template Example | DCF Course, Cost of Preferred Stock Article | AT&T (T) |
| Capital Asset Pricing Model (CAPM) | Estimates required equity return as risk-free rate + (beta × equity risk premium). | Example | DCF Course, CAPM Article | Home Depot (HD) |
| Implied Equity Risk Premium (ERP) Model | Market’s expected equity return over risk-free rate, per Aswath Damodaran’s methodology. | Template | DCF Course | |
| Company Exposure to Country-Specific Risk | Adjusts equity risk premium for stocks in non-developed markets based on country risk. | Example | DCF Course | |
| Bottom-Up Beta | Estimates beta using peer company betas and leverage, adjusted for the target firm’s capital structure. | Template Example | DCF Course | Chipotle Mexican Grill (CMG) |
| Fama-French and Carhart Multifactor Models | Multi-factor models adding size, value, momentum (Carhart) to explain stock returns. | Example | Fama-French and Carhart Multifactor Models Article | Home Depot (HD) |
| Single Index Model (SIM) | Relates stock returns to market returns (beta) to estimate risk and expected returns. | Example | SIM Article | Home Depot (HD) |
| Portfolio Beta Calculation | Derives beta by regressing portfolio returns against market returns over time. | Example | Beta Article | Microsoft (MSFT), Apple (AAPL), Johnson & Johnson (JNJ) |
| Beta Regression Examples | Calculates beta by regressing stock returns against market returns over a historical period. | Example | DCF Course, Beta Article | Microsoft (MSFT), Chipotle Mexican Grill (CMG) |
Want access to ALL of StableBread's Excel models (including these capital structure & risk 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.
