Free calculator
P/E ratio calculator
Compute price-to-earnings (P/E) on listed equity you model yourself: share price ÷ EPS in the same currency, or derive EPS from net income ÷ diluted shares and use the same line. We also show earnings yield (EPS ÷ price) as %. Not live quotes, not forward consensus feeds, not buy/sell advice—illustration only.
When to use this calculator
Quick valuation multiple check before you drop EPS and price into a comps or DCF workbook.
- Turn a headline EPS and last price you already pulled from a statement into P/E and earnings yield for a sanity check.
- Use net income and diluted shares when you have totals but not EPS yet—the tool shows implied EPS and the same P/E.
- Copy =price/EPS into Google Sheets or Excel next to a watchlist you maintain yourself.
- Open the dividend yield tool when you need cash dividend ÷ price, not earnings ÷ price.
We use the textbook equity multiple: P/E = price per share ÷ EPS, with EPS > 0 for the on-page snapshot. Earnings yield = EPS ÷ price × 100 (the percent mirror of 1 ÷ P/E when EPS is positive).
Direct path (price & EPS)
P/E = P ÷ EPS when both are finite, P > 0, and EPS > 0. If EPS is zero or negative, a positive P/E headline is misleading for beginners—this tool stops with an error instead.
Income path (implied EPS)
EPS = net income ÷ diluted shares (same period and currency as your income statement). Then P/E = P ÷ EPS as above. Algebraically this matches market cap ÷ net income when shares cancels: (P×shares) ÷ NI.
Earnings yield
Earnings yield % = EPS ÷ P × 100. Compare to dividend yield on the same price when you want payout vs earnings power—different denominators and stories.
What we do not model
Live quotes, consensus forward EPS, adjusted EPS rules per broker, negative EPS multiples, PEG, EV multiples, FX across listings, or sector medians—bring those inputs from your own research.
When you need a different lens than a single multiple, open: For annualized growth between two values over time, open the CAGR calculator. For dividend yield (cash ÷ price), use the dividend yield calculator. For P&L on one trade, use the stock calculator.
Google Sheets & Excel
English function names. Put price in P2 and EPS in E2 (same currency).
=P2/E2P/E is a ratio (times ×), not a percent—format as number if needed.
=NI2/SH2Replace NI2 with net income and SH2 with diluted shares; then =P2/ that cell for P/E.
More tools in Unit economics
Browse all toolsSlide 1 of 22
Frequently asked questions
What does this P/E ratio calculator do?
It computes P/E = price per share ÷ EPS and earnings yield % = EPS ÷ price × 100 for positive EPS you enter (or EPS implied from net income ÷ shares). No live market data.
What is the exact formula?
P/E = P ÷ EPS. Earnings yield (decimal) = EPS ÷ P; we show × 100 as %. With net income NI and shares S, EPS = NI ÷ S, then the same P ÷ EPS line.
Is this trailing P/E or forward P/E?
We do not choose for you—you supply the EPS (or NI and shares) that matches trailing, forward, or your adjustment. The math is the same once EPS is defined.
Why won’t it show P/E when EPS is zero or negative?
A positive P/E headline when EPS is ≤ 0 is easy to misread. For loss periods, analysts use other frames (EV/sales, price/book, etc.)—out of scope for this simple tool.
How is earnings yield related to P/E?
When EPS > 0, earnings yield ≈ 1 ÷ P/E (as a decimal); we show EPS ÷ price as %. It is not the same as dividend yield unless payout is 100%.
How do I match this in Google Sheets or Excel?
With price in P2 and EPS in E2: =P2/E2 for P/E (a times multiple). Earnings yield (decimal): =E2/P2; format as % if you prefer that view.
Is this for crypto or token “P/E” tools?
This page is framed for traditional EPS on common stock you type yourself. Crypto listings often lack comparable GAAP EPS—do not expect this layout to match every token screener.
Is this investment advice?
No. It is a free educational calculator; not a recommendation, not a research report, and not a substitute for a professional.