{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Asset Utilization Calculator","Sheet1"],"not_rendered":{"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Asset Utilization Calculator","index":0,"n_rows":72,"n_cols":6,"rows_kept":72,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,3],[2,4,2,5],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,0,6,3],[7,0,7,5],[10,0,10,4],[28,0,28,4],[46,0,46,4],[62,0,62,5],[63,0,65,5],[66,0,66,5],[67,0,67,5],[68,0,68,5],[69,0,69,5],[70,0,70,5],[71,0,71,5]]}
["Asset Utilization Worksheet"]
[]
[{"$nulls":4},"Results Analysis"]
["Loan Number:",{"$nulls":3},"TOTAL of Eligible Qualifying Assets:",{"$f":"SUM(E25+E43+E61)","v":{"v":32000,"d":"$32,000"}}]
["Borrower Name:","Smith",null,null,"PLEASE INPUT: Total of Down Payment, Closing Costs and Reserves",{"v":20000,"d":"$20,000"}]
["Calculator Completed by:",{"$nulls":3},"Eligible Assets after deducting Down Payment, Closing Costs and Reserves",{"$f":"F4-F5","v":{"v":12000,"d":"$12,000"}}]
[{"$nulls":4},"Qualifying Monthly Income Derived from Assets Utilization:",{"$f":"F6/60","v":{"v":200,"d":"$200"}}]
[]
["Account #1:"]
["Type of Account- Select Either: \n1)  Checking, Savings, and Money Market;   \n2)  Stocks, Bonds Mutual Funds (including those held in retirement accounts if over age 59 1/2);\n3)  Retirement funds (if younger than age 59 1/2)","Bank/Financial Institution","Account Number","Ending Account Balance","Monthly Statement "]
[]
["Checking/Savings/Money Market",null,null,{"v":20000,"d":"$20,000"},"Month 1 Statement (Oldest Dated Statement being evaluated)"]
["Checking/Savings/Money Market",null,null,{"v":36000,"d":"$36,000"},"Month 2 Statement"]
["Checking/Savings/Money Market",null,null,{"v":36000,"d":"$36,000"},"Month 3 Statement"]
["Checking/Savings/Money Market",null,null,{"v":36000,"d":"$36,000"},"Month 4 Statement (Most Recently Dated Statement)"]
[]
[{"$nulls":3},{"$f":"IF(D15>0,(AVERAGE(D12:D15)),0)","v":{"v":32000,"d":"$32,000"}},"Four Month Average Balance"]
[]
[{"$nulls":3},"Variance between Most Recent Statement Balance and Average Balance over four-months:",{"$f":"IF(D17>0,((D15-D17)/D17),0)","v":{"v":0.125,"d":"12.50%"}}]
[]
[{"$nulls":3},"Eligible Asset Balance for inclusion, determined by evaluating four-months statements:",{"$f":"IF(E19>0.1,D17,D15)","v":{"v":32000,"d":"$32,000"}}]
[]
["Additional Warning Message:",{"$f":"IF(E19>10%,\"Ending Balance of Most Recent Account is >10% above four-month average; use the four-month average UNLESS use of higher ending balance is justified by source documentation\",IF(E19<-10%,\"Ending Balance of Most Recent Statement is less than -10% of four-month average, Arc Home Underwriting Manager must approve use of the income\",\"Use Ending Balance from Most Recent Statement; ending balance is within 10% of four-month average\"))","v":"Ending Balance of Most Recent Account is >10% above four-month average; use the four-month average UNLESS use of higher ending balance is justified by source documentation"},null,"Eligible percentage of Funds:\n100% for Checking, Savings, and Money Market;   \n70% if Stocks, Bonds Mutual Funds (including retirement accounts if over age 59 1/2);  \n50% if Retirement funds (if younger than age 59 1/2)","Dollar Amount of Eligible Qualifying Assets"]
[]
[{"$nulls":3},{"$f":"IF(A15=\"Checking/Savings/Money Market\",100%,IF(A15=\"Stocks/Bonds/MutualFunds/Retirement if >=59 1/2\",70%,IF(A15=\"Retirement Funds if <59 1/2\",50%)))","v":{"v":1,"d":"100%"}},{"$f":"D25*E21","v":{"v":32000,"d":"$32,000"}}]
[]
["Account #2:"]
["Type of Account- Select Either: \n1)  Checking, Savings, and Money Market;   \n2)  Stocks, Bonds Mutual Funds (including those held in retirement accounts if over age 59 1/2);\n3)  Retirement funds (if younger than age 59 1/2)","Bank/Financial Institution","Account Number","Ending Account Balance","Monthly Statement "]
[]
["Checking/Savings/Money Market",null,null,{"v":0,"d":"$0"},"Month 1 Statement (Oldest Dated Statement being evaluated)"]
["Checking/Savings/Money Market",null,null,{"v":0,"d":"$0"},"Month 2 Statement"]
["Checking/Savings/Money Market",null,null,{"v":0,"d":"$0"},"Month 3 Statement"]
["Checking/Savings/Money Market",null,null,{"v":0,"d":"$0"},"Month 4 Statement (Most Recently Dated Statement)"]
[]
[{"$nulls":3},{"$f":"IF(D33>0,(AVERAGE(D30:D33)),0)","v":{"v":0,"d":"$0"}},"Four Month Average Balance"]
[]
[{"$nulls":3},"Variance between Most Recent Statement Balance and Average Balance over four-months:",{"$f":"IF(D35>0,((D33-D35)/D35),0)","v":{"v":0,"d":"0.00%"}}]
[]
[{"$nulls":3},"Eligible Asset Balance for inclusion, determined by evaluating four-months statements:",{"$f":"IF(E37>0.1,D35,D33)","v":{"v":0,"d":"$0"}}]
[]
["Additional Warning Message:",{"$f":"IF(E37>10%,\"Ending Balance of Most Recent Account is >10% above four-month average; use the four-month average UNLESS use of higher ending balance is justified by source documentation\",IF(E37<-10%,\"Ending Balance of Most Recent Statement is less than -10% of four-month average, Arc Home Underwriting Manager must approve use of the income\",\"Use Ending Balance from Most Recent Statement; ending balance is within 10% of four-month average\"))","v":"Use Ending Balance from Most Recent Statement; ending balance is within 10% of four-month average"},null,"Eligible percentage of Funds:\n100% for Checking, Savings, and Money Market;   \n70% if Stocks, Bonds Mutual Funds (including retirement accounts if over age 59 1/2);  \n50% if Retirement funds (if younger than age 59 1/2)","Dollar Amount of Eligible Qualifying Assets"]
[]
[{"$nulls":3},{"$f":"IF(A33=\"Checking/Savings/Money Market\",100%,IF(A33=\"Stocks/Bonds/MutualFunds/Retirement if >=59 1/2\",70%,IF(A33=\"Retirement Funds if <59 1/2\",50%)))","v":{"v":1,"d":"100%"}},{"$f":"D43*E39","v":{"v":0,"d":"$0"}}]
[]
["Account #3:"]
["Type of Account- Select Either: \n1)  Checking, Savings, and Money Market;   \n2)  Stocks, Bonds Mutual Funds (including those held in retirement accounts if over age 59 1/2);\n3)  Retirement funds (if younger than age 59 1/2)","Bank/Financial Institution","Account Number","Ending Account Balance","Monthly Statement "]
[]
["Checking/Savings/Money Market",{"$nulls":3},"Month 1 Statement (Oldest Dated Statement being evaluated)"]
["Checking/Savings/Money Market",{"$nulls":3},"Month 2 Statement"]
["Checking/Savings/Money Market",{"$nulls":3},"Month 3 Statement"]
["Checking/Savings/Money Market",{"$nulls":3},"Month 4 Statement (Most Recently Dated Statement)"]
[]
[{"$nulls":3},{"$f":"IF(D51>0,(AVERAGE(D48:D51)),0)","v":{"v":0,"d":"$0"}},"Four Month Average Balance"]
[]
[{"$nulls":3},"Variance between Most Recent Statement Balance and Average Balance over four-months:",{"$f":"IF(D53>0,((D51-D53)/D53),0)","v":{"v":0,"d":"0.00%"}}]
[]
[{"$nulls":3},"Eligible Asset Balance for inclusion, determined by evaluating four-months statements:",{"$f":"IF(E55>0.1,D53,D51)","v":{"v":0,"d":"$0"}}]
[]
["Additional Warning Message:",{"$f":"IF(E55>10%,\"Ending Balance of Most Recent Account is >10% above four-month average; use the four-month average UNLESS use of higher ending balance is justified by source documentation\",IF(E55<-10%,\"Ending Balance of Most Recent Statement is less than -10% of four-month average, Arc Home Underwriting Manager must approve use of the income\",\"Use Ending Balance from Most Recent Statement; ending balance is within 10% of four-month average\"))","v":"Use Ending Balance from Most Recent Statement; ending balance is within 10% of four-month average"},null,"Eligible percentage of Funds:\n100% for Checking, Savings, and Money Market;   \n70% if Stocks, Bonds Mutual Funds (including retirement accounts if over age 59 1/2);  \n50% if Retirement funds (if younger than age 59 1/2)","Dollar Amount of Eligible Qualifying Assets"]
[]
[{"$nulls":3},{"$f":"IF(A51=\"Checking/Savings/Money Market\",100%,IF(A51=\"Stocks/Bonds/MutualFunds/Retirement if >=59 1/2\",70%,IF(A51=\"Retirement Funds if <59 1/2\",50%)))","v":{"v":1,"d":"100%"}},{"$f":"D61*E57","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, business structure details, and/or loan specifics may require a revised calculation for the purposes of qualifying.  "]

{"sheet":"Sheet1","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
[null,{"v":0,"d":"0%"}]
["Checking/Savings/Money Market",{"v":1,"d":"100%"}]
["Stocks/Bonds/MutualFunds/Retirement if >=59 1/2",{"v":0.7,"d":"70%"}]
["Retirement Funds if <59 1/2",{"v":0.5,"d":"50%"}]