Every investor knows the feeling of checking their portfolio tracker, hoping to see steady green rows, only to have their heart skip a beat. That was exactly the case recently when looking at the Index Holdings table.
There, right next to one of the biggest tech giants in the world, was a terrifying number: Amazon (AMZN) was showing a devastating -91.67% loss.
According to the unadjusted data in the table, the purchase price was $3,135.66, but the current price was listed at just $261.31. For an initial $1 fractional investment, the total value appeared to have shriveled up to a measly $0.08. It looked like a financial catastrophe.
But as seasoned market observers know, things are not always what they seem on a spreadsheet.
Unmasking the Mystery: The 20-for-1 Stock Split
What looked like a catastrophic business failure was actually a classic market event: a 20-for-1 stock split.
In June 2022, Amazon executed a massive stock split. If you aren't familiar with how a split works, think of it like exchanging a $20 bill for twenty $1 bills. The total value of your money doesn't change, but you suddenly have a lot more individual pieces of currency.
When Amazon enacted the 20-for-1 split, the market price of a single share was divided by 20, dropping from the thousands down to a much more digestible double-to-triple-digit number. Crucially, to keep investors whole, every share held by an investor was multiplied by 20.
Why Do Companies Split Their Stock?
Companies usually split their shares when their stock price becomes so high that it becomes intimidating or impractical for everyday retail investors to buy whole shares. By lowering the per-share price, Amazon achieved a few key goals:
- Increased Accessibility: It makes the stock much more attractive to retail investors who might not have thousands of dollars to buy a single share.
- Liquidity: More shares trading at a lower price increases the overall trading volume and liquidity in the market.
- Employee Compensation: It allows the company to distribute stock-based compensation to employees in more precise increments.
The Real Math: From Tragedy to Triumph
The reason for the terrifying -91.67% figure in the table is that the tracker updated the Current Price ($261.31) to the post-split price, but failed to adjust the Total Shares column to reflect the split. It was still multiplying the original, pre-split fractional share count (0.000318912) by the new price.
When we correct the data and apply the 20-for-1 share increase, the real magic of the market reveals itself:
- Original Shares: 0.000318912
- Adjusted Post-Split Shares (x20): 0.006378243
- Current Post-Split Price: $261.31
- Actual Effective Value: $1.67 (on a $1.00 initial purchase)
Instead of a crushing 90% loss, the actual, effective percent gain on this AMZN stock holding is an outstanding +66.67%!
A Cautionary Note for Spreadsheet Investors
This scenario serves as a perfect cautionary tale for anyone managing or tracking their own investments. Never rely blindly on raw price tracking without understanding corporate actions.
When a tracker doesn't automatically account for stock splits, reverse splits, or spin-offs, it can create massive false alarms (or false celebrations).
But more importantly, it reminds us that amazing things happen in the stock market. A stock split is almost always a sign of a healthy, rapidly growing company whose share price has simply become "too successful." Far from being bad news, splits often spell fantastic long-term news for investors—and as this corrected data proves, turning a perceived 90% loss into a 66% gain is a prime example of why you should always dig deeper into the numbers!
Key Assumptions Made in This Analysis:
- Stock Split Ratio: We assume that the price adjustment in the data reflects Amazon's historical 20-for-1 stock split from June 2022, and that the share count in the table was left unadjusted.
- Fractional Share Baseline: Based on the Index Holdings table, we assume a baseline initial investment of $1.00 per asset, resulting in fractional share holdings.
Comments
Post a Comment