1 / 10

SMRE Spring 2008 Project An Excel Model to Estimate Expected Remaining Retirement Lifespan

SMRE Spring 2008 Project An Excel Model to Estimate Expected Remaining Retirement Lifespan. By Bruno Trenkler. Introduction. Need a simple tool to calculate expected remaining life for retirement planning. Available Tools Web based estimators Web based tables

valora
Download Presentation

SMRE Spring 2008 Project An Excel Model to Estimate Expected Remaining Retirement Lifespan

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SMRE Spring 2008 ProjectAn Excel Model to Estimate Expected Remaining Retirement Lifespan By Bruno Trenkler SMRE Spring 2008

  2. Introduction • Need a simple tool to calculate expected remaining life for retirement planning. • Available Tools • Web based estimators • Web based tables • Uses publicly available data for • Total Population • Whites • Males • Females • Blacks • Males • Females SMRE Spring 2008

  3. Methodology • Data source is: National Vital Statistics Reports, Vol 54, 14, April 19, 2006 (Revised March 28, 2007) http://www.cdc.gov/nchs/data/nvsr/nvsr54/nvsr54_14.pdf SMRE Spring 2008

  4. Survival Plot SMRE Spring 2008

  5. Attempts to Model Survivor Function • Distribution Analysis • Weibull (coeff = 0.976) • 3 parameter Weibull (coeff = 0.985) • Transformations • Manual • Log, Log-Log, √ , inverse √ • Box-Cox • Polynomial • 6th order provides R2=0.9999 SMRE Spring 2008

  6. Mean Expected Life SMRE Spring 2008

  7. Cubic Polynomial Fit SMRE Spring 2008

  8. Expected Remaining Life Excel Interface SMRE Spring 2008

  9. Polynomial Model vs. Data SMRE Spring 2008

  10. Conclusions • Modeling survivor function difficult • Cubic polynomial gives good results • Excel program results are acceptable SMRE Spring 2008

More Related