Last Updated: July 7, 2024

Income Tax Planning Spreadsheets

Don't be fooled by the lack of complexity of this web page.  The software available on this web site is amongst the most sophisticated and user friendly for planning your taxes.  We put our energies into the spreadsheets that you are about to download, instead of glitzy web pages that are more functional than the products they tout.

These spreadsheets are applicable to residents of the United States who file personal income taxes.  The spreadsheets assume that you are a full-time resident of the state that you work in (tax rates and schedules are tuned for this situation only).  If you are a resident of one state and work in another, or have multiple sources of income attributable to multiple states, then you should consult a tax advisor to see if these spreadsheets apply to your situation.  Most individuals will be able to use these spreadsheets for planning their personal income taxes.  At the very least, the Federal Only spreadsheet will apply to residents of the United States who earn income in the United States.

The tax planner spreadsheets allow you to perform on-the-fly tax planning with minimal effort.  Most people will be able to model their federal and state taxes in a matter of minutes.  This is no hoax and no joke: you will be able to plan for your taxes in less time and at significantly less cost than you have ever been able to in the past.  These spreadsheets are real products that are currently supported on Windows and are being provided freely to anyone who wants them, no obligation!

The tax planner spreadsheets require that you have Microsoft Excel version 5.0 or higher.  Excel version 5.0 is often called "Excel 95".  Users who have newer versions of Excel (such as Excel in the Microsoft Office 2000 / XP / 2003 / 2007 / 2008 / 2010 / 2011 / 2012 / 2013 / "365" suites) will have no trouble using these spreadsheets.

IMPORTANT: After loading the spreadsheet into Excel, make sure to read all the instructions at the top of the sheet.  If you are attempting to edit a cell and being asked for a password, you are doing it wrong (computational cells are locked against edit with formulas purposely hidden).  A quick read of the instructions will make it clear what cells you can and cannot edit.  You do not need the password, the sheets are fully functional as-is.

Versions and Latest News


Windows Requirements

Windows Download

These tax planner spreadsheets are being made available free of charge.  There are no usage limitations or time bombs in the spreadsheets.  Please use them as you wish with our compliments.

We welcome your feedback!  Please let us know what your experience has been in using these spreadsheets.  We pride ourselves on being extremely responsive to your concerns and suggestions!  Click here to initiate email to us.

IMPORTANT: Some browsers require that you press and hold the SHIFT key while clicking on an item below to effect a download.   If you get confused, choose the "Save File" option that your browser presents as a choice upon clicking an item below.

You have two choices for download, both will result in exactly the same Excel XLS files being extracted.  You can either download a single SETUP.EXE file that you will then invoke on your computer to perform an install, or you can download a TAXPLAN.ZIP file to extract the XLS files directly.  The SETUP.EXE installation is a step-by-step process that will prompt you for which spreadsheets you wish to install and has an option to save a backup of files previously installed. Some anti-virus programs incorrectly flag this SETUP.EXE as suspect or contaminated, in which case you can download using the zip file method in the MacOS Download section below (ZIP files will extract properly on the Windows platform).

Once you have successfully downloaded the appropriate SETUP.EXE file onto your computer, use Windows Explorer to locate the file and double click it.  The installation of the spreadsheets will thus commence.  Once the installation has succeeded, you will be able to open the extracted spreadsheet files using Microsoft Excel.

MacOS Requirements

These tax planner spreadsheets were developed on a Windows compatible system and have not been tested on Macintosh systems and therefore are not officially supported for MacOS.  However, users have reported that the spreadsheets function without error on Macintosh systems using Excel 5.0 for Macintosh or later.  Microsoft states that there should be no problem in using these tax planner spreadsheets on MacOS systems.  You are therefore encouraged to try using these spreadsheets on MacOS using Excel 5.0 or later at your own risk.

The Federal + California spreadsheet requires circular references in the formulas in order to compute federal and state AMT.  You must enable this Excel feature to use this spreadsheet.  To do so, open the spreadsheet and enable circular references as follows (depending on your version of Excel):

Excel  Preferences  Calculation  Enable iterative calculation (check box)
Excel  Preferences  Calculation Limit iteration (check box)
File Options Formulas Enable iterative calculation (check box)
Tools Options Calculation (tab) Iteration (check box)

MacOS Download

This method also works for Windows.  You will download a single TAXPLAN.ZIP file that you will need to unzip on your computer to extract the desired spreadsheets.  In order to unzip, simply double click on the downloaded zip file to extract the desired spreadsheet file(s).

For More Information

If you have any questions, problems, concerns, or suggestions about these tax planner spreadsheet products, please contact us as follows:

Geoff Mendal Consulting
1374 Robnick Court
Campbell, CA  95008-5833

Unfortunately, at this time, we are not able to accommodate any requests for implementing spreadsheets for additional states.  If your state is not yet implemented, it is very unlikely that we will be able to implement your request in a timely manner.  The same is true for feature requests: if you find that you need additional functionality not currently supported in the existing spreadsheet, the chances are that we will not be able to accommodate that for you.

The spreadsheets are offered with no support or warranty.  While we try to be responsive and fix bugs, there is no guarantee that we will be able to do so.