Chapter 4 The MBA Decision Complete the cells highlighted in yellow. Input area: Current salary Years until retirement Salary increase Tax rate...

The Word Document is the case study, the Excel file is what the professor wants populated. 

I started populating the first section (please review), I need help with the yellow section.  While all the professor is looking for is the answer, I want to know how the answer is derived. (formulas).

also, in the case study there are questions 1-6.  those do not need to be answered.

Thanks