{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Asset Utilization Calculator","Input Additional Assets Here","formulas"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":5,"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":"Asset Utilization Calculator","index":0,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[[45,0,45,5],[35,3,35,4],[26,3,26,4],[38,3,38,4],[36,3,36,4],[37,3,37,4],[27,3,27,4],[41,3,41,5],[39,3,39,4],[33,0,33,5],[34,3,34,4],[29,3,29,5],[43,3,43,4],[28,3,28,5],[30,3,30,4],[31,3,31,4],[0,0,2,5],[4,3,4,4],[19,3,19,5],[22,3,22,4],[23,3,23,4],[24,3,24,4],[3,1,3,2],[9,3,9,4],[10,3,10,4],[16,3,16,5],[18,3,18,4],[14,3,14,4],[15,3,15,5],[40,3,40,5],[42,3,42,4],[3,3,3,5],[25,3,25,4],[21,0,21,5],[17,3,17,4],[4,1,4,2],[5,1,5,2],[6,1,6,2],[12,3,12,4],[13,3,13,4],[11,3,11,4],[8,0,8,5],[5,3,6,4],[5,5,6,5],[7,0,7,5],[54,0,54,5],[52,0,52,5],[53,0,53,5],[46,0,48,5],[49,0,49,5],[50,0,50,5],[51,0,51,5]]}
[" Asset Utilization Worksheet (Arc Elite and Arc Access)"]
[]
[]
["Loan Number:",null,null,"Income Calculation"]
["Borrower Name:",null,null,"TOTAL of Eligible Qualifying Assets:",null,{"$f":"F19+F32+F44+'Input Additional Assets Here'!F11+'Input Additional Assets Here'!F23+'Input Additional Assets Here'!F35+'Input Additional Assets Here'!F47+'Input Additional Assets Here'!F59+'Input Additional Assets Here'!F71+'Input Additional Assets Here'!F83","v":0}]
["Product:","Arc Access",null,"Qualifying Monthly Income Derived from Assets Utilization:",null,{"$f":"IF(B6=\"Arc Elite\",F5/120,F5/60)","v":0}]
["Calculator Completed by:"]
[]
["Account #1:"]
["Type of Account:",null,null,{"$f":"IF($B$6=\"Arc Access\",\"Ending Balance:\",\"Average Balance:\")","v":"Ending Balance:"},null,{"$f":"IF(B14>0,IF($B$6=\"Arc Elite\",AVERAGE(B14:B19),B14),0)","v":500000}]
["Bank/Financial Institution:",null,null,{"$f":"IF($B$6=\"Arc Elite\",\"Variance between Most Recent Statement & Average Balance:\",\"Variance between Most Recent Statement & Prior Month's Balance:\")","v":"Variance between Most Recent Statement & Prior Month's Balance:"},null,{"$f":"IF(B14>0,IF($B$6=\"Arc Elite\",(B14-F10)/F10,(B14-B15)/B15),0)","v":-0.16666666666666666}]
["Account Number:",null,null,{"$f":"IF(AND($B$6=\"Arc Elite\",F11>10%),\"Is the source of the increase of funds documented?\",\"\")","v":""}]
["Statements","Ending Account Balance",null,"Total Down Payment, Closing Costs and Reserves (if coming from this account):",null,387500]
["Month 1 Statement (Most Recent Statement)",500000,null,"Most recent ending balance, after deducting DP, CC, and Reserves:",null,{"$f":"B14-F13","v":112500}]
["Month 2 Statement",600000,null,"Eligible Asset Balance for inclusion, after deducting DP, CC and Reserves:",null,{"$f":"IF(AND($B$6=\"Arc Elite\",F11>0.1,F12=\"No\"),\"Manually deduct any unsourced large deposits from all applicable ending balances before proceeding\",F14)","v":112500}]
["Month 3 Statement",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 4 Statement ",null,null,{"$f":"IF(AND($B$6=\"Arc Elite\",F11>10%),\"Ending Balance of Most Recent Statement is >10% above the average; use the ending balance if the source of the increase is documented; otherwise deduct the large deposit from all applicable ending balances in order to recalculate the average\",IF(AND($B$6=\"Arc Access\",F11>10%),\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Arc Home Underwriting Manager must approve use of the income\",IF(F11<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, Arc Home Underwriting Manager must approve use of the income\",\"Ending Balance of the Most Recent Statement must be used\")))","v":"Ending Balance of Most Recent Statement is > 10% less than the average, Arc Home Underwriting Manager must approve use of the income"}]
["Month 5 Statement ",null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B10=\"\"),VLOOKUP(B10,asset,2,FALSE),0)","v":0}]
["Month 6 Statement ",null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F15*F18","v":0}]
[]
[]
["Account #2:"]
["Type of Account:",null,null,{"$f":"IF($B$6=\"Arc Access\",\"Ending Balance:\",\"Average Balance:\")","v":"Ending Balance:"},null,{"$f":"IF(B27>0,IF($B$6=\"Arc Elite\",AVERAGE(B27:B32),B27),0)","v":0}]
["Bank/Financial Institution:",null,null,{"$f":"IF($B$6=\"Arc Elite\",\"Variance between Most Recent Statement & Average Balance:\",\"Variance between Most Recent Statement & Prior Month's Balance:\")","v":"Variance between Most Recent Statement & Prior Month's Balance:"},null,{"$f":"IF(B27>0,IF($B$6=\"Arc Elite\",(B27-F23)/F23,(B27-B28)/B28),0)","v":0}]
["Account Number:",null,null,{"$f":"IF(AND($B$6=\"Arc Elite\",F24>10%),\"Is the source of the increase of funds documented?\",\"\")","v":""}]
["Statements","Ending Account Balance",null,"Total Down Payment, Closing Costs and Reserves (if coming from this account):"]
["Month 1 Statement (Most Recent Statement)",null,null,"Most recent ending balance, after deducting DP, CC, and Reserves:",null,{"$f":"B27-F26","v":0}]
["Month 2 Statement",null,null,"Eligible Asset Balance for inclusion, after deducting DP, CC and Reserves:",null,{"$f":"IF(AND($B$6=\"Arc Elite\",F24>0.1,F25=\"No\"),\"Manually deduct any unsourced large deposits from all applicable ending balances before proceeding\",F27)","v":0}]
["Month 3 Statement",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 4 Statement ",null,null,{"$f":"IF(AND($B$6=\"Arc Elite\",F24>10%),\"Ending Balance of Most Recent Statement is >10% above the average; use the ending balance if the source of the increase is documented; otherwise deduct the large deposit from all applicable ending balances in order to recalculate the average\",IF(AND($B$6=\"Arc Access\",F24>10%),\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Arc Home Underwriting Manager must approve use of the income\",IF(F24<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, Arc Home Underwriting Manager must approve use of the income\",\"Ending Balance of the Most Recent Statement must be used\")))","v":"Ending Balance of the Most Recent Statement must be used"}]
["Month 5 Statement ",null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B23=\"\"),VLOOKUP(B23,asset,2,FALSE),0)","v":0}]
["Month 6 Statement ",null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F28*F31","v":0}]
[]
["Account #3:"]
["Type of Account:",null,null,{"$f":"IF($B$6=\"Arc Access\",\"Ending Balance:\",\"Average Balance:\")","v":"Ending Balance:"},null,{"$f":"IF(B39>0,IF($B$6=\"Arc Elite\",AVERAGE(B39:B44),B39),0)","v":0}]
["Bank/Financial Institution:",null,null,{"$f":"IF($B$6=\"Arc Elite\",\"Variance between Most Recent Statement & Average Balance:\",\"Variance between Most Recent Statement & Prior Month's Balance:\")","v":"Variance between Most Recent Statement & Prior Month's Balance:"},null,{"$f":"IF(B39>0,IF($B$6=\"Arc Elite\",(B39-F35)/F35,(B39-B40)/B40),0)","v":0}]
["Account Number:",null,null,{"$f":"IF(AND($B$6=\"Arc Elite\",F36>10%),\"Is the source of the increase of funds documented?\",\"\")","v":""}]
["Statements","Ending Account Balance",null,"Total Down Payment, Closing Costs and Reserves (if coming from this account):"]
["Month 1 Statement (Most Recent Statement)",null,null,"Most recent ending balance, after deducting DP, CC, and Reserves:",null,{"$f":"B39-F38","v":0}]
["Month 2 Statement",null,null,"Eligible Asset Balance for inclusion, after deducting DP, CC and Reserves:",null,{"$f":"IF(AND($B$6=\"Arc Elite\",F36>0.1,F37=\"No\"),\"Manually deduct any unsourced large deposits from all applicable ending balances before proceeding\",F39)","v":0}]
["Month 3 Statement",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 4 Statement ",null,null,{"$f":"IF(AND($B$6=\"Arc Elite\",F36>10%),\"Ending Balance of Most Recent Statement is >10% above the average; use the ending balance if the source of the increase is documented; otherwise deduct the large deposit from all applicable ending balances in order to recalculate the average\",IF(AND($B$6=\"Arc Access\",F36>10%),\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Arc Home Underwriting Manager must approve use of the income\",IF(F36<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, Arc Home Underwriting Manager must approve use of the income\",\"Ending Balance of the Most Recent Statement must be used\")))","v":"Ending Balance of the Most Recent Statement must be used"}]
["Month 5 Statement ",null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B35=\"\"),VLOOKUP(B35,asset,2,FALSE),0)","v":0}]
["Month 6 Statement ",null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F40*F43","v":0}]
[]
["Comments:"]
[]
[]
[]
[]
["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."]
["The calculation results provided are subject to change at the time of Underwriting.  New or updated documentation, and/or loan specifics may require a revised calculation for the purposes of qualifying.  "]

{"sheet":"Input Additional Assets Here","index":1,"n_rows":83,"n_cols":6,"rows_kept":83,"cut":false,"hidden":false,"merged":[[12,0,12,5],[44,3,44,5],[38,3,38,4],[36,0,36,5],[37,3,37,4],[18,3,18,4],[20,3,20,5],[19,3,19,5],[21,3,21,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[22,3,22,4],[25,3,25,4],[78,3,78,4],[80,3,80,5],[79,3,79,5],[81,3,81,4],[82,3,82,4],[77,3,77,4],[65,3,65,4],[72,0,72,5],[73,3,73,4],[74,3,74,4],[75,3,75,4],[76,3,76,4],[66,3,66,4],[68,3,68,5],[67,3,67,5],[69,3,69,4],[70,3,70,4],[48,0,48,5],[49,3,49,4],[50,3,50,4],[42,3,42,4],[54,3,54,4],[52,3,52,4],[53,3,53,4],[39,3,39,4],[31,3,31,5],[33,3,33,4],[34,3,34,4],[43,3,43,5],[10,3,10,4],[0,0,0,5],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[8,3,8,5],[7,3,7,5],[9,3,9,4],[24,0,24,5],[40,3,40,4],[41,3,41,4],[57,3,57,4],[58,3,58,4],[56,3,56,5],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[32,3,32,5],[45,3,45,4],[46,3,46,4],[55,3,55,5],[51,3,51,4],[64,3,64,4],[62,3,62,4],[63,3,63,4],[60,0,60,5],[61,3,61,4]]}
["Account #4:"]
["Type of Account:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Access\",\"Ending Balance:\",\"Average Balance:\")","v":"Ending Balance:"},null,{"$f":"IF(B6>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",AVERAGE(B6:B11),B6),0)","v":0}]
["Bank/Financial Institution:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",\"Variance between Most Recent Statement & Average Balance:\",\"Variance between Most Recent Statement & Prior Month's Balance:\")","v":"Variance between Most Recent Statement & Prior Month's Balance:"},null,{"$f":"IF(B6>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",(B6-F2)/F2,(B6-B7)/B7),0)","v":0}]
["Account Number:",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F3>10%),\"Is the source of the increase of funds documented?\",\"\")","v":""}]
["Statements","Ending Account Balance",null,"Total Down Payment, Closing Costs and Reserves (if coming from this account):"]
["Month 1 Statement (Most Recent Statement)",null,null,"Most recent ending balance, after deducting DP, CC, and Reserves:",null,{"$f":"B6-F5","v":0}]
["Month 2 Statement",null,null,"Eligible Asset Balance for inclusion, after deducting DP, CC and Reserves:",null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F3>0.1,F4=\"No\"),\"Manually deduct any unsourced large deposits from all applicable ending balances before proceeding\",F6)","v":0}]
["Month 3 Statement",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 4 Statement ",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F3>10%),\"Ending Balance of Most Recent Statement is >10% above the average; use the ending balance if the source of the increase is documented; otherwise deduct the large deposit from all applicable ending balances in order to recalculate the average\",IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Access\",F3>10%),\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Arc Home Underwriting Manager must approve use of the income\",IF(F3<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, Arc Home Underwriting Manager must approve use of the income\",\"Ending Balance of the Most Recent Statement must be used\")))","v":"Ending Balance of the Most Recent Statement must be used"}]
["Month 5 Statement ",null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B2=\"\"),VLOOKUP(B2,asset,2,FALSE),0)","v":0}]
["Month 6 Statement ",null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F7*F10","v":0}]
[]
["Account #5:"]
["Type of Account:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Access\",\"Ending Balance:\",\"Average Balance:\")","v":"Ending Balance:"},null,{"$f":"IF(B18>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",AVERAGE(B18:B23),B18),0)","v":0}]
["Bank/Financial Institution:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",\"Variance between Most Recent Statement & Average Balance:\",\"Variance between Most Recent Statement & Prior Month's Balance:\")","v":"Variance between Most Recent Statement & Prior Month's Balance:"},null,{"$f":"IF(B18>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",(B18-F14)/F14,(B18-B19)/B19),0)","v":0}]
["Account Number:",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F15>10%),\"Is the source of the increase of funds documented?\",\"\")","v":""}]
["Statements","Ending Account Balance",null,"Total Down Payment, Closing Costs and Reserves (if coming from this account):"]
["Month 1 Statement (Most Recent Statement)",null,null,"Most recent ending balance, after deducting DP, CC, and Reserves:",null,{"$f":"B18-F17","v":0}]
["Month 2 Statement",null,null,"Eligible Asset Balance for inclusion, after deducting DP, CC and Reserves:",null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F15>0.1,F16=\"No\"),\"Manually deduct any unsourced large deposits from all applicable ending balances before proceeding\",F18)","v":0}]
["Month 3 Statement",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 4 Statement ",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F15>10%),\"Ending Balance of Most Recent Statement is >10% above the average; use the ending balance if the source of the increase is documented; otherwise deduct the large deposit from all applicable ending balances in order to recalculate the average\",IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Access\",F15>10%),\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Arc Home Underwriting Manager must approve use of the income\",IF(F15<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, Arc Home Underwriting Manager must approve use of the income\",\"Ending Balance of the Most Recent Statement must be used\")))","v":"Ending Balance of the Most Recent Statement must be used"}]
["Month 5 Statement ",null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B14=\"\"),VLOOKUP(B14,asset,2,FALSE),0)","v":0}]
["Month 6 Statement ",null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F19*F22","v":0}]
[]
["Account #6:"]
["Type of Account:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Access\",\"Ending Balance:\",\"Average Balance:\")","v":"Ending Balance:"},null,{"$f":"IF(B30>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",AVERAGE(B30:B35),B30),0)","v":0}]
["Bank/Financial Institution:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",\"Variance between Most Recent Statement & Average Balance:\",\"Variance between Most Recent Statement & Prior Month's Balance:\")","v":"Variance between Most Recent Statement & Prior Month's Balance:"},null,{"$f":"IF(B30>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",(B30-F26)/F26,(B30-B31)/B31),0)","v":0}]
["Account Number:",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F27>10%),\"Is the source of the increase of funds documented?\",\"\")","v":""}]
["Statements","Ending Account Balance",null,"Total Down Payment, Closing Costs and Reserves (if coming from this account):"]
["Month 1 Statement (Most Recent Statement)",null,null,"Most recent ending balance, after deducting DP, CC, and Reserves:",null,{"$f":"B30-F29","v":0}]
["Month 2 Statement",null,null,"Eligible Asset Balance for inclusion, after deducting DP, CC and Reserves:",null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F27>0.1,F28=\"No\"),\"Manually deduct any unsourced large deposits from all applicable ending balances before proceeding\",F30)","v":0}]
["Month 3 Statement",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 4 Statement ",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F27>10%),\"Ending Balance of Most Recent Statement is >10% above the average; use the ending balance if the source of the increase is documented; otherwise deduct the large deposit from all applicable ending balances in order to recalculate the average\",IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Access\",F27>10%),\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Arc Home Underwriting Manager must approve use of the income\",IF(F27<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, Arc Home Underwriting Manager must approve use of the income\",\"Ending Balance of the Most Recent Statement must be used\")))","v":"Ending Balance of the Most Recent Statement must be used"}]
["Month 5 Statement ",null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B26=\"\"),VLOOKUP(B26,asset,2,FALSE),0)","v":0}]
["Month 6 Statement ",null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F31*F34","v":0}]
[]
["Account #7:"]
["Type of Account:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Access\",\"Ending Balance:\",\"Average Balance:\")","v":"Ending Balance:"},null,{"$f":"IF(B42>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",AVERAGE(B42:B47),B42),0)","v":0}]
["Bank/Financial Institution:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",\"Variance between Most Recent Statement & Average Balance:\",\"Variance between Most Recent Statement & Prior Month's Balance:\")","v":"Variance between Most Recent Statement & Prior Month's Balance:"},null,{"$f":"IF(B42>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",(B42-F38)/F38,(B42-B43)/B43),0)","v":0}]
["Account Number:",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F39>10%),\"Is the source of the increase of funds documented?\",\"\")","v":""}]
["Statements","Ending Account Balance",null,"Total Down Payment, Closing Costs and Reserves (if coming from this account):"]
["Month 1 Statement (Most Recent Statement)",null,null,"Most recent ending balance, after deducting DP, CC, and Reserves:",null,{"$f":"B42-F41","v":0}]
["Month 2 Statement",null,null,"Eligible Asset Balance for inclusion, after deducting DP, CC and Reserves:",null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F39>0.1,F40=\"No\"),\"Manually deduct any unsourced large deposits from all applicable ending balances before proceeding\",F42)","v":0}]
["Month 3 Statement",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 4 Statement ",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F39>10%),\"Ending Balance of Most Recent Statement is >10% above the average; use the ending balance if the source of the increase is documented; otherwise deduct the large deposit from all applicable ending balances in order to recalculate the average\",IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Access\",F39>10%),\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Arc Home Underwriting Manager must approve use of the income\",IF(F39<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, Arc Home Underwriting Manager must approve use of the income\",\"Ending Balance of the Most Recent Statement must be used\")))","v":"Ending Balance of the Most Recent Statement must be used"}]
["Month 5 Statement ",null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B38=\"\"),VLOOKUP(B38,asset,2,FALSE),0)","v":0}]
["Month 6 Statement ",null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F43*F46","v":0}]
[]
["Account #8:"]
["Type of Account:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Access\",\"Ending Balance:\",\"Average Balance:\")","v":"Ending Balance:"},null,{"$f":"IF(B54>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",AVERAGE(B54:B59),B54),0)","v":0}]
["Bank/Financial Institution:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",\"Variance between Most Recent Statement & Average Balance:\",\"Variance between Most Recent Statement & Prior Month's Balance:\")","v":"Variance between Most Recent Statement & Prior Month's Balance:"},null,{"$f":"IF(B54>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",(B54-F50)/F50,(B54-B55)/B55),0)","v":0}]
["Account Number:",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F51>10%),\"Is the source of the increase of funds documented?\",\"\")","v":""}]
["Statements","Ending Account Balance",null,"Total Down Payment, Closing Costs and Reserves (if coming from this account):"]
["Month 1 Statement (Most Recent Statement)",null,null,"Most recent ending balance, after deducting DP, CC, and Reserves:",null,{"$f":"B54-F53","v":0}]
["Month 2 Statement",null,null,"Eligible Asset Balance for inclusion, after deducting DP, CC and Reserves:",null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F51>0.1,F52=\"No\"),\"Manually deduct any unsourced large deposits from all applicable ending balances before proceeding\",F54)","v":0}]
["Month 3 Statement",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 4 Statement ",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F51>10%),\"Ending Balance of Most Recent Statement is >10% above the average; use the ending balance if the source of the increase is documented; otherwise deduct the large deposit from all applicable ending balances in order to recalculate the average\",IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Access\",F51>10%),\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Arc Home Underwriting Manager must approve use of the income\",IF(F51<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, Arc Home Underwriting Manager must approve use of the income\",\"Ending Balance of the Most Recent Statement must be used\")))","v":"Ending Balance of the Most Recent Statement must be used"}]
["Month 5 Statement ",null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B50=\"\"),VLOOKUP(B50,asset,2,FALSE),0)","v":0}]
["Month 6 Statement ",null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F55*F58","v":0}]
[]
["Account #9:"]
["Type of Account:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Access\",\"Ending Balance:\",\"Average Balance:\")","v":"Ending Balance:"},null,{"$f":"IF(B66>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",AVERAGE(B66:B71),B66),0)","v":0}]
["Bank/Financial Institution:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",\"Variance between Most Recent Statement & Average Balance:\",\"Variance between Most Recent Statement & Prior Month's Balance:\")","v":"Variance between Most Recent Statement & Prior Month's Balance:"},null,{"$f":"IF(B66>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",(B66-F62)/F62,(B66-B67)/B67),0)","v":0}]
["Account Number:",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F63>10%),\"Is the source of the increase of funds documented?\",\"\")","v":""}]
["Statements","Ending Account Balance",null,"Total Down Payment, Closing Costs and Reserves (if coming from this account):"]
["Month 1 Statement (Most Recent Statement)",null,null,"Most recent ending balance, after deducting DP, CC, and Reserves:",null,{"$f":"B66-F65","v":0}]
["Month 2 Statement",null,null,"Eligible Asset Balance for inclusion, after deducting DP, CC and Reserves:",null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F63>0.1,F64=\"No\"),\"Manually deduct any unsourced large deposits from all applicable ending balances before proceeding\",F66)","v":0}]
["Month 3 Statement",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 4 Statement ",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F63>10%),\"Ending Balance of Most Recent Statement is >10% above the average; use the ending balance if the source of the increase is documented; otherwise deduct the large deposit from all applicable ending balances in order to recalculate the average\",IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Access\",F63>10%),\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Arc Home Underwriting Manager must approve use of the income\",IF(F63<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, Arc Home Underwriting Manager must approve use of the income\",\"Ending Balance of the Most Recent Statement must be used\")))","v":"Ending Balance of the Most Recent Statement must be used"}]
["Month 5 Statement ",null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B62=\"\"),VLOOKUP(B62,asset,2,FALSE),0)","v":0}]
["Month 6 Statement ",null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F67*F70","v":0}]
[]
["Account #10:"]
["Type of Account:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Access\",\"Ending Balance:\",\"Average Balance:\")","v":"Ending Balance:"},null,{"$f":"IF(B78>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",AVERAGE(B78:B83),B78),0)","v":0}]
["Bank/Financial Institution:",null,null,{"$f":"IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",\"Variance between Most Recent Statement & Average Balance:\",\"Variance between Most Recent Statement & Prior Month's Balance:\")","v":"Variance between Most Recent Statement & Prior Month's Balance:"},null,{"$f":"IF(B78>0,IF('Asset Utilization Calculator'!$B$6=\"Arc Elite\",(B78-F74)/F74,(B78-B79)/B79),0)","v":0}]
["Account Number:",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F75>10%),\"Is the source of the increase of funds documented?\",\"\")","v":""}]
["Statements","Ending Account Balance",null,"Total Down Payment, Closing Costs and Reserves (if coming from this account):"]
["Month 1 Statement (Most Recent Statement)",null,null,"Most recent ending balance, after deducting DP, CC, and Reserves:",null,{"$f":"B78-F77","v":0}]
["Month 2 Statement",null,null,"Eligible Asset Balance for inclusion, after deducting DP, CC and Reserves:",null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F75>0.1,F76=\"No\"),\"Manually deduct any unsourced large deposits from all applicable ending balances before proceeding\",F78)","v":0}]
["Month 3 Statement",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 4 Statement ",null,null,{"$f":"IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Elite\",F75>10%),\"Ending Balance of Most Recent Statement is >10% above the average; use the ending balance if the source of the increase is documented; otherwise deduct the large deposit from all applicable ending balances in order to recalculate the average\",IF(AND('Asset Utilization Calculator'!$B$6=\"Arc Access\",F75>10%),\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Arc Home Underwriting Manager must approve use of the income\",IF(F75<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, Arc Home Underwriting Manager must approve use of the income\",\"Ending Balance of the Most Recent Statement must be used\")))","v":"Ending Balance of the Most Recent Statement must be used"}]
["Month 5 Statement ",null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B74=\"\"),VLOOKUP(B74,asset,2,FALSE),0)","v":0}]
["Month 6 Statement ",null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F79*F82","v":0}]

{"sheet":"formulas","index":2,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
["Checking/Savings/CD/Money Market",1]
["Stocks/Bonds/MutualFunds/Retirement Funds if >=59 1/2",0.7]
["Retirement Funds if <59 1/2",0.5]
[]
["Yes"]
["No"]
[]
[]
["Arc Elite"]
["Arc Access"]
[]
[]
[]
[]
[]
["total in account",150000]
["eligible %",0.7]
["closing costs",10000]
["final",{"$f":"(B17*B18)-B19","v":95000}]
[]
[]
["total in account",150000]
["eligible %",0.7]
["closing costs",10000]
["final",{"$f":"(B23-B25)*B24","v":98000}]