{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Rates","Portfolio","Mature","MatYrs","Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Rates","index":0,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Effective Date","Ready","Fixed Rate","Inflation Rate"]
["1998-09-01",true,3.4000000000000002E-2,6.1999999999999998E-3,false,"<-- display redemption value (enter TRUE or FALSE)"]
["1998-11-01",true,3.3000000000000002E-2,8.6E-3]
["1999-05-01",true,3.3000000000000002E-2,8.6E-3]
["1999-11-01",true,3.4000000000000002E-2,1.7600000000000001E-2]
["2000-05-01",true,3.5999999999999997E-2,1.9099999999999999E-2]
["2000-11-01",true,3.4000000000000002E-2,1.52E-2]
["2001-05-01",true,0.03,1.44E-2]
["2001-11-01",true,0.02,1.1900000000000001E-2]
["2002-05-01",true,0.02,2.8E-3]
["2002-11-01",true,1.6E-2,1.23E-2]
["2003-05-01",true,1.0999999999999999E-2,1.77E-2]
["2003-11-01",true,1.0999999999999999E-2,5.4000000000000003E-3]
["2004-05-01",true,0.01,1.1900000000000001E-2]
["2004-11-01",true,0.01,1.3299999999999999E-2]
["2005-05-01",true,1.2E-2,1.7899999999999999E-2]
["2005-11-01",true,0.01,2.8500000000000001E-2]
["2006-05-01",true,1.4E-2,5.0000000000000001E-3]
["2006-11-01",true,1.4E-2,1.55E-2]
["2007-05-01",true,1.2999999999999999E-2,1.21E-2]
["2007-11-01",true,1.2E-2,1.5299999999999999E-2]
["2008-05-01",true,0,2.4199999999999999E-2]
["2008-11-01",true,7.0000000000000001E-3,2.46E-2]
["2009-05-01",true,1E-3,-2.7799999999999998E-2]
["2009-11-01",true,3.0000000000000001E-3,1.5299999999999999E-2]
["2010-05-01",true,2E-3,7.7000000000000002E-3]
["2010-11-01",true,0,3.7000000000000002E-3]
["2011-05-01",true,0,2.3E-2]
["2011-11-01",true,0,1.5299999999999999E-2]
["2012-05-01",true,0,1.0999999999999999E-2]
["2012-11-01",true,0,8.8000000000000005E-3]
["2013-05-01",true,0,5.8999999999999999E-3]
["2013-11-01",true,2E-3,5.8999999999999999E-3]
["2014-05-01",true,1E-3,9.1999999999999998E-3]
["2014-11-01",true,0,7.4000000000000003E-3]
["2015-05-01",true,0,-8.0000000000000002E-3]
["2015-11-01",true,1E-3,7.7000000000000002E-3]
["2016-05-01",true,1E-3,8.0000000000000004E-4]
["2016-11-01",true,0,1.38E-2]
["2017-05-01",true,0,9.7999999999999997E-3]
["2017-11-01",true,1E-3,1.24E-2]
["2018-05-01",true,3.0000000000000001E-3,1.11E-2]
["2018-11-01",true,5.0000000000000001E-3,1.1599999999999999E-2]
["2019-05-01",true,5.0000000000000001E-3,7.0000000000000001E-3]
["2019-11-01",true,2E-3,1.01E-2]
["2020-05-01",true,0,5.3E-3]
["2020-11-01",true,0,8.3999999999999995E-3]
["2021-05-01",true,0,1.77E-2]
["2021-11-01",true,0,3.56E-2]
["2022-05-01",true,0,4.8099999999999997E-2]
["2022-11-01",true,4.0000000000000001E-3,3.2399999999999998E-2]
["2023-05-01",true,8.9999999999999993E-3,1.6899999999999998E-2]
["2023-11-01",true,1.2999999999999999E-2,1.9699999999999999E-2]
["2024-05-01",true,1.2999999999999999E-2,1.4800000000000001E-2]
["2024-11-01",true,1.2E-2,9.4999999999999998E-3]
["2025-05-01",true,1.0999999999999999E-2,1.43E-2]
["2025-11-01",false,0,0,"<-- Enter TRUE, Fixed Rate, & Inflation Rate when known."]
["2026-05-01",false,0,0]
["2026-11-01",false,0,0]
["2027-05-01",false,0,0]
["2027-11-01",false,0,0,"<-- If expand beyond this row, redefine rate_tbl range."]
[null,null,null,null,"(Formulas / Name Manager in Excel  365)"]

{"sheet":"Portfolio","index":1,"n_rows":59,"n_cols":20,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IF(disp_redemp, \"Redemption\", \"Full\")& \" Value\"","v":"Full Value"},2025,{"$f":"DATE($C$1-1,12,1)","v":"2024-12-01"},{"$f":"DATE($C$1,1,1)","v":"2025-01-01"},{"$f":"DATE($C$1,2,1)","v":"2025-02-01"},{"$f":"DATE($C$1,3,1)","v":"2025-03-01"},{"$f":"DATE($C$1,4,1)","v":"2025-04-01"},{"$f":"DATE($C$1,5,1)","v":"2025-05-01"},{"$f":"DATE($C$1,6,1)","v":"2025-06-01"},{"$f":"DATE($C$1,7,1)","v":"2025-07-01"},{"$f":"DATE($C$1,8,1)","v":"2025-08-01"},{"$f":"DATE($C$1,9,1)","v":"2025-09-01"},{"$f":"DATE($C$1,10,1)","v":"2025-10-01"},{"$f":"DATE($C$1,11,1)","v":"2025-11-01"},{"$f":"DATE($C$1,12,1)","v":"2025-12-01"},{"$f":"DATE($C$1+1,1,1)","v":"2026-01-01"},"Click for Value Web Page","Dec vs Dec","Jan vs Jan"]
[null,{"$f":"SUM(B$5:B$1000)","v":550000},null,{"$f":"SUM(D$5:D$1000)","v":1041912},{"$f":"SUM(E$5:E$1000)","v":1044860},1047824,1050808,1053744,1066668,1070444,1074272,1078092,1081912,1085784,1089708,{"$f":"SUM(P$5:P$1000)","v":1089964},1090224,"Total Value",{"$f":"SUM(S$5:S$1000)","v":38052},{"$f":"SUM(T$5:T$1000)","v":35364}]
["Purchase",null,null,{"$f":"D$2-SUMIF(D$5:D$1000,\">0\",$B$5:$B$1000)","v":501912},{"$f":"E$2-SUMIF(E$5:E$1000,\">0\",$B$5:$B$1000)","v":504860},507824,510808,513744,516668,520444,524272,528092,531912,535784,539708,{"$f":"P$2-SUMIF(P$5:P$1000,\">0\",$B$5:$B$1000)","v":539964},540224,"Total Interest"]
["Date","Amount","Fixed",null,{"$f":"E$3-D$3","v":2948},{"$f":"F$3-E$3","v":2964},2984,2936,2924,3776,3828,3820,3820,3872,3924,256,260,"Month's Interest"]
["1998-09-01",10000,{"$f":"IF(ISNUMBER($A5),VLOOKUP($A5,rate_tbl,3,TRUE),\"\")","v":3.4000000000000002E-2},47112,47360,47612,47864,48076,48284,48496,48712,48924,49140,49396,49652,49908,50168,"09-1998 history ",{"$f":"IF(ISNUMBER(P5), P5-MAX($B5,D5),0)","v":2796},2808]
["1998-11-01",10000,3.3000000000000002E-2,45892,46092,46288,46488,46688,46892,47132,47372,47616,47856,48104,48348,48348,48348,"11-1998 history ",2456,2256]
["1999-05-01",10000,3.3000000000000002E-2,44748,44940,45136,45328,45524,45720,45952,46188,46424,46660,46900,47140,47140,47140,"05-1999 history ",2392,2200]
["1999-11-01",10000,3.4000000000000002E-2,44668,44864,45060,45260,45456,45656,45892,46132,46372,46612,46852,47096,47096,47096,"11-1999 history ",2428,2232]
["2000-05-01",10000,3.5999999999999997E-2,45272,45480,45688,45896,46104,46316,46564,46812,47064,47316,47568,47824,47824,47824,"05-2000 history ",2552,2344]
["2000-11-01",10000,3.4000000000000002E-2,41664,41844,42028,42212,42400,42584,42804,43028,43252,43476,43700,43928,43928,43928,"11-2000 history ",2264,2084]
["2001-05-01",10000,0.03,36836,36988,37136,37288,37440,37592,37776,37960,38144,38328,38512,38700,38700,38700,"05-2001 history ",{"$f":"IF(ISNUMBER(P11), P11-MAX($B11,D11),0)","v":1864},{"$f":"IF(ISNUMBER(Q11), Q11-MAX($B11,E11),0)","v":1712}]
["2001-11-01",10000,0.02,28628,28720,28816,28908,29000,29096,29212,29332,29448,29568,29688,29808,29808,29808,"11-2001 history ",1180,1088]
["2002-05-01",10000,0.02,28016,28104,28196,28288,28380,28472,28588,28704,28816,28936,29052,29168,29168,29168,"05-2002 history ",1152,1064]
["2002-11-01",10000,1.6E-2,25396,25472,25544,25620,25696,25768,25864,25960,26056,26152,26248,26344,26344,26344,"11-2002 history ",948,872]
["2003-05-01",10000,1.0999999999999999E-2,22492,22548,22604,22660,22716,22772,22848,22924,22996,23072,23148,23224,23224,23224,"05-2003 history ",732,676]
["2003-11-01",10000,1.0999999999999999E-2,21944,21996,22052,22108,22164,22216,22288,22364,22436,22508,22584,22660,22660,22660,"11-2003 history ",716,664]
["2004-05-01",10000,0.01,21328,21380,21432,21480,21532,21584,21652,21724,21792,21860,21932,22000,22000,22000,"05-2004 history ",672,620]
["2004-11-01",10000,0.01,20944,20992,21044,21096,21144,21196,21264,21332,21400,21468,21536,21608,21608,21608,"11-2004 history ",664,616]
["2005-05-01",10000,1.2E-2,21348,21400,21456,21512,21568,21624,21696,21772,21844,21916,21992,22064,22064,22064,"05-2005 history ",716,664]
["2005-11-01",10000,0.01,20108,20156,20204,20256,20304,20352,20416,20484,20548,20612,20680,20744,20744,20744,"11-2005 history ",636,588]
["2006-05-01",10000,1.4E-2,20840,20900,20956,21012,21072,21128,21204,21276,21352,21428,21504,21580,21580,21580,"05-2006 history ",740,680]
["2006-11-01",10000,1.4E-2,20632,20688,20744,20804,20860,20916,20988,21064,21140,21212,21288,21364,21364,21364,"11-2006 history ",732,676]
["2007-05-01",10000,1.2999999999999999E-2,19820,19872,19928,19980,20032,20084,20152,20224,20292,20364,20432,20504,20504,20504,"05-2007 history ",684,632]
["2007-11-01",10000,1.2E-2,19152,19204,19252,19300,19352,19400,19464,19532,19596,19664,19728,19796,19796,19796,"11-2007 history ",644,592]
["2008-05-01",10000,0,15568,15592,15616,15644,15668,15692,15728,15768,15804,15840,15880,15916,15916,15916,"05-2008 history ",348,324]
["2008-11-01",10000,7.0000000000000001E-3,16884,16920,16956,16996,17032,17068,17120,17168,17220,17272,17320,17372,17372,17372,"11-2008 history ",488,452]
["2009-05-01",10000,1E-3,15060,15084,15112,15136,15160,15188,15224,15264,15300,15336,15376,15412,15412,15412,"05-2009 history ",352,328]
["2009-11-01",10000,3.0000000000000001E-3,15476,15504,15532,15560,15588,15616,15656,15696,15740,15780,15820,15864,15864,15864,"11-2009 history ",388,360]
["2010-05-01",10000,2E-3,15028,15052,15080,15104,15132,15156,15196,15232,15272,15312,15348,15388,15388,15388,"05-2010 history ",360,336]
["2010-11-01",10000,0,14496,14516,14540,14564,14588,14608,14644,14676,14712,14748,14780,14816,14816,14816,"11-2010 history ",320,300]
["2011-05-01",10000,0,14452,14472,14496,14520,14544,14564,14600,14632,14668,14704,14736,14772,14772,14772,"05-2011 history ",320,300]
["2011-11-01",10000,0,14116,14136,14160,14180,14204,14224,14256,14292,14324,14360,14392,14428,14428,14428,"11-2011 history ",312,292]
["2012-05-01",10000,0,13908,13932,13952,13976,13996,14020,14052,14088,14120,14152,14188,14220,14220,14220,"05-2012 history ",312,288]
["2012-11-01",10000,0,13744,13768,13788,13812,13832,13856,13888,13920,13956,13988,14020,14056,14056,14056,"11-2012 history ",312,288]
["2013-05-01",10000,0,13644,13668,13688,13712,13732,13752,13784,13816,13848,13884,13916,13948,13948,13948,"05-2013 history ",304,280]
["2013-11-01",10000,2E-3,13840,13864,13888,13912,13936,13960,13996,14032,14068,14104,14136,14172,14172,14172,"11-2013 history ",332,308]
["2014-05-01",10000,1E-3,13608,13628,13652,13676,13696,13720,13752,13788,13820,13856,13888,13924,13924,13924,"05-2014 history ",316,296]
["2014-11-01",10000,0,13348,13372,13392,13412,13432,13456,13488,13520,13552,13584,13616,13648,13648,13648,"11-2014 history ",300,276]
["2015-05-01",10000,0,13252,13272,13296,13316,13336,13356,13388,13420,13452,13484,13516,13548,13548,13548,"05-2015 history ",296,276]
["2015-11-01",10000,1E-3,13364,13384,13408,13428,13452,13472,13504,13540,13572,13604,13636,13672,13672,13672,"11-2015 history ",308,288]
["2016-05-01",10000,1E-3,13260,13284,13308,13328,13352,13372,13404,13436,13472,13504,13536,13568,13568,13568,"05-2016 history ",308,284]
["2016-11-01",10000,0,13144,13164,13188,13208,13228,13248,13280,13312,13344,13372,13404,13436,13436,13436,"11-2016 history ",292,272]
["2017-05-01",10000,0,12960,12980,13000,13020,13044,13064,13096,13124,13156,13188,13220,13252,13252,13252,"05-2017 history ",292,272]
["2017-11-01",10000,1E-3,12916,12940,12960,12980,13004,13024,13056,13088,13120,13152,13184,13216,13216,13216,"11-2017 history ",300,276]
["2018-05-01",10000,3.0000000000000001E-3,12932,12956,12980,13004,13028,13048,13084,13116,13152,13184,13220,13256,13256,13256,"05-2018 history ",{"$f":"IF(ISNUMBER(P45), P45-MAX($B45,D45),0)","v":324},{"$f":"IF(ISNUMBER(Q45), Q45-MAX($B45,E45),0)","v":300}]
["2018-11-01",10000,5.0000000000000001E-3,12916,12944,12968,12996,13020,13048,13084,13120,13156,13196,13232,13268,13268,13268,"11-2018 history ",352,324]
["2019-05-01",10000,5.0000000000000001E-3,12740,12768,12792,12816,12844,12868,12904,12940,12976,13012,13048,13084,13084,13084,"05-2019 history ",344,316]
["2019-11-01",10000,2E-3,12432,12456,12476,12500,12520,12544,12576,12608,12640,12672,12704,12736,12736,12736,"11-2019 history ",304,280]
["2020-05-01",10000,0,12184,12204,12220,12240,12260,12280,12308,12340,12368,12396,12428,12456,12456,12456,"05-2020 history ",272,252]
["2020-11-01",10000,0,12124,12144,12160,12180,12200,12220,12248,12276,12308,12336,12364,12396,12396,12396,"11-2020 history ",272,252]
["2021-05-01",10000,0,12020,12036,12056,12076,12096,12116,12144,12172,12204,12232,12260,12288,12288,12288,"05-2021 history ",268,252]
["2021-11-01",10000,0,11812,11828,11848,11868,11884,11904,11932,11960,11988,12016,12044,12076,12076,12076,"11-2021 history ",264,248]
["2022-05-01",10000,0,11404,11424,11440,11460,11480,11496,11524,11552,11576,11604,11632,11660,11660,11660,"05-2022 history ",256,236]
["2022-11-01",10000,4.0000000000000001E-3,10968,10988,11012,11032,11052,11072,11100,11132,11164,11192,11224,11252,11252,11252,"11-2022 history ",{"$f":"IF(ISNUMBER(P54), P54-MAX($B54,D54),0)","v":284},{"$f":"IF(ISNUMBER(Q54), Q54-MAX($B54,E54),0)","v":264}]
["2023-05-01",10000,8.9999999999999993E-3,10692,10716,10744,10768,10792,10816,10848,10884,10916,10952,10984,11020,11020,11020,"05-2023 history ",{"$f":"IF(ISNUMBER(P55), P55-MAX($B55,D55),0)","v":328},{"$f":"IF(ISNUMBER(Q55), Q55-MAX($B55,E55),0)","v":304}]
["2023-11-01",10000,1.2999999999999999E-2,10512,10540,10568,10596,10624,10652,10688,10724,10764,10800,10836,10876,10876,10876,"11-2023 history ",364,{"$f":"IF(ISNUMBER(Q56), Q56-MAX($B56,E56),0)","v":336}]
["2024-05-01",10000,1.2999999999999999E-2,10244,10272,10296,10324,10352,10380,10416,10452,10488,10524,10560,10596,10596,10596,"05-2024 history ",{"$f":"IF(ISNUMBER(P57), P57-MAX($B57,D57),0)","v":352},{"$f":"IF(ISNUMBER(Q57), Q57-MAX($B57,E57),0)","v":324}]
["2024-11-01",10000,1.2E-2,10024,10052,10076,10104,10128,10156,10192,10224,10260,10292,10328,10364,10364,10364,"11-2024 history ",340,312]
["2025-05-01",10000,1.0999999999999999E-2,null,null,null,null,null,10000,10032,10064,10100,10132,10164,10200,10200,10200,"05-2025 history ",{"$f":"IF(ISNUMBER(P59), P59-MAX($B59,D59),0)","v":200},{"$f":"IF(ISNUMBER(Q59), Q59-MAX($B59,E59),0)","v":200}]

