Calculate your weighted average cost basis across multiple stock purchases. See per-lot P/L, position value, break-even price, and average-down scenario analysis.
When you buy a stock multiple times at different prices, knowing your weighted average cost basis is essential for making informed sell decisions and calculating taxes. This calculator takes all your purchase lots and computes the overall average cost, position profit/loss, and break-even price.
The per-lot analysis breaks down P/L for each individual purchase, revealing which entries are profitable and which are underwater. Color-coded bars give you instant visual feedback on your best and worst-timed buys. This is the same data your brokerage tracks, but presented in a cleaner analytical format.
The average-down simulator shows exactly how buying additional shares would lower (or raise) your average cost. Enter a potential buy price and shares, and the calculator maps out multiple scenarios showing how many shares you'd need to bring your average to specific levels. This is useful when deciding whether a new lot meaningfully improves your break-even price.
Use this to track your true cost basis after multiple purchases, DRIP reinvestments, or partial sales. It makes the break-even price and unrealized profit or loss easy to see before you place the next order.
Average Cost = Total Cost / Total Shares Total Cost = Σ(Price_i × Shares_i) Unrealized P/L = (Current Price − Avg Cost) × Total Shares Break-Even Price = Average Cost New Average = (Old Cost + New Purchase) / (Old Shares + New Shares)
Result: Average Cost: $153.33, 60 shares, +14.1% unrealized gain
Six DCA purchases at different prices average to $153.33/share. At $175, the 60-share position is worth $10,500 with $1,300 (14.1%) unrealized gain.
Your weighted average cost basis is the total dollars spent divided by total shares owned. That number is what matters when you want a clean break-even level or want to estimate the gain on the full position.
Adding shares at a lower price can improve your average cost, but it only helps if the underlying position still makes sense. The scenario table is most useful when you want to compare the effect of a small add versus a larger commitment.
Last updated:
This worksheet totals the entered purchase lots, divides total dollars invested by total shares to estimate weighted-average cost basis, and uses the entered current price to compute unrealized gain or loss on both the whole position and each lot. The average-down simulator simply adds a hypothetical new purchase to the existing cost and share totals, then recomputes the blended average price.
The result is a position-tracking worksheet, not a broker record of tax lots. It does not replace broker-specific lot-identification rules, wash-sale adjustments, commissions, or account-level tax reporting unless the user includes those items in the entered lot data.
The weighted average price of all your shares. Total dollars invested divided by total shares owned. Used for tax calculations and P/L tracking.
Only if you still believe in the investment thesis. Averaging down on a declining stock with broken fundamentals just increases losses. Average down on temporary dips, not broken companies.
Your total cost stays the same, but shares double (for 2:1 split). So average cost per share halves. Total position value is unchanged.
When you sell, your capital gain is (Sell Price − Average Cost) × Shares. Lower average cost = higher taxable gain. You can also use specific lot identification for tax optimization.
FIFO sells your oldest shares first. Average cost uses the weighted average. For stocks (not mutual funds), specific lot identification is usually optimal for tax purposes.
Both. Overall average gives your break-even. Per-lot tracking enables tax-loss harvesting — selling underwater lots to offset gains elsewhere.