Retire Before Dad

    • Start!
      • About
      • RBD Story
      • Featured on…
      • Archive
      • Portfolio
      • Guest Post Policy
      • Contact
      • Terms & Privacy Policy
      • Home
    • IPOs
    • Reviews
      • NewRetirement Review
      • Sure Dividend Review
      • Yieldstreet Review
      • Fundrise Review
      • M1 Finance Review
      • Motley Fool Stock Advisor
        • Motley Fool Rule Breakers
      • AcreTrader Review
      • Masterworks Review
      • Roofstock Review
      • PeerStreet Review
      • EquityMultiple Review
      • Virginia 529 Review
    • Resources
      • Yield Curve Chart
      • Start Saving for Retirement
      • Passive Income Ideas
      • Best Brokers for Dividends
      • Dividend Aristocrats
      • Debt-Free S&P 500 Stocks
      • Best Real Estate Crowdfunding Platforms
      • Affiliate Programs And Blogging
      • How To Start An Online Business
    • Recommended
      • Retirement Calculator
      • Net Worth Calculator
      • Tools
      • Blogroll
      • Dads Blog Money
    • Best Cards
      • Travel Rewards
      • Cash Back
      • Small Business
      • Airline Rewards
      • Hotel Rewards
    This page may contain links to our partners. RBD may be compensated when a link is clicked. See the full disclosure here.

    Average Cost Calculator for Stocks, Cryptos, or Inventories

    This page and spreadsheet provide a free average cost calculator for a group of stock or crypto purchases. You can also calculate the average cost of items such as sales inventory.

    In stock investing, the average cost is essentially the same as a weighted average. The average cost is your cost basis.

    Cost basis is important because it is used to calculate your tax burden upon a sale that produces a capital gain.

    This article explains the average cost calculator formula and shows examples of calculating the average cost for a set of stock purchases, cryptocurrencies, and product inventory.

    There’s a free spreadsheet at the bottom that you can download, giving you four different average cost calculator options (four tabs).

    There is no email required to download the spreadsheet. Just click the big green button at the bottom or any spreadsheet screenshot to download for free. 

    Table of Contents

    • Average Cost Formula
    • Average Cost Calculator for Stocks (Cost Basis Calculator)
      • Stocks Example #1
      • Stocks Example #2
    • Crypto Average Calculator
    • Average Cost Calculator for Inventories
    • Average Cost Calculator Excel Spreadsheet

    Average Cost Formula

    For stocks, the formula we use for the average cost calculator spreadsheet is as follows: 

    Average cost = total cost/number of shares. 

    For cryptocurrencies, the calculation is essentially the same, but the terminology is different. 

    Average cost = total cost/total coins acquired

    For inventories, the average cost formula is the same:

    Average cost = total cost/quantity of units produced

    Average Cost Calculator for Stocks (Cost Basis Calculator)

    The average cost formula is the same if you buy one lot of shares or 20.

    But there are two methods to calculate the average cost, and I’ll show both examples here. 

    Stocks Example #1

    Step 1: To get the average cost, list the number of shares purchased and the cost of those shares for each lot. They may also be referred to as “tax lots.”

    A “lot” is one stock trade. Round lots are 100 shares or divisible by 100. But lots can be uneven numbers or fractional shares. 

    Step 2: Add the total number of shares.

    Step 3: Add the total cost of all trades. 

    Step 4: Divide the total cost by the total number of shares to to calculate the average cost. 

    Here’s a simple average cost calculation for “XYZ” stock holding with two separate lot purchases. 

    Lot #1
    60 shares costing $15 per share. 

    Lot #2
    40 shares costing $18 per share

    Calculation:

    Number of shares = 60 + 40 = 100
    Cost of Lot #1 = 60*15 = $900 
    Cost of Lot #2 = 40*18 = $720 
    
    Total cost = $1,620

    In this example, there are 100 shares at a total cost of $1,620 (720+900).

    Divide the total cost by the total number of shares. 

    = 1620/100 = $16.20

    The average cost per share is $16.20.

    Here’s what it looks like in the spreadsheet:

    Average cost calculator spreadsheet, stock method 1.

    Stocks Example #2

    Another way to calculate the average cost is to weigh each lot’s cost per share, then add the total.

    This method can be tedious if you have many lots. However, using a spreadsheet, it’s easy. 

    We’ll use the same example as above. 

    Lot #1
    60 shares costing $15 per share. 

    Lot #2
    40 shares costing $18 per share

    Step 1: Calculate the price weight of the first lot.

    To do this, divide the number of shares in the lot (60) by total shares (100) to get a percentage. Then multiply the percentage by the price per share. 

    = (60/100) * 15 = 9

    Step 2: Calculate the price weight of the second lot.

    Same as Step 1. 

    = (40/100) * 18 = 7.2

    Step 3: Add the weighted price of each lot. 

    = 9 + 7.2 = 16.2

    We get the same answer as in example #1.

    Here’s what it looks like in the average cost calculator spreadsheet:

    Average cost calculator spreadsheet, stock method 2.

    Crypto Average Calculator

    The average cost calculation for cryptos I’ve used in this example is the same as the stock method #1. Using this spreadsheet will give you the average cost, or cost basis, for a series of cryptocurrency purchases, such as Bitcoin, Dogecoin, Ethereum, etc. 

    I’ve used approximate Bitcoin numbers dating to about May 2021, when Bitcoin traded between $30,000 and $60,000.

    Average cost calculator cryptocurrency spreadsheet example.

     

    Average Cost Calculator for Inventories

    The average cost calculation for inventories is the same as stocks and cryptos. In the spreadsheet, I’ve changed the headings. You can call them whatever you like. 

    Average cost calculator inventory spreadsheet example

    Average Cost Calculator Excel Spreadsheet

    The spreadsheet I used to make these screenshots is available for free download. There are no restrictions or locking on the fields, so you may modify the cells as you like.

    But you might want to save a copy of the original in case you need to start fresh.  

    Here’s a link to the free average cost calculator Excel spreadsheet (the download does not require your email address). The spreadsheet includes the stock average calculator, crypto average calculator, and inventory cost calculator on separate tabs. 

    Average Cost Calculator Spreadsheet

    Feedback? Contact me.

    Please Share!

    • Click to share on Twitter (Opens in new window)
    • Click to share on Facebook (Opens in new window)
    • Click to share on Reddit (Opens in new window)
    • Click to share on Pinterest (Opens in new window)
    • Click to share on LinkedIn (Opens in new window)
    • Click to email a link to a friend (Opens in new window)

    Favorite tools and investment services right now:

    Fundrise - The easiest way to invest in high-quality real estate with as little as $10 (review)

    Empower (Personal Capital is now Empower) - A free tool to track your net worth and analyze investments.

    M1 Finance - A top online broker for long-term investors and dividend reinvestment (review)

    SaveBetter - SaveBetter is a simpler way to access high-yield, FDIC-insured savings products.

    Services I Use Every Day

    Personal Banking: Wells Fargo
    Travel Credit: Chase Sapphire Preferred
    Primary Savings: Marcus
    Primary Broker: Fidelity
    DRIP Broker: M1 Finance
    Biz Banking: Wells Fargo
    Biz Credit: Chase Ink Business Preferred
    Net Worth Calculator: Empower

    Home
    About
    Featured on
    Resources
    Website Terms/Privacy Policy/Full Disclaimer

    ADVERTISING DISCLOSURE: This website engages in affiliate marketing. This means that if you use an affiliate link to make a purchase, the website will receive a commission on that purchase. All efforts are made to ensure that affiliate links are disclosed in accordance with the FTC. Retire Before Dad has partnered with Cardratings for our coverage of credit card products. Retire Before Dad and CardRatings may receive a commission from card issuers. The Website uses Mediavine to manage all third-party advertising on the Website. This website is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and links to Amazon.com.

    Disclaimer

    Read the full Disclaimer policy here.

    Opinions, reviews, analyses & recommendations are the author’s alone, and have not been reviewed, endorsed or approved by any of these entities. We have made every effort to ensure that all information on this website is accurate. We make no guarantees regarding the results that you will see from using the information provided on the website. We are individual investors, not financial advisors, tax professionals or investment professionals. All information on the site is provided for entertainment and informational purposes only and should not be considered advice. Do not make investment decisions based on the information provided on this website. This website may discuss topics related to finance and investing. The information provided on this websites is provided “as is” without any representations or warranties, express or implied. The website makes no representations or warranties in relation to the financial and investing information on the website. You must not rely on the information on the website as an alternative to advice from a certified public accountant or licensed financial planner. We assume no responsibility for errors or omissions that may appear in the website. You should never delay seeking financial advice, disregard financial advice, or discontinue professional financial services as a result of any information provided on the website.

    Copyright © 2023 Retire Before Dad · Custom site by Moonsteam Design