{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Asset Utilization Calculator","Input Additional Assets Here","formulas"],"not_rendered":{"images":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Asset Utilization Calculator","index":0,"n_rows":53,"n_cols":6,"rows_kept":53,"merged":[[0,0,2,5],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,4],[5,1,5,2],[5,3,5,4],[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[9,3,9,4],[10,0,10,5],[11,0,11,5],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,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],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,5],[28,3,28,5],[29,3,29,4],[30,3,30,4],[31,3,31,5],[33,0,33,5],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,5],[39,3,39,5],[40,3,40,4],[41,3,41,4],[42,3,42,5],[43,0,43,5],[44,0,46,5],[47,0,47,5],[48,0,48,5],[49,0,49,5],[50,0,50,5],[51,0,51,5],[52,0,52,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":{"v":2000000,"d":"$2,000,000"}}]
["Option 1 vs Option 2:","Option 2",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":"Post Closing Assets Required"},null,{"$f":"IF(B6=\"Option 1\",B7+F15+F26+F37+'Input Additional Assets Here'!F4+'Input Additional Assets Here'!F15+'Input Additional Assets Here'!F26+'Input Additional Assets Here'!F37+'Input Additional Assets Here'!F48+'Input Additional Assets Here'!F59+'Input Additional Assets Here'!F70+(B8*60),((1.25*B7)))","v":{"v":1250000,"d":"$1,250,000"}}]
["Loan Amount:",{"v":1000000,"d":"$1,000,000.00"},null,"Residual Income:",null,{"$f":"(F5/60)-B8","v":{"v":23333.333333333336,"d":"$23,333"}}]
["Monthly Obligations (Subject PITIA and all debt):",{"v":10000,"d":"$10,000.00"},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":"YES, Post Closing Assets are Sufficient"}]
["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":"YES, Residual Income Meets Guideline Requirements"}]
[{"$nulls":3},"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":"YES"}]
[]
["Account #1:"]
["Type of Account:","Checking/Savings/CD/Money Market",null,"Ending Balance:",null,{"$f":"B17","v":{"v":3000000,"d":"$3,000,000"}}]
["Bank/Financial Institution:",null,null,"Variance between Most Recent Statement & Prior Month's Balance:",null,{"$f":"IF(B17>0,((B17-B18)/B18),0)","v":{"v":0,"d":"0.00%"}}]
["Account Number:",null,null,"Total Down Payment, Closing Costs, Prepaids, and Reserves (if coming from this account):",null,{"v":1000000,"d":"$1,000,000"}]
["Statements","Ending Account Balance",null,"Most recent ending balance, after deducting DP, CC, PP, and Reserves:",null,{"$f":"B17-F15","v":{"v":2000000,"d":"$2,000,000"}}]
["Month 1 Statement (Most Recent Statement)",{"v":3000000,"d":"$3,000,000"},null,"Explanation for the Eligible Asset Balance for inclusion:"]
["Month 2 Statement",{"v":3000000,"d":"$3,000,000"},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"}]
[{"$nulls":3},"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B13=\"\"),VLOOKUP(B13,asset,2,FALSE),0)","v":{"v":1,"d":"100%"}}]
[{"$nulls":3},"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F16*F19","v":{"v":2000000,"d":"$2,000,000"}}]
[]
[]
["Account #2:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B28","v":{"v":0,"d":"$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":{"v":0,"d":"0.00%"}}]
["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":{"v":0,"d":"$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"}]
[{"$nulls":3},"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B24=\"\"),VLOOKUP(B24,asset,2,FALSE),0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F27*F30","v":{"v":0,"d":"$0"}}]
[]
[]
["Account #3:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B39","v":{"v":0,"d":"$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":{"v":0,"d":"0.00%"}}]
["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":{"v":0,"d":"$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"}]
[{"$nulls":3},"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B35=\"\"),VLOOKUP(B35,asset,2,FALSE),0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F38*F41","v":{"v":0,"d":"$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,"merged":[[0,0,0,5],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,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],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,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],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,5],[28,3,28,5],[29,3,29,4],[30,3,30,4],[31,3,31,5],[33,0,33,5],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,5],[39,3,39,5],[40,3,40,4],[41,3,41,4],[42,3,42,5],[44,0,44,5],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,5],[50,3,50,5],[51,3,51,4],[52,3,52,4],[53,3,53,5],[55,0,55,5],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,5],[61,3,61,5],[62,3,62,4],[63,3,63,4],[64,3,64,5],[66,0,66,5],[67,3,67,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[71,3,71,5],[72,3,72,5],[73,3,73,4],[74,3,74,4],[75,3,75,5]]}
["Account #4:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B6","v":{"v":0,"d":"$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":{"v":0,"d":"0.00%"}}]
["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":{"v":0,"d":"$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"}]
[{"$nulls":3},"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B2=\"\"),VLOOKUP(B2,asset,2,FALSE),0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F5*F8","v":{"v":0,"d":"$0"}}]
[]
[]
["Account #5:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B17","v":{"v":0,"d":"$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":{"v":0,"d":"0.00%"}}]
["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":{"v":0,"d":"$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"}]
[{"$nulls":3},"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B13=\"\"),VLOOKUP(B13,asset,2,FALSE),0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F16*F19","v":{"v":0,"d":"$0"}}]
[]
[]
["Account #6:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B28","v":{"v":0,"d":"$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":{"v":0,"d":"0.00%"}}]
["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":{"v":0,"d":"$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"}]
[{"$nulls":3},"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B24=\"\"),VLOOKUP(B24,asset,2,FALSE),0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F27*F30","v":{"v":0,"d":"$0"}}]
[]
[]
["Account #7:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B39","v":{"v":0,"d":"$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":{"v":0,"d":"0.00%"}}]
["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":{"v":0,"d":"$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"}]
[{"$nulls":3},"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B35=\"\"),VLOOKUP(B35,asset,2,FALSE),0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F38*F41","v":{"v":0,"d":"$0"}}]
[]
[]
["Account #8:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B50","v":{"v":0,"d":"$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":{"v":0,"d":"0.00%"}}]
["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":{"v":0,"d":"$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"}]
[{"$nulls":3},"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B46=\"\"),VLOOKUP(B46,asset,2,FALSE),0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F49*F52","v":{"v":0,"d":"$0"}}]
[]
[]
["Account #9:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B61","v":{"v":0,"d":"$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":{"v":0,"d":"0.00%"}}]
["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":{"v":0,"d":"$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"}]
[{"$nulls":3},"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B57=\"\"),VLOOKUP(B57,asset,2,FALSE),0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F60*F63","v":{"v":0,"d":"$0"}}]
[]
[]
["Account #10:"]
["Type of Account:",null,null,"Ending Balance:",null,{"$f":"B72","v":{"v":0,"d":"$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":{"v":0,"d":"0.00%"}}]
["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":{"v":0,"d":"$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"}]
[{"$nulls":3},"Eligible Percentage of Funds:",null,{"$f":"IF(NOT(B68=\"\"),VLOOKUP(B68,asset,2,FALSE),0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Total Eligible Qualifying Assets from this Account:",null,{"$f":"F71*F74","v":{"v":0,"d":"$0"}}]

{"sheet":"formulas","index":2,"n_rows":26,"n_cols":2,"rows_kept":26,"hidden":true}
[]
["Checking/Savings/CD/Money Market",{"v":1,"d":"100%"}]
["Stocks/Bonds/MutualFunds/Retirement Funds if >=59 1/2",{"v":0.7,"d":"70%"}]
["Retirement Funds if <59 1/2",{"v":0.5,"d":"50%"}]
[]
["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}]