{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Disclosures","Engine","Inputs","Calculations","Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"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":"Disclosures","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Important Disclosures"]
[]
["Purpose of the tool. "]
["This tool is provided for general informational purposes only. It’s designed to help you estimate potential deferrals under BorgWarner’s retirement plans. It does not provide financial, investment, or tax advice, and does not consider your individual circumstances beyond the limited data shown. You may wish to consult with your personal tax or financial adviser before making any elections."]
[]
["How estimates are determined. "]
["The results generated by this tool are estimates only and are based on assumptions, preset formulas, and the information provided. Actual outcomes may differ, and errors are possible. If there is any inconsistency between the information produced by this tool and the terms of the applicable plan documents, the plan documents will control."]
[]
["Excess Plan considerations."]
["Participation in any plan involves risk, and future outcomes cannot be guaranteed. Amounts deferred under the Excess Plan are unsecured obligations of the company and are subject to the claims of the company’s general creditors."]
[]
["More information."]
["If you have any questions about this tool or about the retirement plans, please contact Katie Graziana, Retirement Benefits Manager, at  kgraziana@borgwarner.com"]

{"sheet":"Engine","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Current Year Inputs",null,null,"CRC Inputs"]
["1st Payroll:",46037,null,"Years of Service","Under FICA","Above FICA","Effective Date"]
["401(a)(17) Comp Limit:",360000,null,0,0.04,0.08,{"$f":"DATE(YEAR(DOH)+CRC_Table[[#This Row],[Years of Service]],MONTH(DOH),DAY(DOH))","v":0}]
["402(g) Deferral Limit:",24500,null,10,0.05,0.1,{"$f":"DATE(YEAR(DOH)+CRC_Table[[#This Row],[Years of Service]],MONTH(DOH),DAY(DOH))","v":3653}]
["414(v) Catch-up Limit Pre 60:",8000,null,20,0.06,0.115,{"$f":"DATE(YEAR(DOH)+CRC_Table[[#This Row],[Years of Service]],MONTH(DOH),DAY(DOH))","v":7305}]
["414(v) Catch-up Limit 60 - 63:",11250]
["415(c) Annual Additions Limit:",72000,null,"Calculation Inputs"]
["FICA Taxable Wage Base:",184500,null,"Age for Catch-up:",{"$f":"YEAR(Starting_Payroll)-YEAR(DOB)","v":126}]
["FICA Catch-up Required Wage:",150000,null,"414(v) Catch-up Limit:",{"$f":"IF(E8<50,0,IF(AND(E8>=60,E8<64),Catch_Up_Limit_Post,Catch_Up_Limit_Pre))","v":8000}]
[null,null,null,"Annual Additions Limit:",{"$f":"Regulatory_Additions_Limit+Catch_Up_Limit","v":80000}]
["Plan Provisions",null,null,"CRC Start Date:",{"$f":"_xlfn.XLOOKUP(DOH+60,Calculations!B2:B26,Calculations!B2:B26,,1)","v":46037}]
["Match Tier 1:",0.03,null,"Under FICA %:",{"$f":"_xlfn.XLOOKUP(DATE(YEAR(Starting_Payroll),1,1),CRC_Table[Effective Date],CRC_Table[Under FICA],,-1)","v":0.06}]
["Match Tier 1 %:",1,null,"Over FICA %:",{"$f":"_xlfn.XLOOKUP(DATE(YEAR(Starting_Payroll),1,1),CRC_Table[Effective Date],CRC_Table[Above FICA],,-1)","v":0.115}]
["CRC Safe Harbor %:",0.03]

