{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["VA_Maximum_Mortgage_Worksheet","List Options"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"VA_Maximum_Mortgage_Worksheet","index":0,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[17,1,17,2],[17,4,17,5],[17,7,17,8],[17,10,17,11],[16,5,16,11],[16,1,16,4],[44,9,44,11],[45,9,45,11],[46,9,46,11],[47,9,47,11],[48,9,48,11],[44,2,44,7],[45,2,45,7],[46,2,46,7],[47,2,47,7],[49,2,49,7],[48,2,48,7],[41,2,41,7],[40,2,40,3],[40,4,40,5],[40,6,40,7],[39,9,39,11],[40,9,40,11],[41,9,41,11],[39,2,39,7],[25,1,25,11],[36,2,36,7],[34,9,34,11],[35,9,35,11],[36,9,36,11],[26,2,26,7],[27,2,27,7],[28,2,28,7],[29,2,29,7],[30,2,31,10],[26,9,26,11],[27,9,27,11],[28,9,28,11],[29,9,29,11],[33,1,33,11],[12,1,12,3],[12,4,12,6],[11,3,11,6],[10,3,10,6],[10,8,10,9],[11,8,11,9],[5,1,5,11],[6,1,6,11],[8,1,8,11],[10,1,10,2],[11,1,11,2],[10,10,10,11],[11,10,11,11],[38,1,38,11],[43,1,43,11],[20,13,21,13],[14,6,14,8],[14,1,14,5],[20,2,20,7],[20,9,20,11],[21,9,21,11],[22,9,22,11],[21,2,21,7],[22,2,22,7],[19,1,19,11],[23,2,23,7],[34,2,34,7],[35,2,35,7],[23,9,23,11]]}
[]
[]
[]
[]
[]
[null,"VA Entitlement Worksheet"]
[null,"Maximum Mortgage Calculation Worksheet"]
[]
[null,"Complete applicable gray highlighted items.  Blue highlighted items are automatically calculated."]
[]
[null,"Borrower(s):",null," ",null,null,null,null,"Date Completed:",null," "]
[null,"New VA Case #:",null," ",null,null,null,null,"Loan Number:",null," "]
[null,"Prior VA First Payment Date:",null,null," "]
[]
[null,"VA Cash Out: The Note date must be on or after:",null,null,null,null,{"$f":"E13+210","v":{"$error":"#VALUE!"}}]
[]
[null,"Loan Type & Military Service (select drop-down):",null,null,null," "]
[null,"County/Limit",null,"State:"," ",null,"County:"," ",null,"Enter Limit Amount:"," "]
[null,null,null,null,null,null,null,null,null," "]
[null,"Entitlement"]
[null,"1a)","Enter $36,000 entitlement for all loans ≤$144,000, or",null,null,null,null,null,null,0,null,null,null,"1 field only - both fields may not be completed"]
[null,"1b)","Enter 25% of the VA County Loan Limit for loans >$144,000 (must calculate)",null,null,null,null,null,null,0]
[null,"2)","less previously used entitlement (if applicable)",null,null,null,null,null,"(-)",0]
[null,"3)","Entitlement available for New VA Loan",null,null,null,null,null,"(=)",{"$f":"((J21+J22)-J23)","v":0}]
[]
[null,"Maximum Loan Amount Calculation"]
[null,"4)","Lesser of Property Value per NOV or Sales Price",null,null,null,null,null,null,0]
[null,"5)","multiply by 75%",null,null,null,null,null,"(x)",{"$f":"(J27*75%)","v":0}]
[null,"6)","plus  available entitlement (line 3)",null,null,null,null,null,"(+)",{"$f":"J24","v":0}]
[null,"7)","Maximum Base Loan",null,null,null,null,null,"(=)",{"$f":"MIN(J27,(J28+J29))","v":0}]
[null,null,"For Purchases or Cash-out Refinances, the maximum base loan equals the lesser of line 4 or line 6"]
[]
[]
[null,"Required Cash Down Payment"]
[null,"8)","Lesser of Property Value per NOV or Sales Price (line 4)",null,null,null,null,null,null,{"$f":"J27","v":0}]
[null,"9)","less maximum Base Loan Amount (line 7)",null,null,null,null,null,"(-)",{"$f":"J30","v":0}]
[null,"10)","Required Cash Down Payment/Equity",null,null,null,null,null,"(=)",{"$f":"(J35-J36)","v":0}]
[]
[null,"Final Loan Amount"]
[null,"11)","Base Loan Amont (line 7)",null,null,null,null,null,null,{"$f":"J30","v":0}]
[null,"12)","VA Funding Fee",null,{"$f":"VLOOKUP(F17,'List Options'!A2:B14,2,FALSE)","v":{"$error":"#N/A"}},null,"(select applicable factor)",null,"(x)",{"$f":"(J40*E41)","v":{"$error":"#N/A"}}]
[null,"13)","Final Loan Amount",null,null,null,null,null,"(=)",{"$f":"(J40+J41)","v":{"$error":"#N/A"}}]
[]
[null,"Guaranty Percentage on Proposed Loan Amount"]
[null,"14)","Entitlement (line 3)",null,null,null,null,null,null,{"$f":"J24","v":0}]
[null,"15)","plus required Cash Down Payment/Equity (line 10)",null,null,null,null,null,"(+)",{"$f":"J37","v":0}]
[null,"16)","Total of line 14 and line 15",null,null,null,null,null,"(=)",{"$f":"SUM(J45+J46)","v":0}]
[null,"17)","Lesser of Property Value per NOV or Sales Price (line 4)",null,null,null,null,null,null,{"$f":"J27","v":0}]
[null,"18)","Guaranty Percentage (cannot be less than 25%)",null,null,null,null,null,null,{"$f":"(J47/J27)","v":{"$error":"#DIV/0!"}}]
[null,null,"divide line 16 by Property Value per NOV or Sales Price (line 4)"]

{"sheet":"List Options","index":1,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
["Purchase - ZeroDown - RegularMilitary",2.1499999999999998E-2]
["Purchase - ZeroDown - Reservist/NationalGuard",2.4E-2]
["Subsequent Use - Zero Down - Regular Military",3.3000000000000002E-2]
["Subsequent Use - Zero Down-Reservist/National Guard",3.3000000000000002E-2]
["Purchase and Subsequent Use - 5% Down - Regular Military",1.4999999999999999E-2]
["Purchase and Subsequent Use  - 5% Down - Reservist/National Guard",1.7500000000000002E-2]
["Purchase and Subsequent Use - 10% Down - Regular Military",1.2500000000000001E-2]
["Purchase and Subsequent Use  - 10% Down - Reservist/National Guard",1.4999999999999999E-2]
["Refinance Loan - Regular Military",2.1499999999999998E-2]
["Refinance Loan - Reservist/National Guard",2.4E-2]
["Refinance Loan - Subsequent Use - Regular Military",3.3000000000000002E-2]
["Refinance Loan - Subsequent Use - Reservist/National Guard",3.3000000000000002E-2]
["IRRRL",5.0000000000000001E-3]