The objective is to develop an Excel workbook that will assist in projecting an individuals 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 individuals personal income tax returns including the calculation of the tax liabilities. The workbook should easily allow for what if projections of the individuals 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