1988 FEDERAL INCOME TAX SPREADSHEET
Antic's annual 1040 Syncalc Template
By Tom Chandler
Antic's Annual Federal Income Tax Spreadsheet Templates have been amoung our most popular features. Now you can calculate your 1988 federal income taxes on your 8-bit Atari. Requirements for running the 8-bit Atari template are minimum 48K memory and a disk drive, plus SynCalc spreadsheet software (which unfortunately is no longer being sold by Broderbund). A printer is optional, but you'll need official Internal Revenue Service 1988 tax instructions and forms.
If April 15 is approaching, it's time to calculate your Federal Income Tax again. But at least you can count on much less hassle when you do the number crunching with your 8-bit Atari, Antic's Annual Income Tax template, and SynCalc spreadsheet (no longer sold by Broderbund, but perhaps back copies are still available). This IRS tax template will make it simple for you to experiment with various alternative "what if" strategies for minimizing the taxes you owe.
The Annual Antic Federal Income Tax Spreadsheet Template includes fewer forms than in previous years, because of the "simplified" tax law. (For example, there's no more Income Averaging deduction.) So for 1988 you'll get:
IRS 1040 Long Form
Schedule A (Itemized Expenses)
Schedule B (Interest and Dividends)
2106 Form (Employee Business Expenses)
We use SynCalc software for the Antic tax templates because SynCalc is still the most widely used 8-bit Atari spreadsheet that will perform income tax calculations. If you don't have a printer, you can just hand-copy the figures from the screen to your printed IRS forms.
Even if you've never used SynCalc before, you should be able to work through the well-written manual in a few hours and learn enough to use this tax template. But you're leaving yourself open for unnecessary aggravation if you try to start working on the tax template without taking enough time to become adequately familiar with SynCalc.
Please, if you need help with SynCalc, try Broderbund Technical Support at (800) 527-6263--don't phone Antic! However, if any last-minute fixes are needed in the template itself, the information will be on CompuServe's ANTIC ONLINE. (Type GO ANTIC when you log onto CompuServe and you'll see any necessary bulletins.)
Please be careful and use common sense in figuring out your tax return. If you doubt the accuracy of the template findings, check with a registered tax preparer. User and programmer errors are always a possibility. Antic can't take responsibility for any mistakes made in your tax return as a result of using this template.
Spreadsheet programs are an ideal tool for preparing tax returns. You type in personal data such as income and deduction amounts, and customized formulas tell the spreadsheet how to compute the tax obligation from your data. Each data element or formula is entered in a "cell" with an address similar to the lines and columns on the tax form. As your data changes (if you find another receipt, for example), just go to the proper cell, type in that number and press [START]. Your entire tax return will begin to recalculate.
Important: please remember that SynCalc calculates by rows or columns--so this template must be calculated at least five times. Press [START] five times after changing any figure.
You'll need the official 1988 Internal Revenue Service tax instructions and forms nearby. There isn't enough Atari memory to duplicate the forms exactly, so abbreviations are used wherever possible. But the template follows IRS line numbers, so you won't get lost.
After you enter the information into the spreadsheet, it calculates every line except the actual tax you owe. Putting all the tax tables into the template would chew up memory and typing time. So when you determine your Net Taxable Income on the template, look up the matching tax obligation in the Tax Table or Tax Schedule in your IRS instruction booklet.
The spreadsheet template can be reused for many different 1988 tax returns if you retain a blank version on disk. Entering a taxpayer's personal data should take about an hour. Save each completed tax template under a different filename.
This long, narrrrw template consists of 205 rows (out of a possible 255 maximum) by four columns. You don't need to type in any schedules or forms that you won't use--the 1040 form will work without them. If you type in template sections that you later decide not to use, just leave those cells blank and they won't become part of the overall calculations for the return.
Antic Disk owners will find this template on the monthly disk under the filename TAX1040.SC. You'll need to boot SynCalc before loading TAX1040.SC.
For the purposes of this article, I must assume that you're familiar with SynCalc. For instance, you should know that pressing [OPTION] starts a command sequence, how to move around within the spreadsheet, etc. Keep your SynCalc manual handy, if you have any doubts.
Format a blank disk for data. Before typing anything in, set the column widths as follows: column A, 4; column B, 35; columns C and D, 9 each.
Set GLOBAL FORMAT to PRECISION 0 (to round off cents to the nearest dollar) and COMMA (to insert commas in numbers like 1,000). To speed up data entry, issue the command GLOBAL RECALCULATE MANUAL. Also, set calculation to ROWS.
In this year's template, the IRS form line numbers are in 4-width column A and the text descriptions are in 36 width column B. The actual figures and formulas are in 9-width columns C and D. While entering titles in column B, set FORMAT JUSTIFY LEFT. When entering the numbers and formulas in columns C and D, set FORMAT JUSTIFY RIGHT, and also right-justify column A.
The template is divided into separate sections, one for each tax form or schedule. Each section has two parts. Part A is the format set-up: titles, labels, etc.--with zeros (0) temporarily standing in for your actual number and formula locations. Part B contains the formulas. I'd suggest I starting at cellAl and working d~wn column A using SynCalc's automatic cursor movement. Then go to column B and enter the titles.
You might consider typing in and testing each section before proceeding to next one. Part A of each section starts with the SynCalc row number. Don't type in these row numbers. The tax form line numbers are under the dashes for column A.
Here's a data compression tip: SynCalc uses 16 bytes to store every number. Text entries take only four bytes, plus one byte per character. Unless you use a number in a calculation, enter it as text. In fact, all form line numbers such as the ones in column A must be text. Start each text entry with quotation marks (") or you'll run out of memory.
The last step in Part A is to enter all the zeros. The zeros "hold open" the cells for formulas and values to come later. Most zeros are in columns C and D. As you enter them, use this undocumented tip: the /K command toggles automatic cursor movement on and off. Also, you can move the cursor arrows in a menu without holding down [CONTROL].
Now that the template format is typed in, use Part B of each section for cell formulas. The listing shows each cell address, followed by the entry. Don't type the cell addresses (such as C133) shown in the first three or four spaces at the left. Instead, go to that cell and type in the formula, typing over the space-holding zeros entered earlier. A formula element like D122 is not text--type it as + D122 so that SynCalc will know it's a numeric entry. As you enter each formula, protect it with a /FO (FORMULA PROTECT ENTRY) so you won't accidentally write over it.
TIPS & TRICKS
Because this template pushes SynCalc to its limits, you'll need to use some advanced spreadsheet operation techniques in order to get everything working properly. Since SynCalc occasionally wastes a few cells, if you get the famous ERROR 100 NOT ENOUGH MEMORY message, save the file immediately. Now erase the file in memory with the /E# command and then reload the file from disk. This save/erase/load process deletes unnecessary entries.
To squeeze in long cell formulas, don't type spaces between words. Even more importantly, when you first type in the formulas, leave out words like THEN, ELSE or LOOKUP. Then press [RETURN]. You'll get a SYNTAX ERROR message because of the missing words, but go back and enter those words with the [CONTROL] [INSERT] keys. This lets you put an "illegal" amount of characters into a cell. The final characters will be pushed off the screen, but they're still in memory. (There are limits, of course don't insert more characters than you need to.)
After you correctly type in the complete spreadsheet template, remember to save a blank copy under a name like BLNK1040 before entering any taxpayer data. Loading that blank file lets you do returns for many different taxpayers-just save each return with a different filename.
Tom Chandler has a degree in finance and is an accountant.