OBJECTIVE The objective of this exercise 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.

CAPABILITIES 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 calculations 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. Very vague project can basically do what ever we want. I was hoping for some suggestions or a possible photo of an excel document. Doesn't have to be a lot maybe just one to three points to give me an understanding. Thank you!!

Also I seen a post with this exact question and I would like a different reply than the one that was already posted.