Hi, First off, I am very impressed with the Retiree Portfolio Model. It has taken me several hours to learn to use it. I still do not fully understand it all, but I am working on it. So THANK YOU for the enormous effort you have put into this.
I am using the latest version, 16.3, downloaded 11/26 at 6pm eastern time. I am using Excel 2013 and that MAY come into play.
I have discovered what I think is a problem, in the state income tax area, but this time using percent ( not brackets). I see what I think an error. ( Of course it could be a seat - keyboard interface problem
1 - Even though I include a standard deduction, the tax applied is against the State AGI, Not State Taxable income.
In the Full Case tab, in cell F208 ( just showing first year, but it happens to all ) the formula is
Code: Select all
Note that the tax is calculated by referring to cell F$195 (State AGI) ( in bothe the TRUE and FALSE evaluation of the IF) but I believe it should be F$201(State Taxable Income). If I change it to F$201, then the tax is what I expect.
EDIT - Thought there was a second issue, but I must be late and it was my problem
Hope you can help. I can set up a single bracket to workaround both issues.
Well Good Luck, and Thanks again for a great tool.