Martha, a single woman born in 1955, has worked her entire life. She has one daughter, Elizabeth, who is disabled to the extent eligible to receive SSDI benefits. Elizabeth was born in 1980. Martha’s gross compensation income over her working career are set out in the Excel spreadsheet.
Please prepare an Excel spreadsheet calculating the present value of the Social Security benefits available to Martha and Elizabeth assuming that Martha retires ad (a) Age 62; (b) her Full Retirement Age; and (c) Age 70.
How do I calculate the PV? I have an excel worksheet of Martha compensation history.