Do you ever sit down and wonder, 'is my money really working for me?'

You buy a stock, watch it bounce around the market, and hope for the best.

But hope doesn’t pay the bills – or build wealth.

To really know if your money’s pulling its weight, you need something more solid.

Something like the Capital Gains Yield (CGY).

CGY let's you see what's really going on with your investments. It strips away the noise and shows you how much your stock has truly grown (or not).

Is your stock pulling your weight? Or just coasting along?

In this post, we’re breaking it down. What CGY is, why it matters, and how to use it to make smarter investing decisions. No math degree required, we promise.

Stick with us and, by the end, you will know exactly how to spot the winners in your portfolio (and maybe even make some bold moves you have been second-guessing).

What is Capital Gains Yield?

Capital Gains Yield (CGY) is the percentage of growth (or loss) in the price of an investment, usually a stock, compared to what you paid for it.

Here's the formula:

CGY = (Ending Market Value – Initial Investment) / Initial Investment

If the result is positive, your stock grew in value. If it’s negative, well, it might be time to rethink that investment.

Why Does CGY Matter?

Because it’s not just for stocks. CGY works across different asset classes:

• Stocks: See how your shares are appreciating (or not).
• Bonds: Check if the market value of your bonds is going up, especially if interest rates are shifting.
• Real Estate: Use it to measure the price growth of properties.

Say you bought 100 shares of a stock at $20 each, and the current price is $30 per share. Here’s how you’d calculate CGY:

1. Find Your Initial Investment

• Multiply the number of shares by the purchase price.
• Initial Investment = 100 × $20 = $2000

2. Determine the Ending Market Value

• Multiply the number of shares by the current price.
• Ending Market Value = 100 × $30 = $3000

3. Plug the Numbers Into the Formula

• Subtract the initial investment from the ending market value, then divide by the initial investment.
• CGY = ($3000 – $2000) / $2000 = 0.50 or 50%

Summary Table

Step	Calculation	Result
Initial Investment	100 x 20	$2000
Ending Market Value	100 x 30	$3000
Capital Gains Yield	($3000 – $2000) / $2000	50%

Why is Capital Gains Yield Important?

CGY can be thought of as an investment GPS. It helps you figure out not just where your money is going, but how well it’s doing the job. Whether you’re in it for the short-term gains or playing the long game, CGY is one of the most useful metrics you can have in your corner.

Here's why it matters:

• Guiding Your Buy, Hold, or Sell Decisions

Investing isn’t just about picking a stock and crossing your fingers. CGY gives you hard numbers to work with. Let’s say your stock has been steadily climbing—CGY can confirm whether it’s time to hold on for more growth or cash out before the momentum shifts. On the flip side, if your CGY is in the negative, it might signal it’s time to cut your losses.

• Measuring Profitability

At the end of the day, you want to know if you’re actually making money, right? CGY tells you exactly how much value your investments have gained (or lost) over time.

• Comparing Different Investments

Stocks, bonds, real estate – CGY works across the board. If you’re weighing the potential of one investment against another, CGY gives you a clear, apples-to-apples comparison. Which one is performing better? Where’s the risk worth the reward? CGY spells it out.

• Tracking Trends Over Time

