Fixed blank cell formatting in some rows on the FCFF tab.
V4.0
Mar 20, 2026
NEW
CHARTS Tab: New dedicated charting tab with 36 pre-built charts and 14 custom chart slots.
VBA checkbox at the top to show/hide chart data tables. Tables control what's displayed on each chart (e.g., show/hide any line item on the income statement composition chart). Most chart titles update dynamically.
Sections: Financial Statements, Valuations, Returns & Quality, Capital Allocation, and Leverage & Liquidity.
For Professional/Developer users, a User-Defined Charts section lets you plot any KFS or KFR metric and toggle between bar and line chart. Two comparison charts let you plot up to three metrics across primary bar, primary line, and/or secondary line axes. Value formats update automatically via VBA (not static like traditional Excel tables/charts). Comparison charts also include a growth rate section with conditional format toggles.
Legend and formatting controlled via checkboxes on the left side of the tables, with custom VBA to show/hide legends. Some charts include additional dropdown/input options just above the respective chart.
DGA Tab: New dividend growth analysis tab. Based on the top section of the prior DDM tab. Designed to assess dividend growth more accurately for use on the DDM tab.
Includes DPR, ROE, ROE DuPont analysis, sustainable growth rate calculations (standard, buybacks only, buybacks less LTD), and an average + CAGR growth rate analysis section with conditional formatting.
REV Tab: New tab based on Stephen Penman's Financial Statement Analysis for Value Investing (2025). Breaks down what a stock is worth today vs. what the market expects for growth. Fully dynamic — evaluate implied growth across different scenarios based on current year, 1-year out, and 2-year out estimates.
COMPS DATA Tab: New backend tab (Developer users only). Pulls the same financial data as the KFS for all comparables across the last three fiscal years and TTM. Also includes Graham calculations for all comparables at the bottom.
OVERVIEW Tab:
Added comparables section. Input up to 6 stock tickers and compare them against the main ticker on the KFS, KFR, and CHARTS tabs.
Added chart theme option. Professional/Developer users can switch between StableBread, Wall Street, or Modern themes. All charts across the workbook update automatically.
KFS Tab:
Added comparables section. Tickers (up to 6) pulled from the OVERVIEW tab. Select any period from the last three fiscal years and TTM for comparison. "Show Comps" checkbox compares comps median or average (selectable via dropdown) and highlights the relevant period across the entire column. Additional checkboxes to show/hide conditional format pass/fail across main ticker data, range statistics, and comparables.
Added per-share metrics for each financial statement section with the ability to input custom share counts and select between basic, diluted, and user-defined.
Added NTM estimate inputs, which carry over to the KFR tab.
Added threshold pass/fail to every metric for quicker stock screening.
For Professional/Developer users, added VBA checkboxes to show/hide financials, common size, growth analysis, and per-share metrics. Also includes up to 15 years of data by default and quarterly data over the last 9 quarters.
KFR Tab:
Expanded from ~80 to ~135 ratios, multiples, and metrics with cleaner groupings.
Added Sloan accrual ratios (balance sheet and cash flow versions).
Added Y/Y sparkline charts to be consistent with KFS.
Added same comparables, threshold pass/fail, min/mean/median/max range, and checkbox features as the KFS tab. Supports up to 15 years, last 9 quarters, TTM, and NTM estimates.
GRAHAM Tab:
Added Graham Net-Net (NCAV and net-net working capital) and Graham Number with criteria checks. Both calculated over the same period as KFS/KFR. Price/NCAV, Price/NNWC, and Price/Graham Number pulled into the KFR tab under the "Price" section.
Added Graham Net-Net vs. stock price and Graham Number vs. stock price charts at the top.
UPDATES
COVER Tab: Revamped design and information with additional links, feature breakdown between Basic, Professional, and Developer versions. Re-added guide section with additional clarity and cell formatting rules.
OVERVIEW Tab: Completely redesigned.
Redesigned top section with more company information, cleaner layout, and easier navigation. Removed unnecessary data validation messages.
Stock price chart now uses a selectable chart period (1M to MAX) instead of typing months back. Shows exact beginning and end dates (end date based on analysis year) with cleaner date labels.
Company description capped at 550 characters. Removed auto-size fit macro (now fixed size).
Moved 10-year risk-free rate input to top of OVERVIEW (previously on VALUATION tab).
Moved football field valuation chart from the removed VALUATION tab and condensed it.
Updated key financial ratios section with the most useful/standardized metrics. More options available due to expanded KFR tab.
Financial statements remain with fewer years, more consolidation, and an option to view CAGR over any period over the last 10 years plus common size. IS composition and growth charts now side by side. BS features only composition treemap charts for total assets and total liabilities & SE. CFS charts remain with an improved change in cash flow chart. All can be modified via the CHARTS tab.
Removed radar chart (manual, not particularly useful), valuation ratios comparison chart, buy price range vs. stock price chart (football field chart is superior), dividend history chart (on CHARTS tab; dividend info already at top of OVERVIEW), and KFS/KFR metric comparison section (basic, data quality issues across metric types).
KFS Tab: Completely revamped.
IS, BS, and CFS tabs removed and consolidated into KFS. Supplementary data section removed; calculations now below each financial statement where most appropriate.
Growth analysis and common size now below their respective financial statement.
Quarterly stock price data shows exact prices instead of blanks.
Consolidated min, mean, median, max into a single customizable range with selectable beginning and ending periods (previously two ranges).
Tweaked short names for clarity.
KFR Tab:
Improved red/green/black conditional formatting for companies with less than 10 years of history. Significantly fewer separate rules.
Moved Piotroski F-Score, Altman Z-Score, and Beneish M-Score from the removed QUALITY tab. Components viewable via collapsible rows.
OE Tab: Simplified to one main OE formula (CFO − maintenance CapEx).
Streamlined the 6 maintenance CapEx methods to be more accessible and less complex.
Final OE number selectable across any of the last three fiscal years and any of the 6 methods.
FCFF Tab:
Forecast drivers no longer restricted to dropdown options from the reference key (now standard input cells).
Forecast methods moved out of assumptions section for more logical usability.
DCF Tab: EMM section now ignores terminal year format if OE or diluted EPS is selected as forecast method (EMM relies on FCFF forecast, so this should have been there before).
DDM Tab:
Restructured GGM, Two-Stage DDM, and H-Model chart and table layouts.
Removed margin of safety vs. stable growth rate tables (not particularly useful; reduced performance when saving/recalculating).
Calculations now handle complex situations (e.g., negative to positive growth for Three-Stage DDM).
GRAHAM Tab: Completely revamped.
Removed original vs. revised formulas (did not differ materially). New version displays the formula with input cells for nearly all variables.
Replaced basic sensitivity table with a proper Excel sensitivity table comparing growth to AAA corporate bond yield.
WACC Tab: Universal changes applied.
COMPS Tab: Universal changes applied.
BACKEND Tab: Completely revamped for accessibility, developer-friendliness, easier navigation, and quicker future development. Stock price fetching significantly more precise.
Named Ranges: Completely updated. Full list accessible by typing "=" in any input cell. Cleaned version without ranges or filler cells on the GUIDE documentation page.
Removed Tabs: VALUATION (football field chart moved to OVERVIEW), QUALITY (calculations moved to KFR), IS, BS, CFS (merged into KFS), MANAGEMENT, OWNERSHIP (manual, beyond Wisesheets scope), COMPARISON (replaced by comparables on OVERVIEW with comparison on KFS, KFR, and CHARTS).
Removed Google Sheets version. Available for download until end of month, then no longer supported. Cannot support the required functionality for V4.0, too slow, and adds development time.
Removed Save PDF macro (caused issues for Mac users). To replicate, File → Save As PDF. Pre-defined print guidelines set across workbook.
Universal changes (across workbook):
Improved formatting and spacing throughout.
Removed navigation panels and VBA buttons (clunky, hidden when groups shown/hidden, unnecessary with fewer tabs).
Charts follow a consistent theme, properly sized, with native header titles. Most start with the stock ticker name for picture export by Professional/Developer users.
Updated tab header format. Instead of just reported units (e.g., "USD in Millions, except per-share data"), each tab header now shows company name, exchange, ticker, last fiscal year date, reported units and unit selector, and FX conversion status.
Stock price now automatically currency-converted when FX convert is "Yes" on OVERVIEW. No need to manually select between stock price and currency-converted stock price.
Adjusted green/red/yellow conditional formatting for better contrast.
Sensitivity tables now use waterfall charts instead of line charts for clearer evaluation of variable impact.
Removed descriptions at top of valuation tabs (on StableBread and documentation pages; reduced clutter).
Significantly improved error handling.
FIXES
COMPS Tab: Fixed bug where users couldn't select the proper year for diluted/basic share counts in the historical implied valuation (defaulted to last fiscal year).