Notices
Endeavor Air Regional Airline

Pay estimator doohickey

Old 03-16-2018, 06:05 AM
  #1  
Gets Weekends Off
Thread Starter
 
Joined APC: Mar 2008
Position: Ca. CRJ 200
Posts: 348
Default Pay estimator doohickey

So I'm a numbers nerd and I've been making an excel sheet to ballpark my pay each cycle. What I'm struggling with, is the taxable and nontaxable items each month to get the numbers close. 401k, nt pd, fsa contribution....what else?


Just to be sure I'm not reinventing the wheel before I continue bearing my head against the wall trying to get it all figured out, does anybody have something like this already?
42jeff is offline  
Old 03-16-2018, 07:03 AM
  #2  
Gets Weekends Off
 
Joined APC: Feb 2016
Posts: 2,559
Default

PM sent.
.
HighFlight is offline  
Old 03-16-2018, 12:14 PM
  #3  
Gets Weekends Off
 
Joined APC: Jan 2008
Posts: 888
Default

I built one too, but it's not that hard to reverse engineer.

Healthcare , Dental, FSA's, HSA, Vision and 401K are all tax exempt deductions. NT PD (Non Taxable Per Diem) is also not subject to tax.

Voluntary Life (Vol Life), Spouse Life (SP Life) and Long Term Disability (LTD) are non tax deductible deductions.

In a very simple case take your pay rate, multiply it by hours on the check. Add any Taxable Per Diem and Special Items (Parking Allowance for example). That will be Taxable gross pay. Excluding NT Per Diem multiply that by 1.9%; those are your ALPA dues.

Medicare is 1.45% of taxable (plus 401K which IS subject to Medicare tax).

Social Security is 6.2% of taxable ( again plus 401K which is subject to SS tax). If it applies to you, SS tax stops being collected at $128,400, so any earnings in 2018 in excess of that aren't subject to SS tax.


Alright, looking back that wasn't a very simple explanation. Hopefully HighFlight explained it better, or sent you a spreadsheet.
Blueskies21 is offline  
Old 03-17-2018, 06:02 PM
  #4  
Gets Weekends Off
Thread Starter
 
Joined APC: Mar 2008
Position: Ca. CRJ 200
Posts: 348
Default

Originally Posted by Blueskies21 View Post
I built one too, but it's not that hard to reverse engineer.

Healthcare , Dental, FSA's, HSA, Vision and 401K are all tax exempt deductions. NT PD (Non Taxable Per Diem) is also not subject to tax.

Voluntary Life (Vol Life), Spouse Life (SP Life) and Long Term Disability (LTD) are non tax deductible deductions.

In a very simple case take your pay rate, multiply it by hours on the check. Add any Taxable Per Diem and Special Items (Parking Allowance for example). That will be Taxable gross pay. Excluding NT Per Diem multiply that by 1.9%; those are your ALPA dues.

Medicare is 1.45% of taxable (plus 401K which IS subject to Medicare tax).

Social Security is 6.2% of taxable ( again plus 401K which is subject to SS tax). If it applies to you, SS tax stops being collected at $128,400, so any earnings in 2018 in excess of that aren't subject to SS tax.


Alright, looking back that wasn't a very simple explanation. Hopefully HighFlight explained it better, or sent you a spreadsheet.
You da man

That was exa fly the breakdown I was looking for. I was losing my patience trying to math out which of the deductions were tax deductible.

Thank you
42jeff is offline  
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Clearedtopush
Delta
241
07-27-2016 06:10 PM
MikeF16
Delta
179
02-03-2016 08:22 PM
notEnuf
Delta
238
12-22-2015 04:20 AM
Albief15
FedEx
161
10-02-2015 03:11 PM
TheManager
Major
9584
07-28-2015 12:15 PM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Thread Tools
Search this Thread
Your Privacy Choices