Expectations Investing Calculator

This tool recreates what the market must be assuming about the business to justify today’s price. To do that, it needs a clean snapshot from the latest 10-K + the latest 10-Q. Below is a field-by-field guide. When in doubt: use the most recent filing, stay consistent, and don’t mix companies’ reporting styles.

1. Market

Price per share

• What it is: The current stock price for one share.
• How the model uses it: Multiplied by diluted shares to get market cap, which is the starting point for the implied enterprise value.
• Where to find: Your broker, Google Finance, TradingView — anywhere with today’s quote.
• Tips: Use the class that matches your filings. For Google, for example, be consistent with GOOG vs GOOGL. If you model a specific date, use that day’s close.

Diluted shares

• What it is: Shares outstanding on a fully diluted basis — i.e. basic shares + dilutive RSUs/options.
• How the model uses it: price_per_share × diluted_shares = market_cap.
• Where to find: In the latest 10-Q/10-K, in the income statement section near “Earnings per share — diluted” or in the notes. Often labeled “Weighted-average shares used in computation of diluted net income per share.”
• Adjustments: Use the latest quarter’s diluted share count — it’s usually closer to reality than last year’s average.
• Blind spot: If the company is doing large buybacks or heavy SBC, this number moves — always update it.

Total debt

• What it is: Interest-bearing debt: short-term debt + current portion of long-term debt + long-term debt.
• How the model uses it: Added to market cap when computing enterprise value (EV).
• Where to find: Balance sheet, liabilities section, in 10-K/10-Q. Sometimes split into “short-term debt” and “long-term debt.” Sum them.
• Adjustments: Don’t include accounts payable or lease liabilities unless you deliberately want to. Keep it simple: interest-bearing debt.

Cash & equivalents

• What it is: Cash, cash equivalents, sometimes marketable securities.
• How the model uses it: Subtracted in EV: EV = market_cap + debt + minority – cash – non-operating.
• Where to find: Balance sheet, assets section, line “Cash and cash equivalents.” If they split “marketable securities,” you can leave them in “non-operating assets” instead.
• Tip: Be consistent: if you keep marketable securities out of cash, put them in “non-operating assets.”

Minority interest

• What it is: Noncontrolling interest — the part of consolidated subsidiaries not owned by the parent.
• How the model uses it: Added to EV, because EV should represent the value of the whole operating business.
• Where to find: Balance sheet, equity section: “Total stockholders’ equity” → line “Noncontrolling interests” or “Redeemable noncontrolling interest.”
• Tip: If it’s tiny, you can leave it 0 — the model accepts 0.

Non-operating assets

• What it is: Assets that are not part of the core operations: excess marketable securities, long-term investments, sometimes large stakes in other companies.
• How the model uses it: Subtracted in EV so we don’t ask operations to “earn back” non-operating stuff.
• Where to find: Balance sheet, assets section: “Marketable securities,” “Long-term investments,” “Equity investments.” You can group them here.
• Blind spot: If the company has a cash-like pile split over multiple lines, be sure not to double-subtract it (cash vs non-operating).

2. Business Snapshot (from filings)

This block reconstructs the baseline metrics depending on the chosen mode:

• 10-Q mode: We reconstruct TTM (trailing twelve months) using the standard formula: TTM = last annual (10-K) + current YTD (10-Q) – prior-year YTD (same 10-Q). This cancels seasonality.
• 10-K mode: We use the current annual figures directly from the latest 10-K, and compute observed annual growth by comparing them to the prior annual figures.

Last / Current annual revenue (10-K)

• What it is: Total revenues for the last full fiscal year. In 10-K mode, this is your current annual baseline.
• How the model uses it: First piece of the TTM revenue reconstruction (in 10-Q mode) or the base annual revenue (in 10-K mode).
• Where to find: 10-K, Consolidated Statements of Income (or Operations), top line “Revenue,” “Total revenues,” or “Net sales.”
• Tip: Use the same unit as the rest (whole dollars). Don’t copy a “$ in millions” line without multiplying.

Current YTD revenue (10-Q)

• What it is: Revenue from the beginning of the current year up to the latest quarter.
• How the model uses it: Added to the annual to “update” it.
• Where to find: Latest 10-Q, income statement. There are usually two columns: “Three months ended…” and “Nine months ended…” — take the YTD / “six/nine months ended” column.
• Tip: Make sure the period matches the “prior-year YTD revenue.”

Prior-year YTD revenue (same 10-Q)

• What it is: Revenue for the same period last year (the comparison column in the 10-Q).
• How the model uses it: Subtracted from the annual+current YTD to avoid double-counting last year’s months.
• Where to find: Same 10-Q, right next to the current YTD column.
• Blind spot: If the company changed fiscal year or reporting format, make sure the periods truly match.

Last / Current annual operating income (10-K)

• What it is: Operating income / income from operations / EBIT for the last full year. In 10-K mode, this is your current annual baseline.
• How the model uses it: First piece of the TTM EBIT calculation (in 10-Q mode) or the base annual EBIT (in 10-K mode).
• Where to find: 10-K income statement, usually just below gross profit and operating expenses.
• Note: Use operating income, not net income.

