Finance tools

P/E ratio calculator

Use this P/E ratio calculator to divide share price by earnings per share (EPS) —the classic price to earnings multiple. See earnings yield, estimate fair value with a target P/E, or solve for whichever input is missing. Presets and a live formula update as you type; export CSV or PDF when you are done. You enter figures from your broker or SEC filings—we do not look up tickers for you. Not the profit margin tool (earnings ÷ revenue) or the margin of safety tool (price vs your value estimate). For learning only—not investment advice.

What is the price-to-earnings ratio?

  • Calculate P/E live

  • Fair value from target P/E

  • Solve missing variable

  • CSV/PDF export

P/E ratio formula

Price to earnings formula

P/E ratio calculator example

ScenarioInputsResult
Classic P/EPrice $25, EPS $1.80P/E ≈ 13.89× · yield ≈ 7.2%
High multiplePrice $200, EPS $5P/E = 40× · yield = 2.5%
Fair valueEPS $5, target P/E 20×Fair value $100/share
Premium vs fairFair $100, price $120≈ 20% above fair value
Loss-makingPrice $10, EPS −$2P/E undefined (negative EPS)

How to calculate P/E ratio

  1. Enter share price and EPS

    Use the current market price and TTM diluted EPS per share from your broker, Yahoo Finance, or SEC EDGAR (10-Q/10-K).

  2. Read P/E and earnings yield

    Calculate P/E mode shows the multiple and earnings yield as you type — no submit button.

  3. Optional fair value or solve

    Fair value mode multiplies EPS by a target P/E. Solve mode finds the missing price, EPS, or P/E when you know the other two.

Where to find EPS for P/E

Trailing vs forward P/E

What is a good P/E ratio?

ContextHow investors use P/E
Same-sector peersCompare trailing P/E to a median — outliers deserve a story
Company’s own 5–10 year rangeSee if today’s multiple is high vs its history
Earnings growthFaster growth often supports a higher multiple
Interest rates / bond yieldsHigher yields can pressure equity multiples
Loss-making yearsP/E undefined — use sales, cash flow, or book value

When P/E breaks down

P/E ratio in Excel and Google Sheets

GoalCells (example)Formula
P/E multipleA1 = price, A2 = EPS=A1/A2
Earnings yield %A1 = price, A2 = EPS=(A2/A1)*100
Fair valueB1 = EPS, B2 = target P/E=B1*B2
Premium vs fairC1 = price, C2 = fair value=(C1-C2)/C2

Discover more calculators for time tracking, payroll, and HR.

Frequently asked questions about this P/E ratio calculator

How is the P/E ratio calculated?

Divide share price by earnings per share (EPS): P/E = price ÷ EPS. In this tool, choose Calculate P/E, enter both numbers, and the multiple updates instantly. Example: $25 and $1.80 EPS ≈ 13.89×.

What is a good P/E ratio?

There is no one-size-fits-all answer. Compare the stock to peers in the same industry and to its own history. The S&P 500 has often traded near mid-teens to low-20s trailing P/E over long periods, but your company’s growth and risk matter more than the index alone.

What is a fair price-to-earnings ratio?

“Fair” here means EPS × a target P/E you choose, not a market guarantee. Pick a multiple grounded in sector medians or past trading ranges, then use Fair value mode to see the implied price per share.

Is a P/E of 40 good?

It can be, if earnings are expected to grow fast enough to justify the price. On a mature, slow-growing business, 40× is usually rich. Always read P/E next to growth, margins, and debt—not in isolation.

What did Warren Buffett say about the P/E ratio?

Buffett warns against buying on low P/E alone. He looks for understandable businesses, durable earnings, and a margin of safety on price—not just the cheapest multiple on a screen. Owner earnings and intrinsic value matter more than a single ratio.

What does a negative P/E ratio mean?

It usually means negative EPS (a loss), so price ÷ EPS is not meaningful. Screens may show “N/A.” Use sales, cash flow, or book-value metrics instead; this calculator explains when EPS is zero or below.

What is trailing vs forward P/E?

Trailing P/E uses reported EPS from the last four quarters (TTM). Forward P/E uses an estimate for next year’s EPS. Type either figure into the EPS field—we do not download consensus forecasts.

What is earnings yield?

Earnings yield is EPS ÷ price, the same as 1 ÷ P/E shown as a percent. A 20× P/E equals roughly a 5% earnings yield, which some investors compare to bond yields. It appears below your P/E result here.

How do I calculate P/E in Excel?

With price in A1 and EPS in A2, use =A1/A2. Fair value: =B1*B2 when B1 is EPS and B2 is your target P/E. You can also export CSV from this page and open it in Sheets.

How do you calculate P/E from a balance sheet?

Get diluted EPS from the income statement (or compute net income ÷ diluted shares). P/E is then share price ÷ EPS. The balance sheet helps you judge debt and cash for other ratios, but those lines are not in the basic P/E formula.

Is a high or low P/E ratio better?

Neither is automatically better. A low P/E might flag a bargain or a company in trouble. A high P/E might reflect strong growth expectations or an overheated price. Compare peers, growth, and cash flows before you decide.

How is P/E different from profit margin?

Profit margin is profit divided by revenue (a percentage on the income statement). P/E is share price divided by EPS (a market valuation multiple). Try our profit margin calculator for margin math.

How is P/E different from margin of safety?

P/E is a quick price-to-earnings multiple. Margin of safety measures how far market price sits below your intrinsic value estimate. Fair value from a target P/E is not the same as a Graham-style margin of safety—use our margin of safety calculator for that step.

Can I use this as a stock price to earnings ratio calculator?

Yes. Enter the stock’s current price and TTM diluted EPS (or your own forward EPS). It works for any listed share where you have both inputs. We do not look up symbols or live quotes for you.

Can I find fair value from a P/E ratio?

Yes. Open Fair value mode, enter EPS and a target P/E, and you get fair value per share. Add an optional current price to see whether the stock trades at a premium or discount to that anchor.

What is the P/E ratio formula?

P/E = market price per share ÷ earnings per share, typically trailing twelve-month diluted EPS from SEC filings. Rearranged: fair value ≈ EPS × target P/E; earnings yield ≈ EPS ÷ price.

Is this P/E calculator free?

Yes. Live calculations, presets, and CSV/PDF export are free. No account is required, and your inputs are processed in your browser—they are not sent to our servers.

Does this tool look up live stock prices?

No. Copy price and EPS from your broker, a data terminal, or SEC EDGAR. That keeps the math transparent and avoids relying on a ticker API.

How do I solve for missing price, EPS, or P/E?

Select Solve missing, then fill in any two of share price, EPS, and P/E. The calculator solves for the third field automatically.

Is this investment advice?

No. This page is for learning and scenario math only, not recommendations to buy or sell. For definitions, see Investor.gov on the P/E ratio.

How does P/E relate to intrinsic value?

P/E summarizes price versus one year of earnings. Intrinsic value models future cash flows, growth, and risk. You can compare implied P/E at your fair value using our intrinsic value calculator.

Can I export my P/E calculation?

Yes. Use Export CSV or Export PDF to save inputs, P/E, earnings yield, fair-value fields (if used), and the standard finance disclaimer.