Author Topic: Case Study Spreadsheet updates  (Read 63944 times)

Paul der Krake

  • Magnum Stache
  • ******
  • Posts: 4454
  • Age: 11
  • Location: USA
Re: Case Study Spreadsheet updates
« Reply #150 on: February 13, 2019, 06:05:52 PM »
There's a new Washington payroll tax in town, but it's rather complicated.

It's 0.4% of wages up to the Social Security cap, but employers pay anywhere from 33% to 100% of it, the rest is paid by employees. And it doesn't apply to union shops, tribes, plus a bunch of other quirks.

Full deets: https://paidleave.wa.gov/premiums

Totally understand if you can't be arsed to put that in.



MDM

  • Walrus Stache
  • *******
  • Posts: 9183
Re: Case Study Spreadsheet (CSS) updates
« Reply #151 on: March 19, 2019, 12:57:23 PM »
Versions 11.23 and 12.05
  • Updated AMT calculations to match the new form 6251.
  • Updated some URLs to point to the most recent IRS forms.
The AMT calculations are affected if one has a QBI deduction.

To Paul der Krake:  Looked at that, and you are correct - it's rather complicated.  Too complicated for the relatively small audience. ;)

2018 taxes version: 2018 Case Study Spreadsheet

Most recent version: 2019 Case Study Spreadsheet

MDM

  • Walrus Stache
  • *******
  • Posts: 9183
Re: Case Study Spreadsheet (CSS) updates
« Reply #152 on: March 20, 2019, 05:52:15 PM »
Version 12.06
  • Updated state income tax calculations for 2019.
Thanks to 2019 State Individual Income Tax Rates and Brackets | Tax Foundation for all the legwork.

Note that states may change 2019 law throughout the year, there may have been copy/paste errors, etc.  State Income Tax calculations - Crowdsourcing request is a good place to note errors & omissions so they may be corrected in future versions.


2018 taxes version: 2018 Case Study Spreadsheet

Most recent version: 2019 Case Study Spreadsheet

FireAnt

  • Stubble
  • **
  • Posts: 175
  • Age: 34
  • Location: West Michigan
Re: Case Study Spreadsheet updates
« Reply #153 on: April 07, 2019, 12:44:44 PM »
Doing the 2018 version.

Filing status- We're MFS, should that be marked #3 HOH?

MDM

  • Walrus Stache
  • *******
  • Posts: 9183
Re: Case Study Spreadsheet updates
« Reply #154 on: April 07, 2019, 01:06:59 PM »
Doing the 2018 version.

Filing status- We're MFS, should that be marked #3 HOH?
Unfortunately it isn't set up to do MFS.  Too many exceptions in the tax code for too few people using this status to make it worth doing - at least, that's been the perception....

The spreadsheet is fully changeable by anyone, so if you choose to modify it to handle MFS and the changes aren't too extensive, let me know and perhaps we can release a new version.

FireAnt

  • Stubble
  • **
  • Posts: 175
  • Age: 34
  • Location: West Michigan
Re: Case Study Spreadsheet updates
« Reply #155 on: April 07, 2019, 02:00:17 PM »
Doing the 2018 version.

Filing status- We're MFS, should that be marked #3 HOH?
Unfortunately it isn't set up to do MFS.  Too many exceptions in the tax code for too few people using this status to make it worth doing - at least, that's been the perception....

The spreadsheet is fully changeable by anyone, so if you choose to modify it to handle MFS and the changes aren't too extensive, let me know and perhaps we can release a new version.

I'm not smart enough to modify it. :) The calculations from my 2018 taxes were about $1000 off when I used option #3.