What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
An average-down calculator shows how an additional purchase changes your position’s weighted-average cost, how many shares a budget can buy, or how many shares it would take to reach a target average. You can build the basic calculator in Excel or Google Sheets with the formulas below. It is a planning tool—not a recommendation to add to a losing investment or a substitute for your broker’s tax-lot records.
What averaging down means
Averaging down means buying more of an investment after its price falls, at a price below your existing average cost. The additional shares lower the position’s weighted-average purchase cost, but they also increase the amount invested and the number of shares exposed to future price changes.
For example, 100 shares bought at $50 cost $5,000. Buying another 100 at $30 costs $3,000. The position then has 200 shares and $8,000 invested, for an average cost of $40 per share before fees. The nominal price needed to recover that amount is $40; adding shares does not erase the existing loss or guarantee a recovery.
Build a quick calculator
In a blank worksheet, enter these labels in column A and inputs or formulas in column B. The layout calculates a new average for a specified share quantity; keep the share and price inputs in the same currency and do not round intermediate calculations.
Free tools Windows power users keep installed
One-click scans. No signup required.
#1 Best Overall
- Profitability calculations; cash flow function Calculates NPV and IRR for uneven cash flows
- Time-value-of-money and Amortization keys solve problems including: pension calculations, loans, mortgages, etc.
- Ideal calculator for students, managers and statisticians
- Built-in functionality : List-based one- and two-variable statistics with four regression options: linear, logarithmic, exponential and power
- The BA II Plus calculator is approved for use on the following professional exams: Chartered Financial Analyst exam. GARP Financial Risk Manager (FRM) exam. Certified Management Accountants exam
| Cell | Label | Value or formula |
|---|---|---|
| A2 / B2 | Existing shares | Enter a positive share count |
| A3 / B3 | Existing average cost per share | Enter the average you are using |
| A4 / B4 | New purchase price | Enter a positive price |
| A5 / B5 | Additional shares | Enter the planned quantity |
| A7 / B7 | Existing total cost | =B2*B3 |
| A8 / B8 | New purchase cost | =B4*B5 |
| A9 / B9 | Total shares | =B2+B5 |
| A10 / B10 | Total invested, excluding fees | =B7+B8 |
| A11 / B11 | New average cost, excluding fees | =IFERROR(B10/B9,"") |
This is a weighted average: total cost divided by total shares. Simply averaging the two per-share prices is wrong unless the purchases contain the same number of shares. The equivalent direct formula is =(B2*B3+B5*B4)/(B2+B5).
Calculate a purchase from a budget
To estimate what a fixed budget buys, add a budget input and calculate affordable shares. For fractional-share trading, use =Budget/NewPurchasePrice. For whole shares, use =ROUNDDOWN(Budget/NewPurchasePrice,0) so the purchase does not exceed the budget before fees.
Then use the affordable share result as the additional-share input in the quick calculator. The resulting average is based on the actual affordable quantity, not on the budget alone. If the budget cannot cover one whole share, the whole-share result is zero. If fees apply, reserve them first: with a flat fee, use =IF(Budget>FlatFee,ROUNDDOWN((Budget-FlatFee)/NewPurchasePrice,0),0). A fee greater than or equal to the budget leaves nothing available for shares.
Calculate how many shares reach a target average
Let S be existing shares, A the existing average cost, P the new purchase price, T the desired average, and N the additional shares. The weighted-average equation is (S*A+N*P)/(S+N)=T. Solving for the purchase quantity gives:
Recommended Free Tools
Rank #2
- PROFESSIONAL FINANCIAL CALCULATOR : Built-in TVM, IRR, NPV. Engineered for business analysts, real estate investors, accountants, and finance students.
- ADVANCED CASH FLOW & AMORTIZATION : Execute time value of money, break-even analysis, depreciation schedules, and bond pricing. Trusted for professional exam prep", MBA coursework, and banking certifications.
- CATIGA CF-300 : Flip-open hard case with a snap-close design for a secure fit. Compact and portable: designed for daily professional use in office, classroom, or on-site.
- ALL-IN-ONE FOR PROFESSIONALS : From NPV/IRR for real estate analysis to statistical calculations for business analysts. Handles probability, linear regression, and complex financial formulas.
- MORTGAGE, LOAN & INVESTMENT CALCULATOR : Covers bond pricing, loan amortization, investment analysis, and exam-level computations. Your go-to accounting calculator, business calculator, and real estate calculator in one device.
N=S*(A-T)/(T-P)
For an average-down target reached by buying below the existing average, the target must be lower than A and higher than P. With the quick-calculator layout above, put the target in B6 and use this guarded formula:
=IF(B2<=0,"Enter existing shares",IF(B4<=0,"Enter a valid purchase price",IF(B6>=B3,"Target must be below existing average",IF(B6<=B4,"Target must be above purchase price",B2*(B3-B6)/(B6-B4)))))
To see the capital requirement, multiply the resulting quantity by the purchase price; add applicable fees separately. In the example position of 100 shares at $50, reaching a $35 average by buying at $30 requires 300 additional shares: 100*($50-$35)/($35-$30)=300. That purchase costs $9,000 before fees, leaving 400 shares with $14,000 invested and a $35 average.
When a target cannot be reached
- If the target equals the new purchase price, the denominator is zero; a finite purchase cannot make the combined average exactly equal the new price while an existing position remains.
- If the target is below the new purchase price, buying at that price cannot pull the combined average below itself.
- If the target is at or above the existing average, it is not an average-down target. A general weighted-average calculator can still model a purchase, but it may raise rather than lower the average.
- As the target approaches the new purchase price from above, the required quantity rises sharply. Always display the required shares and the associated cash commitment together.
Whole-share orders and fractional shares
Keep the exact mathematical requirement visible. If only whole shares are available, use =ROUNDUP(required_shares,0) when the goal is to reach or beat the target. Recalculate total shares, total cost, and average using that rounded quantity; the resulting average may be lower than the target. For a budget-based purchase, use ROUNDDOWN instead so rounding does not exceed the available amount. If fractional shares are supported, retain the fractional result subject to the broker’s precision and minimum-order rules.
Compare several purchase scenarios
A scenario table helps show how different prices and quantities change the position. These examples assume 100 existing shares at $50 and exclude fees:
Rank #3
- HP 10BII+ FOR STUDENTS & PROFESSIONALS – This HP calculator is built for business, finance, accounting, and statistics courses. Perfect for learners and professionals who need to solve common financial problems quickly without memorizing formulas or relying on spreadsheets.
- 100+ FUNCTIONS FOR REAL WORLD MATH – Quickly solve time value of money, interest rates, loan payments, NPV, IRR, cash flows, and more. The 10bII+ also includes probability distributions for statistics courses—a feature not often found in financial calculators.
- ALGORITHMIC INPUT WITH DEDICATED KEYS – This high-school/college calculator uses algebraic and chain logic with minimal keystrokes. Layout appears the same as standard calculators for easy learning. Dedicated keys give quick access to commonly used financial and statistical functions
- APPROVED FOR MAJOR EXAMS – The HP 10bII+ algebra calculator is permitted for use on SAT, PSAT/NMSQT, and AP tests. An ideal statistics calculator and business calculator for school finance and accounting students preparing for class, coursework, or standardized exams.
- INCLUDES TRAVEL CASE, CLEANING CLOTH & BATTERIES– Slim, durable, and easy to keep on hand or store in a backpack or locker. Includes a protective case, cleaning cloth, and batteries so it’s ready out of the box. Large screen with clear contrast (non-backlit) is easy to read during exams or lectures.
| New price | New shares | Additional cost | Total shares | Resulting average |
|---|---|---|---|---|
| $45 | 25 | $1,125 | 125 | $49.00 |
| $40 | 50 | $2,000 | 150 | $46.67 |
| $35 | 100 | $3,500 | 200 | $42.50 |
The final weighted average is unchanged by the order of purchases if the same transactions, fees, corporate actions, and cash flows are included. The timing still matters to your exposure, available cash, and risk while those purchases are made.
Track repeated purchases in a ledger
For ongoing use, keep transaction history rather than overwriting a single average-cost input. A ledger can include date, ticker, transaction type, shares, price, gross amount, fees, total cost, running shares, running total cost, running average, and notes. For each buy, calculate gross amount as shares times price and total cost as gross amount plus fees. The running average is cumulative total cost divided by cumulative shares.
A transaction ledger is better suited to repeated buys and helps reveal missing entries. It is not automatically a complete account of partial sales, reinvested distributions, stock splits, or tax-lot treatment; those events may require additional logic. Keep securities and currencies distinct unless the workbook specifies and records a conversion method.
Fees, market value, and break-even
The quick formulas above exclude fees. An all-in model should include commission, exchange or regulatory charges, per-share fees, currency conversion costs, and any other transaction costs that apply. Label the result clearly as either average cost excluding fees or all-in average cost including fees. With a flat fee on the new order, for example, add that fee to the new purchase cost before dividing by total shares; per-share charges should also be included in the transaction cost.
Rank #4
- Solves time-value-of-money calculations such as annuities, mortgages, leases, savings, and more
- Performs cash-flow analysis for up to 32 uneven cash flows with up to 4-digit frequencies
- Calculates various financial functions: Net Future Value Net present Value Modified Internal Rate of Return Internal Rate of Return Modified Duration Payback Discounted Payback
- The Texas Instruments BAII Plus Professional features an Automatic Power Down (APD) function for extended battery life
- Prompted display guides you through financial calculations showing current variable and label. Ten-digit display
Optional current-price inputs can estimate market value and unrealized performance: market value is total shares times current price; unrealized profit or loss is market value minus total invested; return is unrealized profit or loss divided by total invested. These are estimates based on the entered price and cost assumptions. A spreadsheet price may be manual, delayed, or dependent on a data connection, so show its source and timestamp rather than presenting it as guaranteed live data.
Choose a template or tool for your workflow
| Option | Best suited to | What to check |
|---|---|---|
| Build-your-own Excel or Google Sheets calculator | One-off scenarios and transparent formulas | Fee treatment, fractional-share assumptions, and whether the workbook is saved or shared securely |
| Online calculator | A quick calculation without maintaining a workbook | Whether it preserves inputs, includes fees, and offers a downloadable file |
| Portfolio tracker | Monitoring multiple holdings, market values, and gains or losses | Whether it has a target-average scenario feature; general trackers may not provide one |
| Dollar-cost averaging calculator | Modeling scheduled contributions at regular intervals | It is designed around contributions over time, not necessarily a target average after a price decline |
| Mobile calculator | Quick calculations away from a computer | Formula transparency, export options, ads, and requested data permissions |
For a ready-made Excel workbook, Ryan O’Connell Finance’s stock-average calculator template describes editable formulas, instructions, a formula-reference sheet, and Excel 2016-or-later compatibility. Its page observed in April 2026 listed a $0–$20 pay-what-you-want range; confirm current terms on the product page. For a one-off browser calculation, its online stock-average calculator also offers an Excel download option. The older HowToExcel average-down template article was published June 1, 2021, and describes inputs including invested amount, shares, current price, desired average, and budget.
If you need broader investment tracking, Vertex42’s investment tracker is intended for basic investment tracking, not official cost-basis reporting. DollarScout’s templates include a manual investment portfolio workbook. For a library of investment spreadsheets, see FinancialAha’s investing and trading templates. If your actual goal is scheduled investing, its distinction from averaging down is clearer with a dollar-cost averaging calculator. An Android option is Stock Average Calculator: P&L; review its current permissions and features in Google Play.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Average down versus dollar-cost averaging
Averaging down generally means adding to an existing position after its market price has fallen. Dollar-cost averaging means investing a predetermined amount at regular intervals regardless of whether the price rises or falls. The approaches can overlap, but they answer different planning questions: use an average-down calculator to model the effect of an additional purchase or target average, and a DCA model to examine scheduled contributions.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallCrashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteBest Value
- Brand New in box; The product ships with all relevant accessories
- Dedicated keys allow easy access to common financial and statistics functions
- Easy-to-use design provides business, finance and statistical calculations fast
- Specially designed to meet the mathematical needs
Limits: tax basis, other assets, and risk
A spreadsheet’s weighted average is an economic planning estimate, not necessarily the official tax basis for your account. Tax basis can depend on jurisdiction, account and security type, lot-selection method, partial sales, reinvested distributions, wash-sale adjustments, corporate actions, and broker reporting rules. Use broker tax-lot records and applicable tax documents for reporting. A specialized capital-gains calculator tracks transaction details that a simple average-down sheet may omit.
The basic formula is most appropriate for long stock or ETF purchases in the same currency and share units. Crypto arithmetic can use the same weighted-average idea, but fractional units, exchange and network fees, transfers, and tax-lot rules need to be represented. Options require contract multipliers, premiums, assignment, exercise, and expiration logic; futures require contract specifications, margin, tick values, mark-to-market treatment, and rollovers. A long-position share calculator also should not be reused for short positions without redefining cost, entry price, liability, and profit or loss.
Most importantly, a lower average is not a measure of lower investment risk. The spreadsheet describes what happens to the arithmetic when more capital is committed; it cannot establish that the security will recover or that another purchase suits your financial situation.
Quick Recap
Troubleshoot common spreadsheet errors
- A blank or error result: Check for blank inputs, zero total shares, or a zero denominator. Use validation and return a clear message instead of an unexplained error.
- A negative required-share result: Check the target and purchase price. A target at or below the purchase price cannot be reached by buying at that price; an above-existing-average target is not an average-down target.
- The average does not match a broker display: Compare included fees, share quantities, transaction history, corporate actions, currency, and the broker’s cost-basis method.
- The budget is exceeded: For whole shares, round budget-based shares down and account for fees before calculating affordability.
- Numbers look inconsistent after a split or sale: Do not enter a split as an ordinary cash purchase. Adjust the share history for corporate actions and use broker lot records after sales where tax treatment matters.
- A displayed current price seems stale: Confirm whether the value is manually entered, delayed, or refreshed through a supported data source, and record the timestamp.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Fix the driver behind crashes, sound loss and screen glitches3Repair Windows errors before they cause bigger problems
