{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Calculator","index":0,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,1,3,8],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[13,1,13,7],[8,6,8,7],[11,6,11,7],[25,5,25,6],[26,5,26,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[16,5,16,6],[36,5,36,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[9,10,9,14],[31,5,31,6],[7,10,7,14],[4,1,5,4],[7,1,8,4],[10,1,11,4],[15,5,15,6]]}
[]
[null,"BACKGROUND PROPERTIES"]
[null,"If the applicant(s) own any properties which they do not live in, eg buy-to-let, please list all properties individually below"]
[]
[null,"Number of mortgaged rental properties owned by all applicants, including the subject property and properties held by a Ltd Co"]
[null,null,null,null,null,null,"Number"]
[]
[null,"Has any applicant acquired more than 3 BTL properties in the last 12 months?",null,null,null,null,null,null,null,null,"Controls "]
[]
[null,null,null,null,null,null,null,null,null,null,"Gearing Re-Apportionment"]
[null,"Does at least one applicant have a minimum of 24 months’ landlord experience? ",null,null,null,null,null,null,null,null,null,"Personal","LTD",null,"Pass/Fail"]
[null,null,null,null,null,null,null,null,null,null,"Required",{"$f":"(((SUMIFS($E$17:$E$37,$C$17:$C$37,\"No\"))*5.5%)/12)*1.45","v":0},{"$f":"(((SUMIFS($E$17:$E$37,$C$17:$C$37,\"Yes\"))*5.5%)/12)*1.25","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Actual",{"$f":"SUMIFS($F$17:$F$37,$C$17:$C$37,\"No\")","v":0},{"$f":"SUMIFS($F$17:$F$37,$C$17:$C$37,\"yes\")","v":0}]
[null,"Criteria not met. Please refer to our LTD Co. BTL portfolio landlord help sheet or call 01455 894084",null,null,null,null,null,null,null,null,"Excess",{"$f":"L13-L12","v":0},{"$f":"M13-M12","v":0},{"$f":"L14+M14","v":0},{"$f":"IF(N14>=0,\"Pass\",\"Fail\")","v":"Pass"}]
[]
[null,"Property","Owned in a LTD company name?","Property Valuation","Mortgage Balance (Excluding Fees)","Rental income",null,"Interest Coverage Ratio","LTV",null,null,null,"Actual","Requirement"]
[null,"Subject property",null,null,null,null,null,{"$f":"IFERROR(F17/((E17*5.5%)/12),\"\")","v":""},{"$f":"IFERROR(E17/D17,\"\")","v":""},null,null,"Subject LTV",{"$f":"IFERROR(E17/D17,0)","v":0},0.7,{"$f":"IF(M17>N17,\"Fail\",\"Pass\")","v":"Pass"}]
[null,1,null,null,null,null,null,"",{"$f":"IFERROR(E18/D18,\"\")","v":""},null,null,"Portfolio LTV",{"$f":"IFERROR(SUM(E17:E37)/SUM(D17:D37),0)","v":0},0.7,{"$f":"IF(M18>N18,\"Fail\",\"Pass\")","v":"Pass"}]
[null,2,null,null,null,null,null,"","",null,null,"LTD company gearing",{"$f":"IF(ISNUMBER(MATCH(\"yes\",$C$17:$C$37,0)),ROUND(SUMIF(C17:C37,\"yes\",F17:G37)/(SUMIF(C17:C37,\"yes\",E17:E37)*5.5%/12),4),\"\")","v":""},1.25,{"$f":"IF(M19<N19,\"Fail\",\"Pass\")","v":"Pass"}]
[null,3,null,null,null,null,null,"","",null,null,"Personal gearing",{"$f":"IF(ISNUMBER(MATCH(\"no\",$C$17:$C$37,0)),ROUND(SUMIF(C17:C37,\"no\",F17:G37)/(SUMIF(C17:C37,\"no\",E17:E37)*5.5%/12),4),\"\")","v":""},1.45,{"$f":"IF(M20<N20,\"Fail\",\"Pass\")","v":"Pass"}]
[null,4,null,null,null,null,null,"","",null,null,"Subject Property Gearing",{"$f":"ROUND(H17,4)","v":{"$error":"#VALUE!"}},1.25,{"$f":"IF(M21<N21,\"Fail\",\"Pass\")","v":{"$error":"#VALUE!"}}]
[null,5,null,null,null,null,null,"","",null,null,null,null,"Overall",{"$f":"IF(_xlfn.IFNA(MATCH(\"Fail\",$O$14:$O$21,0)>0,0),\"FAIL\",\"PASS\")","v":"PASS"}]
[null,6,null,null,null,null,null,"",""]
[null,7,null,null,null,null,null,"",""]
[null,8,null,null,null,null,null,"",""]
[null,9,null,null,null,null,null,"",""]
[null,10,null,null,null,null,null,"",""]
[null,11,null,null,null,null,null,"",""]
[null,12,null,null,null,null,null,"",""]
[null,13,null,null,null,null,null,"",""]
[null,14,null,null,null,null,null,"",""]
[null,15,null,null,null,null,null,"",""]
[null,16,null,null,null,null,null,"",""]
[null,17,null,null,null,null,null,"",""]
[null,18,null,null,null,null,null,"",""]
[null,19,null,null,null,null,null,"",""]
[null,20,null,null,null,null,null,"",""]