{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Bank Stmt Calculator","Deposit Analysis"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Bank Stmt Calculator","index":0,"n_rows":104,"n_cols":37,"rows_kept":104,"cut":false,"hidden":false,"merged":[[1,16,5,30],[102,2,102,10],[103,2,103,10],[102,14,102,16],[103,14,103,16],[18,7,18,10],[94,2,98,19],[84,18,84,19],[58,2,58,3],[59,2,59,3],[21,8,21,10],[55,6,55,16],[18,25,18,26],[26,2,26,31],[10,2,10,30],[28,23,50,30],[20,14,21,30],[12,28,18,31],[8,1,8,32],[12,25,12,26],[16,25,16,26],[47,7,47,9],[47,17,47,19],[50,10,50,15],[24,1,24,32],[12,7,12,10],[14,7,14,10],[28,7,28,10],[30,7,30,10],[34,3,34,6],[34,14,34,16],[34,7,34,9],[34,17,34,19],[33,3,33,9],[33,14,33,19],[16,7,16,10],[44,14,44,16],[44,17,44,19],[45,14,45,16],[45,17,45,19],[46,14,46,16],[46,17,46,19],[41,14,41,16],[41,17,41,19],[42,14,42,16],[42,17,42,19],[43,14,43,16],[43,17,43,19],[38,14,38,16],[38,17,38,19],[39,14,39,16],[39,17,39,19],[40,14,40,16],[40,17,40,19],[35,14,35,16],[35,17,35,19],[36,14,36,16],[36,17,36,19],[37,14,37,16],[37,17,37,19],[44,3,44,6],[44,7,44,9],[45,3,45,6],[45,7,45,9],[46,3,46,6],[46,7,46,9],[41,3,41,6],[41,7,41,9],[42,3,42,6],[42,7,42,9],[43,3,43,6],[43,7,43,9],[37,7,37,9],[38,3,38,6],[38,7,38,9],[39,3,39,6],[39,7,39,9],[40,3,40,6],[40,7,40,9],[94,23,94,27],[94,29,94,30],[78,14,78,17],[78,18,78,19],[76,9,76,10],[76,5,76,8],[78,9,78,10],[74,9,74,10],[74,5,74,8],[72,24,72,27],[74,24,74,27],[76,24,76,27],[74,29,74,30],[76,29,76,30],[78,29,78,30],[80,29,80,30],[82,29,82,30],[96,29,96,30],[96,23,96,27],[53,1,53,32],[35,7,35,9],[35,3,35,6],[36,3,36,6],[36,7,36,9],[37,3,37,6],[58,22,58,31],[59,22,59,31],[88,22,88,31],[92,29,92,30],[92,23,92,27],[70,4,70,11],[70,13,70,20],[58,13,58,20],[58,4,58,11],[59,4,59,11],[59,13,59,20],[78,5,78,8],[74,14,74,17],[74,18,74,19],[76,14,76,17],[76,18,76,19],[86,29,86,30],[84,29,84,30],[61,29,61,30],[64,29,64,30],[66,29,66,30],[68,29,68,30],[70,29,70,30],[72,29,72,30],[64,9,64,10],[66,9,66,10],[68,9,68,10],[61,9,61,10],[61,18,61,19],[64,18,64,19],[66,18,66,19],[68,18,68,19],[86,9,90,19]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bank Statement Worksheet"]
[]
[]
[]
[]
[]
[]
[null,"Borrower / Business Information"]
[]
[null,null,"Fill out 'Business Narative' tab."]
[]
[null,null,"Borrower Name:",null,null,null,null,null,null,null,null,null,null,"Is borrower using personal Bank Statements?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Z13=\"Yes\",Z17=\"Yes\",Z19=\"No\"),\"Note: 2 mo of business bank statements are required\",\"\")","v":""}]
[]
[null,null,"Axos Loan Number:",null,null,null,null,null,null,null,null,null,null,null,"If yes…"]
[]
[null,null,"Entity / Business Name:",null,null,null,null,null,null,null,null,null,null,null,"Does the borrower keep separate personal & business bank accounts?"]
[]
[null,null,"% Ownership of the Business:",null,null,null,null,null,null,null,null,null,null,null,"Are there any business expenses in their personal account?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(Z13=\"Yes\",Z17=\"Yes\",Z19=\"Yes\"),AND(Z13=\"Yes\",Z17=\"No\",Z19=\"No\"),AND(Z13=\"Yes\",Z17=\"No\",Z19=\"Yes\")),\"Since borrower combines business banking with personal banking, loan must 'qualify' under the business bank statement (regardless if the acct is in the individual's name).  Complete 'Qualifying Income' section below.\",\"\")","v":""}]
[null,null,"Monthly Income from Initial 1003:"]
[]
[]
[null,"Bank Statement Analysis"]
[]
[null,null,"Enter Bank Statement data on 'Deposit Analysis' tab.  Below is a summary of the data."]
[]
[null,null,"Business or Personal Account:",null,null,null,null,{"$f":"IF(Z13=\"no\",\"Business\",IF(OR(Z13=\"\",Z17=\"\",Z19=\"\"),\"Fill out above section entirely\",IF(AND(Z13=\"Yes\",Z17=\"Yes\",Z19=\"No\"),\"Personal\",\"Business\")))","v":"Fill out above section entirely"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\n- Transfers from other bank accounts:\nProvide conclusive evidence that the source of transfer is business related income.\n\n- NSF fees, overdraft fees, and/or Transfers:\nAn LOE from the borrower is required to evaluate that NSFs and overdrafts are not due to financial mishandling and/or indicative of insufficient income.\n\n- Large deposits (as defined by Fannie Mae):\nSourcing for large deposits not required if a sufficient borrower LOE is provided.  Does not need to be addressed individually if consistent with the business.\n"]
[]
[null,null,"# Months Bank Statements:",null,null,null,null,12]
[]
[]
[null,null,null,"Most Recent 12 Months",null,null,null,null,null,null,null,null,null,null,"Prior 12 Months (if applicable)"]
[null,null,null,"Month",null,null,null,"Total Eligible Deposits",null,null,null,null,null,null,"Month",null,null,"Total Eligible Deposits"]
[null,null,null,{"$f":"'Deposit Analysis'!D11","v":"January 1900"},null,null,null,{"$f":"'Deposit Analysis'!N11+'Deposit Analysis'!N29+'Deposit Analysis'!N47+'Deposit Analysis'!N65+'Deposit Analysis'!N83+'Deposit Analysis'!N101","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P11","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z11+'Deposit Analysis'!Z29+'Deposit Analysis'!Z47+'Deposit Analysis'!Z65+'Deposit Analysis'!Z83+'Deposit Analysis'!Z101","v":0}]
[null,null,null,{"$f":"'Deposit Analysis'!D12","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Deposit Analysis'!N12+'Deposit Analysis'!N30+'Deposit Analysis'!N48+'Deposit Analysis'!N66+'Deposit Analysis'!N84+'Deposit Analysis'!N102","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P12","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z12+'Deposit Analysis'!Z30+'Deposit Analysis'!Z48+'Deposit Analysis'!Z66+'Deposit Analysis'!Z84+'Deposit Analysis'!Z102","v":0}]
[null,null,null,{"$f":"'Deposit Analysis'!D13","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Deposit Analysis'!N13+'Deposit Analysis'!N31+'Deposit Analysis'!N49+'Deposit Analysis'!N67+'Deposit Analysis'!N85+'Deposit Analysis'!N103","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P13","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z13+'Deposit Analysis'!Z31+'Deposit Analysis'!Z49+'Deposit Analysis'!Z67+'Deposit Analysis'!Z85+'Deposit Analysis'!Z103","v":0}]
[null,null,null,{"$f":"'Deposit Analysis'!D14","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Deposit Analysis'!N14+'Deposit Analysis'!N32+'Deposit Analysis'!N50+'Deposit Analysis'!N68+'Deposit Analysis'!N86+'Deposit Analysis'!N104","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P14","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z14+'Deposit Analysis'!Z32+'Deposit Analysis'!Z50+'Deposit Analysis'!Z68+'Deposit Analysis'!Z86+'Deposit Analysis'!Z104","v":0}]
[null,null,null,{"$f":"'Deposit Analysis'!D15","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Deposit Analysis'!N15+'Deposit Analysis'!N33+'Deposit Analysis'!N51+'Deposit Analysis'!N69+'Deposit Analysis'!N87+'Deposit Analysis'!N105","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P15","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z15+'Deposit Analysis'!Z33+'Deposit Analysis'!Z51+'Deposit Analysis'!Z69+'Deposit Analysis'!Z87+'Deposit Analysis'!Z105","v":0}]
[null,null,null,{"$f":"'Deposit Analysis'!D16","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Deposit Analysis'!N16+'Deposit Analysis'!N34+'Deposit Analysis'!N52+'Deposit Analysis'!N70+'Deposit Analysis'!N88+'Deposit Analysis'!N106","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P16","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z16+'Deposit Analysis'!Z34+'Deposit Analysis'!Z52+'Deposit Analysis'!Z70+'Deposit Analysis'!Z88+'Deposit Analysis'!Z106","v":0}]
[null,null,null,{"$f":"'Deposit Analysis'!D17","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Deposit Analysis'!N17+'Deposit Analysis'!N35+'Deposit Analysis'!N53+'Deposit Analysis'!N71+'Deposit Analysis'!N89+'Deposit Analysis'!N107","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P17","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z17+'Deposit Analysis'!Z35+'Deposit Analysis'!Z53+'Deposit Analysis'!Z71+'Deposit Analysis'!Z89+'Deposit Analysis'!Z107","v":0}]
[null,null,null,{"$f":"'Deposit Analysis'!D18","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Deposit Analysis'!N18+'Deposit Analysis'!N36+'Deposit Analysis'!N54+'Deposit Analysis'!N72+'Deposit Analysis'!N90+'Deposit Analysis'!N108","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P18","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z18+'Deposit Analysis'!Z36+'Deposit Analysis'!Z54+'Deposit Analysis'!Z72+'Deposit Analysis'!Z90+'Deposit Analysis'!Z108","v":0}]
[null,null,null,{"$f":"'Deposit Analysis'!D19","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Deposit Analysis'!N19+'Deposit Analysis'!N37+'Deposit Analysis'!N55+'Deposit Analysis'!N73+'Deposit Analysis'!N91+'Deposit Analysis'!N109","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P19","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z19+'Deposit Analysis'!Z37+'Deposit Analysis'!Z55+'Deposit Analysis'!Z73+'Deposit Analysis'!Z91+'Deposit Analysis'!Z109","v":0}]
[null,null,null,{"$f":"'Deposit Analysis'!D20","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Deposit Analysis'!N20+'Deposit Analysis'!N38+'Deposit Analysis'!N56+'Deposit Analysis'!N74+'Deposit Analysis'!N92+'Deposit Analysis'!N110","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P20","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z20+'Deposit Analysis'!Z38+'Deposit Analysis'!Z56+'Deposit Analysis'!Z74+'Deposit Analysis'!Z92+'Deposit Analysis'!Z110","v":0}]
[null,null,null,{"$f":"'Deposit Analysis'!D21","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Deposit Analysis'!N21+'Deposit Analysis'!N39+'Deposit Analysis'!N57+'Deposit Analysis'!N75+'Deposit Analysis'!N93+'Deposit Analysis'!N111","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P21","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z21+'Deposit Analysis'!Z39+'Deposit Analysis'!Z57+'Deposit Analysis'!Z75+'Deposit Analysis'!Z93+'Deposit Analysis'!Z111","v":0}]
[null,null,null,{"$f":"'Deposit Analysis'!D22","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Deposit Analysis'!N22+'Deposit Analysis'!N40+'Deposit Analysis'!N58+'Deposit Analysis'!N76+'Deposit Analysis'!N94+'Deposit Analysis'!N112","v":0},null,null,null,null,null,null,{"$f":"'Deposit Analysis'!P22","v":{"$error":"#NUM!"}},null,null,{"$f":"'Deposit Analysis'!Z22+'Deposit Analysis'!Z40+'Deposit Analysis'!Z58+'Deposit Analysis'!Z76+'Deposit Analysis'!Z94+'Deposit Analysis'!Z112","v":0}]
[null,null,null,null,null,null,"TOTAL:  ",{"$f":"SUM(H36:J47)","v":0},null,null,null,null,null,null,null,null,"TOTAL:  ",{"$f":"SUM(R36:T47)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL ELIGIBLE DEPOSITS:  ",{"$f":"IF(H31=12,H48,IF(H31=24,(H48+R48),\"\"))","v":0}]
[]
[]
[null,"Qualifying Income"]
[]
[null,null,null,null,null,"Calculating Option:  "]
[]
[]
[null,null,"Option",null,"40% EXPENSE FACTOR",null,null,null,null,null,null,null,null,"60% EXPENSE FACTOR",null,null,null,null,null,null,null,null,"PROFIT AND LOSS\n(last year + YTD)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($H$29=\"Personal\",$G$56=\"40% Expense Factor (services)\"),\"Yes\",\"No\")","v":"No"},"Personal & 40% Expense Factor"]
[null,null,"Preparer",null,"N/A",null,null,null,null,null,null,null,null,"Tax Professional",null,null,null,null,null,null,null,null,"Tax Professional",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($H$29=\"Personal\",$G$56=\"60% Expense Factor (non-services or product business)\"),\"Yes\",\"No\")","v":"No"},"Personal & 60% Expense Factor"]
[]
[null,null,null,null,null,"Expense Factor",null,null,null,0.4,null,null,null,null,"Expense Factor",null,null,null,0.6,null,null,null,null,"Business receipts/gross income?",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($H$29=\"Business\",$G$56=\"40% Expense Factor (services)\"),\"Yes\",\"No\")","v":"No"},"Business & 40% Expense Factor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summarize the total business expenses…",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($H$29=\"Business\",$G$56=\"60% Expense Factor (non-services or product business)\"),\"Yes\",\"No\")","v":"No"},"Business & 60% Expense Factor"]
[]
[null,null,null,null,null,"Avg. Mo. Net Deposits",null,null,null,{"$f":"IF($H$31=12,$K$51/12,IF($H$31=24,$K$51/24,\"\"))","v":0},null,null,null,null,"Avg. Mo. Net Deposits",null,null,null,{"$f":"IF($H$31=12,$K$51/12,IF($H$31=24,$K$51/24,\"\"))","v":0},null,null,null,null,"Cost of Goods/Materials"]
[]
[null,null,null,null,null,"Multiply by Expense Factor",null,null,null,{"$f":"J65*(100%-J62)","v":0},null,null,null,null,"Multiply by Expense Factor",null,null,null,{"$f":"S65*(100%-S62)","v":0},null,null,null,null,"Labors/Wages (paid to others)"]
[]
[null,null,null,null,null,"Multiply by % Ownership",null,null,null,{"$f":"J67*H19","v":0},null,null,null,null,"Multiply by % Ownership",null,null,null,{"$f":"S67*H19","v":0},null,null,null,null,"Rent"]
[]
[null,null,null,null,"QUALIFYING INCOME",null,null,null,null,null,null,null,null,"QUALIFYING INCOME",null,null,null,null,null,null,null,null,null,"Auto/Truck/Insurance"]
[]
[null,null,null,null,null,"The lower of:",null,null,null,null,null,null,null,null,"The lower of:",null,null,null,null,null,null,null,null,"Other:"]
[]
[null,null,null,null,null,"(A) Mo. Income from Initial 1003: ",null,null,null,{"$f":"I22","v":0},null,null,null,null,"(A) Mo. Income from Initial 1003: ",null,null,null,{"$f":"I22","v":0},null,null,null,null,"Other:"]
[]
[null,null,null,null,null,"(B) Monthly Expense Stmt Calc:",null,null,null,{"$f":"J69","v":0},null,null,null,null,"(B) Monthly Expense Stmt Calc:",null,null,null,{"$f":"S69","v":0},null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,{"$f":"AD79/AD62","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"Qualifying Income:",null,null,null,{"$f":"MIN(J75,J77)","v":0},null,null,null,null,"Qualifying Income:",null,null,null,{"$f":"MIN(S75,S77)","v":0},null,null,null,null,null,null,null,null,"Total Expenses:",null,{"$f":"AD65+AD67+AD69+AD71+AD73+AD75+AD77","v":0},null,null,null,null,"If ≥ 35.00%",{"$f":"AD83/AD85","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Income:",null,{"$f":"AD62-AD79","v":0},null,null,null,null,"If < 35.00%",{"$f":"AD62*(100%-35%)","v":0},"Net less 35% floor"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Income x % ownership:",null,{"$f":"AD81*H19","v":0},null,null,null,null,null,{"$f":"AJ81*H19","v":0},"x % of ownership"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expense Ratio (P&L analysis):",{"$f":"AD79/AD62","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Total # of months of P&L analysis:",null,null,null,null,null,null,null,{"$f":"AD85","v":0},"# of months P&L Analysis"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(S85<35%,\"Note:  The expense ratio on the P&L is less than the floor of 35%.  Qualifying income has been adjusted using the minimum 35% Expense Ratio Factor.\",\"\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Net Income:",null,{"$f":"IF(AD79/AD62>=35%,AJ79,IF(AD79/AD62<35%,AJ87,\"\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"AJ83/AJ85","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H29=\"Personal\",\"PERSONAL BANK STATEMENT QUALIFYING INCOME\",\"QUALIFYING INCOME\")","v":"QUALIFYING INCOME"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The lower of:"]
[]
[null,null,"Notes / Comments (optional)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A) Monthly Income from Initial 1003:",null,null,null,null,null,{"$f":"I22","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H29=\"Personal\",\"(B) Average Monthly Deposits:\",\"(B) Monthly Net Income from P&L/ES:\")","v":"(B) Monthly Net Income from P&L/ES:"},null,null,null,null,null,{"$f":"IF(AND($H$29=\"Personal\",$H$31=12),$K$51/12,IF(AND($H$29=\"Personal\",$H$31=24),$K$51/24,IF($H$29=\"Business\",AD87,\"\")))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qualifying Income:",null,null,null,null,null,{"$f":"MIN(AD93,AD95)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2020-04-07"}]
[null,null,"Completed by",null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"Deposit Analysis","index":1,"n_rows":113,"n_cols":26,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,6,1,8],[3,6,3,7],[61,8,61,10],[61,20,61,22],[79,8,79,10],[79,20,79,22],[26,17,27,17],[26,18,26,24],[8,6,8,12],[8,13,9,13],[7,8,7,10],[7,20,7,22],[25,8,25,10],[25,20,25,22],[43,8,43,10],[43,20,43,22],[96,1,111,1],[96,3,96,13],[96,15,96,25],[98,3,99,3],[98,5,99,5],[98,6,98,12],[98,13,99,13],[98,25,99,25],[97,8,97,10],[97,20,97,22],[98,15,99,15],[98,17,99,17],[98,18,98,24],[80,13,81,13],[80,15,81,15],[80,17,81,17],[78,1,93,1],[78,3,78,13],[78,15,78,25],[80,3,81,3],[80,5,81,5],[80,6,80,12],[80,25,81,25],[80,18,80,24],[60,1,75,1],[60,3,60,13],[60,15,60,25],[62,3,63,3],[62,5,63,5],[62,6,62,12],[62,13,63,13],[62,15,63,15],[62,17,63,17],[62,18,62,24],[62,25,63,25],[26,25,27,25],[42,1,57,1],[42,3,42,13],[42,15,42,25],[44,3,45,3],[44,17,45,17],[44,18,44,24],[44,25,45,25],[44,5,45,5],[44,6,44,12],[44,13,45,13],[44,15,45,15],[26,15,27,15],[6,1,21,1],[24,1,39,1],[24,3,24,13],[24,15,24,25],[26,3,27,3],[26,5,27,5],[26,6,26,12],[26,13,27,13],[6,3,6,13],[6,15,6,25],[8,15,9,15],[8,17,9,17],[8,18,8,24],[8,25,9,25],[8,5,9,5],[8,3,9,3]]}
[]
[null,null,null,null,null,"Borrower Name: ",{"$f":"IF('Bank Stmt Calculator'!H13=\"\",\"\",'Bank Stmt Calculator'!H13)","v":""},null,null,null,"Entity/Business Name: ",{"$f":"IF('Bank Stmt Calculator'!H17=\"\",\"\",'Bank Stmt Calculator'!H17)","v":""}]
[]
[null,null,null,null,null,"Axos Loan Number: ",{"$f":"IF('Bank Stmt Calculator'!H15=\"\",\"\",'Bank Stmt Calculator'!H15)","v":""}]
[]
[]
[null,"BANK ACCOUNT # 1",null,"MOST RECENT 12 MO",null,null,null,null,null,null,null,null,null,null,null,"PREVIOUS 12 MO"]
[null,null,null,null,null,"End date of most recent statement: ",null,"Bank Name:",null,null,null,"Bank Acct Last 4 Digits: ",null,null,null,null,null,null,null,"Bank Name:",{"$f":"IF(I8=\"\",\"\",I8)","v":""},null,null,"Bank Acct Last 4 Digits: ",{"$f":"IF(M8=\"\",\"\",M8)","v":""}]
[null,null,null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits",null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits"]
[null,null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total",null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total"]
[null,null,null,{"$f":"TEXT(E11,\"MMMM\")&\" \"&TEXT(E11,\"YYYY\")","v":"January 1900"},{"$f":"G8","v":"00:00:00"},null,null,null,null,null,null,null,{"$f":"SUM(G11:K11)","v":0},{"$f":"F11-M11","v":0},null,{"$f":"TEXT(Q11,\"MMMM\")&\" \"&TEXT(Q11,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(E22,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,{"$f":"SUM(S11:W11)","v":0},{"$f":"R11-Y11","v":0}]
[null,null,null,{"$error":"#NUM!"},{"$f":"EDATE(E11,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$f":"EDATE(Q11,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(N11:N22)","v":0},null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(Z11:Z22)","v":0}]
[]
[null,"BANK ACCOUNT # 2",null,"MOST RECENT 12 MO",null,null,null,null,null,null,null,null,null,null,null,"PREVIOUS 12 MO"]
[null,null,null,null,null,"End date of most recent statement: ",null,"Bank Name:",null,null,null,"Bank Acct Last 4 Digits: ",null,null,null,null,null,null,null,"Bank Name:",{"$f":"IF(I26=\"\",\"\",I26)","v":""},null,null,"Bank Acct Last 4 Digits: ",{"$f":"IF(M26=\"\",\"\",M26)","v":""}]
[null,null,null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits",null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits"]
[null,null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total",null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total"]
[null,null,null,{"$f":"TEXT(E29,\"MMMM\")&\" \"&TEXT(E29,\"YYYY\")","v":"January 1900"},{"$f":"G26","v":"00:00:00"},null,null,null,null,null,null,null,{"$f":"SUM(G29:K29)","v":0},{"$f":"F29-M29","v":0},null,{"$f":"TEXT(Q29,\"MMMM\")&\" \"&TEXT(Q29,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(E40,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,{"$f":"SUM(S29:W29)","v":0},{"$f":"R29-Y29","v":0}]
[null,null,null,{"$error":"#NUM!"},{"$f":"EDATE(E29,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$f":"EDATE(Q29,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(N29:N40)","v":0},null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(Z29:Z40)","v":0}]
[]
[null,"BANK ACCOUNT # 3",null,"MOST RECENT 12 MO",null,null,null,null,null,null,null,null,null,null,null,"PREVIOUS 12 MO"]
[null,null,null,null,null,"End date of most recent statement: ",null,"Bank Name:",null,null,null,"Bank Acct Last 4 Digits: ",null,null,null,null,null,null,null,"Bank Name:",{"$f":"IF(I44=\"\",\"\",I44)","v":""},null,null,"Bank Acct Last 4 Digits: ",{"$f":"IF(M44=\"\",\"\",M44)","v":""}]
[null,null,null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits",null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits"]
[null,null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total",null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total"]
[null,null,null,{"$f":"TEXT(E47,\"MMMM\")&\" \"&TEXT(E47,\"YYYY\")","v":"January 1900"},{"$f":"G44","v":"00:00:00"},null,null,null,null,null,null,null,{"$f":"SUM(G47:K47)","v":0},{"$f":"F47-M47","v":0},null,{"$f":"TEXT(Q47,\"MMMM\")&\" \"&TEXT(Q47,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(E58,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,{"$f":"SUM(S47:W47)","v":0},{"$f":"R47-Y47","v":0}]
[null,null,null,{"$error":"#NUM!"},{"$f":"EDATE(E47,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$f":"TEXT(Q48,\"MMMM\")&\" \"&TEXT(Q48,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(Q47,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$f":"TEXT(Q49,\"MMMM\")&\" \"&TEXT(Q49,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(Q48,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$f":"TEXT(Q50,\"MMMM\")&\" \"&TEXT(Q50,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(Q49,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$f":"EDATE(Q50,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$f":"EDATE(Q51,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$f":"EDATE(Q52,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(N47:N58)","v":0},null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(Z47:Z58)","v":0}]
[]
[null,"BANK ACCOUNT # 4",null,"MOST RECENT 12 MO",null,null,null,null,null,null,null,null,null,null,null,"PREVIOUS 12 MO"]
[null,null,null,null,null,"End date of most recent statement: ",null,"Bank Name:",null,null,null,"Bank Acct Last 4 Digits: ",null,null,null,null,null,null,null,"Bank Name:",{"$f":"IF(I62=\"\",\"\",I62)","v":""},null,null,"Bank Acct Last 4 Digits: ",{"$f":"IF(M62=\"\",\"\",M62)","v":""}]
[null,null,null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits",null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits"]
[null,null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total",null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total"]
[null,null,null,{"$f":"TEXT(E65,\"MMMM\")&\" \"&TEXT(E65,\"YYYY\")","v":"January 1900"},{"$f":"G62","v":"00:00:00"},null,null,null,null,null,null,null,{"$f":"SUM(G65:K65)","v":0},{"$f":"F65-M65","v":0},null,{"$f":"TEXT(Q65,\"MMMM\")&\" \"&TEXT(Q65,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(E76,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,{"$f":"SUM(S65:W65)","v":0},{"$f":"R65-Y65","v":0}]
[null,null,null,{"$error":"#NUM!"},{"$f":"EDATE(E65,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$f":"TEXT(Q66,\"MMMM\")&\" \"&TEXT(Q66,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(Q65,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$f":"EDATE(E66,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$f":"TEXT(Q67,\"MMMM\")&\" \"&TEXT(Q67,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(Q66,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$f":"EDATE(E67,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$f":"TEXT(Q68,\"MMMM\")&\" \"&TEXT(Q68,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(Q67,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$f":"EDATE(Q68,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(N65:N76)","v":0},null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(Z65:Z76)","v":0}]
[]
[null,"BANK ACCOUNT # 5",null,"MOST RECENT 12 MO",null,null,null,null,null,null,null,null,null,null,null,"PREVIOUS 12 MO"]
[null,null,null,null,null,"End date of most recent statement: ",null,"Bank Name:",null,null,null,"Bank Acct Last 4 Digits: ",null,null,null,null,null,null,null,"Bank Name:",{"$f":"IF(I80=\"\",\"\",I80)","v":""},null,null,"Bank Acct Last 4 Digits: ",{"$f":"IF(M80=\"\",\"\",M80)","v":""}]
[null,null,null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits",null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits"]
[null,null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total",null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total"]
[null,null,null,{"$f":"TEXT(E83,\"MMMM\")&\" \"&TEXT(E83,\"YYYY\")","v":"January 1900"},{"$f":"G80","v":"00:00:00"},null,null,null,null,null,null,null,{"$f":"SUM(G83:K83)","v":0},{"$f":"F83-M83","v":0},null,{"$f":"TEXT(Q83,\"MMMM\")&\" \"&TEXT(Q83,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(E94,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,{"$f":"SUM(S83:W83)","v":0},{"$f":"R83-Y83","v":0}]
[null,null,null,{"$f":"TEXT(E84,\"MMMM\")&\" \"&TEXT(E84,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(E83,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$f":"TEXT(Q84,\"MMMM\")&\" \"&TEXT(Q84,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(Q83,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"TEXT(E85,\"MMMM\")&\" \"&TEXT(E85,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(E84,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$f":"TEXT(Q85,\"MMMM\")&\" \"&TEXT(Q85,\"YYYY\")","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"TEXT(E86,\"MMMM\")&\" \"&TEXT(E86,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(E85,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$f":"TEXT(Q86,\"MMMM\")&\" \"&TEXT(Q86,\"YYYY\")","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"TEXT(E87,\"MMMM\")&\" \"&TEXT(E87,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(E86,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$f":"EDATE(E87,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(N83:N94)","v":0},null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(Z83:Z94)","v":0}]
[]
[null,"BANK ACCOUNT # 6",null,"MOST RECENT 12 MO",null,null,null,null,null,null,null,null,null,null,null,"PREVIOUS 12 MO"]
[null,null,null,null,null,"End date of most recent statement: ",null,"Bank Name:",null,null,null,"Bank Acct Last 4 Digits: ",null,null,null,null,null,null,null,"Bank Name:",{"$f":"IF(I98=\"\",\"\",I98)","v":""},null,null,"Bank Acct Last 4 Digits: ",{"$f":"IF(M98=\"\",\"\",M98)","v":""}]
[null,null,null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits",null,"Month",null,"Total Deposits","Deposits NOT from business activity (EXCLUDE)",null,null,null,null,null,null,"Net Deposits"]
[null,null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total",null,null,null,null,null,"Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Description","Total"]
[null,null,null,{"$f":"TEXT(E101,\"MMMM\")&\" \"&TEXT(E101,\"YYYY\")","v":"January 1900"},{"$f":"G98","v":"00:00:00"},null,null,null,null,null,null,null,{"$f":"SUM(G101:K101)","v":0},{"$f":"F101-M101","v":0},null,{"$f":"TEXT(Q101,\"MMMM\")&\" \"&TEXT(Q101,\"YYYY\")","v":{"$error":"#NUM!"}},{"$f":"EDATE(E112,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,{"$f":"SUM(S101:W101)","v":0},{"$f":"R101-Y101","v":0}]
[null,null,null,{"$error":"#NUM!"},{"$f":"EDATE(E101,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$f":"EDATE(Q101,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$f":"EDATE(E102,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$f":"EDATE(Q102,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$f":"EDATE(E103,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$f":"EDATE(Q103,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$f":"EDATE(E104,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$f":"EDATE(Q104,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$f":"EDATE(Q105,-1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"TEXT(E107,\"MMMM\")&\" \"&TEXT(E107,\"YYYY\")","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(N101:N112)","v":0},null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(Z101:Z112)","v":0}]