to your HTML Add class="sortable" to any table you'd like to make sortable Click on the headers to sort Thanks to many, many people for contributions and suggestions. Licenced as X11: http://www.kryogenix.org/code/browser/licence.html This basically means: do what you want with it. */ var stIsIE = /*@cc_on!@*/false; sorttable = { init: function() { // quit if this function has already been called if (arguments.callee.done) return; // flag this function so we don't do the same thing twice arguments.callee.done = true; // kill the timer if (_timer) clearInterval(_timer); if (!document.createElement || !document.getElementsByTagName) return; sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/; forEach(document.getElementsByTagName('table'), function(table) { if (table.className.search(/\bsortable\b/) != -1) { sorttable.makeSortable(table); } }); }, makeSortable: function(table) { if (table.getElementsByTagName('thead').length == 0) { // table doesn't have a tHead. Since it should have, create one and // put the first table row in it. the = document.createElement('thead'); the.appendChild(table.rows[0]); table.insertBefore(the,table.firstChild); } // Safari doesn't support table.tHead, sigh if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0]; if (table.tHead.rows.length != 1) return; // can't cope with two header rows // Sorttable v1 put rows with a class of "sortbottom" at the bottom (as // "total" rows, for example). This is B&R, since what you're supposed // to do is put them in a tfoot. So, if there are sortbottom rows, // for backwards compatibility, move them to tfoot (creating it if needed). sortbottomrows = []; for (var i=0; i
In the United States, 30-year mortgage rates play a big role in determining how affordable housing is for American households.
As important as they are however, the historical data for mortgage rates is surprisingly lacking. Freddie Mac, officially known as Federal Home Loan Mortgage Corporation, only has weekly data extending back to April 1971. The government-sponsored enterprise used to report monthly averages for mortgage rates, but that discontinued that practice after December 2022.
And yet, because housing sales and prices are reported on a monthly basis, it's incredibly useful to have mortgage rates averaged over the period of a month. Since Freddie Mac isn't doing that job any more, we're taking it over. Not only that, we're making all that historic data freely available!
It's built into the following interactive chart, which visualizes 52 years worth of the average monthly interest rates for 30-year conventional mortgages in the U.S.
Some quick observations:
We plan to update the chart every few months. If you are looking to find a recent month's average rate that hasn't yet been included, see the references....
Freddie Mac. 30-Year Fixed Rate Mortgages Since 1971. [Online Database]. Accessed 23 May 2023. Note: Starting from December 2022, the estimated monthly mortgage rate is taken as the average of weekly 30-year conventional mortgage rates recorded during the month.
Image credit: Mortgage Payment Due date by alanharder.ca via Wikimedia Commons. Creative Commons Attribution 2.0 Generic (CC BY 2.0).
Labels: current, data visualization, real estate
Did you ever wonder how much money you could earn in the form of cash dividends if you were invested in the S&P 500 (Index: SPX)?
Josh Scandlen of Heritage Wealth Planning did, discovering he could use one of our signature tools, The S&P 500 at Your Fingertips, to extract the information he was after. He put together the following 14 minute YouTube video to explain both how dividends work for you as an investor and how to get cash dividend payout information from our tool:
After watching the video, we had two thoughts:
Long time readers will already see where this discussion is heading! We've built a new tool, one that ties directly into the quarterly dividend data that Standard & Poor reports in spreadsheet form for its heralded S&P 500 index. In it, we put you in the shoes of someone who has either just bought into the index or has just flipped the switch to begin collecting cash dividends from it during the month ending a historic calendar quarter.
Based on the value of the investment at that point of time, it estimates the equivalent number of shares of the S&P 500 you own. It then calculates how much dividend income you would have collected at a later point of time, assuming you never sell any of the shares you own. It will also tell you how much your investment in the S&P 500 is worth at that later point of time you selected.
But that's not all! The tool also extracts how much you would have earned in dividends during the first calendar year of your investment, during the final calendar year, and also during any calendar year that might interest you in between. It will also identify the highest and lowest amount of dividends earned in any calendar year throughout your full period of interest.
If you're ready, here's the tool. If you're reading this article on a site that republishes our RSS news feed, please click through to our site to access a working version of the tool.
We've set the default data in the tool up to reflect the example Josh Scandlen worked in his video, but we've made all the quarterly dividend data we have for the S&P 500 and its predecessor indices and component stocks going back to 1871. If you want to see that historic data, you can access it either through our The S&P 500 at Your Fingertips tool, which is updated monthly, or at our Quarterly Data for the S&P 500, Since 1871 resource, which we update annually.
Speaking of updates, we plan to update this tool in January 2023 after 2022's dividend data is available, then quarterly afterward.
Using the tool, we recommend selecting different periods and paying attention to when the lowest annual dividend payout data differs from the first year's data. The idea here is that you would want your investment to handle a worst case scenario when the market experiences a major downturn. While this will depend on what periods you might cover, we found that 1896 and 1933 represent major low points for a multi-decade investment holding period.
That said, we're celebrating our anniversary today, and what better way to do it than building on the capabilities of a tool we featured in one of our earlier anniversaries!
Our anniversary posts typically represent the biggest ideas and celebration of the original work we develop here each year. Here are our landmark posts from previous years:
We marked our 2013 anniversary in three parts, since we were telling a story too big to be told in a single blog post! Here they are:
Resuming our list of anniversary posts....
Labels: current, dividends, ideas, investing, SP 500, stock market, tool
Have you been saving for retirement and are now ready to retire? What would happen if you withdrew a fixed percentage of the value of your retirement investment once a year for the rest of your life, if that investment was in the S&P 500? Would that provide enough money to pay for the things you might want to buy with it after you no longer have an income from a job? Or might market volatility force you to reconsider your options?
These are difficult questions to answer, because the future is very much an undiscovered country, where chaos controls both the timing and magnitude for when and how much market volatility might erupt.
But if we assume the unfixed future might be like the past, we can test how well a strategy to only withdraw a fixed rate of money from such an investment would have fared using the S&P 500's rich history of data during its most turbulent episodes.
And that's what we've done with our latest tool, where you can see how well you could count on your investment in the S&P 500 would have fared for up to 40 year long periods if you had chosen to retire in any month between January 1871 and 40 years before the present* while fully reinvesting your dividends along the way. If you're accessing this article on a site that republishes our RSS news feed, please click through to working version of the tool at our site.
For our tool's default settings, we've chosen September 1929 as the time of the first withdrawal, because this month immediately precedes what happened with the U.S. stock market at the onset of the Great Depression. If your S&P 500 cash out strategy can survive the sustained series of disruptive events that followed this month and provide sufficient funds to support your needs, you can reasonably expect to weather any lesser event.
For good measure, you might also want to consider how your retirement might fare if a market crash occurred well after you've retired. You might choose a date that includes the years of the Great Depression or you could choose the more recent disruptive event of the Great Recession of 2008-2009 by selecting a starting year in the range of the late 1960s through the late 1970s. The maximum length of time the tool will consider for your S&P 500 withdrawal strategy is 40 years.
The tool's results indicate the value of your investment in the S&P 500 before and after your annual withdrawal, along with our estimates of the total amount you would have withdrawn over the number of years you've selected, the average amount of your annual withdrawals, and also the highest and lowest values of your annual withdrawals along with the years in which they would have occurred. Meanwhile, the tool does not consider things like taxes, commissions, or fees, which would most likely be taken out of any money you withdraw if they apply.
* Like our S&P 500 At Your Fingertips and Investing Through Time tools, we plan to periodically update this tool, with the first update in the first quarter of 2020 after the S&P 500's data for 2019 is finalized, and then once a year afterward, which will allow us to roll in new 40-year long periods.
The tool above really doesn't say anthing about what a "safe withdrawal rate" for you may be. For that kind of insight, do check out the following resources on the topic, which you might find useful.
Hubbard, Carl; Cooley, Philip L.; and Walz, Daniel T. Retirement Savings: Choosing a Withdrawal Rate That Is Sustainable. Journal of the American Association of Individual Investors. [Online Article]. February 1998.
Pfau, Wade. The Trinity Study and Portfolio Success Rates (Updated to 2018). Forbes. [Online Article]. 16 January 2018.
RBC Wealth Management. Sustainable withdrawal rates in retirement. [PDF Document]. 25 March 2019.
Where our tool is concerned, so long as you select an annual withdrawal percentage rate of less than 25.0%, your investment will effectively last forever because there will always be some fraction remaining in your investment from which you can withdraw some percentage of it in future years, even though the withdrawal amounts may become vanishingly small, which can be considered the investment math version of one of Zeno's paradoxes.
In practice, you may find it extraordinarily difficult to resist raising the percentage of your investment that you cash out in years where market volatility might crash the amount you would withdraw if you otherwise maintained a fixed percentage rate of withdrawal, where you would intervene to reset that withdrawal rate because you've come to value having cash today more than whatever potential investment value you might have tomorrow. If you need cash to cover your living expenses in retirement or in times of severe economic distress, where your ability to earn income is very limited, it's very understandable.
Our tool can accommodate that kind of decision making. Just update it with the value of your investment at the starting month where you would need to adjust your withdrawal rate, and see what happens next. Then adjust it again at later dates as you might need.
Image credit: Max Harlynking
Our anniversary posts typically represent the biggest ideas and celebration of the original work we develop here each year. Here are our landmark posts from previous years:
We marked our 2013 anniversary in three parts, since we were telling a story too big to be told in a single blog post! Here they are:
Resuming our list of anniversary posts....
Labels: chaos, current, personal finance, SP 500, tool
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.