Capital Gains Yield Formula (Table of Contents)
 Capital Gains Yield Formula
 Capital Gains Yield Calculator
 Capital Gains Yield Formula in Excel (With Excel Template)
Capital Gains Yield Formula
Where,
 P0 = Initial Stock Price
 P1 = Stock Price after First time period.
The formula of capital gains can be stated as the ending price divided by the initial price minus one. Again the alternative formula is a rearranging of the capital gains yield formula shown earlier.
Capital Gains Yield Formula = Delta P / P0.
Capital games yield denotes the absolute return of a stock based on the appreciation of that particular stock after purchasing. The formula of capital gains yields is calculated by excluding the dividend paid by the stock. The dividend yield can be calculated by dividend yield formula. Combining capital gains yields and dividend yield we get the total return from this particular stock. Capital gains it is primarily used to calculate the rate of change of the stock price only. The rate of change can be found by subtracting the end amount from the buying price and then divided it by the original amount.
Examples of Capital Gains Yield Formula
Example #1
Rajesh bought a share of Marico Ltd @ INR 600 on 1st January 2015. At the End of the year, the appreciated by 50% and the stock price was quoting at INR 900. Marico has announced a dividend of INR 12/ share during the end of the calendar year 2015. Calculate the Capital Gains Yields.
The Capital Gains Yield for the above investment is calculated as:
 Capital Gains Yield Formula = (P1 – P0) / P0
 Capital Gains Yield = (900600)/600
 Capital Gains Yield = 300/600
 Capital Gains Yield = 0.5 or 50%
The Dividend Gain Yield for the above investment is 12 /600 = 0.02 or 2%
The total return from the investment is 52%
Example #2
Mr. Jagmohon bought TATA Steel Limited on 1st April 2017@ INR 550/ share and sold @ INR 450 on 31st December 2018. TATA steel has allotted a dividend of INR 2/ share during the period. Calculate the Capital Gains Yields.
4.5 (586 ratings)
Since Mr. Jagmohon sold TATA Steel at a loss of INR (550450) or INR 100, there has been no capital appreciation and there is no capital appreciation in the Books of Mr. Jagmohon. So the Capital yield formula is not applicable here. TATA Steel has announced a dividend of INR. 5.5/ Share during that period.
Again, as the dividend does not comprise a substantial portion of the stock so there is no scope of capital appreciation too. Thus the capital Yield formula is not required.
Thus capital yield formula would be NIL. But Dividend yield ratio would be 5.5/550= 0.01 or 1%
Note: There might be a situation where there is no announcement of dividend by the particular Stock and thus, Dividend yield ratio will not be valid at that point.
Example #3
Yami wants to see how much she has earned on a particular stock only on the basis of capital appreciation/depreciation. She has seen that when she has bought the stock, the price was INR 100. Now, after 2 years, the price of the stock has appreciated to INR 200 per share. What is the Capital Yield on that particular stock?
The Capital Gains Yield for the above investment is calculated as:
 Capital Gains Yield Formula = (P1 – P0) / P0
 Capital Gains Yield = (INR 200 – INR 100) / INR 100
 Capital Gains Yield = INR 100/ INR 100
 Capital Gains Yield = 1 or 100%
Thus there has been a capital appreciation of 100%
Explanation of Capital Gains Yield Formula
 The requirement of capital yield formula used when there is a change in the buying price of a stock and with the selling price of the particular stock within a oneyear time frame. When a stock price appreciates and the holder of the stock sales at a premium price and the difference of the amount is entitled to a shortterm capital gains tax.
 The calculation of capital yield is done by subtracting the buying amount from the ceiling amount and dividing it by the buying amount multiplied by 100. Thus we get capital gains yield at absolute percentage terms.
 If security cannot generate a positive return that is the selling price is higher than the buying price then there is no point of capital gains. There might be several instances where the dividend healed ratio is higher but the capital gain is Nil.
 Again or stock may deliver lower dividend yield but there might be a capital gain. In that cases, the stock price reflects the company’s growth instead of getting it distributed through a dividend.
Use of Capital Gains Yield Formula
 For each and every investor capital gains used to be one of the prime aspects in calculating the premium value received against a stock. If there is a good growth story by the company then the stock price will reflect a premium price and the appreciation is being reflected by through the stock price.
 In practice, most of the companies don’t pay dividends in spite of higher profitability growth in each and every year. The undistributed dividends get compiled within the profits of the company. Thus the price of the stock denotes the absolute return in form of the stock price.
 Thus there is no dividend yield ratio for the investor. Show all the growth of the company is being reflected from the appreciation of the stock price in the stock market. Thus the absolute capital gain yield can only be reflected through the difference in buying price and selling price of the stock.
Capital Gains Yield Calculator
You can use the following Capital Gains Yield Calculator
P1  
P0  
Capital Gains Yield Formula =  
Capital Gains Yield Formula = 


Capital Gains Yield Formula in Excel (With Excel Template)
Here we will do the same example of the Capital Gains Yield formula in Excel. It is very easy and simple. You need to provide the two inputs i.e Initial Stock Price and Stock Price after First time period
You can easily calculate the Capital Gains Yield using Formula in the template provided.
First We Calculate Capital Gains Yield Using Formula
Then We Calculate Dividend Gain Yield
You can download this Capital Gains Yield Template here – Capital Gains Yield Formula Excel Template
Conclusion
Dividend yield and Capital gains yields are required in case of appreciation of a stock price. A growing business in most of the cases gives a scope of capital appreciation for the shareholders. Yields refer to the profits generated after selling a particular stock at a premium price over a period of timebased on the invested amount and is measured by the excess cash flow received by the investor after investing on security. In most of the cases, a yield is computed on yearly basis and in extreme cases yields are calculated on a halfyearly and quarterly basis.
Recommended Articles
This has been a guide to a Capital Gains Yield formula. Here we discuss its uses along with practical examples. We also provide you with Capital Gains Yield Calculator with downloadable excel template. You may also look at the following articles to learn more –
 Future Value Formula Examples
 Risk Premium Formula With Template
 Guide to Preferred Dividend Examples
 Calculator of Preferred Dividend Formula
Financial Analyst Course All in One Bundle
250+ Online Courses
1000+ Hours
Verifiable Certificates
Lifetime Access

Investment Banking Course

Financial Modeling Course

Equity Research Course

Project Finance Course

Business Valuation Course
Leave a Reply