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.

Building Wealth Book Companion Spreadsheets:

These are the spreadsheets included in my recently published book, For My Children’s Children: A Practical Guide To Building Generational Wealth.  These spreadsheets are compound interest sheets that are setup in several different scenarios.  They are fully editable by the user.


House Payment Spreadsheet Version 3.0:

House Payment SpreadsheetLooking 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 


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. Click here for a video overview of the 2018 version of the spreadsheet.

Retirement Planning Spreadsheet:

Retirement Planning Spreadsheet 2This 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.

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 *