Kostenloser Rechner
Aktien-Gewinn-Rechner
Estimate profit or loss on one round-trip stock trade: how many shares you bought, price per share at purchase and sale, and optional flat commissions on the buy and sell sides. We show total cost, net proceeds, net P&L, and return on invested capital as a percent. This is not live market data, not a DCA / average-cost tool for many lots in v1, and not the same as the ROI calculator that only takes two totals—see methodology for when to use each.
When to use this calculator
Quick what-if on a single buy and sell before you build a full position model in Sheets or Excel.
- Translate shares, prices, and fees into net P&L and a headline ROI % on cash you actually put in.
- Compare fee sensitivity by nudging the commission fields while holding prices constant.
- Copy the ratio pattern into a workbook row when you want spreadsheet parity with this page’s definitions.
- Jump to the ROI calculator when you already know total invested and total returned without per-share detail.
We model one cash equity round-trip: you type shares, per-share buy and sell prices, and optional flat commissions on each side. Currency is yours to keep consistent—we never convert FX.
Total cost (what you put in)
Buy subtotal = shares × buy price per share. Total cost = buy subtotal + buy commission. This is the cash tied up before the sale (commissions included).
Net proceeds and net P&L
Sell subtotal = shares × sell price per share. Net proceeds = sell subtotal − sell commission. Net P&L = net proceeds − total cost (negative means a loss).
ROI % on invested capital
ROI % = (net P&L ÷ total cost) × 100 when total cost is greater than zero. This matches treating commissions as part of your all-in buy and sell economics for this illustration.
What we do not model
Live prices, dividends, DRIP, multiple tax lots, average cost across buys (see FAQ), short stock, options, currency conversion, and issuer-specific fee schedules—use a full ledger or broker statement when you need those layers.
For two totals without per-share detail, the ROI page may be faster; for capital-gains framing (U.S. federal illustration), see the dedicated tool—still not tax advice. For invested vs returned without share rows, open the ROI calculator. For annualized growth between two values over time, see the CAGR calculator. To convert amounts between currencies first, use the currency converter (reference rates)—then type one currency throughout here.
Google Sheets & Excel
English US/UK function names below. Replace N, Pb, Ps, Fb, Fs with cells for shares, buy price, sell price, buy fee, sell fee.
=N*(Ps-Pb)-Fb-FsAlgebraically the same as net proceeds − total cost when proceeds = N×Ps − Fs and cost = N×Pb + Fb.
=D2/C2Format as Percent. C2 must be total cost (N×Pb + Fb) and D2 the net P&L line—see methodology.
Frequently asked questions
What does this stock calculator do?
It estimates profit or loss and ROI % on one round-trip trade from shares, buy and sell prices per share, and optional flat buy and sell commissions. It does not pull live market prices.
What formulas do you use?
Total cost = shares × buy price + buy commission. Net proceeds = shares × sell price − sell commission. Net P&L = net proceeds − total cost. ROI % = (net P&L ÷ total cost) × 100 when total cost is greater than zero.
Why flat commissions instead of per share?
Many broker statements show per-order fees; per-share fees are easy to add in a sheet (=Fb+N*feePerShare) if your story needs them. v1 keeps one currency fee line per side for clarity.
How is this different from the ROI calculator?
ROI here is still (gain ÷ cost), but cost and proceeds are built from shares × price ± commissions. The ROI calculator takes total invested and total returned directly—use it when you already have those two totals.
Can I average multiple purchases (DCA)?
Not in v1. For several buys at different prices, average cost per share = total shares purchased ÷ sum of (shares × price) costs (plus fees if you include them in basis). Build that in a sheet or watch for a future average-cost mode—this page stays one buy and one sell.
Does this include taxes or live stock prices?
No. Type your own prices. For a U.S. federal gain-line illustration (not the same as this page’s cash story), see the capital gains tax tool—still not tax preparation.
Rechnet ihr Abgeltungssteuer oder den Sparer-Pauschbetrag?
Nein. Diese Seite zeigt nur Gewinn/Verlust und Rendite % aus Preisen und Gebühren, die du eingibst—kein Steuerprogramm und kein Ersatz für Steuerberatung.
Est-ce le même calculateur que le profit sur Forex ou CFD ?
Non. Ici on parle d’actions au comptant avec prix par titre et frais forfaitaires—pas de pips, lots, levier ou marge comme sur les pages FX/CFD.
How do I match this in Google Sheets or Excel?
Use =N*(Ps-Pb)-Fb-Fs for net P&L when N is shares, Pb/Ps are per-share prices, Fb/Fs are flat fees. For ROI on basis, divide net P&L by =N*Pb+Fb.
Is this investment or tax advice?
No. It is a free educational tool—not a recommendation to trade, not a fiduciary opinion, and not a substitute for qualified professionals when decisions have money on the line.