{"sheet":"Mature","index":2,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["                                                                                                              "]
["m/yyyy;;","###,##0;;","#0.0%","###,##0.00;;","m/yyyy;;","m/yyyy;;","###0;;","#0.0;;","#0.00%;;",{"$f":"$B2","v":"###,##0;;"},{"$f":"$B2","v":"###,##0;;"}]
[12,9,7,14,8,9,6,7,7,11,11]
["Last rates",{"$f":"INDEX(Rates!A:A,MATCH(FALSE,Rates!B:B,0)-1,0)","v":"2025-05-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(\"   \"&ROW(A4),3)&RIGHT(A$1&A4,A$3)&RIGHT(A$1&TEXT(B4,A2),B$3)","v":"  4  Last rates   5/2025"}]
["Future CPI",0.02,"<-- Enter future inflation assumption",null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(\"   \"&ROW(A5),3)&RIGHT(A$1&A5,A$3)&RIGHT(A$1&TEXT(B5,C$2),B$3)","v":"  5  Future CPI     2.0%"}]
[null,"Face","Fixed","Now",null,null,null,"Remain","Comp","Grows",null,null,{"$f":"RIGHT(\"   \"&ROW(A6),3)&RIGHT(A$1&A6,A$3)&RIGHT(A$1&B6,B$3)&RIGHT(A$1&C6,C$3)&RIGHT(A$1&D6,D$3)&RIGHT(A$1&E6,E$3)&RIGHT(A$1&F6,F$3)&RIGHT(A$1&G6,G$3)&RIGHT(A$1&H6,H$3)&RIGHT(A$1&I6,I$3)&RIGHT(A$1&J6,J$3)&RIGHT(A$1&K6,K$3)","v":"  6                 Face  Fixed           Now                        Remain   Comp      Grows           "}]
["Bought","Value","Rate","Worth","As of","Matures","Year","Life","Rate","To","Gain",null,{"$f":"RIGHT(\"   \"&ROW(A7),3)&RIGHT(A$1&A7,A$3)&RIGHT(A$1&B7,B$3)&RIGHT(A$1&C7,C$3)&RIGHT(A$1&D7,D$3)&RIGHT(A$1&E7,E$3)&RIGHT(A$1&F7,F$3)&RIGHT(A$1&G7,G$3)&RIGHT(A$1&H7,H$3)&RIGHT(A$1&I7,I$3)&RIGHT(A$1&J7,J$3)&RIGHT(A$1&K7,K$3)","v":"  7      Bought    Value   Rate         Worth   As of  Matures  Year   Life   Rate         To       Gain"}]
["Sum",{"$f":"SUM(B9:B1000)","v":550000},null,{"$f":"SUM(D9:D1000)","v":1089964},null,null,null,null,null,{"$f":"SUM(J9:J1000)","v":1556987},{"$f":"J8-B8","v":1006987},null,{"$f":"RIGHT(\"   \"&ROW(A8),3)&RIGHT(A$1&TEXT(A8,A$2),A$3)&RIGHT(A$1&TEXT(B8,B$2),B$3)&RIGHT(A$1&TEXT(D8,D$2),C$3+D$3)&RIGHT(A$1&TEXT(J8,J$2),E$3+F$3+G$3+H$3+I$3+J$3)&RIGHT(A$1&TEXT(K8,K$2),K$3)","v":"  8         Sum  550,000         1,089,964.00                                       1,556,987  1,006,987"}]
[{"$f":"IF(ISNUMBER(Portfolio!A5),Portfolio!A5,\"\")","v":"1998-09-01"},{"$f":"IF(ISNUMBER(Portfolio!B5),Portfolio!B5,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C5),Portfolio!C5,\"\")","v":3.4000000000000002E-2},{"$f":"IF(ISNUMBER(Portfolio!P5),Portfolio!P5,\"\")","v":49908},{"$f":"IF(ISNUMBER(A9),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A9),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A9),6)<5,6,0),DAY(B$4)),\"\")","v":"2026-03-01"},{"$f":"IF(ISNUMBER(A9),DATE(YEAR(A9)+30,MONTH(A9),DAY(A9)),\"\")","v":"2028-09-01"},{"$f":"IF(ISNUMBER(A9),YEAR(F9),\"\")","v":2028},{"$f":"IF(ISNUMBER(A9),YEAR(F9)-YEAR(E9)+(MONTH(F9)-MONTH(E9))/12,\"\")","v":2.5},{"$f":"IF(ISNUMBER(A9),ROUND(C9+B$5+C9*(B$5/2),4),\"\")","v":5.4300000000000001E-2},{"$f":"IF(ISNUMBER(A9),ROUND(D9*(1+I9/2)^(H9*2),0),\"\")","v":57061},{"$f":"IF(ISNUMBER(A9),J9-B9,\"\")","v":47061},null,{"$f":"RIGHT(\"   \"&ROW(A9),3)&RIGHT(A$1&TEXT(A9,A$2),A$3)&RIGHT(A$1&TEXT(B9,B$2),B$3)&RIGHT(A$1&TEXT(C9,C$2),C$3)&RIGHT(A$1&TEXT(D9,D$2),D$3)&RIGHT(A$1&TEXT(E9,E$2),E$3)&RIGHT(A$1&TEXT(F9,F$2),F$3)&RIGHT(A$1&TEXT(G9,G$2),G$3)&RIGHT(A$1&TEXT(H9,H$2),H$3)&RIGHT(A$1&TEXT(I9,I$2),I$3)&RIGHT(A$1&TEXT(J9,J$2),J$3)&RIGHT(A$1&TEXT(K9,K$2),K$3)","v":"  9      9/1998   10,000   3.4%     49,908.00  3/2026   9/2028  2028    2.5  5.43%     57,061     47,061"}]
[{"$f":"IF(ISNUMBER(Portfolio!A6),Portfolio!A6,\"\")","v":"1998-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B6),Portfolio!B6,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C6),Portfolio!C6,\"\")","v":3.3000000000000002E-2},{"$f":"IF(ISNUMBER(Portfolio!P6),Portfolio!P6,\"\")","v":48348},{"$f":"IF(ISNUMBER(A10),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A10),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A10),6)<5,6,0),DAY(B$4)),\"\")","v":"2025-11-01"},{"$f":"IF(ISNUMBER(A10),DATE(YEAR(A10)+30,MONTH(A10),DAY(A10)),\"\")","v":"2028-11-01"},{"$f":"IF(ISNUMBER(A10),YEAR(F10),\"\")","v":2028},{"$f":"IF(ISNUMBER(A10),YEAR(F10)-YEAR(E10)+(MONTH(F10)-MONTH(E10))/12,\"\")","v":3},{"$f":"IF(ISNUMBER(A10),ROUND(C10+B$5+C10*(B$5/2),4),\"\")","v":5.33E-2},{"$f":"IF(ISNUMBER(A10),ROUND(D10*(1+I10/2)^(H10*2),0),\"\")","v":56613},{"$f":"IF(ISNUMBER(A10),J10-B10,\"\")","v":46613},null,{"$f":"RIGHT(\"   \"&ROW(A10),3)&RIGHT(A$1&TEXT(A10,A$2),A$3)&RIGHT(A$1&TEXT(B10,B$2),B$3)&RIGHT(A$1&TEXT(C10,C$2),C$3)&RIGHT(A$1&TEXT(D10,D$2),D$3)&RIGHT(A$1&TEXT(E10,E$2),E$3)&RIGHT(A$1&TEXT(F10,F$2),F$3)&RIGHT(A$1&TEXT(G10,G$2),G$3)&RIGHT(A$1&TEXT(H10,H$2),H$3)&RIGHT(A$1&TEXT(I10,I$2),I$3)&RIGHT(A$1&TEXT(J10,J$2),J$3)&RIGHT(A$1&TEXT(K10,K$2),K$3)","v":" 10     11/1998   10,000   3.3%     48,348.00 11/2025  11/2028  2028    3.0  5.33%     56,613     46,613"}]
[{"$f":"IF(ISNUMBER(Portfolio!A7),Portfolio!A7,\"\")","v":"1999-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B7),Portfolio!B7,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C7),Portfolio!C7,\"\")","v":3.3000000000000002E-2},{"$f":"IF(ISNUMBER(Portfolio!P7),Portfolio!P7,\"\")","v":47140},"2025-11-01","2029-05-01",2029,3.5,5.33E-2,56669,46669,null," 11      5/1999   10,000   3.3%     47,140.00 11/2025   5/2029  2029    3.5  5.33%     56,669     46,669"]
[{"$f":"IF(ISNUMBER(Portfolio!A8),Portfolio!A8,\"\")","v":"1999-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B8),Portfolio!B8,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C8),Portfolio!C8,\"\")","v":3.4000000000000002E-2},{"$f":"IF(ISNUMBER(Portfolio!P8),Portfolio!P8,\"\")","v":47096},"2025-11-01","2029-11-01",2029,4,5.4300000000000001E-2,58352,48352,null," 12     11/1999   10,000   3.4%     47,096.00 11/2025  11/2029  2029    4.0  5.43%     58,352     48,352"]
[{"$f":"IF(ISNUMBER(Portfolio!A9),Portfolio!A9,\"\")","v":"2000-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B9),Portfolio!B9,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C9),Portfolio!C9,\"\")","v":3.5999999999999997E-2},{"$f":"IF(ISNUMBER(Portfolio!P9),Portfolio!P9,\"\")","v":47824},"2025-11-01","2030-05-01",2030,4.5,5.6399999999999999E-2,61425,51425,null," 13      5/2000   10,000   3.6%     47,824.00 11/2025   5/2030  2030    4.5  5.64%     61,425     51,425"]
[{"$f":"IF(ISNUMBER(Portfolio!A10),Portfolio!A10,\"\")","v":"2000-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B10),Portfolio!B10,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C10),Portfolio!C10,\"\")","v":3.4000000000000002E-2},{"$f":"IF(ISNUMBER(Portfolio!P10),Portfolio!P10,\"\")","v":43928},"2025-11-01","2030-11-01",2030,5,5.4300000000000001E-2,57422,47422,null," 14     11/2000   10,000   3.4%     43,928.00 11/2025  11/2030  2030    5.0  5.43%     57,422     47,422"]
[{"$f":"IF(ISNUMBER(Portfolio!A11),Portfolio!A11,\"\")","v":"2001-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B11),Portfolio!B11,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C11),Portfolio!C11,\"\")","v":0.03},{"$f":"IF(ISNUMBER(Portfolio!P11),Portfolio!P11,\"\")","v":38700},"2025-11-01","2031-05-01",2031,5.5,5.0299999999999997E-2,50860,40860,null," 15      5/2001   10,000   3.0%     38,700.00 11/2025   5/2031  2031    5.5  5.03%     50,860     40,860"]
[{"$f":"IF(ISNUMBER(Portfolio!A12),Portfolio!A12,\"\")","v":"2001-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B12),Portfolio!B12,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C12),Portfolio!C12,\"\")","v":0.02},{"$f":"IF(ISNUMBER(Portfolio!P12),Portfolio!P12,\"\")","v":29808},"2025-11-01","2031-11-01",2031,6,4.02E-2,37848,27848,null," 16     11/2001   10,000   2.0%     29,808.00 11/2025  11/2031  2031    6.0  4.02%     37,848     27,848"]
[{"$f":"IF(ISNUMBER(Portfolio!A13),Portfolio!A13,\"\")","v":"2002-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B13),Portfolio!B13,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C13),Portfolio!C13,\"\")","v":0.02},{"$f":"IF(ISNUMBER(Portfolio!P13),Portfolio!P13,\"\")","v":29168},"2025-11-01","2032-05-01",2032,6.5,4.02E-2,37780,27780,null," 17      5/2002   10,000   2.0%     29,168.00 11/2025   5/2032  2032    6.5  4.02%     37,780     27,780"]
[{"$f":"IF(ISNUMBER(Portfolio!A14),Portfolio!A14,\"\")","v":"2002-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B14),Portfolio!B14,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C14),Portfolio!C14,\"\")","v":1.6E-2},{"$f":"IF(ISNUMBER(Portfolio!P14),Portfolio!P14,\"\")","v":26344},"2025-11-01","2032-11-01",2032,7,3.6200000000000003E-2,33865,23865,null," 18     11/2002   10,000   1.6%     26,344.00 11/2025  11/2032  2032    7.0  3.62%     33,865     23,865"]
[{"$f":"IF(ISNUMBER(Portfolio!A15),Portfolio!A15,\"\")","v":"2003-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B15),Portfolio!B15,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C15),Portfolio!C15,\"\")","v":1.0999999999999999E-2},{"$f":"IF(ISNUMBER(Portfolio!P15),Portfolio!P15,\"\")","v":23224},"2025-11-01","2033-05-01",2033,7.5,3.1099999999999999E-2,29272,19272,null," 19      5/2003   10,000   1.1%     23,224.00 11/2025   5/2033  2033    7.5  3.11%     29,272     19,272"]
[{"$f":"IF(ISNUMBER(Portfolio!A16),Portfolio!A16,\"\")","v":"2003-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B16),Portfolio!B16,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C16),Portfolio!C16,\"\")","v":1.0999999999999999E-2},{"$f":"IF(ISNUMBER(Portfolio!P16),Portfolio!P16,\"\")","v":22660},"2025-11-01","2033-11-01",2033,8,3.1099999999999999E-2,29006,19006,null," 20     11/2003   10,000   1.1%     22,660.00 11/2025  11/2033  2033    8.0  3.11%     29,006     19,006"]
[{"$f":"IF(ISNUMBER(Portfolio!A17),Portfolio!A17,\"\")","v":"2004-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B17),Portfolio!B17,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C17),Portfolio!C17,\"\")","v":0.01},{"$f":"IF(ISNUMBER(Portfolio!P17),Portfolio!P17,\"\")","v":22000},"2025-11-01","2034-05-01",2034,8.5,3.0099999999999998E-2,28360,18360,null," 21      5/2004   10,000   1.0%     22,000.00 11/2025   5/2034  2034    8.5  3.01%     28,360     18,360"]
[{"$f":"IF(ISNUMBER(Portfolio!A18),Portfolio!A18,\"\")","v":"2004-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B18),Portfolio!B18,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C18),Portfolio!C18,\"\")","v":0.01},{"$f":"IF(ISNUMBER(Portfolio!P18),Portfolio!P18,\"\")","v":21608},"2025-11-01","2034-11-01",2034,9,3.0099999999999998E-2,28274,18274,null," 22     11/2004   10,000   1.0%     21,608.00 11/2025  11/2034  2034    9.0  3.01%     28,274     18,274"]
[{"$f":"IF(ISNUMBER(Portfolio!A19),Portfolio!A19,\"\")","v":"2005-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B19),Portfolio!B19,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C19),Portfolio!C19,\"\")","v":1.2E-2},{"$f":"IF(ISNUMBER(Portfolio!P19),Portfolio!P19,\"\")","v":22064},"2025-11-01","2035-05-01",2035,9.5,3.2099999999999997E-2,29859,19859,null," 23      5/2005   10,000   1.2%     22,064.00 11/2025   5/2035  2035    9.5  3.21%     29,859     19,859"]
[{"$f":"IF(ISNUMBER(Portfolio!A20),Portfolio!A20,\"\")","v":"2005-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B20),Portfolio!B20,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C20),Portfolio!C20,\"\")","v":0.01},{"$f":"IF(ISNUMBER(Portfolio!P20),Portfolio!P20,\"\")","v":20744},"2025-11-01","2035-11-01",2035,10,3.0099999999999998E-2,27967,17967,null," 24     11/2005   10,000   1.0%     20,744.00 11/2025  11/2035  2035   10.0  3.01%     27,967     17,967"]
[{"$f":"IF(ISNUMBER(Portfolio!A21),Portfolio!A21,\"\")","v":"2006-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B21),Portfolio!B21,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C21),Portfolio!C21,\"\")","v":1.4E-2},{"$f":"IF(ISNUMBER(Portfolio!P21),Portfolio!P21,\"\")","v":21580},"2025-11-01","2036-05-01",2036,10.5,3.4099999999999998E-2,30778,20778,null,{"$f":"RIGHT(\"   \"&ROW(A25),3)&RIGHT(A$1&TEXT(A25,A$2),A$3)&RIGHT(A$1&TEXT(B25,B$2),B$3)&RIGHT(A$1&TEXT(C25,C$2),C$3)&RIGHT(A$1&TEXT(D25,D$2),D$3)&RIGHT(A$1&TEXT(E25,E$2),E$3)&RIGHT(A$1&TEXT(F25,F$2),F$3)&RIGHT(A$1&TEXT(G25,G$2),G$3)&RIGHT(A$1&TEXT(H25,H$2),H$3)&RIGHT(A$1&TEXT(I25,I$2),I$3)&RIGHT(A$1&TEXT(J25,J$2),J$3)&RIGHT(A$1&TEXT(K25,K$2),K$3)","v":" 25      5/2006   10,000   1.4%     21,580.00 11/2025   5/2036  2036   10.5  3.41%     30,778     20,778"}]
[{"$f":"IF(ISNUMBER(Portfolio!A22),Portfolio!A22,\"\")","v":"2006-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B22),Portfolio!B22,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C22),Portfolio!C22,\"\")","v":1.4E-2},{"$f":"IF(ISNUMBER(Portfolio!P22),Portfolio!P22,\"\")","v":21364},"2025-11-01","2036-11-01",2036,11,3.4099999999999998E-2,30989,20989,null," 26     11/2006   10,000   1.4%     21,364.00 11/2025  11/2036  2036   11.0  3.41%     30,989     20,989"]
[{"$f":"IF(ISNUMBER(Portfolio!A23),Portfolio!A23,\"\")","v":"2007-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B23),Portfolio!B23,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C23),Portfolio!C23,\"\")","v":1.2999999999999999E-2},{"$f":"IF(ISNUMBER(Portfolio!P23),Portfolio!P23,\"\")","v":20504},"2025-11-01","2037-05-01",2037,11.5,3.3099999999999997E-2,29909,19909,null," 27      5/2007   10,000   1.3%     20,504.00 11/2025   5/2037  2037   11.5  3.31%     29,909     19,909"]
[{"$f":"IF(ISNUMBER(Portfolio!A24),Portfolio!A24,\"\")","v":"2007-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B24),Portfolio!B24,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C24),Portfolio!C24,\"\")","v":1.2E-2},{"$f":"IF(ISNUMBER(Portfolio!P24),Portfolio!P24,\"\")","v":19796},"2025-11-01","2037-11-01",2037,12,3.2099999999999997E-2,29009,19009,null," 28     11/2007   10,000   1.2%     19,796.00 11/2025  11/2037  2037   12.0  3.21%     29,009     19,009"]
[{"$f":"IF(ISNUMBER(Portfolio!A25),Portfolio!A25,\"\")","v":"2008-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B25),Portfolio!B25,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C25),Portfolio!C25,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P25),Portfolio!P25,\"\")","v":15916},"2025-11-01","2038-05-01",2038,12.5,0.02,20411,10411,null," 29      5/2008   10,000   0.0%     15,916.00 11/2025   5/2038  2038   12.5  2.00%     20,411     10,411"]
[{"$f":"IF(ISNUMBER(Portfolio!A26),Portfolio!A26,\"\")","v":"2008-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B26),Portfolio!B26,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C26),Portfolio!C26,\"\")","v":7.0000000000000001E-3},{"$f":"IF(ISNUMBER(Portfolio!P26),Portfolio!P26,\"\")","v":17372},"2025-11-01","2038-11-01",2038,13,2.7099999999999999E-2,24650,14650,null," 30     11/2008   10,000   0.7%     17,372.00 11/2025  11/2038  2038   13.0  2.71%     24,650     14,650"]
[{"$f":"IF(ISNUMBER(Portfolio!A27),Portfolio!A27,\"\")","v":"2009-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B27),Portfolio!B27,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C27),Portfolio!C27,\"\")","v":1E-3},{"$f":"IF(ISNUMBER(Portfolio!P27),Portfolio!P27,\"\")","v":15412},{"$f":"IF(ISNUMBER(A31),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A31),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A31),6)<5,6,0),DAY(B$4)),\"\")","v":"2025-11-01"},{"$f":"IF(ISNUMBER(A31),DATE(YEAR(A31)+30,MONTH(A31),DAY(A31)),\"\")","v":"2039-05-01"},{"$f":"IF(ISNUMBER(A31),YEAR(F31),\"\")","v":2039},{"$f":"IF(ISNUMBER(A31),YEAR(F31)-YEAR(E31)+(MONTH(F31)-MONTH(E31))/12,\"\")","v":13.5},{"$f":"IF(ISNUMBER(A31),ROUND(C31+B$5+C31*(B$5/2),4),\"\")","v":2.1000000000000001E-2},{"$f":"IF(ISNUMBER(A31),ROUND(D31*(1+I31/2)^(H31*2),0),\"\")","v":20433},{"$f":"IF(ISNUMBER(A31),J31-B31,\"\")","v":10433},null,{"$f":"RIGHT(\"   \"&ROW(A31),3)&RIGHT(A$1&TEXT(A31,A$2),A$3)&RIGHT(A$1&TEXT(B31,B$2),B$3)&RIGHT(A$1&TEXT(C31,C$2),C$3)&RIGHT(A$1&TEXT(D31,D$2),D$3)&RIGHT(A$1&TEXT(E31,E$2),E$3)&RIGHT(A$1&TEXT(F31,F$2),F$3)&RIGHT(A$1&TEXT(G31,G$2),G$3)&RIGHT(A$1&TEXT(H31,H$2),H$3)&RIGHT(A$1&TEXT(I31,I$2),I$3)&RIGHT(A$1&TEXT(J31,J$2),J$3)&RIGHT(A$1&TEXT(K31,K$2),K$3)","v":" 31      5/2009   10,000   0.1%     15,412.00 11/2025   5/2039  2039   13.5  2.10%     20,433     10,433"}]
[{"$f":"IF(ISNUMBER(Portfolio!A28),Portfolio!A28,\"\")","v":"2009-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B28),Portfolio!B28,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C28),Portfolio!C28,\"\")","v":3.0000000000000001E-3},{"$f":"IF(ISNUMBER(Portfolio!P28),Portfolio!P28,\"\")","v":15864},"2025-11-01","2039-11-01",2039,14,2.3E-2,21850,11850,null," 32     11/2009   10,000   0.3%     15,864.00 11/2025  11/2039  2039   14.0  2.30%     21,850     11,850"]
[{"$f":"IF(ISNUMBER(Portfolio!A29),Portfolio!A29,\"\")","v":"2010-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B29),Portfolio!B29,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C29),Portfolio!C29,\"\")","v":2E-3},{"$f":"IF(ISNUMBER(Portfolio!P29),Portfolio!P29,\"\")","v":15388},"2025-11-01","2040-05-01",2040,14.5,2.1999999999999999E-2,21133,11133,null," 33      5/2010   10,000   0.2%     15,388.00 11/2025   5/2040  2040   14.5  2.20%     21,133     11,133"]
[{"$f":"IF(ISNUMBER(Portfolio!A30),Portfolio!A30,\"\")","v":"2010-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B30),Portfolio!B30,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C30),Portfolio!C30,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P30),Portfolio!P30,\"\")","v":14816},"2025-11-01","2040-11-01",2040,15,0.02,19970,9970,null," 34     11/2010   10,000   0.0%     14,816.00 11/2025  11/2040  2040   15.0  2.00%     19,970      9,970"]
[{"$f":"IF(ISNUMBER(Portfolio!A31),Portfolio!A31,\"\")","v":"2011-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B31),Portfolio!B31,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C31),Portfolio!C31,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P31),Portfolio!P31,\"\")","v":14772},"2025-11-01","2041-05-01",2041,15.5,0.02,20110,10110,null," 35      5/2011   10,000   0.0%     14,772.00 11/2025   5/2041  2041   15.5  2.00%     20,110     10,110"]
[{"$f":"IF(ISNUMBER(Portfolio!A32),Portfolio!A32,\"\")","v":"2011-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B32),Portfolio!B32,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C32),Portfolio!C32,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P32),Portfolio!P32,\"\")","v":14428},{"$f":"IF(ISNUMBER(A36),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A36),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A36),6)<5,6,0),DAY(B$4)),\"\")","v":"2025-11-01"},{"$f":"IF(ISNUMBER(A36),DATE(YEAR(A36)+30,MONTH(A36),DAY(A36)),\"\")","v":"2041-11-01"},{"$f":"IF(ISNUMBER(A36),YEAR(F36),\"\")","v":2041},{"$f":"IF(ISNUMBER(A36),YEAR(F36)-YEAR(E36)+(MONTH(F36)-MONTH(E36))/12,\"\")","v":16},{"$f":"IF(ISNUMBER(A36),ROUND(C36+B$5+C36*(B$5/2),4),\"\")","v":0.02},{"$f":"IF(ISNUMBER(A36),ROUND(D36*(1+I36/2)^(H36*2),0),\"\")","v":19838},{"$f":"IF(ISNUMBER(A36),J36-B36,\"\")","v":9838},null,{"$f":"RIGHT(\"   \"&ROW(A36),3)&RIGHT(A$1&TEXT(A36,A$2),A$3)&RIGHT(A$1&TEXT(B36,B$2),B$3)&RIGHT(A$1&TEXT(C36,C$2),C$3)&RIGHT(A$1&TEXT(D36,D$2),D$3)&RIGHT(A$1&TEXT(E36,E$2),E$3)&RIGHT(A$1&TEXT(F36,F$2),F$3)&RIGHT(A$1&TEXT(G36,G$2),G$3)&RIGHT(A$1&TEXT(H36,H$2),H$3)&RIGHT(A$1&TEXT(I36,I$2),I$3)&RIGHT(A$1&TEXT(J36,J$2),J$3)&RIGHT(A$1&TEXT(K36,K$2),K$3)","v":" 36     11/2011   10,000   0.0%     14,428.00 11/2025  11/2041  2041   16.0  2.00%     19,838      9,838"}]
[{"$f":"IF(ISNUMBER(Portfolio!A33),Portfolio!A33,\"\")","v":"2012-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B33),Portfolio!B33,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C33),Portfolio!C33,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P33),Portfolio!P33,\"\")","v":14220},"2025-11-01","2042-05-01",2042,16.5,0.02,19747,9747,null," 37      5/2012   10,000   0.0%     14,220.00 11/2025   5/2042  2042   16.5  2.00%     19,747      9,747"]
[{"$f":"IF(ISNUMBER(Portfolio!A34),Portfolio!A34,\"\")","v":"2012-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B34),Portfolio!B34,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C34),Portfolio!C34,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P34),Portfolio!P34,\"\")","v":14056},"2025-11-01","2042-11-01",2042,17,0.02,19715,9715,null," 38     11/2012   10,000   0.0%     14,056.00 11/2025  11/2042  2042   17.0  2.00%     19,715      9,715"]
[{"$f":"IF(ISNUMBER(Portfolio!A35),Portfolio!A35,\"\")","v":"2013-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B35),Portfolio!B35,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C35),Portfolio!C35,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P35),Portfolio!P35,\"\")","v":13948},"2025-11-01","2043-05-01",2043,17.5,0.02,19759,9759,null," 39      5/2013   10,000   0.0%     13,948.00 11/2025   5/2043  2043   17.5  2.00%     19,759      9,759"]
[{"$f":"IF(ISNUMBER(Portfolio!A36),Portfolio!A36,\"\")","v":"2013-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B36),Portfolio!B36,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C36),Portfolio!C36,\"\")","v":2E-3},{"$f":"IF(ISNUMBER(Portfolio!P36),Portfolio!P36,\"\")","v":14172},"2025-11-01","2043-11-01",2043,18,2.1999999999999999E-2,21012,11012,null," 40     11/2013   10,000   0.2%     14,172.00 11/2025  11/2043  2043   18.0  2.20%     21,012     11,012"]
[{"$f":"IF(ISNUMBER(Portfolio!A37),Portfolio!A37,\"\")","v":"2014-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B37),Portfolio!B37,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C37),Portfolio!C37,\"\")","v":1E-3},{"$f":"IF(ISNUMBER(Portfolio!P37),Portfolio!P37,\"\")","v":13924},"2025-11-01","2044-05-01",2044,18.5,2.1000000000000001E-2,20493,10493,null," 41      5/2014   10,000   0.1%     13,924.00 11/2025   5/2044  2044   18.5  2.10%     20,493     10,493"]
[{"$f":"IF(ISNUMBER(Portfolio!A38),Portfolio!A38,\"\")","v":"2014-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B38),Portfolio!B38,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C38),Portfolio!C38,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P38),Portfolio!P38,\"\")","v":13648},"2025-11-01","2044-11-01",2044,19,0.02,19920,9920,null," 42     11/2014   10,000   0.0%     13,648.00 11/2025  11/2044  2044   19.0  2.00%     19,920      9,920"]
[{"$f":"IF(ISNUMBER(Portfolio!A39),Portfolio!A39,\"\")","v":"2015-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B39),Portfolio!B39,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C39),Portfolio!C39,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P39),Portfolio!P39,\"\")","v":13548},"2025-11-01","2045-05-01",2045,19.5,0.02,19971,9971,null," 43      5/2015   10,000   0.0%     13,548.00 11/2025   5/2045  2045   19.5  2.00%     19,971      9,971"]
[{"$f":"IF(ISNUMBER(Portfolio!A40),Portfolio!A40,\"\")","v":"2015-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B40),Portfolio!B40,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C40),Portfolio!C40,\"\")","v":1E-3},{"$f":"IF(ISNUMBER(Portfolio!P40),Portfolio!P40,\"\")","v":13672},"2025-11-01","2045-11-01",2045,20,2.1000000000000001E-2,20763,10763,null," 44     11/2015   10,000   0.1%     13,672.00 11/2025  11/2045  2045   20.0  2.10%     20,763     10,763"]
[{"$f":"IF(ISNUMBER(Portfolio!A41),Portfolio!A41,\"\")","v":"2016-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B41),Portfolio!B41,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C41),Portfolio!C41,\"\")","v":1E-3},{"$f":"IF(ISNUMBER(Portfolio!P41),Portfolio!P41,\"\")","v":13568},"2025-11-01","2046-05-01",2046,20.5,2.1000000000000001E-2,20821,10821,null," 45      5/2016   10,000   0.1%     13,568.00 11/2025   5/2046  2046   20.5  2.10%     20,821     10,821"]
[{"$f":"IF(ISNUMBER(Portfolio!A42),Portfolio!A42,\"\")","v":"2016-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B42),Portfolio!B42,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C42),Portfolio!C42,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P42),Portfolio!P42,\"\")","v":13436},"2025-11-01","2046-11-01",2046,21,0.02,20406,10406,null," 46     11/2016   10,000   0.0%     13,436.00 11/2025  11/2046  2046   21.0  2.00%     20,406     10,406"]
[{"$f":"IF(ISNUMBER(Portfolio!A43),Portfolio!A43,\"\")","v":"2017-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B43),Portfolio!B43,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C43),Portfolio!C43,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P43),Portfolio!P43,\"\")","v":13252},"2025-11-01","2047-05-01",2047,21.5,0.02,20328,10328,null," 47      5/2017   10,000   0.0%     13,252.00 11/2025   5/2047  2047   21.5  2.00%     20,328     10,328"]
[{"$f":"IF(ISNUMBER(Portfolio!A44),Portfolio!A44,\"\")","v":"2017-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B44),Portfolio!B44,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C44),Portfolio!C44,\"\")","v":1E-3},{"$f":"IF(ISNUMBER(Portfolio!P44),Portfolio!P44,\"\")","v":13216},{"$f":"IF(ISNUMBER(A48),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A48),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A48),6)<5,6,0),DAY(B$4)),\"\")","v":"2025-11-01"},{"$f":"IF(ISNUMBER(A48),DATE(YEAR(A48)+30,MONTH(A48),DAY(A48)),\"\")","v":"2047-11-01"},{"$f":"IF(ISNUMBER(A48),YEAR(F48),\"\")","v":2047},{"$f":"IF(ISNUMBER(A48),YEAR(F48)-YEAR(E48)+(MONTH(F48)-MONTH(E48))/12,\"\")","v":22},{"$f":"IF(ISNUMBER(A48),ROUND(C48+B$5+C48*(B$5/2),4),\"\")","v":2.1000000000000001E-2},{"$f":"IF(ISNUMBER(A48),ROUND(D48*(1+I48/2)^(H48*2),0),\"\")","v":20927},{"$f":"IF(ISNUMBER(A48),J48-B48,\"\")","v":10927},null,{"$f":"RIGHT(\"   \"&ROW(A48),3)&RIGHT(A$1&TEXT(A48,A$2),A$3)&RIGHT(A$1&TEXT(B48,B$2),B$3)&RIGHT(A$1&TEXT(C48,C$2),C$3)&RIGHT(A$1&TEXT(D48,D$2),D$3)&RIGHT(A$1&TEXT(E48,E$2),E$3)&RIGHT(A$1&TEXT(F48,F$2),F$3)&RIGHT(A$1&TEXT(G48,G$2),G$3)&RIGHT(A$1&TEXT(H48,H$2),H$3)&RIGHT(A$1&TEXT(I48,I$2),I$3)&RIGHT(A$1&TEXT(J48,J$2),J$3)&RIGHT(A$1&TEXT(K48,K$2),K$3)","v":" 48     11/2017   10,000   0.1%     13,216.00 11/2025  11/2047  2047   22.0  2.10%     20,927     10,927"}]
[{"$f":"IF(ISNUMBER(Portfolio!A45),Portfolio!A45,\"\")","v":"2018-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B45),Portfolio!B45,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C45),Portfolio!C45,\"\")","v":3.0000000000000001E-3},{"$f":"IF(ISNUMBER(Portfolio!P45),Portfolio!P45,\"\")","v":13256},"2025-11-01","2048-05-01",2048,22.5,2.3E-2,22176,12176,null," 49      5/2018   10,000   0.3%     13,256.00 11/2025   5/2048  2048   22.5  2.30%     22,176     12,176"]
[{"$f":"IF(ISNUMBER(Portfolio!A46),Portfolio!A46,\"\")","v":"2018-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B46),Portfolio!B46,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C46),Portfolio!C46,\"\")","v":5.0000000000000001E-3},{"$f":"IF(ISNUMBER(Portfolio!P46),Portfolio!P46,\"\")","v":13268},"2025-11-01","2048-11-01",2048,23,2.5100000000000001E-2,23549,13549,null," 50     11/2018   10,000   0.5%     13,268.00 11/2025  11/2048  2048   23.0  2.51%     23,549     13,549"]
[{"$f":"IF(ISNUMBER(Portfolio!A47),Portfolio!A47,\"\")","v":"2019-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B47),Portfolio!B47,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C47),Portfolio!C47,\"\")","v":5.0000000000000001E-3},{"$f":"IF(ISNUMBER(Portfolio!P47),Portfolio!P47,\"\")","v":13084},"2025-11-01","2049-05-01",2049,23.5,2.5100000000000001E-2,23513,13513,null," 51      5/2019   10,000   0.5%     13,084.00 11/2025   5/2049  2049   23.5  2.51%     23,513     13,513"]
[{"$f":"IF(ISNUMBER(Portfolio!A48),Portfolio!A48,\"\")","v":"2019-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B48),Portfolio!B48,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C48),Portfolio!C48,\"\")","v":2E-3},{"$f":"IF(ISNUMBER(Portfolio!P48),Portfolio!P48,\"\")","v":12736},"2025-11-01","2049-11-01",2049,24,2.1999999999999999E-2,21532,11532,null," 52     11/2019   10,000   0.2%     12,736.00 11/2025  11/2049  2049   24.0  2.20%     21,532     11,532"]
[{"$f":"IF(ISNUMBER(Portfolio!A49),Portfolio!A49,\"\")","v":"2020-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B49),Portfolio!B49,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C49),Portfolio!C49,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P49),Portfolio!P49,\"\")","v":12456},"2025-11-01","2050-05-01",2050,24.5,0.02,20283,10283,null," 53      5/2020   10,000   0.0%     12,456.00 11/2025   5/2050  2050   24.5  2.00%     20,283     10,283"]
[{"$f":"IF(ISNUMBER(Portfolio!A50),Portfolio!A50,\"\")","v":"2020-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B50),Portfolio!B50,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C50),Portfolio!C50,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P50),Portfolio!P50,\"\")","v":12396},"2025-11-01","2050-11-01",2050,25,0.02,20387,10387,null," 54     11/2020   10,000   0.0%     12,396.00 11/2025  11/2050  2050   25.0  2.00%     20,387     10,387"]
[{"$f":"IF(ISNUMBER(Portfolio!A51),Portfolio!A51,\"\")","v":"2021-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B51),Portfolio!B51,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C51),Portfolio!C51,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P51),Portfolio!P51,\"\")","v":12288},"2025-11-01","2051-05-01",2051,25.5,0.02,20411,10411,null," 55      5/2021   10,000   0.0%     12,288.00 11/2025   5/2051  2051   25.5  2.00%     20,411     10,411"]
[{"$f":"IF(ISNUMBER(Portfolio!A52),Portfolio!A52,\"\")","v":"2021-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B52),Portfolio!B52,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C52),Portfolio!C52,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P52),Portfolio!P52,\"\")","v":12076},"2025-11-01","2051-11-01",2051,26,0.02,20260,10260,null," 56     11/2021   10,000   0.0%     12,076.00 11/2025  11/2051  2051   26.0  2.00%     20,260     10,260"]
[{"$f":"IF(ISNUMBER(Portfolio!A53),Portfolio!A53,\"\")","v":"2022-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B53),Portfolio!B53,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C53),Portfolio!C53,\"\")","v":0},{"$f":"IF(ISNUMBER(Portfolio!P53),Portfolio!P53,\"\")","v":11660},{"$f":"IF(ISNUMBER(A57),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A57),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A57),6)<5,6,0),DAY(B$4)),\"\")","v":"2025-11-01"},{"$f":"IF(ISNUMBER(A57),DATE(YEAR(A57)+30,MONTH(A57),DAY(A57)),\"\")","v":"2052-05-01"},{"$f":"IF(ISNUMBER(A57),YEAR(F57),\"\")","v":2052},{"$f":"IF(ISNUMBER(A57),YEAR(F57)-YEAR(E57)+(MONTH(F57)-MONTH(E57))/12,\"\")","v":26.5},{"$f":"IF(ISNUMBER(A57),ROUND(C57+B$5+C57*(B$5/2),4),\"\")","v":0.02},{"$f":"IF(ISNUMBER(A57),ROUND(D57*(1+I57/2)^(H57*2),0),\"\")","v":19757},{"$f":"IF(ISNUMBER(A57),J57-B57,\"\")","v":9757},null,{"$f":"RIGHT(\"   \"&ROW(A57),3)&RIGHT(A$1&TEXT(A57,A$2),A$3)&RIGHT(A$1&TEXT(B57,B$2),B$3)&RIGHT(A$1&TEXT(C57,C$2),C$3)&RIGHT(A$1&TEXT(D57,D$2),D$3)&RIGHT(A$1&TEXT(E57,E$2),E$3)&RIGHT(A$1&TEXT(F57,F$2),F$3)&RIGHT(A$1&TEXT(G57,G$2),G$3)&RIGHT(A$1&TEXT(H57,H$2),H$3)&RIGHT(A$1&TEXT(I57,I$2),I$3)&RIGHT(A$1&TEXT(J57,J$2),J$3)&RIGHT(A$1&TEXT(K57,K$2),K$3)","v":" 57      5/2022   10,000   0.0%     11,660.00 11/2025   5/2052  2052   26.5  2.00%     19,757      9,757"}]
[{"$f":"IF(ISNUMBER(Portfolio!A54),Portfolio!A54,\"\")","v":"2022-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B54),Portfolio!B54,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C54),Portfolio!C54,\"\")","v":4.0000000000000001E-3},{"$f":"IF(ISNUMBER(Portfolio!P54),Portfolio!P54,\"\")","v":11252},{"$f":"IF(ISNUMBER(A58),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A58),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A58),6)<5,6,0),DAY(B$4)),\"\")","v":"2025-11-01"},{"$f":"IF(ISNUMBER(A58),DATE(YEAR(A58)+30,MONTH(A58),DAY(A58)),\"\")","v":"2052-11-01"},{"$f":"IF(ISNUMBER(A58),YEAR(F58),\"\")","v":2052},{"$f":"IF(ISNUMBER(A58),YEAR(F58)-YEAR(E58)+(MONTH(F58)-MONTH(E58))/12,\"\")","v":27},{"$f":"IF(ISNUMBER(A58),ROUND(C58+B$5+C58*(B$5/2),4),\"\")","v":2.4E-2},{"$f":"IF(ISNUMBER(A58),ROUND(D58*(1+I58/2)^(H58*2),0),\"\")","v":21428},{"$f":"IF(ISNUMBER(A58),J58-B58,\"\")","v":11428},null,{"$f":"RIGHT(\"   \"&ROW(A58),3)&RIGHT(A$1&TEXT(A58,A$2),A$3)&RIGHT(A$1&TEXT(B58,B$2),B$3)&RIGHT(A$1&TEXT(C58,C$2),C$3)&RIGHT(A$1&TEXT(D58,D$2),D$3)&RIGHT(A$1&TEXT(E58,E$2),E$3)&RIGHT(A$1&TEXT(F58,F$2),F$3)&RIGHT(A$1&TEXT(G58,G$2),G$3)&RIGHT(A$1&TEXT(H58,H$2),H$3)&RIGHT(A$1&TEXT(I58,I$2),I$3)&RIGHT(A$1&TEXT(J58,J$2),J$3)&RIGHT(A$1&TEXT(K58,K$2),K$3)","v":" 58     11/2022   10,000   0.4%     11,252.00 11/2025  11/2052  2052   27.0  2.40%     21,428     11,428"}]
[{"$f":"IF(ISNUMBER(Portfolio!A55),Portfolio!A55,\"\")","v":"2023-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B55),Portfolio!B55,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C55),Portfolio!C55,\"\")","v":8.9999999999999993E-3},{"$f":"IF(ISNUMBER(Portfolio!P55),Portfolio!P55,\"\")","v":11020},{"$f":"IF(ISNUMBER(A59),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A59),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A59),6)<5,6,0),DAY(B$4)),\"\")","v":"2025-11-01"},{"$f":"IF(ISNUMBER(A59),DATE(YEAR(A59)+30,MONTH(A59),DAY(A59)),\"\")","v":"2053-05-01"},{"$f":"IF(ISNUMBER(A59),YEAR(F59),\"\")","v":2053},{"$f":"IF(ISNUMBER(A59),YEAR(F59)-YEAR(E59)+(MONTH(F59)-MONTH(E59))/12,\"\")","v":27.5},{"$f":"IF(ISNUMBER(A59),ROUND(C59+B$5+C59*(B$5/2),4),\"\")","v":2.9100000000000001E-2},{"$f":"IF(ISNUMBER(A59),ROUND(D59*(1+I59/2)^(H59*2),0),\"\")","v":24391},{"$f":"IF(ISNUMBER(A59),J59-B59,\"\")","v":14391},null,{"$f":"RIGHT(\"   \"&ROW(A59),3)&RIGHT(A$1&TEXT(A59,A$2),A$3)&RIGHT(A$1&TEXT(B59,B$2),B$3)&RIGHT(A$1&TEXT(C59,C$2),C$3)&RIGHT(A$1&TEXT(D59,D$2),D$3)&RIGHT(A$1&TEXT(E59,E$2),E$3)&RIGHT(A$1&TEXT(F59,F$2),F$3)&RIGHT(A$1&TEXT(G59,G$2),G$3)&RIGHT(A$1&TEXT(H59,H$2),H$3)&RIGHT(A$1&TEXT(I59,I$2),I$3)&RIGHT(A$1&TEXT(J59,J$2),J$3)&RIGHT(A$1&TEXT(K59,K$2),K$3)","v":" 59      5/2023   10,000   0.9%     11,020.00 11/2025   5/2053  2053   27.5  2.91%     24,391     14,391"}]
[{"$f":"IF(ISNUMBER(Portfolio!A56),Portfolio!A56,\"\")","v":"2023-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B56),Portfolio!B56,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C56),Portfolio!C56,\"\")","v":1.2999999999999999E-2},{"$f":"IF(ISNUMBER(Portfolio!P56),Portfolio!P56,\"\")","v":10876},{"$f":"IF(ISNUMBER(A60),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A60),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A60),6)<5,6,0),DAY(B$4)),\"\")","v":"2025-11-01"},{"$f":"IF(ISNUMBER(A60),DATE(YEAR(A60)+30,MONTH(A60),DAY(A60)),\"\")","v":"2053-11-01"},{"$f":"IF(ISNUMBER(A60),YEAR(F60),\"\")","v":2053},{"$f":"IF(ISNUMBER(A60),YEAR(F60)-YEAR(E60)+(MONTH(F60)-MONTH(E60))/12,\"\")","v":28},{"$f":"IF(ISNUMBER(A60),ROUND(C60+B$5+C60*(B$5/2),4),\"\")","v":3.3099999999999997E-2},{"$f":"IF(ISNUMBER(A60),ROUND(D60*(1+I60/2)^(H60*2),0),\"\")","v":27270},{"$f":"IF(ISNUMBER(A60),J60-B60,\"\")","v":17270},null,{"$f":"RIGHT(\"   \"&ROW(A60),3)&RIGHT(A$1&TEXT(A60,A$2),A$3)&RIGHT(A$1&TEXT(B60,B$2),B$3)&RIGHT(A$1&TEXT(C60,C$2),C$3)&RIGHT(A$1&TEXT(D60,D$2),D$3)&RIGHT(A$1&TEXT(E60,E$2),E$3)&RIGHT(A$1&TEXT(F60,F$2),F$3)&RIGHT(A$1&TEXT(G60,G$2),G$3)&RIGHT(A$1&TEXT(H60,H$2),H$3)&RIGHT(A$1&TEXT(I60,I$2),I$3)&RIGHT(A$1&TEXT(J60,J$2),J$3)&RIGHT(A$1&TEXT(K60,K$2),K$3)","v":" 60     11/2023   10,000   1.3%     10,876.00 11/2025  11/2053  2053   28.0  3.31%     27,270     17,270"}]
[{"$f":"IF(ISNUMBER(Portfolio!A57),Portfolio!A57,\"\")","v":"2024-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B57),Portfolio!B57,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C57),Portfolio!C57,\"\")","v":1.2999999999999999E-2},{"$f":"IF(ISNUMBER(Portfolio!P57),Portfolio!P57,\"\")","v":10596},{"$f":"IF(ISNUMBER(A61),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A61),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A61),6)<5,6,0),DAY(B$4)),\"\")","v":"2025-11-01"},{"$f":"IF(ISNUMBER(A61),DATE(YEAR(A61)+30,MONTH(A61),DAY(A61)),\"\")","v":"2054-05-01"},{"$f":"IF(ISNUMBER(A61),YEAR(F61),\"\")","v":2054},{"$f":"IF(ISNUMBER(A61),YEAR(F61)-YEAR(E61)+(MONTH(F61)-MONTH(E61))/12,\"\")","v":28.5},{"$f":"IF(ISNUMBER(A61),ROUND(C61+B$5+C61*(B$5/2),4),\"\")","v":3.3099999999999997E-2},{"$f":"IF(ISNUMBER(A61),ROUND(D61*(1+I61/2)^(H61*2),0),\"\")","v":27007},{"$f":"IF(ISNUMBER(A61),J61-B61,\"\")","v":17007},null,{"$f":"RIGHT(\"   \"&ROW(A61),3)&RIGHT(A$1&TEXT(A61,A$2),A$3)&RIGHT(A$1&TEXT(B61,B$2),B$3)&RIGHT(A$1&TEXT(C61,C$2),C$3)&RIGHT(A$1&TEXT(D61,D$2),D$3)&RIGHT(A$1&TEXT(E61,E$2),E$3)&RIGHT(A$1&TEXT(F61,F$2),F$3)&RIGHT(A$1&TEXT(G61,G$2),G$3)&RIGHT(A$1&TEXT(H61,H$2),H$3)&RIGHT(A$1&TEXT(I61,I$2),I$3)&RIGHT(A$1&TEXT(J61,J$2),J$3)&RIGHT(A$1&TEXT(K61,K$2),K$3)","v":" 61      5/2024   10,000   1.3%     10,596.00 11/2025   5/2054  2054   28.5  3.31%     27,007     17,007"}]
[{"$f":"IF(ISNUMBER(Portfolio!A58),Portfolio!A58,\"\")","v":"2024-11-01"},{"$f":"IF(ISNUMBER(Portfolio!B58),Portfolio!B58,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C58),Portfolio!C58,\"\")","v":1.2E-2},{"$f":"IF(ISNUMBER(Portfolio!P58),Portfolio!P58,\"\")","v":10364},{"$f":"IF(ISNUMBER(A62),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A62),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A62),6)<5,6,0),DAY(B$4)),\"\")","v":"2025-11-01"},{"$f":"IF(ISNUMBER(A62),DATE(YEAR(A62)+30,MONTH(A62),DAY(A62)),\"\")","v":"2054-11-01"},{"$f":"IF(ISNUMBER(A62),YEAR(F62),\"\")","v":2054},{"$f":"IF(ISNUMBER(A62),YEAR(F62)-YEAR(E62)+(MONTH(F62)-MONTH(E62))/12,\"\")","v":29},{"$f":"IF(ISNUMBER(A62),ROUND(C62+B$5+C62*(B$5/2),4),\"\")","v":3.2099999999999997E-2},{"$f":"IF(ISNUMBER(A62),ROUND(D62*(1+I62/2)^(H62*2),0),\"\")","v":26098},{"$f":"IF(ISNUMBER(A62),J62-B62,\"\")","v":16098},null,{"$f":"RIGHT(\"   \"&ROW(A62),3)&RIGHT(A$1&TEXT(A62,A$2),A$3)&RIGHT(A$1&TEXT(B62,B$2),B$3)&RIGHT(A$1&TEXT(C62,C$2),C$3)&RIGHT(A$1&TEXT(D62,D$2),D$3)&RIGHT(A$1&TEXT(E62,E$2),E$3)&RIGHT(A$1&TEXT(F62,F$2),F$3)&RIGHT(A$1&TEXT(G62,G$2),G$3)&RIGHT(A$1&TEXT(H62,H$2),H$3)&RIGHT(A$1&TEXT(I62,I$2),I$3)&RIGHT(A$1&TEXT(J62,J$2),J$3)&RIGHT(A$1&TEXT(K62,K$2),K$3)","v":" 62     11/2024   10,000   1.2%     10,364.00 11/2025  11/2054  2054   29.0  3.21%     26,098     16,098"}]
[{"$f":"IF(ISNUMBER(Portfolio!A59),Portfolio!A59,\"\")","v":"2025-05-01"},{"$f":"IF(ISNUMBER(Portfolio!B59),Portfolio!B59,\"\")","v":10000},{"$f":"IF(ISNUMBER(Portfolio!C59),Portfolio!C59,\"\")","v":1.0999999999999999E-2},{"$f":"IF(ISNUMBER(Portfolio!P59),Portfolio!P59,\"\")","v":10200},{"$f":"IF(ISNUMBER(A63),DATE(YEAR(B$4),MONTH(B$4)+6+MOD(MONTH(A63),6)-MOD(MONTH(B$4),6)+IF(MOD(MONTH(A63),6)<5,6,0),DAY(B$4)),\"\")","v":"2025-11-01"},{"$f":"IF(ISNUMBER(A63),DATE(YEAR(A63)+30,MONTH(A63),DAY(A63)),\"\")","v":"2055-05-01"},{"$f":"IF(ISNUMBER(A63),YEAR(F63),\"\")","v":2055},{"$f":"IF(ISNUMBER(A63),YEAR(F63)-YEAR(E63)+(MONTH(F63)-MONTH(E63))/12,\"\")","v":29.5},{"$f":"IF(ISNUMBER(A63),ROUND(C63+B$5+C63*(B$5/2),4),\"\")","v":3.1099999999999999E-2},{"$f":"IF(ISNUMBER(A63),ROUND(D63*(1+I63/2)^(H63*2),0),\"\")","v":25350},{"$f":"IF(ISNUMBER(A63),J63-B63,\"\")","v":15350},null,{"$f":"RIGHT(\"   \"&ROW(A63),3)&RIGHT(A$1&TEXT(A63,A$2),A$3)&RIGHT(A$1&TEXT(B63,B$2),B$3)&RIGHT(A$1&TEXT(C63,C$2),C$3)&RIGHT(A$1&TEXT(D63,D$2),D$3)&RIGHT(A$1&TEXT(E63,E$2),E$3)&RIGHT(A$1&TEXT(F63,F$2),F$3)&RIGHT(A$1&TEXT(G63,G$2),G$3)&RIGHT(A$1&TEXT(H63,H$2),H$3)&RIGHT(A$1&TEXT(I63,I$2),I$3)&RIGHT(A$1&TEXT(J63,J$2),J$3)&RIGHT(A$1&TEXT(K63,K$2),K$3)","v":" 63      5/2025   10,000   1.1%     10,200.00 11/2025   5/2055  2055   29.5  3.11%     25,350     15,350"}]

{"sheet":"MatYrs","index":3,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["                    ",9,14,11,11]
[null,"Face","Now","Grows",null,null,{"$f":"RIGHT(\"   \"&ROW(A2),3)&RIGHT(A$1&A2,7)&RIGHT(A$1&B2,B$1)&RIGHT(A$1&C2,C$1)&RIGHT(A$1&D2,D$1)&RIGHT(A$1&E2,E$1)","v":"  2            Face           Now      Grows           "}]
["Year","Value","Worth","To","Gain",null,{"$f":"RIGHT(\"   \"&ROW(A3),3)&RIGHT(A$1&A3,7)&RIGHT(A$1&B3,B$1)&RIGHT(A$1&C3,C$1)&RIGHT(A$1&D3,D$1)&RIGHT(A$1&E3,E$1)","v":"  3   Year    Value         Worth         To       Gain"}]
["Sum",{"$f":"SUM(B5:B100)","v":550000},{"$f":"SUM(C5:C100)","v":1089964},{"$f":"SUM(D5:D100)","v":1556987},{"$f":"SUM(E5:E100)","v":1006987},null,{"$f":"RIGHT(\"   \"&ROW(A4),3)&RIGHT(A$1&A4,7)&IF(B4=0,\"\",RIGHT(A$1&TEXT(B4,\"#,###,##0\"),B$1)&RIGHT(A$1&TEXT(C4,\"#,###,##0.00\"),C$1)&RIGHT(A$1&TEXT(D4,\"#,###,##0\"),D$1)&RIGHT(A$1&TEXT(E4,\"#,###,##0\"),E$1))","v":"  4    Sum  550,000  1,089,964.00  1,556,987  1,006,987"}]
[{"$f":"YEAR(MIN(Portfolio!A5:A1000))+30","v":2028},{"$f":"IF(ISNUMBER($A5),SUMIF(Mature!$G$5:G$1000,$A5,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A5),SUMIF(Mature!$G$5:I$1000,$A5,Mature!D$5:D$1000),\"\")","v":98256},{"$f":"IF(ISNUMBER($A5),SUMIF(Mature!$G$5:J$1000,$A5,Mature!J$5:J$1000),\"\")","v":113674},{"$f":"IF(ISNUMBER($A5),SUMIF(Mature!$G$5:K$1000,$A5,Mature!K$5:K$1000),\"\")","v":93674},null,{"$f":"RIGHT(\"   \"&ROW(A5),3)&RIGHT(A$1&A5,7)&IF(B5=0,\"\",RIGHT(A$1&TEXT(B5,\"#,###,##0\"),B$1)&RIGHT(A$1&TEXT(C5,\"#,###,##0.00\"),C$1)&RIGHT(A$1&TEXT(D5,\"#,###,##0\"),D$1)&RIGHT(A$1&TEXT(E5,\"#,###,##0\"),E$1))","v":"  5   2028   20,000     98,256.00    113,674     93,674"}]
[{"$f":"IF(A5=\"\",\"\",IF(A5+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A5+1,\"\"))","v":2029},{"$f":"IF(ISNUMBER($A6),SUMIF(Mature!$G$5:G$1000,$A6,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A6),SUMIF(Mature!$G$5:I$1000,$A6,Mature!D$5:D$1000),\"\")","v":94236},{"$f":"IF(ISNUMBER($A6),SUMIF(Mature!$G$5:J$1000,$A6,Mature!J$5:J$1000),\"\")","v":115021},{"$f":"IF(ISNUMBER($A6),SUMIF(Mature!$G$5:K$1000,$A6,Mature!K$5:K$1000),\"\")","v":95021},null,"  6   2029   20,000     94,236.00    115,021     95,021"]
[{"$f":"IF(A6=\"\",\"\",IF(A6+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A6+1,\"\"))","v":2030},{"$f":"IF(ISNUMBER($A7),SUMIF(Mature!$G$5:G$1000,$A7,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A7),SUMIF(Mature!$G$5:I$1000,$A7,Mature!D$5:D$1000),\"\")","v":91752},{"$f":"IF(ISNUMBER($A7),SUMIF(Mature!$G$5:J$1000,$A7,Mature!J$5:J$1000),\"\")","v":118847},{"$f":"IF(ISNUMBER($A7),SUMIF(Mature!$G$5:K$1000,$A7,Mature!K$5:K$1000),\"\")","v":98847},null,"  7   2030   20,000     91,752.00    118,847     98,847"]
[{"$f":"IF(A7=\"\",\"\",IF(A7+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A7+1,\"\"))","v":2031},{"$f":"IF(ISNUMBER($A8),SUMIF(Mature!$G$5:G$1000,$A8,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A8),SUMIF(Mature!$G$5:I$1000,$A8,Mature!D$5:D$1000),\"\")","v":68508},{"$f":"IF(ISNUMBER($A8),SUMIF(Mature!$G$5:J$1000,$A8,Mature!J$5:J$1000),\"\")","v":88708},{"$f":"IF(ISNUMBER($A8),SUMIF(Mature!$G$5:K$1000,$A8,Mature!K$5:K$1000),\"\")","v":68708},null,"  8   2031   20,000     68,508.00     88,708     68,708"]
[{"$f":"IF(A8=\"\",\"\",IF(A8+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A8+1,\"\"))","v":2032},{"$f":"IF(ISNUMBER($A9),SUMIF(Mature!$G$5:G$1000,$A9,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A9),SUMIF(Mature!$G$5:I$1000,$A9,Mature!D$5:D$1000),\"\")","v":55512},{"$f":"IF(ISNUMBER($A9),SUMIF(Mature!$G$5:J$1000,$A9,Mature!J$5:J$1000),\"\")","v":71645},{"$f":"IF(ISNUMBER($A9),SUMIF(Mature!$G$5:K$1000,$A9,Mature!K$5:K$1000),\"\")","v":51645},null,"  9   2032   20,000     55,512.00     71,645     51,645"]
[{"$f":"IF(A9=\"\",\"\",IF(A9+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A9+1,\"\"))","v":2033},{"$f":"IF(ISNUMBER($A10),SUMIF(Mature!$G$5:G$1000,$A10,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A10),SUMIF(Mature!$G$5:I$1000,$A10,Mature!D$5:D$1000),\"\")","v":45884},{"$f":"IF(ISNUMBER($A10),SUMIF(Mature!$G$5:J$1000,$A10,Mature!J$5:J$1000),\"\")","v":58278},{"$f":"IF(ISNUMBER($A10),SUMIF(Mature!$G$5:K$1000,$A10,Mature!K$5:K$1000),\"\")","v":38278},null," 10   2033   20,000     45,884.00     58,278     38,278"]
[{"$f":"IF(A10=\"\",\"\",IF(A10+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A10+1,\"\"))","v":2034},{"$f":"IF(ISNUMBER($A11),SUMIF(Mature!$G$5:G$1000,$A11,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A11),SUMIF(Mature!$G$5:I$1000,$A11,Mature!D$5:D$1000),\"\")","v":43608},{"$f":"IF(ISNUMBER($A11),SUMIF(Mature!$G$5:J$1000,$A11,Mature!J$5:J$1000),\"\")","v":56634},{"$f":"IF(ISNUMBER($A11),SUMIF(Mature!$G$5:K$1000,$A11,Mature!K$5:K$1000),\"\")","v":36634},null," 11   2034   20,000     43,608.00     56,634     36,634"]
[{"$f":"IF(A11=\"\",\"\",IF(A11+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A11+1,\"\"))","v":2035},{"$f":"IF(ISNUMBER($A12),SUMIF(Mature!$G$5:G$1000,$A12,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A12),SUMIF(Mature!$G$5:I$1000,$A12,Mature!D$5:D$1000),\"\")","v":42808},{"$f":"IF(ISNUMBER($A12),SUMIF(Mature!$G$5:J$1000,$A12,Mature!J$5:J$1000),\"\")","v":57826},{"$f":"IF(ISNUMBER($A12),SUMIF(Mature!$G$5:K$1000,$A12,Mature!K$5:K$1000),\"\")","v":37826},null," 12   2035   20,000     42,808.00     57,826     37,826"]
[{"$f":"IF(A12=\"\",\"\",IF(A12+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A12+1,\"\"))","v":2036},{"$f":"IF(ISNUMBER($A13),SUMIF(Mature!$G$5:G$1000,$A13,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A13),SUMIF(Mature!$G$5:I$1000,$A13,Mature!D$5:D$1000),\"\")","v":42944},{"$f":"IF(ISNUMBER($A13),SUMIF(Mature!$G$5:J$1000,$A13,Mature!J$5:J$1000),\"\")","v":61767},{"$f":"IF(ISNUMBER($A13),SUMIF(Mature!$G$5:K$1000,$A13,Mature!K$5:K$1000),\"\")","v":41767},null," 13   2036   20,000     42,944.00     61,767     41,767"]
[{"$f":"IF(A13=\"\",\"\",IF(A13+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A13+1,\"\"))","v":2037},{"$f":"IF(ISNUMBER($A14),SUMIF(Mature!$G$5:G$1000,$A14,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A14),SUMIF(Mature!$G$5:I$1000,$A14,Mature!D$5:D$1000),\"\")","v":40300},{"$f":"IF(ISNUMBER($A14),SUMIF(Mature!$G$5:J$1000,$A14,Mature!J$5:J$1000),\"\")","v":58918},{"$f":"IF(ISNUMBER($A14),SUMIF(Mature!$G$5:K$1000,$A14,Mature!K$5:K$1000),\"\")","v":38918},null," 14   2037   20,000     40,300.00     58,918     38,918"]
[{"$f":"IF(A14=\"\",\"\",IF(A14+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A14+1,\"\"))","v":2038},{"$f":"IF(ISNUMBER($A15),SUMIF(Mature!$G$5:G$1000,$A15,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A15),SUMIF(Mature!$G$5:I$1000,$A15,Mature!D$5:D$1000),\"\")","v":33288},{"$f":"IF(ISNUMBER($A15),SUMIF(Mature!$G$5:J$1000,$A15,Mature!J$5:J$1000),\"\")","v":45061},{"$f":"IF(ISNUMBER($A15),SUMIF(Mature!$G$5:K$1000,$A15,Mature!K$5:K$1000),\"\")","v":25061},null," 15   2038   20,000     33,288.00     45,061     25,061"]
[{"$f":"IF(A15=\"\",\"\",IF(A15+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A15+1,\"\"))","v":2039},{"$f":"IF(ISNUMBER($A16),SUMIF(Mature!$G$5:G$1000,$A16,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A16),SUMIF(Mature!$G$5:I$1000,$A16,Mature!D$5:D$1000),\"\")","v":31276},{"$f":"IF(ISNUMBER($A16),SUMIF(Mature!$G$5:J$1000,$A16,Mature!J$5:J$1000),\"\")","v":42283},{"$f":"IF(ISNUMBER($A16),SUMIF(Mature!$G$5:K$1000,$A16,Mature!K$5:K$1000),\"\")","v":22283},null," 16   2039   20,000     31,276.00     42,283     22,283"]
[{"$f":"IF(A16=\"\",\"\",IF(A16+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A16+1,\"\"))","v":2040},{"$f":"IF(ISNUMBER($A17),SUMIF(Mature!$G$5:G$1000,$A17,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A17),SUMIF(Mature!$G$5:I$1000,$A17,Mature!D$5:D$1000),\"\")","v":30204},{"$f":"IF(ISNUMBER($A17),SUMIF(Mature!$G$5:J$1000,$A17,Mature!J$5:J$1000),\"\")","v":41103},{"$f":"IF(ISNUMBER($A17),SUMIF(Mature!$G$5:K$1000,$A17,Mature!K$5:K$1000),\"\")","v":21103},null," 17   2040   20,000     30,204.00     41,103     21,103"]
[{"$f":"IF(A17=\"\",\"\",IF(A17+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A17+1,\"\"))","v":2041},{"$f":"IF(ISNUMBER($A18),SUMIF(Mature!$G$5:G$1000,$A18,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A18),SUMIF(Mature!$G$5:I$1000,$A18,Mature!D$5:D$1000),\"\")","v":29200},{"$f":"IF(ISNUMBER($A18),SUMIF(Mature!$G$5:J$1000,$A18,Mature!J$5:J$1000),\"\")","v":39948},{"$f":"IF(ISNUMBER($A18),SUMIF(Mature!$G$5:K$1000,$A18,Mature!K$5:K$1000),\"\")","v":19948},null," 18   2041   20,000     29,200.00     39,948     19,948"]
[{"$f":"IF(A18=\"\",\"\",IF(A18+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A18+1,\"\"))","v":2042},{"$f":"IF(ISNUMBER($A19),SUMIF(Mature!$G$5:G$1000,$A19,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A19),SUMIF(Mature!$G$5:I$1000,$A19,Mature!D$5:D$1000),\"\")","v":28276},{"$f":"IF(ISNUMBER($A19),SUMIF(Mature!$G$5:J$1000,$A19,Mature!J$5:J$1000),\"\")","v":39462},{"$f":"IF(ISNUMBER($A19),SUMIF(Mature!$G$5:K$1000,$A19,Mature!K$5:K$1000),\"\")","v":19462},null," 19   2042   20,000     28,276.00     39,462     19,462"]
[{"$f":"IF(A19=\"\",\"\",IF(A19+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A19+1,\"\"))","v":2043},{"$f":"IF(ISNUMBER($A20),SUMIF(Mature!$G$5:G$1000,$A20,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A20),SUMIF(Mature!$G$5:I$1000,$A20,Mature!D$5:D$1000),\"\")","v":28120},{"$f":"IF(ISNUMBER($A20),SUMIF(Mature!$G$5:J$1000,$A20,Mature!J$5:J$1000),\"\")","v":40771},{"$f":"IF(ISNUMBER($A20),SUMIF(Mature!$G$5:K$1000,$A20,Mature!K$5:K$1000),\"\")","v":20771},null," 20   2043   20,000     28,120.00     40,771     20,771"]
[{"$f":"IF(A20=\"\",\"\",IF(A20+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A20+1,\"\"))","v":2044},{"$f":"IF(ISNUMBER($A21),SUMIF(Mature!$G$5:G$1000,$A21,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A21),SUMIF(Mature!$G$5:I$1000,$A21,Mature!D$5:D$1000),\"\")","v":27572},{"$f":"IF(ISNUMBER($A21),SUMIF(Mature!$G$5:J$1000,$A21,Mature!J$5:J$1000),\"\")","v":40413},{"$f":"IF(ISNUMBER($A21),SUMIF(Mature!$G$5:K$1000,$A21,Mature!K$5:K$1000),\"\")","v":20413},null," 21   2044   20,000     27,572.00     40,413     20,413"]
[{"$f":"IF(A21=\"\",\"\",IF(A21+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A21+1,\"\"))","v":2045},{"$f":"IF(ISNUMBER($A22),SUMIF(Mature!$G$5:G$1000,$A22,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A22),SUMIF(Mature!$G$5:I$1000,$A22,Mature!D$5:D$1000),\"\")","v":27220},{"$f":"IF(ISNUMBER($A22),SUMIF(Mature!$G$5:J$1000,$A22,Mature!J$5:J$1000),\"\")","v":40734},{"$f":"IF(ISNUMBER($A22),SUMIF(Mature!$G$5:K$1000,$A22,Mature!K$5:K$1000),\"\")","v":20734},null," 22   2045   20,000     27,220.00     40,734     20,734"]
[{"$f":"IF(A22=\"\",\"\",IF(A22+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A22+1,\"\"))","v":2046},{"$f":"IF(ISNUMBER($A23),SUMIF(Mature!$G$5:G$1000,$A23,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A23),SUMIF(Mature!$G$5:I$1000,$A23,Mature!D$5:D$1000),\"\")","v":27004},{"$f":"IF(ISNUMBER($A23),SUMIF(Mature!$G$5:J$1000,$A23,Mature!J$5:J$1000),\"\")","v":41227},{"$f":"IF(ISNUMBER($A23),SUMIF(Mature!$G$5:K$1000,$A23,Mature!K$5:K$1000),\"\")","v":21227},null," 23   2046   20,000     27,004.00     41,227     21,227"]
[{"$f":"IF(A23=\"\",\"\",IF(A23+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A23+1,\"\"))","v":2047},{"$f":"IF(ISNUMBER($A24),SUMIF(Mature!$G$5:G$1000,$A24,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A24),SUMIF(Mature!$G$5:I$1000,$A24,Mature!D$5:D$1000),\"\")","v":26468},{"$f":"IF(ISNUMBER($A24),SUMIF(Mature!$G$5:J$1000,$A24,Mature!J$5:J$1000),\"\")","v":41255},{"$f":"IF(ISNUMBER($A24),SUMIF(Mature!$G$5:K$1000,$A24,Mature!K$5:K$1000),\"\")","v":21255},null," 24   2047   20,000     26,468.00     41,255     21,255"]
[{"$f":"IF(A24=\"\",\"\",IF(A24+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A24+1,\"\"))","v":2048},{"$f":"IF(ISNUMBER($A25),SUMIF(Mature!$G$5:G$1000,$A25,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A25),SUMIF(Mature!$G$5:I$1000,$A25,Mature!D$5:D$1000),\"\")","v":26524},{"$f":"IF(ISNUMBER($A25),SUMIF(Mature!$G$5:J$1000,$A25,Mature!J$5:J$1000),\"\")","v":45725},{"$f":"IF(ISNUMBER($A25),SUMIF(Mature!$G$5:K$1000,$A25,Mature!K$5:K$1000),\"\")","v":25725},null," 25   2048   20,000     26,524.00     45,725     25,725"]
[{"$f":"IF(A25=\"\",\"\",IF(A25+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A25+1,\"\"))","v":2049},{"$f":"IF(ISNUMBER($A26),SUMIF(Mature!$G$5:G$1000,$A26,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A26),SUMIF(Mature!$G$5:I$1000,$A26,Mature!D$5:D$1000),\"\")","v":25820},{"$f":"IF(ISNUMBER($A26),SUMIF(Mature!$G$5:J$1000,$A26,Mature!J$5:J$1000),\"\")","v":45045},{"$f":"IF(ISNUMBER($A26),SUMIF(Mature!$G$5:K$1000,$A26,Mature!K$5:K$1000),\"\")","v":25045},null," 26   2049   20,000     25,820.00     45,045     25,045"]
[{"$f":"IF(A26=\"\",\"\",IF(A26+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A26+1,\"\"))","v":2050},{"$f":"IF(ISNUMBER($A27),SUMIF(Mature!$G$5:G$1000,$A27,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A27),SUMIF(Mature!$G$5:I$1000,$A27,Mature!D$5:D$1000),\"\")","v":24852},{"$f":"IF(ISNUMBER($A27),SUMIF(Mature!$G$5:J$1000,$A27,Mature!J$5:J$1000),\"\")","v":40670},{"$f":"IF(ISNUMBER($A27),SUMIF(Mature!$G$5:K$1000,$A27,Mature!K$5:K$1000),\"\")","v":20670},null," 27   2050   20,000     24,852.00     40,670     20,670"]
[{"$f":"IF(A27=\"\",\"\",IF(A27+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A27+1,\"\"))","v":2051},{"$f":"IF(ISNUMBER($A28),SUMIF(Mature!$G$5:G$1000,$A28,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A28),SUMIF(Mature!$G$5:I$1000,$A28,Mature!D$5:D$1000),\"\")","v":24364},{"$f":"IF(ISNUMBER($A28),SUMIF(Mature!$G$5:J$1000,$A28,Mature!J$5:J$1000),\"\")","v":40671},{"$f":"IF(ISNUMBER($A28),SUMIF(Mature!$G$5:K$1000,$A28,Mature!K$5:K$1000),\"\")","v":20671},null,{"$f":"RIGHT(\"   \"&ROW(A28),3)&RIGHT(A$1&A28,7)&IF(B28=0,\"\",RIGHT(A$1&TEXT(B28,\"#,###,##0\"),B$1)&RIGHT(A$1&TEXT(C28,\"#,###,##0.00\"),C$1)&RIGHT(A$1&TEXT(D28,\"#,###,##0\"),D$1)&RIGHT(A$1&TEXT(E28,\"#,###,##0\"),E$1))","v":" 28   2051   20,000     24,364.00     40,671     20,671"}]
[{"$f":"IF(A28=\"\",\"\",IF(A28+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A28+1,\"\"))","v":2052},{"$f":"IF(ISNUMBER($A29),SUMIF(Mature!$G$5:G$1000,$A29,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A29),SUMIF(Mature!$G$5:I$1000,$A29,Mature!D$5:D$1000),\"\")","v":22912},{"$f":"IF(ISNUMBER($A29),SUMIF(Mature!$G$5:J$1000,$A29,Mature!J$5:J$1000),\"\")","v":41185},{"$f":"IF(ISNUMBER($A29),SUMIF(Mature!$G$5:K$1000,$A29,Mature!K$5:K$1000),\"\")","v":21185},null,{"$f":"RIGHT(\"   \"&ROW(A29),3)&RIGHT(A$1&A29,7)&IF(B29=0,\"\",RIGHT(A$1&TEXT(B29,\"#,###,##0\"),B$1)&RIGHT(A$1&TEXT(C29,\"#,###,##0.00\"),C$1)&RIGHT(A$1&TEXT(D29,\"#,###,##0\"),D$1)&RIGHT(A$1&TEXT(E29,\"#,###,##0\"),E$1))","v":" 29   2052   20,000     22,912.00     41,185     21,185"}]
[{"$f":"IF(A29=\"\",\"\",IF(A29+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A29+1,\"\"))","v":2053},{"$f":"IF(ISNUMBER($A30),SUMIF(Mature!$G$5:G$1000,$A30,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A30),SUMIF(Mature!$G$5:I$1000,$A30,Mature!D$5:D$1000),\"\")","v":21896},{"$f":"IF(ISNUMBER($A30),SUMIF(Mature!$G$5:J$1000,$A30,Mature!J$5:J$1000),\"\")","v":51661},{"$f":"IF(ISNUMBER($A30),SUMIF(Mature!$G$5:K$1000,$A30,Mature!K$5:K$1000),\"\")","v":31661},null,{"$f":"RIGHT(\"   \"&ROW(A30),3)&RIGHT(A$1&A30,7)&IF(B30=0,\"\",RIGHT(A$1&TEXT(B30,\"#,###,##0\"),B$1)&RIGHT(A$1&TEXT(C30,\"#,###,##0.00\"),C$1)&RIGHT(A$1&TEXT(D30,\"#,###,##0\"),D$1)&RIGHT(A$1&TEXT(E30,\"#,###,##0\"),E$1))","v":" 30   2053   20,000     21,896.00     51,661     31,661"}]
[{"$f":"IF(A30=\"\",\"\",IF(A30+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A30+1,\"\"))","v":2054},{"$f":"IF(ISNUMBER($A31),SUMIF(Mature!$G$5:G$1000,$A31,Mature!B$5:B$1000),\"\")","v":20000},{"$f":"IF(ISNUMBER($A31),SUMIF(Mature!$G$5:I$1000,$A31,Mature!D$5:D$1000),\"\")","v":20960},{"$f":"IF(ISNUMBER($A31),SUMIF(Mature!$G$5:J$1000,$A31,Mature!J$5:J$1000),\"\")","v":53105},{"$f":"IF(ISNUMBER($A31),SUMIF(Mature!$G$5:K$1000,$A31,Mature!K$5:K$1000),\"\")","v":33105},null,{"$f":"RIGHT(\"   \"&ROW(A31),3)&RIGHT(A$1&A31,7)&IF(B31=0,\"\",RIGHT(A$1&TEXT(B31,\"#,###,##0\"),B$1)&RIGHT(A$1&TEXT(C31,\"#,###,##0.00\"),C$1)&RIGHT(A$1&TEXT(D31,\"#,###,##0\"),D$1)&RIGHT(A$1&TEXT(E31,\"#,###,##0\"),E$1))","v":" 31   2054   20,000     20,960.00     53,105     33,105"}]
[{"$f":"IF(A31=\"\",\"\",IF(A31+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A31+1,\"\"))","v":2055},{"$f":"IF(ISNUMBER($A32),SUMIF(Mature!$G$5:G$1000,$A32,Mature!B$5:B$1000),\"\")","v":10000},{"$f":"IF(ISNUMBER($A32),SUMIF(Mature!$G$5:I$1000,$A32,Mature!D$5:D$1000),\"\")","v":10200},{"$f":"IF(ISNUMBER($A32),SUMIF(Mature!$G$5:J$1000,$A32,Mature!J$5:J$1000),\"\")","v":25350},{"$f":"IF(ISNUMBER($A32),SUMIF(Mature!$G$5:K$1000,$A32,Mature!K$5:K$1000),\"\")","v":15350},null,{"$f":"RIGHT(\"   \"&ROW(A32),3)&RIGHT(A$1&A32,7)&IF(B32=0,\"\",RIGHT(A$1&TEXT(B32,\"#,###,##0\"),B$1)&RIGHT(A$1&TEXT(C32,\"#,###,##0.00\"),C$1)&RIGHT(A$1&TEXT(D32,\"#,###,##0\"),D$1)&RIGHT(A$1&TEXT(E32,\"#,###,##0\"),E$1))","v":" 32   2055   10,000     10,200.00     25,350     15,350"}]
[{"$f":"IF(A32=\"\",\"\",IF(A32+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A32+1,\"\"))","v":""}]
[{"$f":"IF(A33=\"\",\"\",IF(A33+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A33+1,\"\"))","v":""}]
[{"$f":"IF(A34=\"\",\"\",IF(A34+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A34+1,\"\"))","v":""}]
[{"$f":"IF(A35=\"\",\"\",IF(A35+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A35+1,\"\"))","v":""}]
[{"$f":"IF(A36=\"\",\"\",IF(A36+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A36+1,\"\"))","v":""}]
[{"$f":"IF(A37=\"\",\"\",IF(A37+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A37+1,\"\"))","v":""}]
[{"$f":"IF(A38=\"\",\"\",IF(A38+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A38+1,\"\"))","v":""}]
[{"$f":"IF(A39=\"\",\"\",IF(A39+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A39+1,\"\"))","v":""}]
[{"$f":"IF(A40=\"\",\"\",IF(A40+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A40+1,\"\"))","v":""}]
[{"$f":"IF(A41=\"\",\"\",IF(A41+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A41+1,\"\"))","v":""}]
[{"$f":"IF(A42=\"\",\"\",IF(A42+1<=YEAR(MAX(Portfolio!A$5:A$1000))+30,A42+1,\"\"))","v":""}]

{"sheet":"Notes","index":4,"n_rows":99,"n_cols":4,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["2012-08-04","Prepared by Bob Hinkley"]
[null,"Excel workbook for computing the value of a portfolio of I Bonds."]
[null,"Compute for each of twelve months for a designated year."]
[null,"Use an Excel macro to compute and paste the values."]
[]
[null,"Instructions"]
[null,null,"Select the Portfolio sheet"]
[null,null,"Enter the date and amount of each I Bond purchase in columns A and B"]
[null,null,null,"(The day of the month doesn't affect the calculation)"]
[null,null,"Enter the year to display in cell C1"]
[null,null,"Click the [Calculate] button at the top left"]
[]
[null,"Comments"]
[null,null,"Total portfolio value displays in row 2"]
[null,null,"The Dec vs Dec column on the right shows the interest \"accrued\" for the year"]
[null,null,null,"The Jan vs Jan column shows the interest \"earned\" for the year"]
[null,null,null,"Useful for taxpayers using \"Method 2\" for reporting interest (see link below)"]
[null,null,"To see redemption value instead of full value, enter TRUE in cell E2 on Rates sheet"]
[null,null,null,"(Redemption value excludes last 3 months interest on bonds under 5 years old)"]
[null,null,"When entering your portfolio, replace the sample bonds or blank their cells in column A & B,"]
[null,null,null,"don't attempt to delete their rows"]
[null,null,"A value in bold indicates the bond's 6 month \"anniversary\""]
[null,null,"A value in colored italic means the month is after the last known inflation rate"]
[null,null,null,"It carries forward the previous month's value, assuming a 0% composite rate"]
[null,null,"To see the entire value history of a purchase, click the link on the far right"]
[null,null,null,"(If the purchase amount is non-standard, the page for a $25 bond will display"]
[null,null,null," since the value of any other denomination is a multiple of it)"]
[null,null,"To prevent accidentally overwriting formulas the Portolio sheet is protected"]
[null,null,null,"To unprotect it, choose Tools / Protection / Unprotect Sheet (in Excel 2003)"]
[]
[null,"Cautions"]
[null,null,"Do not delete cells that are named as these names are referenced by the macro"]
[null,null,null,"This can happen if you delete the rows or columns that contain the named cells"]
[null,null,null,"Note: deleting a cell is different than deleting its contents"]
[]
[null,"Every six months"]
[null,null,"Enter the new fixed rate and inflation rate on the Rates sheet and change FALSE to TRUE"]
[]
[null,"To enter a portolio of more than 40 I Bonds"]
[null,null,"Select and unprotect Portfolio sheet"]
[null,null,"Color additional rows in columns A and B for additional bonds"]
[null,null,null,"(Coloring is only a visual aid, it doesn't affect the calculation)"]
[null,null,"Copy down the formula from the last cell in the Fixed Rate column"]
[null,null,"Copy down the formulas in the Dec vs Dec and Jan vs Jan columns"]
[null,null,"Reprotect the sheet - Tools / Protection / Protect Sheet"]
[]
[null,"Calculation References"]
[null,null,"http://www.savings-bond-advisor.com/confounding-compounding-calculations/"]
[null,null,"http://www.savings-bond-advisor.com/savings-bond-interest-rate-calculations/"]
[]
[null,"TreasuryDirect I Savings Bonds Rates & Terms and Alternative Calculators"]
[null,null,"http://www.treasurydirect.gov/indiv/research/indepth/ibonds/res_ibonds_iratesandterms.htm"]
[null,null,"http://www.treasurydirect.gov/indiv/tools/tools_savingsbondcalc.htm"]
[null,null,"http://www.treasurydirect.gov/indiv/tools/tools_savingsbondwizard.htm"]
[]
[null,"IRS Discussion of Methods 1 & 2 for Reporting Savings Bond Interest"]
[null,null,"http://www.irs.gov/publications/p550/ch01.html#en_US_2011_publink10009895"]
[]
["2012-08-05","Add option to calculate Gain instead of Value"]
["2012-08-10","Add link to bond's history page on my web site ($25 bond when non-standard amount):"]
[null,null,"http://eyebonds.info/ibonds"]
["2012-08-17","Add preceding December and following January to allow …"]
[null,"Add columns to subtract Dec from Dec & Jan from Jan to get one year's increase in value"]
[null,"Add option to calculate Redemption Value instead of Full Value"]
[null,"Remove option to calculate Gain instead of Value (confusing along with previous changes made today)"]
[]
["2012-08-19","correct determination of when past last known inflation rate to work when showing redemption value"]
[null,"color values past known inflation rate as well as show in italic"]
[null,"Add two rows at top to show total interest and interest for the month"]
[]
["2012-11-07","Add 0.88% Inflation Rate Effective Nov 1"]
["2013-11-01","Update rates eff May 1 2013 & Nov 1 2013"]
["2014-05-01","Update rates eff May 1 2014"]
["2014-11-03","Update rates eff Nov 1 2014"]
["2015-05-01","Update rates eff May 1 2015"]
["2015-11-02","Update rates eff Nov 1 2015"]
["2016-05-02","Update rates eff May 1 2016"]
["2016-11-01","Update rates eff Nov 1 2016"]
["2017-05-01","Update rates eff May 1 2017"]
["2017-11-17","Update rates eff Nov 1 2017"]
["2018-05-01","Update rates eff May 1 2018"]
["2018-11-01","Update rates eff Nov 1 2018"]
["2019-05-01","Update rates eff May 1 2019"]
["2019-11-01","Update rates eff NOv 1 2020"]
["2020-05-01","Update rates eff May 1 2020"]
["2020-11-02","Update rates eff Nov 1 2020"]
["2021-04-02","Add Mature sheet to estimate value of portfolio at maturity."]
[null,"User: Enter estimated future annual CPI increase in the yellow cell."]
[null,"Add MatYrs sheet to group values by maturity year."]
[null,"Save as .XLSM file type instead of .XLS."]
["2021-05-03","Update rates eff May 1 2021"]
["2021-11-01","Update rates eff Nov 1 2021"]
["2022-05-02","Update rates eff May 1 2022"]
["2022-11-01","Update rates eff Nov 1 2022"]
["2023-05-01","Update rates eff May 1 2023"]
["2023-11-01","Update rates eff Nov 1 2023"]
["2024-05-12","Update rates eff May 1 2024"]
["2024-11-01","Update rates eff Nov 1 2024"]
["2025-05-01","Update rates eff May 1 2025"]