UnThreaded | Threaded | Whole Thread (2) | Ignore Thread Prev | Next
Author: PosFCF Big gold star, 5000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 449283  
Subject: Re: average rate of dividend return Date: 2/27/2013 8:32 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 7
My dear METAR minds is there a simple formula to calculate my average percent of return across my portfolio? I look at my holdings and estimate my average dividend return to be around 5.5 percent, but of course each holding has a different weighting and different payout percentage then the next and I think I could easily be off by a half percent or more. Thanks bcTim.

Two ways come to mind: Easiest & not too tough

Easiest would be if all of your holdings were in dividend paying companies: Add up all the interest paid for the year then divide it by the total cost of buying those companies....multiply the answer by 100 to get the percentage yield.

Not too tough has a little more to it but, with calculators is still not that hard. Add up your portfolio (even those that don't pay a dividend) that number becomes the denominator (divisor) in each of the following equations. Then take the amount invested in one entity, divide it by the total and then multiply that answer by the interest rate expressed as a decimal. To put it mathematically: Interest rate X (investment in company/total investments) = weighted interest rate.

Numerical example: Assume $25,000 invested in company A which pays 3.5% dividend and $32,000 invested in company B which pays 5% dividend.

The total invested is $57,000 (gotten by adding $25,000 +32,000)
3.5% and 5% would be converted to the decimals .035 & .05
Now the math:
.035 X (25,000/57,000) = .015
.05 X (32,000/57,000) = .028
.015 + .028 = .043 = 4.3% which is your dividend rate for the 2 company portfolio.

Do this for each holding and then add all the weighted returns together to derive the weighted rate for your portfolio.

Microsoft Excel, if you have it, makes this job easy but plain old pen and paper is not really that much tougher.

Poz
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (2) | Ignore Thread Prev | Next

Announcements

2013 Feste Award Voting Begins!
Who will win the 2013 Feste Award? Vote now for the Fool that most exemplifies the Fool Community mission of Learning Together!
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Post of the Day:
Tax Strategies

TMFPMarti-Feeling Good
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and "#1 Media Company to Work For" (BusinessInsider 2011)! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.
Advertisement