How to Calculate Gain and Loss on a Stock (2024)

What Are Stock Gains and Losses?

Gains are an increase in an asset's market value from its purchase price, while losses are a decrease in market value from its purchase price. There are two types of gains and losses: realized and unrealized. Unrealized gains and losses occur while you still own the asset. They are realized (brought into reality) when you sell the investment, resulting in an actual gain or loss of capital.

Gains occur whenever an asset's current price is higher than the price at which it was originally purchased. So, if you bought a share of Amazon (AMZN) stock on Sept. 3, 2013, at $13.23 and held it until May 11, 2020, you would have experienced an unrealized gain, as the stock closed at $120.45.

When you incur a loss, it means the current value of an asset or investment is lower than the price at which it was originally purchased. So, if you bought a single share of AT&T (T) stock on May 10, 2021, for $32.63 and sold it at $22.17 on Dec. 15, 2021, you'd have a realized loss.

Key Takeaways

  • To calculate your profit or loss, subtract the current price from the original price, also called the "cost basis."
  • The percentage change takes the result from above, divides it by the original purchase price, and multiplies that by 100.
  • A stock profit may not mean much unless you know how much you need to invest to make that amount of money.
  • Many websites calculate gains or losses, or you can set up a spreadsheet to do it for you.

Formula for Gains and Losses

To find the netgainorloss experienced for any stocks you hold, determine the difference between the total price you paid for them and the amount you received when you sold them. The result of the loss or gain calculation will be a percentage.

You calculate gains and losses using the price you paid—including all fees, commissions, and other expenses—and its market value when you sell it. This total price, for the purpose of this example, can be considered the original purchase price.

To calculate your gain or loss, subtract theoriginal purchase pricefrom thesale priceand divide the difference by the purchase priceof the stock.Multiply that figure by 100 to get the percentage change.

Net Gain or Net Loss = [ (Current Price - Original Purchase Price) ÷ Original Purchase Price ] x 100

Calculating Gains and Losses

To calculate your gains or losses, fill in the formula with your information. For simplicity, the calculation below excludes other costs and profit elements, such as dividends received, brokerage fees, and income taxes.

Using the previous Amazon figures:

  • Purchase price: $288.80
  • Sale price: $2,409.78
  • ($2,409.78 - $288.80) ÷ $288.80 = 7.344
  • 7.344 x 100 = 734.4%

You'd have realized a gain of 734.4% for a single Amazon share.

The AT&T stock figures:

  • Purchase price: $32.63
  • Sale price: $22.17
  • ($22.17 - $32.63) ÷ $32.63 = -.3205
  • -.3205 x 100 = -32%

You'd have a loss of 32% for a single AT&T share.

Gains and losses are categorized by the Internal Revenue Service (IRS) as long-term and short-term gains and losses. Long-term gains are realized after holding assets for more than a year while those deemed short-term are realized after being held for less than 12 months.

Dollar Value Profit or Loss

Some investors only use the dollar value of their returns to gauge profitability, but here is why percentage return figures are much more useful.

Imagine an investor buys 100 shares of Cory's Tequila Company at $10 per share for a total investment of$1,000. Suppose they sell those shares for $1700 ($17 per share) two months later, which means their profit for the trade is $700.

Suppose the investor also bought 1,000 shares in Rob's Sake Distillers at $10 apiece (for a total investment of $10,000) and later sold those shares at $10.70 each for a total of$10,700. The investor gained $700 in this investment as well.

Fees and other costs can eat away at your profits or add to your losses. Make sure you factor them in when you're considering selling any assets.

Calculating Investment Returns

The investment in Cory's Tequila Company was made at $10 per share and sold at $17 per share. The math for Cory's per share percent return is as follows:

  • ($17 – $10) ÷ $10 = .7
  • .7 x 100 = 70%

Thus, the percentage return on a $10 per share investment is 70%.

The math for Rob's is as follows:

  • ($10.70 - $10) ÷ $10 = .07
  • .07 x 100 = 7%

An investment in Rob's Sake Distillers would yield a 7% return per share.

So, when the investor compares the dollar value of their investments, it's clear that Cory's was a better investment because it took $10,000 to gain 7% at Rob's, but only $1,000 to gain 70% at Cory's:

Cory's

  • Outlay: $1,000

  • Returned: $1,700

  • Percent Gain: 70%

Rob's

  • Outlay: $10,000

  • Returned: $10,700

  • Percent Gain: 7%

Gains and losses are realized when you actually sell stock. Gains and losses are unrealized if the value changes, but you hold onto the stock within your portfolio.

Tools for Calculating Investment Returns

You can certainly use the formula above to calculate the returns of specific assets. However, there are several tools available to you that can help you tabulate your returns.

