Spreadsheet: 886985d1737057445-cells-need-to-trigger-changes-in-graph-2025-chart
Sheet: Chart

 | S&P 500 Annual Index Returns |  | 20% PR S&P 500 |  | 3% MYGA |  |  |  |  | S&P 500 Annual Index Returns |  |  |  | 40% PR S&P 500 |  | 3% MYGA
Year | S&P 500 | Account Value | Interest Credited | Account Value | MYGA | Account Value |  |  | Year | S&P 500 |  | S&P 500 |  | Interest Credited | FIA | MYGA | MYGA |  | CASH
1997 |  | 100000 |  | 100000 |  | 100000 |  |  | 1998 |  |  | 100000 |  |  | 100000 |  | 100000 |  | 100000
1998 | 0.2667 | 126670 | 0.05334 | 105330 | 0.03 | 103000 |  |  | 1999 | 0.1953 |  |  | 0.4 |  |  | 0.03 |  |  | 100000
1999 | 0.1953 | 151409 | 0.03906 | 109448 | 0.03 | 106090 |  |  | 2000 | -0.1014 |  |  | 0 |  |  |  |  |  | 100000
2000 | –10.14% | 136056 | 0 | 109448 | 0.03 | 109272.7 |  |  | 2001 | -0.1304 |  |  | 0 |  |  |  |  |  | 100000
2001 | –13.04% | 118314 | 0 | 109448 | 0.03 | 112550.89 |  |  | 2002 | -0.2337 |  |  | 0 |  |  |  |  |  | 100000
2002 | –23.37% | 90664 | 0 | 109448 | 0.03 | 115927.41 |  |  | 2003 | 0.2638 |  |  | 0.4 |  |  |  |  |  | 100000
2003 | 0.2638 | 114581 | 0.05276 | 115227 | 0.03 | 119405.23 |  |  | 2004 | 0.0899 |  |  | 0.4 |  |  |  |  |  | 100000
2004 | 0.0899 | 124882 | 0.01798 | 117301 | 0.03 | 122987.39 |  |  | 2005 | 0.03 |  |  | 0.4 |  |  |  |  |  | 100000
2005 | 0.03 | 128629 | 0.0006 | 124339 | 0.03 | 126677.01 |  |  | 2006 | 0.1362 |  |  | 0.4 |  |  |  |  |  | 100000
2006 | 0.1362 | 146148 | 0.02724 | 127721 | 0.03 | 130477.32 |  |  | 2007 | 0.0353 |  |  | 0.4 |  |  |  |  |  | 100000
2007 | 0.0353 | 151307 | 0.00706 | 128628 | 0.03 | 134391.64 |  |  | 2008 | -0.3849 |  |  | 0 |  |  |  |  |  | 100000
2008 | –38.49% | 93069 | 0 | 128628 | 0.03 | 138423.39 |  |  | 2009 | 0.2345 |  |  | 0.4 |  |  |  |  |  | 100000
2009 | 0.2345 | 117894 | 0.0469 | 134660 | 0.03 | 142576.09 |  |  | 2010 | 0.1278 |  |  | 0.4 |  |  |  |  |  | 100000
2010 | 0.1278 | 129577 | 0.02556 | 138108 | 0.03 | 146853.37 |  |  | 2011 | 0 |  |  | 0 |  |  |  |  |  | 100000
2011 | 0 | 129577 | 0 | 138108 | 0.03 | 151258.97 |  |  | 2012 | 0.1341 |  |  | 0.4 |  |  |  |  |  | 100000
2012 | 0.1341 | 146953 | 0.02682 | 141809 | 0.03 | 155796.74 |  |  | 2013 | 0.296 |  |  | 0.4 |  |  |  |  |  | 100000
2013 | 0.296 | 190451 | 0.0592 | 150204 | 0.03 | 160470.64 |  |  | 2014 | 0.1139 |  |  | 0.4 |  |  |  |  |  | 100000
2014 | 0.1139 | 212144 | 0.02278 | 153629 | 0.03 | 165284.76 |  |  | 2015 | -0.0073 |  |  | 0 |  |  |  |  |  | 100000
2015 | –0.73% | 210595 | 0 | 153629 | 0.03 | 170243.31 |  |  | 2016 | 0.0954 |  |  | 0.4 |  |  |  |  |  | 100000
2016 | 0.0954 | 230686 | 0.01908 | 156563 | 0.03 | 175350.61 |  |  | 2017 | 0.1942 |  |  | 0.4 |  |  |  |  |  | 100000
2017 | 0.1942 | 275485 | 0.03884 | 162638 | 0.03 | 180611.12 |  |  | 2018 | -0.0624 |  |  | 0 |  |  |  |  |  | 100000
2018 | –6.24% | 258295 | 0 | 162638 | 0.03 | 186029.46 |  |  | 2019 | 0.2888 |  |  | 0.4 |  |  |  |  |  | 100000
2019 | 0.2888 | 332891 | 0.05776 | 172038 | 0.03 | 191610.34 |  |  | 2020 | 0.1626 |  |  | 0.4 |  |  |  |  |  | 100000
2020 | 0.1626 | 387019 | 0.03252 | 177630 | 0.03 | 197358.65 |  |  | 2021 | 0.2689 |  |  | 0.4 |  |  |  |  |  | 100000
2021 | 0.2689 | 491088 | 0.05378 | 187186 | 0.03 | 203279.41 |  |  | 2022 | Input % |  | 312323 | Input 40% or 0% |  | 278662 |  | 203280 |  | 100000 |  | Note: the #Value! Errors will resolve themselves once you populate the orange highlighted cells
 |  |  |  |  |  |  |  |  | 2023 |  |  | 387905 |  |  | 305636 |  | 209378 |  | 100000
 |  |  |  |  |  |  |  |  | Year | S&P 500 |  | Account Value |  | Interest Credited | Account Value | MYGA | Account Value