Ever since I was a young boy, I’ve played the gridded sheet. From Lotus down to Excel, I know all embedded cheats. But I ain’t seen nothing like him, in any corporate suite… That deaf, dumb and blind kid sure types a mean spreadsheet! *
Many RBD readers have an obsession with spreadsheets, often creating ridiculous ones at the office in the guise of actual work. The infatuation with Excel or Google Sheets can get out of hand.
Especially when we build elaborate spreadsheets for tasks that can be handled by free software.
I’m guilty of this in a few ways. For the DRIPs I own, I keep a detailed worksheet tracking cost basis. Transfer agents are now required to track cost basis, so this activity is redundant.
For my checking accounts, I update a spreadsheet that balances my checkbook almost every day. Unnecessary.
Another is my now-retired net worth spreadsheet. I tracked my net worth on an intricate spreadsheet every month for 13 years. To update it, I logged into every account I owned, copied the balance, and pasted it into my workbook.
It was an onerous process.
Now I use Personal Capital. It’s free, and it tracks my net worth every day with no effort on my part (saves me about two hours a month). It’ kind of like Mint if you’re familiar with that, but way more powerful for investors and nerds.
I still build all kinds of spreadsheets. Some are one-offs. Others I maintain year after year.
But not everyone is a spreadsheet wizard. For those people, I’ve added a new feature to Retire Before Dad that I think you’re going to like.
10 Financial Calculators
He sits like a statue, becomes part of the machine. Feeling all the functions, always typing clean. He builds by intuition, his formulas so sweet… That deaf, dumb and blind kid sure types a mean spreadsheet! **
To help make this website more useful, Retire Before Dad has partnered with SmartAsset to provide access to a suite of calculators to help you achieve your financial goals. SmartAsset is a leading provider of slick and user-friendly interactive online calculators.
The startup offers a few dozen calculators on their website. I’ve tinkered around with all of them to determined which ones I believe are the ten most useful to my readers. Then I added them right to my website to make them easily accessible.
You can access the calculators from the tab on the main menu.
Simply choose the calculator you’re interested in, then plug in your numbers.
Each calculator is simplified. But you can always click the “methodology” link to learn more detail about each calculator. There’s also usually a link to a more detailed step by step calculator to walk you through it.
Here’s a quick rundown of the ten calculators. Use these to play around with your numbers and see how they can help you. They’re totally free to use. The software also throws in some selected vendors that may help you achieve your financial goals.
These work great on a desktop computer or your mobile phone.
The first calculator can be used to estimate the cost of living from one local to another. For example, I live in the Washington D.C. metro region. It’s expensive here. But what if we moved to Detroit? How much would our cost of living decrease? Could moving help us achieve financial independence earlier?
You can input your household income and family status to get a more accurate estimate.
Click here to check out the Cost of Living Calculator.
The Home Affordability calculator estimates how much money you can reasonably spend on a home. The calculator takes into account your location, household income, the amount you have saved for a down payment, and your monthly debts. From those numbers, it can determine how much house you can afford by estimating your monthly payment and other associated costs, as well as down payment and closing costs.
This a good starting point for aspiring home buyers.
Click here to play around with the Home Affordability calculator.
3. Income Tax
This next calculator estimates how much you should expect to pay in taxes and breaks it down over Federal, State, Local, and FICA. Make sure to select the advanced options where you can add in 401k, IRA contributions, and itemized deductions and exemptions.
As a tax nerd, I mostly approve of this one. However, it only covers two filing statuses and has no option for dependents which would alter your taxable income. This is another good starting point, but taxes are often much more complicated.
Click here to look at your tax liability with the Income Tax calculator.
The Investment calculator is a simple compounding formula that estimates the future value of an investment given five variables. Spreadsheets wizards and Finance majors will recognize this calculator as the FV (future value) formula in Excel. So it’s not as dynamic as some of the others, but the graphics give you a quick summary of the power of compounding. For that, it’s worth a look.
Click here to try a few numbers in the Investment calculator.
Parents of children should always have life insurance as part of a comprehensive estate plan. Even married couples can find comfort in a term life policy if both are reliant on each other’s income.
But shopping for life insurance can be daunting. When Mrs. RBD and I were expecting our first child, we found a provider through a third party site and bought it directly from the provider. However, our estimate for determining how much insurance we needed was off the cuff.
The Life Insurance calculator from SmartAsset gives a ballpark estimate of how much life insurance you would need. What I found experimenting with this calculator, is it seems to over-estimate the amount you’ll need. It does look at existing savings but doesn’t break out tax advantaged savings or home equity.
After you learn about how much life insurance you need, scroll down to get a price estimate on how much a policy would cost. There’s also a Life Insurance Cost estimator that I found helpful to get ballpark figures. Compare these numbers to a third party provider to see how they add up.
Click here to check out the Life Insurance calculator and the Life Insurance Cost Estimator.
Personal loan options have expanded in recent years thanks to innovated technology in finance. For example, through Lending Club, individuals can attain a loan of up to $40,000 over a three or five-year term. Rates are more competitive than banks because the rates are determined by supply and demand. Lending Club pairs borrowers in need and investors willing to loan the cash to fund the notes. It’s a marketplace for lending.
The Personal Loan calculator will tell you the monthly payment of a loan, the total amount paid, and total interest paid based on just three inputs. This calculator includes a graphical view of the loan balance over the term of the loan. It incorporates multiple financial calculations into one readable view.
If you have an idea of how much money you need for a personal loan, scroll down a little further and you can get a few quotes with just a couple of inputs and clicks.
Click here to check out the Personal Loan calculator and some estimates on loan rates.
Refinancing your mortgage is one of the six powerful (and low-risk) financial maneuvers that people can execute in their own financial plans to accelerate their path to wealth. I’m actually going through another refinance now. The numbers don’t lie. If it makes sense to refinance, do it. Just be sure to factor in the closing costs.
So I recently used this calculator for my own purposes. It’s a quick way to see how much savings a refinance can give you. The side-by-side comparison keeps it simple and it tells you if it makes sense to refinance.
I’ve also included a mortgage rate estimation widget to show you some ballpark mortgage and refinance rates.
Click here to compare your current mortgage to what may be possible. Doing so could save you a bundle.
The Retirement calculator is one of the most popular on RBD so far. This one takes in five variables and calculates what you’ll have saved at your retirement age versus what you’ll need.
These numbers are mostly on the mark. However, it assumes you’ll need to maintain your current income level into retirement. If you save half of your income, you’re living on half your income. So you won’t need as much. So this calculator is helpful, but I think it over-estimates again how much you’ll actually need at retirement.
Click here to run your own retirement scenario through the calculator.
The Social Security calculator is probably the most accurate estimate because it’s based on the actual Social Security numbers available from the government. Just type in your annual income, birth year, and the year you plan to take Social Security. Presto! It spits out the annual income that Social Security is projected to provide.
Click here to check it out.
10. Student loan
Lastly, I think a lot of younger readers will benefit from the Student Loan calculator. This nifty visual is useful to see exactly how long it will take to pay off loans.
I’ve never had student loans myself as I was fortunate to have parents that paid for my education (and I am planning to pay for my kids’ college). But I know student loan debt is a ball and chain for many college graduates.
This page also includes some options for finding ways to refinance your loans and lower the interest rates and payment amounts.
Click here to get on that road to paying off student debts!
Conclusion – Are You A Spreadsheet Wizard?
He’s a spreadsheet wizard, there has to be a twist. A spreadsheet wizard’s got such a supple wrist! ***
For readers who may not have that “supple wrist” on the keyboard, take a look at these calculators by SmartAsset to see if you can improve upon your current personal finance situation. We all can improve all the time.
Perhaps spreadsheets will eventually go the way of the dodo bird for a lot of people. Simple online calculators can do just as good job as a spreadsheet, albeit, without all the awesome and nerdy customization.
* Satirical quotations inspired by Pete Townshend of The Who, and the song “Pinball Wizard” from the album Tommy.
** Read the real Pinball Wizard lyrics here.
*** Music fans will love the video below of The Who performing the song in 1969.
What about you? Are you a spreadsheet wizard or do you prefer GUI calculators?
Featured Photo via Pixabay CC0 Public Domain