For starters, you may want to consider websites that do the calculations for you. The following are just a few of the sites you can visit to calculate the percentage gain or loss for the stocks you hold in your portfolio:

  • Gain & Loss Percentage Calculator from Babypips
  • Percentage Increase Calculator from OMNI Calculator
  • Percentage Decrease Calculator from OMNI Calculator
  • Percentage Increase Calculator from CalculatorSoup
  • Percentage Decrease Calculator from CalculatorSoup
  • Calculator from Percent Change Calculator

Calculating Profits and Losses in Spreadsheets

You can also use software to help you. For example, you can set up your own percentage change calculator using a spreadsheet. Begin by labeling the individual cells in the first columns as follows:

  • A1: Final Price
  • B1: Purchase Price
  • C1: Percentage Change

Input your purchase and final prices into the cells in the following rows:

  • A2: Final Price
  • B2: Purchase Price

Click on the cell for C2 and type in =(A2-B2)/B2*100. Cell C2 should automatically populate with your percentage change. So, if you use the example of Cory's Tequila Company with an initial investment of $1,000 and the sale netting $1,700, we get a percentage change of 70%.

Keep in mind that you can drag the formula down in Excel to carry it down into further cells.

How Do You Calculate Profit on Stock?

If you want to calculate the profit on a stock, you'll need the total amount of money you used to purchase your stock and the total value of your shares at the current price. You'll also need to know any fees associated with your transactions. So, if you bought 10 shares of Company X at $10 each and sold them for $20 each and incurred fees of $10, you stand to walk away with a profit of $90. Put simply, $200- $100- $10 = $90. Remember that this is just the dollar value and not the percentage change.

How Can I Calculate Long-Term Gain or Loss on Stock?

Long-term gains or losses are realized any time you sell a stock that you've held for more than a year. In order to figure out the gain or loss, you need your purchase and sale price for the stock. Subtract the purchase price from the sale price. A positive result means you have a capital gain while a negative result means you have a loss. Your capital gains tax rate depends on several factors, including your income and filing status.

How Do You Calculate Gain or Loss Percentage on Stock With a Calculator?

You'll need the original purchase price and the current value of your stock in order to make the calculation. Subtract the total purchase price from the current price of the stock then divide that by the original purchase price and multiply that figure by 100. This gives you the total percentage change.

The Bottom Line

Calculating your profit or loss on your stock holdings is a fairly straightforward procedure. It's as simple as calculating the percentage change between a beginning value and an ending value. When calculating your profit or loss, make sure you look at the percentage return as opposed to the dollar value.

How to Calculate Gain and Loss on a Stock (2024)

FAQs

How to Calculate Gain and Loss on a Stock? ›

In order to figure out the gain or loss, you need your purchase and sale price for the stock. Subtract the purchase price from the sale price. A positive result means you have a capital gain while a negative result means you have a loss.

How to calculate stock loss or gain? ›

The Takeaway. Assuming a stock's price is higher when you sell it versus when you bought it, learning how to calculate stock profit is pretty easy. You simply subtract the original purchase price from the price at which you sold it. (If the selling price is lower than the purchase price, of course, you'd see a loss.)

How can I calculate my gains or losses? ›

Start by subtracting the purchase price from the selling price. Then take that gain or loss and divide it by the purchase price. Finally, multiply that result (a number in decimal form) by 100 to get percentage change.

How do you calculate profit gain or loss? ›

When the selling price and cost price are known, the basic formulas for calculating the profit and loss are: Profit = Selling price (S.P.) - Cost price (C.P.) Loss = Cost price (C.P.)

How do you calculate gain or loss basis? ›

Sale Price – Cost Basis = Reportable Gain or Loss

For regular stock bought on the open market, the cost basis is simply the purchase price. With stock plans, adjustments may be needed to determine the correct cost basis amount.

What is the formula for gain or loss? ›

To calculate your gain or loss, subtract the original purchase price from the sale price and divide the difference by the purchase price of the stock. Multiply that figure by 100 to get the percentage change.

How do you calculate inventory gain or loss? ›

The formula for inventory loss using the gross profit method is as follows: add current year purchases to the beginning inventory to calculate the cost of goods available for sale, then estimate the gross profit margin for the period, calculate COGS, and subtract it from goods available for sale to calculate the ending ...

How to calculate profit and loss in stock market? ›

In order to calculate the loss or profit for trades that are CLOSED, follow the below formula:
  1. BUY Trade: (Close rate – Open rate) * Nominal Value = P/L.
  2. SELL Trade: (Open rate – Close rate) * Nominal Value = P/L.

How to calculate gain or loss on stock in Excel? ›

Creating Profit/Loss Formulas in Excel

The profit and loss formula is the difference multiplied by the number of shares. To create the formula, click in the cell where you want the value to appear. Next, type the equals sign and then click in the cell that contains the difference (see above).

What is the formula for calculating loss of profit? ›

