Spreadsheet Formulas updated 3/20/2025
Welcome to the SWA Paycheck Calculator. This spreadsheet was initially created when Contract 2020 was passed to assist pilots with the pay complexities of the new contract. Based on the positive feedback I have received over the last year I decided to update it for 2025 and enhance it with some new features. There are a few changes to this year's calculator, the biggest being a built in federal tax withholding calculator, as well as simplified inputs for paycheck options and more accurate calculations. The spreadsheet has been fully updated for all 2025 limits. The features of this spreadsheet will allow you to:
Accurately estimate Federal Tax Withholding for every paycheck
Know when you will hit any IRS limits and start to receive excess monies
Quick glance year end totals for all pay sections and tax withholdings
Customize each cell or row for your own situationÂ
Estimate year end Taxable Income and Federal Tax Withholdings to make
appropriate changes to your tax withholding elections