Retiree Portfolio Model

Wiki link: Retiree Portfolio Model

The Retiree Portfolio Model is a downloadable Excel spreadsheet created by a retiree for retirees. It models the most common financial aspects of a retiree and their spouse’s lives, including pensions, Social Security benefits, living expenses, IRA Required Minimum Distributions, purchase of an annuity, sale of a house, and many other items including Federal and state income taxes. All of this data is used to create a model of their accounts over a period of 1 to 40 years.

A feature of this model allows the user to compare their normal portfolio results with one that includes alternative choices, such as doing Roth IRA conversions, choosing alternative Social Security starting ages and benefits, or buying a Single Premium Immediate Annuity. This model was created using Excel 2003 and is compatible with LibreOffice Calc and possibly Google Sheets. All formulas and results are completely viewable and can be unprotected, allowing user customization.

The model was developed by forum member BigFoot48.

The first post in this Bogleheads® forum topic: Retiree Portfolio Model contains the link for downloading the spreadsheet. Also use this topic to receive assistance or ask questions.

About

Barry Barnitz, administrator of both the Bogleheads® wiki and of Financial Page, a Bogleheads® blog. In addition I serve as an administrator of finiki, the Canadian financial wiki, as an administrator of la Wiki Bogleheads® España, and as an administrator of the John C. Bogle Center for Financial Literacy site.

Posted in
Archives
Categories
Follow Financial Page on WordPress.com
%d bloggers like this: