Documentation: Released a new and updated written documentation, complete with updated copy, links, images, tables, and more. Removed videos (outdated and not necessary).
Updated documentation, support, changelog, roadmap, and article links in the models.
Removed "AutoFitAll" macro (clunky).
Updated "SavePDF" macro to support Mac Excel.
FIXES
Fixed stock price change and CAGR calculation on OVERVIEW tab.
Fixed market capitalization name on COMPS for market data.
V3.1
Feb 13, 2025
NEW/UPDATES
None
FIXES
KFS & KFR Tab:
Market cap and enterprise value now have options to select between (1) being calculated based on financial statement and market data, (2) or via Wisesheets (the default and recommended option for accuracy).
Included 'short-term investments' in enterprise value and net debt calculation on KFS tab.
Updated KFR formulas to reflect updated naming conventions on KFS tab for market cap and enterprise value.
Fixed stock chart not loading on some occasions, for the Excel version.
V3.0
Jan 31, 2025
NEW/UPDATES
DCF Tab:
Added conditional format rule to hide "discount rate vs. perpetual growth rate" sensitivity analysis table if "EMM" is selected.
DDM Tab:
Fixed incorrect conditional formatting for sensitivity analysis tables.
Updated data validation copy for stable growth rates.
BUFFETT OE:
Moved Final Buffett OE selection to top of page.
Added error checking to formulas.
Improved table formatting.
FIXES
DCF Tab:
Fixed sensitivity analysis tables not working for some users.
Improved error formats.
GRAHAM: Fixed current AAA corporate bond yield format.
V2.9
Jan 14, 2025
NEW/UPDATES
DCF Tab: Completely revamped the DCF model to be more accurate, flexible, and informative.
DCF now supports diluted EPS as a forecasting method.
Moved TV to model tab top, removed second EMM method (which was arbitrary), and consolidated no-growth and perpetual growth methods into a single TV calculation. Additionally:
For EMM:
Terminal year metrics offered are Revenue, EBITDA, EBIT, and FCFF. These automatically pull from the FCFF tab.
Added implied PGR calculations for conservative, base, and optimistic case scenarios to cross-check with PGM. Compatible with mid-year convention.
For PGM:
Updated PGM warnings format and criteria (aligned with VALUATION tab changes).
Added implied exit multiple calculations for conservative, base, and optimistic case scenarios to cross-check with EMM. Compatible with mid-year convention.
Consolidated market value vs. intrinsic value/buy price waterfall charts into a single dynamic chart. Users can toggle between intrinsic values and buy prices.
Improved DCF model descriptions, formula, labels, and conditional formatting for better clarity.
Updated sensitivity table formatting.
Removed redundant intrinsic value vs. buy price chart below DCF Outputs.
Added dynamic discounted future cash flows chart that automatically hides missing years.
DDM Tab:
Consolidated market value vs. intrinsic value/buy price waterfall charts into a single dynamic chart, matching DCF tab functionality.
Updated DDM warnings format and criteria across all dividend discount model approaches (aligned with VALUATION tab changes).
Updated sensitivity table formatting.
FCFF Tab:
Removed unnecessary year 11 forecast for FCFF.
WACC Tab: Improved accessibility and flexibility.
Removed debt rating approach (not doable for most retail investors).
For CAPM:
Removed unlevered/levered beta calculations (these were only applicable for bottom-up calculations from multiple companies, which the previous version didn't support).
Added input options for country-specific risk premium (CSRP), size-risk premium (SRP), and company-specific risk premium (CORP) in the modified CAPM.
Beta now offers two options: (1) Wisesheets beta or (2) Manual input cell for bottom-up beta estimate (more accurate). Includes Damodaran's U.S. sector betas dataset.
Improved formatting, updated groupings, added clear total cost + weight section for WACC calculation.
IS, BS, CFS Tabs: Added quarterly financials.
Added quarterly financials over the last 5 quarters.
Replaced N/A, A, P labels with actual fiscal year or quarterly dates. Shows "N/A" only when date is unavailable (either hasn't occurred or doesn't exist for the company).
Enhanced horizontal analysis format with quarterly calculations.
Limited sparkline charts to annual financials only.
KFS Tab:
Added quarterly financials with all relevant supplementary calculations and a new chart visual.
Added min, mean, median, max columns with dynamic date ranges (matching KFR tab).
Relocated charts and period-over-period growth analysis to tab top for better visibility.
KFR Tab:
Added quarterly financials with complete ratio calculations, as well as a new chart visual.
Moved charts and period-over-period growth analysis to tab top, like the KFS tab.
Updated conditional formatting rules for ratios. Now, there's significantly fewer separate rules.
Added red font warning for invalid Pass/Fail inputs based on ratio performance criteria.
VALUATION Tab:
Removed unnecessary input cells (3mo, LT risk-free rate, inflation rates, savings rate, U.S. GDP growth rate). Retained risk-free rate input.
Relocated corporate bond yield to GRAHAM tab where it's used.
OVERVIEW Tab:
Removed redundant CAGR growth section (covered by existing growth calculations and visuals, plus incompatible with sub-10-year datasets).
Slightly modified dividend chart.
Analysis years now use available date-based minimums instead of fixed 10-year lookback.
Updated and added links across workbook.
Updated default date range to 2019-2024. Set 2024 as default analysis year.
Renamed "Date of Analysis" to "Valuation Date."
Removed unnecessary notes cells from valuation models.
Refined currency label formatting across workbook.
Updated COVER tab format and disclaimer.
Updated default print guidelines.
Standardized multiples formatting.
Removed unreliable STOCKHISTORY/GOOGLEFINANCE options for stock chart.