The objective is to develop an Excel workbook that will assist in projecting an individual’s Federal and state income tax situation – overpayment and refund or credit due or balance due - as well as providing information relative to any underpayment penalty safe harbor amounts.
The workbook should be set up so as to approximate the information which will be included in an individual’s personal income tax returns including the calculation of the tax liabilities.
The workbook should easily allow for “what if” projections of the individual’s year-end tax situation – balance due or overpayment and refund or credit due.

Client A
Marital status: single
location: New jersey
Salary: $63,028 per year