StableBread Logo

Overview

Model Configuration

Key model configurations are at the top of the OVERVIEW tab:

Overview: Model Configuration
OVERVIEW: Model Configuration
  • Stock Ticker: Must match Yahoo Finance ticker format. Updating this cell refreshes all model data.
  • Analysis Year: Controls the last fiscal year (FY) displayed across the model. "=LFY" shortcut references reflect this year.
    • Example: MSFT's last FY is 2025 → dropdown range is 2011–2025. Setting "2025" shows 2011–2025 data. Setting "2021" shows 2007–2021 data.
    • Best practice: Set to the most recent FY and verify after entering a new ticker, since FY-end dates vary by company.
  • Stock Prices: Controls how stock prices are retrieved across the workbook (except stock price charts).
    • FY (default, recommended): Retrieves prices as of the company's FY-end date (e.g., June 30th for MSFT).
    • CY: Retrieves prices as of December 31st.
  • Unit Selector: Changes how financial data is displayed across the model. Either billions (/1B), millions (/1M), or thousands (/1K).
  • Convert FX?: Toggle "Yes" to convert price currencies to reported currencies (if they differ). Ensures all price-based metrics are calculated in the same currency as the reported financials.
  • Risk-Free Rate: Input cell for the 10-year risk-free rate. Used in valuation models across the workbook.
  • Chart Theme: Switch between StableBread, Wall Street, or Modern themes (Professional/Developer users only). All charts across the workbook update automatically.
  • Comparables: Input up to 6 comparable stock tickers. Populates the COMPS DATA backend tab over the last 3 fiscal years and TTM. Data can be compared on the KFS and KFR tabs, and on select CHARTS tab visuals.
  • Stock Price Chart: Visualizes stock price performance over up to 15 years, showing cumulative percentage returns and CAGR. Select between 1M to MAX.

Key Financial Ratios (KFR) Summary

Summarized view of the KFR tab. Includes the most fundamental ratios, multiples, and metrics over the last two fiscal years and TTM.

Overview: Key Financial Ratios
OVERVIEW: Key Financial Ratios

Key Financial Statement (KFS) Summary

Summarized IS, BS, and CFS from the KFS tab with corresponding visuals. All charts are copied from the CHARTS tab—modifications there are reflected here.

CAGR Period and Common Size dropdowns are also available. CAGR Period calculates CAGRs for each line item over a selectable range (up to 10 years). Common Size expresses each line item as a percentage of a base metric (e.g., % of revenue for the IS).

Income Statement (IS) Summary

The income statement details a company's revenues, expenses, and profits over a specific period, providing insight into its profitability.

Overview: Income Statement
OVERVIEW: Income Statement

First chart: Revenue and costs combo stacked bar and line chart. Shows where the company incurs expenses to drive revenue and how profitability line items are trending.

Second chart: Five line charts showing growth of primary profitability measures and revenue. Useful for assessing profit efficiency and growth.

Balance Sheet (BS) Summary

The balance sheet provides a snapshot of a company's assets, liabilities, and shareholders' equity at a specific point in time.

Overview: Balance Sheet
OVERVIEW: Balance Sheet

Two treemap charts show composition of assets, liabilities, and equity. Useful for understanding financial structure.

Cash Flow Statement (CFS) Summary

The cash flow statement details cash inflows and outflows across operating, investing, and financing activities.

Overview: Cash Flow Statement
OVERVIEW: Cash Flow Statement

First chart: Overview of net operating, investing, and financing cash flows plus CapEx and FCF. Useful for analyzing cash flow trends and operational health.

Second chart: Historical breakdown of the company's cash position. Reflects how operating, investing, and financing activities impact liquidity over time.

chevron-downchevron-down-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram