I RECENTLY LISTENED to a podcast featuring Richard Thaler, the Nobel prize-winning economist. To say I’m a huge fan of his work is an understatement. Thaler has that rare ability to communicate a complex topic—behavioral economics—to a lay audience in a way that’s both accessible and enjoyable. His book Misbehaving offers a fascinating historical account of behavioral economics, a field he played a major role in developing.
But it was a casual comment that Thaler made toward the end of the interview that really caught my attention. Podcast host Meb Faber asked him for some best practices for teaching personal finance to high school students. Thaler suggested replacing subjects like trigonometry—with near zero practical value—with more useful ones, such as teaching students how to use a spreadsheet.
Use a spreadsheet. It suddenly dawned on me just how heavily I’ve relied on spreadsheets throughout my life, particularly when it comes to personal finance. So many financial questions are ripe for analysis through the use of spreadsheets. The following is a list of nine problems for which I’ve depended on them. Some of the resulting spreadsheets were relatively simple, while others devilishly complex.
Looking for help creating a spreadsheet? Microsoft offers a slew of Excel templates that are available for download.
Many of my HumbleDollar articles—and the financial analyses that underlay them—would never have seen the light of day if it weren’t for spreadsheets. Of the 24 articles and blog posts that I’ve written so far, a full quarter of them relied on spreadsheets in some manner. In particular, this article, this one and this one were essentially spreadsheets disguised as prose. These articles also happen to be among my favorites.
How often have I used trigonometry in my finances? Meet the null set.