Financial Spreadsheets

Most people who know me are aware that I love spreadsheets and use them for many aspects of my life, most notably, personal finance. With how much time I have spent developing these financial spreadsheets, I think that it would only make sense to allow others to benefit from them as well.  I will be adding on as time goes on, so check back frequently.

NOTE: All of my spreadsheets are composed in OpenOffice 3.1. If you are using a different program, there may be some formatting and/or calculation issues.  I have not had a chance to test these in excel yet. I recommend making a copy of each file after download to ensure that if unrecoverable mistakes are made, there is a source copy available to start over from.

House Payment SpreadsheetHouse Payment Spreadsheet Version 3.0: Looking to Pay off your mortgage early? Check out our newest version of the House Payment Spreadsheet.  This sheet offers everything our previous version did, with some really cool new features.  For starters, the user inputs, which would be your loan details, are frozen in place, so no matter where you are in the amortization, you can see the details of the loan.  The second big feature is the user metrics section.  Like the user inputs section, this is also frozen and will travel with the entire screen.  The user metrics section tell you how much interest you will pay over the life of the loan and calculates in any additional principal payments you make and tells you how many months you have taken off the mortgage and how much interest you have saved.  I personally love this feature and my need for this feature is why I created version 3.0 of this spreadsheet.  Paying off a mortgage is a lot of hard work and you don’t see any real results until it is fully paid off.  The user metrics provided by this spreadsheet provide a HUGE motivational boost.  For me I was blown away to see that so far I have saved over $16,000 in interest and taken over 4 years off my mortgage! I love seeing how much money and time I am saving with each payment I make on my mortgage.

This spreadsheet is also great for comparing different mortgage options.  There is an amortization sheet for a 30 year, 20 year, 15 year, and 10 year amortization and an extra sheet that compares the equity built in each mortgage type over time. Click here for a video overview of the spreadsheet 

2018 Tax PlanningTax Planning Spreadsheet for 2018: This is the new and updated spreadsheet for tax year 2018.  All adjustments made to the tax brackets have been inputted into this spreadsheet. I have redone the 2018 spreadsheet to also include a user metrics section to display which option has the lowest tax bill, and what the effective tax rate is. Another major change for this year is a reduction in the total number of comparisons. The old sheet seemed too cumbersome with 10 comparison columns, this version reduces the number of columns down to 6. This is what you want to use for planning out your taxes that are due April 15th 2019.  Click here for a video overview of the spreadsheet.

Tax Planning Spreadsheet for 2020: This is the new and updated spreadsheet for tax year 2020.  All adjustments made to the tax brackets have been inputted into this spreadsheet. This includes the changes made to the standard deduction, the elimination of exemptions, and the expansion of the child tax credit. This spreadsheet contains all of the enhanced features that were in the previous 2018 spreadsheet as well. This is what you want to use for planning out your taxes that are due April 15th 2021.

Retirement Planning Spreadsheet 2Retirement Planning Spreadsheet: This spreadsheet has been completely reworked to make it much more user friendly than the previous version.  This retirement planning spreadsheet allows the user to input different contribution amounts for each year and to compare different retirement scenarios side by side.  In the user metrics section the spreadsheet will show the user when they will reach their retirement nest egg goal and when they will become a millionaire.  Additionally this spreadsheet will also calculate the users Social Security benefits provided their Averaged Indexed Monthly Earnings.

ACA Healthcare Spreadsheet:

ACA Spreadsheet Obamacare

This spreadsheet is a great tool to see how much the ACA program (Obamacare) expects you to pay for health insurance.  This spreadsheet will calculate out your percent of the federal poverty level and from there determine what amount the ACA expects you to pay for insurance per year.  Your subsidy will be based on the difference between this number and the cost of the second lowest cost silver plan.  This spreadsheet then compares 14 different changes in income situations to demonstrate how the ACA plan handles an over payment and an under payment of tax subsidies throughout the year, and how much of a refund/ repayment you would need to make.  Additionally this sheet will calculate out the penalty owed for not having health insurance.  This spreadsheet is a great tool for estimating your liability and goes hand in hand with our tax planning spreadsheet.  The ACA spreadsheet is currently a free download. 

NOTE: I am not a tax accountant or a professional in any financial sector. These tools are estimation templates to assist YOU in making your decisions.  While every effort has been made to optimize these sheets for a wide audience, I am human and mistakes may exist.  While I think these are excellent products, they are essentially just a framework for you to play with to find out what may work right for you. Please contact me with your thoughts on my spreadsheets and any improvements or adjustments you think I should make.


Leave a Reply

Your email address will not be published. Required fields are marked *