Classic Computer Magazine Archive ANTIC VOL. 6, NO. 12 / APRIL 1988

1987

Federal Income Tax Spreadsheet

Antic's fourth annual 1040 SynCalc template

by TOM CHANDLER

Tom Chandler has a degree in finance and is a marketing employee of Antic Publishing

Antic's three previous Federal Income Tax Spreadsheet Templates have been among our most popular annual features. Now you can calculate your 1987 federal income taxes on your 8-bit Atari. (ST owners will find templates for the VIP Professional and A-Calc Prime spreadsheets in the Spring 1988 issue of START.) Requirements for running the 8-bit Atari template are minimum 48K memory, a disk drive and SynCalc spreadsheet software ($49.95) from Broderbund. A printer is optional, but you'll need your official Internal Revenue Service 1987 tax instructions and forms.

THIS IS THE YEAR when you must face all those major changes in the Revised Federal Income Tax Law But at least you can count on much less hassle when you do the number crunching wih your 8-bit Atari, SynCaic spreadsheet ($49.95, Broderbund) and Antic's Fourth Annual Income Tax Template. 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 Fourth Annual Antic Federal Income Tax Spreadsheet Template includes fewer forms than in previous years, because of the new "simplified" tax law. (For example, there's no more Income Averaging deduction.) So for 1987 you'll get:

IRS 1040 Long Form

Schedule A (Itemized Expenses)

Schedule B (Interest and Dividends)

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, phone Broderbund Technical Support at (800) 527-6263-not 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. Then choose the Mailbox selection from the main menu and go to the Error Log section.)

Sorry, under this year's new laws you cannot deduct any tax preparation expenses-such as this issue of Antic and the monthly disk, or your online time-charges for accessing tax information.

Please be careful and use common sense in figuring out yout 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.

TAX SPREADSHEETS

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 1987 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 re-used for many different 1987 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, narrow template consists of 149 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.

TEMPLATE TYPE-IN

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, 36; 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 35-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

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 starting at cell Al and working down 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. You must enter all numbers and formulas in the exact cells shown, or else the template won't work.

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 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 IE 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 BLNKl040 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.

SYNCALC
Broderbund Software
17 Paul Drive
San Rafael, CA 94903
(800) 527-6263
$49.95, 48K disk

Listing 1: TAX1040.SC Download