here is the spreadsheet (and a spreadsheet for covered comp values if anyone still uses those values). spreadsheet also contains a table for estimating soc sec if you plug in your historical comp. at least I come close to matching my own results on that when I plug my actual comps, but who knows if I really have that all set up properly.
plugged in the latest national wage average released and the generates the 132,900 value for the taxable wage base as well
plugged the cpi-w values and that generates the 2.8% COLA increase. nice to know that I somehow managed to create a spreadsheet that calculates values that match the govt for taxable wage base and COLA! guess even a blind pig can find an acorn
Since 1975, Social Security's general benefit increases have been based on increases in the cost of living, as measured by the Consumer Price Index. We call such increases Cost-Of-Living Adjustments, or COLAs. We determined a 2.8-percent COLA on October 11, 2018. We will announce the next COLA in October 2019.
indexed limits and soc sec.xlsx
covered comp at 132900.xls