Stock market appreciation calculator

It also has Consumer Price Index CPI data integrated, so it can estimate total investment returns before taxes. It uses data from Robert Shiller, available here.

Stock Calculator for Calculating Return On Investment from Shares

Do you want to model fees, periodic investments and taxes? For a complete list of all our calculators, for investing and otherwise, go to this page. Professor Shiller lists his methodology on his site — all values internal to this tool use the values he provided. Let me say that again in a different way: Also, important since it comes up often in the comments: Is this completely accurate?

Deal with it — over a long enough period the dividends will roughly balance out. We also present this data from the perspective of average return over various time periods. A Treasury Return Calculator using the same data can be found at that link. Or, try our popular individual stock Graham Number calculator or our individual stock dividend reinvestment calculator.

Does it mean a lot to include reinvested dividends? It seems shabby, but the effect is much more pronounced over longer periods of time. Consider from January until April the return was 8, To Robert Shiller, of course, for posting his data publicly.

To Ken Faulkenberry at Arbor Investment Planner for finding an error with the dividend calculation in an earlier version of the tool — yes, everything was off by a factor of 12 with dividends.

Sorry folks, and thanks Ken for pointing it out! Featured , Investing Tagged: I of course agree percent that dividends need to be included. Are the numbers here inflation-adjusted? I believe that Shiller uses inflation-adjusted numbers. So I am assuming they are. I believe their info adjusts for dividends. But your tool makes it simple. I just made two indices and kicked it out as XML and wrote the script. Let me know if you think of any other high value calculators — I want to increase the inventory on the site, haha.

My experience tells me that it will start two new arguments for every one that it settles. Sadly, I saw this in many financial advisory offices. Thinking out loud and off the cuff: It seems like it encourages the status quo.

Jen Master the Art of Saving says. Marie at FamilyMoneyValues says. Leave it to a programmer to try to break it….. Sorry for the laziness. This is a really great tool. Thanks for making it available. I am getting a bad data result. Looks like all October — December data sets are returning those results, no matter the year.

A really useful tool would be to have a listing of funds and hedge funds with their published monthly performance numbers. If you have a bead on it, send it my way. I put Jan start date and Dec end date then hit calculate. Why would there be a 1. Great tool by the way!

But this calc shows annualized Div reinvested jan-dec as A couple reasons — Jan-Dec is only an 11 month period in the tool. You should try Jan-Jan or Dec-Dec for a better read. Thanks so much for sharing this tool. I could add the dividends up, but I thought time value and CPI impact might be worth including — but I am probably just out of my depths here.

In any case, the tool above is great and will suffice. Index prices he updates on a monthly basis, but he used to interpolate from yearly data. You should check out his site for details. I have the same question. For example, if I choose November as a beginning date, am I beginning with November 1, November 30 or something else?

I stumbled across you calculator a few weeks ago and very much appreciate having it available. Just trying to better understand what I am seeing. The TR data only goes back to Maybe a better way to ask the question is to ask what it means to choose a particular month as the beginning month. Does the calculator include the data for the month chosen, or does it begin with the data for the following month?

Or, does the calculation create a beginning point in some other fashion? Before mutual fund prices became easily available on the internet, I used to call the fund companies automated response numbers to get NAVs for our funds. Anyway, it sounds like when I plug in Nov. Is that at least approximately correct? You could use this tool to get benchmark returns up until when that index begins, then move to the day to day index for more recent market returns.

A link and a question. I have no idea how accurate it is. It does provide specific date values for the index for several years. I am only interested in the last six or so, but it appears to go back at least 10 years, if not much further. Any knowledge of where the data comes from or how accurate it is? Click calculate should provide value of total nest egg.

Link to details which shows each deposit with value of total nest egg compounded up to that date and final totals Total Principal Invested, Capital Gains and if Dividends were re-invested then what would it be. What would it take to include performance comparisons for the Dow Jones Industrial Average, Russell , etc. Do these numbers makes sense?

When I calculate total return for the period Nov. But a compounded return of 9. I got the Shiller data and calculated in excel, tried the maximum jan to october , and got nominal 4. For the dividend reinvested case I got 5. To get the number 9. Please check that you have reinvested the dividends in your calculation. I Have found error in my calculation, now I get the same as you 9. Best to start buy some stocks! This is an awesome tool — much appreciated for taking the time to build the page here and make it public.

