{"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":1,"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":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[26,3,26,4],[22,0,22,5],[15,3,15,4],[14,3,14,4],[11,0,11,5],[12,3,12,4],[13,3,13,4],[16,3,16,5],[17,3,17,5],[18,3,18,4],[19,3,19,4],[0,0,2,5],[4,3,4,4],[52,0,52,5],[50,0,50,5],[51,0,51,5],[44,0,46,5],[47,0,47,5],[48,0,48,5],[49,0,49,5],[20,3,20,5],[23,3,23,4],[24,3,24,4],[25,3,25,4],[3,1,3,2],[5,3,5,4],[3,3,3,5],[43,0,43,5],[35,3,35,4],[36,3,36,4],[37,3,37,4],[33,0,33,5],[34,3,34,4],[38,3,38,5],[39,3,39,5],[40,3,40,4],[41,3,41,4],[42,3,42,5],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,0,10,5],[27,3,27,5],[28,3,28,5],[29,3,29,4],[30,3,30,4],[31,3,31,5]]}
[" Asset Qualifier Worksheet (Arc Access Only)"]
[]
[]
["Loan Number:",null,null,"Income Calculation"]
["Borrower Name:",null,null,"TOTAL of Eligible Qualifying Assets:",null,{"$f":"F20+F31+F42+'Input Additional Assets Here'!F9+'Input Additional Assets Here'!F20+'Input Additional Assets Here'!F31+'Input Additional Assets Here'!F42+'Input Additional Assets Here'!F53+'Input Additional Assets Here'!F64+'Input Additional Assets Here'!F75","v":0}]
["Option 1 vs Option 2:","Option 1",null,{"$f":"IF(B6=\"Option 1\",\"Assets required to cover loan amount, DP, CC, PP, and 60 months of obligations\",\"Post Closing Assets Required\")","v":"Assets required to cover loan amount, DP, CC, PP, and 60 months of obligations"},null,{"$f":"IF(B6=\"Option 1\",B7+F15+F26+F37+'[1]Input Additional Assets Here'!F4+'[1]Input Additional Assets Here'!F15+'[1]Input Additional Assets Here'!F26+'[1]Input Additional Assets Here'!F37+'[1]Input Additional Assets Here'!F48+'[1]Input Additional Assets Here'!F59+'[1]Input Additional Assets Here'!F70+(B8*60),((1.25*B7)))","v":0}]
["Loan Amount:",null,null,"Residual Income:",null,{"$f":"(F5/60)-B8","v":0}]
["Monthly Obligations (Subject PITIA and all debt):",null,null,"Are the Post Closing Assets sufficient?",null,{"$f":"IF(B7>0,IF(F5>F6,\"YES, Post Closing Assets are Sufficient\",\"NO, Insufficient Post Closing Assets\"),\"\")","v":""}]
["Calculator Completed by:",null,null,"Is the Residual Income sufficient and does the borrower qualify?",null,{"$f":"IF(B7>0,IF(AND(B6=\"Option 1\",F7>=2000),\"YES, Residual Income Meets Guideline Requirements\",IF(AND(B6=\"Option 2\",B7>2000000,F7>=5500),\"YES, Residual Income Meets Guideline Requirements\",IF(AND(B6=\"Option 2\",B7<=2000000,F7>=3500),\"YES, Residual Income Meets Guideline Requirements\",\"NO, Residual income is not sufficient to meet guideline requirements\"))),\"\")","v":""}]
[null,null,null,"Does the borrower qualify?",null,{"$f":"IF(NOT(F9=\"\"),IF(AND(F8=\"Yes, Post Closing Assets are Sufficient\",F9=\"Yes, Residual income meets guideline requirements\"),\"YES\",\"NO\"),\"\")","v":""}]
[]
["Account #1:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B17","v":0}]
["Bank/Financial Institution:",null,null,"Variance between Most Recent Statement & Prior Month's Balance:",null,{"$f":"IF(B17>0,((B17-B18)/B18),0)","v":0}]
["Account Number:",null,null,"Total Down Payment, Closing Costs, Prepaids, and Reserves (if coming from this account):"]
["Statements","Ending Account Balance",null,"Most recent ending balance, after deducting DP, CC, PP, and Reserves:",null,{"$f":"B17-F15","v":0}]
["Month 1 Statement (Most Recent Statement)",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 2 Statement",null,null,{"$f":"IF(F14>10%,\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Underwriting Manager must approve use of the income\",IF(F14<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, 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"}]
[null,null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B13=\"\"),VLOOKUP(B13,asset,2,FALSE),0)","v":0}]
[null,null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F16*F19","v":0}]
[]
[]
["Account #2:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B28","v":0}]
["Bank/Financial Institution:",null,null,"Variance between Most Recent Statement & Prior Month's Balance:",null,{"$f":"IF(B28>0,((B28-B29)/B29),0)","v":0}]
["Account Number:",null,null,"Total Down Payment, Closing Costs, Prepaids, and Reserves (if coming from this account):"]
["Statements","Ending Account Balance",null,"Most recent ending balance, after deducting DP, CC, PP, and Reserves:",null,{"$f":"B28-F26","v":0}]
["Month 1 Statement (Most Recent Statement)",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 2 Statement",null,null,{"$f":"IF(F25>10%,\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Underwriting Manager must approve use of the income\",IF(F25<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, 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"}]
[null,null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B24=\"\"),VLOOKUP(B24,asset,2,FALSE),0)","v":0}]
[null,null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F27*F30","v":0}]
[]
[]
["Account #3:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B39","v":0}]
["Bank/Financial Institution:",null,null,"Variance between Most Recent Statement & Prior Month's Balance:",null,{"$f":"IF(B39>0,((B39-B40)/B40),0)","v":0}]
["Account Number:",null,null,"Total Down Payment, Closing Costs, Prepaids, and Reserves (if coming from this account):"]
["Statements","Ending Account Balance",null,"Most recent ending balance, after deducting DP, CC, PP, and Reserves:",null,{"$f":"B39-F37","v":0}]
["Month 1 Statement (Most Recent Statement)",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 2 Statement",null,null,{"$f":"IF(F36>10%,\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Underwriting Manager must approve use of the income\",IF(F36<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, 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"}]
[null,null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B35=\"\"),VLOOKUP(B35,asset,2,FALSE),0)","v":0}]
[null,null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F38*F41","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":75,"n_cols":6,"rows_kept":75,"cut":false,"hidden":false,"merged":[[37,3,37,4],[24,3,24,4],[25,3,25,4],[5,3,5,5],[6,3,6,5],[7,3,7,4],[8,3,8,4],[9,3,9,5],[11,0,11,5],[35,3,35,4],[33,0,33,5],[34,3,34,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[0,0,0,5],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[62,3,62,4],[63,3,63,4],[64,3,64,5],[71,3,71,5],[44,0,44,5],[45,3,45,4],[46,3,46,4],[48,3,48,4],[50,3,50,5],[59,3,59,4],[57,3,57,4],[58,3,58,4],[55,0,55,5],[56,3,56,4],[52,3,52,4],[53,3,53,5],[72,3,72,5],[73,3,73,4],[74,3,74,4],[75,3,75,5],[66,0,66,5],[67,3,67,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[23,3,23,4],[26,3,26,4],[16,3,16,5],[17,3,17,5],[18,3,18,4],[19,3,19,4],[20,3,20,5],[22,0,22,5],[27,3,27,5],[60,3,60,5],[61,3,61,5],[28,3,28,5],[29,3,29,4],[30,3,30,4],[31,3,31,5],[51,3,51,4],[39,3,39,5],[40,3,40,4],[41,3,41,4],[42,3,42,5],[49,3,49,5],[47,3,47,4],[36,3,36,4],[38,3,38,5]]}
["Account #4:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B6","v":0}]
["Bank/Financial Institution:",null,null,"Variance between Most Recent Statement & Prior Month's Balance:",null,{"$f":"IF(B6>0,((B6-B7)/B7),0)","v":0}]
["Account Number:",null,null,"Total Down Payment, Closing Costs, Prepaids, and Reserves (if coming from this account):"]
["Statements","Ending Account Balance",null,"Most recent ending balance, after deducting DP, CC, PP, and Reserves:",null,{"$f":"B6-F4","v":0}]
["Month 1 Statement (Most Recent Statement)",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 2 Statement",null,null,{"$f":"IF(F3>10%,\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Underwriting Manager must approve use of the income\",IF(F3<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, 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"}]
[null,null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B2=\"\"),VLOOKUP(B2,asset,2,FALSE),0)","v":0}]
[null,null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F5*F8","v":0}]
[]
[]
["Account #5:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B17","v":0}]
["Bank/Financial Institution:",null,null,"Variance between Most Recent Statement & Prior Month's Balance:",null,{"$f":"IF(B17>0,((B17-B18)/B18),0)","v":0}]
["Account Number:",null,null,"Total Down Payment, Closing Costs, Prepaids, and Reserves (if coming from this account):"]
["Statements","Ending Account Balance",null,"Most recent ending balance, after deducting DP, CC, PP, and Reserves:",null,{"$f":"B17-F15","v":0}]
["Month 1 Statement (Most Recent Statement)",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 2 Statement",null,null,{"$f":"IF(F14>10%,\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Underwriting Manager must approve use of the income\",IF(F14<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, 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"}]
[null,null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B13=\"\"),VLOOKUP(B13,asset,2,FALSE),0)","v":0}]
[null,null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F16*F19","v":0}]
[]
[]
["Account #6:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B28","v":0}]
["Bank/Financial Institution:",null,null,"Variance between Most Recent Statement & Prior Month's Balance:",null,{"$f":"IF(B28>0,((B28-B29)/B29),0)","v":0}]
["Account Number:",null,null,"Total Down Payment, Closing Costs, Prepaids, and Reserves (if coming from this account):"]
["Statements","Ending Account Balance",null,"Most recent ending balance, after deducting DP, CC, PP, and Reserves:",null,{"$f":"B28-F26","v":0}]
["Month 1 Statement (Most Recent Statement)",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 2 Statement",null,null,{"$f":"IF(F25>10%,\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Underwriting Manager must approve use of the income\",IF(F25<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, 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"}]
[null,null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B24=\"\"),VLOOKUP(B24,asset,2,FALSE),0)","v":0}]
[null,null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F27*F30","v":0}]
[]
[]
["Account #7:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B39","v":0}]
["Bank/Financial Institution:",null,null,"Variance between Most Recent Statement & Prior Month's Balance:",null,{"$f":"IF(B39>0,((B39-B40)/B40),0)","v":0}]
["Account Number:",null,null,"Total Down Payment, Closing Costs, Prepaids, and Reserves (if coming from this account):"]
["Statements","Ending Account Balance",null,"Most recent ending balance, after deducting DP, CC, PP, and Reserves:",null,{"$f":"B39-F37","v":0}]
["Month 1 Statement (Most Recent Statement)",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 2 Statement",null,null,{"$f":"IF(F36>10%,\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Underwriting Manager must approve use of the income\",IF(F36<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, 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"}]
[null,null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B35=\"\"),VLOOKUP(B35,asset,2,FALSE),0)","v":0}]
[null,null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F38*F41","v":0}]
[]
[]
["Account #8:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B50","v":0}]
["Bank/Financial Institution:",null,null,"Variance between Most Recent Statement & Prior Month's Balance:",null,{"$f":"IF(B50>0,((B50-B51)/B51),0)","v":0}]
["Account Number:",null,null,"Total Down Payment, Closing Costs, Prepaids, and Reserves (if coming from this account):"]
["Statements","Ending Account Balance",null,"Most recent ending balance, after deducting DP, CC, PP, and Reserves:",null,{"$f":"B50-F48","v":0}]
["Month 1 Statement (Most Recent Statement)",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 2 Statement",null,null,{"$f":"IF(F47>10%,\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Underwriting Manager must approve use of the income\",IF(F47<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, 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"}]
[null,null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B46=\"\"),VLOOKUP(B46,asset,2,FALSE),0)","v":0}]
[null,null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F49*F52","v":0}]
[]
[]
["Account #9:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B61","v":0}]
["Bank/Financial Institution:",null,null,"Variance between Most Recent Statement & Prior Month's Balance:",null,{"$f":"IF(B61>0,((B61-B62)/B62),0)","v":0}]
["Account Number:",null,null,"Total Down Payment, Closing Costs, Prepaids, and Reserves (if coming from this account):"]
["Statements","Ending Account Balance",null,"Most recent ending balance, after deducting DP, CC, PP, and Reserves:",null,{"$f":"B61-F59","v":0}]
["Month 1 Statement (Most Recent Statement)",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 2 Statement",null,null,{"$f":"IF(F58>10%,\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Underwriting Manager must approve use of the income\",IF(F58<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, 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"}]
[null,null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B57=\"\"),VLOOKUP(B57,asset,2,FALSE),0)","v":0}]
[null,null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F60*F63","v":0}]
[]
[]
["Account #10:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B72","v":0}]
["Bank/Financial Institution:",null,null,"Variance between Most Recent Statement & Prior Month's Balance:",null,{"$f":"IF(B72>0,((B72-B73)/B73),0)","v":0}]
["Account Number:",null,null,"Total Down Payment, Closing Costs, Prepaids, and Reserves (if coming from this account):"]
["Statements","Ending Account Balance",null,"Most recent ending balance, after deducting DP, CC, PP, and Reserves:",null,{"$f":"B72-F70","v":0}]
["Month 1 Statement (Most Recent Statement)",null,null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 2 Statement",null,null,{"$f":"IF(F69>10%,\"Ending Balance of Most Recent Statement is > 10% of the prior month, then Underwriting Manager must approve use of the income\",IF(F69<-10%,\"Ending Balance of Most Recent Statement is > 10% less than the average, 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"}]
[null,null,null,"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B68=\"\"),VLOOKUP(B68,asset,2,FALSE),0)","v":0}]
[null,null,null,"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F71*F74","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}]