Procedure to Determine the Optimal Roth IRA versus Deductible IRA Allocation
Loading...
Files
Authors
Hull, John B.
Hull, Robert M.
Issue Date
2016-03-1
Type
Working paper
Language
en_US
Keywords
Individual retirement accounts , Asset allocation , Financial advising , Excel spreadsheet template
Alternative Title
Abstract
This paper offers financial advisors a spreadsheet application to solve the Roth IRA versus deductible IRA (RVD) allocation choice. Our algorithmic procedure requires advisors to input values for nine variables. An optimal RVD choice is computed based on these values and other values supplied by our procedure. The optimal choice reveals what percent of IRA retirement funds should be put in a deductible IRA in order to maximize retirement wealth. The key computations to determine an optimal RVD are the contribution and withdrawal tax rates. Algorithms are used that are applicable to income levels for all effective statutory tax rates.
Description
Citation
Publisher
Washburn University. School of Business