{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Personal Bk Stmt Calculator","Sheet2"],"not_rendered":{"images":1,"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Personal Bk Stmt Calculator","index":0,"n_rows":46,"n_cols":22,"rows_kept":46,"merged":[[0,0,0,19],[1,0,1,19],[2,0,2,19],[3,0,3,1],[4,3,5,3],[4,4,5,4],[4,6,4,14],[5,6,5,12],[5,13,5,14],[6,6,6,12],[6,13,6,14],[7,3,8,3],[7,4,8,4],[7,6,7,12],[7,13,7,14],[8,6,8,12],[8,13,8,14],[9,6,9,12],[11,0,11,19],[12,0,12,19],[13,4,13,18],[38,17,38,18],[39,0,39,19],[40,0,40,19],[41,0,41,19],[42,0,42,19],[43,0,43,19],[44,0,44,19],[45,0,45,19]]}
["Personal Bank Statement Program Income Calculator"]
[]
[]
["Account Information"]
["Name on Account ","Acme Brick",null,"Choose 12 or 24 Months:",24,null,"Results Analysis"]
["Financial Institution ","Acme Bank",{"$nulls":4},"Total Qualifying Deposits:",{"$nulls":6},{"$f":"T39","v":{"v":240000,"d":"$240,000"}}]
["Account Number:",1313,{"$nulls":4}," Monthly Qualifying Income Based on Deposits:",{"$nulls":6},{"$f":"N6/E5","v":{"v":10000,"d":"$10,000"}}]
["Borrower Name:","joe doe",null,"Order of Bank Statements:","Descending",null,"PLEASE INPUT: Monthly Income entered on 1003:",{"$nulls":6},{"v":2000,"d":"$2,000"}]
["Underwriter:","Underwriter Name",{"$nulls":4},"Monthly Qualifying Income:",{"$nulls":6},{"$f":"MIN(N7:O8)","v":{"v":2000,"d":"$2,000"}}]
["ARC Loan Number:",1234]
["Date",{"$f":"TODAY()","v":"2020-11-13"}]
[]
[]
["Month","Statement End Date                                 (must be recent and consecutive)","*NSFs","Total Monthly Deposits","**Ineligible deposits to be subtracted  (input figures as positive numbers)",{"$nulls":14},"Total Adjusted Deposits"]
[1,"2020-10-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"$f":"SUM(D15,-(SUM(E15:S15)))","v":{"v":10000,"d":"$10,000"}},null,{"$f":"SUM(C15:C26)","v":0}]
[2,{"$f":"IF($E$8=\"Ascending\",EDATE(B15,1),EDATE(B15,-1))","v":"2020-09-20"},0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"$10,000"},null,{"$f":"SUM(C16:C27)","v":0}]
[3,{"$f":"IF($E$8=\"Ascending\",EDATE(B16,1),EDATE(B16,-1))","v":"2020-08-20"},0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"$10,000"},null,0]
[4,"2020-07-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"$10,000"},null,0]
[5,"2020-06-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"$10,000"},null,0]
[6,"2020-05-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"$10,000"},null,0]
[7,"2020-04-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"$10,000"},null,0]
[8,"2020-03-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"$10,000"},null,0]
[9,"2020-02-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"$10,000"},null,0]
[10,"2020-01-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"$10,000"},null,0]
[11,"2019-12-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"$10,000"},null,0]
[12,"2019-11-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"$10,000"},null,0]
[13,"2019-10-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[14,"2019-09-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[15,"2019-08-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[16,"2019-07-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[17,"2019-06-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[18,"2019-05-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[19,"2019-04-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[20,"2019-03-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[21,"2019-02-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[22,"2019-01-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[23,"2018-12-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[24,"2018-11-20",0,{"v":10000,"d":"$10,000"},{"$nulls":15},{"v":10000,"d":"10,000"},null,0]
[{"$nulls":17},"Total Allowable Deposits:",null,{"$f":"IF(E5=24,SUM(T15:T38),SUM(T15:T26))","v":{"v":240000,"d":"$240,000"}}]
[]
["* Only deposits can be used; transfers from a business account into a personal account are acceptable with proof, other transfers are not acceptable. "]
["** No more than 6 NSF in a consecutive 12-month period"]
["DISCLAIMER:"]
["The information provided via this calculator are intended for illustrative purposes for mortgage professionals only; accuracy is not guaranteed.  "]
["The results provided do not constitute either a pre-qualification or a credit decision.  "]
["Qualification for loan programs that are offered by Arc Home requires specific borrower, property and other applicable information to be reviewed by an Arc Home underwriter."]

{"sheet":"Sheet2","index":1,"n_rows":6,"n_cols":9,"rows_kept":6,"hidden":true}
[12,{"$nulls":7},{"$f":"MAX('Personal Bk Stmt Calculator'!V15:V38)","v":0}]
[24]
[]
[]
["Ascending"]
["Descending"]