I'd like for line E to be solved based on the average tax rate being 13.29%

and Line L to be solved based on anticipated inflation rate of 3.30%

Conditional Formatting ~ A Cells Editing Paste Font Alignment Number Format as Table ~ Cell Styles ~ ndo Clipboard Styles ABCDE F G H W 16 WORKSHEET Worksheet for Funding Your Retirement Needs Your Numbers Step 1: Estimate Your Annual Needs at Retirement A. Present level of your living expenditures on an after-tax basis $2,017 B. Times 0.80 equals: Base retirement expenditure level in today's dollars x 0.80 $1,614 C. Plus or minus: Anticipated change in living expenditures ater retirement + or- $500 D. Annual living expenditures at retirement in today's dollars on an after-tax basis = $1,614 E. Before-tax adjustment factor, based on an average tax rate of % Use Table 15.2 in Text F. Before-tax income necessary to cover the annual living expenses in line D $1,614 (Line D divided by (1-Line E)) Step 2: Estimate Your Income Available at Retirement G. Income from Social Security in today's dollars $887 H. Plus: Projected pension benefits in today's dollars $0 1. Plus: Other income in today's dollars + $1,000 J. Anticipated retirement income, in today's dollars [equals (lines G + H + 1)] = $1,887 Step 3: Calculate the Annual Inflation-Adjusted Shortfall K. Anticipated shortfall in today's dollars (line F minus line J) $273 L. Inflation adjustement factor, based on anticipated inflation rate of % Years until retirement 30 FVIF: as found in Appendix A = ? Accessibility: Unavailable 88.F Sunny O