What would be an awesome addition to this is to factor in 2 more things. I realize that qualified plans may have taxes deferred, but I use this calculator to weigh different options in my regular accounts which are taxed every year. Is there any way to factor in an understandable year over year tax effect assuming that a certain percentage of the portfolio will be taxed due to mutual fund, index re-weighting etc? Further, there are always expense loads — they may be low, but they are there and still parasitic.

As if everyone participating in the market should have HOPE as the key ingredient in their portfolio. We need to see more financial literature pointing people in the direction of realistic returns and this calculator is an awesome step in that direction.

While you are right that tax treatments matter for folks investing outside tax advantaged accounts, different tax rates and commissions paid for shares makes a huge difference in returns. Even with those caveats, we stand behind our numbers and disagree that hope is the only thing that makes equities beat commodities — even if typical investors would never match those returns.

The total returns I found were way too high to be real, so I took a look at the dividends for SPY and VFINX, both of which are supposed to replicate the SP What are your thoughts on this?

The only way to get more exact than that would be to find someone who bought an index fund at your start date, reinvested through today, and never pulled money out — otherwise these estimates are as good as it gets and I would feel comfortable using them. However, I think the problem was mine. Thanks for your quick feedback; it convinced me to take yet another look. The simplest to get you started would be to simply divide by 12 for the listed dividend, and treat that as correct for the month.

Shiller has a brief note on data adjustments on this page: Right, I can see the interpolation approach Shiller takes in his spreadsheet. However, you seem to have a more accurate read of the quarterly dividends.

Can you tell me if you arrived at your quarterly dps data by researching the underlying stock payouts or by disaggregating the trailing month average in some way? If the latter, did you use a math approach directly on the moving average, or detect a pattern in the percentage of annual payout that occurs each quarter. Thank you for any insight you can give me. Would still be interested in knowing if you used a different approach. Some not interesting DQYDJ history: I hesitate to answer as it changes every month — but as of I would like to rephrase my original question, since I see now that the data is quite understandably not available immediately….

I think that with the addition of a note indicating how the period is calculated this tool would meet the needs of the vast majority of users. No, that is not correct, there are no individual dates in this tool other than the most recent month temporarily, which is revised when data becomes available.

Would be great if you could add an extra input to deduct tax on dividends. If you could add another box to take this into account that would be perfect. Others out there would probably like to have a capital gains tax deductor too not important for my purposes. And my true weighted return, given the timings of moneys into investment account, is Look at monthly log charts for true picture.

Speculate also but be ruthless on cutting losses and taking profits on speculative stocks eg TWTR, small biotech, Chinese internet, YELP. Try to avoid bottom fishing except at bottom of major recessions.

Where I lost money: Feed winners, starve losers. If you would like to do a custom calculation, your best bet is to build it bottom up in something like Excel or OpenOffice. This is a very interesting tool. I am trying to understand the proper way to calculate the return of a stock over one year including reinvested dividends. I am doing this on excel. Is there any way you could help? At that point, you can do the math here — total return, annualized return, etc, since you have a beginning and an ending price, as well as a time period.

I am doing some similar analysis and am finding that I cannot replicate your results for the reinvested calculations. Can you please provide a simple example calculation. Such as for the period from January to February See this post for methodology: Buy one share at 4.

SWKS - Skyworks Solutions Inc Stock quote - efulejeqih.web.fc2.com

Now just repeat and your numbers should match the tool. It seems there is a discrepancy between the results of your calculator and other sites. But I see Your numbers say There are some interesting discussions on this issue in the comments and the methodology, but it boils down to the Shiller data — in short, none of the months mean any specific days. To get an approximation here, you can do Jan-Jan or Dec-Dec, as that would cover approximately 12 months.

Hi, I love the information this provides and cannot find anything better on line. However, I have a question for you: I understand fees and taxes would not be subtracted. What if you added a box for amount of original investment, and a box for amount of current value without taxes and fees deducted?

Or, maybe I am misinterpreting the purpose of this calculator? Thank you for putting this on line! I thought this information would be easy to find, but even sites like vanguard do not have a calculator like this one. To do the math, remember that the number quoted is the gain, not the total amount. I love your calculator. Thank you so much for providing this awesome tool. I have adjusted the data for dividend reinvestment per your earlier replies thanks also for this information and have graphs of price and dividend reinvested value.

I would also like to plot Inflation CPI adjusted data. How do I add these values to the spreadsheet? The calculator itself only needs to do the math once, for the start and end point — but you would be better served by adjusting each month.

