Tax Deferral Worksheet
Use our Tax Deferral Worksheet to illustrate the benefits of tax deferred annuities over taxable investments, such as CDs.
1.) Open the worksheet by clicking HERE (for 3 year period) or HERE (for 5 year period)
2.) In cell B8 enter the initial premium amount desired.
3.) In cell D13 enter the current annuity (tax deferred) rate you wish to compare.
4.) In cell F13 enter the current CD rate (taxable) rate you wish to compare.
The rest of the worksheet will auto fill. The worksheet even illustrates different tax brackets: 28%, 25% and 15%. The yellow highlighted section shows the account values after 3 or 5 years, depending on the worksheet you choose.