{"sheet":"Inputs","index":2,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
["Instructions"]
[1,"Click \"Enable Content\" at top of screen or via\nFile > Info > Security Warning to allow Macros."]
[2,"Fill out user inputs below."]
[]
[null,"*Required User Input"]
[]
[null,"*Optional User Input"]
[]
[3,"Review pay period calculations via 'Calculations' tab."]
["4a","Review annual projection totals via 'Summary' tab."]
["4b","Print summary statement as PDF via button."]
[]
["Demographic Data"]
["Name:"]
["Date of Hire:"]
["Date of Birth:"]
["Excess Plan Eligible:"]
[{"$f":"\"Prior Year Compensation greater than \"&TEXT(FICA_Roth_Wage,\"$#,###\")&\":\"","v":"Prior Year Compensation greater than $150,000:"}]
[]
["Compensation"]
[null,{"$f":"DATE(YEAR(Starting_Payroll),1,1)","v":46023},{"$f":"DATE(YEAR(Starting_Payroll),4,1)","v":46113}]
["Annual Base Pay:"]
["Base Pay per Payroll:",{"$f":"B22/24","v":0},{"$f":"C22/24","v":0}]
["Bonus Amount:"]
[]
["Deferral Elections"]
[null,null,"Before Tax Deferral %",null,"Roth Deferral %",null,"After Tax Deferral %"]
[null,null,"Current Election:",null,"Current Election:",null,"Current Election:"]
["Payroll","Pay Period","Override","Rate Used","Override","Rate Used","Override","Rate Used"]
[1,{"$f":"Calculations!B2","v":46037},null,{"$f":"IF(C30=\"\",Before_Tax_Elect,C30)","v":0},null,{"$f":"IF(E30=\"\",Roth_Elect,E30)","v":0},null,{"$f":"IF(G30=\"\",After_Tax_Elect,G30)","v":0}]
[2,{"$f":"Calculations!B3","v":46053},null,0,null,0,null,0]
[3,{"$f":"Calculations!B4","v":46068},null,0,null,0,null,0]
["Bonus",{"$f":"Calculations!B5","v":46070},null,0,null,0,null,0]
[4,{"$f":"Calculations!B6","v":46081},null,0,null,0,null,0]
[5,{"$f":"Calculations!B7","v":46096},null,0,null,0,null,0]
[6,{"$f":"Calculations!B8","v":46112},null,0,null,0,null,0]
[7,{"$f":"Calculations!B9","v":46127},null,0,null,0,null,0]
[8,{"$f":"Calculations!B10","v":46142},null,0,null,0,null,0]
[9,{"$f":"Calculations!B11","v":46157},null,0,null,0,null,0]
[10,{"$f":"Calculations!B12","v":46173},null,0,null,0,null,0]
[11,{"$f":"Calculations!B13","v":46188},null,0,null,0,null,0]
[12,{"$f":"Calculations!B14","v":46203},null,0,null,0,null,0]
[13,{"$f":"Calculations!B15","v":46218},null,0,null,0,null,0]
[14,{"$f":"Calculations!B16","v":46234},null,0,null,0,null,0]
[15,{"$f":"Calculations!B17","v":46249},null,0,null,0,null,0]
[16,{"$f":"Calculations!B18","v":46265},null,0,null,0,null,0]
[17,{"$f":"Calculations!B19","v":46280},null,0,null,0,null,0]
[18,{"$f":"Calculations!B20","v":46295},null,0,null,0,null,0]
[19,{"$f":"Calculations!B21","v":46310},null,0,null,0,null,0]
[20,{"$f":"Calculations!B22","v":46326},null,0,null,0,null,0]
[21,{"$f":"Calculations!B23","v":46341},null,0,null,0,null,0]
[22,{"$f":"Calculations!B24","v":46356},null,0,null,0,null,0]
[23,{"$f":"Calculations!B25","v":46371},null,0,null,0,null,0]
[24,{"$f":"Calculations!B26","v":46387},null,0,null,0,null,0]

{"sheet":"Calculations","index":3,"n_rows":27,"n_cols":25,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Payroll","Pay Period","Periodic Compensation","YTD Compensation","401(a)(17) Limited  YTD Compensation","Plan Eligible\nPeriodic Compensation","Savings B/Tax \nPeriodic Deferral","Roth A/Tax\nPeriodic Deferral","YTD Deferral","Savings B/Tax \nCatch-Up\nPeriodic Deferral","Roth A/Tax\nCatch-Up\nPeriodic Deferral","Total\nCatch-Up\nPeriodic Deferral","YTD Catch-Up","Savings Plan\nPeriodic Company Match","Savings Plan\nYTD Company Match","Excess Plan\nPeriodic Company Match","Excess Plan\nYTD Company Match","CRC Qualified Periodic\nSafe Harbor","CRC Qualified\nPeriodic Regular","CRC Qualified\nPeriodic Total","CRC Qualified\nYTD Total","CRC\nExcess Plan Periodic Total","Savings A/Tax \nPeriodic Deferral","Savings A/Tax \nYTD Deferral","Total \nYTD Additions"]
[1,{"$f":"Starting_Payroll","v":46037},{"$f":"IF(DOH>B2,0,IF(A2=\"Bonus\",Bonus_Amt,IF(B2<Comp_Eff_Date_2,Base_Comp_1,Base_Comp_2)))","v":0},{"$f":"SUM($C$2:C2)","v":0},{"$f":"IF(D2>=Compensation_Limit,Compensation_Limit,D2)","v":0},{"$f":"E2-IF(A2=1,0,E1)","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B2,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F2,Deferral_Limit-IF(A2=1,0,I1),Annual_Additions_Limit-IF(A2=1,0,Y1))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B2,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F2,Deferral_Limit-IF(A2=1,0,I1)-G2,Annual_Additions_Limit-IF(A2=1,0,Y1)-G2)","v":0},{"$f":"SUM($G$2:H2)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B2,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F2-G2,M2-IF(A2=1,0,M1)))","v":0},{"$f":"M2-IF(A2=1,0,M1)-J2","v":0},{"$f":"MAX(MIN(F2*(_xlfn.XLOOKUP(B2,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B2,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B2,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G2+H2),Catch_Up_Limit-IF(A2=1,0,M1),Annual_Additions_Limit-IF(A2=1,0,Y1)-G2-H2),0)","v":0},{"$f":"SUM($L$2:L2)","v":0},{"$f":"MIN(MIN(IFERROR((G2+H2+J2+K2)/F2,0),Match_Tier_1)*Match_Tier_1_Perc*F2,Annual_Additions_Limit-IF(A2=1,0,Y1)-G2-H2-L2)","v":0},{"$f":"SUM($N$2:N2)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G2+H2+L2+IF(Excess_Plan_Elig=\"No\",0,MAX(C2*(_xlfn.XLOOKUP(B2,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B2,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M2>0),0,_xlfn.XLOOKUP(B2,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G2+H2)-L2,0)))/C2,0),Match_Tier_1)*Match_Tier_1_Perc*C2))-N2,0)","v":0},{"$f":"SUM($P$2:P2)","v":0},{"$f":"IF(CRC_Start_Date>B2,0,MIN(CRC_Safe_Harbor_Perc*F2,Annual_Additions_Limit-IF(A2=1,0,Y1)-G2-H2-L2-N2))","v":0},{"$f":"T2-R2","v":0},{"$f":"IF(CRC_Start_Date>B2,0,MIN(IF(E2<=FICA_Tax_Base,F2*Under_FICA_Perc,IF(E2-F2>FICA_Tax_Base,F2*Above_FICA_Perc,((FICA_Tax_Base-(E2-F2))*Under_FICA_Perc)+(E2-FICA_Tax_Base)*Above_FICA_Perc)),Annual_Additions_Limit-IF(A2=1,0,Y1)-G2-H2-L2-N2))","v":0},{"$f":"SUM($T$2:T2)","v":0},{"$f":"IF(CRC_Start_Date>B2,0,IF(D2<=FICA_Tax_Base,C2*Under_FICA_Perc,IF(D2-C2>FICA_Tax_Base,C2*Above_FICA_Perc,((FICA_Tax_Base-(D2-C2))*Under_FICA_Perc)+(D2-FICA_Tax_Base)*Above_FICA_Perc))-T2)","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B2,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F2,Annual_Additions_Limit-IF(A2=1,0,Y1)-G2-H2-L2-N2-T2)","v":0},{"$f":"SUM($W$2:W2)","v":0},{"$f":"I2+M2+O2+U2+X2","v":0}]
[2,{"$f":"IF(DAY(B2)=15,\nEOMONTH(B2,0),\nDATE(YEAR(B2),MONTH(B2)+1,15))","v":46053},{"$f":"IF(DOH>B3,0,IF(A3=\"Bonus\",Bonus_Amt,IF(B3<Comp_Eff_Date_2,Base_Comp_1,Base_Comp_2)))","v":0},{"$f":"SUM($C$2:C3)","v":0},{"$f":"IF(D3>=Compensation_Limit,Compensation_Limit,D3)","v":0},{"$f":"E3-IF(A3=1,0,E2)","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B3,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F3,Deferral_Limit-IF(A3=1,0,I2),Annual_Additions_Limit-IF(A3=1,0,Y2))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B3,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F3,Deferral_Limit-IF(A3=1,0,I2)-G3,Annual_Additions_Limit-IF(A3=1,0,Y2)-G3)","v":0},{"$f":"SUM($G$2:H3)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B3,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F3-G3,M3-IF(A3=1,0,M2)))","v":0},{"$f":"M3-IF(A3=1,0,M2)-J3","v":0},{"$f":"MAX(MIN(F3*(_xlfn.XLOOKUP(B3,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B3,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B3,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G3+H3),Catch_Up_Limit-IF(A3=1,0,M2),Annual_Additions_Limit-IF(A3=1,0,Y2)-G3-H3),0)","v":0},{"$f":"SUM($L$2:L3)","v":0},0,{"$f":"SUM($N$2:N3)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G3+H3+L3+IF(Excess_Plan_Elig=\"No\",0,MAX(C3*(_xlfn.XLOOKUP(B3,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B3,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M3>0),0,_xlfn.XLOOKUP(B3,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G3+H3)-L3,0)))/C3,0),Match_Tier_1)*Match_Tier_1_Perc*C3))-N3,0)","v":0},{"$f":"SUM($P$2:P3)","v":0},0,{"$f":"T3-R3","v":0},0,{"$f":"SUM($T$2:T3)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B3,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F3,Annual_Additions_Limit-IF(A3=1,0,Y2)-G3-H3-L3-N3-T3)","v":0},{"$f":"SUM($W$2:W3)","v":0},{"$f":"I3+M3+O3+U3+X3","v":0}]
[3,{"$f":"IF(DAY(B3)=15,\nEOMONTH(B3,0),\nDATE(YEAR(B3),MONTH(B3)+1,15))","v":46068},0,{"$f":"SUM($C$2:C4)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B4,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F4,Deferral_Limit-IF(A4=1,0,I3),Annual_Additions_Limit-IF(A4=1,0,Y3))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B4,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F4,Deferral_Limit-IF(A4=1,0,I3)-G4,Annual_Additions_Limit-IF(A4=1,0,Y3)-G4)","v":0},{"$f":"SUM($G$2:H4)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B4,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F4-G4,M4-IF(A4=1,0,M3)))","v":0},0,{"$f":"MAX(MIN(F4*(_xlfn.XLOOKUP(B4,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B4,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B4,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G4+H4),Catch_Up_Limit-IF(A4=1,0,M3),Annual_Additions_Limit-IF(A4=1,0,Y3)-G4-H4),0)","v":0},{"$f":"SUM($L$2:L4)","v":0},0,{"$f":"SUM($N$2:N4)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G4+H4+L4+IF(Excess_Plan_Elig=\"No\",0,MAX(C4*(_xlfn.XLOOKUP(B4,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B4,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M4>0),0,_xlfn.XLOOKUP(B4,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G4+H4)-L4,0)))/C4,0),Match_Tier_1)*Match_Tier_1_Perc*C4))-N4,0)","v":0},{"$f":"SUM($P$2:P4)","v":0},0,0,0,{"$f":"SUM($T$2:T4)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B4,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F4,Annual_Additions_Limit-IF(A4=1,0,Y3)-G4-H4-L4-N4-T4)","v":0},{"$f":"SUM($W$2:W4)","v":0},0]
["Bonus",{"$f":"B4+2","v":46070},0,{"$f":"SUM($C$2:C5)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B5,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F5,Deferral_Limit-IF(A5=1,0,I4),Annual_Additions_Limit-IF(A5=1,0,Y4))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B5,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F5,Deferral_Limit-IF(A5=1,0,I4)-G5,Annual_Additions_Limit-IF(A5=1,0,Y4)-G5)","v":0},{"$f":"SUM($G$2:H5)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B5,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F5-G5,M5-IF(A5=1,0,M4)))","v":0},0,{"$f":"MAX(MIN(F5*(_xlfn.XLOOKUP(B5,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B5,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B5,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G5+H5),Catch_Up_Limit-IF(A5=1,0,M4),Annual_Additions_Limit-IF(A5=1,0,Y4)-G5-H5),0)","v":0},{"$f":"SUM($L$2:L5)","v":0},0,{"$f":"SUM($N$2:N5)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G5+H5+L5+IF(Excess_Plan_Elig=\"No\",0,MAX(C5*(_xlfn.XLOOKUP(B5,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B5,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M5>0),0,_xlfn.XLOOKUP(B5,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G5+H5)-L5,0)))/C5,0),Match_Tier_1)*Match_Tier_1_Perc*C5))-N5,0)","v":0},{"$f":"SUM($P$2:P5)","v":0},0,0,0,{"$f":"SUM($T$2:T5)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B5,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F5,Annual_Additions_Limit-IF(A5=1,0,Y4)-G5-H5-L5-N5-T5)","v":0},{"$f":"SUM($W$2:W5)","v":0},0]
[4,{"$f":"IF(DAY(B4)=15,\nEOMONTH(B4,0),\nDATE(YEAR(B4),MONTH(B4)+1,15))","v":46081},0,{"$f":"SUM($C$2:C6)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B6,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F6,Deferral_Limit-IF(A6=1,0,I5),Annual_Additions_Limit-IF(A6=1,0,Y5))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B6,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F6,Deferral_Limit-IF(A6=1,0,I5)-G6,Annual_Additions_Limit-IF(A6=1,0,Y5)-G6)","v":0},{"$f":"SUM($G$2:H6)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B6,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F6-G6,M6-IF(A6=1,0,M5)))","v":0},0,{"$f":"MAX(MIN(F6*(_xlfn.XLOOKUP(B6,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B6,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B6,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G6+H6),Catch_Up_Limit-IF(A6=1,0,M5),Annual_Additions_Limit-IF(A6=1,0,Y5)-G6-H6),0)","v":0},{"$f":"SUM($L$2:L6)","v":0},0,{"$f":"SUM($N$2:N6)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G6+H6+L6+IF(Excess_Plan_Elig=\"No\",0,MAX(C6*(_xlfn.XLOOKUP(B6,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B6,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M6>0),0,_xlfn.XLOOKUP(B6,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G6+H6)-L6,0)))/C6,0),Match_Tier_1)*Match_Tier_1_Perc*C6))-N6,0)","v":0},{"$f":"SUM($P$2:P6)","v":0},0,0,0,{"$f":"SUM($T$2:T6)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B6,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F6,Annual_Additions_Limit-IF(A6=1,0,Y5)-G6-H6-L6-N6-T6)","v":0},{"$f":"SUM($W$2:W6)","v":0},0]
[5,{"$f":"IF(DAY(B6)=15,\nEOMONTH(B6,0),\nDATE(YEAR(B6),MONTH(B6)+1,15))","v":46096},0,{"$f":"SUM($C$2:C7)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B7,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F7,Deferral_Limit-IF(A7=1,0,I6),Annual_Additions_Limit-IF(A7=1,0,Y6))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B7,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F7,Deferral_Limit-IF(A7=1,0,I6)-G7,Annual_Additions_Limit-IF(A7=1,0,Y6)-G7)","v":0},{"$f":"SUM($G$2:H7)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B7,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F7-G7,M7-IF(A7=1,0,M6)))","v":0},0,{"$f":"MAX(MIN(F7*(_xlfn.XLOOKUP(B7,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B7,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B7,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G7+H7),Catch_Up_Limit-IF(A7=1,0,M6),Annual_Additions_Limit-IF(A7=1,0,Y6)-G7-H7),0)","v":0},{"$f":"SUM($L$2:L7)","v":0},0,{"$f":"SUM($N$2:N7)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G7+H7+L7+IF(Excess_Plan_Elig=\"No\",0,MAX(C7*(_xlfn.XLOOKUP(B7,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B7,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M7>0),0,_xlfn.XLOOKUP(B7,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G7+H7)-L7,0)))/C7,0),Match_Tier_1)*Match_Tier_1_Perc*C7))-N7,0)","v":0},{"$f":"SUM($P$2:P7)","v":0},0,0,0,{"$f":"SUM($T$2:T7)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B7,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F7,Annual_Additions_Limit-IF(A7=1,0,Y6)-G7-H7-L7-N7-T7)","v":0},{"$f":"SUM($W$2:W7)","v":0},0]
[6,46112,0,{"$f":"SUM($C$2:C8)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B8,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F8,Deferral_Limit-IF(A8=1,0,I7),Annual_Additions_Limit-IF(A8=1,0,Y7))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B8,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F8,Deferral_Limit-IF(A8=1,0,I7)-G8,Annual_Additions_Limit-IF(A8=1,0,Y7)-G8)","v":0},{"$f":"SUM($G$2:H8)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B8,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F8-G8,M8-IF(A8=1,0,M7)))","v":0},0,{"$f":"MAX(MIN(F8*(_xlfn.XLOOKUP(B8,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B8,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B8,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G8+H8),Catch_Up_Limit-IF(A8=1,0,M7),Annual_Additions_Limit-IF(A8=1,0,Y7)-G8-H8),0)","v":0},{"$f":"SUM($L$2:L8)","v":0},0,{"$f":"SUM($N$2:N8)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G8+H8+L8+IF(Excess_Plan_Elig=\"No\",0,MAX(C8*(_xlfn.XLOOKUP(B8,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B8,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M8>0),0,_xlfn.XLOOKUP(B8,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G8+H8)-L8,0)))/C8,0),Match_Tier_1)*Match_Tier_1_Perc*C8))-N8,0)","v":0},{"$f":"SUM($P$2:P8)","v":0},0,0,0,{"$f":"SUM($T$2:T8)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B8,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F8,Annual_Additions_Limit-IF(A8=1,0,Y7)-G8-H8-L8-N8-T8)","v":0},{"$f":"SUM($W$2:W8)","v":0},0]
[7,46127,0,{"$f":"SUM($C$2:C9)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B9,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F9,Deferral_Limit-IF(A9=1,0,I8),Annual_Additions_Limit-IF(A9=1,0,Y8))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B9,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F9,Deferral_Limit-IF(A9=1,0,I8)-G9,Annual_Additions_Limit-IF(A9=1,0,Y8)-G9)","v":0},{"$f":"SUM($G$2:H9)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B9,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F9-G9,M9-IF(A9=1,0,M8)))","v":0},0,{"$f":"MAX(MIN(F9*(_xlfn.XLOOKUP(B9,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B9,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B9,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G9+H9),Catch_Up_Limit-IF(A9=1,0,M8),Annual_Additions_Limit-IF(A9=1,0,Y8)-G9-H9),0)","v":0},{"$f":"SUM($L$2:L9)","v":0},0,{"$f":"SUM($N$2:N9)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G9+H9+L9+IF(Excess_Plan_Elig=\"No\",0,MAX(C9*(_xlfn.XLOOKUP(B9,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B9,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M9>0),0,_xlfn.XLOOKUP(B9,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G9+H9)-L9,0)))/C9,0),Match_Tier_1)*Match_Tier_1_Perc*C9))-N9,0)","v":0},{"$f":"SUM($P$2:P9)","v":0},0,0,0,{"$f":"SUM($T$2:T9)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B9,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F9,Annual_Additions_Limit-IF(A9=1,0,Y8)-G9-H9-L9-N9-T9)","v":0},{"$f":"SUM($W$2:W9)","v":0},0]
[8,46142,0,{"$f":"SUM($C$2:C10)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B10,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F10,Deferral_Limit-IF(A10=1,0,I9),Annual_Additions_Limit-IF(A10=1,0,Y9))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B10,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F10,Deferral_Limit-IF(A10=1,0,I9)-G10,Annual_Additions_Limit-IF(A10=1,0,Y9)-G10)","v":0},{"$f":"SUM($G$2:H10)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B10,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F10-G10,M10-IF(A10=1,0,M9)))","v":0},0,{"$f":"MAX(MIN(F10*(_xlfn.XLOOKUP(B10,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B10,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B10,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G10+H10),Catch_Up_Limit-IF(A10=1,0,M9),Annual_Additions_Limit-IF(A10=1,0,Y9)-G10-H10),0)","v":0},{"$f":"SUM($L$2:L10)","v":0},0,{"$f":"SUM($N$2:N10)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G10+H10+L10+IF(Excess_Plan_Elig=\"No\",0,MAX(C10*(_xlfn.XLOOKUP(B10,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B10,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M10>0),0,_xlfn.XLOOKUP(B10,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G10+H10)-L10,0)))/C10,0),Match_Tier_1)*Match_Tier_1_Perc*C10))-N10,0)","v":0},{"$f":"SUM($P$2:P10)","v":0},0,0,0,{"$f":"SUM($T$2:T10)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B10,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F10,Annual_Additions_Limit-IF(A10=1,0,Y9)-G10-H10-L10-N10-T10)","v":0},{"$f":"SUM($W$2:W10)","v":0},0]
[9,46157,0,{"$f":"SUM($C$2:C11)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B11,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F11,Deferral_Limit-IF(A11=1,0,I10),Annual_Additions_Limit-IF(A11=1,0,Y10))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B11,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F11,Deferral_Limit-IF(A11=1,0,I10)-G11,Annual_Additions_Limit-IF(A11=1,0,Y10)-G11)","v":0},{"$f":"SUM($G$2:H11)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B11,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F11-G11,M11-IF(A11=1,0,M10)))","v":0},0,{"$f":"MAX(MIN(F11*(_xlfn.XLOOKUP(B11,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B11,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B11,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G11+H11),Catch_Up_Limit-IF(A11=1,0,M10),Annual_Additions_Limit-IF(A11=1,0,Y10)-G11-H11),0)","v":0},{"$f":"SUM($L$2:L11)","v":0},0,{"$f":"SUM($N$2:N11)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G11+H11+L11+IF(Excess_Plan_Elig=\"No\",0,MAX(C11*(_xlfn.XLOOKUP(B11,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B11,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M11>0),0,_xlfn.XLOOKUP(B11,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G11+H11)-L11,0)))/C11,0),Match_Tier_1)*Match_Tier_1_Perc*C11))-N11,0)","v":0},{"$f":"SUM($P$2:P11)","v":0},0,0,0,{"$f":"SUM($T$2:T11)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B11,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F11,Annual_Additions_Limit-IF(A11=1,0,Y10)-G11-H11-L11-N11-T11)","v":0},{"$f":"SUM($W$2:W11)","v":0},0]
[10,46173,0,{"$f":"SUM($C$2:C12)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B12,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F12,Deferral_Limit-IF(A12=1,0,I11),Annual_Additions_Limit-IF(A12=1,0,Y11))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B12,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F12,Deferral_Limit-IF(A12=1,0,I11)-G12,Annual_Additions_Limit-IF(A12=1,0,Y11)-G12)","v":0},{"$f":"SUM($G$2:H12)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B12,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F12-G12,M12-IF(A12=1,0,M11)))","v":0},0,{"$f":"MAX(MIN(F12*(_xlfn.XLOOKUP(B12,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B12,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B12,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G12+H12),Catch_Up_Limit-IF(A12=1,0,M11),Annual_Additions_Limit-IF(A12=1,0,Y11)-G12-H12),0)","v":0},{"$f":"SUM($L$2:L12)","v":0},0,{"$f":"SUM($N$2:N12)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G12+H12+L12+IF(Excess_Plan_Elig=\"No\",0,MAX(C12*(_xlfn.XLOOKUP(B12,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B12,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M12>0),0,_xlfn.XLOOKUP(B12,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G12+H12)-L12,0)))/C12,0),Match_Tier_1)*Match_Tier_1_Perc*C12))-N12,0)","v":0},{"$f":"SUM($P$2:P12)","v":0},0,0,0,{"$f":"SUM($T$2:T12)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B12,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F12,Annual_Additions_Limit-IF(A12=1,0,Y11)-G12-H12-L12-N12-T12)","v":0},{"$f":"SUM($W$2:W12)","v":0},0]
[11,46188,0,{"$f":"SUM($C$2:C13)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B13,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F13,Deferral_Limit-IF(A13=1,0,I12),Annual_Additions_Limit-IF(A13=1,0,Y12))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B13,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F13,Deferral_Limit-IF(A13=1,0,I12)-G13,Annual_Additions_Limit-IF(A13=1,0,Y12)-G13)","v":0},{"$f":"SUM($G$2:H13)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B13,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F13-G13,M13-IF(A13=1,0,M12)))","v":0},0,{"$f":"MAX(MIN(F13*(_xlfn.XLOOKUP(B13,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B13,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B13,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G13+H13),Catch_Up_Limit-IF(A13=1,0,M12),Annual_Additions_Limit-IF(A13=1,0,Y12)-G13-H13),0)","v":0},{"$f":"SUM($L$2:L13)","v":0},0,{"$f":"SUM($N$2:N13)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G13+H13+L13+IF(Excess_Plan_Elig=\"No\",0,MAX(C13*(_xlfn.XLOOKUP(B13,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B13,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M13>0),0,_xlfn.XLOOKUP(B13,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G13+H13)-L13,0)))/C13,0),Match_Tier_1)*Match_Tier_1_Perc*C13))-N13,0)","v":0},{"$f":"SUM($P$2:P13)","v":0},0,0,0,{"$f":"SUM($T$2:T13)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B13,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F13,Annual_Additions_Limit-IF(A13=1,0,Y12)-G13-H13-L13-N13-T13)","v":0},{"$f":"SUM($W$2:W13)","v":0},0]
[12,46203,0,{"$f":"SUM($C$2:C14)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B14,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F14,Deferral_Limit-IF(A14=1,0,I13),Annual_Additions_Limit-IF(A14=1,0,Y13))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B14,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F14,Deferral_Limit-IF(A14=1,0,I13)-G14,Annual_Additions_Limit-IF(A14=1,0,Y13)-G14)","v":0},{"$f":"SUM($G$2:H14)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B14,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F14-G14,M14-IF(A14=1,0,M13)))","v":0},0,{"$f":"MAX(MIN(F14*(_xlfn.XLOOKUP(B14,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B14,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B14,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G14+H14),Catch_Up_Limit-IF(A14=1,0,M13),Annual_Additions_Limit-IF(A14=1,0,Y13)-G14-H14),0)","v":0},{"$f":"SUM($L$2:L14)","v":0},0,{"$f":"SUM($N$2:N14)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G14+H14+L14+IF(Excess_Plan_Elig=\"No\",0,MAX(C14*(_xlfn.XLOOKUP(B14,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B14,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M14>0),0,_xlfn.XLOOKUP(B14,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G14+H14)-L14,0)))/C14,0),Match_Tier_1)*Match_Tier_1_Perc*C14))-N14,0)","v":0},{"$f":"SUM($P$2:P14)","v":0},0,0,0,{"$f":"SUM($T$2:T14)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B14,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F14,Annual_Additions_Limit-IF(A14=1,0,Y13)-G14-H14-L14-N14-T14)","v":0},{"$f":"SUM($W$2:W14)","v":0},0]
[13,46218,0,{"$f":"SUM($C$2:C15)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B15,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F15,Deferral_Limit-IF(A15=1,0,I14),Annual_Additions_Limit-IF(A15=1,0,Y14))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B15,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F15,Deferral_Limit-IF(A15=1,0,I14)-G15,Annual_Additions_Limit-IF(A15=1,0,Y14)-G15)","v":0},{"$f":"SUM($G$2:H15)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B15,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F15-G15,M15-IF(A15=1,0,M14)))","v":0},0,{"$f":"MAX(MIN(F15*(_xlfn.XLOOKUP(B15,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B15,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B15,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G15+H15),Catch_Up_Limit-IF(A15=1,0,M14),Annual_Additions_Limit-IF(A15=1,0,Y14)-G15-H15),0)","v":0},{"$f":"SUM($L$2:L15)","v":0},0,{"$f":"SUM($N$2:N15)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G15+H15+L15+IF(Excess_Plan_Elig=\"No\",0,MAX(C15*(_xlfn.XLOOKUP(B15,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B15,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M15>0),0,_xlfn.XLOOKUP(B15,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G15+H15)-L15,0)))/C15,0),Match_Tier_1)*Match_Tier_1_Perc*C15))-N15,0)","v":0},{"$f":"SUM($P$2:P15)","v":0},0,0,0,{"$f":"SUM($T$2:T15)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B15,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F15,Annual_Additions_Limit-IF(A15=1,0,Y14)-G15-H15-L15-N15-T15)","v":0},{"$f":"SUM($W$2:W15)","v":0},0]
[14,46234,0,{"$f":"SUM($C$2:C16)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B16,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F16,Deferral_Limit-IF(A16=1,0,I15),Annual_Additions_Limit-IF(A16=1,0,Y15))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B16,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F16,Deferral_Limit-IF(A16=1,0,I15)-G16,Annual_Additions_Limit-IF(A16=1,0,Y15)-G16)","v":0},{"$f":"SUM($G$2:H16)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B16,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F16-G16,M16-IF(A16=1,0,M15)))","v":0},0,{"$f":"MAX(MIN(F16*(_xlfn.XLOOKUP(B16,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B16,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B16,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G16+H16),Catch_Up_Limit-IF(A16=1,0,M15),Annual_Additions_Limit-IF(A16=1,0,Y15)-G16-H16),0)","v":0},{"$f":"SUM($L$2:L16)","v":0},0,{"$f":"SUM($N$2:N16)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G16+H16+L16+IF(Excess_Plan_Elig=\"No\",0,MAX(C16*(_xlfn.XLOOKUP(B16,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B16,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M16>0),0,_xlfn.XLOOKUP(B16,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G16+H16)-L16,0)))/C16,0),Match_Tier_1)*Match_Tier_1_Perc*C16))-N16,0)","v":0},{"$f":"SUM($P$2:P16)","v":0},0,0,0,{"$f":"SUM($T$2:T16)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B16,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F16,Annual_Additions_Limit-IF(A16=1,0,Y15)-G16-H16-L16-N16-T16)","v":0},{"$f":"SUM($W$2:W16)","v":0},0]
[15,46249,0,{"$f":"SUM($C$2:C17)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B17,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F17,Deferral_Limit-IF(A17=1,0,I16),Annual_Additions_Limit-IF(A17=1,0,Y16))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B17,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F17,Deferral_Limit-IF(A17=1,0,I16)-G17,Annual_Additions_Limit-IF(A17=1,0,Y16)-G17)","v":0},{"$f":"SUM($G$2:H17)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B17,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F17-G17,M17-IF(A17=1,0,M16)))","v":0},0,{"$f":"MAX(MIN(F17*(_xlfn.XLOOKUP(B17,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B17,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B17,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G17+H17),Catch_Up_Limit-IF(A17=1,0,M16),Annual_Additions_Limit-IF(A17=1,0,Y16)-G17-H17),0)","v":0},{"$f":"SUM($L$2:L17)","v":0},0,{"$f":"SUM($N$2:N17)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G17+H17+L17+IF(Excess_Plan_Elig=\"No\",0,MAX(C17*(_xlfn.XLOOKUP(B17,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B17,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M17>0),0,_xlfn.XLOOKUP(B17,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G17+H17)-L17,0)))/C17,0),Match_Tier_1)*Match_Tier_1_Perc*C17))-N17,0)","v":0},{"$f":"SUM($P$2:P17)","v":0},0,0,0,{"$f":"SUM($T$2:T17)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B17,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F17,Annual_Additions_Limit-IF(A17=1,0,Y16)-G17-H17-L17-N17-T17)","v":0},{"$f":"SUM($W$2:W17)","v":0},0]
[16,46265,0,{"$f":"SUM($C$2:C18)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B18,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F18,Deferral_Limit-IF(A18=1,0,I17),Annual_Additions_Limit-IF(A18=1,0,Y17))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B18,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F18,Deferral_Limit-IF(A18=1,0,I17)-G18,Annual_Additions_Limit-IF(A18=1,0,Y17)-G18)","v":0},{"$f":"SUM($G$2:H18)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B18,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F18-G18,M18-IF(A18=1,0,M17)))","v":0},0,{"$f":"MAX(MIN(F18*(_xlfn.XLOOKUP(B18,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B18,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B18,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G18+H18),Catch_Up_Limit-IF(A18=1,0,M17),Annual_Additions_Limit-IF(A18=1,0,Y17)-G18-H18),0)","v":0},{"$f":"SUM($L$2:L18)","v":0},0,{"$f":"SUM($N$2:N18)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G18+H18+L18+IF(Excess_Plan_Elig=\"No\",0,MAX(C18*(_xlfn.XLOOKUP(B18,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B18,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M18>0),0,_xlfn.XLOOKUP(B18,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G18+H18)-L18,0)))/C18,0),Match_Tier_1)*Match_Tier_1_Perc*C18))-N18,0)","v":0},{"$f":"SUM($P$2:P18)","v":0},0,0,0,{"$f":"SUM($T$2:T18)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B18,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F18,Annual_Additions_Limit-IF(A18=1,0,Y17)-G18-H18-L18-N18-T18)","v":0},{"$f":"SUM($W$2:W18)","v":0},0]
[17,46280,0,{"$f":"SUM($C$2:C19)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B19,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F19,Deferral_Limit-IF(A19=1,0,I18),Annual_Additions_Limit-IF(A19=1,0,Y18))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B19,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F19,Deferral_Limit-IF(A19=1,0,I18)-G19,Annual_Additions_Limit-IF(A19=1,0,Y18)-G19)","v":0},{"$f":"SUM($G$2:H19)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B19,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F19-G19,M19-IF(A19=1,0,M18)))","v":0},0,{"$f":"MAX(MIN(F19*(_xlfn.XLOOKUP(B19,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B19,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B19,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G19+H19),Catch_Up_Limit-IF(A19=1,0,M18),Annual_Additions_Limit-IF(A19=1,0,Y18)-G19-H19),0)","v":0},{"$f":"SUM($L$2:L19)","v":0},0,{"$f":"SUM($N$2:N19)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G19+H19+L19+IF(Excess_Plan_Elig=\"No\",0,MAX(C19*(_xlfn.XLOOKUP(B19,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B19,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M19>0),0,_xlfn.XLOOKUP(B19,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G19+H19)-L19,0)))/C19,0),Match_Tier_1)*Match_Tier_1_Perc*C19))-N19,0)","v":0},{"$f":"SUM($P$2:P19)","v":0},0,0,0,{"$f":"SUM($T$2:T19)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B19,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F19,Annual_Additions_Limit-IF(A19=1,0,Y18)-G19-H19-L19-N19-T19)","v":0},{"$f":"SUM($W$2:W19)","v":0},0]
[18,46295,0,{"$f":"SUM($C$2:C20)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B20,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F20,Deferral_Limit-IF(A20=1,0,I19),Annual_Additions_Limit-IF(A20=1,0,Y19))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B20,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F20,Deferral_Limit-IF(A20=1,0,I19)-G20,Annual_Additions_Limit-IF(A20=1,0,Y19)-G20)","v":0},{"$f":"SUM($G$2:H20)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B20,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F20-G20,M20-IF(A20=1,0,M19)))","v":0},0,{"$f":"MAX(MIN(F20*(_xlfn.XLOOKUP(B20,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B20,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B20,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G20+H20),Catch_Up_Limit-IF(A20=1,0,M19),Annual_Additions_Limit-IF(A20=1,0,Y19)-G20-H20),0)","v":0},{"$f":"SUM($L$2:L20)","v":0},0,{"$f":"SUM($N$2:N20)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G20+H20+L20+IF(Excess_Plan_Elig=\"No\",0,MAX(C20*(_xlfn.XLOOKUP(B20,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B20,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M20>0),0,_xlfn.XLOOKUP(B20,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G20+H20)-L20,0)))/C20,0),Match_Tier_1)*Match_Tier_1_Perc*C20))-N20,0)","v":0},{"$f":"SUM($P$2:P20)","v":0},0,0,0,{"$f":"SUM($T$2:T20)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B20,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F20,Annual_Additions_Limit-IF(A20=1,0,Y19)-G20-H20-L20-N20-T20)","v":0},{"$f":"SUM($W$2:W20)","v":0},0]
[19,46310,0,{"$f":"SUM($C$2:C21)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B21,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F21,Deferral_Limit-IF(A21=1,0,I20),Annual_Additions_Limit-IF(A21=1,0,Y20))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B21,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F21,Deferral_Limit-IF(A21=1,0,I20)-G21,Annual_Additions_Limit-IF(A21=1,0,Y20)-G21)","v":0},{"$f":"SUM($G$2:H21)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B21,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F21-G21,M21-IF(A21=1,0,M20)))","v":0},0,{"$f":"MAX(MIN(F21*(_xlfn.XLOOKUP(B21,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B21,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B21,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G21+H21),Catch_Up_Limit-IF(A21=1,0,M20),Annual_Additions_Limit-IF(A21=1,0,Y20)-G21-H21),0)","v":0},{"$f":"SUM($L$2:L21)","v":0},0,{"$f":"SUM($N$2:N21)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G21+H21+L21+IF(Excess_Plan_Elig=\"No\",0,MAX(C21*(_xlfn.XLOOKUP(B21,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B21,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M21>0),0,_xlfn.XLOOKUP(B21,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G21+H21)-L21,0)))/C21,0),Match_Tier_1)*Match_Tier_1_Perc*C21))-N21,0)","v":0},{"$f":"SUM($P$2:P21)","v":0},0,0,0,{"$f":"SUM($T$2:T21)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B21,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F21,Annual_Additions_Limit-IF(A21=1,0,Y20)-G21-H21-L21-N21-T21)","v":0},{"$f":"SUM($W$2:W21)","v":0},0]
[20,46326,0,{"$f":"SUM($C$2:C22)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B22,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F22,Deferral_Limit-IF(A22=1,0,I21),Annual_Additions_Limit-IF(A22=1,0,Y21))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B22,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F22,Deferral_Limit-IF(A22=1,0,I21)-G22,Annual_Additions_Limit-IF(A22=1,0,Y21)-G22)","v":0},{"$f":"SUM($G$2:H22)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B22,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F22-G22,M22-IF(A22=1,0,M21)))","v":0},0,{"$f":"MAX(MIN(F22*(_xlfn.XLOOKUP(B22,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B22,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B22,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G22+H22),Catch_Up_Limit-IF(A22=1,0,M21),Annual_Additions_Limit-IF(A22=1,0,Y21)-G22-H22),0)","v":0},{"$f":"SUM($L$2:L22)","v":0},0,{"$f":"SUM($N$2:N22)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G22+H22+L22+IF(Excess_Plan_Elig=\"No\",0,MAX(C22*(_xlfn.XLOOKUP(B22,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B22,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M22>0),0,_xlfn.XLOOKUP(B22,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G22+H22)-L22,0)))/C22,0),Match_Tier_1)*Match_Tier_1_Perc*C22))-N22,0)","v":0},{"$f":"SUM($P$2:P22)","v":0},0,0,0,{"$f":"SUM($T$2:T22)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B22,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F22,Annual_Additions_Limit-IF(A22=1,0,Y21)-G22-H22-L22-N22-T22)","v":0},{"$f":"SUM($W$2:W22)","v":0},0]
[21,46341,0,{"$f":"SUM($C$2:C23)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B23,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F23,Deferral_Limit-IF(A23=1,0,I22),Annual_Additions_Limit-IF(A23=1,0,Y22))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B23,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F23,Deferral_Limit-IF(A23=1,0,I22)-G23,Annual_Additions_Limit-IF(A23=1,0,Y22)-G23)","v":0},{"$f":"SUM($G$2:H23)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B23,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F23-G23,M23-IF(A23=1,0,M22)))","v":0},0,{"$f":"MAX(MIN(F23*(_xlfn.XLOOKUP(B23,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B23,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B23,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G23+H23),Catch_Up_Limit-IF(A23=1,0,M22),Annual_Additions_Limit-IF(A23=1,0,Y22)-G23-H23),0)","v":0},{"$f":"SUM($L$2:L23)","v":0},0,{"$f":"SUM($N$2:N23)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G23+H23+L23+IF(Excess_Plan_Elig=\"No\",0,MAX(C23*(_xlfn.XLOOKUP(B23,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B23,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M23>0),0,_xlfn.XLOOKUP(B23,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G23+H23)-L23,0)))/C23,0),Match_Tier_1)*Match_Tier_1_Perc*C23))-N23,0)","v":0},{"$f":"SUM($P$2:P23)","v":0},0,0,0,{"$f":"SUM($T$2:T23)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B23,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F23,Annual_Additions_Limit-IF(A23=1,0,Y22)-G23-H23-L23-N23-T23)","v":0},{"$f":"SUM($W$2:W23)","v":0},0]
[22,46356,0,{"$f":"SUM($C$2:C24)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B24,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F24,Deferral_Limit-IF(A24=1,0,I23),Annual_Additions_Limit-IF(A24=1,0,Y23))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B24,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F24,Deferral_Limit-IF(A24=1,0,I23)-G24,Annual_Additions_Limit-IF(A24=1,0,Y23)-G24)","v":0},{"$f":"SUM($G$2:H24)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B24,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F24-G24,M24-IF(A24=1,0,M23)))","v":0},0,{"$f":"MAX(MIN(F24*(_xlfn.XLOOKUP(B24,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B24,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B24,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G24+H24),Catch_Up_Limit-IF(A24=1,0,M23),Annual_Additions_Limit-IF(A24=1,0,Y23)-G24-H24),0)","v":0},{"$f":"SUM($L$2:L24)","v":0},0,{"$f":"SUM($N$2:N24)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G24+H24+L24+IF(Excess_Plan_Elig=\"No\",0,MAX(C24*(_xlfn.XLOOKUP(B24,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B24,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M24>0),0,_xlfn.XLOOKUP(B24,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G24+H24)-L24,0)))/C24,0),Match_Tier_1)*Match_Tier_1_Perc*C24))-N24,0)","v":0},{"$f":"SUM($P$2:P24)","v":0},0,0,0,{"$f":"SUM($T$2:T24)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B24,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F24,Annual_Additions_Limit-IF(A24=1,0,Y23)-G24-H24-L24-N24-T24)","v":0},{"$f":"SUM($W$2:W24)","v":0},0]
[23,46371,0,{"$f":"SUM($C$2:C25)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B25,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F25,Deferral_Limit-IF(A25=1,0,I24),Annual_Additions_Limit-IF(A25=1,0,Y24))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B25,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F25,Deferral_Limit-IF(A25=1,0,I24)-G25,Annual_Additions_Limit-IF(A25=1,0,Y24)-G25)","v":0},{"$f":"SUM($G$2:H25)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B25,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F25-G25,M25-IF(A25=1,0,M24)))","v":0},0,{"$f":"MAX(MIN(F25*(_xlfn.XLOOKUP(B25,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B25,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B25,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G25+H25),Catch_Up_Limit-IF(A25=1,0,M24),Annual_Additions_Limit-IF(A25=1,0,Y24)-G25-H25),0)","v":0},{"$f":"SUM($L$2:L25)","v":0},0,{"$f":"SUM($N$2:N25)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G25+H25+L25+IF(Excess_Plan_Elig=\"No\",0,MAX(C25*(_xlfn.XLOOKUP(B25,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B25,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M25>0),0,_xlfn.XLOOKUP(B25,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G25+H25)-L25,0)))/C25,0),Match_Tier_1)*Match_Tier_1_Perc*C25))-N25,0)","v":0},{"$f":"SUM($P$2:P25)","v":0},0,0,0,{"$f":"SUM($T$2:T25)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B25,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F25,Annual_Additions_Limit-IF(A25=1,0,Y24)-G25-H25-L25-N25-T25)","v":0},{"$f":"SUM($W$2:W25)","v":0},0]
[24,46387,0,{"$f":"SUM($C$2:C26)","v":0},0,0,{"$f":"MIN(_xlfn.XLOOKUP(B26,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F26,Deferral_Limit-IF(A26=1,0,I25),Annual_Additions_Limit-IF(A26=1,0,Y25))","v":0},{"$f":"MIN(_xlfn.XLOOKUP(B26,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)*F26,Deferral_Limit-IF(A26=1,0,I25)-G26,Annual_Additions_Limit-IF(A26=1,0,Y25)-G26)","v":0},{"$f":"SUM($G$2:H26)","v":0},{"$f":"IF(Prior_Yr_HCE_Indic=\"Yes\",0,MIN(_xlfn.XLOOKUP(B26,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)*F26-G26,M26-IF(A26=1,0,M25)))","v":0},0,{"$f":"MAX(MIN(F26*(_xlfn.XLOOKUP(B26,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B26,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0),0,_xlfn.XLOOKUP(B26,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G26+H26),Catch_Up_Limit-IF(A26=1,0,M25),Annual_Additions_Limit-IF(A26=1,0,Y25)-G26-H26),0)","v":0},{"$f":"SUM($L$2:L26)","v":0},0,{"$f":"SUM($N$2:N26)","v":0},{"$f":"MAX(IF(Excess_Plan_Elig=\"No\",0,(MIN(IFERROR((G26+H26+L26+IF(Excess_Plan_Elig=\"No\",0,MAX(C26*(_xlfn.XLOOKUP(B26,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)+IF((Prior_Yr_HCE_Indic=\"Yes\")*(_xlfn.XLOOKUP(B26,Inputs!$B$30:$B$54,Inputs!$D$30:$D$54)>0)*(M26>0),0,_xlfn.XLOOKUP(B26,Inputs!$B$30:$B$54,Inputs!$F$30:$F$54)))-(G26+H26)-L26,0)))/C26,0),Match_Tier_1)*Match_Tier_1_Perc*C26))-N26,0)","v":0},{"$f":"SUM($P$2:P26)","v":0},0,0,0,{"$f":"SUM($T$2:T26)","v":0},0,{"$f":"MIN(_xlfn.XLOOKUP(B26,Inputs!$B$30:$B$54,Inputs!$H$30:$H$54)*F26,Annual_Additions_Limit-IF(A26=1,0,Y25)-G26-H26-L26-N26-T26)","v":0},{"$f":"SUM($W$2:W26)","v":0},0]
["Totals",null,{"$f":"SUM(C2:C26)","v":0},null,null,{"$f":"SUM(F2:F26)","v":0},{"$f":"SUM(G2:G26)","v":0},{"$f":"SUM(H2:H26)","v":0},null,{"$f":"SUM(J2:J26)","v":0},{"$f":"SUM(K2:K26)","v":0},{"$f":"SUM(L2:L26)","v":0},null,{"$f":"SUM(N2:N26)","v":0},null,{"$f":"SUM(P2:P26)","v":0},null,{"$f":"SUM(R2:R26)","v":0},{"$f":"SUM(S2:S26)","v":0},{"$f":"SUM(T2:T26)","v":0},null,{"$f":"SUM(V2:V26)","v":0},{"$f":"SUM(W2:W26)","v":0}]

{"sheet":"Summary","index":4,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[27,0,27,4],[29,0,29,4],[31,0,31,4],[33,0,33,4]]}
["RSP & Excess Plan Benefit Summary"]
[{"$f":"\"Statement Printed \"&TEXT(TODAY(),\"mmmm d, yyyy\")","v":"Statement Printed January 15, 2026"}]
[]
["Participant Information",null,null,"Projected Totals"]
["Name:",{"$f":"Name","v":0},null,"Compensation"]
["Date of Hire:",{"$f":"TEXT(DOH,\"mmmm d, yyyy\")","v":"January 0, 1900"},null,"Uncapped Pay",{"$f":"Calculations!C27","v":0}]
["Date of Birth:",{"$f":"TEXT(DOB,\"mmmm d, yyyy\")","v":"January 0, 1900"},null,"401(a)(17) Limited Pay",{"$f":"Calculations!F27","v":0}]
["Excess Plan Eligible:",{"$f":"Excess_Plan_Elig","v":0}]
["Catch-up as Roth required:",{"$f":"Prior_Yr_HCE_Indic","v":0},null,"Employee Contributions"]
["Annual Compensation",null,null,"Before Tax Deferrals",{"$f":"Calculations!G27+Calculations!J27","v":0}]
[{"$f":"\"Base Pay through \"&TEXT(Comp_Eff_Date_2,\"mmmm d, yyyy\")&\":\"","v":"Base Pay through April 1, 2026:"},{"$f":"Inputs!B22","v":0},null,"Roth Deferrals",{"$f":"Calculations!H27+Calculations!K27","v":0}]
[{"$f":"\"Base Pay after \"&TEXT(Comp_Eff_Date_2,\"mmmm d, yyyy\")&\":\"","v":"Base Pay after April 1, 2026:"},{"$f":"Inputs!C22","v":0},null,"After Tax Deferrals",{"$f":"Calculations!W27","v":0}]
[{"$f":"YEAR(Starting_Payroll)&\" Bonus Amount:\"","v":"2026 Bonus Amount:"},{"$f":"Bonus_Amt","v":0},null,"Total",{"$f":"SUM(E10:E12)","v":0}]
["Effective Deferral Rates"]
["Before Tax Deferral %:",{"$f":"IFERROR(E10/$E$7,0)","v":0},null,"Employer Contributions"]
["Roth Deferral %:",{"$f":"IFERROR(E11/$E$7,0)","v":0},null,"Company Retirement Account (CRC) - Qualified",{"$f":"Calculations!T27","v":0}]
["After Tax Deferral %:",{"$f":"IFERROR(E12/$E$7,0)","v":0},null,"Company Retirement Account (CRC) - Excess",{"$f":"Calculations!V27","v":0}]
["Statutory/Plan Limits ",null,null,"Savings Plan Match",{"$f":"Calculations!N27","v":0}]
["FICA Taxable Wage Base:",{"$f":"FICA_Tax_Base","v":184500},null,"Excess Plan Match",{"$f":"Calculations!P27","v":0}]
["401(a)(17) Compensation:",{"$f":"Compensation_Limit","v":360000},null,"Total",{"$f":"SUM(E16:E19)","v":0}]
["402(g) Deferral:",{"$f":"Deferral_Limit","v":24500}]
["414(v) Catch-up:",{"$f":"Catch_Up_Limit","v":8000},null,"Plan Breakout"]
["415(c) Annual Additions:",{"$f":"Annual_Additions_Limit","v":80000},null,"Total RSP Contributions",{"$f":"E13+E16+E18","v":0}]
[null,null,null,"Total Excess Plan Contributions",{"$f":"E17+E19","v":0}]
[null,null,null,"Grand Total",{"$f":"SUM(E23:E24)","v":0}]
[]
[{"$f":"Disclosures!A3","v":"Purpose of the tool. "}]
[{"$f":"Disclosures!A4","v":"This tool is provided for general informational purposes only. It’s designed to help you estimate potential deferrals under BorgWarner’s retirement plans. It does not provide financial, investment, or tax advice, and does not consider your individual circumstances beyond the limited data shown. You may wish to consult with your personal tax or financial adviser before making any elections."}]
[{"$f":"Disclosures!A6","v":"How estimates are determined. "}]
[{"$f":"Disclosures!A7","v":"The results generated by this tool are estimates only and are based on assumptions, preset formulas, and the information provided. Actual outcomes may differ, and errors are possible. If there is any inconsistency between the information produced by this tool and the terms of the applicable plan documents, the plan documents will control."}]
[{"$f":"Disclosures!A9","v":"Excess Plan considerations."}]
[{"$f":"Disclosures!A10","v":"Participation in any plan involves risk, and future outcomes cannot be guaranteed. Amounts deferred under the Excess Plan are unsecured obligations of the company and are subject to the claims of the company’s general creditors."}]
[{"$f":"Disclosures!A12","v":"More information."}]
[{"$f":"Disclosures!A13","v":"If you have any questions about this tool or about the retirement plans, please contact Katie Graziana, Retirement Benefits Manager, at  kgraziana@borgwarner.com"}]