Current YTD operating income (10-Q)

• What it is: Operating income from the start of the year to the latest quarter.
• How the model uses it: Added to last annual to update it.
• Where to find: Latest 10-Q income statement, same column as YTD revenue.

Prior-year YTD operating income (same 10-Q)

• What it is: Last year’s YTD operating income for the same period.
• How the model uses it: Subtracted to avoid double-counting.
• Where to find: Right next to current YTD operating income.

Total shareholders’ equity (parent)

• What it is: Equity attributable to the parent company (not including noncontrolling interests).
• How the model uses it: Used to compute invested capital if you don’t override it: IC = debt + parent equity + minority – cash – non-operating
• Where to find: Balance sheet, equity section: “Total stockholders’ equity” or “Total equity attributable to Alphabet Inc.” etc.
• Adjustments: Don’t use “Total equity including NCI” — we add minority separately.

Effective tax rate

• What it is: The tax rate you want to apply to operating income to get NOPAT.
• How the model uses it: NOPAT = EBIT × (1 – tax_rate)
• Where to find: 10-K, “Provision for income taxes” note, or simply take the effective tax rate from the P&L.
• Tip: If the company had a weird tax year, use a normalized rate (e.g. 21–25% for US big tech).

3. Discounting

WACC

• What it is: Your discount rate.
• How the model uses it: Every yearly FCF and the terminal value are discounted at this rate.
• Where to find: You pick it. 8–10% is a typical range for large caps; you can also reuse what you use in other DCF models.
• Blind spot: Too low a WACC will make the model too forgiving and imply unrealistic operating paths.

Terminal growth

• What it is: Long-run growth rate after the forecast horizon.
• How the model uses it: Used in the Gordon formula for terminal value.
• Tip: Stay conservative (2–3% for USD), unless you model in inflation-heavy currencies.

Forecast horizon

• What it is: Number of explicit years the model projects.
• How the model uses it: Builds revenue, margins, ROIC, reinvestment year by year up to this year, then applies terminal value.
• Tip: 7–10 works best for “expectations investing,” because it gives the model time to fade growth.

4. Optional / Advanced

Override invested capital

• What it is: A manual IC number.
• How the model uses it: If you fill this, it replaces the computed IC. ROIC₀ is then based on your override.
• When to use: If the balance sheet is distorted (very big cash swings, big one-off items) and the computed IC becomes silly.

Target EBIT margin

• What it is: A margin you want the company to reach by the final forecast year.
• How the model uses it: If you set it, the model will not solve for margin — it will fade current margin to your target.
• When to leave blank: If you want the “pure expectations” version (solve for margin that makes price = value).

Reinvestment fade start year / Reinvestment floor

• What it is: A way to tell the model “start lowering reinvestment from year X towards Y% of the computed reinvestment.”
• How the model uses it: After the fade start year, it linearly reduces the reinvestment share down to the floor by the horizon.
• Why: Mature companies don’t keep reinvesting at early-year rates.

Terminal ROIC (optional)

• What it is: The ROIC you want the business to have in the terminal year.
• How the model uses it: If set, the ROIC path is faded from current ROIC to this number. If not set, model uses rule: max(WACC + 0.02, 0.10).
• Tip: Use this if you think the business will stay above-average in the steady state.

Min reinvestment as % of NOPAT

• What it is: A floor so that reinvestment can’t drop below e.g. 25% of NOPAT.
• How the model uses it: Each year it checks the “theoretical” reinvestment from growth/ROIC and then applies the floor. If the floor is higher, that year gets “floored.”
• Why: This avoids unrealistically high free cash flow in years where growth is still high.

5. Scenario

Scenario = observed

• What it is: “Just take what the latest 10-Q shows as growth and fade it.”
• How the model uses it: It reads your observed growth from the revenue inputs and then applies your high-growth window.

High-growth years

• What it is: “Keep the filing growth for this many years.”
• How the model uses it: For those early years, revenue grows at observed × decay. After that, it fades to terminal growth.
• Tip: 3–5 is a reasonable range for big mature names; 0 means “fade immediately.”

High-growth decay

• What it is: A multiplier for the observed growth (e.g. 0.8 trims the Q growth a bit).
• How the model uses it: Year 1 growth = observed × decay.
• When to use: When the last quarter was unusually strong and you want to “cool it down.”

Scenario = CAGR

• What it is: You tell the model “assume 9% every year” instead of using the observed growth.
• How the model uses it: It just applies that rate for all projection years.

Scenario = custom

• What it is: You fill Year 1 growth, Year 2 growth, … up to 10.
• How the model uses it: Each year uses your number; blanks fall back to the terminal growth.
• Tip: This is the best for “I want 20, 18, 15, 12, 10, 8, 6, 5, 4, 3.”

---

That’s it. If you fill these from the latest 10-K + latest 10-Q, the page will reconstruct the same numbers you see in “Derived values,” so you can audit every step and compare companies on the same footing.