Case Study Spreadsheet updates

[passionfruit17]

where do you put treasuries dividends that are not subject to state sales tax?

[MDM]

where do you put treasuries dividends that are not subject to state sales tax?

For federal purposes, that interest amount should be included in cell Calculations!D23.

There is no pre-configured cell for federally taxable but not state taxable interest.  Assuming you have a specific amount in mind, you could use column M on the 'State Tax' tab to enter that amount for your state.  Does that work for you?

[passionfruit17]

YEs, unlocking the sheet and entering the amount of interest that is not taxable by state in column M for my state seem to work. Thanks for the prompt answer.

I would have thought it was a common use case, iBonds, treasuries (including TIPS) are exempt from state and local taxes, and some MMFs like VUSXX are 80-90% state/local tax exempt so it might be worth making it official, or add yet another column past AG for manually entered adjustments to the taxable income

[MDM]

YEs, unlocking the sheet and entering the amount of interest that is not taxable by state in column M for my state seem to work. Thanks for the prompt answer.

I would have thought it was a common use case, iBonds, treasuries (including TIPS) are exempt from state and local taxes, and some MMFs like VUSXX are 80-90% state/local tax exempt so it might be worth making it official, or add yet another column past AG for manually entered adjustments to the taxable income

Or maybe unlock column M and let that be for any adjustment?  Or move the box that currently starts in Calculations!K39 a couple columns to the right and allow a state income adjustment there?  Or...?

At this point I don't remember why the 'State Tax'!Column M is being used only for rent subtraction on a MA return.  Probably someone asked for it and it was simple enough to do, but in hindsight it is a very narrow niche....

[passionfruit17]

I also noticed that CO income tax is set to a flat 4.4%. it was changed to 4.25% for 2024  see https://dhub.deloitte.com/Newsletters/Tax/2024/STM/240524_1.html

I'm going to change 'State Brackets"!D22 and 'State Brackets"!G22 in my copy.

[MDM]

On a related topic, a couple years ago I built a tool that combines a bunch of related functions: calculating the performance of different kinds of accounts (taxable, non-deductible, pre-tax, Roth, tax-free), estimating future tax rates, and calculating TvsR comparisons. Most of these are already done in the CSS, but not pulled together in a cohesive way. I suggested you consider merging it into the CSS and you declined. Since then I've developed and polished it quite a bit. It might be worth a second look.

Won't hurt to take a second look. :)

Having recently done the Version 22.18 release, I went back to look at your tool.  Best I can tell it is designed for a niche currently occupied by tools such as Pralana and Bogleheads' RPM, and I'm not looking for the CSS to compete in that space.  Best wishes for success with it for your own use, and for whoever else picks it up from Bogleheads.