In the case of profit, the selling price is always more than the cost price. Profit = Selling Price - Cost Price. Similarly, in the case of loss, the cost price is more than the selling price. Loss = Cost Price - Selling Price.

How do you find capital gain or loss? ›

You have a capital gain if you sell the asset for more than your adjusted basis. You have a capital loss if you sell the asset for less than your adjusted basis. Losses from the sale of personal-use property, such as your home or car, aren't tax deductible.

How do you calculate percentage gain and percentage loss? ›

Important Formulas
  1. Profit or Gain = Selling price – Cost price.
  2. Loss = Cost price – Selling price.
  3. Profit Percentage = [Profit/C.P.]×100.
  4. Percentage Loss = [Loss/C.P.]×100.

How to calculate stock basis? ›

You can calculate your cost basis per share in two ways: Take the original investment amount ($10,000) and divide it by the new number of shares you hold (2,000 shares) to arrive at the new per-share cost basis ($10,000/2,000 = $5).

How do you calculate portfolio gain or loss? ›

When an investor incurs a loss, the current value of an asset or investment is lower than the price at which it was purchased. To find the net gain or loss of a stock, subtract the purchase price from the current price and divide the difference by the purchase prices of the asset.

What is the formula for loss? ›

Loss: When the cost price is higher than the selling price, and the difference between them is the loss suffered. Formula: Loss = C.P. – S.P. Remember: Loss or Profit is always computed on the cost price. Marked Price/List Price: price at which the selling price on an article is marked.

How do you calculate gain or loss on options? ›

To calculate the net profit or loss, subtract the premium paid (for a long position) or add the premium received (for a short position) from the final option value at expiration. The final option value is the sum of the intrinsic value and time value at expiration.

Top Articles
Best Burial Insurance For Seniors To Cover Final Expenses!
How Does Life Insurance Work for People Over 85? | Cake Blog
Hotels Near 6491 Peachtree Industrial Blvd
Lowe's Garden Fence Roll
Matgyn
Swimgs Yuzzle Wuzzle Yups Wits Sadie Plant Tune 3 Tabs Winnie The Pooh Halloween Bob The Builder Christmas Autumns Cow Dog Pig Tim Cook’s Birthday Buff Work It Out Wombats Pineview Playtime Chronicles Day Of The Dead The Alpha Baa Baa Twinkle
Myexperience Login Northwell
Winston Salem Nc Craigslist
What Are the Best Cal State Schools? | BestColleges
Gabriel Kuhn Y Daniel Perry Video
9192464227
Brgeneral Patient Portal
The Realcaca Girl Leaked
Learn How to Use X (formerly Twitter) in 15 Minutes or Less
Camstreams Download
Was sind ACH-Routingnummern? | Stripe
Crusader Kings 3 Workshop
Culvers Tartar Sauce
4302024447
Wordscape 5832
Transfer Credits Uncc
Nebraska Furniture Tables
Unlv Mid Semester Classes
Chelactiv Max Cream
Barber Gym Quantico Hours
Today Was A Good Day With Lyrics
Tripadvisor Napa Restaurants
Dewalt vs Milwaukee: Comparing Top Power Tool Brands - EXTOL
Horn Rank
January 8 Jesus Calling
Farm Equipment Innovations
Truck from Finland, used truck for sale from Finland
Ncal Kaiser Online Pay
In hunt for cartel hitmen, Texas Ranger's biggest obstacle may be the border itself (2024)
Craigs List Jax Fl
Planned re-opening of Interchange welcomed - but questions still remain
Emily Katherine Correro
Ket2 Schedule
42 Manufacturing jobs in Grayling
Chs.mywork
Viewfinder Mangabuddy
Gets Less Antsy Crossword Clue
Noaa Duluth Mn
Brake Pads - The Best Front and Rear Brake Pads for Cars, Trucks & SUVs | AutoZone
Woody Folsom Overflow Inventory
Craigslist Minneapolis Com
Zipformsonline Plus Login
Unblocked Games 6X Snow Rider
Acuity Eye Group - La Quinta Photos
Used Auto Parts in Houston 77013 | LKQ Pick Your Part
Sams La Habra Gas Price
La Fitness Oxford Valley Class Schedule
Latest Posts
Article information

Author: Twana Towne Ret

Last Updated:

Views: 6186

Rating: 4.3 / 5 (64 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Twana Towne Ret

Birthday: 1994-03-19

Address: Apt. 990 97439 Corwin Motorway, Port Eliseoburgh, NM 99144-2618

Phone: +5958753152963

Job: National Specialist

Hobby: Kayaking, Photography, Skydiving, Embroidery, Leather crafting, Orienteering, Cooking

Introduction: My name is Twana Towne Ret, I am a famous, talented, joyous, perfect, powerful, inquisitive, lovely person who loves writing and wants to share my knowledge and understanding with you.