{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Income Calculator","_DEF_AND_RESET_01_2022_","__VAR_OPS__","_LOOKUP_LISTS_","_SHOW_HIDE_TOTALS_","_SHOW_HIDE_OPS_","_DEFAULTS_AND_RESET_"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"Income Calculator","index":0,"n_rows":324,"n_cols":14,"rows_kept":324,"cut":false,"hidden":false,"merged":[[311,3,311,6],[312,3,312,6],[313,3,313,6],[324,2,335,13],[314,3,314,5],[316,3,316,8],[317,3,317,8],[318,3,318,8],[320,3,320,8],[290,3,290,8],[291,3,291,8],[292,3,292,8],[294,3,294,8],[297,1,297,2],[297,3,297,6],[297,8,297,13],[301,3,301,5],[307,3,307,8],[266,3,266,8],[268,3,268,8],[271,1,271,2],[275,3,275,5],[281,3,281,8],[285,3,285,6],[286,3,286,6],[287,3,287,6],[288,3,288,5],[271,3,271,6],[271,8,271,13],[249,3,249,5],[255,3,255,8],[259,3,259,6],[260,3,260,6],[240,3,240,8],[261,3,261,6],[262,3,262,5],[264,3,264,8],[265,3,265,8],[208,3,208,5],[214,3,214,8],[217,1,217,7],[245,1,245,2],[219,1,219,2],[223,3,223,5],[229,3,229,8],[242,3,242,8],[233,3,233,6],[234,3,234,6],[235,3,235,6],[236,3,236,5],[238,3,238,8],[239,3,239,8],[219,3,219,6],[219,8,219,13],[245,3,245,6],[245,8,245,13],[166,1,166,2],[166,3,166,6],[166,8,166,13],[170,3,170,5],[176,3,176,8],[185,3,185,8],[194,3,194,8],[203,3,203,8],[207,3,207,7],[2,2,2,11],[7,1,7,2],[26,3,26,8],[11,3,11,5],[17,3,17,8],[4,1,4,2],[4,7,4,8],[4,3,4,5],[7,3,7,6],[7,8,7,13],[60,1,60,2],[64,3,64,5],[70,3,70,8],[79,3,79,8],[60,3,60,6],[60,8,60,13],[35,3,35,8],[44,3,44,8],[55,3,55,8],[48,3,48,7],[58,1,58,7],[49,3,49,5],[123,3,123,8],[132,3,132,8],[141,3,141,8],[150,3,150,8],[154,3,154,7],[155,3,155,5],[161,3,161,8],[164,1,164,7],[88,3,88,8],[97,3,97,8],[101,3,101,7],[102,3,102,5],[108,3,108,8],[111,1,111,7],[113,1,113,2],[117,3,117,5],[113,3,113,6],[113,8,113,13]]}
[null,"Employment and Other Income Analysis Worksheet",null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[]
[null,null,"User Tips:\n    • Add borrower information in blue-shaded fields\n    • Click the \"O\" button to expand income source section\n    • Populate YTD Monthly Earnings:\n        -  Select \"A\" for Annualized YTD Monthly Earnings\n        -  Select \"Y\" for YTD Monthly Earnings\n        -  Select the Reset Workbook button on top to clear all information\n\nIncome analysis may vary by investor. FOLLOW INVESTOR GUIDELINES.",null,null,null,null,null,null,null,null,null,"HIDE"]
[]
[null,"File Name:  ",null,null,null,null,"Prepared by:  ",null,null,null,null,"Date:  "]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[]
[null,"Borrower Name:",null,null,null,null,null,"Employer Name:  "]
[null,null,"Base Pay "]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,"Rate of Pay","Pay Frequency   (select from drop down)    ","Hours Worked Weekly","HIDE","HIDE","Monthly Earnings","HIDE"]
[null,null,"O",null,null,null,null,"Hourly (H)",0,{"$f":"VLOOKUP(H12,VLKP_PAY_FREQ,2,FALSE)","v":"H"},{"$f":"IF(J12=\"H\",G12*I12*52,G12*J12)","v":0},{"$f":"IFERROR(ROUND(K12/12,2),0)","v":0}]
[null,null,null,null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:",null,null,"Monthly Earnings:",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F14<>\"\",G14<>\"\"),IF(K14>0,K14,IF(K14<0,0,K14)),0)","v":0},{"$f":"IF(MONTH(F14)=MONTH(G14),((YEAR(G14)-YEAR(F14))*12)-12+(12-MONTH(F14))+MONTH(G14)-1+(EOMONTH(F14,0)-F14+1)/DAY(EOMONTH(F14,0))+(1-(EOMONTH(G14,0)-G14)/DAY(EOMONTH(G14,0))),((YEAR(G14)-YEAR(F14))*12)-12+(12-MONTH(F14))+MONTH(G14)-1+(EOMONTH(F14,0)-F14+1)/DAY(EOMONTH(F14,0))+(1-(EOMONTH(G14,0)-G14)/DAY(EOMONTH(G14,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F14<>\"\",G14<>\"\"),H14/I14,0),2),0)","v":0},{"$f":"IFERROR(IF(((L14-L15)/ABS(L15))>0,\"+\",\"\")&TEXT(ROUND(((L14-L15)/ABS(L15))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M14","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J15,2)","v":12},{"$f":"IF(AND(F15<>\"\",G15<>\"\"),IF(K15>0,K15,IF(K15<0,0,K15)),0)","v":12},{"$f":"IF(MONTH(F15)=MONTH(G15),((YEAR(G15)-YEAR(F15))*12)-12+(12-MONTH(F15))+MONTH(G15)-1+(EOMONTH(F15,0)-F15+1)/DAY(EOMONTH(F15,0))+(1-(EOMONTH(G15,0)-G15)/DAY(EOMONTH(G15,0))),((YEAR(G15)-YEAR(F15))*12)-12+(12-MONTH(F15))+MONTH(G15)-1+(EOMONTH(F15,0)-F15+1)/DAY(EOMONTH(F15,0))+(1-(EOMONTH(G15,0)-G15)/DAY(EOMONTH(G15,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F15<>\"\",G15<>\"\"),H15/I15,0),2),0)","v":0},{"$f":"IFERROR(IF(((L15-L16)/ABS(L16))>0,\"+\",\"\")&TEXT(ROUND(((L15-L16)/ABS(L16))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M15","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J16,2)","v":12},{"$f":"IF(AND(F16<>\"\",G16<>\"\"),IF(K16>0,K16,IF(K16<0,0,K16)),0)","v":12},12,0,"-",{"$f":"M16","v":"-"}]
[]
[null,null,null,"Qualifying Base Pay:",null,null,null,null,null,null,{"$f":"ROUND(IF(C12=\"X\",L12,0)+IFERROR(SUMIF(C14:C16,\"=X\",H14:H16)/SUMIF(C14:C16,\"=X\",I14:I16),0),2)","v":0},{"$f":"K18","v":0}]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Overtime"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ","HIDE","% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F23<>\"\",G23<>\"\"),IF(K23>0,K23,IF(K23<0,0,K23)),0)","v":0},{"$f":"IF(MONTH(F23)=MONTH(G23),((YEAR(G23)-YEAR(F23))*12)-12+(12-MONTH(F23))+MONTH(G23)-1+(EOMONTH(F23,0)-F23+1)/DAY(EOMONTH(F23,0))+(1-(EOMONTH(G23,0)-G23)/DAY(EOMONTH(G23,0))),((YEAR(G23)-YEAR(F23))*12)-12+(12-MONTH(F23))+MONTH(G23)-1+(EOMONTH(F23,0)-F23+1)/DAY(EOMONTH(F23,0))+(1-(EOMONTH(G23,0)-G23)/DAY(EOMONTH(G23,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F23<>\"\",G23<>\"\"),H23/I23,0),2),0)","v":0},{"$f":"IFERROR(IF(((L23-L24)/ABS(L24))>0,\"+\",\"\")&TEXT(ROUND(((L23-L24)/ABS(L24))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M23","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J24,2)","v":12},{"$f":"IF(AND(F24<>\"\",G24<>\"\"),IF(K24>0,K24,IF(K24<0,0,K24)),0)","v":12},{"$f":"IF(MONTH(F24)=MONTH(G24),((YEAR(G24)-YEAR(F24))*12)-12+(12-MONTH(F24))+MONTH(G24)-1+(EOMONTH(F24,0)-F24+1)/DAY(EOMONTH(F24,0))+(1-(EOMONTH(G24,0)-G24)/DAY(EOMONTH(G24,0))),((YEAR(G24)-YEAR(F24))*12)-12+(12-MONTH(F24))+MONTH(G24)-1+(EOMONTH(F24,0)-F24+1)/DAY(EOMONTH(F24,0))+(1-(EOMONTH(G24,0)-G24)/DAY(EOMONTH(G24,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F24<>\"\",G24<>\"\"),H24/I24,0),2),0)","v":0},"-",{"$f":"M24","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J25,2)","v":12},{"$f":"IF(AND(F25<>\"\",G25<>\"\"),IF(K25>0,K25,IF(K25<0,0,K25)),0)","v":12},12,0,"-",{"$f":"M25","v":"-"}]
[]
[null,null,null,"Qualifying Overtime:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C23:C25,\"=X\",H23:H25)/SUMIF(C23:C25,\"=X\",I23:I25),0),2)","v":0},{"$f":"K27","v":0}]
[]
[null,null,"Bonus"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F32<>\"\",G32<>\"\"),IF(K32>0,K32,IF(K32<0,0,K32)),0)","v":0},{"$f":"IF(MONTH(F32)=MONTH(G32),((YEAR(G32)-YEAR(F32))*12)-12+(12-MONTH(F32))+MONTH(G32)-1+(EOMONTH(F32,0)-F32+1)/DAY(EOMONTH(F32,0))+(1-(EOMONTH(G32,0)-G32)/DAY(EOMONTH(G32,0))),((YEAR(G32)-YEAR(F32))*12)-12+(12-MONTH(F32))+MONTH(G32)-1+(EOMONTH(F32,0)-F32+1)/DAY(EOMONTH(F32,0))+(1-(EOMONTH(G32,0)-G32)/DAY(EOMONTH(G32,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F32<>\"\",G32<>\"\"),H32/I32,0),2),0)","v":0},{"$f":"IFERROR(IF(((L32-L33)/ABS(L33))>0,\"+\",\"\")&TEXT(ROUND(((L32-L33)/ABS(L33))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M32","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J33,2)","v":12},{"$f":"IF(AND(F33<>\"\",G33<>\"\"),IF(K33>0,K33,IF(K33<0,0,K33)),0)","v":12},{"$f":"IF(MONTH(F33)=MONTH(G33),((YEAR(G33)-YEAR(F33))*12)-12+(12-MONTH(F33))+MONTH(G33)-1+(EOMONTH(F33,0)-F33+1)/DAY(EOMONTH(F33,0))+(1-(EOMONTH(G33,0)-G33)/DAY(EOMONTH(G33,0))),((YEAR(G33)-YEAR(F33))*12)-12+(12-MONTH(F33))+MONTH(G33)-1+(EOMONTH(F33,0)-F33+1)/DAY(EOMONTH(F33,0))+(1-(EOMONTH(G33,0)-G33)/DAY(EOMONTH(G33,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F33<>\"\",G33<>\"\"),H33/I33,0),2),0)","v":0},"-",{"$f":"M33","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J34,2)","v":12},{"$f":"IF(AND(F34<>\"\",G34<>\"\"),IF(K34>0,K34,IF(K34<0,0,K34)),0)","v":12},12,0,"-",{"$f":"M34","v":"-"}]
[]
[null,null,null,"Qualifying Bonus:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C32:C34,\"=X\",H32:H34)/SUMIF(C32:C34,\"=X\",I32:I34),0),2)","v":0},{"$f":"K36","v":0}]
[]
[null,null,"Commission"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F41<>\"\",G41<>\"\"),IF(K41>0,K41,IF(K41<0,0,K41)),0)","v":0},{"$f":"IF(MONTH(F41)=MONTH(G41),((YEAR(G41)-YEAR(F41))*12)-12+(12-MONTH(F41))+MONTH(G41)-1+(EOMONTH(F41,0)-F41+1)/DAY(EOMONTH(F41,0))+(1-(EOMONTH(G41,0)-G41)/DAY(EOMONTH(G41,0))),((YEAR(G41)-YEAR(F41))*12)-12+(12-MONTH(F41))+MONTH(G41)-1+(EOMONTH(F41,0)-F41+1)/DAY(EOMONTH(F41,0))+(1-(EOMONTH(G41,0)-G41)/DAY(EOMONTH(G41,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F41<>\"\",G41<>\"\"),H41/I41,0),2),0)","v":0},{"$f":"IFERROR(IF(((L41-L42)/ABS(L42))>0,\"+\",\"\")&TEXT(ROUND(((L41-L42)/ABS(L42))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M41","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J42,2)","v":12},{"$f":"IF(AND(F42<>\"\",G42<>\"\"),IF(K42>0,K42,IF(K42<0,0,K42)),0)","v":12},{"$f":"IF(MONTH(F42)=MONTH(G42),((YEAR(G42)-YEAR(F42))*12)-12+(12-MONTH(F42))+MONTH(G42)-1+(EOMONTH(F42,0)-F42+1)/DAY(EOMONTH(F42,0))+(1-(EOMONTH(G42,0)-G42)/DAY(EOMONTH(G42,0))),((YEAR(G42)-YEAR(F42))*12)-12+(12-MONTH(F42))+MONTH(G42)-1+(EOMONTH(F42,0)-F42+1)/DAY(EOMONTH(F42,0))+(1-(EOMONTH(G42,0)-G42)/DAY(EOMONTH(G42,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F42<>\"\",G42<>\"\"),H42/I42,0),2),0)","v":0},"-",{"$f":"M42","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J43,2)","v":12},{"$f":"IF(AND(F43<>\"\",G43<>\"\"),IF(K43>0,K43,IF(K43<0,0,K43)),0)","v":12},12,0,"-",{"$f":"M43","v":"-"}]
[]
[null,null,null,"Qualifying Commission:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C41:C43,\"=X\",H41:H43)/SUMIF(C41:C43,\"=X\",I41:I43),0),2)","v":0},{"$f":"K45","v":0}]
[]
[null,null,"Other Income"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Type:",null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F52<>\"\",G52<>\"\"),IF(K52>0,K52,IF(K52<0,0,K52)),0)","v":0},{"$f":"IF(MONTH(F52)=MONTH(G52),((YEAR(G52)-YEAR(F52))*12)-12+(12-MONTH(F52))+MONTH(G52)-1+(EOMONTH(F52,0)-F52+1)/DAY(EOMONTH(F52,0))+(1-(EOMONTH(G52,0)-G52)/DAY(EOMONTH(G52,0))),((YEAR(G52)-YEAR(F52))*12)-12+(12-MONTH(F52))+MONTH(G52)-1+(EOMONTH(F52,0)-F52+1)/DAY(EOMONTH(F52,0))+(1-(EOMONTH(G52,0)-G52)/DAY(EOMONTH(G52,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F52<>\"\",G52<>\"\"),H52/I52,0),2),0)","v":0},{"$f":"IFERROR(IF(((L52-L53)/ABS(L53))>0,\"+\",\"\")&TEXT(ROUND(((L52-L53)/ABS(L53))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M52","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J53,2)","v":12},{"$f":"IF(AND(F53<>\"\",G53<>\"\"),IF(K53>0,K53,IF(K53<0,0,K53)),0)","v":12},{"$f":"IF(MONTH(F53)=MONTH(G53),((YEAR(G53)-YEAR(F53))*12)-12+(12-MONTH(F53))+MONTH(G53)-1+(EOMONTH(F53,0)-F53+1)/DAY(EOMONTH(F53,0))+(1-(EOMONTH(G53,0)-G53)/DAY(EOMONTH(G53,0))),((YEAR(G53)-YEAR(F53))*12)-12+(12-MONTH(F53))+MONTH(G53)-1+(EOMONTH(F53,0)-F53+1)/DAY(EOMONTH(F53,0))+(1-(EOMONTH(G53,0)-G53)/DAY(EOMONTH(G53,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F53<>\"\",G53<>\"\"),H53/I53,0),2),0)","v":0},"-",{"$f":"M53","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J54,2)","v":12},{"$f":"IF(AND(F54<>\"\",G54<>\"\"),IF(K54>0,K54,IF(K54<0,0,K54)),0)","v":12},12,0,"-",{"$f":"M54","v":"-"}]
[]
[null,null,null,"Qualifying Other Income:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C52:C54,\"=X\",H52:H54)/SUMIF(C52:C54,\"=X\",I52:I54),0),2)","v":0},{"$f":"K56","v":0}]
[]
[]
[null,{"$f":"\"Total Qualifying Income from: \"&D8","v":"Total Qualifying Income from: "},null,null,null,null,null,null,null,null,{"$f":"IFERROR(L18+L27+L36+L45+L56,0)","v":0},{"$f":"K59","v":0}]
[]
[null,"Borrower Name:",null,null,null,null,null,"Employer Name:  "]
[null,null,"Base Pay "]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,"Rate of Pay","Pay Frequency   (select from drop down)    ","Hours Worked Weekly","HIDE","HIDE","Monthly Earnings","HIDE"]
[null,null,"O",null,null,null,null,"Hourly (H)",0,{"$f":"VLOOKUP(H65,VLKP_PAY_FREQ,2,FALSE)","v":"H"},{"$f":"IF(J65=\"H\",G65*I65*52,G65*J65)","v":0},{"$f":"IFERROR(ROUND(K65/12,2),0)","v":0}]
[null,null,null,null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:",null,null,"Monthly Earnings:",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,{"$f":"ROUND(J67,2)","v":0},{"$f":"IF(AND(F67<>\"\",G67<>\"\"),IF(K67>0,K67,IF(K67<0,0,K67)),0)","v":0},{"$f":"IF(MONTH(F67)=MONTH(G67),((YEAR(G67)-YEAR(F67))*12)-12+(12-MONTH(F67))+MONTH(G67)-1+(EOMONTH(F67,0)-F67+1)/DAY(EOMONTH(F67,0))+(1-(EOMONTH(G67,0)-G67)/DAY(EOMONTH(G67,0))),((YEAR(G67)-YEAR(F67))*12)-12+(12-MONTH(F67))+MONTH(G67)-1+(EOMONTH(F67,0)-F67+1)/DAY(EOMONTH(F67,0))+(1-(EOMONTH(G67,0)-G67)/DAY(EOMONTH(G67,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F67<>\"\",G67<>\"\"),H67/I67,0),2),0)","v":0},{"$f":"IFERROR(IF(((L67-L68)/ABS(L68))>0,\"+\",\"\")&TEXT(ROUND(((L67-L68)/ABS(L68))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M67","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J68,2)","v":12},{"$f":"IF(AND(F68<>\"\",G68<>\"\"),IF(K68>0,K68,IF(K68<0,0,K68)),0)","v":12},{"$f":"IF(MONTH(F68)=MONTH(G68),((YEAR(G68)-YEAR(F68))*12)-12+(12-MONTH(F68))+MONTH(G68)-1+(EOMONTH(F68,0)-F68+1)/DAY(EOMONTH(F68,0))+(1-(EOMONTH(G68,0)-G68)/DAY(EOMONTH(G68,0))),((YEAR(G68)-YEAR(F68))*12)-12+(12-MONTH(F68))+MONTH(G68)-1+(EOMONTH(F68,0)-F68+1)/DAY(EOMONTH(F68,0))+(1-(EOMONTH(G68,0)-G68)/DAY(EOMONTH(G68,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F68<>\"\",G68<>\"\"),H68/I68,0),2),0)","v":0},{"$f":"IFERROR(IF(((L68-L69)/ABS(L69))>0,\"+\",\"\")&TEXT(ROUND(((L68-L69)/ABS(L69))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M68","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J69,2)","v":12},{"$f":"IF(AND(F69<>\"\",G69<>\"\"),IF(K69>0,K69,IF(K69<0,0,K69)),0)","v":12},12,0,"-",{"$f":"M69","v":"-"}]
[]
[null,null,null,"Qualifying Base Pay:",null,null,null,null,null,null,{"$f":"ROUND(IF(C65=\"X\",L65,0)+IFERROR(SUMIF(C67:C69,\"=X\",H67:H69)/SUMIF(C67:C69,\"=X\",I67:I69),0),2)","v":0},{"$f":"K71","v":0}]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Overtime"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ","HIDE","% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F76<>\"\",G76<>\"\"),IF(K76>0,K76,IF(K76<0,0,K76)),0)","v":0},{"$f":"IF(MONTH(F76)=MONTH(G76),((YEAR(G76)-YEAR(F76))*12)-12+(12-MONTH(F76))+MONTH(G76)-1+(EOMONTH(F76,0)-F76+1)/DAY(EOMONTH(F76,0))+(1-(EOMONTH(G76,0)-G76)/DAY(EOMONTH(G76,0))),((YEAR(G76)-YEAR(F76))*12)-12+(12-MONTH(F76))+MONTH(G76)-1+(EOMONTH(F76,0)-F76+1)/DAY(EOMONTH(F76,0))+(1-(EOMONTH(G76,0)-G76)/DAY(EOMONTH(G76,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F76<>\"\",G76<>\"\"),H76/I76,0),2),0)","v":0},{"$f":"IFERROR(IF(((L76-L77)/ABS(L77))>0,\"+\",\"\")&TEXT(ROUND(((L76-L77)/ABS(L77))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M76","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J77,2)","v":12},{"$f":"IF(AND(F77<>\"\",G77<>\"\"),IF(K77>0,K77,IF(K77<0,0,K77)),0)","v":12},{"$f":"IF(MONTH(F77)=MONTH(G77),((YEAR(G77)-YEAR(F77))*12)-12+(12-MONTH(F77))+MONTH(G77)-1+(EOMONTH(F77,0)-F77+1)/DAY(EOMONTH(F77,0))+(1-(EOMONTH(G77,0)-G77)/DAY(EOMONTH(G77,0))),((YEAR(G77)-YEAR(F77))*12)-12+(12-MONTH(F77))+MONTH(G77)-1+(EOMONTH(F77,0)-F77+1)/DAY(EOMONTH(F77,0))+(1-(EOMONTH(G77,0)-G77)/DAY(EOMONTH(G77,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F77<>\"\",G77<>\"\"),H77/I77,0),2),0)","v":0},"-",{"$f":"M77","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J78,2)","v":12},{"$f":"IF(AND(F78<>\"\",G78<>\"\"),IF(K78>0,K78,IF(K78<0,0,K78)),0)","v":12},12,0,"-",{"$f":"M78","v":"-"}]
[]
[null,null,null,"Qualifying Overtime:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C76:C78,\"=X\",H76:H78)/SUMIF(C76:C78,\"=X\",I76:I78),0),2)","v":0},{"$f":"K80","v":0}]
[]
[null,null,"Bonus"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F85<>\"\",G85<>\"\"),IF(K85>0,K85,IF(K85<0,0,K85)),0)","v":0},{"$f":"IF(MONTH(F85)=MONTH(G85),((YEAR(G85)-YEAR(F85))*12)-12+(12-MONTH(F85))+MONTH(G85)-1+(EOMONTH(F85,0)-F85+1)/DAY(EOMONTH(F85,0))+(1-(EOMONTH(G85,0)-G85)/DAY(EOMONTH(G85,0))),((YEAR(G85)-YEAR(F85))*12)-12+(12-MONTH(F85))+MONTH(G85)-1+(EOMONTH(F85,0)-F85+1)/DAY(EOMONTH(F85,0))+(1-(EOMONTH(G85,0)-G85)/DAY(EOMONTH(G85,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F85<>\"\",G85<>\"\"),H85/I85,0),2),0)","v":0},{"$f":"IFERROR(IF(((L85-L86)/ABS(L86))>0,\"+\",\"\")&TEXT(ROUND(((L85-L86)/ABS(L86))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M85","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J86,2)","v":12},{"$f":"IF(AND(F86<>\"\",G86<>\"\"),IF(K86>0,K86,IF(K86<0,0,K86)),0)","v":12},{"$f":"IF(MONTH(F86)=MONTH(G86),((YEAR(G86)-YEAR(F86))*12)-12+(12-MONTH(F86))+MONTH(G86)-1+(EOMONTH(F86,0)-F86+1)/DAY(EOMONTH(F86,0))+(1-(EOMONTH(G86,0)-G86)/DAY(EOMONTH(G86,0))),((YEAR(G86)-YEAR(F86))*12)-12+(12-MONTH(F86))+MONTH(G86)-1+(EOMONTH(F86,0)-F86+1)/DAY(EOMONTH(F86,0))+(1-(EOMONTH(G86,0)-G86)/DAY(EOMONTH(G86,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F86<>\"\",G86<>\"\"),H86/I86,0),2),0)","v":0},"-",{"$f":"M86","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J87,2)","v":12},{"$f":"IF(AND(F87<>\"\",G87<>\"\"),IF(K87>0,K87,IF(K87<0,0,K87)),0)","v":12},12,0,"-",{"$f":"M87","v":"-"}]
[]
[null,null,null,"Qualifying Bonus:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C85:C87,\"=X\",H85:H87)/SUMIF(C85:C87,\"=X\",I85:I87),0),2)","v":0},{"$f":"K89","v":0}]
[]
[null,null,"Commission"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F94<>\"\",G94<>\"\"),IF(K94>0,K94,IF(K94<0,0,K94)),0)","v":0},{"$f":"IF(MONTH(F94)=MONTH(G94),((YEAR(G94)-YEAR(F94))*12)-12+(12-MONTH(F94))+MONTH(G94)-1+(EOMONTH(F94,0)-F94+1)/DAY(EOMONTH(F94,0))+(1-(EOMONTH(G94,0)-G94)/DAY(EOMONTH(G94,0))),((YEAR(G94)-YEAR(F94))*12)-12+(12-MONTH(F94))+MONTH(G94)-1+(EOMONTH(F94,0)-F94+1)/DAY(EOMONTH(F94,0))+(1-(EOMONTH(G94,0)-G94)/DAY(EOMONTH(G94,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F94<>\"\",G94<>\"\"),H94/I94,0),2),0)","v":0},{"$f":"IFERROR(IF(((L94-L95)/ABS(L95))>0,\"+\",\"\")&TEXT(ROUND(((L94-L95)/ABS(L95))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M94","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J95,2)","v":12},{"$f":"IF(AND(F95<>\"\",G95<>\"\"),IF(K95>0,K95,IF(K95<0,0,K95)),0)","v":12},{"$f":"IF(MONTH(F95)=MONTH(G95),((YEAR(G95)-YEAR(F95))*12)-12+(12-MONTH(F95))+MONTH(G95)-1+(EOMONTH(F95,0)-F95+1)/DAY(EOMONTH(F95,0))+(1-(EOMONTH(G95,0)-G95)/DAY(EOMONTH(G95,0))),((YEAR(G95)-YEAR(F95))*12)-12+(12-MONTH(F95))+MONTH(G95)-1+(EOMONTH(F95,0)-F95+1)/DAY(EOMONTH(F95,0))+(1-(EOMONTH(G95,0)-G95)/DAY(EOMONTH(G95,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F95<>\"\",G95<>\"\"),H95/I95,0),2),0)","v":0},"-",{"$f":"M95","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J96,2)","v":12},{"$f":"IF(AND(F96<>\"\",G96<>\"\"),IF(K96>0,K96,IF(K96<0,0,K96)),0)","v":12},12,0,"-",{"$f":"M96","v":"-"}]
[]
[null,null,null,"Qualifying Commission:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C94:C96,\"=X\",H94:H96)/SUMIF(C94:C96,\"=X\",I94:I96),0),2)","v":0},{"$f":"K98","v":0}]
[]
[null,null,"Other Income"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Type:",null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F105<>\"\",G105<>\"\"),IF(K105>0,K105,IF(K105<0,0,K105)),0)","v":0},{"$f":"IF(MONTH(F105)=MONTH(G105),((YEAR(G105)-YEAR(F105))*12)-12+(12-MONTH(F105))+MONTH(G105)-1+(EOMONTH(F105,0)-F105+1)/DAY(EOMONTH(F105,0))+(1-(EOMONTH(G105,0)-G105)/DAY(EOMONTH(G105,0))),((YEAR(G105)-YEAR(F105))*12)-12+(12-MONTH(F105))+MONTH(G105)-1+(EOMONTH(F105,0)-F105+1)/DAY(EOMONTH(F105,0))+(1-(EOMONTH(G105,0)-G105)/DAY(EOMONTH(G105,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F105<>\"\",G105<>\"\"),H105/I105,0),2),0)","v":0},{"$f":"IFERROR(IF(((L105-L106)/ABS(L106))>0,\"+\",\"\")&TEXT(ROUND(((L105-L106)/ABS(L106))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M105","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J106,2)","v":12},{"$f":"IF(AND(F106<>\"\",G106<>\"\"),IF(K106>0,K106,IF(K106<0,0,K106)),0)","v":12},{"$f":"IF(MONTH(F106)=MONTH(G106),((YEAR(G106)-YEAR(F106))*12)-12+(12-MONTH(F106))+MONTH(G106)-1+(EOMONTH(F106,0)-F106+1)/DAY(EOMONTH(F106,0))+(1-(EOMONTH(G106,0)-G106)/DAY(EOMONTH(G106,0))),((YEAR(G106)-YEAR(F106))*12)-12+(12-MONTH(F106))+MONTH(G106)-1+(EOMONTH(F106,0)-F106+1)/DAY(EOMONTH(F106,0))+(1-(EOMONTH(G106,0)-G106)/DAY(EOMONTH(G106,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F106<>\"\",G106<>\"\"),H106/I106,0),2),0)","v":0},"-",{"$f":"M106","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J107,2)","v":12},{"$f":"IF(AND(F107<>\"\",G107<>\"\"),IF(K107>0,K107,IF(K107<0,0,K107)),0)","v":12},12,0,"-",{"$f":"M107","v":"-"}]
[]
[null,null,null,"Qualifying Other Income:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C105:C107,\"=X\",H105:H107)/SUMIF(C105:C107,\"=X\",I105:I107),0),2)","v":0},{"$f":"K109","v":0}]
[]
[]
[null,{"$f":"\"Total Qualifying Income from: \"&D61","v":"Total Qualifying Income from: "},null,null,null,null,null,null,null,null,{"$f":"IFERROR(L71+L80+L89+L98+L109,0)","v":0},{"$f":"K112","v":0}]
[]
[null,"Borrower Name:",null,null,null,null,null,"Employer Name:  "]
[null,null,"Base Pay "]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,"Rate of Pay","Pay Frequency   (select from drop down)    ","Hours Worked Weekly","HIDE","HIDE","Monthly Earnings","HIDE"]
[null,null,"O",null,null,null,null,"Hourly (H)",0,{"$f":"VLOOKUP(H118,VLKP_PAY_FREQ,2,FALSE)","v":"H"},{"$f":"IF(J118=\"H\",G118*I118*52,G118*J118)","v":0},{"$f":"IFERROR(ROUND(K118/12,2),0)","v":0}]
[null,null,null,null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:",null,null,"Monthly Earnings:",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,{"$f":"ROUND(J120,2)","v":0},{"$f":"IF(AND(F120<>\"\",G120<>\"\"),IF(K120>0,K120,IF(K120<0,0,K120)),0)","v":0},{"$f":"IF(MONTH(F120)=MONTH(G120),((YEAR(G120)-YEAR(F120))*12)-12+(12-MONTH(F120))+MONTH(G120)-1+(EOMONTH(F120,0)-F120+1)/DAY(EOMONTH(F120,0))+(1-(EOMONTH(G120,0)-G120)/DAY(EOMONTH(G120,0))),((YEAR(G120)-YEAR(F120))*12)-12+(12-MONTH(F120))+MONTH(G120)-1+(EOMONTH(F120,0)-F120+1)/DAY(EOMONTH(F120,0))+(1-(EOMONTH(G120,0)-G120)/DAY(EOMONTH(G120,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F120<>\"\",G120<>\"\"),H120/I120,0),2),0)","v":0},{"$f":"IFERROR(IF(((L120-L121)/ABS(L121))>0,\"+\",\"\")&TEXT(ROUND(((L120-L121)/ABS(L121))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M120","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J121,2)","v":12},{"$f":"IF(AND(F121<>\"\",G121<>\"\"),IF(K121>0,K121,IF(K121<0,0,K121)),0)","v":12},{"$f":"IF(MONTH(F121)=MONTH(G121),((YEAR(G121)-YEAR(F121))*12)-12+(12-MONTH(F121))+MONTH(G121)-1+(EOMONTH(F121,0)-F121+1)/DAY(EOMONTH(F121,0))+(1-(EOMONTH(G121,0)-G121)/DAY(EOMONTH(G121,0))),((YEAR(G121)-YEAR(F121))*12)-12+(12-MONTH(F121))+MONTH(G121)-1+(EOMONTH(F121,0)-F121+1)/DAY(EOMONTH(F121,0))+(1-(EOMONTH(G121,0)-G121)/DAY(EOMONTH(G121,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F121<>\"\",G121<>\"\"),H121/I121,0),2),0)","v":0},{"$f":"IFERROR(IF(((L121-L122)/ABS(L122))>0,\"+\",\"\")&TEXT(ROUND(((L121-L122)/ABS(L122))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M121","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J122,2)","v":12},{"$f":"IF(AND(F122<>\"\",G122<>\"\"),IF(K122>0,K122,IF(K122<0,0,K122)),0)","v":12},12,0,"-",{"$f":"M122","v":"-"}]
[]
[null,null,null,"Qualifying Base Pay:",null,null,null,null,null,null,{"$f":"ROUND(IF(C118=\"X\",L118,0)+IFERROR(SUMIF(C120:C122,\"=X\",H120:H122)/SUMIF(C120:C122,\"=X\",I120:I122),0),2)","v":0},{"$f":"K124","v":0}]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Overtime"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ","HIDE","% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F129<>\"\",G129<>\"\"),IF(K129>0,K129,IF(K129<0,0,K129)),0)","v":0},{"$f":"IF(MONTH(F129)=MONTH(G129),((YEAR(G129)-YEAR(F129))*12)-12+(12-MONTH(F129))+MONTH(G129)-1+(EOMONTH(F129,0)-F129+1)/DAY(EOMONTH(F129,0))+(1-(EOMONTH(G129,0)-G129)/DAY(EOMONTH(G129,0))),((YEAR(G129)-YEAR(F129))*12)-12+(12-MONTH(F129))+MONTH(G129)-1+(EOMONTH(F129,0)-F129+1)/DAY(EOMONTH(F129,0))+(1-(EOMONTH(G129,0)-G129)/DAY(EOMONTH(G129,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F129<>\"\",G129<>\"\"),H129/I129,0),2),0)","v":0},{"$f":"IFERROR(IF(((L129-L130)/ABS(L130))>0,\"+\",\"\")&TEXT(ROUND(((L129-L130)/ABS(L130))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M129","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J130,2)","v":12},{"$f":"IF(AND(F130<>\"\",G130<>\"\"),IF(K130>0,K130,IF(K130<0,0,K130)),0)","v":12},{"$f":"IF(MONTH(F130)=MONTH(G130),((YEAR(G130)-YEAR(F130))*12)-12+(12-MONTH(F130))+MONTH(G130)-1+(EOMONTH(F130,0)-F130+1)/DAY(EOMONTH(F130,0))+(1-(EOMONTH(G130,0)-G130)/DAY(EOMONTH(G130,0))),((YEAR(G130)-YEAR(F130))*12)-12+(12-MONTH(F130))+MONTH(G130)-1+(EOMONTH(F130,0)-F130+1)/DAY(EOMONTH(F130,0))+(1-(EOMONTH(G130,0)-G130)/DAY(EOMONTH(G130,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F130<>\"\",G130<>\"\"),H130/I130,0),2),0)","v":0},"-",{"$f":"M130","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J131,2)","v":12},{"$f":"IF(AND(F131<>\"\",G131<>\"\"),IF(K131>0,K131,IF(K131<0,0,K131)),0)","v":12},12,0,"-",{"$f":"M131","v":"-"}]
[]
[null,null,null,"Qualifying Overtime:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C129:C131,\"=X\",H129:H131)/SUMIF(C129:C131,\"=X\",I129:I131),0),2)","v":0},{"$f":"K133","v":0}]
[]
[null,null,"Bonus"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F138<>\"\",G138<>\"\"),IF(K138>0,K138,IF(K138<0,0,K138)),0)","v":0},{"$f":"IF(MONTH(F138)=MONTH(G138),((YEAR(G138)-YEAR(F138))*12)-12+(12-MONTH(F138))+MONTH(G138)-1+(EOMONTH(F138,0)-F138+1)/DAY(EOMONTH(F138,0))+(1-(EOMONTH(G138,0)-G138)/DAY(EOMONTH(G138,0))),((YEAR(G138)-YEAR(F138))*12)-12+(12-MONTH(F138))+MONTH(G138)-1+(EOMONTH(F138,0)-F138+1)/DAY(EOMONTH(F138,0))+(1-(EOMONTH(G138,0)-G138)/DAY(EOMONTH(G138,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F138<>\"\",G138<>\"\"),H138/I138,0),2),0)","v":0},{"$f":"IFERROR(IF(((L138-L139)/ABS(L139))>0,\"+\",\"\")&TEXT(ROUND(((L138-L139)/ABS(L139))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M138","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J139,2)","v":12},{"$f":"IF(AND(F139<>\"\",G139<>\"\"),IF(K139>0,K139,IF(K139<0,0,K139)),0)","v":12},{"$f":"IF(MONTH(F139)=MONTH(G139),((YEAR(G139)-YEAR(F139))*12)-12+(12-MONTH(F139))+MONTH(G139)-1+(EOMONTH(F139,0)-F139+1)/DAY(EOMONTH(F139,0))+(1-(EOMONTH(G139,0)-G139)/DAY(EOMONTH(G139,0))),((YEAR(G139)-YEAR(F139))*12)-12+(12-MONTH(F139))+MONTH(G139)-1+(EOMONTH(F139,0)-F139+1)/DAY(EOMONTH(F139,0))+(1-(EOMONTH(G139,0)-G139)/DAY(EOMONTH(G139,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F139<>\"\",G139<>\"\"),H139/I139,0),2),0)","v":0},"-",{"$f":"M139","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J140,2)","v":12},{"$f":"IF(AND(F140<>\"\",G140<>\"\"),IF(K140>0,K140,IF(K140<0,0,K140)),0)","v":12},12,0,"-",{"$f":"M140","v":"-"}]
[]
[null,null,null,"Qualifying Bonus:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C138:C140,\"=X\",H138:H140)/SUMIF(C138:C140,\"=X\",I138:I140),0),2)","v":0},{"$f":"K142","v":0}]
[]
[null,null,"Commission"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F147<>\"\",G147<>\"\"),IF(K147>0,K147,IF(K147<0,0,K147)),0)","v":0},{"$f":"IF(MONTH(F147)=MONTH(G147),((YEAR(G147)-YEAR(F147))*12)-12+(12-MONTH(F147))+MONTH(G147)-1+(EOMONTH(F147,0)-F147+1)/DAY(EOMONTH(F147,0))+(1-(EOMONTH(G147,0)-G147)/DAY(EOMONTH(G147,0))),((YEAR(G147)-YEAR(F147))*12)-12+(12-MONTH(F147))+MONTH(G147)-1+(EOMONTH(F147,0)-F147+1)/DAY(EOMONTH(F147,0))+(1-(EOMONTH(G147,0)-G147)/DAY(EOMONTH(G147,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F147<>\"\",G147<>\"\"),H147/I147,0),2),0)","v":0},{"$f":"IFERROR(IF(((L147-L148)/ABS(L148))>0,\"+\",\"\")&TEXT(ROUND(((L147-L148)/ABS(L148))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M147","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J148,2)","v":12},{"$f":"IF(AND(F148<>\"\",G148<>\"\"),IF(K148>0,K148,IF(K148<0,0,K148)),0)","v":12},{"$f":"IF(MONTH(F148)=MONTH(G148),((YEAR(G148)-YEAR(F148))*12)-12+(12-MONTH(F148))+MONTH(G148)-1+(EOMONTH(F148,0)-F148+1)/DAY(EOMONTH(F148,0))+(1-(EOMONTH(G148,0)-G148)/DAY(EOMONTH(G148,0))),((YEAR(G148)-YEAR(F148))*12)-12+(12-MONTH(F148))+MONTH(G148)-1+(EOMONTH(F148,0)-F148+1)/DAY(EOMONTH(F148,0))+(1-(EOMONTH(G148,0)-G148)/DAY(EOMONTH(G148,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F148<>\"\",G148<>\"\"),H148/I148,0),2),0)","v":0},"-",{"$f":"M148","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J149,2)","v":12},{"$f":"IF(AND(F149<>\"\",G149<>\"\"),IF(K149>0,K149,IF(K149<0,0,K149)),0)","v":12},12,0,"-",{"$f":"M149","v":"-"}]
[]
[null,null,null,"Qualifying Commission:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C147:C149,\"=X\",H147:H149)/SUMIF(C147:C149,\"=X\",I147:I149),0),2)","v":0},{"$f":"K151","v":0}]
[]
[null,null,"Other Income"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Type:",null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F158<>\"\",G158<>\"\"),IF(K158>0,K158,IF(K158<0,0,K158)),0)","v":0},{"$f":"IF(MONTH(F158)=MONTH(G158),((YEAR(G158)-YEAR(F158))*12)-12+(12-MONTH(F158))+MONTH(G158)-1+(EOMONTH(F158,0)-F158+1)/DAY(EOMONTH(F158,0))+(1-(EOMONTH(G158,0)-G158)/DAY(EOMONTH(G158,0))),((YEAR(G158)-YEAR(F158))*12)-12+(12-MONTH(F158))+MONTH(G158)-1+(EOMONTH(F158,0)-F158+1)/DAY(EOMONTH(F158,0))+(1-(EOMONTH(G158,0)-G158)/DAY(EOMONTH(G158,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F158<>\"\",G158<>\"\"),H158/I158,0),2),0)","v":0},{"$f":"IFERROR(IF(((L158-L159)/ABS(L159))>0,\"+\",\"\")&TEXT(ROUND(((L158-L159)/ABS(L159))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M158","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J159,2)","v":12},{"$f":"IF(AND(F159<>\"\",G159<>\"\"),IF(K159>0,K159,IF(K159<0,0,K159)),0)","v":12},{"$f":"IF(MONTH(F159)=MONTH(G159),((YEAR(G159)-YEAR(F159))*12)-12+(12-MONTH(F159))+MONTH(G159)-1+(EOMONTH(F159,0)-F159+1)/DAY(EOMONTH(F159,0))+(1-(EOMONTH(G159,0)-G159)/DAY(EOMONTH(G159,0))),((YEAR(G159)-YEAR(F159))*12)-12+(12-MONTH(F159))+MONTH(G159)-1+(EOMONTH(F159,0)-F159+1)/DAY(EOMONTH(F159,0))+(1-(EOMONTH(G159,0)-G159)/DAY(EOMONTH(G159,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F159<>\"\",G159<>\"\"),H159/I159,0),2),0)","v":0},"-",{"$f":"M159","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J160,2)","v":12},{"$f":"IF(AND(F160<>\"\",G160<>\"\"),IF(K160>0,K160,IF(K160<0,0,K160)),0)","v":12},12,0,"-",{"$f":"M160","v":"-"}]
[]
[null,null,null,"Qualifying Other Income:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C158:C160,\"=X\",H158:H160)/SUMIF(C158:C160,\"=X\",I158:I160),0),2)","v":0},{"$f":"K162","v":0}]
[]
[]
[null,{"$f":"\"Total Qualifying Income from: \"&D114","v":"Total Qualifying Income from: "},null,null,null,null,null,null,null,null,{"$f":"IFERROR(L124+L133+L142+L151+L162,0)","v":0},{"$f":"K165","v":0}]
[]
[null,"Borrower Name:",null,null,null,null,null,"Employer Name:  "]
[null,null,"Base Pay "]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,"Rate of Pay","Pay Frequency   (select from drop down)    ","Hours Worked Weekly","HIDE","HIDE","Monthly Earnings","HIDE"]
[null,null,"O",null,null,null,null,"Hourly (H)",0,{"$f":"VLOOKUP(H171,VLKP_PAY_FREQ,2,FALSE)","v":"H"},{"$f":"IF(J171=\"H\",G171*I171*52,G171*J171)","v":0},{"$f":"IFERROR(ROUND(K171/12,2),0)","v":0}]
[null,null,null,null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:",null,null,"Monthly Earnings:",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,{"$f":"ROUND(J173,2)","v":0},{"$f":"IF(AND(F173<>\"\",G173<>\"\"),IF(K173>0,K173,IF(K173<0,0,K173)),0)","v":0},{"$f":"IF(MONTH(F173)=MONTH(G173),((YEAR(G173)-YEAR(F173))*12)-12+(12-MONTH(F173))+MONTH(G173)-1+(EOMONTH(F173,0)-F173+1)/DAY(EOMONTH(F173,0))+(1-(EOMONTH(G173,0)-G173)/DAY(EOMONTH(G173,0))),((YEAR(G173)-YEAR(F173))*12)-12+(12-MONTH(F173))+MONTH(G173)-1+(EOMONTH(F173,0)-F173+1)/DAY(EOMONTH(F173,0))+(1-(EOMONTH(G173,0)-G173)/DAY(EOMONTH(G173,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F173<>\"\",G173<>\"\"),H173/I173,0),2),0)","v":0},{"$f":"IFERROR(IF(((L173-L174)/ABS(L174))>0,\"+\",\"\")&TEXT(ROUND(((L173-L174)/ABS(L174))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M173","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J174,2)","v":12},{"$f":"IF(AND(F174<>\"\",G174<>\"\"),IF(K174>0,K174,IF(K174<0,0,K174)),0)","v":12},{"$f":"IF(MONTH(F174)=MONTH(G174),((YEAR(G174)-YEAR(F174))*12)-12+(12-MONTH(F174))+MONTH(G174)-1+(EOMONTH(F174,0)-F174+1)/DAY(EOMONTH(F174,0))+(1-(EOMONTH(G174,0)-G174)/DAY(EOMONTH(G174,0))),((YEAR(G174)-YEAR(F174))*12)-12+(12-MONTH(F174))+MONTH(G174)-1+(EOMONTH(F174,0)-F174+1)/DAY(EOMONTH(F174,0))+(1-(EOMONTH(G174,0)-G174)/DAY(EOMONTH(G174,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F174<>\"\",G174<>\"\"),H174/I174,0),2),0)","v":0},{"$f":"IFERROR(IF(((L174-L175)/ABS(L175))>0,\"+\",\"\")&TEXT(ROUND(((L174-L175)/ABS(L175))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M174","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J175,2)","v":12},{"$f":"IF(AND(F175<>\"\",G175<>\"\"),IF(K175>0,K175,IF(K175<0,0,K175)),0)","v":12},12,0,"-",{"$f":"M175","v":"-"}]
[]
[null,null,null,"Qualifying Base Pay:",null,null,null,null,null,null,{"$f":"ROUND(IF(C171=\"X\",L171,0)+IFERROR(SUMIF(C173:C175,\"=X\",H173:H175)/SUMIF(C173:C175,\"=X\",I173:I175),0),2)","v":0},{"$f":"K177","v":0}]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Overtime"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ","HIDE","% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F182<>\"\",G182<>\"\"),IF(K182>0,K182,IF(K182<0,0,K182)),0)","v":0},{"$f":"IF(MONTH(F182)=MONTH(G182),((YEAR(G182)-YEAR(F182))*12)-12+(12-MONTH(F182))+MONTH(G182)-1+(EOMONTH(F182,0)-F182+1)/DAY(EOMONTH(F182,0))+(1-(EOMONTH(G182,0)-G182)/DAY(EOMONTH(G182,0))),((YEAR(G182)-YEAR(F182))*12)-12+(12-MONTH(F182))+MONTH(G182)-1+(EOMONTH(F182,0)-F182+1)/DAY(EOMONTH(F182,0))+(1-(EOMONTH(G182,0)-G182)/DAY(EOMONTH(G182,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F182<>\"\",G182<>\"\"),H182/I182,0),2),0)","v":0},{"$f":"IFERROR(IF(((L182-L183)/ABS(L183))>0,\"+\",\"\")&TEXT(ROUND(((L182-L183)/ABS(L183))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M182","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J183,2)","v":12},{"$f":"IF(AND(F183<>\"\",G183<>\"\"),IF(K183>0,K183,IF(K183<0,0,K183)),0)","v":12},{"$f":"IF(MONTH(F183)=MONTH(G183),((YEAR(G183)-YEAR(F183))*12)-12+(12-MONTH(F183))+MONTH(G183)-1+(EOMONTH(F183,0)-F183+1)/DAY(EOMONTH(F183,0))+(1-(EOMONTH(G183,0)-G183)/DAY(EOMONTH(G183,0))),((YEAR(G183)-YEAR(F183))*12)-12+(12-MONTH(F183))+MONTH(G183)-1+(EOMONTH(F183,0)-F183+1)/DAY(EOMONTH(F183,0))+(1-(EOMONTH(G183,0)-G183)/DAY(EOMONTH(G183,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F183<>\"\",G183<>\"\"),H183/I183,0),2),0)","v":0},"-",{"$f":"M183","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J184,2)","v":12},{"$f":"IF(AND(F184<>\"\",G184<>\"\"),IF(K184>0,K184,IF(K184<0,0,K184)),0)","v":12},12,0,"-",{"$f":"M184","v":"-"}]
[]
[null,null,null,"Qualifying Overtime:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C182:C184,\"=X\",H182:H184)/SUMIF(C182:C184,\"=X\",I182:I184),0),2)","v":0},{"$f":"K186","v":0}]
[]
[null,null,"Bonus"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F191<>\"\",G191<>\"\"),IF(K191>0,K191,IF(K191<0,0,K191)),0)","v":0},{"$f":"IF(MONTH(F191)=MONTH(G191),((YEAR(G191)-YEAR(F191))*12)-12+(12-MONTH(F191))+MONTH(G191)-1+(EOMONTH(F191,0)-F191+1)/DAY(EOMONTH(F191,0))+(1-(EOMONTH(G191,0)-G191)/DAY(EOMONTH(G191,0))),((YEAR(G191)-YEAR(F191))*12)-12+(12-MONTH(F191))+MONTH(G191)-1+(EOMONTH(F191,0)-F191+1)/DAY(EOMONTH(F191,0))+(1-(EOMONTH(G191,0)-G191)/DAY(EOMONTH(G191,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F191<>\"\",G191<>\"\"),H191/I191,0),2),0)","v":0},{"$f":"IFERROR(IF(((L191-L192)/ABS(L192))>0,\"+\",\"\")&TEXT(ROUND(((L191-L192)/ABS(L192))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M191","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J192,2)","v":12},{"$f":"IF(AND(F192<>\"\",G192<>\"\"),IF(K192>0,K192,IF(K192<0,0,K192)),0)","v":12},{"$f":"IF(MONTH(F192)=MONTH(G192),((YEAR(G192)-YEAR(F192))*12)-12+(12-MONTH(F192))+MONTH(G192)-1+(EOMONTH(F192,0)-F192+1)/DAY(EOMONTH(F192,0))+(1-(EOMONTH(G192,0)-G192)/DAY(EOMONTH(G192,0))),((YEAR(G192)-YEAR(F192))*12)-12+(12-MONTH(F192))+MONTH(G192)-1+(EOMONTH(F192,0)-F192+1)/DAY(EOMONTH(F192,0))+(1-(EOMONTH(G192,0)-G192)/DAY(EOMONTH(G192,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F192<>\"\",G192<>\"\"),H192/I192,0),2),0)","v":0},"-",{"$f":"M192","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J193,2)","v":12},{"$f":"IF(AND(F193<>\"\",G193<>\"\"),IF(K193>0,K193,IF(K193<0,0,K193)),0)","v":12},12,0,"-",{"$f":"M193","v":"-"}]
[]
[null,null,null,"Qualifying Bonus:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C191:C193,\"=X\",H191:H193)/SUMIF(C191:C193,\"=X\",I191:I193),0),2)","v":0},{"$f":"K195","v":0}]
[]
[null,null,"Commission"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F200<>\"\",G200<>\"\"),IF(K200>0,K200,IF(K200<0,0,K200)),0)","v":0},{"$f":"IF(MONTH(F200)=MONTH(G200),((YEAR(G200)-YEAR(F200))*12)-12+(12-MONTH(F200))+MONTH(G200)-1+(EOMONTH(F200,0)-F200+1)/DAY(EOMONTH(F200,0))+(1-(EOMONTH(G200,0)-G200)/DAY(EOMONTH(G200,0))),((YEAR(G200)-YEAR(F200))*12)-12+(12-MONTH(F200))+MONTH(G200)-1+(EOMONTH(F200,0)-F200+1)/DAY(EOMONTH(F200,0))+(1-(EOMONTH(G200,0)-G200)/DAY(EOMONTH(G200,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F200<>\"\",G200<>\"\"),H200/I200,0),2),0)","v":0},{"$f":"IFERROR(IF(((L200-L201)/ABS(L201))>0,\"+\",\"\")&TEXT(ROUND(((L200-L201)/ABS(L201))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M200","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J201,2)","v":12},{"$f":"IF(AND(F201<>\"\",G201<>\"\"),IF(K201>0,K201,IF(K201<0,0,K201)),0)","v":12},{"$f":"IF(MONTH(F201)=MONTH(G201),((YEAR(G201)-YEAR(F201))*12)-12+(12-MONTH(F201))+MONTH(G201)-1+(EOMONTH(F201,0)-F201+1)/DAY(EOMONTH(F201,0))+(1-(EOMONTH(G201,0)-G201)/DAY(EOMONTH(G201,0))),((YEAR(G201)-YEAR(F201))*12)-12+(12-MONTH(F201))+MONTH(G201)-1+(EOMONTH(F201,0)-F201+1)/DAY(EOMONTH(F201,0))+(1-(EOMONTH(G201,0)-G201)/DAY(EOMONTH(G201,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F201<>\"\",G201<>\"\"),H201/I201,0),2),0)","v":0},"-",{"$f":"M201","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J202,2)","v":12},{"$f":"IF(AND(F202<>\"\",G202<>\"\"),IF(K202>0,K202,IF(K202<0,0,K202)),0)","v":12},12,0,"-",{"$f":"M202","v":"-"}]
[]
[null,null,null,"Qualifying Commission:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C200:C202,\"=X\",H200:H202)/SUMIF(C200:C202,\"=X\",I200:I202),0),2)","v":0},{"$f":"K204","v":0}]
[]
[null,null,"Other Income"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Type:",null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:","HIDE","HIDE","Monthly Earnings: ",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F211<>\"\",G211<>\"\"),IF(K211>0,K211,IF(K211<0,0,K211)),0)","v":0},{"$f":"IF(MONTH(F211)=MONTH(G211),((YEAR(G211)-YEAR(F211))*12)-12+(12-MONTH(F211))+MONTH(G211)-1+(EOMONTH(F211,0)-F211+1)/DAY(EOMONTH(F211,0))+(1-(EOMONTH(G211,0)-G211)/DAY(EOMONTH(G211,0))),((YEAR(G211)-YEAR(F211))*12)-12+(12-MONTH(F211))+MONTH(G211)-1+(EOMONTH(F211,0)-F211+1)/DAY(EOMONTH(F211,0))+(1-(EOMONTH(G211,0)-G211)/DAY(EOMONTH(G211,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F211<>\"\",G211<>\"\"),H211/I211,0),2),0)","v":0},{"$f":"IFERROR(IF(((L211-L212)/ABS(L212))>0,\"+\",\"\")&TEXT(ROUND(((L211-L212)/ABS(L212))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M211","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J212,2)","v":12},{"$f":"IF(AND(F212<>\"\",G212<>\"\"),IF(K212>0,K212,IF(K212<0,0,K212)),0)","v":12},{"$f":"IF(MONTH(F212)=MONTH(G212),((YEAR(G212)-YEAR(F212))*12)-12+(12-MONTH(F212))+MONTH(G212)-1+(EOMONTH(F212,0)-F212+1)/DAY(EOMONTH(F212,0))+(1-(EOMONTH(G212,0)-G212)/DAY(EOMONTH(G212,0))),((YEAR(G212)-YEAR(F212))*12)-12+(12-MONTH(F212))+MONTH(G212)-1+(EOMONTH(F212,0)-F212+1)/DAY(EOMONTH(F212,0))+(1-(EOMONTH(G212,0)-G212)/DAY(EOMONTH(G212,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F212<>\"\",G212<>\"\"),H212/I212,0),2),0)","v":0},"-",{"$f":"M212","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J213,2)","v":12},{"$f":"IF(AND(F213<>\"\",G213<>\"\"),IF(K213>0,K213,IF(K213<0,0,K213)),0)","v":12},12,0,"-",{"$f":"M213","v":"-"}]
[]
[null,null,null,"Qualifying Other Income:",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(SUMIF(C211:C213,\"=X\",H211:H213)/SUMIF(C211:C213,\"=X\",I211:I213),0),2)","v":0},{"$f":"K215","v":0}]
[]
[]
[null,{"$f":"\"Total Qualifying Income from: \"&D167","v":"Total Qualifying Income from: "},null,null,null,null,null,null,null,null,{"$f":"IFERROR(L177+L186+L195+L204+L215,0)","v":0},{"$f":"K218","v":0}]
[]
[null,"Borrower Name:",null,null,null,null,null,"Other Income Src: "]
[null,null,"Is the Source Taxable?"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,null,null,null,null,null,null,"HIDE"]
[null,null,"O","       Monthly amount:"]
[null,null,null,null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:",null,null,"Monthly Earnings:",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F226<>\"\",G226<>\"\"),IF(K226>0,K226,IF(K226<0,0,K226)),0)","v":0},{"$f":"IF(MONTH(F226)=MONTH(G226),((YEAR(G226)-YEAR(F226))*12)-12+(12-MONTH(F226))+MONTH(G226)-1+(EOMONTH(F226,0)-F226+1)/DAY(EOMONTH(F226,0))+(1-(EOMONTH(G226,0)-G226)/DAY(EOMONTH(G226,0))),((YEAR(G226)-YEAR(F226))*12)-12+(12-MONTH(F226))+MONTH(G226)-1+(EOMONTH(F226,0)-F226+1)/DAY(EOMONTH(F226,0))+(1-(EOMONTH(G226,0)-G226)/DAY(EOMONTH(G226,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F226<>\"\",G226<>\"\"),H226/I226,0),2),0)","v":0},{"$f":"IFERROR(IF(((L226-L227)/ABS(L227))>0,\"+\",\"\")&TEXT(ROUND(((L226-L227)/ABS(L227))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M226","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J227,2)","v":12},{"$f":"IF(AND(F227<>\"\",G227<>\"\"),IF(K227>0,K227,IF(K227<0,0,K227)),0)","v":12},{"$f":"IF(MONTH(F227)=MONTH(G227),((YEAR(G227)-YEAR(F227))*12)-12+(12-MONTH(F227))+MONTH(G227)-1+(EOMONTH(F227,0)-F227+1)/DAY(EOMONTH(F227,0))+(1-(EOMONTH(G227,0)-G227)/DAY(EOMONTH(G227,0))),((YEAR(G227)-YEAR(F227))*12)-12+(12-MONTH(F227))+MONTH(G227)-1+(EOMONTH(F227,0)-F227+1)/DAY(EOMONTH(F227,0))+(1-(EOMONTH(G227,0)-G227)/DAY(EOMONTH(G227,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F227<>\"\",G227<>\"\"),H227/I227,0),2),0)","v":0},"-",{"$f":"M227","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J228,2)","v":12},{"$f":"IF(AND(F228<>\"\",G228<>\"\"),IF(K228>0,K228,IF(K228<0,0,K228)),0)","v":12},12,0,"-",{"$f":"M228","v":"-"}]
[]
[null,null,null,{"$f":"\"Qualifying Income from: \"&D220","v":"Qualifying Income from: "},null,null,null,null,null,null,{"$f":"IF(C224=\"X\",L224,0)+IFERROR(SUMIF(C226:C228,\"=X\",H226:H228)/SUMIF(C226:C228,\"=X\",I226:I228),0)","v":0},{"$f":"K230","v":0}]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Is the Source Non-Taxable?"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,null,"Annual Amount",null,"HIDE","HIDE","Monthly Amount","HIDE"]
[null,null,"O","Gross amount reported on personal tax return or Form 1099",null,null,null,null,"Gross amount = 100%",{"$f":"ROUND(H235/12,2)","v":0},null,{"$f":"J235","v":0},"HIDE"]
[null,null,"O","Taxable amount reported on personal tax return",null,null,null,null,{"$f":"\"Taxable portion = \"&TEXT((K236*100),\"0.00\")&\"%\"","v":"Taxable portion = 0.00%"},{"$f":"ROUND(H236/12,2)","v":0},{"$f":"IFERROR(ROUND(H236/H235,4),0)","v":0},{"$f":"J236","v":0},"HIDE"]
[null,null,"O","Amount eligible for gross-up",null,null,0.25,{"$f":"ROUND(IF(AND(H235=0,H236=0),0,H235-H236),2)","v":0},{"$f":"\"Non-taxable portion = \"&TEXT((K237*100),\"0.00\")&\"%\"","v":"Non-taxable portion = 0.00%"},{"$f":"ROUND((H237*(1+G237))/12,2)","v":0},{"$f":"ROUND(IF(AND(H235=0,H236=0),0,1-K236),4)","v":0},{"$f":"J237","v":0},"HIDE"]
[]
[null,null,"O","Current MONTHLY amount  (to gross-up; enter personal tax return information above)",null,null,null,null,null,null,null,null,"HIDE"]
[null,null,"O","Taxable amount  (based on entry above)",null,null,null,null,null,null,{"$f":"ROUND(L239*K236,2)","v":0},{"$f":"K240","v":0},"HIDE"]
[null,null,"O","Amount eligible for gross-up  (based on entry above)",null,null,null,null,null,null,{"$f":"ROUND(IF(AND(H235=0,H236=0),0,(L239-L240)*(1+G237)),2)","v":0},{"$f":"K241","v":0},"HIDE"]
[]
[null,null,null,{"$f":"\"Qualifying Income from: \"&D220","v":"Qualifying Income from: "},null,null,null,null,null,null,{"$f":"IFERROR(SUMIF(C235:C241,\"=X\",L235:L241),0)","v":0},{"$f":"K243","v":0}]
[]
[]
[null,"Borrower Name:",null,null,null,null,null,"Other Income Src: "]
[null,null,"Is the Source Taxable?"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,null,null,null,null,null,null,"HIDE"]
[null,null,"O","       Monthly amount:"]
[null,null,null,null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:",null,null,"Monthly Earnings:",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F252<>\"\",G252<>\"\"),IF(K252>0,K252,IF(K252<0,0,K252)),0)","v":0},{"$f":"IF(MONTH(F252)=MONTH(G252),((YEAR(G252)-YEAR(F252))*12)-12+(12-MONTH(F252))+MONTH(G252)-1+(EOMONTH(F252,0)-F252+1)/DAY(EOMONTH(F252,0))+(1-(EOMONTH(G252,0)-G252)/DAY(EOMONTH(G252,0))),((YEAR(G252)-YEAR(F252))*12)-12+(12-MONTH(F252))+MONTH(G252)-1+(EOMONTH(F252,0)-F252+1)/DAY(EOMONTH(F252,0))+(1-(EOMONTH(G252,0)-G252)/DAY(EOMONTH(G252,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F252<>\"\",G252<>\"\"),H252/I252,0),2),0)","v":0},{"$f":"IFERROR(IF(((L252-L253)/ABS(L253))>0,\"+\",\"\")&TEXT(ROUND(((L252-L253)/ABS(L253))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M252","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J253,2)","v":12},{"$f":"IF(AND(F253<>\"\",G253<>\"\"),IF(K253>0,K253,IF(K253<0,0,K253)),0)","v":12},{"$f":"IF(MONTH(F253)=MONTH(G253),((YEAR(G253)-YEAR(F253))*12)-12+(12-MONTH(F253))+MONTH(G253)-1+(EOMONTH(F253,0)-F253+1)/DAY(EOMONTH(F253,0))+(1-(EOMONTH(G253,0)-G253)/DAY(EOMONTH(G253,0))),((YEAR(G253)-YEAR(F253))*12)-12+(12-MONTH(F253))+MONTH(G253)-1+(EOMONTH(F253,0)-F253+1)/DAY(EOMONTH(F253,0))+(1-(EOMONTH(G253,0)-G253)/DAY(EOMONTH(G253,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F253<>\"\",G253<>\"\"),H253/I253,0),2),0)","v":0},"-",{"$f":"M253","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J254,2)","v":12},{"$f":"IF(AND(F254<>\"\",G254<>\"\"),IF(K254>0,K254,IF(K254<0,0,K254)),0)","v":12},12,0,"-",{"$f":"M254","v":"-"}]
[]
[null,null,null,{"$f":"\"Qualifying Income from: \"&D246","v":"Qualifying Income from: "},null,null,null,null,null,null,{"$f":"IF(C250=\"X\",L250,0)+IFERROR(SUMIF(C252:C254,\"=X\",H252:H254)/SUMIF(C252:C254,\"=X\",I252:I254),0)","v":0},{"$f":"K256","v":0}]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Is the Source Non-Taxable?"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,null,"Annual Amount",null,"HIDE","HIDE","Monthly Amount","HIDE"]
[null,null,"O","Gross amount reported on personal tax return or Form 1099",null,null,null,null,"Gross amount = 100%",{"$f":"ROUND(H261/12,2)","v":0},null,{"$f":"J261","v":0},"HIDE"]
[null,null,"O","Taxable amount reported on personal tax return",null,null,null,null,{"$f":"\"Taxable portion = \"&TEXT((K262*100),\"0.00\")&\"%\"","v":"Taxable portion = 0.00%"},{"$f":"ROUND(H262/12,2)","v":0},{"$f":"IFERROR(ROUND(H262/H261,4),0)","v":0},{"$f":"J262","v":0},"HIDE"]
[null,null,"O","Amount eligible for gross-up",null,null,0.25,{"$f":"ROUND(IF(AND(H261=0,H262=0),0,H261-H262),2)","v":0},{"$f":"\"Non-taxable portion = \"&TEXT((K263*100),\"0.00\")&\"%\"","v":"Non-taxable portion = 0.00%"},{"$f":"ROUND((H263*(1+G263))/12,2)","v":0},{"$f":"ROUND(IF(AND(H261=0,H262=0),0,1-K262),4)","v":0},{"$f":"J263","v":0},"HIDE"]
[]
[null,null,"O","Current MONTHLY amount  (to gross-up; enter personal tax return information above)",null,null,null,null,null,null,null,null,"HIDE"]
[null,null,"O","Taxable amount  (based on entry above)",null,null,null,null,null,null,{"$f":"ROUND(L265*K262,2)","v":0},{"$f":"K266","v":0},"HIDE"]
[null,null,"O","Amount eligible for gross-up  (based on entry above)",null,null,null,null,null,null,{"$f":"ROUND(IF(AND(H261=0,H262=0),0,(L265-L266)*(1+G263)),2)","v":0},{"$f":"K267","v":0},"HIDE"]
[]
[null,null,null,{"$f":"\"Qualifying Income from: \"&D246","v":"Qualifying Income from: "},null,null,null,null,null,null,{"$f":"IFERROR(SUMIF(C261:C267,\"=X\",L261:L267),0)","v":0},{"$f":"K269","v":0}]
[]
[]
[null,"Borrower Name:",null,null,null,null,null,"Other Income Src: "]
[null,null,"Is the Source Taxable?"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,null,null,null,null,null,null,"HIDE"]
[null,null,"O","       Monthly amount:"]
[null,null,null,null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:",null,null,"Monthly Earnings:",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F278<>\"\",G278<>\"\"),IF(K278>0,K278,IF(K278<0,0,K278)),0)","v":0},{"$f":"IF(MONTH(F278)=MONTH(G278),((YEAR(G278)-YEAR(F278))*12)-12+(12-MONTH(F278))+MONTH(G278)-1+(EOMONTH(F278,0)-F278+1)/DAY(EOMONTH(F278,0))+(1-(EOMONTH(G278,0)-G278)/DAY(EOMONTH(G278,0))),((YEAR(G278)-YEAR(F278))*12)-12+(12-MONTH(F278))+MONTH(G278)-1+(EOMONTH(F278,0)-F278+1)/DAY(EOMONTH(F278,0))+(1-(EOMONTH(G278,0)-G278)/DAY(EOMONTH(G278,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F278<>\"\",G278<>\"\"),H278/I278,0),2),0)","v":0},{"$f":"IFERROR(IF(((L278-L279)/ABS(L279))>0,\"+\",\"\")&TEXT(ROUND(((L278-L279)/ABS(L279))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M278","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J279,2)","v":12},{"$f":"IF(AND(F279<>\"\",G279<>\"\"),IF(K279>0,K279,IF(K279<0,0,K279)),0)","v":12},{"$f":"IF(MONTH(F279)=MONTH(G279),((YEAR(G279)-YEAR(F279))*12)-12+(12-MONTH(F279))+MONTH(G279)-1+(EOMONTH(F279,0)-F279+1)/DAY(EOMONTH(F279,0))+(1-(EOMONTH(G279,0)-G279)/DAY(EOMONTH(G279,0))),((YEAR(G279)-YEAR(F279))*12)-12+(12-MONTH(F279))+MONTH(G279)-1+(EOMONTH(F279,0)-F279+1)/DAY(EOMONTH(F279,0))+(1-(EOMONTH(G279,0)-G279)/DAY(EOMONTH(G279,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F279<>\"\",G279<>\"\"),H279/I279,0),2),0)","v":0},"-",{"$f":"M279","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J280,2)","v":12},{"$f":"IF(AND(F280<>\"\",G280<>\"\"),IF(K280>0,K280,IF(K280<0,0,K280)),0)","v":12},12,0,"-",{"$f":"M280","v":"-"}]
[]
[null,null,null,{"$f":"\"Qualifying Income from: \"&D272","v":"Qualifying Income from: "},null,null,null,null,null,null,{"$f":"IF(C276=\"X\",L276,0)+IFERROR(SUMIF(C278:C280,\"=X\",H278:H280)/SUMIF(C278:C280,\"=X\",I278:I280),0)","v":0},{"$f":"K282","v":0}]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Is the Source Non-Taxable?"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,null,"Annual Amount",null,"HIDE","HIDE","Monthly Amount","HIDE"]
[null,null,"O","Gross amount reported on personal tax return or Form 1099",null,null,null,null,"Gross amount = 100%",{"$f":"ROUND(H287/12,2)","v":0},null,{"$f":"J287","v":0},"HIDE"]
[null,null,"O","Taxable amount reported on personal tax return",null,null,null,null,{"$f":"\"Taxable portion = \"&TEXT((K288*100),\"0.00\")&\"%\"","v":"Taxable portion = 0.00%"},{"$f":"ROUND(H288/12,2)","v":0},{"$f":"IFERROR(ROUND(H288/H287,4),0)","v":0},{"$f":"J288","v":0},"HIDE"]
[null,null,"O","Amount eligible for gross-up",null,null,0.25,{"$f":"ROUND(IF(AND(H287=0,H288=0),0,H287-H288),2)","v":0},{"$f":"\"Non-taxable portion = \"&TEXT((K289*100),\"0.00\")&\"%\"","v":"Non-taxable portion = 0.00%"},{"$f":"ROUND((H289*(1+G289))/12,2)","v":0},{"$f":"ROUND(IF(AND(H287=0,H288=0),0,1-K288),4)","v":0},{"$f":"J289","v":0},"HIDE"]
[]
[null,null,"O","Current MONTHLY amount  (to gross-up; enter personal tax return information above)",null,null,null,null,null,null,null,null,"HIDE"]
[null,null,"O","Taxable amount  (based on entry above)",null,null,null,null,null,null,{"$f":"ROUND(L291*K288,2)","v":0},{"$f":"K292","v":0},"HIDE"]
[null,null,"O","Amount eligible for gross-up  (based on entry above)",null,null,null,null,null,null,{"$f":"ROUND(IF(AND(H287=0,H288=0),0,(L291-L292)*(1+G289)),2)","v":0},{"$f":"K293","v":0},"HIDE"]
[]
[null,null,null,{"$f":"\"Qualifying Income from: \"&D272","v":"Qualifying Income from: "},null,null,null,null,null,null,{"$f":"IFERROR(SUMIF(C287:C293,\"=X\",L287:L293),0)","v":0},{"$f":"K295","v":0}]
[]
[]
[null,"Borrower Name:",null,null,null,null,null,"Other Income Src: "]
[null,null,"Is the Source Taxable?"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,null,null,null,null,null,null,"HIDE"]
[null,null,"O","       Monthly amount:"]
[null,null,null,null,null,"Date From:","Date Paid Through:","Total Earnings:","# of Months:",null,null,"Monthly Earnings:",null,"% Change:"]
[null,null,"O","YTD ",2023,"2023-01-01",null,null,null,{"$f":"IF(AND(F304<>\"\",G304<>\"\"),IF(K304>0,K304,IF(K304<0,0,K304)),0)","v":0},{"$f":"IF(MONTH(F304)=MONTH(G304),((YEAR(G304)-YEAR(F304))*12)-12+(12-MONTH(F304))+MONTH(G304)-1+(EOMONTH(F304,0)-F304+1)/DAY(EOMONTH(F304,0))+(1-(EOMONTH(G304,0)-G304)/DAY(EOMONTH(G304,0))),((YEAR(G304)-YEAR(F304))*12)-12+(12-MONTH(F304))+MONTH(G304)-1+(EOMONTH(F304,0)-F304+1)/DAY(EOMONTH(F304,0))+(1-(EOMONTH(G304,0)-G304)/DAY(EOMONTH(G304,0))))","v":-1476},{"$f":"IFERROR(ROUND(IF(AND(F304<>\"\",G304<>\"\"),H304/I304,0),2),0)","v":0},{"$f":"IFERROR(IF(((L304-L305)/ABS(L305))>0,\"+\",\"\")&TEXT(ROUND(((L304-L305)/ABS(L305))*100,2),\"0.00\")&\"%\",\"-\")","v":"-"},{"$f":"M304","v":"-"}]
[null,null,"O","Year",2022,"2022-01-01","2022-12-31",null,{"$f":"ROUND(J305,2)","v":12},{"$f":"IF(AND(F305<>\"\",G305<>\"\"),IF(K305>0,K305,IF(K305<0,0,K305)),0)","v":12},{"$f":"IF(MONTH(F305)=MONTH(G305),((YEAR(G305)-YEAR(F305))*12)-12+(12-MONTH(F305))+MONTH(G305)-1+(EOMONTH(F305,0)-F305+1)/DAY(EOMONTH(F305,0))+(1-(EOMONTH(G305,0)-G305)/DAY(EOMONTH(G305,0))),((YEAR(G305)-YEAR(F305))*12)-12+(12-MONTH(F305))+MONTH(G305)-1+(EOMONTH(F305,0)-F305+1)/DAY(EOMONTH(F305,0))+(1-(EOMONTH(G305,0)-G305)/DAY(EOMONTH(G305,0))))","v":12},{"$f":"IFERROR(ROUND(IF(AND(F305<>\"\",G305<>\"\"),H305/I305,0),2),0)","v":0},"-",{"$f":"M305","v":"-"}]
[null,null,"O","Year",2021,"2021-01-01","2021-12-31",null,{"$f":"ROUND(J306,2)","v":12},{"$f":"IF(AND(F306<>\"\",G306<>\"\"),IF(K306>0,K306,IF(K306<0,0,K306)),0)","v":12},12,0,"-",{"$f":"M306","v":"-"}]
[]
[null,null,null,{"$f":"\"Qualifying Income from: \"&D298","v":"Qualifying Income from: "},null,null,null,null,null,null,{"$f":"IF(C302=\"X\",L302,0)+IFERROR(SUMIF(C304:C306,\"=X\",H304:H306)/SUMIF(C304:C306,\"=X\",I304:I306),0)","v":0},{"$f":"K308","v":0}]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Is the Source Non-Taxable?"]
[null,null,null,null,null,null,null,null,null,"HIDE","HIDE",null,"HIDE"]
[null,null,"Select to include as qualifying income: ",null,null,null,null,"Annual Amount",null,"HIDE","HIDE","Monthly Amount","HIDE"]
[null,null,"O","Gross amount reported on personal tax return or Form 1099",null,null,null,null,"Gross amount = 100%",{"$f":"ROUND(H313/12,2)","v":0},null,{"$f":"J313","v":0},"HIDE"]
[null,null,"O","Taxable amount reported on personal tax return",null,null,null,null,{"$f":"\"Taxable portion = \"&TEXT((K314*100),\"0.00\")&\"%\"","v":"Taxable portion = 0.00%"},{"$f":"ROUND(H314/12,2)","v":0},{"$f":"IFERROR(ROUND(H314/H313,4),0)","v":0},{"$f":"J314","v":0},"HIDE"]
[null,null,"O","Amount eligible for gross-up",null,null,0.25,{"$f":"ROUND(IF(AND(H313=0,H314=0),0,H313-H314),2)","v":0},{"$f":"\"Non-taxable portion = \"&TEXT((K315*100),\"0.00\")&\"%\"","v":"Non-taxable portion = 0.00%"},{"$f":"ROUND((H315*(1+G315))/12,2)","v":0},{"$f":"ROUND(IF(AND(H313=0,H314=0),0,1-K314),4)","v":0},{"$f":"J315","v":0},"HIDE"]
[]
[null,null,"O","Current MONTHLY amount  (to gross-up; enter personal tax return information above)",null,null,null,null,null,null,null,null,"HIDE"]
[null,null,"O","Taxable amount  (based on entry above)",null,null,null,null,null,null,{"$f":"ROUND(L317*K314,2)","v":0},{"$f":"K318","v":0},"HIDE"]
[null,null,"O","Amount eligible for gross-up  (based on entry above)",null,null,null,null,null,null,{"$f":"ROUND(IF(AND(H313=0,H314=0),0,(L317-L318)*(1+G315)),2)","v":0},{"$f":"K319","v":0},"HIDE"]
[]
[null,null,null,{"$f":"\"Qualifying Income from: \"&D298","v":"Qualifying Income from: "},null,null,null,null,null,null,{"$f":"IFERROR(SUMIF(C313:C319,\"=X\",L313:L319),0)","v":0},{"$f":"K321","v":0}]
[]
[]
[null,null,"Comments / Notes (For a new line, hold Alt and press Enter)"]

