Income Statement
$
Total net income (common + preferred shareholders)
$
Dividends paid to preferred shareholders (subtracted first)
shares
Weighted average common shares outstanding
Dilutive Securities optional
shares
shares
shares
Optional
$
Basic EPS
Earnings per basic share outstanding
Diluted EPS
Dilution Impact
Earnings for Common
Total Diluted Shares
Total Dilutive Secs.
Dilution per Share
P/E Ratio (Diluted)
EPS Quality
Basic EPS vs Diluted EPS — Dilution Breakdown

What each tab calculates

01

Basic & Diluted EPS

Calculates Basic EPS as (Net Income − Preferred Dividends) ÷ Basic Shares, and Diluted EPS including all dilutive securities (options, convertibles, RSUs). Shows dilution impact %, earnings available to common shareholders, diluted share count, P/E ratio if a stock price is entered, and an EPS quality rating based on dilution severity.

02

EPS Growth Tracker

Tracks EPS across up to 5 periods with fully editable labels (FY2020, Q3 2024, etc.). Calculates CAGR from first to last valid period, period-over-period YoY growth rates, average annual growth, best and worst periods, total EPS growth, and a consistency score. Mixed chart shows EPS trend line with growth rate bars color-coded green/red.

03

EPS Forecast

Projects EPS up to 10 years using base EPS, annual net income growth rate, and optional share count change. Effective EPS CAGR compounds both earnings growth and share buyback or dilution effects. Year-by-year table shows forecast EPS, YoY growth, cumulative growth, and implied P/E. Bar chart visualizes the full trajectory.

04

EPS Valuation

Calculates fair value by multiplying EPS against four P/E benchmarks: your target P/E, sector average, market average (S&P 500 ≈ 22×), and the stock's historical P/E. With a current price, shows upside/downside to each estimate and a valuation signal from Undervalued to Significantly Overvalued. Bar chart shows all scenarios at once.

05

EPS Compare

Compares EPS and P/E across up to 5 companies. Enter Net Income in $M, optional preferred dividends, shares in millions, and optional stock price — EPS and P/E auto-calculate in real time. Summary shows highest-EPS company, average EPS, average P/E, and EPS spread. Ranked bar chart updates instantly as you type.