The attached Excel spread sheet allows quick approximation of Tier II or Tier IIA retirement benefits. It is meant to provide ballpark figures, not exact amounts. It is an additional tool to the one on the Comptroller's website, because while the latter works well for people about to retire, it doesn't work as well for people who are a ways from retirement. That's because it provides no assistance in determining what one's final average salary might be in 10 years (or whenever one plans to retire). It also allows only one estimation at a time.
The attached chart works off current earnings estimates, and then computes Final Average Earnings based upon the retirement date inputted, and a percentage wage increase. That increase is set to 3%, but can be modified by the user to any percentage from zero to 10.
The chart may look scary at first glance, but it's actually fairly easy to use. Only the yellow fields allow data entry by the user. All the others are blocked. The yellow fields are age (at the end of the current year), current year, estimated final average salary if one were to retire this year, years of service at end of this year, and anticipated retirement date. The table allows the entry of this information in three discrete rows, so that three different retirement dates can be compared simultaneously. The table can also be printed or saved.