{"sheet":"_DEF_AND_RESET_01_2022_","index":1,"n_rows":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
["NUM","HEADER_ACTION","WKSHEET","PG_SECTION","HARDCODED","OFF_OF","SHAPE_PREFIX","YEAR_OPT","MY_NAME","DEF_ROW","DEF_COL","DEF_FORMULA_OR_VALUE","EXAMPLE_FORMULA_OR_VALUE"]
[1,"NULL","Income Calculator","HEADER",true,"Worksheet",{"$f":"IF(F2=\"Shape\",B2&\" | \"&C2&\" | \"&D2,\"\")","v":""},null,"File Name",5,4,"NULL"]
[2,"NULL","Income Calculator","HEADER",true,"Worksheet",{"$f":"IF(F3=\"Shape\",B3&\" | \"&C3&\" | \"&D3,\"\")","v":""},null,"Prepared by",5,8,"NULL"]
[3,"NULL","Income Calculator","HEADER",true,"Worksheet",{"$f":"IF(F4=\"Shape\",B4&\" | \"&C4&\" | \"&D4,\"\")","v":""},null,"Date",5,14,"NULL"]
[4,"NULL","Income Calculator","FOOTER",true,"Worksheet",null,null,"Comments",325,3,"NULL"]
[5,"Show Hide","Income Calculator","Base Pay",false,"Shape",{"$f":"IF(F6=\"Shape\",B6&\" | \"&C6&\" | \"&D6,\"\")","v":"Show Hide | Income Calculator | Base Pay"},null,"Borrower Name",-1,2,"NULL"]
[6,"Show Hide","Income Calculator","Base Pay",false,"Shape",{"$f":"IF(F7=\"Shape\",B7&\" | \"&C7&\" | \"&D7,\"\")","v":"Show Hide | Income Calculator | Base Pay"},null,"Employer Name",-1,7,"NULL"]
[7,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",null,"Rate of Pay",3,5,"NULL"]
[8,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",null,"Pay Frequency",3,6,"Hourly (H)","Hourly (H)"]
[9,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",null,"Hours Worked Weekly",3,7,0,"0.00"]
[10,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",2023,"Date from: 2023",5,4,{"$f":"\"1/1/\"&H11","v":"1/1/2023"},"2023-01-01"]
[11,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",2023,"Date Paid Through: 2023",5,5,"NULL","2023-01-02"]
[12,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",2023,"Total Earnings: 2023",5,6,"NULL","2023-01-03"]
[13,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",2022,"Date from: 2022",6,4,{"$f":"\"1/1/\"&H14","v":"1/1/2022"},"2022-01-01"]
[14,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",2022,"Date Paid Through: 2022",6,5,{"$f":"\"12/31/\"&H15","v":"12/31/2022"},"2022-12-31"]
[15,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",2022,"Total Earnings: 2022",6,6,"NULL"]
[16,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",2021,"Date from: 2021",7,4,{"$f":"\"1/1/\"&H17","v":"1/1/2021"},"2021-01-01"]
[17,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",2021,"Date Paid Through: 2021",7,5,{"$f":"\"12/31/\"&H18","v":"12/31/2021"},"2021-12-31"]
[18,"Show Hide","Income Calculator","Base Pay",false,"Shape","Show Hide | Income Calculator | Base Pay",2021,"Total Earnings: 2021",7,6,"NULL"]
[19,"Show Hide","Income Calculator","Overtime",false,"Shape","Show Hide | Income Calculator | Overtime",2023,"Date from: 2023",3,4,{"$f":"\"1/1/\"&H20","v":"1/1/2023"},"2023-01-01"]
[20,"Show Hide","Income Calculator","Overtime",false,"Shape",{"$f":"IF(F21=\"Shape\",B21&\" | \"&C21&\" | \"&D21,\"\")","v":"Show Hide | Income Calculator | Overtime"},2023,"Date Paid Through: 2023",3,5,"NULL"]
[21,"Show Hide","Income Calculator","Overtime",false,"Shape","Show Hide | Income Calculator | Overtime",2023,"Total Earnings: 2023",3,6,"NULL"]
[22,"Show Hide","Income Calculator","Overtime",false,"Shape","Show Hide | Income Calculator | Overtime",null,"# of Months",3,7,"NULL"]
[23,"Show Hide","Income Calculator","Overtime",false,"Shape","Show Hide | Income Calculator | Overtime",2022,"Date from: 2022",4,4,{"$f":"\"1/1/\"&H24","v":"1/1/2022"},"2022-01-01"]
[24,"Show Hide","Income Calculator","Overtime",false,"Shape","Show Hide | Income Calculator | Overtime",2022,"Date Paid Through: 2022",4,5,{"$f":"\"12/31/\"&H25","v":"12/31/2022"},"2022-12-31"]
[25,"Show Hide","Income Calculator","Overtime",false,"Shape","Show Hide | Income Calculator | Overtime",2022,"Total Earnings: 2022",4,6,"NULL"]
[26,"Show Hide","Income Calculator","Overtime",false,"Shape","Show Hide | Income Calculator | Overtime",2021,"Date from: 2021",5,4,{"$f":"\"1/1/\"&H27","v":"1/1/2021"},"2021-01-01"]
[27,"Show Hide","Income Calculator","Overtime",false,"Shape","Show Hide | Income Calculator | Overtime",2021,"Date Paid Through: 2021",5,5,{"$f":"\"12/31/\"&H28","v":"12/31/2021"},"2021-12-31"]
[28,"Show Hide","Income Calculator","Overtime",false,"Shape","Show Hide | Income Calculator | Overtime",2021,"Total Earnings: 2021",5,6,"NULL"]
[29,"Show Hide","Income Calculator","Bonus",false,"Shape","Show Hide | Income Calculator | Bonus",2023,"Date from: 2023",3,4,{"$f":"\"1/1/\"&H30","v":"1/1/2023"},"2023-01-01"]
[30,"Show Hide","Income Calculator","Bonus",false,"Shape",{"$f":"IF(F31=\"Shape\",B31&\" | \"&C31&\" | \"&D31,\"\")","v":"Show Hide | Income Calculator | Bonus"},2023,"Date Paid Through: 2023",3,5,"NULL"]
[31,"Show Hide","Income Calculator","Bonus",false,"Shape","Show Hide | Income Calculator | Bonus",2023,"Total Earnings: 2023",3,6,"NULL"]
[32,"Show Hide","Income Calculator","Bonus",false,"Shape","Show Hide | Income Calculator | Bonus",null,"# of Months",3,7,"NULL"]
[33,"Show Hide","Income Calculator","Bonus",false,"Shape","Show Hide | Income Calculator | Bonus",2022,"Date from: 2022",4,4,{"$f":"\"1/1/\"&H34","v":"1/1/2022"},"2022-01-01"]
[34,"Show Hide","Income Calculator","Bonus",false,"Shape","Show Hide | Income Calculator | Bonus",2022,"Date Paid Through: 2022",4,5,{"$f":"\"12/31/\"&H35","v":"12/31/2022"},"2022-12-31"]
[35,"Show Hide","Income Calculator","Bonus",false,"Shape","Show Hide | Income Calculator | Bonus",2022,"Total Earnings: 2022",4,6,"NULL"]
[36,"Show Hide","Income Calculator","Bonus",false,"Shape","Show Hide | Income Calculator | Bonus",2021,"Date from: 2021",5,4,{"$f":"\"1/1/\"&H37","v":"1/1/2021"},"2021-01-01"]
[37,"Show Hide","Income Calculator","Bonus",false,"Shape","Show Hide | Income Calculator | Bonus",2021,"Date Paid Through: 2021",5,5,{"$f":"\"12/31/\"&H38","v":"12/31/2021"},"2021-12-31"]
[38,"Show Hide","Income Calculator","Bonus",false,"Shape","Show Hide | Income Calculator | Bonus",2021,"Total Earnings: 2021",5,6,"NULL"]
[39,"Show Hide","Income Calculator","Commission",false,"Shape","Show Hide | Income Calculator | Commission",2023,"Date from: 2023",3,4,{"$f":"\"1/1/\"&H40","v":"1/1/2023"},"2023-01-01"]
[40,"Show Hide","Income Calculator","Commission",false,"Shape",{"$f":"IF(F41=\"Shape\",B41&\" | \"&C41&\" | \"&D41,\"\")","v":"Show Hide | Income Calculator | Commission"},2023,"Date Paid Through: 2023",3,5,"NULL"]
[41,"Show Hide","Income Calculator","Commission",false,"Shape","Show Hide | Income Calculator | Commission",2023,"Total Earnings: 2023",3,6,"NULL"]
[42,"Show Hide","Income Calculator","Commission",false,"Shape","Show Hide | Income Calculator | Commission",null,"# of Months",3,7,"NULL"]
[43,"Show Hide","Income Calculator","Commission",false,"Shape","Show Hide | Income Calculator | Commission",2022,"Date from: 2022",4,4,{"$f":"\"1/1/\"&H44","v":"1/1/2022"},"2022-01-01"]
[44,"Show Hide","Income Calculator","Commission",false,"Shape","Show Hide | Income Calculator | Commission",2022,"Date Paid Through: 2022",4,5,{"$f":"\"12/31/\"&H45","v":"12/31/2022"},"2022-12-31"]
[45,"Show Hide","Income Calculator","Commission",false,"Shape","Show Hide | Income Calculator | Commission",2022,"Total Earnings: 2022",4,6,"NULL"]
[46,"Show Hide","Income Calculator","Commission",false,"Shape","Show Hide | Income Calculator | Commission",2021,"Date from: 2021",5,4,{"$f":"\"1/1/\"&H47","v":"1/1/2021"},"2021-01-01"]
[47,"Show Hide","Income Calculator","Commission",false,"Shape","Show Hide | Income Calculator | Commission",2021,"Date Paid Through: 2021",5,5,{"$f":"\"12/31/\"&H48","v":"12/31/2021"},"2021-12-31"]
[48,"Show Hide","Income Calculator","Commission",false,"Shape","Show Hide | Income Calculator | Commission",2021,"Total Earnings: 2021",5,6,"NULL"]
[49,"Show Hide","Income Calculator","Other Income",false,"Shape",{"$f":"IF(F50=\"Shape\",B50&\" | \"&C50&\" | \"&D50,\"\")","v":"Show Hide | Income Calculator | Other Income"},null,"Type",2,2,"NULL"]
[50,"Show Hide","Income Calculator","Other Income",false,"Shape","Show Hide | Income Calculator | Other Income",2023,"Date from: 2023",5,4,{"$f":"\"1/1/\"&H51","v":"1/1/2023"},"2023-01-01"]
[51,"Show Hide","Income Calculator","Other Income",false,"Shape",{"$f":"IF(F52=\"Shape\",B52&\" | \"&C52&\" | \"&D52,\"\")","v":"Show Hide | Income Calculator | Other Income"},2023,"Date Paid Through: 2023",5,5,"NULL"]
[52,"Show Hide","Income Calculator","Other Income",false,"Shape","Show Hide | Income Calculator | Other Income",2023,"Total Earnings: 2023",5,6,"NULL"]
[53,"Show Hide","Income Calculator","Other Income",false,"Shape","Show Hide | Income Calculator | Other Income",null,"# of Months",5,7,"NULL"]
[54,"Show Hide","Income Calculator","Other Income",false,"Shape","Show Hide | Income Calculator | Other Income",2022,"Date from: 2022",6,4,{"$f":"\"1/1/\"&H55","v":"1/1/2022"},"2022-01-01"]
[55,"Show Hide","Income Calculator","Other Income",false,"Shape","Show Hide | Income Calculator | Other Income",2022,"Date Paid Through: 2022",6,5,{"$f":"\"12/31/\"&H56","v":"12/31/2022"},"2022-12-31"]
[56,"Show Hide","Income Calculator","Other Income",false,"Shape","Show Hide | Income Calculator | Other Income",2022,"Total Earnings: 2022",6,6,"NULL"]
[57,"Show Hide","Income Calculator","Other Income",false,"Shape","Show Hide | Income Calculator | Other Income",2021,"Date from: 2021",7,4,{"$f":"\"1/1/\"&H58","v":"1/1/2021"},"2021-01-01"]
[58,"Show Hide","Income Calculator","Other Income",false,"Shape","Show Hide | Income Calculator | Other Income",2021,"Date Paid Through: 2021",7,5,{"$f":"\"12/31/\"&H59","v":"12/31/2021"},"2021-12-31"]
[59,"Show Hide","Income Calculator","Other Income",false,"Shape","Show Hide | Income Calculator | Other Income",2021,"Total Earnings: 2021",7,6,"NULL"]
[60,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",null,"Borrower Name",-1,2,"NULL"]
[61,"Show Hide","Income Calculator","Taxable",false,"Shape",{"$f":"IF(F62=\"Shape\",B62&\" | \"&C62&\" | \"&D62,\"\")","v":"Show Hide | Income Calculator | Taxable"},null,"Other Income Src",-1,7,"NULL"]
[62,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",null,"Monthly Amount",3,10,"NULL"]
[63,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",2023,"Date from: 2023",5,4,{"$f":"\"1/1/\"&H64","v":"1/1/2023"},"2023-01-01"]
[64,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",2023,"Date Paid Through: 2023",5,5,"NULL"]
[65,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",2023,"Total Earnings: 2023",5,6,"NULL"]
[66,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",null,"# of Months",5,7,"NULL"]
[67,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",2022,"Date from: 2022",6,4,{"$f":"\"1/1/\"&H68","v":"1/1/2022"},"2022-01-01"]
[68,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",2022,"Date Paid Through: 2022",6,5,{"$f":"\"12/31/\"&H69","v":"12/31/2022"},"2022-12-31"]
[69,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",2022,"Total Earnings: 2022",6,6,"NULL"]
[70,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",2021,"Date from: 2021",7,4,{"$f":"\"1/1/\"&H71","v":"1/1/2021"},"2021-01-01"]
[71,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",2021,"Date Paid Through: 2021",7,5,{"$f":"\"12/31/\"&H72","v":"12/31/2021"},"2021-12-31"]
[72,"Show Hide","Income Calculator","Taxable",false,"Shape","Show Hide | Income Calculator | Taxable",2021,"Total Earnings: 2021",7,6,"NULL"]
[73,"Show Hide","Income Calculator","Non-Taxable",false,"Shape",{"$f":"IF(F74=\"Shape\",B74&\" | \"&C74&\" | \"&D74,\"\")","v":"Show Hide | Income Calculator | Non-Taxable"},null,"Gross Annual Amount",3,6,"NULL"]
[74,"Show Hide","Income Calculator","Non-Taxable",false,"Shape","Show Hide | Income Calculator | Non-Taxable",null,"Taxable Annual Amount",4,6,"NULL"]
[75,"Show Hide","Income Calculator","Non-Taxable",false,"Shape","Show Hide | Income Calculator | Non-Taxable",null,"Amt for Gross-Up",5,5,0.25,0.25]
[76,"Show Hide","Income Calculator","Non-Taxable",false,"Shape","Show Hide | Income Calculator | Non-Taxable",null,"Current Monthly Amount",7,10,"NULL"]

{"sheet":"__VAR_OPS__","index":2,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,null,"COL"]
[null,null,null,null,null,"NUM"]
[null,null,null,null,null,"HEADER_ACTION",2,"lHdrActionColNum",null,null,{"$f":"\"Public Const \"&H5&\" As Long = \"&G5&\"   '\"&F5","v":"Public Const lHdrActionColNum As Long = 2   'HEADER_ACTION"}]
[null,null,null,null,null,"WKSHEET",3,"lWksOpColNum",null,null,{"$f":"\"Public Const \"&H6&\" As Long = \"&G6&\"   '\"&F6","v":"Public Const lWksOpColNum As Long = 3   'WKSHEET"}]
[null,null,null,null,null,"PG_SECTION",4,"lHdrSectionColNum",null,null,"Public Const lHdrSectionColNum As Long = 4   'PG_SECTION"]
[null,null,null,null,null,"HARDCODED",5,"lHardcodeColNum",null,null,"Public Const lHardcodeColNum As Long = 5   'HARDCODED"]
[null,null,null,null,null,"OFF_OF",6,"lOffOfColNum",null,null,"Public Const lOffOfColNum As Long = 6   'OFF_OF"]
[null,null,null,null,null,"SHAPE_PREFIX",7,"lShpPrefixColNum",null,null,"Public Const lShpPrefixColNum As Long = 7   'SHAPE_PREFIX"]
[null,null,null,null,null,"YEAR_OPT",8,"lYrOptColNum",null,null,"Public Const lYrOptColNum As Long = 8   'YEAR_OPT"]
[null,null,null,null,null,"MY_NAME",9,"lMyNameColNum",null,null,"Public Const lMyNameColNum As Long = 9   'MY_NAME"]
[null,null,null,null,null,"DEF_ROW",10,"lDefRowColNum",null,null,"Public Const lDefRowColNum As Long = 10   'DEF_ROW"]
[null,null,null,null,null,"DEF_COL",11,"lDefColColNum",null,null,"Public Const lDefColColNum As Long = 11   'DEF_COL"]
[null,null,null,null,null,"DEF_FORMULA_OR_VALUE",12,"lDefValColNum",null,null,"Public Const lDefValColNum As Long = 12   'DEF_FORMULA_OR_VALUE"]
[null,null,null,null,null,"EXAMPLE_FORMULA_OR_VALUE"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Public Const lHdrActionColNum As Long = 2   'HEADER_ACTION"]
[null,null,null,null,null,null,null,null,null,null,"Public Const lWksOpColNum As Long = 3   'WKSHEET"]
[null,null,null,null,null,null,null,null,null,null,"Public Const lHdrSectionColNum As Long = 4   'PG_SECTION"]
[null,null,null,null,null,null,null,null,null,null,"Public Const lHardcodeColNum As Long = 5   'HARDCODED"]
[null,null,null,null,null,null,null,null,null,null,"Public Const lOffOfColNum As Long = 6   'OFF_OF"]
[null,null,null,null,null,null,null,null,null,null,"Public Const lShpPrefixColNum As Long = 7   'SHAPE_PREFIX"]
[null,null,null,null,null,null,null,null,null,null,"Public Const lYrOptColNum As Long = 8   'YEAR_OPT"]
[null,null,null,null,null,null,null,null,null,null,"Public Const lMyNameColNum As Long = 9   'MY_NAME"]
[null,null,null,null,null,null,null,null,null,null,"Public Const lDefRowColNum As Long = 10   'DEF_ROW"]
[null,null,null,null,null,null,null,null,null,null,"Public Const lDefColColNum As Long = 11   'DEF_COL"]
[null,null,null,null,null,null,null,null,null,null,"Public Const lDefValColNum As Long = 12   'DEF_FORMULA_OR_VALUE"]

{"sheet":"_LOOKUP_LISTS_","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["LKP_YEAR","LKP_PAY_FREQ","LKP_PAY_FREQ_VAL","LKP_PAY_FREQ_02","LKP_PAY_FREQ_VAL_02"]
[2021,"Hourly (H)","H","Hourly (H)","H"]
[2022,"Weekly (52)",52,"Weekly (52)",52]
[2023,"Bi-Weekly (26)",26,"Bi-Weekly (26)",26]
[null,"Semi-Monthly (24)",24,"Semi-Monthly (24)",24]
[null,"Monthly (12)",12,"Monthly (12)",12]
[null,"Quarterly (4)",4,"Quarterly (4)",4]
[null,"Semi-Annually (2)",2,"Semi-Annually (2)",2]
[null,"Annually (1)",1,"Annually (1)",1]
[null,"Varies",0,"Varies",0]

{"sheet":"_SHOW_HIDE_TOTALS_","index":4,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["NUM_ENTRY","HEADER_ACTION","WKSHEET","PG_SECTION","NUM_ROWS","COLS_OVER"]
[1,"Total Row","Income Calculator","Employer^1",2,3]
[2,"Total Row","Income Calculator","Employer^2",2,3]
[3,"Total Row","Income Calculator","Employer^3",2,3]
[4,"Total Row","Income Calculator","Employer^4",2,3]

{"sheet":"_SHOW_HIDE_OPS_","index":5,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["NUM_ENTRY","WKSHEET","PG_SECTION","NUM_ROWS"]
[1,"Income Calculator","Base Pay^1",10]
[2,"Income Calculator","Overtime^1",8]
[3,"Income Calculator","Bonus^1",8]
[4,"Income Calculator","Commission^1",8]
[5,"Income Calculator","Other Income^1",10]
[6,"Income Calculator","Base Pay^2",10]
[7,"Income Calculator","Overtime^2",8]
[8,"Income Calculator","Bonus^2",8]
[9,"Income Calculator","Commission^2",8]
[10,"Income Calculator","Other Income^2",10]
[11,"Income Calculator","Base Pay^3",10]
[12,"Income Calculator","Overtime^3",8]
[13,"Income Calculator","Bonus^3",8]
[14,"Income Calculator","Commission^3",8]
[15,"Income Calculator","Other Income^3",10]
[16,"Income Calculator","Base Pay^4",10]
[17,"Income Calculator","Overtime^4",8]
[18,"Income Calculator","Bonus^4",8]
[19,"Income Calculator","Commission^4",8]
[20,"Income Calculator","Other Income^4",10]
[21,"Income Calculator","Taxable^1",10]
[22,"Income Calculator","Non-Taxable^1",12]
[23,"Income Calculator","Taxable^2",10]
[24,"Income Calculator","Non-Taxable^2",12]
[25,"Income Calculator","Taxable^3",10]
[26,"Income Calculator","Non-Taxable^3",12]
[27,"Income Calculator","Taxable^4",10]
[28,"Income Calculator","Non-Taxable^4",12]
[29,"Other Source","Taxable^1",10]
[30,"Other Source","Non-Taxable^1",11]

{"sheet":"_DEFAULTS_AND_RESET_","index":6,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["NUM","HEADER_ACTION","WKSHEET","PG_SECTION","DEF_NAME","ACTUAL_NAME","DEF_ROW","DEF_COL","DEF_FORMULA_OR_VALUE","EXAMPLE_FORMULA_OR_VALUE"]
[1,"Show Hide","Income Calculator","Base Pay^1","DEFAULT01","Rate_of_Pay_Monthly_Earnings",3,10,"=IFERROR(ROUND(†-1|0†/12,2),0)","=IFERROR(ROUND(K12/12,2),0)"]
[2,"Show Hide","Income Calculator","Base Pay^1","DEFAULT02","Base_Pay_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[3,"Show Hide","Income Calculator","Overtime^1","DEFAULT01","Overtime_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[4,"Show Hide","Income Calculator","Bonus^1","DEFAULT01","Bonus_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[5,"Show Hide","Income Calculator","Commission^1","DEFAULT01","Commission_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[6,"Show Hide","Income Calculator","Other Income^1","DEFAULT01","Other_Income_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[7,"Show Hide","Income Calculator","Base Pay^2","DEFAULT01","Rate_of_Pay_Monthly_Earnings",3,10,"=IFERROR(ROUND(†-1|0†/12,2),0)","=IFERROR(ROUND(K12/12,2),0)"]
[8,"Show Hide","Income Calculator","Base Pay^2","DEFAULT02","Base_Pay_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[9,"Show Hide","Income Calculator","Overtime^2","DEFAULT01","Overtime_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[10,"Show Hide","Income Calculator","Bonus^2","DEFAULT01","Bonus_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[11,"Show Hide","Income Calculator","Commission^2","DEFAULT01","Commission_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[12,"Show Hide","Income Calculator","Other Income^2","DEFAULT01","Other_Income_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[13,"Show Hide","Income Calculator","Base Pay^3","DEFAULT01","Rate_of_Pay_Monthly_Earnings",3,10,"=IFERROR(ROUND(†-1|0†/12,2),0)","=IFERROR(ROUND(K12/12,2),0)"]
[14,"Show Hide","Income Calculator","Base Pay^3","DEFAULT02","Base_Pay_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[15,"Show Hide","Income Calculator","Overtime^3","DEFAULT01","Overtime_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[16,"Show Hide","Income Calculator","Bonus^3","DEFAULT01","Bonus_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[17,"Show Hide","Income Calculator","Commission^3","DEFAULT01","Commission_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[18,"Show Hide","Income Calculator","Other Income^3","DEFAULT01","Other_Income_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[19,"Show Hide","Income Calculator","Base Pay^4","DEFAULT01","Rate_of_Pay_Monthly_Earnings",3,10,"=IFERROR(ROUND(†-1|0†/12,2),0)","=IFERROR(ROUND(K12/12,2),0)"]
[20,"Show Hide","Income Calculator","Base Pay^4","DEFAULT02","Base_Pay_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[21,"Show Hide","Income Calculator","Overtime^4","DEFAULT01","Overtime_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[22,"Show Hide","Income Calculator","Bonus^4","DEFAULT01","Bonus_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[23,"Show Hide","Income Calculator","Commission^4","DEFAULT01","Commission_Annualize_or_YTD",3,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[24,"Show Hide","Income Calculator","Other Income^4","DEFAULT01","Other_Income_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J38,2)"]
[25,"Show Hide","Income Calculator","Taxable^1","DEFAULT01","Taxable_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[26,"Show Hide","Income Calculator","Taxable^2","DEFAULT01","Taxable_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[27,"Show Hide","Income Calculator","Taxable^3","DEFAULT01","Taxable_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[28,"Show Hide","Income Calculator","Taxable^4","DEFAULT01","Taxable_Annualize_or_YTD",5,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]
[29,"Show Hide","Other Source","Taxable^1","DEFAULT01","Taxable_Annualize_or_YTD",6,7,"=ROUND(†0|1†,2)","=ROUND(J26,2)"]