Skip to content

Finance & Investment · Returns

Average Cost Calculator (Stocks & Mutual Funds)

Enter each purchase of a share, mutual fund or crypto (units and price, plus any charges) to get your average cost per unit and total cost. Add today's price to see your profit or loss, and a target average to see how many more units you'd need to buy to reach it.

Your inputs

Quick start — try a typical case

3 rows · you can paste rows from Excel or Google Sheets

One row per purchase. You can paste rows straight from Excel or your broker's statement.

Leave 0 to skip profit and loss.

Your result Live

Average Cost per Unit

₹208.53

Across 3 purchases, including ₹60 of charges

Average Price (before charges)
₹208.33
Total Units
300
Total Cost incl. Charges
₹62,560
Current Value
₹61,500
Unrealised Loss
₹1,060 (-1.69%)
Break-even Price
₹208.53

Purchases

3 rows
#UnitsPriceChargesCostRunning average
1100₹250₹20₹25,020₹250.20
250₹210₹15₹10,515₹236.90
3150₹180₹25₹27,025₹208.53

How this is calculated

Average cost = Σ(units × price + charges) ÷ Σ units · Units to reach target T at price P = U × (A − T) ÷ (T − P)

U, A
Units held now and their average cost
T
Target average
P
Price of the new purchase

Your average cost is a weighted average: bigger purchases count for more. Including brokerage, STT, stamp duty and other charges gives your true break-even price. Averaging down only works if you buy below the target — the new average always lands between the old average and the new price.

Assumptions & sources

  • All rows are purchases of the same security; sales are not tracked (use FIFO from your broker's tax statement for sold lots).
  • Charges are added to cost, as they are for capital-gains purposes in India.
  • Bonus issues and splits must be entered as adjusted units and prices.
  1. 1Investments (Bodie, Kane & Marcus), chapters on returns, compounding and the time value of money — McGraw-Hill
  2. 2Investor education material — SEBI — Securities and Exchange Board of India

Calculator ID FIN-COST-AVG-001 · version 1.0.0

Common questions

Should charges be included in the average?

Yes, for your real break-even price and for capital gains. The calculator shows both: the plain average price and the average including charges.

How does averaging down work?

Buying more at a lower price pulls the average down. To reach a target average T with a purchase at price P, you need U × (A − T) ÷ (T − P) more units, where U and A are your current units and average. It's only possible when P is below T.

Does averaging down make sense?

It lowers your break-even price but also puts more money into the same investment. Do it only if you'd buy the investment fresh at today's price for its own merits.