Math was never my strong subject. In high school I never took algebra or anything beyond arithmetic- there is an archaic word for you. When I ventured into college many years later I had to take a non-credit course in algebra to get accepted. Years later calculus was required. I liked the course so much I took it twice. It didn’t matter that the professor barely spoke English. I didn’t understand her or the subject.
Here I am 55 years later and still looking for an occasion to use algebra or calculus. There was one time I wish I had paid attention though.
I was presenting a executive compensation plan to the company Chairman. He was using a whiteboard to analyze what I was proposing. There were formulas all over the place. I finally gave up the charade and admitted I had no idea what he was talking about. Good thing it was the year before I retired.
This leads me to the fascination with spreadsheets for personal finance and retirement planning. Back in the day I had a modest ability to use Excel. A few years ago I actually attempted to track our spending using Numbers on my iPad. I concluded it didn’t tell me anything I didn’t intuitively know – we lived well within our means – which to me simply means we saved adequately and never carried credit card debt.
Besides, I had to keep entering stuff to make the spreadsheet do anything. If I tried to project the future, the assumptions were all up to me – and I kept changing them. I figured out you could achieve any goal with just a tweak to you assumptions. Annual rate of return? Click up. Inflation rate? Click down 🤑
My hat is off to those who like spreadsheets, even calculus. No doubt spreadsheets provide a measure of comfort, perhaps a reassurance about their financial future – or it’s nearly hobby. If you happened to be an engineer, I understand.
For me going into my bank app tells me how I spent money last month via charges, direct bill withdrawals, checks (very few) and ATM use. It doesn’t know how I used the cash withdrawals, but does it matter?
Perhaps my dislike for and skill deficiency with math is the reason I like money stuff simple and high level. So far the seat-of-the-pants approach has served me well.
I’ve already said my piece on spreadsheets: https://humbledollar.com/2023/09/driven-by-data/
The article notwithstanding, my financial spreadsheets were more useful when we were driving toward a goal of financial independence. Reaching retirement, I find the data is less interesting to me. For you, Dick, your monthly cash flow is so much higher than your monthly needs that a spreadsheet is not useful to you. No need to worry about margins; you know you have “enough.” And if they’re not fun for you, why bother? I get it.
Excel rocks. I love the Microsoft 365 version which can look up stock, ETF, or fund prices. I’m stuck with assets split between Fidelity and Vanguard until 2030. Excel makes it easy to have a consolidated view of net worth and pre-Social Security income. After that, life gets simpler and Excel may get to take a break.
The key word is “consolidated” which to me makes sense. Exactly why I consolidated with Fidelity and they do the work.
Spreadsheets are a useful tool that can be as simple or complex as you like. You don’t have to be good at math to use a spreadsheet. I wouldn’t be as effective in nearly every aspect of my life without them.