Use this projected annuity spreadsheet to accurately determine your monthly and annual annuity over the next 40 years. The annuity growth is based on an estimated average COLA growth rate, with and without survivor benefits, and your survivor’s annual and monthly annuity.