{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["LR007","real1","real2","real3","real4"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":178,"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":"LR007","index":0,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"A3","v":"REAL ESTATE"}]
[]
["REAL ESTATE"]
[null,null,null,"(1)",null,"(2)",null,null,"(3)"]
[null,null,null,"Book / Adjusted",null,"Average",null,null,"RBC"]
[null,null,"Annual Statement Source","Carrying Value",null,"Factor",null,null,"  Requirement ‡"]
[null,"Real Estate"]
[1,"Company Occupied Real Estate","AVR Equity Component Column 1 Line 18",{"$f":"real1!C9","v":0}]
[2,"Company Occupied Encumbrances","AVR Equity Component Column 3 Line 18",{"$f":"real1!E9","v":0}]
[3,"Total Company Occupied Real Estate","Line (1) + (2) ",{"$f":"D8+D9","v":0},"X",{"$f":"IF(D10<>0,ROUND(+I10/D10,4),0)","v":0},"†","=",{"$f":"real1!N9","v":0}]
[4,"Foreclosed Real Estate","AVR Equity Component Column 1 Line 20",{"$f":"real2!C9","v":0}]
[5,"Foreclosed Encumbrances","AVR Equity Component Column 3 Line 20",{"$f":"real2!E9","v":0}]
[6,"Total Foreclosed Real Estate","Line (4) + (5)",{"$f":"D11+D12","v":0},"X",{"$f":"IF(D13<>0,ROUND(+I13/D13,4),0)","v":0},"†","=",{"$f":"real2!N9","v":0}]
[7,"Investment Real Estate","AVR Equity Component Column 1 Line 19",{"$f":"real3!C9","v":0}]
[8,"Investment Encumbrances","AVR Equity Component Column 3 Line 19",{"$f":"real3!E9","v":0}]
[9,"Total Investment Real Estate","Line (7) + (8)",{"$f":"D14+D15","v":0},"X",{"$f":"IF(D16<>0,ROUND(+I16/D16,4),0)","v":0},"†","=",{"$f":"real3!N9","v":0}]
[]
[10,"Total Real Estate","Lines (3) + (6) + (9)",{"$f":"+D16+D13+D10","v":0},null,null,null,null,{"$f":"+I16+I13+I10","v":0}]
[null,"(pre-MODCO/Funds Withheld)"]
[11,"Reduction in RBC for MODCO/Funds Withheld "]
[null,"Reinsurance Ceded Agreements","Company Records (enter a pre-tax amount)",null,null,null,null,null,0]
[12,"Increase in RBC for MODCO/Funds Withheld "]
[null,"Reinsurance Assumed Agreements","Company Records (enter a pre-tax amount)",null,null,null,null,null,0]
[13,"Total Real Estate"]
[null,"(including MODCO/Funds Withheld.)","Lines (10) - (11) + (12)",null,null,null,null,null,{"$f":"MAX(+I18-I21+I23,0)","v":0}]
[]
[null,"Schedule BA Real Estate"]
[14,"Schedule BA Real Estate","Schedule BA Part 1 Column 12 Line 2199999 ",{"$f":"real4!C9","v":0}]
[null,null,"+ Line 2299999, in part "]
[]
[15,"Schedule BA Real Estate Encumbrances","Schedule BA Part 1 Column 12 Line 2199999 ",{"$f":"real4!E9","v":0}]
[null,null,"+ Line 2299999, in part "]
[]
[16,"Total Schedule BA Real Estate Excluding Low","Line (14) + (15)",{"$f":"D28+D31","v":0},"X",{"$f":"IF(D34<>0,ROUND(+I34/D34,4),0)","v":0},"†","=",{"$f":"real4!N9","v":0}]
[null,"Income Housing Tax Credits Included Below"]
[17,"Federal Guaranteed Low Income Housing Tax Credits","AVR Equity Component Column 1 Line 75",0,"X",1.4E-3,null,"=",{"$f":"ROUND(MAX(0,D36)*F36,0)","v":0}]
[18,"Federal Non-Guaranteed Low Income Housing Tax Credits","AVR Equity Component Column 1 Line 76",0,"X",2.5999999999999999E-2,null,"=",{"$f":"ROUND(MAX(0,D37)*F37,0)","v":0}]
[19,"State Guaranteed Low Income Housing Tax Credits","AVR Equity Component Column 1 Line 77",null,"X",1.4E-3,null,"=",{"$f":"ROUND(MAX(0,D38)*F38,0)","v":0}]
[20,"State Non-Guaranteed Low Income Housing Tax Credits","AVR Equity Component Column 1 Line 78",null,"X",2.5999999999999999E-2,null,"=",{"$f":"ROUND(MAX(0,D39)*F39,0)","v":0}]
[21,"All Other Low Income Housing Tax Credits","AVR Equity Component Column 1 Line 79",null,"X",0.15,null,"=",{"$f":"ROUND(MAX(0,D40)*F40,0)","v":0}]
[22,"Total Schedule BA Real Estate","Lines (16) + (17) + (18) + (19) + (20) + (21)",{"$f":"D34+D36+D37+D38+D39+D40","v":0},null,null,null,null,{"$f":"I34+I36+I37+I38+I39+I40","v":0}]
[null,"(pre-MODCO/Funds Withheld)"]
[23,"Reduction in RBC for MODCO/Funds Withheld "]
[null,"Reinsurance Ceded Agreements","Company Records (enter a pre-tax amount)",null,null,null,null,null,0]
[24,"Increase in RBC for MODCO/Funds Withheld "]
[null,"Reinsurance Assumed Agreements","Company Records (enter a pre-tax amount)",null,null,null,null,null,0]
[25,"Total Schedule BA Real Estate"]
[null,"(including MODCO/Funds Withheld)","Lines (22) - (23) + (24)",null,null,null,null,null,{"$f":"MAX(+I41-I44+I46,0)","v":0}]
[]
["†","Column (2) is calculated as Column (3) divided by Column (1)."]
["‡","The RBC requirement is calculated for each individual property and then summarized on this page. Refer to the worksheet included in the Real Estate "]
[null,"portion of the instructions."]

{"sheet":"real1","index":1,"n_rows":128,"n_cols":14,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
["Company Name",null,null,null,null,null,null,null,null,null,null,null,null,"Cocode: 00000"]
["Company Occupied Real Estate"]
["Fair Value adjustment factor",null,{"$f":"2/3","v":0.66666666666666663}]
["(1)",null,"(2)",null,"(3)",null,-4,null,"(5)","(6)","(7)","(8)","(9)","(10)"]
[null,null,"Book/Adjusted",null,null,null,null,null,null,"Encumbrances",null,"Gross RBC "]
[null,null,"Carrying",null,null,null,null,null,null,"credit","Adjusted",null,"Encumbrances","RBC"]
["Name / ID / Line",null,"Value",null,"Encumbrances",null,"Fair Value",null," Base Factor","Factor","RBC Factor","Requirement","Credit","Requirement"]
[]
["Total for All Lines",null,{"$f":"SUM(C13:C249)","v":0},null,{"$f":"SUM(E13:E249)","v":0},null,{"$f":"SUM(G13:G249)","v":0},null,null,null,null,{"$f":"SUM(L13:L249)","v":0},{"$f":"SUM(M13:M249)","v":0},{"$f":"SUM(N13:N249)","v":0}]
[]
["Properties Without Encumbrances:"]
["Enter individually, add lines as needed"]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF(C13=0,0,MAX(I13*((1-($C$3)*(G13-(C13))/(C13))), 0))","v":0},{"$f":"K13*(C13)","v":0},"XXX",{"$f":"MIN(MAX((L13),(C13*0.013)),C13*0.45)","v":0}]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF(C14=0,0,MAX(I14*((1-($C$3)*(G14-(C14))/(C14))), 0))","v":0},{"$f":"K14*(C14)","v":0},"XXX",{"$f":"MIN(MAX((L14),(C14*0.013)),C14*0.45)","v":0}]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[]
["Properties With Encumbrances:"]
["Enter individually, add lines as needed"]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C26+E26)=0,0,MAX(I26*((1-($C$3)*(G26-(C26+E26))/(C26+E26))),0))","v":0},{"$f":"K26*(C26+E26)","v":0},{"$f":"E26*J26","v":0},{"$f":"MAX(MIN(MAX((L26-M26),(C26*0.013)),C26*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C27+E27)=0,0,MAX(I27*((1-($C$3)*(G27-(C27+E27))/(C27+E27))),0))","v":0},0,0,{"$f":"MAX(MIN(MAX((L27-M27),(C27*0.013)),C27*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,{"$f":"K90*(C90+E90)","v":0},{"$f":"E90*J90","v":0},0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C91+E91)=0,0,MAX(I91*((1-($C$3)*(G91-(C91+E91))/(C91+E91))),0))","v":0},0,0,{"$f":"MAX(MIN(MAX((L91-M91),(C91*0.013)),C91*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]

{"sheet":"real2","index":2,"n_rows":128,"n_cols":14,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
["Company Name",null,null,null,null,null,null,null,null,null,null,null,null,"Cocode: 00000"]
["Property Acquired in satisfaction of Debt"]
["Fair Value adjustment factor",null,{"$f":"2/3","v":0.66666666666666663}]
["(1)",null,"(2)",null,"(3)",null,-4,null,"(5)","(6)","(7)","(8)","(9)","(10)"]
[null,null,"Book/Adjusted",null,null,null,null,null,null,"Encumbrances",null,"Gross RBC "]
[null,null,"Carrying",null,null,null,null,null,null,"credit","Adjusted",null,"Encumbrances","RBC"]
["Name / ID / Line",null,"Value",null,"Encumbrances",null,"Fair Value",null," Base Factor","Factor","RBC Factor","Requirement","Credit","Requirement"]
[]
["Total for All Lines",null,{"$f":"SUM(C13:C249)","v":0},null,{"$f":"SUM(E13:E249)","v":0},null,{"$f":"SUM(G13:G249)","v":0},null,null,null,null,{"$f":"SUM(L13:L249)","v":0},{"$f":"SUM(M13:M249)","v":0},{"$f":"SUM(N13:N249)","v":0}]
[]
["Properties Without Encumbrances:"]
["Enter individually, add lines as needed"]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF(C13=0,0,MAX(I13*((1-($C$3)*(G13-(C13))/(C13))), 0))","v":0},{"$f":"K13*(C13)","v":0},"XXX",{"$f":"MIN(MAX((L13),(C13*0.013)),C13*0.45)","v":0}]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF(C14=0,0,MAX(I14*((1-($C$3)*(G14-(C14))/(C14))), 0))","v":0},{"$f":"K14*(C14)","v":0},"XXX",{"$f":"MIN(MAX((L14),(C14*0.013)),C14*0.45)","v":0}]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[]
["Properties With Encumbrances:"]
["Enter individually, add lines as needed"]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C26+E26)=0,0,MAX(I26*((1-($C$3)*(G26-(C26+E26))/(C26+E26))),0))","v":0},{"$f":"K26*(C26+E26)","v":0},{"$f":"E26*J26","v":0},{"$f":"MAX(MIN(MAX((L26-M26),(C26*0.013)),C26*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C27+E27)=0,0,MAX(I27*((1-($C$3)*(G27-(C27+E27))/(C27+E27))),0))","v":0},0,0,{"$f":"MAX(MIN(MAX((L27-M27),(C27*0.013)),C27*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,{"$f":"K90*(C90+E90)","v":0},{"$f":"E90*J90","v":0},0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C91+E91)=0,0,MAX(I91*((1-($C$3)*(G91-(C91+E91))/(C91+E91))),0))","v":0},0,0,{"$f":"MAX(MIN(MAX((L91-M91),(C91*0.013)),C91*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]

{"sheet":"real3","index":3,"n_rows":128,"n_cols":14,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
["Company Name",null,null,null,null,null,null,null,null,null,null,null,null,"Cocode: 00000"]
["Investment Real Estate","including held for sale"]
["Fair Value adjustment factor",null,{"$f":"2/3","v":0.66666666666666663}]
["(1)",null,"(2)",null,"(3)",null,-4,null,"(5)","(6)","(7)","(8)","(9)","(10)"]
[null,null,"Book/Adjusted",null,null,null,null,null,null,"Encumbrances",null,"Gross RBC "]
[null,null,"Carrying",null,null,null,null,null,null,"credit","Adjusted",null,"Encumbrances","RBC"]
["Name / ID / Line",null,"Value",null,"Encumbrances",null,"Fair Value",null," Base Factor","Factor","RBC Factor","Requirement","Credit","Requirement"]
[]
["Total for All Lines",null,{"$f":"SUM(C13:C249)","v":0},null,{"$f":"SUM(E13:E249)","v":0},null,{"$f":"SUM(G13:G249)","v":0},null,null,null,null,{"$f":"SUM(L13:L249)","v":0},{"$f":"SUM(M13:M249)","v":0},{"$f":"SUM(N13:N249)","v":0}]
[]
["Properties Without Encumbrances:"]
["Enter individually, add lines as needed"]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF(C13=0,0,MAX(I13*((1-($C$3)*(G13-(C13))/(C13))), 0))","v":0},{"$f":"K13*(C13)","v":0},"XXX",{"$f":"MIN(MAX((L13),(C13*0.013)),C13*0.45)","v":0}]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF(C14=0,0,MAX(I14*((1-($C$3)*(G14-(C14))/(C14))), 0))","v":0},{"$f":"K14*(C14)","v":0},"XXX",{"$f":"MIN(MAX((L14),(C14*0.013)),C14*0.45)","v":0}]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[]
["Properties With Encumbrances:"]
["Enter individually, add lines as needed"]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C26+E26)=0,0,MAX(I26*((1-($C$3)*(G26-(C26+E26))/(C26+E26))),0))","v":0},{"$f":"K26*(C26+E26)","v":0},{"$f":"E26*J26","v":0},{"$f":"MAX(MIN(MAX((L26-M26),(C26*0.013)),C26*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C27+E27)=0,0,MAX(I27*((1-($C$3)*(G27-(C27+E27))/(C27+E27))),0))","v":0},0,0,{"$f":"MAX(MIN(MAX((L27-M27),(C27*0.013)),C27*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,{"$f":"K90*(C90+E90)","v":0},{"$f":"E90*J90","v":0},0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C91+E91)=0,0,MAX(I91*((1-($C$3)*(G91-(C91+E91))/(C91+E91))),0))","v":0},0,0,{"$f":"MAX(MIN(MAX((L91-M91),(C91*0.013)),C91*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]

{"sheet":"real4","index":4,"n_rows":128,"n_cols":14,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
["Company Name",null,null,null,null,null,null,null,null,null,null,null,null,"Cocode: 00000"]
["Schedule BA Real Estate"]
["Fair Value adjustment factor",null,{"$f":"2/3","v":0.66666666666666663}]
["(1)",null,"(2)",null,"(3)",null,-4,null,"(5)","(6)","(7)","(8)","(9)","(10)"]
[null,null,"Book/Adjusted",null,null,null,null,null,null,"Encumbrances",null,"Gross RBC "]
[null,null,"Carrying",null,null,null,null,null,null,"credit","Adjusted",null,"Encumbrances","RBC"]
["Name / ID / Line",null,"Value",null,"Encumbrances",null,"Fair Value",null," Base Factor","Factor","RBC Factor","Requirement","Credit","Requirement"]
[]
["Total for All Lines",null,{"$f":"SUM(C13:C249)","v":0},null,{"$f":"SUM(E13:E249)","v":0},null,{"$f":"SUM(G13:G249)","v":0},null,null,null,null,{"$f":"SUM(L13:L249)","v":0},{"$f":"SUM(M13:M249)","v":0},{"$f":"SUM(N13:N249)","v":0}]
[]
["Properties Without Encumbrances:"]
["Enter individually, add lines as needed"]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF(C13=0,0,MAX(I13*((1-($C$3)*(G13-(C13))/(C13))), 0))","v":0},{"$f":"K13*(C13)","v":0},"XXX",{"$f":"MIN(MAX((L13),(C13*0.013)),C13*0.45)","v":0}]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF(C14=0,0,MAX(I14*((1-($C$3)*(G14-(C14))/(C14))), 0))","v":0},{"$f":"K14*(C14)","v":0},"XXX",{"$f":"MIN(MAX((L14),(C14*0.013)),C14*0.45)","v":0}]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[null,null,0,null,"XXX",null,0,null,0.1,1.7500000000000002E-2,0,0,"XXX",0]
[]
["Properties With Encumbrances:"]
["Enter individually, add lines as needed"]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C26+E26)=0,0,MAX(I26*((1-($C$3)*(G26-(C26+E26))/(C26+E26))),0))","v":0},{"$f":"K26*(C26+E26)","v":0},{"$f":"E26*J26","v":0},{"$f":"MAX(MIN(MAX((L26-M26),(C26*0.013)),C26*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C27+E27)=0,0,MAX(I27*((1-($C$3)*(G27-(C27+E27))/(C27+E27))),0))","v":0},{"$f":"K27*(C27+E27)","v":0},{"$f":"E27*J27","v":0},{"$f":"MAX(MIN(MAX((L27-M27),(C27*0.013)),C27*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,{"$f":"IF((C91+E91)=0,0,MAX(I91*((1-($C$3)*(G91-(C91+E91))/(C91+E91))),0))","v":0},{"$f":"K91*(C91+E91)","v":0},{"$f":"E91*J91","v":0},{"$f":"MAX(MIN(MAX((L91-M91),(C91*0.013)),C91*0.45),0)","v":0}]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]
[null,null,0,null,0,null,0,null,0.1,1.7500000000000002E-2,0,0,0,0]