Thanks for the help. I did the calculations exactly like you said, and then realized my calculations matched Column H, Real Price. I just did not know what Column H Real Price was. I also have a similar Trend Chart but not CPI adjusted vs. Adjusting for CPI really makes the data fit nicely. Thanks again for your help and your great calculator.

I used the calculator to help debug and as a sanity check on my calculations.

And thanks to Shiller for providing the data. I would be happy to share my Excel Chart with you if you would provide me with an email address or drop box so I can get it to you.

In my case I can ignore investment costs; I have my money in a very low cost mutual fund. I can also ignore taxes for now; it is all in retirement accounts.

Kudos on the calculator.

Is there a way for you to provide an add on to show month by month performance if desired? Thanks for creating this tool. So is it appropriate in this circumstance to adjust for inflation or not? It seems to me that the accumulated benefit should ignore inflation. I turn caffeine into useful tools and interesting posts. I also designed and started Don't Quit Your Day Job We're a finance blog with a twist: Comments Untemplater says Neat stuff PK! Thanks for making this.

Sorry about that Kristin!

Thanks for reporting that bug. Thank you so much for the tool. I use it to compare the returns hedge funds achieve! What day of the month is used in the calculator? The first day or the last day? Hi Ted, thanks for being a fan! Sorry, ran out of characters. Thanks again for making this available. What would be cool is to show the power of compounding. In other words, enter the following — Amount Invested — Period Weekly, Bi-Weekly, Monthy or Quarterly — Date of First deposit Click calculate should provide value of total nest egg.

Good looking out, and thanks for reporting it — fixed this while adding the May data. Thanks for the comment! Very need tool you have created! If I wanted to see the return Jan. PK What a eye opener. Thank you for making this information so easily available. And I, too, would like to thank you for this very useful tool! Thanks for this useful tool. Yes, thank you so much! Hello, I am doing some similar analysis and am finding that I cannot replicate your results for the reinvested calculations.

Thanks, I am looking forward to it. In any event, great tool!!!!! Trackbacks Blog Post of the Week!

Stock Market Income Tax Calculation

Carnival of Financial Camaraderie - Mother's Day Edition One Smart Dollar. My Momma Told Me Edition Well Heeled Blog. Carnival of Wealth, Tim Duncan Edition Control Your Cash: Making Money Make Sense.

Self Directed Investing For Retirement Carnival — Bear Market Rally is Over. Carnival of Passive Investing - Mayday! Beating the Market is Simpler Than You Think Bank The Money, Bets That Can't Lose, Bonus Bagging. Super Bowl Advertising Rates Top The Stock Market - Forbes. Investing in index funds and the strategy Save.

Math Suckage and Dave Ramsey Above the Market. Calculating total annual returns My Financial Independence Journey. The Case for Investing in Gold The Wealth Papers. Surviving a Series of Unfortunate Events - MarketShadows. Adventures in art-market commodification, James Stewart edition Felix Salmon. This is the reason why. What Your Car Says About Your Investing Style And Money Making Acumen Financial Samurai. Should You Buy Many Lottery Tickets for One Drawing, or A Few Tickets For Many Drawings?

Christian Investors Should Take A Stand For Workers. Most Americans Pay Their Children an Allowance.

Stock Appreciation Right (SAR)

Join Our Mailing List Today Enter your email address Contact PK Follow PK on Twitter. How Long Will Your Relationship Last? Why More Hours Means More Money in America. Why a Flatter Tax Code is Better The No Math Edition!

Bond Yield to Maturity Calculator All About Credit Cards and the Perfect Credit Card Spending Strategy The Aspirational Class: How Many Accredited Investors Are There in America? Compound Annual Growth Rate Calculator CAGR. Recent Comments Paul on How Round Number Bias and Psychological Pricing Affect Your Gains and Spending Mrs.

Picky Pincher on How Round Number Bias and Psychological Pricing Affect Your Gains and Spending Clint on How Round Number Bias and Psychological Pricing Affect Your Gains and Spending Mrs. PK on A Raspberry Pi Hadoop Cluster with Apache Spark on YARN: Big Data Lily The Frugal Gene on What is the One Percent and Median Millennial Income Per State? Dave on A Raspberry Pi Hadoop Cluster with Apache Spark on YARN: Quick Links Contact Us Advertise on DQYDJ Disclosures Recent Posts.