I maintain an all-in-one personal finance companion that I use alongside my budget to acquire a holistic view of my finances, forecast the future, and analyze different scenarios.
Why you need it
- Allows you to keep track of everything in one place (and link information together).
- It is fully dynamic, requiring very few inputs to calculate everything you want to see.
- It is lightweight (~ 1MB).
- The feature set continues to grow.
Why spreadsheets (and not an app)
Spreadsheets are extremely versatile and allow you to edit the tools and reports as desired whereas an app is very limiting in the changes you (the user) can make. I want you to retain full control and usability over how you approach your finances.
An additional benefit is not having to share your private financial information with a third party!
How to get it
You can acquire the PFC in one of two ways:
Access to the file comes with free lifetime updates.
Full feature set
Keep track of some high level information in one place (some of which flows through the file into other sheets).
Provides high level reports of all the tools in order to get a holistic view of everything at-a-glance.
Budgeting on a paycheck-by-paycheck basis with dollars you already have is very important, but so is forecasting the future. This will help shed light on areas that you might need to start saving for now. This tool allows for yearly forecasting for up to two people getting paid twice a month.
Saving Rate Tracker
Track how much of your paycheck is being saved/invested over time.
Saving Rate Increase Calculator
Calculate how increasing your saving/investing rate over time will help your money grow faster.
Net Worth Tracker
Track your assets (cash, investments, etc.) against your liabilities (loans, etc.) to see where your true net worth currently stands and watch it change over time.
401(k) Maximizing Tool
Curious how much of your paycheck is needed to contribute the maximum annual amount into your 401(k)? This tool uses your annual salary, contribution percentage, and employer match to show where you are now and provide different scenarios for what increasing your contribution percentage would like.
Portfolio Allocation & Re-Balancing Tool
If you want to hold a percentage of your portfolio in certain funds, stocks, bonds, etc. this tool will help you re-balance based on these target percentages, the current balance, and investable cash.
Based on your current plan, see how long it will take you to retire within your needs. Then play around with new scenarios to see what adjustments you can make to speed it up.
Debt Reduction Schedule
Not sure how to tackle paying off your debt? This tool will dynamically build you a month-by-month payment reduction plan based on the payoff method you select (custom order, snowball – lowest balance first, avalanche – highest interest rate first). It even includes a selection to show how long it would take to pay off the creditors if only paying the minimum monthly payment (and how much interest would accrue).
Loan Amortization Schedule
Wondering what the best loan for your situation is? This tool will show everything from the first payment to the last (up to 30 year loan term), whether it’s a mortgage or not. Play around with different scenarios such as rates, term lengths, extra monthly payments, etc. and watch it dynamically rebuild the amortization schedule around your inputs.
Quick Loan Calculator
Input a few details and see the monthly payment and how much interest you will pay over the course of the loan (primarily aimed at vehicle purchases but can easily be used for any other loans).
Fixed Assets Tracker
Track and depreciate (using straight-line or declining) everything you own over a certain dollar threshold in order to have a list for insurance in case of property damage / break-ins and to know how much insurance is needed to replace the items.
Rent vs. Buy Calculator
Calculator to estimate whether it makes more sense for you to buy or rent in your current situation.
For when you need to compare the financial drain of different locations you’re thinking about renting from.
Credit Card Annual Fee Tracking
Wondering if paying the annual fee on a credit card is worth it for you? This tracker determines how long it takes for the rewards points to cover the annual fee on a card.
Side Income Tracker
Need something easy and basic to keep track of side income? This tracker will allow you to do just that.
Income Tax Liability Forecaster
Use this tool to estimate your annual income tax liability.