Shows the probability of two people being alive in the future: individually, both, either, etc. Based on user selectable life table. Has option for estimating present values of single and joint annuities.
Change log:
08/07/15: Initial version
08/08/15: Allow more flexibility in Joint annuity options
09/01/15: Add Society of Actuaries RP-2014 Mortality Table
09/20/15: Add SSA Cohort 1980, 1990, & 2000 tables
06/25/16: Add options for minimum years guaranteed & annual % increase
12/16/19: Add SS sheet to calculate PV for nine claim ages 62 - 70
11/24/21: Add SSA 2019 Period table & make it the default
01/23/22: Add Tax sheet to allow calc after income tax
Click following link to download: OddsOfBeingAlive.XLSX