MANUAL REVISIONS TO THE RSP 3 (v3.x) TAX TABLES ----------------------------------------------- 1) Click License Info to find out which version you have installed. RSP 3 users need Version 3.10 or higher. Send an e-mail to RSPsupport@pa.wagner.com if you use a prior version. 2) Use Excel's Format->Sheet->Unhide to unhide the TaxTables worksheet. 3) Use Excel's Tools->Protection->Unprotect Sheet to allow changes to it. 4) There are 4 major blocks of data, one for each Filing Status, as follows: Married Joint, Single, Married Separate, Head of Household. Each major block has 6 tables specified, as follows: Federal tax schedule for regular income; State tax rate for regular income (keep this set to 0); Local tax rate for regular income (linked to ClientAssumptions); Federal tax schedule for long-term capital gains; Federal penalty for early tax-deferred distributions (linked to ClientBasics); Federal tax schedule for long-term capital gains, for use by clients in the first 2 regular income tax brackets; Federal Social Security tax (FICA) schedule for earnings income; Federal Medicare tax (FICA) schedule for earnings income; Change the income breakpoints (column 7) and corresponding rates (column 8) to the values for the current tax year. Make sure that the final income breakpoint for each table is set to "Unlimited". The State Tax Rate or Schedule must be changed on the ClientAssumptions worksheet, and on each StateTaxXX worksheet. The Local Tax Rate must be changed on the ClientAssumptions worksheet. 5) Change the Tax Table Year (cell R1C6 or F1) to the current tax year. 6) Use Excel's File->Save or File->Save As to save the revised RSP workbook.