Calculations of S&P 500 + BSPP Portfolio
Initial Portfolio Value: $ | PORTFOLIO | PERFORMANCE | REBALANCING | |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Time Period (March 2008 to December 2025) | Performance of Stand-alone S&P | Performance of Stand-alone BSPP (Net on protection Size) | Balance of Stand-alone S&P | Total Beginning Balance of S&P + BSPP | -Beginning Balance of S&P Portion | -Beginning Balance of BSPP Portion | BSPP Protection Size | Ending Balance of S&P Portion | Ending Balance of BSPP Portion | Total Ending Balance of S&P BSPP | Performance of S&P + BSPP | YE Attribution from BSPP | YE Attribution from BSPP | Deposits to S&P Portion | Deposits to BSPP Portion | Rebalanced S&P | Rebalanced BSPP | Ratio of BSPP to S&P | ||||||||
| 2008 | 100% | 1.67% | $200,000,000 | $100,000,000 | $98,330,000 | $1,670,000 | $98,330,000 | $196,660,000 | $3,312,111 | $199,972,111 | 99.97% | -0.03% | -$30,000 | -$27,423 | $27,423 | $196,632,577 | $3,339,534 | 1.70% | ||||||||
| 2009 | 100.00% | 1.67% | $400,000,000 | $199,972,111 | $196,632,577 | $3,339,534 | $196,632,577 | $393,265,154 | $6,623,298 | $399,888,452 | 99.97% | -0.03% | -$59,992 | -$54,839 | $54,839 | $393,210,315 | $6,678,137 | 1.70% | ||||||||
| 2010 | 100.00% | 1.67% | $800,000,000 | $399,888,452 | $393,210,315 | $6,678,137 | $393,210,315 | $786,420,630 | $13,244,749 | $799,665,379 | 99.97% | -0.03% | -$119,967 | -$109,663 | $109,663 | $786,310,967 | $13,354,412 | 1.70% | ||||||||
| 2011 | 100.00% | 1.67% | $1,600,000,000 | $799,665,379 | $786,310,967 | $13,354,412 | $786,310,967 | $1,572,621,934 | $26,485,805 | $1,599,107,739 | 99.97% | -0.03% | -$239,900 | -$219,294 | $219,294 | $1,572,402,640 | $26,705,099 | 1.70% | ||||||||
| 2012 | 100.00% | 1.67% | $3,200,000,000 | $1,599,107,739 | $1,572,402,640 | $26,705,099 | $1,572,402,640 | $3,144,805,280 | $52,964,223 | $3,197,769,503 | 99.97% | -0.03% | -$479,732 | -$438,528 | $438,528 | $3,144,366,752 | $53,402,751 | 1.70% | ||||||||
| 2013 | 100.00% | 1.67% | $6,400,000,000 | $3,197,769,503 | $3,144,366,752 | $53,402,751 | $3,144,366,752 | $6,288,733,504 | $105,913,676 | $6,394,647,180 | 99.97% | -0.03% | -$959,331 | -$876,932 | $876,932 | $6,287,856,572 | $106,790,608 | 1.70% | ||||||||
| 2014 | 100.00% | 1.67% | $12,800,000,000 | $6,394,647,180 | $6,287,856,572 | $106,790,608 | $6,287,856,572 | $12,575,713,144 | $211,797,813 | $12,787,510,957 | 99.97% | -0.03% | -$1,918,394 | -$1,753,620 | $1,753,620 | $12,573,959,524 | $213,551,433 | 1.70% | ||||||||
| 2015 | 100.00% | 1.67% | $25,600,000,000 | $12,787,510,957 | $12,573,959,524 | $213,551,433 | $12,573,959,524 | $25,147,919,048 | $423,536,557 | $25,571,455,605 | 99.97% | -0.03% | -$3,836,253 | -$3,506,752 | $3,506,752 | $25,144,412,296 | $427,043,309 | 1.70% | ||||||||
| 2016 | 100.00% | 1.67% | $51,200,000,000 | $25,571,455,605 | $25,144,412,296 | $427,043,309 | $25,144,412,296 | $50,288,824,592 | $846,954,994 | $51,135,779,586 | 99.97% | -0.03% | -$7,671,437 | -$7,012,525 | $7,012,525 | $50,281,812,067 | $853,967,519 | 1.70% | ||||||||
| 2017 | 100.00% | 1.67% | $102,400,000,000 | $51,135,779,586 | $50,281,812,067 | $853,967,519 | $50,281,812,067 | $100,563,624,134 | $1,693,673,781 | $102,257,297,915 | 99.97% | -0.03% | -$15,340,734 | -$14,023,094 | $14,023,094 | $100,549,601,040 | $1,707,696,875 | 1.70% | ||||||||
| 2018 | 100.00% | 1.67% | $204,800,000,000 | $102,257,297,915 | $100,549,601,040 | $1,707,696,875 | $100,549,601,040 | $201,099,202,080 | $3,386,875,212 | $204,486,077,292 | 99.97% | -0.03% | -$30,677,189 | -$28,042,279 | $28,042,279 | $201,071,159,801 | $3,414,917,491 | 1.70% | ||||||||
| 2019 | 100.00% | 1.67% | $409,600,000,000 | $204,486,077,292 | $201,071,159,801 | $3,414,917,491 | $201,071,159,801 | $402,142,319,602 | $6,772,805,860 | $408,915,125,462 | 99.97% | -0.03% | -$61,345,823 | -$56,076,735 | $56,076,735 | $402,086,242,867 | $6,828,882,595 | 1.70% | ||||||||
| 2020 | 100.00% | 1.67% | $819,200,000,000 | $408,915,125,462 | $402,086,242,867 | $6,828,882,595 | $402,086,242,867 | $804,172,485,734 | $13,543,722,851 | $817,716,208,585 | 99.97% | -0.03% | -$122,674,538 | -$112,137,832 | $112,137,832 | $804,060,347,902 | $13,655,860,683 | 1.70% | ||||||||
| 2021 | 100.00% | 1.67% | $1,638,400,000,000 | $817,716,208,585 | $804,060,347,902 | $13,655,860,683 | $804,060,347,902 | $1,608,120,695,804 | $27,083,668,493 | $1,635,204,364,297 | 99.97% | -0.03% | -$245,314,863 | -$224,244,391 | $224,244,391 | $1,607,896,451,413 | $27,307,912,884 | 1.70% | ||||||||
| 2022 | 100.00% | 1.67% | $3,276,800,000,000 | $1,635,204,364,297 | $1,607,896,451,413 | $27,307,912,884 | $1,607,896,451,413 | $3,215,792,902,826 | $54,159,783,623 | $3,269,952,686,449 | 99.97% | -0.03% | -$490,561,309 | -$448,426,241 | $448,426,241 | $3,215,344,476,585 | $54,608,209,864 | 1.70% | ||||||||
| 2023 | 100.00% | 1.67% | $6,553,600,000,000 | $3,269,952,686,449 | $3,215,344,476,585 | $54,608,209,864 | $3,215,344,476,585 | $6,430,688,953,170 | $108,304,462,623 | $6,538,993,415,793 | 99.97% | -0.03% | -$980,985,806 | -$896,727,421 | $896,727,421 | $6,429,792,225,749 | $109,201,190,044 | 1.70% | ||||||||
| 2024 | 100.00% | 1.67% | $13,107,200,000,000 | $6,538,993,415,793 | $6,429,792,225,749 | $109,201,190,044 | $6,429,792,225,749 | $12,859,584,451,498 | $216,578,720,214 | $13,076,163,171,712 | 99.97% | -0.03% | -$1,961,698,025 | -$1,793,204,754 | $1,793,204,754 | $12,857,791,246,744 | $218,371,924,968 | 1.70% | ||||||||
| 2025 | 100.00% | 1.67% | $26,214,400,000,000 | $13,076,163,171,712 | $12,857,791,246,744 | $218,371,924,968 | $12,857,791,246,744 | $25,715,582,493,488 | $433,097,038,789 | $26,148,679,532,277 | 99.97% | -0.03% | -$3,922,848,952 | -$3,585,909,400 | $3,585,909,400 | $25,711,996,584,088 | $436,682,948,189 | 1.70% | ||||||||