Please reproduce the charts on Page 2 of the attached annuity brochure using excel with formulas - just values will not be accepted
What are the two Charts trying to illustrate?
Recreate the payouts with a guaranteed minimum rate of 0%
How does FGNY Index-Safety 7 work? 1. HOW WILL THE VALUE OF MY ANNUITY GROW? Interest Crediting Options Four Interest Crediting Options That Offer Upside Potential (Subject To Caps) 1. One-year S&P 500 monthly point-to-point with a cap Three of the four options in your annuity will earn interest based on Minimum cap per year: 1% formulas linked to changes in an index. These are subject to a cap rate 2. One-year S&P 500 monthly average with a cap (see Interest-Crediting Options 1 through 3 on the side box). Minimum cap per year: 3% Indexed interest is credited on each interest crediting option anniversary 3. One-year S&P 500 annual point-to-point with a cap and, because indexed interest will never be less than the guaranteed Minimum cap per year: 3% minimum effective rate, your account value will never decrease due to a 4. Fixed interest option with a seven year initial declining index. interest rate guarantee The fourth interest crediting option is the fixed interest option. The initial "if publication of the selected index is discontinued, or if we are interest rate is GUARANTEED for seven years, and the rate thereafter is unable to utilize it, or if the calculation is substantially changed, we will substitute a suitable alternative index and notify you at guaranteed to be equal to or greater than the guaranteed minimum effective your last known address annual interest rate declared in your contract for the life of your annuity. This adaptable combination of four interest crediting options offers you the flexibility to reallocate your account value between these options on each crediting option anniversary. The following hypothetical example illustrates how the account value of a generic fixed indexed annuity (which is not necessarily representative of this product) can increase but never decrease in value, assuming no withdrawals and no surrender charges. The graph below assumes an Annual Point-to-Point crediting option with 100% participation rate in the indexing formula. Annual interest credits for the Annuity are based upon assumed indexed-interest rates linked to the S&P 500's actual performance and will never be below the guaranteed minimum effective interest rate. The guaranteed minimum effective interest rate is based on 1.75% on 100% of premium. $160,000 $150,000 1.15% $140,000 2.16% 6.00% 5,55% $130,000 $120,000 6.00% 6.00% 18.49% $110,000 1.75% 2,16% 11,65% 100 1.75% 6.00% $100,000 -11.82% 5.55% 000% $90,000 8.44% -10.02% 21.94% $80,000 $70,000 -35.61% -21.27% $60,000 1/1/1999 1/1/2000 1/1/2001 1/1/2002 1/1/2003 1/1/2004 1/1/2005 1/1/2006 1/1/2007 1/1/2008 1/1/2009 Fund growing with annual change in S&P 500 index Account Value The above chart assumes an initial premium of $100,000. The S&P 500 Index value assumes the initial account value is evenly allocated among the stocks comprising the index. The S&P 500 is an index measuring the performance of selected stocks (excluding dividends); it is not an investment. Whereas investments in stocks underlying the S&P 500 can gain or lose value, including principal, the Annuity's principal is guaranteed, which eams interest and is subject to minimum interest guarantees and credited interest rate caps. Withdrawals will decrease account value and the dollar amount of future interest earned and may be subject to surrender charges. How does FGNY Index-Safety 7 work? 1. HOW WILL THE VALUE OF MY ANNUITY GROW? Interest Crediting Options Four Interest Crediting Options That Offer Upside Potential (Subject To Caps) 1. One-year S&P 500 monthly point-to-point with a cap Three of the four options in your annuity will earn interest based on Minimum cap per year: 1% formulas linked to changes in an index. These are subject to a cap rate 2. One-year S&P 500 monthly average with a cap (see Interest-Crediting Options 1 through 3 on the side box). Minimum cap per year: 3% Indexed interest is credited on each interest crediting option anniversary 3. One-year S&P 500 annual point-to-point with a cap and, because indexed interest will never be less than the guaranteed Minimum cap per year: 3% minimum effective rate, your account value will never decrease due to a 4. Fixed interest option with a seven year initial declining index. interest rate guarantee The fourth interest crediting option is the fixed interest option. The initial "if publication of the selected index is discontinued, or if we are interest rate is GUARANTEED for seven years, and the rate thereafter is unable to utilize it, or if the calculation is substantially changed, we will substitute a suitable alternative index and notify you at guaranteed to be equal to or greater than the guaranteed minimum effective your last known address annual interest rate declared in your contract for the life of your annuity. This adaptable combination of four interest crediting options offers you the flexibility to reallocate your account value between these options on each crediting option anniversary. The following hypothetical example illustrates how the account value of a generic fixed indexed annuity (which is not necessarily representative of this product) can increase but never decrease in value, assuming no withdrawals and no surrender charges. The graph below assumes an Annual Point-to-Point crediting option with 100% participation rate in the indexing formula. Annual interest credits for the Annuity are based upon assumed indexed-interest rates linked to the S&P 500's actual performance and will never be below the guaranteed minimum effective interest rate. The guaranteed minimum effective interest rate is based on 1.75% on 100% of premium. $160,000 $150,000 1.15% $140,000 2.16% 6.00% 5,55% $130,000 $120,000 6.00% 6.00% 18.49% $110,000 1.75% 2,16% 11,65% 100 1.75% 6.00% $100,000 -11.82% 5.55% 000% $90,000 8.44% -10.02% 21.94% $80,000 $70,000 -35.61% -21.27% $60,000 1/1/1999 1/1/2000 1/1/2001 1/1/2002 1/1/2003 1/1/2004 1/1/2005 1/1/2006 1/1/2007 1/1/2008 1/1/2009 Fund growing with annual change in S&P 500 index Account Value The above chart assumes an initial premium of $100,000. The S&P 500 Index value assumes the initial account value is evenly allocated among the stocks comprising the index. The S&P 500 is an index measuring the performance of selected stocks (excluding dividends); it is not an investment. Whereas investments in stocks underlying the S&P 500 can gain or lose value, including principal, the Annuity's principal is guaranteed, which eams interest and is subject to minimum interest guarantees and credited interest rate caps. Withdrawals will decrease account value and the dollar amount of future interest earned and may be subject to surrender charges