For long-term investors, CGY helps you spot patterns. Is your portfolio on an upward trajectory, or is something dragging it down? For short-term traders, it’s a pulse check on how quickly an investment is delivering returns (or if it's fizzling out).

Short-Term vs. Long-Term

• Short-Term: CGY helps you capitalize on quick market movements. It’s especially handy for spotting opportunities to cash out while the numbers are good.
• Long-Term: Over time, CGY becomes a valuable tool for monitoring whether your investments are growing steadily and holding their value.

Comparing CGY Across Investment Types

Capital Gains Yield is not just for stock; it works across all kinds of investments. Whether it’s shares, bonds, real estate, or mutual funds, CGY gives you a way to compare performance on a level playing field.

Here’s how it works for different investment types, along with quick examples:

1. Stocks

CGY helps you track how much your shares have appreciated (or depreciated) over time.

Example:

You bought 50 shares of a stock at $40 each, and now they’re worth $60 per share:

CGY = [(50 x 60) – (50 x 40)] / (50 x 40)

= 50%

Your stock has grown by 50%.

2. Bonds

For bonds, CGY shows the impact of price changes due to market fluctuations or interest rate shifts.

Example:

You purchased a bond for $1,000, and its market price rises to $1,100:

CGY = ($1,100 – $1,000) / $1,000

= 10%

Your bond gained 10% in market value.

3. Real Estate

CGY measures the appreciation of property value over time, factoring in purchase and current prices.

Example:

You bought a property for $300,000, and its market value rises to $360,000:

CGY = ($360,000 – $300,000) / $300,000

= 20%

The property has gained 20% in value.

4. Mutual Funds

CGY helps you gauge the performance of a mutual fund by comparing its market value over time.

Example:

You invested $5,000 in a mutual fund, and its current value is $6,500:

CGY = ($6,500 – $5,000) / $5,000

= 30%

Your mutual fund grew by 30%.

Why Comparing CGY Matters

At the end of the day, you want to know if your investments are doing their job. CGY makes it easy to compare different types of assets – be it stocks, bonds, real-estate, mutual funds, or something else. It gives you one clear number to show what’s working and what’s not.

Instead of second-guessing yourself or getting lost in the details, you can figure out where your money is actually making a difference (and where it is just sitting there, doing nothing).

For long-term valuation, explore this Terminal Value Formula guide in Excel.

Real-World Applications of Capital Gains Yield

Understanding Capital Gains Yield is one thing, but knowing how to use it in real-life situations is what makes it truly valuable.

Let’s look at two scenarios where CGY can help you navigate the market and make better decisions:

Case Study 1: Market Volatility and Its Effect on CGY

Picture this: At the start of the year, you buy 50 shares of a tech stock at $100 each. Over the next six months, the price shoots up to $150 per share.

Excited, you calculate the CGY:

CGY = [(150 x 50) – (100 x 50)] / (100 x 50)

= 50%

You’re looking at a solid 50% gain – not bad, right?

But then the market takes a hit. By the end of the year, the stock drops to $90 per share, leaving you with:

CGY = [(90 x 50) – (100 x 50)] / (100 x 50)

= -10%

The once-promising stock is now in the red. CGY in this case serves as a reality check, helping you track how market volatility can impact your portfolio over time. It’s a reminder to stay vigilant and not get too attached to those high points.

Case Study 2: Using CGY Trends to Decide When to Sell

Here’s another example: You’ve been holding onto shares of an electric vehicle company for three years. The price has doubled from $50 to $100, giving you an impressive CGY of 100%:

CGY = [(100 x 100) – (50 x 100)] / (50 x 100)

= 100%

But in the past six months, the stock price has plateaued, barely hovering at $100. That’s a signal: your CGY is no longer increasing. The market may have reached a saturation point for this stock.

By watching the trend, you might decide it’s time to sell and lock in your gains before any downturn. CGY trends can act as a nudge to take profits at the right moment instead of holding on for too long.

Visual: CGY Over Time

Here’s how CGY might look in a graph for Case Study 1:

• X-Axis: Time (Months)
• Y-Axis: Stock Price ($)
• Plot the stock price movements over the year to show the climb to $150 and the drop to $90.
• Add annotations for CGY at the high ($150) and low ($90) points.

Why This Matters

These examples show that CGY is way to really understand how your investments are doing and what you should do next. Whether you’re riding out a volatile market or trying to decide if it’s the right time to sell, CGY gives you the numbers you need to make smarter moves.

Analyzing Capital Gains Yield with Wisesheets

If you’ve ever tried calculating Capital Gains Yield (CGY) manually, you know it can be a headache. Digging up historical stock prices, cross-referencing market data, and double-checking formulas? It’s a lot.

That’s where Wisesheets can save the day.

With Wisesheets, you can pull real-time and historical stock data directly into Excel or Google Sheets, automate calculations, and even screen stocks based on metrics like CGY.

Explore other tools like Yahoo Finance API to streamline your stock data gathering and analysis.

Here’s how it works:

Example Workflow: Automating CGY Calculations with Wisesheets

Let’s say you want to calculate the CGY for several stocks you own.

Step 1: Set Up Your Spreadsheet

1. Open a new Excel or Google Sheets file.

2. Create a column for the Stock Ticker and list your stocks (e.g., AAPL, TSLA, MSFT).

Want to take it further? Here’s how to create your own custom Excel stock screener.

Step 2: Use Wisesheets to Pull Data

• Add the Wisesheets add-in to Excel or Google Sheets if you haven’t already.
• In the next column, use the Wisesheets formula to pull the current price. For instance, this is the formula you would use to pull the current price for Apple:

=WISEPRICE("AAPL","price")

Check out this guide on how to retrieve live stock prices in Google Sheets.

Step 3: Manually Input Purchase Prices

Enter the price you paid for each stock in the Purchase Price column.

Example: If you bought AAPL at $150, type 150 into the row for AAPL.

Step 4: Calculate CGY Automatically

Use this formula in the CGY (%) column:

=((B2 – C2) / C2) * 100

• B2: Current Price (from Wisesheets).
• C2: Purchase Price (manually input).

Drag the formula down to calculate CGY for all stocks.

FAQs About Capital Gains Yield

What is the formula for Capital Gains Yield?

The formula for Capital Gains Yield (CGY) is:

CGY = [(Ending Market Value – Initial Investment) / Initial Investment] x 100

This calculates the percentage change in the price of an investment over time. If the result is positive, it means your investment has gained value. If it’s negative, your investment has lost value.

---

How does CGY differ from Dividend Yield?

Both CGY and Dividend Yield measure returns, but they focus on different parts of your investment:

• CGY: Tracks the growth (or loss) in the stock’s price over time.
• Dividend Yield: Measures the income you earn from dividends as a percentage of the stock’s price.

Learn how to screen for high-dividend stocks with our Dividend Stock Screener guide.

Example: If a stock’s price increases from $100 to $120, the CGY is 20%. If the same stock pays a $5 dividend, its Dividend Yield is:

$5 / $100 = 5%

---

Can CGY be negative?

Yes, CGY can absolutely be negative. This happens when the ending market value of your investment is lower than your initial purchase price.

Example:

• Purchase Price: $50
• Current Price: $40

CGY = [($40 – $50) / $50] x 100 = -20%

A negative CGY shows that your investment has lost 20% of its value – an indicator it may be time to reassess.

---

Capital Gains Yield: Turn Numbers Into Decisions

Investing isn't simple.

You’ve got to keep track of what’s working and what’s just dragging you down.

Capital Gains Yield (CGY) is how you figure that out.

It’s simple, it’s clear, and it tells you if your money is growing or if it’s time to make a change.

But of course, crunching those numbers on our own can be frustrating.

Tools like Wisesheets make it easier by pulling the data right into your workflow, so you can focus on strategy instead of spreadsheets.

In the end, investing is not just about growing your money but about staying in control and making decisions that actually get you somewhere.

CGY helps you do that.