{"text_format":"3","workbook":"xlsx","n_sheets":40,"sheets":["표지","1부.Ⅰ.1","1부.Ⅰ.2.1)","1부.Ⅰ.2.2)","1부.Ⅰ.3.1)","1부.Ⅰ.3.2)","1부.Ⅰ.4.1)","1부.Ⅰ.4.2)","1부.Ⅰ.4.3)","1부.Ⅰ.5","2부.Ⅰ","2부.Ⅰ.1.1)","2부.Ⅰ.1.2)","2부.Ⅰ.1.3)","2부.Ⅰ.2","2부.Ⅰ.3","2부.Ⅰ.4","2부.Ⅱ","3부.Ⅰ","3부.Ⅱ.1.1)","3부.Ⅱ.1.2)","3부.Ⅱ.2","3부.Ⅱ.3","3부.Ⅱ.4","3부.Ⅲ","3부.Ⅳ.1","3부.Ⅳ.2","3부.Ⅴ","4부.Ⅰ.1","4부.Ⅰ.2","5부.Ⅰ","5부.Ⅱ","5부.Ⅲ","5부.Ⅳ","5부.Ⅴ","5부.Ⅵ","5부.Ⅶ","6부.Ⅰ","7부.Ⅰ","8부.Ⅰ"],"not_rendered":{"images":2,"external_links":1,"defined_names":58},"read":"whole","date_system":"1900"}

{"sheet":"표지","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"merged":[[2,0,2,11],[4,3,4,6],[5,3,5,4],[5,6,5,7],[10,1,10,5],[12,3,12,8],[13,1,13,10],[16,9,16,10],[27,4,27,10],[28,4,28,10],[29,4,29,10],[30,4,30,5],[30,6,30,10],[31,4,31,5],[31,6,31,10],[32,4,32,5],[32,6,32,8],[33,4,33,5],[33,6,33,8],[34,4,34,5],[34,6,34,8],[35,4,35,5],[35,6,35,8],[38,0,38,11]]}
[]
[]
["투  자  보  고  서"]
[]
[]
[{"$nulls":3},"2021.06.01",null,"부터","2021.11.30",null,"까지"]
[]
[{"$nulls":4},"( 제",4,"기 )"]
[]
[]
[null,"국토교통부장관, 금융위원회 귀중"]
[]
[]
[null,"부동산투자회사법 제37조, 동법 시행령 제40조 및 부동산투자회사등에 관한 감독규정\n제7조의 규정에 의하여 투자보고서를 작성하여 제출합니다."]
[]
[]
[{"$nulls":9},"2022.02.28"]
{"$rows_empty":10}
[{"$nulls":3},"회  사   명  :","이에스알켄달스퀘어위탁관리부동산투자회사(주)"]
[{"$nulls":3},"대 표 이 사  :","박래익"]
[{"$nulls":3},"본점소재지 :","서울시 영등포구 국제금융로 10 Three IFC 35층"]
[{"$nulls":4},"(전화번호)",null,"02)6205-0474"]
[{"$nulls":4},"(홈페이지)",null,"http://www.esrks-reit.com"]
[{"$nulls":3},"작성책임자 :","(회사)",null,"켄달스퀘어리츠운용(주)",null,null,"(직책)","팀장"]
[{"$nulls":4},"(전화번호)",null,"02-6205-0474",null,null,"성명","김진숙"]
[{"$nulls":3},"공시책임자 :","(회사)",null,"켄달스퀘어리츠운용(주)",null,null,"(직책)","팀장"]
[{"$nulls":4},"(전화번호)",null,"02-6205-0474",null,null,"성명","김진숙"]
[]
[]
["*입력도움말\n1. 제출날짜(YYYY.MM.DD) 및 회사명, 대표이사, 본점소재지 등 내용을 직접 입력하시기 바랍니다.\n2. 대표이사, 작성책임자, 공시책임자의 도장 스캔본을 '(인)' 위에 각각 삽입 후 마우스 오른쪽버튼을 클릭하여 '맨 뒤로 보내기'를 클릭하시기 바랍니다.\n3. 표지 작성 후 '8부(재무제표) -> 그외 시트' 순으로 작성 바랍니다."]

{"sheet":"1부.Ⅰ.1","index":1,"n_rows":27,"n_cols":38,"rows_kept":27,"merged":[[1,0,1,36],[4,0,4,32],[6,1,6,15],[8,4,8,14],[8,15,8,25],[8,27,8,30],[8,31,8,35],[9,4,9,14],[9,15,9,36],[10,4,10,14],[10,15,10,36],[11,4,11,14],[11,15,11,19],[11,20,11,25],[11,26,11,36],[12,4,12,14],[12,15,12,25],[12,26,12,36],[13,4,13,14],[13,15,13,25],[13,26,13,36],[14,4,14,14],[14,15,14,25],[14,26,14,36],[15,4,15,14],[15,15,15,36],[16,4,16,14],[16,15,16,36],[17,4,17,14],[17,15,17,36],[18,4,21,14],[18,15,18,36],[19,15,19,36],[20,15,20,36],[21,15,21,36],[23,4,23,36],[26,0,26,36]]}
[]
["제 1 부 부동산투자회사의 현황"]
[]
[]
["Ⅰ. 회사의 현황"]
[]
[null,"1. 회사의 개요"]
[{"$nulls":37},"상장여부"]
[{"$nulls":4},"1) 회사명",{"$nulls":10},{"$f":"표지!E28","v":"이에스알켄달스퀘어위탁관리부동산투자회사(주)"},{"$nulls":10},{"$f":"IF(AL9=\"상장\",\"(\",\"\")","v":"("},{"$f":"IF(AL9=\"상장\",\"상장일자:\",\"\")","v":"상장일자:"},{"$nulls":3},"2020.12.23",{"$nulls":4},{"$f":"IF(AL9=\"상장\",\")\",\"\")","v":")"},"상장"]
[{"$nulls":4},"2) 설립일",{"$nulls":10},"2020.02.20"]
[{"$nulls":4},"3) 소재지",{"$nulls":10},{"$f":"표지!E30","v":"서울시 영등포구 국제금융로 10 Three IFC 35층"}]
[{"$nulls":4},"4) 자산 및 자본금, 부채",{"$nulls":10},"(기준일자)",{"$nulls":4},{"$f":"표지!G6","v":"2021.11.30"},{"$nulls":5},"(단위: 원)"]
[{"$nulls":4},"총 자 산",{"$nulls":10},{"$f":"'5부.Ⅰ'!U79","v":{"v":725325311393,"d":"725,325,311,393"}}]
[{"$nulls":4},"자 본 금",{"$nulls":10},{"$f":"'5부.Ⅰ'!U112","v":{"v":143259000000,"d":"143,259,000,000"}}]
[{"$nulls":4},"부     채",{"$nulls":10},{"$f":"'5부.Ⅰ'!U110","v":{"v":20922371809,"d":"20,922,371,809"}}]
[{"$nulls":4},"5) 자산관리회사",{"$nulls":10},"이에스알켄달스퀘어위탁관리부동산투자회사(주)"]
[{"$nulls":4},"6) 사무수탁회사",{"$nulls":10},"신한아이타스"]
[{"$nulls":4},"7) 자산보관회사",{"$nulls":10},"주식회사 신한은행"]
[{"$nulls":4},"8) 비고",{"$nulls":10},"(1) 정관에서 정한 회사의 존속기간 및 해산사유"]
[{"$nulls":15},"1. 존립기간을 정한 경우 그 존립기간의 만료\r\n2. 주주총회의 해산결의\r\n3. 합병\r\n4. 파산\r\n5. 법원의 해산명령 또는 해산판결\r\n6. 국토교통부장관의 영업인가 또는 등록의 취소\r\n7. 부투법 제3조부터 제7조까지의 규정을 위한하여 영업인가 또는 등록이 거부된 경우\r\n8. 설립 후 1년 6개월 이내에 영업인가를 받지 못하거나 등록을 하지 못한 경우\r"]
[{"$nulls":15},"(2) 신용평가결과"]
[]
[]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 양식 수정은 절대 금지하며, 셀 높이 조절만 가능합니다.\n2. 바탕색이 황갈색인 셀에만 데이터를 입력하시기 바랍니다.\n3. 날짜는 0000.00.00 형식으로 입력하시기 바랍니다.\n4. 상장여부를 반드시 체크하시기 바랍니다.\n5. '신용평가결과'는 추후 시행예정으로 시행 전까지 '해당사항 없음'으로 기재 바랍니다.\n"]

{"sheet":"1부.Ⅰ.2.1)","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"merged":[[1,1,1,15],[3,2,3,36],[5,4,8,36],[11,0,11,36]]}
[]
[null,"2. 회사의 연혁"]
[]
[null,null,"1) 설립경과 및 설립이후의 변동사항(상호의 변경, 영업양수 또는 영업양도, 주요 자산취득일 등을 기재)"]
[]
[{"$nulls":4},"- 2020.02.20: 발기설립\n- 2020.06.12: 자산관리위탁계약서 체결(켄달스퀘어리츠운용)\n- 2020.06.12: 일반사무수탁계약서 체결(신한아이타스)\n- 2020.06.12: 자산보관계약서 체결(신한은행)\n- 2020.08.24: 국토교통부 영업인가\n- 2020.08.31: 1차 자산관리위탁 변경계약 체결(켄달스퀘어리츠운용)\n- 2020.09.24: 이에스알켄달스퀘어에셋1호위탁관리부동산투자회사 발행주식 매수\n- 2020.10.19: 국토교통부 변경인가 승인\n- 2020.10.23: 2차 자산관리위탁 변경계약 체결(켄달스퀘어리츠운용)\n- 2020.10.27: 2차 유상증자(사모) 보통주47,300,000주(자본금 총액 482억원)\n- 2020.10.27: 제1회 기명식 전환사채 발행(1,180억원)(사채권자:CPPIB)\n- 2020.11.06: 증권신고서 제출\n- 2020.11.23: 증권신고서 효력 발생\n- 2020.12.10: 3차 유상증자(보통주 71,459,000주 / 자본금 총액 3,573억원)\n- 2020.12.11: 켄달스퀘어전문투자형사모부동산신탁6호의 B종 수익증권 매수(25,564,025,475좌)\n              켄달스퀘어전문투자형사모부동산신탁8호의 F종 수익증권 매수(25,643,009,474좌)\n              켄달스퀘어전문투자형사모부동산신탁611의 수익증권 매수(34,304,284,981좌)\n              켄달스퀘어전문투자형사모부동산신탁7호의 B종 수익증권 매수(31,526,694,806좌)\n- 2020.12.11: 켄달스퀘어전문투자형사모부동산신탁8호의 F종 수익증권 추가설정(12,100,000,000좌)\n              켄달스퀘어전문투자형사모부동산신탁11호의 수익증권 추가설정(7,800,000,000좌)\n              켄달스퀘어전문투자형사모부동산신탁7호의 B종 수익증권 추가설정(9,600,000,000좌)\n              켄달스퀘어전문투자형사모부동산신탁6호의 B종 수익증권 추가설정(11,700,000,000좌)\n- 2020.12.11: 전환사채(1,180억원) 23,600,000주 주식 전환(4차 유상증자)\n- 2020.12.11: 이에스알켄달스퀘어에셋1호위탁관리부동산투자회사주식회사 발행주식 매수(보통주 10,670,980주)\n- 2020.12.21: 유가증권시장 주권 신규상장 승인\n- 2020.12.23: 한국거래소 유가증권시장 상장\n- 2021.06.10: 켄달스퀘어전문투자형사모부동산신탁18호의 제1종 수익증권 매수(21,700,000,000좌)\n              및 2종 수익증권(3,000,000,000좌) 매수\n- 2021.06.11: 켄달스퀘어전문투자형사모부동산신탁18호의 제1종 수익증권 매수(1,698,138,840좌)\n- 2021.07.16: 이에스알켄달스퀘어에셋2호위탁관리부동산투자회사주식회사 설립자본금(보통주300,000주) 납입\n- 2021.11.25: 이에스알켄달스퀘어에셋2호위탁관리부동산투자회사주식회사 유상증자 참여(보통주 440,000주)\n\n"]
[]
[]
[]
[]
[]
["* 입력도움말\n1. 양식 수정은 절대 금지하며, 셀 높이 조절만 가능합니다.\n2. 바탕색이 황갈색인 셀에만 데이터를 입력하시기 바랍니다."]

{"sheet":"1부.Ⅰ.2.2)","index":3,"n_rows":32,"n_cols":38,"rows_kept":32,"merged":[[1,2,1,36],[3,3,3,36],[5,4,5,11],[5,12,5,18],[5,19,5,30],[5,31,5,36],[6,4,6,11],[6,12,6,18],[6,19,6,30],[6,31,6,36],[7,4,7,11],[7,12,7,18],[7,19,7,30],[7,31,7,36],[8,4,8,11],[8,12,8,18],[8,19,8,30],[8,31,8,36],[9,4,9,11],[9,12,9,18],[9,19,9,30],[9,31,9,36],[10,4,10,11],[10,12,10,18],[10,19,10,30],[10,31,10,36],[12,4,12,36],[13,4,13,36],[14,4,14,36],[16,3,16,36],[18,4,18,9],[18,10,18,15],[18,16,18,20],[18,21,18,30],[18,31,18,36],[19,4,19,9],[19,10,19,15],[19,16,19,20],[19,21,19,30],[19,31,19,36],[20,4,20,9],[20,10,20,15],[20,16,20,20],[20,21,20,30],[20,31,20,36],[21,4,21,9],[21,10,21,15],[21,16,21,20],[21,21,21,30],[21,31,21,36],[22,4,22,9],[22,10,22,15],[22,16,22,20],[22,21,22,30],[22,31,22,36],[23,4,23,9],[23,10,23,15],[23,16,23,20],[23,21,23,30],[23,31,23,36],[24,4,24,9],[24,10,24,15],[24,16,24,20],[24,21,24,30],[24,31,24,36],[26,4,26,36],[27,4,27,36],[28,4,28,36],[31,0,31,36]]}
[]
[null,null,"2) 발기인·이사 및 감사에 관한 사항"]
[]
[{"$nulls":3},"(1) 발기인에 관한 사항"]
[]
[{"$nulls":4},"성    명 ",{"$nulls":7},"생년월일 또는        법인등록번호",{"$nulls":6},"주요경력 및 연혁",{"$nulls":11},"비 고"]
[{"$nulls":4},"이에스알켄달스퀘어 주식회사",{"$nulls":7},"110111-5588350",{"$nulls":6},"2020.09. 사명 변경\n(켄달스퀘어로지스틱프로퍼티스 주식회사->이에스알켄달스퀘어 주식회사)",{"$nulls":11},"해당사항없음"]
[]
[]
[]
[]
[]
[{"$nulls":4},"※ 비고란에는 법 제7조의 결격요건 해당여부를 기재"]
[{"$nulls":4},"※ 주요경력은 주요근무지, 근무기간 및 직위등을 구체적으로 기재"]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[{"$nulls":3},"(2) 이사 및 감사에 관한 사항"]
[]
[{"$nulls":4},"직 명",{"$nulls":5},"성 명",{"$nulls":5},"생년월일",{"$nulls":4},"주요경력 및 연혁",{"$nulls":9},"비 고"]
[{"$nulls":4},"대표이사",{"$nulls":5},"박래익",{"$nulls":5},"1964.10.08",{"$nulls":4},"2018.7.16~ 현재 그레이프 주식회사",{"$nulls":9},"해당사항없음"]
[{"$nulls":4},"기타비상무이사",{"$nulls":5},"신유철",{"$nulls":5},"1965.03.01",{"$nulls":4},"2018.8. ~ 현재 변호사 신유철 법률사무소",{"$nulls":9},"해당사항없음"]
[{"$nulls":4},"기타비상무이사",{"$nulls":5},"조주현",{"$nulls":5},"1953.05.30",{"$nulls":4},"1988.9~2018.8 건국대학교 교수\r",{"$nulls":9},"해당사항없음"]
[{"$nulls":4},"기타비상무이사",{"$nulls":5},"조준우",{"$nulls":5},"1978.01.07",{"$nulls":4},"2010. 4. ~ 현재 법무법인 광장 변호사",{"$nulls":9},"해당사항없음"]
[{"$nulls":4},"기타비상무이사",{"$nulls":5},"하재창",{"$nulls":5},"1970.04.23",{"$nulls":4},"현재 한국교직원공제회 대체투자부 대체투자2팀 팀장",{"$nulls":9},"해당사항없음"]
[{"$nulls":4},"감사",{"$nulls":5},"김태헌",{"$nulls":5},"1983.12.21",{"$nulls":4},"2018.08.27 ~ 현재 대교회계법인 공인회계사",{"$nulls":9},"해당사항없음"]
[]
[{"$nulls":4},"※ 비고란에는 법 제14조의 결격요건 해당여부를 기재"]
[{"$nulls":4},"※ 주요경력은 주요근무지, 근무기간 및 직위등을 구체적으로 기재"]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 양식 수정은 절대 금지하며, 셀 높이 조절만 가능합니다.\n2. 바탕색이 황갈색인 셀에만 데이터를 입력하시기 바랍니다.\n3. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n4. 생년월일은 0000.00.00 형식으로 입력하시기 바랍니다."]

{"sheet":"1부.Ⅰ.3.1)","index":4,"n_rows":35,"n_cols":38,"rows_kept":35,"merged":[[1,1,1,15],[3,2,3,15],[5,3,5,36],[6,30,6,34],[6,35,6,36],[7,3,7,9],[7,10,7,12],[7,31,7,36],[8,2,8,7],[8,8,8,13],[8,14,8,20],[8,21,8,25],[8,26,8,30],[8,31,8,36],[9,2,9,7],[9,8,9,13],[9,14,9,20],[9,21,9,25],[9,26,9,30],[9,31,9,36],[10,2,10,7],[10,8,10,13],[10,14,10,20],[10,21,10,25],[10,26,10,30],[10,31,10,36],[11,2,11,7],[11,8,11,13],[11,14,11,20],[11,21,11,25],[11,26,11,30],[11,31,11,36],[12,2,12,7],[12,8,12,13],[12,14,12,20],[12,21,12,25],[12,26,12,30],[12,31,12,36],[14,4,14,36],[16,3,16,36],[17,31,17,36],[18,2,18,7],[18,8,18,13],[18,14,18,20],[18,21,18,29],[18,30,18,36],[19,2,19,7],[19,8,19,13],[19,14,19,20],[19,21,19,29],[19,30,19,36],[20,2,20,7],[20,8,20,13],[20,14,20,20],[20,21,20,29],[20,30,20,36],[22,4,22,36],[24,3,24,36],[26,2,26,36],[28,3,28,36],[30,2,30,36],[34,0,34,36]]}
[]
[null,"3. 주식 및 자본에 관한 사항"]
[]
[null,null,"1) 주식에 관한 사항"]
[]
[{"$nulls":3},"(1) 발행한 주식의 내용"]
[{"$nulls":29},"[",{"$f":"표지!G6","v":"2021.11.30"},{"$nulls":4},"현재]"]
[{"$nulls":31},"(단위 : 원, 주)"]
[null,null,"구 분",{"$nulls":5},"종 류",{"$nulls":5},"발행주식수",{"$nulls":6},"주당 발행가액",{"$nulls":4},"주당 액면가액",{"$nulls":4},"비 고"]
[null,null,"기명",{"$nulls":5},"보통주",{"$nulls":5},{"v":143259000,"d":"143,259,000"},{"$nulls":6},{"v":5000,"d":"5,000"},{"$nulls":4},{"v":1000,"d":"1,000"}]
[]
[]
[]
[]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[{"$nulls":3},"(2) 자기주식 취득현황"]
[{"$nulls":31},"(단위 : 원, 주)"]
[null,null,"취득일자",{"$nulls":5},"종 류",{"$nulls":5},"주식수량",{"$nulls":6},"취득가액",{"$nulls":8},"비 고"]
[]
[]
[]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[{"$nulls":3},"(3) 현물출자 현황"]
[]
[]
[]
[{"$nulls":3},"(4) 비고(주식매수선택권 여부, 의결권이 있는 주식수, 의결권이 제한된 주식수 등을 기재)"]
[]
[]
[]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 날짜는 0000.00.00 형식으로 입력하시기 바랍니다.\n3. 해당사항 없는 항목은 기재하지 마시기 바랍니다."]

{"sheet":"1부.Ⅰ.3.2)","index":5,"n_rows":21,"n_cols":39,"rows_kept":21,"merged":[[1,2,1,15],[2,30,2,37],[3,2,4,5],[3,6,4,7],[3,8,3,21],[3,22,4,27],[3,28,4,33],[3,34,4,37],[4,8,4,10],[4,11,4,15],[4,16,4,18],[4,19,4,21],[5,2,5,5],[5,6,5,7],[5,8,5,10],[5,11,5,15],[5,16,5,18],[5,19,5,21],[5,22,5,27],[5,28,5,33],[5,34,5,37],[6,2,6,5],[6,6,6,7],[6,8,6,10],[6,11,6,15],[6,16,6,18],[6,19,6,21],[6,22,6,27],[6,28,6,33],[6,34,6,37],[7,2,7,5],[7,6,7,7],[7,8,7,10],[7,11,7,15],[7,16,7,18],[7,19,7,21],[7,22,7,27],[7,28,7,33],[7,34,7,37],[8,2,8,5],[8,6,8,7],[8,8,8,10],[8,11,8,15],[8,16,8,18],[8,19,8,21],[8,22,8,27],[8,28,8,33],[8,34,8,37],[10,4,10,37],[11,2,11,16],[12,2,12,15],[14,2,14,37],[20,0,20,37]]}
[]
[null,null,"2) 자본금 변동상황"]
[{"$nulls":30},"(단위 : 원, 주)"]
[null,null,"일자",{"$nulls":3},"원인",null,"증가(감소)한 주식의 내용",{"$nulls":13},"증(감)자한\n자본금",{"$nulls":5},"증(감)자 후 \n자본금",{"$nulls":5},"증(감)자\n비율"]
[{"$nulls":8},"종류",null,null,"수량",{"$nulls":4},"주당\n발행가액",null,null,"주당\n액면가액"]
[null,null,"2020.\n02.20",{"$nulls":3},"설립자본",null,"보통주",null,null,{"v":900000,"d":"900,000"},{"$nulls":4},{"v":5000,"d":"5,000"},null,null,{"v":1000,"d":"1,000"},null,null,{"v":900000000,"d":"900,000,000"},{"$nulls":5},{"v":900000000,"d":"900,000,000"},{"$nulls":5},{"v":0,"d":"0.0%"}]
[null,null,"2020.\n10.27",{"$nulls":3},"증자",null,"보통주",null,null,{"v":47300000,"d":"47,300,000"},{"$nulls":4},{"v":5000,"d":"5,000"},null,null,{"v":1000,"d":"1,000"},null,null,{"v":47300000000,"d":"47,300,000,000"},{"$nulls":5},{"v":48200000000,"d":"48,200,000,000"},{"$nulls":5},{"v":52.555556,"d":"5255.6%"}]
[null,null,"2020.\n12.11",{"$nulls":3},"증자",null,"보통주",null,null,{"v":71459000,"d":"71,459,000"},{"$nulls":4},{"v":5000,"d":"5,000"},null,null,{"v":1000,"d":"1,000"},null,null,{"v":71459000000,"d":"71,459,000,000"},{"$nulls":5},{"v":119659000000,"d":"119,659,000,000"},{"$nulls":5},{"v":1.482552,"d":"148.3%"}]
[null,null,"2020.\n12.11",{"$nulls":3},"증자",null,"보통주",null,null,{"v":23600000,"d":"23,600,000"},{"$nulls":4},{"v":5000,"d":"5,000"},null,null,{"v":1000,"d":"1,000"},null,null,{"v":23600000000,"d":"23,600,000,000"},{"$nulls":5},{"v":143259000000,"d":"143,259,000,000"},{"$nulls":5},{"v":0.197,"d":"19.7%"}]
[]
[{"$nulls":38},"← 필요시 주석 기재"]
[]
[null,null,"3) 자본금 변동예정 등"]
{"$rows_empty":7}
["* 입력도움말\n1. 2) 자본금 변동상황은 설립시부터 적어주시기 바라며, 필요시 행추가(복사한 셀 삽입)하여 \n   작성해주시기 바랍니다.\n2. 감자로 자본금이 감소할 경우는 수량을 음수(-)로 작성해주시기 바랍니다.\n    (예) : △50,000,000 (X) / -50,000,000(O)\n3. 증자비율: 증가금액(수량X주당액면가액)/증(감)자 전 자본금\n    감자비율: 감소금액(수량X주당액면가액)/증(감)자 전 자본금\n4. 해당사항 없는 항목은 기재하지 마시기 바랍니다."]

{"sheet":"1부.Ⅰ.4.1)","index":6,"n_rows":20,"n_cols":48,"rows_kept":20,"merged":[[1,1,1,25],[3,2,3,32],[4,38,4,42],[4,43,4,45],[5,2,6,6],[5,7,6,9],[5,10,6,12],[5,13,6,15],[5,16,6,17],[5,18,6,20],[5,21,6,23],[5,24,5,41],[5,42,6,46],[6,24,6,28],[6,29,6,32],[6,33,6,36],[6,37,6,41],[7,2,8,6],[7,7,8,9],[7,10,8,12],[7,13,8,15],[7,16,8,17],[7,18,8,20],[7,21,8,23],[7,24,7,28],[7,29,7,32],[7,33,7,36],[7,37,7,41],[7,42,8,46],[8,24,8,28],[8,29,8,32],[8,33,8,36],[8,37,8,41],[9,2,10,6],[9,7,10,9],[9,10,10,12],[9,13,10,15],[9,16,10,17],[9,18,10,20],[9,21,10,23],[9,24,9,28],[9,29,9,32],[9,33,9,36],[9,37,9,41],[9,42,10,46],[10,24,10,28],[10,29,10,32],[10,33,10,36],[10,37,10,41],[11,2,12,6],[11,7,12,9],[11,10,12,12],[11,13,12,15],[11,16,12,17],[11,18,12,20],[11,21,12,23],[11,24,11,28],[11,29,11,32],[11,33,11,36],[11,37,11,41],[11,42,12,46],[12,24,12,28],[12,29,12,32],[12,33,12,36],[12,37,12,41],[14,4,14,36],[15,4,15,36],[16,4,16,46],[19,0,19,46]]}
[]
[null,"4. 주주현황"]
[]
[null,null,"1) 최대주주 및 그 특별관계자의 주식소유현황"]
[{"$nulls":37},"【",{"$f":"표지!G6","v":"2021.11.30"},{"$nulls":4},"현재",null,null,"】"]
[null,null,"성명",{"$nulls":4},"관계",null,null,"내/\n외국인",null,null,"국적",null,null,"기관/개인",null,"청약예외주주",null,null,"주식의\n종류",null,null,"소유주식수(지분율)",{"$nulls":17},"변동원인"]
[{"$nulls":24},"기초",{"$nulls":4},"증가",{"$nulls":3},"감소",{"$nulls":3},"기말"]
[null,null,"CPPInvest mentBoard RealEstate Holdingsinc",{"$nulls":4},"최대주주",null,null,"외국인",null,null,"캐나다",null,null,"기관",null,"해당사항없음",null,null,"보통주",null,null,{"v":35600000,"d":"35,600,000"},{"$nulls":12},{"$f":"Y8+AD8-AH8","v":{"v":35600000,"d":"35,600,000"}}]
[{"$nulls":24},{"v":0.2485,"d":"(24.85%)"},{"$nulls":12},{"v":0.2485,"d":"(24.85%)"}]
[null,null,"ESR Kendall Square REIT Holding",{"$nulls":4},"특별관계자",null,null,"외국인",null,null,"싱가포르",null,null,"기관",null,"해당사항없음",null,null,"보통주",null,null,{"v":9200000,"d":"9,200,000"},{"$nulls":12},{"$f":"Y10+AD10-AH10","v":{"v":9200000,"d":"9,200,000"}}]
[{"$nulls":24},{"v":0.0642,"d":"(6.42%)"},{"$nulls":12},{"v":0.0642,"d":"(6.42%)"}]
[null,null,"켄달스퀘어리츠운용㈜",{"$nulls":4},"특별관계자",null,null,"내국인",null,null,"대한민국",null,null,"기관",null,"해당사항없음",null,null,"보통주",null,null,{"v":1000000,"d":"1,000,000"},{"$nulls":12},{"$f":"Y12+AD12-AH12","v":{"v":1000000,"d":"1,000,000"}}]
[{"$nulls":24},{"v":0.007,"d":"(0.70%)"},{"$nulls":12},{"v":0.007,"d":"(0.70%)"}]
[]
[{"$nulls":4},"※ 특별관계자는 자본시장법 시행령 제141조제1항의 특수관계인 및 공동보유자를 말함"]
[{"$nulls":4},"※ 청약예외주주란에는 시행령 제12조의3(일반청약에 대한 예외) 각 호 중 해당되는 호를 기재"]
[{"$nulls":47},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다. \n2. 지분율은 숫자만 입력하시기 바랍니다.(괄호 자동표시)\n3. 공모 회사 중 필요한 경우 기준일자를 직접 입력하고, 그 일자 기준의 주주현황을 입력하시기 바랍니다."]

{"sheet":"1부.Ⅰ.4.2)","index":7,"n_rows":14,"n_cols":51,"rows_kept":14,"merged":[[1,2,1,45],[2,41,2,45],[2,46,2,48],[3,2,3,5],[3,6,3,10],[3,11,3,14],[3,15,3,18],[3,19,3,22],[3,23,3,26],[3,27,3,30],[3,31,3,38],[3,39,3,44],[3,45,3,49],[4,2,4,5],[4,6,4,10],[4,11,4,14],[4,15,4,18],[4,19,4,22],[4,23,4,26],[4,27,4,30],[4,31,4,38],[4,39,4,44],[4,45,4,49],[5,2,5,5],[5,6,5,10],[5,11,5,14],[5,15,5,18],[5,19,5,22],[5,23,5,26],[5,27,5,30],[5,31,5,38],[5,39,5,44],[5,45,5,49],[6,2,6,5],[6,6,6,10],[6,11,6,14],[6,15,6,18],[6,19,6,22],[6,23,6,26],[6,27,6,30],[6,31,6,38],[6,39,6,44],[6,45,6,49],[8,4,8,49],[13,0,13,49]]}
[]
[null,null,"2) 주요주주(10%이상 주주)의 주식소유현황"]
[{"$nulls":40},"【",{"$f":"표지!G6","v":"2021.11.30"},{"$nulls":4},"현재",null,null,"】"]
[null,null,"순위",{"$nulls":3},"성명",{"$nulls":4},"내/\n외국인",{"$nulls":3},"국적",{"$nulls":3},"기관/\n개인",{"$nulls":3},"청약예외주주",{"$nulls":3},"주식의 \n종류",{"$nulls":3},"소유주식수",{"$nulls":7},"지분율",{"$nulls":5},"비고"]
[null,null,1]
[null,null,2]
[null,null,3]
[]
[{"$nulls":50},"← 필요시 주석 기재"]
[]
[]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다. \n2. 공모 회사 중 필요한 경우 기준일자를 직접 입력하고, 그 일자 기준의 주주현황을 입력하시기 바랍니다.\n\n\n"]

{"sheet":"1부.Ⅰ.4.3)","index":8,"n_rows":25,"n_cols":38,"rows_kept":25,"merged":[[1,2,1,36],[2,28,2,32],[2,33,2,35],[3,2,3,8],[3,9,3,12],[3,13,3,18],[3,19,3,25],[3,26,3,31],[3,32,3,36],[4,2,4,8],[4,9,4,12],[4,13,4,18],[4,19,4,25],[4,26,4,31],[4,32,4,36],[5,2,5,8],[5,9,5,12],[5,13,5,18],[5,19,5,25],[5,26,5,31],[5,32,5,36],[6,2,6,8],[6,9,6,12],[6,13,6,18],[6,19,6,25],[6,26,6,31],[6,32,6,36],[7,2,7,8],[7,9,7,12],[7,13,7,18],[7,19,7,25],[7,26,7,31],[7,32,7,36],[8,2,8,8],[8,9,8,12],[8,13,8,18],[8,19,8,25],[8,26,8,31],[8,32,8,36],[10,4,10,36],[13,2,13,36],[15,2,15,10],[15,11,15,12],[15,14,15,15],[15,18,15,19],[15,21,15,22],[15,25,15,26],[15,28,15,29],[15,32,15,36],[16,2,16,10],[16,11,16,17],[16,18,16,24],[16,25,16,31],[16,32,16,36],[17,2,17,10],[17,11,17,17],[17,18,17,24],[17,25,17,31],[17,32,17,36],[18,2,18,10],[18,11,18,17],[18,18,18,24],[18,25,18,31],[18,32,18,36],[19,2,19,10],[19,11,19,17],[19,18,19,24],[19,25,19,31],[19,32,19,36],[20,4,20,36],[21,4,21,36],[24,0,24,36]]}
[]
[null,null,"3) 소액주주, 최대주주 및 기타주주 분포"]
[{"$nulls":27},"【 ",{"$f":"표지!G6","v":"2021.11.30"},{"$nulls":4},"현재",null,null,"】"]
[null,null,"구분",{"$nulls":6},"주주수(명)",{"$nulls":3},"비율",{"$nulls":5},"주식수",{"$nulls":6},"비율",{"$nulls":5},"비고"]
[null,null,"최대주주",{"$nulls":6},3,{"$nulls":3},{"$f":"IFERROR(J5/SUM($J$5:$M$8),\"\")","v":{"v":1.2659296143134442E-4,"d":"0.01%"}},{"$nulls":5},{"v":45800000,"d":"45,800,000"},{"$nulls":6},{"$f":"IFERROR(T5/SUM($T$5:$Z$8),\"\")","v":{"v":0.3197006819815858,"d":"31.97%"}},{"$nulls":5},"특수관계자포함"]
[null,null,"주요주주",{"$nulls":6},"-",{"$nulls":3},"-",{"$nulls":5},"-",{"$nulls":6},"-",{"$nulls":5},"-"]
[null,null,"소액주주\n - 개인",{"$nulls":6},{"v":23680,"d":"23,680"},{"$nulls":3},{"$f":"IFERROR(J7/SUM($J$5:$M$8),\"\")","v":{"v":0.999240442231412,"d":"99.92%"}},{"$nulls":5},{"v":46692801,"d":"46,692,801"},{"$nulls":6},{"$f":"IFERROR(T7/SUM($T$5:$Z$8),\"\")","v":{"v":0.32593275815132033,"d":"32.59%"}},{"$nulls":5},"발행주식 총수의 1%이하 보유 주수 포함"]
[null,null,"소액주주 \n- 법인",{"$nulls":6},15,{"$nulls":3},{"$f":"IFERROR(J8/SUM($J$5:$M$8),\"\")","v":{"v":6.3296480715672207E-4,"d":"0.06%"}},{"$nulls":5},{"v":50766199,"d":"50,766,199"},{"$nulls":6},{"$f":"IFERROR(T8/SUM($T$5:$Z$8),\"\")","v":{"v":0.35436655986709387,"d":"35.44%"}},{"$nulls":5},"발행주식 총수의 1%이상 보유 주수 포함"]
[null,null,"합 계",{"$nulls":6},{"$f":"SUM(J5:M8)","v":{"v":23698,"d":"23,698"}},{"$nulls":3},{"$f":"SUM(N5:S8)","v":{"v":1,"d":"100.00%"}},{"$nulls":5},{"$f":"SUM(T5:Z8)","v":{"v":143259000,"d":"143,259,000"}},{"$nulls":6},{"$f":"SUM(AA5:AF8)","v":{"v":1,"d":"100.00%"}}]
[]
[{"$nulls":4},"*발행주식 총수와 최대주주 보유주식수 차이중 1%이상은 소액주주-법인으로 분류하고, 1%이하는 소액주주-개인으로 분류하였음. 실제 주식 소유현황과 차이날 수 있음.",{"$nulls":32},"← 필요시 주석 기재"]
[]
[]
[null,null,"4) 주가변동사항"]
[]
[null,null,"월별",{"$nulls":8},21,null,"년",11,null,"월",null,21,null,"년",10,null,"월",null,21,null,"년",9,null,"월",null,"비고"]
[null,null,"최고가(일자)",{"$nulls":8},"6,770원(01일)",{"$nulls":6},"6,810원(29일)",{"$nulls":6},"6,820원(01일)"]
[null,null,"최저가(일자)",{"$nulls":8},"6,470원\n(10,15,18일)",{"$nulls":6},"6,310원(06일)",{"$nulls":6},"6,380원(30일)"]
[null,null,"월간 거래량",{"$nulls":8},{"v":5780726,"d":"5,780,726"},{"$nulls":6},{"v":4494911,"d":"4,494,911"},{"$nulls":6},{"v":5155269,"d":"5,155,269"}]
[null,null,"일평균 거래량",{"$nulls":8},{"v":262760,"d":"262,760"},{"$nulls":6},{"v":236574,"d":"236,574"},{"$nulls":6},{"v":271330,"d":"271,330"}]
[{"$nulls":4},"※ 주가는 월별 종가기준으로 기재"]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 공모 회사 중 필요한 경우 기준일자를 직접 입력하고, 그 일자 기준의 주주현황을 입력하시기 \n    바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n\n"]

{"sheet":"1부.Ⅰ.5","index":9,"n_rows":57,"n_cols":33,"rows_kept":57,"merged":[[1,1,1,15],[3,2,3,15],[5,2,5,31],[7,2,7,22],[8,3,8,9],[8,10,8,12],[8,26,8,31],[9,2,9,7],[10,2,10,7],[10,8,10,13],[10,14,10,19],[10,20,10,25],[10,26,10,31],[11,2,11,7],[11,8,11,13],[11,14,11,19],[11,20,11,25],[11,26,11,31],[12,2,12,7],[12,8,12,13],[12,14,12,19],[12,20,12,25],[12,26,12,31],[13,2,13,7],[13,8,13,13],[13,14,13,19],[13,20,13,25],[13,26,13,31],[14,2,14,7],[14,8,14,13],[14,14,14,19],[14,20,14,25],[14,26,14,31],[15,2,15,7],[15,8,15,13],[15,14,15,19],[15,20,15,25],[15,26,15,31],[16,2,16,7],[16,8,16,13],[16,14,16,19],[16,20,16,25],[16,26,16,31],[17,2,17,7],[17,8,17,13],[17,14,17,19],[17,20,17,25],[17,26,17,31],[18,4,18,31],[19,4,19,31],[20,4,20,31],[21,4,21,31],[22,4,22,31],[23,4,23,31],[24,4,24,31],[26,3,26,13],[26,26,26,31],[27,2,27,7],[28,2,28,7],[28,8,28,13],[28,14,28,19],[28,20,28,25],[28,26,28,31],[29,2,29,7],[29,8,29,13],[29,14,29,19],[29,20,29,25],[29,26,29,31],[30,2,30,7],[30,8,30,13],[30,14,30,19],[30,20,30,25],[30,26,30,31],[31,2,31,7],[31,8,31,13],[31,14,31,19],[31,20,31,25],[31,26,31,31],[32,2,32,7],[32,8,32,13],[32,14,32,19],[32,20,32,25],[32,26,32,31],[33,2,33,7],[33,8,33,13],[33,14,33,19],[33,20,33,25],[33,26,33,31],[34,2,34,7],[34,8,34,13],[34,14,34,19],[34,20,34,25],[34,26,34,31],[36,3,36,31],[38,26,38,31],[39,2,39,7],[40,2,40,7],[40,8,40,13],[40,14,40,19],[40,20,40,25],[40,26,40,31],[41,2,41,7],[41,8,41,13],[41,14,41,19],[41,20,41,25],[41,26,41,31],[42,2,42,7],[42,8,42,13],[42,14,42,19],[42,20,42,25],[42,26,42,31],[43,2,43,7],[43,8,43,13],[43,14,43,19],[43,20,43,25],[43,26,43,31],[44,2,44,7],[44,8,44,13],[44,14,44,19],[44,20,44,25],[44,26,44,31],[45,2,45,7],[45,8,45,13],[45,14,45,19],[45,20,45,25],[45,26,45,31],[46,2,46,7],[46,8,46,13],[46,14,46,19],[46,20,46,25],[46,26,46,31],[47,2,47,7],[47,8,47,13],[47,14,47,19],[47,20,47,25],[47,26,47,31],[48,2,48,7],[48,8,48,13],[48,14,48,19],[48,20,48,25],[48,26,48,31],[49,2,49,7],[49,8,49,13],[49,14,49,19],[49,20,49,25],[49,26,49,31],[51,3,51,31],[56,0,56,31]]}
[]
[null,"5. 배당에 관한 사항"]
[]
[null,null,"1) 이익 등의 분배방침"]
[]
[null,null,"가. 배당가능이익\n부동산투자회사법 제28조 배당 규정에 의거하여 배당할 계획이며, 그 구체적 계획에 대하여는 정관에서 정함.\n나. 배당정책\n- 배당가능이익의 90% 이상을 현금배당\n다. 배당금 지급 시기 및 결정방법\n- 회계연도는 매년 6월 1일 개시하여 11월 30일에 종료하고, 12월 1일에 개시하여 5월 31일에 종료할 계획임.\n- 최초 회계연도는 당해 회사의 설립일에 개시하여 2020년 5월 31일에 종료할 계획임.\n- 배당금은 정기주주총회 또는 제51조 제5항에 따른 이사회의 결의로 승인을 받아 매 사업연도 종료일 현재 주주명부에 기재된 주주 또는 등록된 질권자에게 지급하며, 배당금은 배당금 승인을 한 정기주주총회 또는 이사회에서 달리 결정되지 않는 한 정기주주총회 또는 이사회의 승인일로부터 1개월 내에 지급할 계획임."]
[]
[null,null,"2) 최근 사업연도의 배당에 관한 사항"]
[{"$nulls":3},"[주당액면가액 :",{"$nulls":6},{"v":1000,"d":"1,000"},null,null,"원","]",{"$nulls":11},"(단위 : 원, %)"]
[null,null,"구분",{"$nulls":7},"제",4,"기",{"$nulls":3},"제",3,"기",{"$nulls":3},"제",2,"기",{"$nulls":3},"제",1,"기"]
[null,null,"당기순이익",{"$nulls":5},{"$f":"'5부.Ⅱ'!U73","v":{"v":18889201443,"d":"18,889,201,443"}},{"$nulls":5},{"v":-496229966,"d":"-496,229,966 "},{"$nulls":5},{"v":-1321492232,"d":"-1,321,492,232 "},{"$nulls":5},{"v":-125133733,"d":"-125,133,733 "}]
[null,null,"상법상\n배당가능이익",{"$nulls":5},{"v":20040809374,"d":"20,040,809,374"},{"$nulls":5},{"v":19715144069,"d":"19,715,144,069"},{"$nulls":5},0,{"$nulls":5},0]
[null,null,"당기감가상각비 등",{"$nulls":5},{"$f":"I32+I33","v":0},{"$nulls":5},{"$f":"O32+O33","v":0},{"$nulls":5},{"$f":"U32+U33","v":0},{"$nulls":5},{"$f":"AA32+AA33","v":0}]
[null,null,"이익배당한도",{"$nulls":5},{"$f":"I12+I13","v":{"v":20040809374,"d":"20,040,809,374"}},{"$nulls":5},{"$f":"O12+O13","v":{"v":19715144069,"d":"19,715,144,069"}},{"$nulls":5},{"$f":"U12+U13","v":0},{"$nulls":5},{"$f":"AA12+AA13","v":0}]
[null,null,"배당금",{"$nulls":5},{"$f":"'5부.Ⅲ'!O20","v":{"v":19196706000,"d":"19,196,706,000"}},{"$nulls":5},{"v":19263536138,"d":"19,263,536,138"},{"$nulls":5},0,{"$nulls":5},0]
[null,null,"주당배당금",{"$nulls":5},134,{"$nulls":5},{"v":134.46,"d":"134"},{"$nulls":5},0,{"$nulls":5},0]
[null,null,"배당수익율",{"$nulls":5},{"$f":"IF(ISERROR(I15/((I34+I35)/2)*100),\"-\",I15/((I34+I35)/2))","v":{"v":0.028035203916485105,"d":"2.80%"}},{"$nulls":5},{"$f":"IF(ISERROR(O15/((O34+O35)/2)*100),\"-\",O15/((O34+O35)/2))","v":{"v":0.04161259166742674,"d":"4.16%"}},{"$nulls":5},{"$f":"IF(ISERROR(U15/((U34+U35)/2)*100),\"-\",U15/((U34+U35)/2))","v":{"v":0,"d":"0.00%"}},{"$nulls":5},{"$f":"IF(ISERROR(AA15/((AA34+AA35)/2)*100),\"-\",AA15/((AA34+AA35)/2))","v":{"v":0,"d":"0.00%"}}]
[null,null,"연환산배당율",{"$nulls":5},{"$f":"IF(ISERROR(I17*365/I31),\"-\",I17*365/I31)","v":{"v":0.055917209997361,"d":"5.59%"}},{"$nulls":5},{"$f":"IF(ISERROR(O17*365/O31),\"-\",O17*365/O31)","v":{"v":0.08345382394841078,"d":"8.35%"}},{"$nulls":5},{"$f":"IF(ISERROR(U17*365/U31),\"-\",U17*365/U31)","v":{"v":0,"d":"0.00%"}},{"$nulls":5},{"$f":"IF(ISERROR(AA17*365/AA31),\"-\",AA17*365/AA31)","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":4},"※ 상법상 배당가능이익 : 순자산가액 - 자본금 - 자본준비금 - 상법 시행령 제19조의 미실현이익 \n                                  - 기타(주식할인발행차금 상각액 등)"]
[{"$nulls":4},"※ 당기 감가상각비 등 : 당기 감가상각비 + 전기이전 감가상각비 초과배당누적액"]
[{"$nulls":4},"※ 이익배당한도 : 상법상 배당가능이익 + 당기 감가상각비 등"]
[{"$nulls":4},"※ 주당배당금 : 배당금 / 발행주식수"]
[{"$nulls":4},"※ 배당수익율 : 배당액 / [ (기초납입자본금+기말납입자본금)/2 ] 로 계산"]
[{"$nulls":4},"※ 1기의 사업연도가 1년 미만일 경우, 비교목적으로 연환산배당율을 다음의 산식으로 추가기재 \n   연환산배당율 : 배당수익율 x 365일 / (해당사업연도의 일수)"]
[{"$nulls":32},"← 필요시 주석 기재"]
[]
[{"$nulls":3},"* 산출근거자료",{"$nulls":22},"(단위 : 원)"]
[null,null,"구분",{"$nulls":7},"제",{"$f":"L10","v":4},"기",{"$nulls":3},"제",{"$f":"R10","v":3},"기",{"$nulls":3},"제",{"$f":"X10","v":2},"기",{"$nulls":3},"제",{"$f":"AD10","v":1},"기"]
[null,null,"기수시작일",{"$nulls":5},"2021-06-01",{"$nulls":5},"2020-12-01",{"$nulls":5},"2020-06-01",{"$nulls":5},"2020-02-20"]
[null,null,"기수종료일",{"$nulls":5},"2021-11-30",{"$nulls":5},"2021-05-31",{"$nulls":5},"2020-11-30",{"$nulls":5},"2020-05-31"]
[null,null,"사업일수",{"$nulls":5},{"$f":"IFERROR(IF(I29>0, I30-I29+1, \" \"),\"\")","v":183},{"$nulls":5},{"$f":"IFERROR(IF(O29>0, O30-O29+1, \" \"),\"\")","v":182},{"$nulls":5},{"$f":"IFERROR(IF(U29>0, U30-U29+1, \" \"),\"\")","v":183},{"$nulls":5},{"$f":"IFERROR(IF(AA29>0, AA30-AA29+1, \" \"),\"\")","v":102}]
[null,null,"당기 감가상각비",{"$nulls":5},0,{"$nulls":5},0,{"$nulls":5},0,{"$nulls":5},0]
[null,null,"전기이전\n감가상각비\n초과배당누적액",{"$nulls":5},0,{"$nulls":5},0,{"$nulls":5},0,{"$nulls":5},0]
[null,null,"기초납입자본금",{"$nulls":5},{"$f":"'5부.Ⅰ'!AG112+'5부.Ⅰ'!AG115","v":{"v":685109342670,"d":"685,109,342,670"}},{"$nulls":5},{"v":240741961760,"d":"240,741,961,760"},{"$nulls":5},{"v":4492289000,"d":"4,492,289,000"},{"$nulls":5},0]
[null,null,"기말납입자본금",{"$nulls":5},{"$f":"'5부.Ⅰ'!U112+'5부.Ⅰ'!U115","v":{"v":684362130210,"d":"684,362,130,210"}},{"$nulls":5},{"v":685109342670,"d":"685,109,342,670"},{"$nulls":5},{"v":240741961760,"d":"240,741,961,760"},{"$nulls":5},{"v":4492289000,"d":"4,492,289,000"}]
[]
[{"$nulls":3},"※ 납입자본금은 액면가액이 아닌 발행가액을 기준하여 적용"]
[]
[{"$nulls":3},"- 우선주 및 보통주의 배당에 관한 사항",{"$nulls":22},"(단위 : 원, %)"]
[null,null,"구분",{"$nulls":7},"제",{"$f":"L10","v":4},"기",{"$nulls":3},"제",{"$f":"R10","v":3},"기",{"$nulls":3},"제",{"$f":"X10","v":2},"기",{"$nulls":3},"제",{"$f":"AD10","v":1},"기"]
[null,null,"(우선주)\n배당금총액",{"$nulls":5},{"$f":"'5부.Ⅲ'!O22+'5부.Ⅲ'!O24","v":0},{"$nulls":5},0,{"$nulls":5},0,{"$nulls":5},0]
[null,null,"(우선주)\n배당수익율",{"$nulls":5},{"$f":"IF(ISERROR(I41/((I47+I48)/2)*100),\"-\",I41/((I47+I48)/2))","v":"-"},{"$nulls":5},{"$f":"IF(ISERROR(O41/((O47+O48)/2)*100),\"-\",O41/((O47+O48)/2))","v":"-"},{"$nulls":5},{"$f":"IF(ISERROR(U41/((U47+U48)/2)*100),\"-\",U41/((U47+U48)/2))","v":"-"},{"$nulls":5},{"$f":"IF(ISERROR(AA41/((AA47+AA48)/2)*100),\"-\",AA41/((AA47+AA48)/2))","v":"-"}]
[null,null,"(우선주)\n연환산배당율",{"$nulls":5},{"$f":"IF(ISERROR(I42*365/I31),\"-\",I42*365/I31)","v":"-"},{"$nulls":5},{"$f":"IF(ISERROR(O42*365/O31),\"-\",O42*365/O31)","v":"-"},{"$nulls":5},{"$f":"IF(ISERROR(U42*365/U31),\"-\",U42*365/U31)","v":"-"},{"$nulls":5},{"$f":"IF(ISERROR(AA42*365/AA31),\"-\",AA42*365/AA31)","v":"-"}]
[null,null,"(보통주)\n배당금총액",{"$nulls":5},{"$f":"'5부.Ⅲ'!O21+'5부.Ⅲ'!O23","v":{"v":19196706000,"d":"19,196,706,000"}},{"$nulls":5},0,{"$nulls":5},0,{"$nulls":5},0]
[null,null,"(보통주)\n배당수익율",{"$nulls":5},{"$f":"IF(ISERROR(I44/((I49+I50)/2)*100),\"-\",I44/((I49+I50)/2))","v":{"v":0.16042843413366317,"d":"16.04%"}},{"$nulls":5},{"$f":"IF(ISERROR(O44/((O49+O50)/2)*100),\"-\",O44/((O49+O50)/2))","v":{"v":0,"d":"0.00%"}},{"$nulls":5},{"$f":"IF(ISERROR(U44/((U49+U50)/2)*100),\"-\",U44/((U49+U50)/2))","v":{"v":0,"d":"0.00%"}},{"$nulls":5},{"$f":"IF(ISERROR(AA44/((AA49+AA50)/2)*100),\"-\",AA44/((AA49+AA50)/2))","v":{"v":0,"d":"0.00%"}}]
[null,null,"(보통주)\n연환산배당율",{"$nulls":5},{"$f":"IF(ISERROR(I45*365/I31),\"-\",I45*365/I31)","v":{"v":0.3199802101573063,"d":"32.00%"}},{"$nulls":5},{"$f":"IF(ISERROR(O45*365/O31),\"-\",O45*365/O31)","v":{"v":0,"d":"0.00%"}},{"$nulls":5},{"$f":"IF(ISERROR(U45*365/U31),\"-\",U45*365/U31)","v":{"v":0,"d":"0.00%"}},{"$nulls":5},{"$f":"IF(ISERROR(AA45*365/AA31),\"-\",AA45*365/AA31)","v":{"v":0,"d":"0.00%"}}]
[null,null,"(우선주)\n기초납입자본금",{"$nulls":5},0,{"$nulls":5},0,{"$nulls":5},0,{"$nulls":5},0]
[null,null,"(우선주)\n기말납입자본금",{"$nulls":5},0,{"$nulls":5},0,{"$nulls":5},0,{"$nulls":5},0]
[null,null,"(보통주)\n기초납입자본금",{"$nulls":5},{"v":119659000000,"d":"119,659,000,000"},{"$nulls":5},{"v":48200000000,"d":"48,200,000,000"},{"$nulls":5},{"v":900000000,"d":"900,000,000"},{"$nulls":5},0]
[null,null,"(보통주)\n기말납입자본금",{"$nulls":5},{"v":119659000000,"d":"119,659,000,000"},{"$nulls":5},{"v":119659000000,"d":"119,659,000,000"},{"$nulls":5},{"v":48200000000,"d":"48,200,000,000"},{"$nulls":5},{"v":900000000,"d":"900,000,000"}]
[]
[{"$nulls":3},"※ 납입자본금은 액면가액이 아닌 발행가액을 기준하여 적용"]
[]
[]
[]
[]
["* 입력도움말\n1. 1) 이익 등의 분배방침 내용입력시 내용이 많을 경우 셀높이를 조절하시기 바랍니다.\n2. 기수는 표 왼쪽부터 최근 기수를 입력하여 주시기 바랍니다.\n3. 산출근거자료표의 사업일수 자동계산을 위해 '기수시작일', '기수종료일'은 0000-00-00 형식으로 입력하시기 바랍니다.\n4. 1기의 기초납입자본금은 설립납입자본금으로 입력하시기 바랍니다."]

{"sheet":"2부.Ⅰ","index":10,"n_rows":23,"n_cols":38,"rows_kept":23,"merged":[[1,0,1,36],[3,0,3,32],[5,26,5,36],[6,2,7,12],[6,13,6,20],[6,21,6,28],[6,29,7,36],[7,13,7,17],[7,18,7,20],[7,21,7,25],[7,26,7,28],[8,2,8,4],[8,5,8,12],[8,13,8,17],[8,18,8,20],[8,21,8,25],[8,26,8,28],[8,29,9,36],[9,2,9,4],[9,5,9,12],[9,13,9,17],[9,18,9,20],[9,21,9,25],[9,26,9,28],[10,2,10,12],[10,13,10,17],[10,18,10,20],[10,21,10,25],[10,26,10,28],[10,29,10,36],[11,2,11,12],[11,13,11,17],[11,18,11,20],[11,21,11,25],[11,26,11,28],[11,29,11,36],[12,2,12,12],[12,13,12,17],[12,18,12,20],[12,21,12,25],[12,26,12,28],[12,29,12,36],[13,2,13,12],[13,13,13,17],[13,18,13,20],[13,21,13,25],[13,26,13,28],[13,29,13,36],[15,4,15,36],[16,4,16,36],[17,4,17,36],[18,4,18,36],[19,4,19,36],[22,0,22,36]]}
[]
["제 2 부 자산의 투자·운용 및 자산의 구성·변경 현황"]
[]
["Ⅰ. 총자산의 투자·운용 및 구성현황"]
[]
[{"$nulls":26},"(단위 : 백만원, %)"]
[null,null,"항 목",{"$nulls":10},"전기",{"$nulls":7},"당기",{"$nulls":7},"총자산대비\n구성비율"]
[{"$nulls":13},"자산총액",{"$nulls":4},"비율",null,null,"자산총액",{"$nulls":4},"비율"]
[null,null,"부동산",{"$nulls":10},0,{"$nulls":4},{"$f":"IFERROR(N9/SUM($N$9:$R$13)*100,\"\")","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IFERROR(V9/SUM($V$9:$Z$13)*100,\"\")","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IFERROR(AA9+AA10,\"\")","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"부동산개발사업",{"$nulls":12},{"$f":"IFERROR(N10/SUM($N$9:$R$13)*100,\"\")","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IFERROR(V10/SUM($V$9:$Z$13)*100,\"\")","v":{"v":0,"d":"0.00"}}]
[null,null,"부동산관련 유가증권",{"$nulls":10},{"v":692287014736,"d":"692,287"},{"$nulls":4},{"$f":"IFERROR(N11/SUM($N$9:$R$13)*100,\"\")","v":{"v":98.21136224474604,"d":"98.21"}},null,null,{"v":721634755449,"d":"721,635"},{"$nulls":4},{"$f":"IFERROR(V11/SUM($V$9:$Z$13)*100,\"\")","v":{"v":99.49118610835292,"d":"99.49"}},null,null,{"$f":"AA11","v":{"v":99.49118610835292,"d":"99.49"}}]
[null,null,"현금",{"$nulls":10},{"v":8289912266,"d":"8,290"},{"$nulls":4},{"$f":"IFERROR(N12/SUM($N$9:$R$13)*100,\"\")","v":{"v":1.176049180763222,"d":"1.18"}},null,null,{"v":1706287357,"d":"1,706"},{"$nulls":4},{"$f":"IFERROR(V12/SUM($V$9:$Z$13)*100,\"\")","v":{"v":0.23524442483925526,"d":"0.24"}},null,null,{"$f":"AA12","v":{"v":0.23524442483925526,"d":"0.24"}}]
[null,null,"기타 자산",{"$nulls":10},{"v":4318106437,"d":"4,318"},{"$nulls":4},{"$f":"IFERROR(N13/SUM($N$9:$R$13)*100,\"\")","v":{"v":0.6125885744907407,"d":"0.61"}},null,null,{"v":1984268587,"d":"1,984"},{"$nulls":4},{"$f":"IFERROR(V13/SUM($V$9:$Z$13)*100,\"\")","v":{"v":0.27356946680782135,"d":"0.27"}},null,null,{"$f":"AA13","v":{"v":0.27356946680782135,"d":"0.27"}}]
[null,null,"총계",{"$nulls":10},{"$f":"SUM(N9:R13)","v":{"v":704895033439,"d":"704,895"}},{"$nulls":4},{"$f":"IFERROR(N14/SUM($N$14:$R$14)*100,\"\")","v":{"v":100,"d":"100.00"}},null,null,{"$f":"SUM(V9:Z13)","v":{"v":725325311393,"d":"725,325"}},{"$nulls":4},{"$f":"IFERROR(V14/SUM($V$14:$Z$14)*100,\"\")","v":{"v":100,"d":"100.00"}},null,null,{"$f":"AA14","v":{"v":100,"d":"100.00"}}]
[]
[{"$nulls":4},"※ 1. 부동산은 지상권·임차권 등 부동산 사용에 관한 권리, 부동산개발사업, 설립할 때 납입된 \n       주금(株金), 신주발행으로 조성한 자금 및 소유 부동산의 매각대금, 시행령 제27조에 의하여 \n       부동산에 포함되는 자산을 말함(기업구조조정부동산투자회사의 경우, 구조조정부동산을 \n       별도 표시)"]
[{"$nulls":4},"   2. 부동산관련 유가증권은 법제2조3항 각 목의 어느 하나에 해당하는 자산을 말함"]
[{"$nulls":4},"   3. 현금은 금융기관에의 예치금을 포함하며, 부동산에 포함되는 자산은 제외함"]
[{"$nulls":4},"   4. 기타는 자산 중 부동산, 부동산관련 유가증권, 현금에 해당되지 않는 자산을 말함"]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 자산총액의 입력은 반드시 '원' 단위로 입력하시기 바랍니다. ('백만원' 단위로 자동표시)"]

{"sheet":"2부.Ⅰ.1.1)","index":11,"n_rows":27,"n_cols":42,"rows_kept":27,"merged":[[1,1,1,25],[3,2,3,32],[5,2,5,7],[5,8,5,18],[5,19,5,23],[5,24,5,28],[5,29,5,36],[6,3,6,7],[6,8,6,18],[6,19,6,23],[6,24,6,28],[6,29,6,36],[7,3,7,7],[7,8,7,18],[7,19,7,23],[7,24,7,28],[7,29,7,36],[8,3,8,7],[8,8,8,18],[8,19,8,23],[8,24,8,28],[8,29,8,36],[9,3,9,7],[9,8,9,18],[9,19,9,23],[9,24,9,28],[9,29,9,36],[10,3,10,7],[10,8,10,18],[10,19,10,23],[10,24,10,28],[10,29,10,36],[11,3,11,7],[11,8,11,18],[11,19,11,23],[11,24,11,28],[11,29,11,36],[12,3,12,7],[12,8,12,18],[12,19,12,23],[12,24,12,28],[12,29,12,36],[13,3,13,7],[13,8,13,18],[13,19,13,23],[13,24,13,28],[13,29,13,36],[14,3,14,7],[14,8,14,18],[14,19,14,23],[14,24,14,28],[14,29,14,36],[15,3,15,7],[15,8,15,18],[15,19,15,23],[15,24,15,28],[15,29,15,36],[16,3,16,7],[16,8,16,18],[16,19,16,23],[16,24,16,28],[16,29,16,36],[17,3,17,7],[17,8,17,18],[17,19,17,23],[17,24,17,28],[17,29,17,36],[18,3,18,7],[18,8,18,18],[18,19,18,23],[18,24,18,28],[18,29,18,36],[19,3,19,7],[19,8,19,18],[19,19,19,23],[19,24,19,28],[19,29,19,36],[20,3,20,7],[20,8,20,18],[20,19,20,23],[20,24,20,28],[20,29,20,36],[21,4,21,30],[22,4,22,36],[25,0,25,36],[26,0,26,36]]}
[]
[null,"1. 부동산(지상권·임차권 등 부동산사용에 관한 권리도 포함)"]
[]
[null,null,"1) 소유 부동산별 개요"]
[]
[null,null,"부동산명",{"$nulls":5},"위치",{"$nulls":10},"완공\n(개축)일자",{"$nulls":4},"취득일자",{"$nulls":4},"담보 및 부채내역",{"$nulls":7},"유형","투자대상","대지면적(㎡)","연면적(㎡)","건축면적(㎡)"]
[null,null,1,"ESR켄달스퀘어리츠",{"$nulls":33},"일반","물류",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[{"$nulls":4},"※ 준공시 잔금지급예정으로 준공후 소유권이 넘어오는 경우는 제외"]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 부동산이 15개를 초과할 경우 행추가(복사한 셀 삽입)하여 추가 작성(16번부터 이어서 작성)하시기 바라며,\n    아직 소유한 부동산이 없을 경우 기재하지 마시기 바랍니다.\n2. 완공일자와 취득일자는 YYYY-MM-DD 형식으로 입력바랍니다.\n3. 개발관련부동산으로 토지만 소유시 부동산명은 토지(개발사업명)로 입력하시고, 하나의 개발사업에 여러\n    필지가 해당되는 경우에는 위치에 대표번지 입력하고 '외 0필지'로 입력하시기 바랍니다.\n4. 준공시 잔금지급예정으로 준공후 소유권이 넘어오는 경우는 소유부동산 표에 입력하지 마시고 표 하단에\n    별도로 주석처리하시기 바랍니다.\n5. 열 AL~AP의 내용을 선택 또는 입력하여 주시기 바랍니다.\n\n"]
["                                                        <투자대상 분류기준>\n(분류유형) 투자대상은 투자하는 부동산의 주된 유형에 따라 주택, 오피스, 리테일, 호텔, 물류, 복합형으로 \n               구분된 6가지 유형 중 한가지로 분류함\n(복합형) 하나의 리츠가 둘이상 유형의 복수 부동산에 투자하는 경우 복합형으로 분류, 하나의 투자부동산에\n            둘이상 유형이 존재하여 주된 유형의 구분이 어려운 경우 복합형으로 분류\n(지분투자) 지분투자하는 경우에는 투자하는 부동산 유형에 따라 분류하며, 투자유형이 여러개인 경우 복합형\n               으로 분류\n(토지지원) 토지지원리츠는 토지지원으로 개발되는 부동산 유형에 따라 분류\n"]

{"sheet":"2부.Ⅰ.1.2)","index":12,"n_rows":26,"n_cols":26,"rows_kept":26,"merged":[[1,2,1,21],[3,18,3,24],[4,2,5,5],[4,6,4,9],[4,10,4,13],[4,14,4,17],[4,18,5,19],[4,20,5,21],[4,22,5,24],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[6,3,6,5],[6,6,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,13],[6,14,6,15],[6,16,6,17],[6,18,6,19],[6,20,6,21],[6,22,6,24],[7,3,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[7,12,7,13],[7,14,7,15],[7,16,7,17],[7,18,7,19],[7,20,7,21],[7,22,7,24],[8,3,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[8,16,8,17],[8,18,8,19],[8,20,8,21],[8,22,8,24],[9,3,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[9,14,9,15],[9,16,9,17],[9,18,9,19],[9,20,9,21],[9,22,9,24],[10,3,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[10,16,10,17],[10,18,10,19],[10,20,10,21],[10,22,10,24],[11,3,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[11,16,11,17],[11,18,11,19],[11,20,11,21],[11,22,11,24],[12,3,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[12,16,12,17],[12,18,12,19],[12,20,12,21],[12,22,12,24],[13,3,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[13,16,13,17],[13,18,13,19],[13,20,13,21],[13,22,13,24],[14,3,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,15],[14,16,14,17],[14,18,14,19],[14,20,14,21],[14,22,14,24],[15,3,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[15,16,15,17],[15,18,15,19],[15,20,15,21],[15,22,15,24],[16,3,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[16,16,16,17],[16,18,16,19],[16,20,16,21],[16,22,16,24],[17,3,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[17,16,17,17],[17,18,17,19],[17,20,17,21],[17,22,17,24],[18,3,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[18,16,18,17],[18,18,18,19],[18,20,18,21],[18,22,18,24],[19,3,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[19,20,19,21],[19,22,19,24],[20,3,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,16,20,17],[20,18,20,19],[20,20,20,21],[20,22,20,24],[22,4,22,24],[25,0,25,24]]}
[]
[null,null,"2) 소유 부동산별 금액현황"]
[]
[{"$nulls":18},"(단위 : 백만원)"]
[null,null,"부동산명",{"$nulls":3},"취득가액",{"$nulls":3},"취득후\n자본적지출",{"$nulls":3},"평가손익",{"$nulls":3},"감가 \n상각 \n누계액",null,"손상\n차손\n누계액",null,"장부가액"]
[{"$nulls":6},"토지",null,"건물",null,"토지",null,"건물",null,"토지",null,"건물"]
[null,null,1,{"$f":"'2부.Ⅰ.1.1)'!D7","v":"ESR켄달스퀘어리츠"},{"$nulls":18},{"$f":"G7+I7+K7+M7+O7+Q7-S7-U7","v":0}]
[null,null,2,{"$f":"'2부.Ⅰ.1.1)'!D8","v":0},{"$nulls":18},{"$f":"G8+I8+K8+M8+O8+Q8-S8-U8","v":0}]
[null,null,3,{"$f":"'2부.Ⅰ.1.1)'!D9","v":0},{"$nulls":18},0]
[null,null,4,{"$f":"'2부.Ⅰ.1.1)'!D10","v":0},{"$nulls":18},0]
[null,null,5,{"$f":"'2부.Ⅰ.1.1)'!D11","v":0},{"$nulls":18},0]
[null,null,6,{"$f":"'2부.Ⅰ.1.1)'!D12","v":0},{"$nulls":18},0]
[null,null,7,{"$f":"'2부.Ⅰ.1.1)'!D13","v":0},{"$nulls":18},0]
[null,null,8,{"$f":"'2부.Ⅰ.1.1)'!D14","v":0},{"$nulls":18},0]
[null,null,9,{"$f":"'2부.Ⅰ.1.1)'!D15","v":0},{"$nulls":18},0]
[null,null,10,{"$f":"'2부.Ⅰ.1.1)'!D16","v":0},{"$nulls":18},0]
[null,null,11,{"$f":"'2부.Ⅰ.1.1)'!D17","v":0},{"$nulls":18},0]
[null,null,12,{"$f":"'2부.Ⅰ.1.1)'!D18","v":0},{"$nulls":18},0]
[null,null,13,{"$f":"'2부.Ⅰ.1.1)'!D19","v":0},{"$nulls":18},0]
[null,null,14,{"$f":"'2부.Ⅰ.1.1)'!D20","v":0},{"$nulls":18},0]
[null,null,15,{"$f":"'2부.Ⅰ.1.1)'!D21","v":0},{"$nulls":18},0]
[]
[{"$nulls":25},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 부동산이 15개를 초과할 경우 행추가(복사한 셀 삽입)하여 추가 작성(16번부터 이어서 작성하고 '부동산명'은 \n    2부.Ⅰ.1.1) 시트와 동일하게 작성)하시기 바라며, 아직 소유한 부동산이 없을 경우 기재하지 마시기 바랍니다."]

{"sheet":"2부.Ⅰ.1.3)","index":13,"n_rows":24,"n_cols":26,"rows_kept":24,"merged":[[1,2,1,21],[3,2,3,7],[3,8,3,12],[3,13,3,16],[3,17,3,21],[3,22,3,24],[4,3,4,7],[4,8,4,12],[4,13,4,16],[4,17,4,21],[4,22,4,24],[5,3,5,7],[5,8,5,12],[5,13,5,16],[5,17,5,21],[5,22,5,24],[6,3,6,7],[6,8,6,12],[6,13,6,16],[6,17,6,21],[6,22,6,24],[7,3,7,7],[7,8,7,12],[7,13,7,16],[7,17,7,21],[7,22,7,24],[8,3,8,7],[8,8,8,12],[8,13,8,16],[8,17,8,21],[8,22,8,24],[9,3,9,7],[9,8,9,12],[9,13,9,16],[9,17,9,21],[9,22,9,24],[10,3,10,7],[10,8,10,12],[10,13,10,16],[10,17,10,21],[10,22,10,24],[11,3,11,7],[11,8,11,12],[11,13,11,16],[11,17,11,21],[11,22,11,24],[12,3,12,7],[12,8,12,12],[12,13,12,16],[12,17,12,21],[12,22,12,24],[13,3,13,7],[13,8,13,12],[13,13,13,16],[13,17,13,21],[13,22,13,24],[14,3,14,7],[14,8,14,12],[14,13,14,16],[14,17,14,21],[14,22,14,24],[15,3,15,7],[15,8,15,12],[15,13,15,16],[15,17,15,21],[15,22,15,24],[16,3,16,7],[16,8,16,12],[16,13,16,16],[16,17,16,21],[16,22,16,24],[17,3,17,7],[17,8,17,12],[17,13,17,16],[17,17,17,21],[17,22,17,24],[18,3,18,7],[18,8,18,12],[18,13,18,16],[18,17,18,21],[18,22,18,24],[20,4,20,24],[23,0,23,24]]}
[]
[null,null,"3) 소유 부동산별 임대현황"]
[]
[null,null,"부동산명",{"$nulls":5},"임대가능\n면적\n(㎡)",{"$nulls":4},"임대면적\n(㎡)",{"$nulls":3},"임대율\n(임대면적/임대가능면적, %)",{"$nulls":4},"임대차\n계약수"]
[null,null,1,{"$f":"'2부.Ⅰ.1.1)'!D7","v":"ESR켄달스퀘어리츠"},{"$nulls":13},{"$f":"IFERROR(N5/I5,\"\")","v":""}]
[null,null,2,{"$f":"'2부.Ⅰ.1.1)'!D8","v":0},{"$nulls":13},""]
[null,null,3,{"$f":"'2부.Ⅰ.1.1)'!D9","v":0},{"$nulls":13},""]
[null,null,4,{"$f":"'2부.Ⅰ.1.1)'!D10","v":0},{"$nulls":13},""]
[null,null,5,{"$f":"'2부.Ⅰ.1.1)'!D11","v":0},{"$nulls":13},""]
[null,null,6,{"$f":"'2부.Ⅰ.1.1)'!D12","v":0},{"$nulls":13},""]
[null,null,7,{"$f":"'2부.Ⅰ.1.1)'!D13","v":0},{"$nulls":13},""]
[null,null,8,{"$f":"'2부.Ⅰ.1.1)'!D14","v":0},{"$nulls":13},""]
[null,null,9,{"$f":"'2부.Ⅰ.1.1)'!D15","v":0},{"$nulls":13},""]
[null,null,10,{"$f":"'2부.Ⅰ.1.1)'!D16","v":0},{"$nulls":13},""]
[null,null,11,{"$f":"'2부.Ⅰ.1.1)'!D17","v":0},{"$nulls":13},""]
[null,null,12,{"$f":"'2부.Ⅰ.1.1)'!D18","v":0},{"$nulls":13},""]
[null,null,13,{"$f":"'2부.Ⅰ.1.1)'!D19","v":0},{"$nulls":13},""]
[null,null,14,{"$f":"'2부.Ⅰ.1.1)'!D20","v":0},{"$nulls":13},""]
[null,null,15,{"$f":"'2부.Ⅰ.1.1)'!D21","v":0},{"$nulls":13},""]
[]
[{"$nulls":25},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 부동산이 15개를 초과할 경우 행추가(복사한 셀 삽입)하여 추가 작성(16번부터 이어서 작성\n    하고 '부동산명'은 2부.Ⅰ.1.1) 시트와 동일하게 작성)하시기 바라며, 아직 소유한 부동산이\n    없을 경우 기재하지 마시기 바랍니다.\n2. 임대내역이 없을 경우 '임대가능 면적, 임대면적, 임대차 계약수' 입력 칸에 0을 입력하시기\n    바랍니다."]

{"sheet":"2부.Ⅰ.2","index":14,"n_rows":25,"n_cols":33,"rows_kept":25,"merged":[[1,1,1,20],[3,24,3,31],[4,2,4,9],[4,10,4,15],[4,16,4,20],[4,21,4,26],[4,27,4,31],[5,2,5,9],[5,10,5,15],[5,16,5,20],[5,21,5,26],[5,27,5,31],[6,2,6,9],[6,10,6,15],[6,16,6,20],[6,21,6,26],[6,27,6,31],[7,2,7,9],[7,10,7,15],[7,16,7,20],[7,21,7,26],[7,27,7,31],[8,2,8,9],[8,10,8,15],[8,16,8,20],[8,21,8,26],[8,27,8,31],[9,2,9,9],[9,10,9,15],[9,16,9,20],[9,21,9,26],[9,27,9,31],[10,2,10,9],[10,10,10,15],[10,16,10,20],[10,21,10,26],[10,27,10,31],[11,2,11,9],[11,10,11,15],[11,16,11,20],[11,21,11,26],[11,27,11,31],[12,2,12,9],[12,10,12,15],[12,16,12,20],[12,21,12,26],[12,27,12,31],[13,2,13,9],[13,10,13,15],[13,16,13,20],[13,21,13,26],[13,27,13,31],[14,2,14,9],[14,10,14,15],[14,16,14,20],[14,21,14,26],[14,27,14,31],[15,2,15,9],[15,10,15,15],[15,16,15,20],[15,21,15,26],[15,27,15,31],[16,2,16,9],[16,10,16,15],[16,16,16,20],[16,21,16,26],[16,27,16,31],[17,2,17,9],[17,10,17,15],[17,16,17,20],[17,21,17,26],[17,27,17,31],[18,2,18,9],[18,10,18,15],[18,16,18,20],[18,21,18,26],[18,27,18,31],[19,2,19,9],[19,10,19,15],[19,16,19,20],[19,21,19,26],[19,27,19,31],[21,4,21,31],[24,0,24,31]]}
[]
[null,"2. 기말 현재 부동산 관련 유가증권 현황"]
[]
[{"$nulls":24},"(단위 : 백만원, %)"]
[null,null,"구분",{"$nulls":7},"종 목 명",{"$nulls":5},"취득금액",{"$nulls":4},"당해 기말\n현재 가액",{"$nulls":5},"자산구성비"]
[null,null,"부동산관련\n유가증권",{"$nulls":7},"이에스알켄달스퀘어에셋1호",{"$nulls":5},{"v":534049,"d":"534,049"},{"$nulls":4},{"v":534049,"d":"534,049"},{"$nulls":5},{"v":0.7401,"d":"74.01%"}]
[null,null,"부동산관련\n유가증권",{"$nulls":7},"이에스알켄달스퀘어에셋2호",{"$nulls":5},{"v":2500,"d":"2,500"},{"$nulls":4},{"v":2500,"d":"2,500"},{"$nulls":5},{"v":0.0035,"d":"0.35%"}]
[null,null,"부동산관련\n유가증권",{"$nulls":7},"켄달스퀘어전문투자형사모부동산투자신탁6호",{"$nulls":5},{"v":37264,"d":"37,264"},{"$nulls":4},{"v":37264,"d":"37,264"},{"$nulls":5},{"v":0.0516,"d":"5.16%"}]
[null,null,"부동산관련\n유가증권",{"$nulls":7},"켄달스퀘어전문투자형사모부동산투자신탁7호",{"$nulls":5},{"v":41127,"d":"41,127"},{"$nulls":4},{"v":41127,"d":"41,127"},{"$nulls":5},{"v":0.057,"d":"5.70%"}]
[null,null,"부동산관련\n유가증권",{"$nulls":7},"켄달스퀘어전문투자형사모부동산투자신탁8호",{"$nulls":5},{"v":37743,"d":"37,743"},{"$nulls":4},{"v":37743,"d":"37,743"},{"$nulls":5},{"v":0.0523,"d":"5.23%"}]
[null,null,"부동산관련\n유가증권",{"$nulls":7},"켄달스퀘어전문투자형사모부동산투자신탁11호",{"$nulls":5},{"v":42104,"d":"42,104"},{"$nulls":4},{"v":42104,"d":"42,104"},{"$nulls":5},{"v":0.0583,"d":"5.83%"}]
[null,null,"부동산관련\n유가증권",{"$nulls":7},"켄달스퀘어전문투자형사모부동산투자신탁18호",{"$nulls":5},{"v":26848,"d":"26,848"},{"$nulls":4},{"v":26848,"d":"26,848"},{"$nulls":5},{"v":0.0372,"d":"3.72%"}]
[null,null,"부동산관련\n유가증권"]
[null,null,"부동산관련\n유가증권"]
[null,null,"부동산관련\n유가증권"]
[null,null,"부동산관련\n유가증권"]
[null,null,"부동산관련\n유가증권"]
[null,null,"부동산관련\n유가증권"]
[null,null,"부동산관련\n유가증권"]
[null,null,"부동산관련\n유가증권"]
[]
[{"$nulls":32},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n\n"]

{"sheet":"2부.Ⅰ.3","index":15,"n_rows":11,"n_cols":42,"rows_kept":11,"merged":[[1,1,1,20],[3,29,3,40],[4,4,4,11],[4,12,4,20],[4,21,4,24],[4,25,4,30],[4,31,4,36],[4,37,4,40],[5,4,5,11],[5,12,5,20],[5,21,5,24],[5,25,5,30],[5,31,5,36],[5,37,5,40],[7,4,7,36],[10,0,10,36]]}
[]
[null,"3. 현금(금융기관 예치내역 포함) 현황"]
[]
[{"$nulls":29},"(단위 : %, 백만원)"]
[{"$nulls":4},"예치 금융상품",{"$nulls":7},"예치 금융회사",{"$nulls":8},"이자율",{"$nulls":3},"전기예치금",{"$nulls":5},"당기예치금",{"$nulls":5},"비고"]
[{"$nulls":4},"보통예금",{"$nulls":7},"신한은행",{"$nulls":8},"변동금리",{"$nulls":3},{"v":8289.816768,"d":"8,290"},{"$nulls":5},{"v":1706.230558,"d":"1,706"}]
[]
[{"$nulls":41},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n"]

{"sheet":"2부.Ⅰ.4","index":16,"n_rows":21,"n_cols":33,"rows_kept":21,"merged":[[1,1,1,20],[3,24,3,31],[4,2,4,9],[4,10,4,15],[4,16,4,20],[4,21,4,26],[4,27,4,31],[5,2,5,9],[5,10,5,15],[5,16,5,20],[5,21,5,26],[5,27,5,31],[6,2,6,9],[6,10,6,15],[6,16,6,20],[6,21,6,26],[6,27,6,31],[7,2,7,9],[7,10,7,15],[7,16,7,20],[7,21,7,26],[7,27,7,31],[8,2,8,9],[8,10,8,15],[8,16,8,20],[8,21,8,26],[8,27,8,31],[9,2,9,9],[9,10,9,15],[9,16,9,20],[9,21,9,26],[9,27,9,31],[10,2,10,9],[10,10,10,15],[10,16,10,20],[10,21,10,26],[10,27,10,31],[11,2,11,9],[11,10,11,15],[11,16,11,20],[11,21,11,26],[11,27,11,31],[12,2,12,9],[12,10,12,15],[12,16,12,20],[12,21,12,26],[12,27,12,31],[13,2,13,9],[13,10,13,15],[13,16,13,20],[13,21,13,26],[13,27,13,31],[14,2,14,9],[14,10,14,15],[14,16,14,20],[14,21,14,26],[14,27,14,31],[15,2,15,9],[15,10,15,15],[15,16,15,20],[15,21,15,26],[15,27,15,31],[17,4,17,31],[20,0,20,31]]}
[]
[null,"4. 기말 기타 자산 현황"]
[]
[{"$nulls":24},"(단위 : 백만원, %)"]
[null,null,"구분",{"$nulls":7},"종 목 명",{"$nulls":5},"취득금액",{"$nulls":4},"당해 기말\n현재 가액",{"$nulls":5},"비고"]
[null,null,"유가증권"]
[null,null,"유가증권"]
[null,null,"유가증권"]
[null,null,"유가증권"]
[null,null,"유가증권"]
[null,null,"파생상품자산"]
[null,null,"파생상품자산"]
[null,null,"파생상품자산"]
[null,null,"기타자산",{"$nulls":7},"미수수익",{"$nulls":5},{"v":1058.636957,"d":"1,059"},{"$nulls":4},{"v":1058.636957,"d":"1,059"}]
[null,null,"기타자산",{"$nulls":7},"선납세금",{"$nulls":5},{"v":925.63163,"d":"926"},{"$nulls":4},{"v":925.63163,"d":"926"}]
[null,null,"기타자산"]
[]
[{"$nulls":4},"* 미수수익은 수익증권 이익분배금 + 예금 미수이자 이자 입니다.",{"$nulls":27},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n\n"]

{"sheet":"2부.Ⅱ","index":17,"n_rows":29,"n_cols":38,"rows_kept":29,"merged":[[1,0,1,32],[3,1,3,25],[4,26,4,36],[5,2,5,4],[5,5,5,9],[5,10,5,17],[5,18,5,22],[5,23,5,26],[5,27,5,30],[5,31,5,36],[6,2,6,4],[6,5,6,9],[6,10,6,17],[6,18,6,22],[6,23,6,26],[6,27,6,30],[6,31,6,36],[7,2,7,4],[7,5,7,9],[7,10,7,17],[7,18,7,22],[7,23,7,26],[7,27,7,30],[7,31,7,36],[8,4,8,33],[9,4,9,36],[11,1,11,29],[12,4,12,36],[14,4,14,36],[16,1,16,25],[17,29,17,36],[18,4,18,11],[18,12,18,20],[18,21,18,24],[18,25,18,30],[18,31,18,36],[19,4,19,11],[19,12,19,20],[19,21,19,24],[19,25,19,30],[19,31,19,36],[21,4,21,36],[23,1,23,29],[25,4,25,36],[28,0,28,36]]}
[]
["Ⅱ. 총자산의 변경내역"]
[]
[null,"1. 당기동안의 부동산 매입·매각"]
[{"$nulls":26},"(단위 : 백만원)"]
[null,null,"구분",null,null,"부동산명",{"$nulls":4},"위치",{"$nulls":7},"거래일자",{"$nulls":4},"매매가액",{"$nulls":3},"거래비용",{"$nulls":3},"비고"]
[]
[]
[{"$nulls":4},"※ 매각의 경우 비고란에 취득한 금액, 보유기간 등 간략히 기재"]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[null,"2. 당기동안의 부동산관련 유가증권 거래내역"]
[{"$nulls":4},"- 당기동안에 거래된 부동산관련 유가증권의 거래내역, 거래에 따른 이익현황, 거래비용 \n   등을 간략하게 기재"]
[]
[{"$nulls":4},"- 2021.07.16,11.25: 이에스알켄달스퀘어에셋2호위탁관리부동산투자회사_주식매입_446,000주_2,500백만원\n- 2021.06.10~11: 켄달스퀘어전문투자형사모부동산투자신탁18호_26,200백만원_거래비용648백만원"]
[]
[null,"3. 현금(금융기관 예치내역 포함) 변경내역"]
[{"$nulls":29},"(단위 : %, 백만원)"]
[{"$nulls":4},"예치 금융상품",{"$nulls":7},"예치 금융회사",{"$nulls":8},"이자율",{"$nulls":3},"전기예치금",{"$nulls":5},"당기예치금"]
[{"$nulls":4},"보통예금",{"$nulls":7},"신한은행",{"$nulls":8},"변동금리",{"$nulls":3},{"v":8289.816768,"d":"8,290"},{"$nulls":5},{"v":1706.230558,"d":"1,706"}]
[]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[null,"4. 기타 자산 변경내역"]
[]
[]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다."]

{"sheet":"3부.Ⅰ","index":18,"n_rows":23,"n_cols":38,"rows_kept":23,"merged":[[1,0,1,36],[3,0,3,36],[5,2,5,13],[5,14,5,21],[5,22,5,29],[5,30,5,36],[6,2,8,6],[6,7,6,13],[6,14,6,21],[6,22,6,29],[6,30,6,36],[7,7,7,13],[7,14,7,21],[7,22,7,29],[7,30,7,36],[8,7,8,13],[8,14,8,21],[8,22,8,29],[8,30,8,36],[9,2,11,6],[9,7,9,13],[9,14,9,21],[9,22,9,29],[9,30,9,36],[10,7,10,13],[10,14,10,21],[10,22,10,29],[10,30,10,36],[11,7,11,13],[11,14,11,21],[11,22,11,29],[11,30,11,36],[12,2,12,6],[12,7,12,13],[12,14,12,21],[12,22,12,29],[12,30,12,36],[13,2,13,6],[13,7,13,13],[13,14,13,21],[13,22,13,29],[13,30,13,36],[14,2,14,13],[14,14,14,21],[14,22,14,29],[14,30,14,36],[15,2,15,13],[15,14,15,21],[15,22,15,29],[15,30,15,36],[16,4,16,34],[17,4,17,33],[18,4,18,36],[22,0,22,36]]}
[]
["제 3 부 자산 및 수익과 비용에 관한 사항"]
[]
["Ⅰ. 총수입금액 및 수입구조"]
[]
[null,null,"구 분",{"$nulls":11},"금액(원)",{"$nulls":7},"비율(%)",{"$nulls":7},"비 고"]
[null,null,"부동산",{"$nulls":4},"임 대 료",{"$nulls":6},{"$f":"SUM('3부.Ⅱ.1.1)'!O9:W24)","v":0},{"$nulls":7},{"$f":"IFERROR(O7/$O$16,\"\")","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":7},"분양수익",{"$nulls":6},0,{"$nulls":7},{"v":0,"d":"0.00%"}]
[{"$nulls":7},"기타수익",{"$nulls":6},0,{"$nulls":7},{"v":0,"d":"0.00%"}]
[null,null,"부동산관련 유가증권",{"$nulls":4},"평가이익",{"$nulls":6},{"$f":"SUM('3부.Ⅱ.2'!Q6:U11)","v":0},{"$nulls":7},{"v":0,"d":"0.00%"}]
[{"$nulls":7},"처분이익",{"$nulls":6},{"$f":"SUM('3부.Ⅱ.2'!K6:P11)","v":0},{"$nulls":7},{"v":0,"d":"0.00%"}]
[{"$nulls":7},"이자,배당금 등",{"$nulls":6},{"$f":"SUM('3부.Ⅱ.2'!V6:AA11)","v":{"v":19680322901,"d":"19,680,322,901"}},{"$nulls":7},{"v":0.9998973647090903,"d":"99.99%"}]
[null,null,"현금",{"$nulls":4},"현금관련수익",{"$nulls":6},{"$f":"SUM('3부.Ⅱ.3'!AF6:AF14)","v":{"v":2006419,"d":"2,006,419"}},{"$nulls":7},{"v":1.0194004847859016E-4,"d":"0.01%"}]
[null,null,"기타자산",{"$nulls":4},"기타자산관련수익",{"$nulls":6},{"$f":"SUM('3부.Ⅱ.4'!O5:W9)","v":0},{"$nulls":7},{"v":0,"d":"0.00%"}]
[null,null,"기타",{"$nulls":11},{"v":13684,"d":"13,684"},{"$nulls":7},{"v":6.9524243110787325E-7,"d":"0.00%"}]
[null,null,"총 수 익",{"$nulls":11},{"$f":"SUM(O7:V15)","v":{"v":19682343004,"d":"19,682,343,004"}},{"$nulls":7},{"$f":"SUM(W7:AD15)","v":{"v":1,"d":"100.00%"}}]
[null,null," ",null,"※ 부동산관련 유가증권 평가이익란에는 당기손익에 반영되는 평가이익만 포함"]
[{"$nulls":4},"※ 기타란에는 자산별로 구분되지 않는 수익을 기재"]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[]
[]
["* 입력도움말\n1. 부동산(임대료, 분양수익), 부동산관련 유가증권(평가이익, 처분이익, 이자, 배당금 등) 등의 \n    금액은 뒤 시트와 연결되어 있으므로 수정 불가합니다. \n2. 부동산(기타수익), 기타 및 각 항목의 비고, 주석 사항만 직접 기재 바랍니다."]

{"sheet":"3부.Ⅱ.1.1)","index":19,"n_rows":29,"n_cols":36,"rows_kept":29,"merged":[[1,0,1,34],[3,1,3,34],[5,2,5,30],[7,2,7,13],[7,14,7,22],[7,23,7,27],[7,28,7,34],[8,3,8,13],[8,14,8,22],[8,23,8,27],[8,28,8,34],[9,3,9,13],[9,14,9,22],[9,23,9,27],[9,28,9,34],[10,3,10,13],[10,14,10,22],[10,23,10,27],[10,28,10,34],[11,3,11,13],[11,14,11,22],[11,23,11,27],[11,28,11,34],[12,3,12,13],[12,14,12,22],[12,23,12,27],[12,28,12,34],[13,3,13,13],[13,14,13,22],[13,23,13,27],[13,28,13,34],[14,3,14,13],[14,14,14,22],[14,23,14,27],[14,28,14,34],[15,3,15,13],[15,14,15,22],[15,23,15,27],[15,28,15,34],[16,3,16,13],[16,14,16,22],[16,23,16,27],[16,28,16,34],[17,3,17,13],[17,14,17,22],[17,23,17,27],[17,28,17,34],[18,3,18,13],[18,14,18,22],[18,23,18,27],[18,28,18,34],[19,3,19,13],[19,14,19,22],[19,23,19,27],[19,28,19,34],[20,3,20,13],[20,14,20,22],[20,23,20,27],[20,28,20,34],[21,3,21,13],[21,14,21,22],[21,23,21,27],[21,28,21,34],[22,3,22,13],[22,14,22,22],[22,23,22,27],[22,28,22,34],[23,3,23,13],[23,14,23,22],[23,23,23,27],[23,28,23,34],[25,4,25,34],[28,0,28,34]]}
[]
["Ⅱ. 부문별 상세내역"]
[]
[null,"1. 부동산(지상권·임차권 등 부동산사용에 관한 권리도 포함)"]
[]
[null,null,"1) 부동산 임대료 수익"]
[]
[null,null,"부동산명",{"$nulls":11},"임대료(원)",{"$nulls":8},"비율(%)",{"$nulls":4},"비 고"]
[null,null,1,{"$f":"'2부.Ⅰ.1.1)'!D7","v":"ESR켄달스퀘어리츠"},{"$nulls":19},{"$f":"IFERROR(O9/SUM(O9:W24),\"\")","v":""}]
[null,null,2,{"$f":"'2부.Ⅰ.1.1)'!D8","v":0},{"$nulls":19},{"$f":"IFERROR(O10/SUM(O9:W24),\"\")","v":""}]
[null,null,3,{"$f":"'2부.Ⅰ.1.1)'!D9","v":0},{"$nulls":19},{"$f":"IFERROR(O11/SUM(O9:W24),\"\")","v":""}]
[null,null,4,{"$f":"'2부.Ⅰ.1.1)'!D10","v":0},{"$nulls":19},{"$f":"IFERROR(O12/SUM(O9:W24),\"\")","v":""}]
[null,null,5,{"$f":"'2부.Ⅰ.1.1)'!D11","v":0},{"$nulls":19},{"$f":"IFERROR(O13/SUM(O9:W24),\"\")","v":""}]
[null,null,6,{"$f":"'2부.Ⅰ.1.1)'!D12","v":0},{"$nulls":19},{"$f":"IFERROR(O14/SUM(O9:W24),\"\")","v":""}]
[null,null,7,{"$f":"'2부.Ⅰ.1.1)'!D13","v":0},{"$nulls":19},{"$f":"IFERROR(O15/SUM(O9:W24),\"\")","v":""}]
[null,null,8,{"$f":"'2부.Ⅰ.1.1)'!D14","v":0},{"$nulls":19},{"$f":"IFERROR(O16/SUM(O9:W24),\"\")","v":""}]
[null,null,9,{"$f":"'2부.Ⅰ.1.1)'!D15","v":0},{"$nulls":19},{"$f":"IFERROR(O17/SUM(O9:W24),\"\")","v":""}]
[null,null,10,{"$f":"'2부.Ⅰ.1.1)'!D16","v":0},{"$nulls":19},{"$f":"IFERROR(O18/SUM(O9:W24),\"\")","v":""}]
[null,null,11,{"$f":"'2부.Ⅰ.1.1)'!D17","v":0},{"$nulls":19},{"$f":"IFERROR(O19/SUM(O9:W24),\"\")","v":""}]
[null,null,12,{"$f":"'2부.Ⅰ.1.1)'!D18","v":0},{"$nulls":19},{"$f":"IFERROR(O20/SUM(O9:W24),\"\")","v":""}]
[null,null,13,{"$f":"'2부.Ⅰ.1.1)'!D19","v":0},{"$nulls":19},{"$f":"IFERROR(O21/SUM(O9:W24),\"\")","v":""}]
[null,null,14,{"$f":"'2부.Ⅰ.1.1)'!D20","v":0},{"$nulls":19},{"$f":"IFERROR(O22/SUM(O9:W24),\"\")","v":""}]
[null,null,15,{"$f":"'2부.Ⅰ.1.1)'!D20","v":0},{"$nulls":19},{"$f":"IFERROR(O23/SUM(O8:W23),\"\")","v":""}]
[null,null,15,{"$f":"'2부.Ⅰ.1.1)'!D21","v":0},{"$nulls":19},{"$f":"IFERROR(O24/SUM(O9:W24),\"\")","v":""}]
[]
[{"$nulls":35},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 부동산이 15개를 초과할 경우 행추가(복사한 셀 삽입)하여 추가 작성(16번부터 이어서 작성\n    하고 '부동산명'은 2부.Ⅰ.1.1) 시트와 동일하게 작성)하시기 바라며, 아직 소유한 부동산이\n    없을 경우 기재하지 마시기 바랍니다."]

{"sheet":"3부.Ⅱ.1.2)","index":20,"n_rows":15,"n_cols":38,"rows_kept":15,"merged":[[1,2,1,30],[2,29,2,36],[3,2,3,7],[3,8,3,11],[3,12,3,14],[3,15,3,18],[3,19,3,22],[3,23,3,26],[3,27,3,30],[3,31,3,33],[3,34,3,36],[4,3,4,7],[4,8,4,11],[4,12,4,14],[4,15,4,18],[4,19,4,22],[4,23,4,26],[4,27,4,30],[4,31,4,33],[4,34,4,36],[5,3,5,7],[5,8,5,11],[5,12,5,14],[5,15,5,18],[5,19,5,22],[5,23,5,26],[5,27,5,30],[5,31,5,33],[5,34,5,36],[6,3,6,7],[6,8,6,11],[6,12,6,14],[6,15,6,18],[6,19,6,22],[6,23,6,26],[6,27,6,30],[6,31,6,33],[6,34,6,36],[7,3,7,7],[7,8,7,11],[7,12,7,14],[7,15,7,18],[7,19,7,22],[7,23,7,26],[7,27,7,30],[7,31,7,33],[7,34,7,36],[8,3,8,7],[8,8,8,11],[8,12,8,14],[8,15,8,18],[8,19,8,22],[8,23,8,26],[8,27,8,30],[8,31,8,33],[8,34,8,36],[9,4,9,33],[10,4,10,36],[14,0,14,36]]}
[]
[null,null,"2) 부동산 처분수익"]
[{"$nulls":29},"(단위 : 원)"]
[null,null,"부동산명",{"$nulls":5},"취득\n가액",{"$nulls":3},"평가\n손익",null,null,"상각\n누계액",{"$nulls":3},"장부\n가액",{"$nulls":3},"매매\n가액",{"$nulls":3},"처분\n손익",{"$nulls":3},"비율\n(%)",null,null,"비고"]
[null,null,1,{"$nulls":28},{"$f":"IFERROR(AB5/SUM(AB5:AE9),\"\")","v":""}]
[null,null,2,{"$nulls":28},{"$f":"IFERROR(AB6/SUM(AB5:AE9),\"\")","v":""}]
[null,null,3,{"$nulls":28},{"$f":"IFERROR(AB7/SUM(AB5:AE9),\"\")","v":""}]
[null,null,4,{"$nulls":28},{"$f":"IFERROR(AB8/SUM(AB5:AE9),\"\")","v":""}]
[null,null,5,{"$nulls":28},{"$f":"IFERROR(AB9/SUM(AB5:AE9),\"\")","v":""}]
[{"$nulls":4},"※ 부동산개발사업을 통한 분양수익은 비고란에 구분 기재"]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n\n"]

{"sheet":"3부.Ⅱ.2","index":21,"n_rows":16,"n_cols":38,"rows_kept":16,"merged":[[1,1,1,26],[3,31,3,36],[4,2,4,9],[4,10,4,15],[4,16,4,20],[4,21,4,26],[4,27,4,31],[4,32,4,36],[5,3,5,9],[5,10,5,15],[5,16,5,20],[5,21,5,26],[5,27,5,31],[5,32,5,36],[6,3,6,9],[6,10,6,15],[6,16,6,20],[6,21,6,26],[6,27,6,31],[6,32,6,36],[7,3,7,9],[7,10,7,15],[7,16,7,20],[7,21,7,26],[7,27,7,31],[7,32,7,36],[8,3,8,9],[8,10,8,15],[8,16,8,20],[8,21,8,26],[8,27,8,31],[8,32,8,36],[9,3,9,9],[9,10,9,15],[9,16,9,20],[9,21,9,26],[9,27,9,31],[9,32,9,36],[10,3,10,9],[10,10,10,15],[10,16,10,20],[10,21,10,26],[10,27,10,31],[10,32,10,36],[12,4,12,31],[15,0,15,31]]}
[]
[null,"2. 부동산 관련 유가증권 처분손익, 평가손익, 이자 및 배당금"]
[]
[{"$nulls":31},"(단위 : 원)"]
[null,null,"구 분",{"$nulls":7},"매매손익",{"$nulls":5},"평가손익",{"$nulls":4},"이자 및 배당금",{"$nulls":5},"비율\n(%)",{"$nulls":4},"비 고"]
[null,null,1,"이에스알켄달스퀘어에셋1호",{"$nulls":17},{"v":15280202252,"d":"15,280,202,252"},{"$nulls":5},{"$f":"IFERROR(SUM(K6:AA6)/SUM(K6:AA11),\"\")","v":{"v":0.776420302088823,"d":"77.64%"}}]
[null,null,1,"켄달스퀘어전문투자형사모부동산투자신탁6호",{"$nulls":17},{"v":962253225,"d":"962,253,225"},{"$nulls":5},{"$f":"IFERROR(SUM(K7:AA7)/SUM(K7:AA12),\"\")","v":{"v":0.21868791830030568,"d":"21.87%"}}]
[null,null,2,"켄달스퀘어전문투자형사모부동산투자신탁7호",{"$nulls":17},{"v":1111889287,"d":"1,111,889,287"},{"$nulls":5},{"$f":"IFERROR(SUM(K8:AA8)/SUM(K6:AA11),\"\")","v":{"v":0.05649751239312758,"d":"5.65%"}}]
[null,null,3,"켄달스퀘어전문투자형사모부동산투자신탁8호",{"$nulls":17},{"v":843297060,"d":"843,297,060"},{"$nulls":5},{"$f":"IFERROR(SUM(K9:AA9)/SUM(K6:AA11),\"\")","v":{"v":0.04284975730541241,"d":"4.28%"}}]
[null,null,4,"켄달스퀘어전문투자형사모부동산투자신탁11호",{"$nulls":17},{"v":973066737,"d":"973,066,737"},{"$nulls":5},{"$f":"IFERROR(SUM(K10:AA10)/SUM(K6:AA11),\"\")","v":{"v":0.04944363676830508,"d":"4.94%"}}]
[null,null,5,"켄달스퀘어전문투자형사모부동산투자신탁18호",{"$nulls":17},{"v":509614340,"d":"509,614,340"},{"$nulls":5},{"$f":"IFERROR(SUM(K11:AA11)/SUM(K6:AA11),\"\")","v":{"v":0.025894612733925487,"d":"2.59%"}}]
[]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n\n"]

{"sheet":"3부.Ⅱ.3","index":22,"n_rows":13,"n_cols":42,"rows_kept":13,"merged":[[1,1,1,20],[3,29,3,40],[4,4,4,11],[4,12,4,20],[4,21,4,24],[4,25,4,30],[4,31,4,36],[4,37,4,40],[5,4,5,11],[5,12,5,20],[5,21,5,24],[5,25,5,30],[5,31,5,36],[5,37,5,40],[6,4,6,11],[6,12,6,20],[6,21,6,24],[6,25,6,30],[6,31,6,36],[6,37,6,40],[7,4,7,11],[7,12,7,20],[7,21,7,24],[7,25,7,30],[7,31,7,36],[7,37,7,40],[9,4,9,36],[12,0,12,36]]}
[]
[null,"3. 현금(금융기관 예치내역 포함)"]
[]
[{"$nulls":29},"(단위 : %, 원)"]
[{"$nulls":4},"예치 금융상품",{"$nulls":7},"예치 금융회사",{"$nulls":8},"이자율",{"$nulls":3},"전기예치금\n발생 수익",{"$nulls":5},"당기예치금\n발생 수익",{"$nulls":5},"비고"]
[{"$nulls":4},"보토예금",{"$nulls":7},"KB국민은행",{"$nulls":8},"변동금리",{"$nulls":3},{"v":691989,"d":"691,989"}]
[{"$nulls":4},"보통예금",{"$nulls":7},"중소기업은행",{"$nulls":8},"변동금리",{"$nulls":3},{"v":432639404,"d":"432,639,404"},{"$nulls":5},{"v":56799,"d":"56,799"}]
[{"$nulls":4},"보통예금",{"$nulls":7},"신한은행",{"$nulls":8},"변동금리",{"$nulls":3},{"v":4262386,"d":"4,262,386"},{"$nulls":5},{"v":1949620,"d":"1,949,620"}]
[]
[{"$nulls":41},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n"]

{"sheet":"3부.Ⅱ.4","index":23,"n_rows":14,"n_cols":36,"rows_kept":14,"merged":[[1,1,1,34],[3,2,3,13],[3,14,3,22],[3,23,3,27],[3,28,3,34],[4,3,4,13],[4,14,4,22],[4,23,4,27],[4,28,4,34],[5,3,5,13],[5,14,5,22],[5,23,5,27],[5,28,5,34],[6,3,6,13],[6,14,6,22],[6,23,6,27],[6,28,6,34],[7,3,7,13],[7,14,7,22],[7,23,7,27],[7,28,7,34],[8,3,8,13],[8,14,8,22],[8,23,8,27],[8,28,8,34],[10,4,10,34],[13,0,13,34]]}
[]
[null,"4. 기타 자산 수익"]
[]
[null,null,"구 분",{"$nulls":11},"금 액(원)",{"$nulls":8},"비율(%)",{"$nulls":4},"비 고"]
[null,null,1,{"$nulls":20},{"$f":"IFERROR(O5/SUM(O5:W9),\"\")","v":""}]
[null,null,2,{"$nulls":20},{"$f":"IFERROR(O6/SUM(O5:W9),\"\")","v":""}]
[null,null,3,{"$nulls":20},{"$f":"IFERROR(O7/SUM(O5:W9),\"\")","v":""}]
[null,null,4,{"$nulls":20},{"$f":"IFERROR(O8/SUM(O5:W9),\"\")","v":""}]
[null,null,5,{"$nulls":20},{"$f":"IFERROR(O9/SUM(O5:W9),\"\")","v":""}]
[]
[{"$nulls":35},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다."]

{"sheet":"3부.Ⅲ","index":24,"n_rows":17,"n_cols":38,"rows_kept":17,"merged":[[1,0,1,36],[3,2,3,13],[3,14,3,21],[3,22,3,29],[3,30,3,36],[4,2,6,6],[4,7,4,13],[4,14,4,21],[4,22,4,29],[4,30,4,36],[5,7,5,13],[5,14,5,21],[5,22,5,29],[5,30,5,36],[6,7,6,13],[6,14,6,21],[6,22,6,29],[6,30,6,36],[7,2,9,6],[7,7,7,13],[7,14,7,21],[7,22,7,29],[7,30,7,36],[8,7,8,13],[8,14,8,21],[8,22,8,29],[8,30,8,36],[9,7,9,13],[9,14,9,21],[9,22,9,29],[9,30,9,36],[10,2,10,6],[10,7,10,13],[10,14,10,21],[10,22,10,29],[10,30,10,36],[11,2,11,6],[11,7,11,13],[11,14,11,21],[11,22,11,29],[11,30,11,36],[12,2,12,13],[12,14,12,21],[12,22,12,29],[12,30,12,36],[13,2,13,13],[13,14,13,21],[13,22,13,29],[13,30,13,36],[14,4,14,34],[15,4,15,33],[16,4,16,36]]}
[]
["Ⅲ. 총 비용 및 지출구조"]
[]
[null,null,"구 분",{"$nulls":11},"금액(원)",{"$nulls":7},"비율(%)",{"$nulls":7},"비 고"]
[null,null,"부동산",{"$nulls":4},"분양원가",{"$nulls":14},{"$f":"IFERROR(O5/$O$14,\"\")","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":7},"감가상각비",{"$nulls":14},{"$f":"IFERROR(O6/$O$14,\"\")","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":7},"기타비용",{"$nulls":14},{"$f":"IFERROR(O7/$O$14,\"\")","v":{"v":0,"d":"0.00%"}}]
[null,null,"부동산관련 유가증권",{"$nulls":4},"평가손실",{"$nulls":14},{"$f":"IFERROR(O8/$O$14,\"\")","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":7},"처분손실",{"$nulls":6},{"$f":"+'5부.Ⅱ'!O62","v":0},{"$nulls":7},{"$f":"IFERROR(O9/$O$14,\"\")","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":7},"기타비용",{"$nulls":6},{"v":387110492,"d":"387,110,492"},{"$nulls":7},{"v":0.48807238333586705,"d":"48.81%"}]
[null,null,"현금",{"$nulls":4},"현금관련비용",{"$nulls":14},{"$f":"IFERROR(O11/$O$14,\"\")","v":{"v":0,"d":"0.00%"}}]
[null,null,"기타자산",{"$nulls":4},"기타자산관련비용",{"$nulls":14},{"$f":"IFERROR(O12/$O$14,\"\")","v":{"v":0,"d":"0.00%"}}]
[null,null,"기타",{"$nulls":11},{"v":406031069,"d":"406,031,069"},{"$nulls":7},{"v":0.5119276166641329,"d":"51.19%"}]
[null,null,"총 비 용",{"$nulls":11},{"$f":"SUM(O5:V13)","v":{"v":793141561,"d":"793,141,561"}},{"$nulls":7},{"$f":"SUM(W5:AD13)","v":{"v":1,"d":"100.00%"}}]
[null,null," ",null,"※ 부동산관련 유가증권 평가손실란에는 당기손익에 반영되는 평가손실만 포함"]
[{"$nulls":4},"※ 기타란에는 자산별로 구분되지 않는 비용을 기재"]
[{"$nulls":37},"← 필요시 주석 기재"]

{"sheet":"3부.Ⅳ.1","index":25,"n_rows":41,"n_cols":16,"rows_kept":41,"merged":[[1,0,1,13],[3,1,3,13],[6,2,6,9],[7,2,7,9],[8,2,8,9],[9,2,9,9],[10,2,10,9],[11,2,11,9],[12,2,12,9],[13,2,13,9],[14,2,14,9],[15,2,15,9],[16,2,16,9],[17,2,17,9],[18,2,18,9],[19,2,19,9],[20,2,20,9],[21,2,21,9],[22,2,22,9],[23,2,23,9],[24,2,24,9],[25,2,25,9],[26,2,26,9],[27,2,27,9],[28,2,28,9],[29,2,29,9],[30,2,30,9],[31,2,31,9],[32,2,32,9],[33,2,33,9],[34,2,34,9],[35,2,35,9],[37,4,37,14],[40,0,40,14]]}
[]
["Ⅳ. 상세내역"]
[]
[null,"1. 부동산 영업경비"]
[]
[{"$nulls":14},"(단위 : 원)"]
[null,null,"구  분",{"$nulls":7},"합계","ESR켄달스퀘어리츠","현금","기타자산","기타"]
[null,null,"분양원가",{"$nulls":7},{"$f":"SUM(L8:Z8)","v":0},0]
[null,null,"급여",{"$nulls":7},{"$f":"SUM(L9:Z9)","v":{"v":57000000,"d":"57,000,000"}},{"v":57000000,"d":"57,000,000"}]
[null,null,"상여",{"$nulls":7},0,0]
[null,null,"퇴직급여",{"$nulls":7},0,0]
[null,null,"복리후생비",{"$nulls":7},0,0]
[null,null,"자산관리수수료\n(AMC수수료)",{"$nulls":7},0,0]
[null,null,"부동산관리수수료\n(PM, FM 등)",{"$nulls":7},0,0]
[null,null,"자산보관수수료",{"$nulls":7},{"v":5000000,"d":"5,000,000"},{"v":5000000,"d":"5,000,000"}]
[null,null,"일반사무\n위탁수수료",{"$nulls":7},{"v":43729700,"d":"43,729,700"},{"$nulls":3},{"v":43729700,"d":"43,729,700"}]
[null,null,"기타지급수수료",{"$nulls":7},{"v":226110492,"d":"226,110,492"},{"v":226110492,"d":"226,110,492"}]
[null,null,"유형자산\n감가상각비",{"$nulls":7},0,0]
[null,null,"투자부동산\n감가상각비",{"$nulls":7},0,0]
[null,null,"무형자산\n감가상각비",{"$nulls":7},0]
[null,null,"세금과공과",{"$nulls":7},0,0]
[null,null,"광고선전비",{"$nulls":7},{"v":99000000,"d":"99,000,000"},{"v":99000000,"d":"99,000,000"}]
[null,null,"보험료",{"$nulls":7},0,0]
[null,null,"임차료",{"$nulls":7},0,0]
[null,null,"교육훈련비",{"$nulls":7},0,0]
[null,null,"여비교통비",{"$nulls":7},0,0]
[null,null,"통신비",{"$nulls":7},0,0]
[null,null,"수선유지비",{"$nulls":7},0,0]
[null,null,"청소비",{"$nulls":7},0,0]
[null,null,"수도광열비",{"$nulls":7},0,0]
[null,null,"대손상각비",{"$nulls":7},0,0]
[null,null,"접대비",{"$nulls":7},0,0]
[null,null,"판매촉진비",{"$nulls":7},0,0]
[null,null,"이자비용",{"$nulls":7},0,0]
[null,null,"금융리스이자비용",{"$nulls":7},0,0]
[null,null,"기타영업비용",{"$nulls":7},0,0]
[]
[{"$nulls":15},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 필요시 열추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n3. 부동산과 부동산관련 유가증권은 각각 기재하시되, 현금과 기타자산은 하나의 항목으로 기재바랍니다.\n\n\n"]

{"sheet":"3부.Ⅳ.2","index":26,"n_rows":22,"n_cols":38,"rows_kept":22,"merged":[[1,1,1,14],[3,2,3,7],[3,8,3,10],[3,11,3,12],[3,13,3,30],[3,31,3,36],[4,2,9,7],[4,8,4,10],[4,13,4,30],[4,31,4,36],[5,8,5,10],[5,13,5,30],[5,31,5,36],[6,8,6,10],[6,13,6,30],[6,31,6,36],[7,8,7,10],[7,13,7,30],[7,31,7,36],[8,8,8,10],[8,13,8,30],[8,31,8,36],[9,8,9,10],[9,13,9,30],[9,31,9,36],[10,2,10,7],[10,8,10,10],[10,11,10,12],[10,13,10,30],[10,31,10,36],[11,2,11,7],[11,8,11,10],[11,11,11,12],[11,13,11,30],[11,31,11,36],[12,2,12,7],[12,8,12,10],[12,11,12,12],[12,13,12,30],[12,31,12,36],[13,2,13,7],[13,8,13,10],[13,11,13,12],[13,13,13,30],[13,31,13,36],[14,2,14,7],[14,8,14,10],[14,11,14,12],[14,13,14,30],[14,31,14,36],[15,2,15,30],[15,31,15,36],[16,4,16,36],[17,4,17,36],[21,0,21,36]]}
[]
[null,"2. 업무위탁비용"]
[]
[null,null,"구 분",{"$nulls":5},"종 류",null,null,"위탁기관",null,"대상물건, 위탁비율, 계산방법, \n지급시기 및 지급방법",{"$nulls":17},"위탁비용\n(원)"]
[null,null,"자산관리회사",{"$nulls":5},"기본보수(매입)",null,null,"켄달스퀘어리츠운용㈜",null,"a. 부동산: 부동산 매입가액 X 1.0%\n* 단, 자산관리자의 계열회사가 집합투자업자인 집합투자기구 또는 법인세법 제51조의 2 및 동 시행령 제86조의 2에 의한 자산관리회사인 프로젝트금융투자회사가 보유한 부동산의 경우, 0.75%로 함.\nb. 집합투자증권 및 지분증권 등 부동산을 제외한 대상자산: 대상자산의 기초자산인 부동산의 평가금액 X 1.0% X 위탁자의 지분율\n* 단, (i) 위 대상자산이 부동산투자회사법상 부동산투자회사의 주식이고, 자산관리자 또는 자산관리자의 계열회사가 해당 부동산투자회사의 자산관리회사인 경우, 또는 (ii) 위 대상자산이 부동산집합투자기구가 발행한 집합투자증권이고, 자산관리자의 계열회사가 해당 부동산집합투자기구의 집합투자업자인 경우, 0.75%로 함.\n=> 취득일로부터 1주일 이내에 매입보수를 자산관리자에게 지급한다.",{"$nulls":17},{"v":647740713,"d":"647,740,713"}]
[{"$nulls":8},"성과보수(매입)"]
[{"$nulls":8},"기본보수(운용)",{"$nulls":4},"a. 부동산:(부동산 매입가액+매입부대비용)x연0.5%\nb. 집합투자증권 및 지분증권 등 부동산을 제외한 대상자산:(위탁자가 해당 대상자산을 매입하는 시점에 그 대상자산의 기초자산인 부동산의 평가금액+매입부대비용)x연0.5%x위탁자의 지분율\n=> 결산기 주주총회의 승인을 득한 날로부터 1주일 이내에 운용보수를 자산관리자에게 지급한다.",{"$nulls":17},{"$f":" '5부.Ⅱ'!U24","v":0}]
[{"$nulls":8},"성과보수(운용)",{"$nulls":4},"(당해연도 1주당 운용성과보수 차감 전 배당액 - 과거 사업연도 1주당 운용성과보수 차감 전 배당액 중 최대액) X 당해연도 가중평균 총 발행 주식수 X 25%\r\n => 마지막 사업연도 종료일(11월 30일)에 외부감사인의 결산보고서 주주총회 승인을 득한 날로부터 1주일 이내에 지급한다."]
[{"$nulls":8},"기본보수(매각)",{"$nulls":4},"a. 대산자산의 매각 급액 X 0.5%\r\n=> 각 처분일이 속한 결산기에 외부감사인의 결산보고서를 작성하여 주주총회의 승인을 득한 날로부터 1주일 이내에 지급한다."]
[{"$nulls":8},"기본보수(개발)",{"$nulls":4},"토지의 매입 완료일로부터 건물의 (임시)사용승인일까지 발생하는 공사비, 국민주택채권매각차손, 법률자문수수료, 건설공사보험료, 안전관리예치금 보험료, 설계비, 감리비, 인허가비용, 광고홍보비, 민원처리비, 부담금 등 취득세 과표에 포함되는 모든 비용 및 취득세(단, 토지관련비용, 금융비용 및 운영비용은 제외)를 포함한 금액의 5% 상당액\n=> 총 개발보수 중 해당 사업연도에 해당하는 금액을 일할계산하여 결산기 주주총회의 승인을 득한 날로부터 1주일 이내에 운용보수를 자산관리자에게 지급한다."]
[null,null,"사무수탁회사",{"$nulls":5},"위탁보수",null,null,"신한아이타스㈜",null,"a. 주식이 증권거래소에 상장된 날의 직전일까지는 결산기별 2,000만원\nb. 주식이 증권거래소에 상장된 날부터는 결산기별 4,250만원\nc. 추가로 매입하는 자산에 대하여 추가매입자산의 가중평균매입가액*정해진 보수율(0.005%~0.01%)\n => 매 결산기마다 해당 결산기 말일 이후 수탁자의 청구일로부터 14일 이내에 현금으로 지급한다.",{"$nulls":17},{"$f":" '5부.Ⅱ'!U27","v":{"v":43729700,"d":"43,729,700"}}]
[null,null,"자산보관회사",{"$nulls":5},"위탁보수",null,null,"㈜신한은행",null,"최초 설정자금이 들어온 날부터 본계약의 종료일까지 연정액 일천만원(VAT별도)\r\n=> 매 기별로 청구일로부터 7영업일 이내에 현금 지급한다.",{"$nulls":17},{"$f":" '5부.Ⅱ'!U26","v":{"v":5000000,"d":"5,000,000"}}]
[null,null,"시설관리회사",{"$nulls":5},"위탁보수"]
[null,null,"임대관리회사",{"$nulls":5},"위탁보수"]
[null,null,"재산관리회사",{"$nulls":5},"위탁보수"]
[null,null,"합 계",{"$nulls":28},{"$f":"SUM(AF5:AK15)","v":{"v":696470413,"d":"696,470,413"}}]
[{"$nulls":4},"※ 위탁보수 : 자산관리회사, 자산보관회사 등 위탁기관 및 대상물건, 위탁비율, 계산방법, 지급시기 및 지급방법을 위탁기관\n   별로 구체적으로 기재하며, 해당 기간의 발생주의에 따른 금액을 위탁비용으로 기재"]
[{"$nulls":4},"* 자산관리회사 수익증권매입보수 647,740,713원은 영업비용이 아닌 수익증권 원가에 산입하여 회계처리함.",{"$nulls":32},"← 필요시 주석 기재"]
[]
[]
[]
["* 입력도움말\n1. 표 안의 행은 입력사항에 맞춰 높이를 조절하시면 됩니다.\n2. 부동산별로 위탁수수료 계산방법이 다를 경우에는 대상물건 등의 해당 셀 안의 내용입력시 부동산별로 입력하시면 됩니다.\n"]

{"sheet":"3부.Ⅴ","index":27,"n_rows":17,"n_cols":38,"rows_kept":17,"merged":[[1,0,1,14],[3,31,3,36],[4,2,4,12],[4,15,4,16],[4,21,4,22],[4,27,4,28],[4,33,4,34],[5,2,5,12],[5,13,5,18],[5,19,5,24],[5,25,5,30],[5,31,5,36],[6,4,6,36],[7,4,7,36],[10,2,10,12],[10,15,10,16],[10,21,10,22],[10,27,10,28],[10,33,10,34],[11,2,11,12],[11,13,11,18],[11,19,11,24],[11,25,11,30],[11,31,11,36],[12,2,12,12],[12,13,12,18],[12,19,12,24],[12,25,12,30],[12,31,12,36],[13,2,13,12],[13,13,13,18],[13,19,13,24],[13,25,13,30],[13,31,13,36],[14,2,14,12],[14,13,14,18],[14,19,14,24],[14,25,14,30],[14,31,14,36],[16,0,16,36]]}
[]
["Ⅴ. 자기자본수익률"]
[]
[{"$nulls":31},"(단위 : %)"]
[null,null,"구 분",{"$nulls":11},"제",{"$f":"표지!F8","v":4},null,"기",null,null,"제",3,null,"기",null,null,"제",2,null,"기",null,null,"제",1,null,"기"]
[null,null,"당해회사수익률",{"$nulls":10},{"$f":"IFERROR((((1+(N12/((N14+N15)/2)))^(12/N13))-1)*100,\"\")","v":{"v":5.593323176342957,"d":"5.59"}},{"$nulls":5},{"$f":"IFERROR((((1+(T12/((T14+T15)/2)))^(12/T13))-1)*100,\"\")","v":{"v":-0.2142737169474107,"d":"(0.21)"}},{"$nulls":5},{"$f":"IFERROR((((1+(Z12/((Z14+Z15)/2)))^(12/Z13))-1)*100,\"\")","v":{"v":-2.143862223524906,"d":"(2.14)"}},{"$nulls":5},{"$f":"IFERROR((((1+(AF12/((AF14+AF15)/2)))^(12/AF13))-1)*100,\"\")","v":{"v":-8.12595552292299,"d":"(8.13)"}}]
[{"$nulls":4},"※ 수익률은 회계적 자기자본이익률(Return on Equity)로서 연단위로 환산하며 다음과 같이 \n    계산함\n    결산기수익률=(당기순이익/[(연기초납입자본금+연기말납입자본금)/2])\n※ 납입자본금 = 자본금 + 자본잉여금\n※ 상기산식은 1기 사업연도가 12개월일 경우를 가정한 것으로, 1기의 사업연도가 6개월일 \n    경우 상기 산식을 준용하여 최근 1년간 분기별 연환산 자기자본수익율을 제시할 것\n※ 수익률은 소수점 둘째 자리까지 기재할 것"]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[null,null,"* 산출근거자료"]
[null,null,"구 분",{"$nulls":11},"제",{"$f":"P5","v":4},null,"기",null,null,"제",{"$f":"V5","v":3},null,"기",null,null,"제",{"$f":"AB5","v":2},null,"기",null,null,"제",{"$f":"AH5","v":1},null,"기"]
[null,null,"결산기누적순이익",{"$nulls":10},{"$f":"'5부.Ⅱ'!U73","v":{"v":18889201443,"d":"18,889,201,443"}},{"$nulls":5},{"v":-496229966,"d":"(496,229,966)"},{"$nulls":5},{"v":-1321492232,"d":"(1,321,492,232)"},{"$nulls":5},{"v":-125133733,"d":"(125,133,733)"}]
[null,null,"결산기누적개월수",{"$nulls":10},6,{"$nulls":5},6,{"$nulls":5},6,{"$nulls":5},4]
[null,null,"연기초납입자본금",{"$nulls":10},{"$f":"'5부.Ⅰ'!AG112+'5부.Ⅰ'!AG115","v":{"v":685109342670,"d":"685,109,342,670"}},{"$nulls":5},{"v":240741961760,"d":"240,741,961,760"},{"$nulls":5},{"v":4492289000,"d":"4,492,289,000"},{"$nulls":5},{"v":4492289000,"d":"4,492,289,000"}]
[null,null,"연기말납입자본금",{"$nulls":10},{"$f":"'5부.Ⅰ'!U112+'5부.Ⅰ'!U115","v":{"v":684362130210,"d":"684,362,130,210"}},{"$nulls":5},{"v":685109342670,"d":"685,109,342,670"},{"$nulls":5},{"v":240741961760,"d":"240,741,961,760"},{"$nulls":5},{"v":4492289000,"d":"4,492,289,000"}]
[]
["* 입력도움말\n1. 기수는 표 왼쪽부터 최근 기수를 입력하여 주시기 바랍니다."]

{"sheet":"4부.Ⅰ.1","index":28,"n_rows":19,"n_cols":38,"rows_kept":19,"merged":[[1,0,1,36],[3,0,3,36],[5,1,5,36],[7,29,7,36],[8,2,8,6],[8,7,8,11],[8,12,8,15],[8,16,8,19],[8,20,8,22],[8,23,8,26],[8,27,8,30],[8,31,8,34],[8,35,8,36],[9,2,9,6],[9,7,9,11],[9,12,9,15],[9,16,9,19],[9,20,9,22],[9,23,9,26],[9,27,9,30],[9,31,9,34],[9,35,9,36],[10,2,10,6],[10,7,10,11],[10,12,10,15],[10,16,10,19],[10,20,10,22],[10,23,10,26],[10,27,10,30],[10,31,10,34],[10,35,10,36],[11,2,11,6],[11,7,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,22],[11,23,11,26],[11,27,11,30],[11,31,11,34],[11,35,11,36],[12,2,12,6],[12,7,12,11],[12,12,12,15],[12,16,12,19],[12,20,12,22],[12,23,12,26],[12,27,12,30],[12,31,12,34],[12,35,12,36],[13,2,13,6],[13,7,13,11],[13,12,13,15],[13,16,13,19],[13,20,13,22],[13,23,13,26],[13,27,13,30],[13,31,13,34],[13,35,13,36],[14,4,14,36],[15,4,15,36],[18,0,18,36]]}
[]
["제 4 부 부동산개발사업에 대한 투자 현황"]
[]
["Ⅰ. 부동산개발사업의 현황"]
[]
[null,"1. 개요"]
[]
[{"$nulls":29},"(단위 : 백만원)"]
[null,null,"개발사업명",{"$nulls":4},"소재지",{"$nulls":4},"개발규모(㎡) ",{"$nulls":3},"준공\n예정일",{"$nulls":3},"공정률",null,null,"총사업비",{"$nulls":3},"총\n투자금액",{"$nulls":3},"기\n투자금액",{"$nulls":3},"비고",null,"투자대상"]
[]
[]
[]
[]
[]
[{"$nulls":4},"※ 1. 총사업비는 당해 개발사업의 총사업비를 말함\n    2. 총투자금액은 당해 부동산투자회사가 투자하여야 하는 총금액을 말함\n    3. 기투자금액이란 당해 부동산투자회사가 이미 투자한 총금액을 말함"]
[{"$nulls":37},"← 필요시 주석 기재"]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n3. 개발규모, 공정률, 총사업비, 총투자금액, 기투자금액은 숫자로만 입력하시고, 자세한 사항은 비고 혹은 4부.Ⅰ.2 시트를 이용\n    하시기 바랍니다.\n4. 준공예정일은 YYYY-MM-DD 형식으로 입력 바랍니다.\n5. AL열 투자대상을 선택하여 주시기 바랍니다."]

{"sheet":"4부.Ⅰ.2","index":29,"n_rows":26,"n_cols":38,"rows_kept":26,"merged":[[1,1,1,36],[3,1,3,36],[4,2,8,36],[4,37,8,42],[10,1,10,36],[11,2,15,36],[17,1,17,36],[18,2,22,36],[18,37,22,42],[25,0,25,36]]}
[]
[null,"2. 당기에 추진중인 부동산개발사업 현황"]
[]
[null,"1) 부동산개발사업명(1)"]
[{"$nulls":37}," - 사업계획서가 작성되어 이사회 결의를 거친 프로젝트 및 건설중인 프로젝트를 의미하며, \n    이 경우 기 작성된 사업계획서를 바탕으로 하여 다음의 순으로 내용을 개략 나타냄\n\n · 사업의 개요\n · 자금의 조달, 투자 및 회수에 관한 사항\n · 추정손익에 관한 사항\n · 사업의 위험에 관한 사항\n · 공사시공 등 외용역에 관한 사항\n · 그 밖에 투자자를 보호하기 위하여 필요한 사항"]
[]
[]
[]
[]
[]
[null,"2) 부동산개발사업명(2)"]
[]
[]
[]
[]
[]
[]
[null,"3) 장래 예정인 부동산개발사업 현황"]
[{"$nulls":37}," - 사업계획서 작성 이전 단계에 있으나, 개발 추진가능성이 상당하고 정보의 공개가 당사의 이익에\n    해가 되지 않는다면, 대상 프로젝트에 대한 개략적 정보를 나타냄"]
[]
[]
[]
[]
[]
[]
["* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n"]

{"sheet":"5부.Ⅰ","index":30,"n_rows":134,"n_cols":39,"rows_kept":134,"merged":[[1,1,1,37],[3,1,3,37],[5,26,5,28],[6,26,6,28],[7,34,7,37],[8,3,9,13],[9,14,9,25],[9,26,9,37],[10,14,10,19],[10,20,10,25],[10,26,10,31],[10,32,10,37],[11,14,11,19],[11,20,11,25],[11,26,11,31],[11,32,11,37],[12,14,12,19],[12,20,12,25],[12,26,12,31],[12,32,12,37],[13,14,13,19],[13,20,13,25],[13,26,13,31],[13,32,13,37],[14,14,14,19],[14,20,14,25],[14,26,14,31],[14,32,14,37],[15,14,15,19],[15,20,15,25],[15,26,15,31],[15,32,15,37],[16,14,16,19],[16,20,16,25],[16,26,16,31],[16,32,16,37],[17,14,17,19],[17,20,17,25],[17,26,17,31],[17,32,17,37],[18,14,18,19],[18,20,18,25],[18,26,18,31],[18,32,18,37],[19,14,19,19],[19,20,19,25],[19,26,19,31],[19,32,19,37],[20,14,20,19],[20,20,20,25],[20,26,20,31],[20,32,20,37],[21,14,21,19],[21,20,21,25],[21,26,21,31],[21,32,21,37],[22,14,22,19],[22,20,22,25],[22,26,22,31],[22,32,22,37],[23,14,23,19],[23,20,23,25],[23,26,23,31],[23,32,23,37],[24,14,24,19],[24,20,24,25],[24,26,24,31],[24,32,24,37],[25,14,25,19],[25,20,25,25],[25,26,25,31],[25,32,25,37],[26,14,26,19],[26,20,26,25],[26,26,26,31],[26,32,26,37],[27,14,27,19],[27,20,27,25],[27,26,27,31],[27,32,27,37],[28,14,28,19],[28,20,28,25],[28,26,28,31],[28,32,28,37],[29,14,29,19],[29,20,29,25],[29,26,29,31],[29,32,29,37],[30,14,30,19],[30,20,30,25],[30,26,30,31],[30,32,30,37],[31,14,31,19],[31,20,31,25],[31,26,31,31],[31,32,31,37],[32,14,32,19],[32,20,32,25],[32,26,32,31],[32,32,32,37],[33,14,33,19],[33,20,33,25],[33,26,33,31],[33,32,33,37],[34,14,34,19],[34,20,34,25],[34,26,34,31],[34,32,34,37],[35,14,35,19],[35,20,35,25],[35,26,35,31],[35,32,35,37],[36,14,36,19],[36,20,36,25],[36,26,36,31],[36,32,36,37],[37,14,37,19],[37,20,37,25],[37,26,37,31],[37,32,37,37],[38,14,38,19],[38,20,38,25],[38,26,38,31],[38,32,38,37],[39,14,39,19],[39,20,39,25],[39,26,39,31],[39,32,39,37],[40,14,40,19],[40,20,40,25],[40,26,40,31],[40,32,40,37],[41,14,41,19],[41,20,41,25],[41,26,41,31],[41,32,41,37],[42,14,42,19],[42,20,42,25],[42,26,42,31],[42,32,42,37],[43,14,43,19],[43,20,43,25],[43,26,43,31],[43,32,43,37],[44,14,44,19],[44,20,44,25],[44,26,44,31],[44,32,44,37],[45,14,45,19],[45,20,45,25],[45,26,45,31],[45,32,45,37],[46,14,46,19],[46,20,46,25],[46,26,46,31],[46,32,46,37],[47,14,47,19],[47,20,47,25],[47,26,47,31],[47,32,47,37],[48,14,48,19],[48,20,48,25],[48,26,48,31],[48,32,48,37],[49,14,49,19],[49,20,49,25],[49,26,49,31],[49,32,49,37],[50,14,50,19],[50,20,50,25],[50,26,50,31],[50,32,50,37],[51,14,51,19],[51,20,51,25],[51,26,51,31],[51,32,51,37],[52,14,52,19],[52,20,52,25],[52,26,52,31],[52,32,52,37],[53,14,53,19],[53,20,53,25],[53,26,53,31],[53,32,53,37],[54,14,54,19],[54,20,54,25],[54,26,54,31],[54,32,54,37],[55,14,55,19],[55,20,55,25],[55,26,55,31],[55,32,55,37],[56,14,56,19],[56,20,56,25],[56,26,56,31],[56,32,56,37],[57,14,57,19],[57,20,57,25],[57,26,57,31],[57,32,57,37],[58,14,58,19],[58,20,58,25],[58,26,58,31],[58,32,58,37],[59,14,59,19],[59,20,59,25],[59,26,59,31],[59,32,59,37],[60,14,60,19],[60,20,60,25],[60,26,60,31],[60,32,60,37],[61,14,61,19],[61,20,61,25],[61,26,61,31],[61,32,61,37],[62,14,62,19],[62,20,62,25],[62,26,62,31],[62,32,62,37],[63,14,63,19],[63,20,63,25],[63,26,63,31],[63,32,63,37],[64,14,64,19],[64,20,64,25],[64,26,64,31],[64,32,64,37],[65,14,65,19],[65,20,65,25],[65,26,65,31],[65,32,65,37],[66,14,66,19],[66,20,66,25],[66,26,66,31],[66,32,66,37],[67,14,67,19],[67,20,67,25],[67,26,67,31],[67,32,67,37],[68,14,68,19],[68,20,68,25],[68,26,68,31],[68,32,68,37],[69,14,69,19],[69,20,69,25],[69,26,69,31],[69,32,69,37],[70,14,70,19],[70,20,70,25],[70,26,70,31],[70,32,70,37],[71,14,71,19],[71,20,71,25],[71,26,71,31],[71,32,71,37],[72,14,72,19],[72,20,72,25],[72,26,72,31],[72,32,72,37],[73,14,73,19],[73,20,73,25],[73,26,73,31],[73,32,73,37],[74,14,74,19],[74,20,74,25],[74,26,74,31],[74,32,74,37],[75,14,75,19],[75,20,75,25],[75,26,75,31],[75,32,75,37],[76,14,76,19],[76,20,76,25],[76,26,76,31],[76,32,76,37],[77,14,77,19],[77,20,77,25],[77,26,77,31],[77,32,77,37],[78,14,78,19],[78,20,78,25],[78,26,78,31],[78,32,78,37],[79,14,79,19],[79,20,79,25],[79,26,79,31],[79,32,79,37],[80,14,80,19],[80,20,80,25],[80,26,80,31],[80,32,80,37],[81,14,81,19],[81,20,81,25],[81,26,81,31],[81,32,81,37],[82,14,82,19],[82,20,82,25],[82,26,82,31],[82,32,82,37],[83,14,83,19],[83,20,83,25],[83,26,83,31],[83,32,83,37],[84,14,84,19],[84,20,84,25],[84,26,84,31],[84,32,84,37],[85,14,85,19],[85,20,85,25],[85,26,85,31],[85,32,85,37],[86,14,86,19],[86,20,86,25],[86,26,86,31],[86,32,86,37],[87,14,87,19],[87,20,87,25],[87,26,87,31],[87,32,87,37],[88,14,88,19],[88,20,88,25],[88,26,88,31],[88,32,88,37],[89,14,89,19],[89,20,89,25],[89,26,89,31],[89,32,89,37],[90,14,90,19],[90,20,90,25],[90,26,90,31],[90,32,90,37],[91,14,91,19],[91,20,91,25],[91,26,91,31],[91,32,91,37],[92,14,92,19],[92,20,92,25],[92,26,92,31],[92,32,92,37],[93,14,93,19],[93,20,93,25],[93,26,93,31],[93,32,93,37],[94,14,94,19],[94,20,94,25],[94,26,94,31],[94,32,94,37],[95,14,95,19],[95,20,95,25],[95,26,95,31],[95,32,95,37],[96,14,96,19],[96,20,96,25],[96,26,96,31],[96,32,96,37],[97,14,97,19],[97,20,97,25],[97,26,97,31],[97,32,97,37],[98,14,98,19],[98,20,98,25],[98,26,98,31],[98,32,98,37],[99,14,99,19],[99,20,99,25],[99,26,99,31],[99,32,99,37],[100,14,100,19],[100,20,100,25],[100,26,100,31],[100,32,100,37],[101,14,101,19],[101,20,101,25],[101,26,101,31],[101,32,101,37],[102,14,102,19],[102,20,102,25],[102,26,102,31],[102,32,102,37],[103,14,103,19],[103,20,103,25],[103,26,103,31],[103,32,103,37],[104,14,104,19],[104,20,104,25],[104,26,104,31],[104,32,104,37],[105,14,105,19],[105,20,105,25],[105,26,105,31],[105,32,105,37],[106,14,106,19],[106,20,106,25],[106,26,106,31],[106,32,106,37],[107,14,107,19],[107,20,107,25],[107,26,107,31],[107,32,107,37],[108,14,108,19],[108,20,108,25],[108,26,108,31],[108,32,108,37],[109,14,109,19],[109,20,109,25],[109,26,109,31],[109,32,109,37],[110,14,110,19],[110,20,110,25],[110,26,110,31],[110,32,110,37],[111,14,111,19],[111,20,111,25],[111,26,111,31],[111,32,111,37],[112,14,112,19],[112,20,112,25],[112,26,112,31],[112,32,112,37],[113,14,113,19],[113,20,113,25],[113,26,113,31],[113,32,113,37],[114,14,114,19],[114,20,114,25],[114,26,114,31],[114,32,114,37],[115,14,115,19],[115,20,115,25],[115,26,115,31],[115,32,115,37],[116,14,116,19],[116,20,116,25],[116,26,116,31],[116,32,116,37],[117,14,117,19],[117,20,117,25],[117,26,117,31],[117,32,117,37],[118,14,118,19],[118,20,118,25],[118,26,118,31],[118,32,118,37],[119,14,119,19],[119,20,119,25],[119,26,119,31],[119,32,119,37],[120,14,120,19],[120,20,120,25],[120,26,120,31],[120,32,120,37],[121,14,121,19],[121,20,121,25],[121,26,121,31],[121,32,121,37],[122,14,122,19],[122,20,122,25],[122,26,122,31],[122,32,122,37],[123,14,123,19],[123,20,123,25],[123,26,123,31],[123,32,123,37],[124,14,124,19],[124,20,124,25],[124,26,124,31],[124,32,124,37],[125,14,125,19],[125,20,125,25],[125,26,125,31],[125,32,125,37],[126,14,126,19],[126,20,126,25],[126,26,126,31],[126,32,126,37],[127,14,127,19],[127,20,127,25],[127,26,127,31],[127,32,127,37],[128,14,128,19],[128,20,128,25],[128,26,128,31],[128,32,128,37],[130,4,130,37],[133,1,133,37]]}
[]
[null,"제 5 부 재무제표에 관한 사항"]
[]
[null,"Ⅰ. 재무상태표"]
[]
[{"$nulls":12},"당기",null,null,"제",{"$f":"표지!F8","v":4},"기",null,"기말",null,null,"기준일",{"$nulls":3},{"$f":"표지!G6","v":"2021.11.30"},{"$nulls":3},"현재"]
[{"$nulls":12},"전기",null,null,"제",{"$f":"Q6-1","v":3},"기",null,"기말",null,null,"기준일",{"$nulls":3},"2021.05.31",{"$nulls":3},"현재"]
[{"$nulls":3},"회사명:",null,null,{"$f":"표지!E28","v":"이에스알켄달스퀘어위탁관리부동산투자회사(주)"},{"$nulls":27},"(단위: 원)"]
[{"$nulls":3},"과 목",{"$nulls":13},"제",{"$f":"Q6","v":4},"(당)기",null,null,{"$f":"T6","v":"기말"},{"$nulls":6},"제",{"$f":"Q7","v":3},"(전)기",null,null,{"$f":"T7","v":"기말"}]
[{"$nulls":14},"금  액",{"$nulls":11},"금  액"]
[{"$nulls":3},"I. 자  산"]
["A000000",null,null," 1. 유동자산",{"$nulls":16},{"$f":"+O13+O14+O15+O16+O17+O18+O19+O20+O21+O22+O23+O24+O25+O26+O32+O33+O34+O35","v":{"v":3690555944,"d":"3,690,555,944"}},{"$nulls":11},{"$f":"+AA13+AA14+AA15+AA16+AA17+AA18+AA19+AA20+AA21+AA22+AA23+AA24+AA25+AA26+AA32+AA33+AA34+AA35","v":{"v":12608018703,"d":"12,608,018,703"}}]
["A011000",null,null,"  1) 현금및현금성자산",{"$nulls":10},{"v":1706287357,"d":"1,706,287,357"},{"$nulls":11},{"v":8289912266,"d":"8,289,912,266"}]
["A012000",null,null,"  2) 단기금융상품"]
["A013000",null,null,"  3) 매출채권"]
["A014000",null,null,"  4) 미청구공사"]
["A015000",null,null,"  5) 미수수익",{"$nulls":10},{"v":1058636957,"d":"1,058,636,957"},{"$nulls":11},{"v":4311171447,"d":"4,311,171,447"}]
["A016000",null,null,"  6) 분양미수금"]
["A017000",null,null,"  7) 기타미수금"]
["A018000",null,null,"  8) 선급금"]
["A019000",null,null,"  9) 선급비용"]
["A020000",null,null,"  10) 부가세대급금"]
["A021000",null,null,"  11) 선급법인세",{"$nulls":10},{"v":925631630,"d":"925,631,630"},{"$nulls":11},{"v":6934990,"d":"6,934,990"}]
["A022000",null,null,"  12) 단기대여금"]
["A023000",null,null,"  13) 유가증권"]
["A024000",null,null,"  14) 재고자산",{"$nulls":10},{"$f":"+O27+O28+O29+O30+O31","v":0},{"$nulls":11},{"$f":"+AA27+AA28+AA29+AA30+AA31","v":0}]
["A024110",null,null,"   용지"]
["A024120",null,null,"   미성공사"]
["A024130",null,null,"   완성주택"]
["A024140",null,null,"   미완성주택"]
["A024990",null,null,"   기타"]
["A025000",null,null,"  15) 유동파생상품자산"]
["A026000",null,null,"  16) 유동보증금"]
["A027000",null,null,"  17) 매각예정 비유동자산"]
["A099000",null,null,"  18) 기타유동자산"]
["B000000",null,null," 2. 비유동자산",{"$nulls":16},{"$f":"+O37+O38+O39+O40+O46+O60+O71+O75+O76+O77+O78","v":{"v":721634755449,"d":"721,634,755,449"}},{"$nulls":11},{"$f":"+AA37+AA38+AA39+AA40+AA46+AA60+AA71+AA75+AA76+AA77+AA78","v":{"v":692287014736,"d":"692,287,014,736"}}]
["B011000",null,null,"  1) 장기금융상품"]
["B012000",null,null,"  2) 장기매출채권"]
["B013000",null,null,"  3) 장기대여금"]
["B014000",null,null,"  4) 유가증권",{"$nulls":10},{"$f":"+O41+O42+O43+O44+O45","v":{"v":721634755449,"d":"721,634,755,449"}},{"$nulls":11},{"$f":"+AA41+AA42+AA43+AA44+AA45","v":{"v":692287014736,"d":"692,287,014,736"}}]
["B014110",null,null,"   매도가능금융자산"]
["B014120",null,null,"   만기보유금융자산"]
["B014130",null,null,"   관계기업투자",{"$nulls":10},{"v":185085755449,"d":"185,085,755,449"},{"$nulls":11},{"v":158238014736,"d":"158,238,014,736"}]
["B014140",null,null,"   종속기업투자",{"$nulls":10},{"v":536549000000,"d":"536,549,000,000"},{"$nulls":11},{"v":534049000000,"d":"534,049,000,000"}]
["B014990",null,null,"   기타"]
["B015000",null,null,"  5) 유형자산",{"$nulls":10},{"$f":"+O47+O48+O49+O50+O51+O52+O53+O54+O55+O56+O57+O58+O59","v":0},{"$nulls":11},{"$f":"+AA47+AA48+AA49+AA50+AA51+AA52+AA53+AA54+AA55+AA56+AA57+AA58+AA59","v":0}]
["B015110",null,null,"   토지"]
["B015111",null,null,"   손상차손누계액(유형자산-토지)"]
["B015112",null,null,"   기타(유형자산-토지)"]
["B015120",null,null,"   건물"]
["B015121",null,null,"   감가상각누계액(유형자산-건물)"]
["B015122",null,null,"   손상차손누계액(유형자산-건물)"]
["B015123",null,null,"   기타(유형자산-건물)"]
["B015130",null,null,"   건설중인자산"]
["B015131",null,null,"   기타(건설중인자산)"]
["B015990",null,null,"   기타유형자산"]
["B015991",null,null,"   감가상각누계액(유형자산-기타유형자산)"]
["B015992",null,null,"   손상차손누계액(유형자산-기타유형자산)"]
["B015993",null,null,"   기타(유형자산-기타유형자산)"]
["B016000",null,null,"  6) 투자부동산",{"$nulls":10},{"$f":"+O61+O62+O63+O64+O65+O66+O67+O68+O69+O70","v":0},{"$nulls":11},{"$f":"+AA61+AA62+AA63+AA64+AA65+AA66+AA67+AA68+AA69+AA70","v":0}]
["B016110",null,null,"   토지"]
["B016111",null,null,"   손상차손누계액(투자부동산-토지)"]
["B016112",null,null,"   기타(투자부동산-토지)"]
["B016120",null,null,"   건물"]
["B016121",null,null,"   감가상각누계액(투자부동산-건물)"]
["B016122",null,null,"   손상차손누계액(투자부동산-건물)"]
["B016123",null,null,"   기타(투자부동산-건물)"]
["B016130",null,null,"   건설중인자산"]
["B016131",null,null,"   기타(건설중인자산)"]
["B016990",null,null,"   기타"]
["B017000",null,null,"  7) 무형자산",{"$nulls":10},{"$f":"+O72+O73+O74","v":0},{"$nulls":11},{"$f":"+AA72+AA73+AA74","v":0}]
["B017110",null,null,"   소프트웨어"]
["B017120",null,null,"   회원권"]
["B017990",null,null,"   기타"]
["B018000",null,null,"  8) 비유동보증금"]
["B019000",null,null,"  9) 비유동파생상품자산"]
["B020000",null,null,"  10) 금융리스채권"]
["B099000",null,null,"  110) 기타비유동자산"]
["C000000",null,null,"           자 산 총 계",{"$nulls":16},{"$f":"U12+U36","v":{"v":725325311393,"d":"725,325,311,393"}},{"$nulls":11},{"$f":"AG12+AG36","v":{"v":704895033439,"d":"704,895,033,439"}}]
[{"$nulls":3},"Ⅱ. 부채"]
["D000000",null,null," 1. 유동부채",{"$nulls":16},{"$f":"+O82+O83+O84+O85+O86+O87+O88+O89+O90+O91+O92+O93+O94+O95+O96+O97+O98+O99","v":{"v":922371809,"d":"922,371,809"}},{"$nulls":11},{"$f":"+AA82+AA83+AA84+AA85+AA86+AA87+AA88+AA89+AA90+AA91+AA92+AA93+AA94+AA95+AA96+AA97+AA98+AA99","v":{"v":70546700,"d":"70,546,700"}}]
["D011000",null,null,"  1) 매입채무"]
["D012000",null,null,"  2) 초과청구공사"]
["D013000",null,null,"  3) 분양선수금"]
["D014000",null,null,"  4) 기타선수금"]
["D015000",null,null,"  5) 선수수익"]
["D016000",null,null,"  6) 미지급금",{"$nulls":10},{"v":750843383,"d":"750,843,383"},{"$nulls":11},{"v":69758000,"d":"69,758,000"}]
["D017000",null,null,"  7) 미지급비용",{"$nulls":10},{"v":170739726,"d":"170,739,726"}]
["D018000",null,null,"  8) 예수금",{"$nulls":10},{"v":788700,"d":"788,700"},{"$nulls":11},{"v":788700,"d":"788,700"}]
["D019000",null,null,"  9) 부가세예수금"]
["D020000",null,null,"  10) 미지급법인세"]
["D021000",null,null,"  11) 미지급배당금"]
["D022000",null,null,"  12) 단기차입금"]
["D023000",null,null,"  13) 유동성장기차입금"]
["D024000",null,null,"  14) 유동사채"]
["D025000",null,null,"  15) 유동보증금"]
["D026000",null,null,"  16) 유동파생상품부채"]
["D027000",null,null,"  17) 유동충당부채"]
["D099000",null,null,"  18) 기타유동부채"]
["E000000",null,null," 2. 비유동부채",{"$nulls":16},{"$f":"+O101+O102+O103+O104+O105+O106+O107+O108+O109","v":{"v":20000000000,"d":"20,000,000,000"}},{"$nulls":11},{"$f":"+AA101+AA102+AA103+AA104+AA105+AA106+AA107+AA108+AA109","v":0}]
["E011000",null,null,"  1) 장기매입채무"]
["E012000",null,null,"  2) 장기미지급금"]
["E013000",null,null,"  3) 장기차입금",{"$nulls":10},{"v":20000000000,"d":"20,000,000,000"}]
["E014000",null,null,"  4) 비유동사채"]
["E015000",null,null,"  5) 비유동보증금"]
["E016000",null,null,"  6) 비유동파생상품부채"]
["E017000",null,null,"  7) 순확정급여채무"]
["E018000",null,null,"  8) 비유동충당부채"]
["E099000",null,null,"  9) 기타비유동부채"]
["F000000",null,null,"         부  채  총  계",{"$nulls":16},{"$f":"U81+ U100","v":{"v":20922371809,"d":"20,922,371,809"}},{"$nulls":11},{"$f":"AG81+ AG100","v":{"v":70546700,"d":"70,546,700"}}]
[{"$nulls":3},"Ⅲ. 자 본"]
["G000000",null,null," 1. 자본금",{"$nulls":16},{"$f":"+O113+O114","v":{"v":143259000000,"d":"143,259,000,000"}},{"$nulls":11},{"$f":"+AA113+AA114","v":{"v":143259000000,"d":"143,259,000,000"}}]
["G011000",null,null,"  1) 보통주자본금",{"$nulls":10},{"v":143259000000,"d":"143,259,000,000"},{"$nulls":11},{"v":143259000000,"d":"143,259,000,000"}]
["G012000",null,null,"  2) 종류주자본금"]
["H000000",null,null," 2. 자본잉여금",{"$nulls":16},{"$f":"+O116+O117","v":{"v":541103130210,"d":"541,103,130,210"}},{"$nulls":11},{"$f":"+AA116+AA117","v":{"v":541850342670,"d":"541,850,342,670"}}]
["H011000",null,null,"  1) 주식발행초과금",{"$nulls":10},{"v":541103130210,"d":"541,103,130,210"},{"$nulls":11},{"v":541850342670,"d":"541,850,342,670"}]
["H099000",null,null,"  2) 기타"]
["I000000",null,null," 3. 자본조정",{"$nulls":16},{"$f":"+O119+O120","v":0},{"$nulls":11},{"$f":"+AA119+AA120","v":0}]
["I011000",null,null,"  1) 주식할인발행차금"]
["I099000",null,null,"  2) 기타"]
["J000000",null,null," 4. 기타포괄손익누계액",{"$nulls":16},{"$f":"+O122+O123+O124+O125+O126","v":0},{"$nulls":11},{"$f":"+AA122+AA123+AA124+AA125+AA126","v":0}]
["J011000",null,null,"  1) 유가증권평가손익"]
["J012000",null,null,"  2) 파생상품평가손익"]
["J013000",null,null,"  3) 표시통화환산손익"]
["J014000",null,null,"  4) 재평가잉여금"]
["J099000",null,null,"  5) 기타"]
["K000000",null,null," 5. 이익잉여금(결손금)",{"$nulls":16},{"v":20040809374,"d":"20,040,809,374"},{"$nulls":11},{"v":19715144069,"d":"19,715,144,069"}]
["L000000",null,null,"         자  본  총  계",{"$nulls":16},{"$f":"+O113+O114+O116+O117+O119+O120+O122+O123+O124+O125+O126+U127","v":{"v":704402939584,"d":"704,402,939,584"}},{"$nulls":11},{"$f":"+AA113+AA114+AA116+AA117+AA119+AA120+AA122+AA123+AA124+AA125+AA126+AG127","v":{"v":704824486739,"d":"704,824,486,739"}}]
["M000000",null,null,"        부 채 및 자 본 총 계",{"$nulls":16},{"$f":"U110+U128","v":{"v":725325311393,"d":"725,325,311,393"}},{"$nulls":11},{"$f":"AG110+AG128","v":{"v":704895033439,"d":"704,895,033,439"}}]
[]
[{"$nulls":38},"← 필요시 주석 기재"]
[]
[]
[null,"* 입력도움말\n1. 계정과목은 수정하지 마시기 바랍니다.(일치하는 계정과목이 없는경우 해당 대분류 아래 '기타'에 입력)\n2. 해당하는 계정과목에만 금액을 입력하시고, 그외는 기재하지 마시기 바랍니다.\n3. 당기는 당기말, 전기는 전기말 기준으로 입력하시기 바랍니다.\n4. 해당 계정과목과 관련된 대손충당금, 현재가치할인차금 등을 차감한 순액으로 입력하시기 바랍니다.\n5. 자본조정, 결손금 등 음수인 계정과목은 숫자 앞에 '-'를 붙여 음수로 입력하시기 바랍니다.\n6. 표 왼쪽에 적혀있는 코드는 수정 및 삭제하지 마시기 바랍니다."]

{"sheet":"5부.Ⅱ","index":31,"n_rows":84,"n_cols":39,"rows_kept":84,"merged":[[1,1,1,37],[3,21,3,23],[3,28,3,30],[4,21,4,23],[4,28,4,30],[5,34,5,37],[6,3,8,13],[7,14,7,25],[7,26,7,37],[8,14,8,19],[8,20,8,25],[8,26,8,31],[8,32,8,37],[9,14,9,19],[9,20,9,25],[9,26,9,31],[9,32,9,37],[10,14,10,19],[10,20,10,25],[10,26,10,31],[10,32,10,37],[11,14,11,19],[11,20,11,25],[11,26,11,31],[11,32,11,37],[12,14,12,19],[12,20,12,25],[12,26,12,31],[12,32,12,37],[13,14,13,19],[13,20,13,25],[13,26,13,31],[13,32,13,37],[14,14,14,19],[14,20,14,25],[14,26,14,31],[14,32,14,37],[15,14,15,19],[15,20,15,25],[15,26,15,31],[15,32,15,37],[16,14,16,19],[16,20,16,25],[16,26,16,31],[16,32,16,37],[17,14,17,19],[17,20,17,25],[17,26,17,31],[17,32,17,37],[18,14,18,19],[18,20,18,25],[18,26,18,31],[18,32,18,37],[19,14,19,19],[19,20,19,25],[19,26,19,31],[19,32,19,37],[20,14,20,19],[20,20,20,25],[20,26,20,31],[20,32,20,37],[21,14,21,19],[21,20,21,25],[21,26,21,31],[21,32,21,37],[22,14,22,19],[22,20,22,25],[22,26,22,31],[22,32,22,37],[23,14,23,19],[23,20,23,25],[23,26,23,31],[23,32,23,37],[24,14,24,19],[24,20,24,25],[24,26,24,31],[24,32,24,37],[25,14,25,19],[25,20,25,25],[25,26,25,31],[25,32,25,37],[26,14,26,19],[26,20,26,25],[26,26,26,31],[26,32,26,37],[27,14,27,19],[27,20,27,25],[27,26,27,31],[27,32,27,37],[28,14,28,19],[28,20,28,25],[28,26,28,31],[28,32,28,37],[29,14,29,19],[29,20,29,25],[29,26,29,31],[29,32,29,37],[30,14,30,19],[30,20,30,25],[30,26,30,31],[30,32,30,37],[31,14,31,19],[31,20,31,25],[31,26,31,31],[31,32,31,37],[32,14,32,19],[32,20,32,25],[32,26,32,31],[32,32,32,37],[33,14,33,19],[33,20,33,25],[33,26,33,31],[33,32,33,37],[34,14,34,19],[34,20,34,25],[34,26,34,31],[34,32,34,37],[35,14,35,19],[35,20,35,25],[35,26,35,31],[35,32,35,37],[36,14,36,19],[36,20,36,25],[36,26,36,31],[36,32,36,37],[37,14,37,19],[37,20,37,25],[37,26,37,31],[37,32,37,37],[38,14,38,19],[38,20,38,25],[38,26,38,31],[38,32,38,37],[39,14,39,19],[39,20,39,25],[39,26,39,31],[39,32,39,37],[40,14,40,19],[40,20,40,25],[40,26,40,31],[40,32,40,37],[41,14,41,19],[41,20,41,25],[41,26,41,31],[41,32,41,37],[42,14,42,19],[42,20,42,25],[42,26,42,31],[42,32,42,37],[43,14,43,19],[43,20,43,25],[43,26,43,31],[43,32,43,37],[44,14,44,19],[44,20,44,25],[44,26,44,31],[44,32,44,37],[45,14,45,19],[45,20,45,25],[45,26,45,31],[45,32,45,37],[46,14,46,19],[46,20,46,25],[46,26,46,31],[46,32,46,37],[47,14,47,19],[47,20,47,25],[47,26,47,31],[47,32,47,37],[48,14,48,19],[48,20,48,25],[48,26,48,31],[48,32,48,37],[49,14,49,19],[49,20,49,25],[49,26,49,31],[49,32,49,37],[50,14,50,19],[50,20,50,25],[50,26,50,31],[50,32,50,37],[51,14,51,19],[51,20,51,25],[51,26,51,31],[51,32,51,37],[52,14,52,19],[52,20,52,25],[52,26,52,31],[52,32,52,37],[53,14,53,19],[53,20,53,25],[53,26,53,31],[53,32,53,37],[54,14,54,19],[54,20,54,25],[54,26,54,31],[54,32,54,37],[55,14,55,19],[55,20,55,25],[55,26,55,31],[55,32,55,37],[56,14,56,19],[56,20,56,25],[56,26,56,31],[56,32,56,37],[57,14,57,19],[57,20,57,25],[57,26,57,31],[57,32,57,37],[58,14,58,19],[58,20,58,25],[58,26,58,31],[58,32,58,37],[59,14,59,19],[59,20,59,25],[59,26,59,31],[59,32,59,37],[60,14,60,19],[60,20,60,25],[60,26,60,31],[60,32,60,37],[61,14,61,19],[61,20,61,25],[61,26,61,31],[61,32,61,37],[62,14,62,19],[62,20,62,25],[62,26,62,31],[62,32,62,37],[63,14,63,19],[63,20,63,25],[63,26,63,31],[63,32,63,37],[64,14,64,19],[64,20,64,25],[64,26,64,31],[64,32,64,37],[65,14,65,19],[65,20,65,25],[65,26,65,31],[65,32,65,37],[66,14,66,19],[66,20,66,25],[66,26,66,31],[66,32,66,37],[67,14,67,19],[67,20,67,25],[67,26,67,31],[67,32,67,37],[68,14,68,19],[68,20,68,25],[68,26,68,31],[68,32,68,37],[69,14,69,19],[69,20,69,25],[69,26,69,31],[69,32,69,37],[70,14,70,19],[70,20,70,25],[70,26,70,31],[70,32,70,37],[71,14,71,19],[71,20,71,25],[71,26,71,31],[71,32,71,37],[72,14,72,19],[72,20,72,25],[72,26,72,31],[72,32,72,37],[73,14,73,19],[73,20,73,25],[73,26,73,31],[73,32,73,37],[74,14,74,19],[74,20,74,25],[74,26,74,31],[74,32,74,37],[75,14,75,19],[75,20,75,25],[75,26,75,31],[75,32,75,37],[76,14,76,19],[76,20,76,25],[76,26,76,31],[76,32,76,37],[77,14,77,19],[77,20,77,25],[77,26,77,31],[77,32,77,37],[78,14,78,19],[78,20,78,25],[78,26,78,31],[78,32,78,37],[80,4,80,37],[83,1,83,37]]}
[]
[null,"Ⅱ. 손익계산서"]
[]
[{"$nulls":9},"당기",null,"제",{"$f":"'5부.Ⅰ'!Q6","v":4},"기",null,"기말",null,null,"시작일",null,null,{"$f":"표지!D6","v":"2021.06.01"},{"$nulls":3},"종료일",null,null,{"$f":"표지!G6","v":"2021.11.30"}]
[{"$nulls":9},"전기",null,"제",{"$f":"'5부.Ⅰ'!Q7","v":3},"기",null,"기말",null,null,"시작일",null,null,"2020.12.01",{"$nulls":3},"종료일",null,null,{"$f":"'5부.Ⅰ'!AA7","v":"2021.05.31"}]
[{"$nulls":3},"회사명:",null,null,{"$f":"표지!E28","v":"이에스알켄달스퀘어위탁관리부동산투자회사(주)"},{"$nulls":27},"(단위: 원)"]
[{"$nulls":3},"과 목",{"$nulls":14},"제",{"$f":"M4","v":4},"(당)기",{"$nulls":9},"제",{"$f":"M5","v":3},"(전)기"]
["코 드",{"$nulls":13},"금  액",{"$nulls":11},"금  액"]
[{"$nulls":14},"최근3개월",{"$nulls":5},"당기누적",{"$nulls":5},"최근3개월",{"$nulls":5},"전기누적"]
["N000000",null,null,"Ⅰ. 영업수익",{"$nulls":10},{"$f":"+O11+O12+O13+O14+O15+O16+O17","v":{"v":4400120649,"d":"4,400,120,649"}},{"$nulls":5},{"$f":"+U11+U12+U13+U14+U15+U16+U17","v":{"v":19680322901,"d":"19,680,322,901"}},{"$nulls":5},{"$f":"+AA11+AA12+AA13+AA14+AA15+AA16+AA17","v":{"v":4307058953,"d":"4,307,058,953"}},{"$nulls":5},{"$f":"+AG11+AG12+AG13+AG14+AG15+AG16+AG17","v":{"v":4307171829,"d":"4,307,171,829"}}]
["N011000",null,null,"  1) 분양수익"]
["N012000",null,null,"  2) 임대료수익"]
["N013000",null,null,"  3) 관리비수익"]
["N014000",null,null,"  4) 부동산평가수익"]
["N015000",null,null,"  5) 배당금수익",{"$nulls":10},{"v":4400120649,"d":"4,400,120,649"},{"$nulls":5},{"v":19680322901,"d":"19,680,322,901"},{"$nulls":5},{"v":4307058953,"d":"4,307,058,953"},{"$nulls":5},{"v":4307171829,"d":"4,307,171,829"}]
["N016000",null,null,"  6) 금융리스이자수익"]
["N099000",null,null,"  7) 기타영업수익"]
["O000000",null,null,"Ⅱ. 영업비용",{"$nulls":10},{"$f":"+O19+O20+O21+O22+O23+O24+O25+O26+O27+O28+O29+O30+O31+O32+O33+O34+O35+O36+O37+O38+O39+O40+O41+O42+O43+O44+O45+O46+O47","v":{"v":164912442,"d":"164,912,442"}},{"$nulls":5},{"$f":"+U19+U20+U21+U22+U23+U24+U25+U26+U27+U28+U29+U30+U31+U32+U33+U34+U35+U36+U37+U38+U39+U40+U41+U42+U43+U44+U45+U46+U47","v":{"v":430840192,"d":"430,840,192"}},{"$nulls":5},{"$f":"+AA19+AA20+AA21+AA22+AA23+AA24+AA25+AA26+AA27+AA28+AA29+AA30+AA31+AA32+AA33+AA34+AA35+AA36+AA37+AA38+AA39+AA40+AA41+AA42+AA43+AA44+AA45+AA46+AA47","v":{"v":145146566,"d":"145,146,566"}},{"$nulls":5},{"$f":"+AG19+AG20+AG21+AG22+AG23+AG24+AG25+AG26+AG27+AG28+AG29+AG30+AG31+AG32+AG33+AG34+AG35+AG36+AG37+AG38+AG39+AG40+AG41+AG42+AG43+AG44+AG45+AG46+AG47","v":{"v":5512323574,"d":"5,512,323,574"}}]
["O011000",null,null,"  1) 분양원가"]
["O012000",null,null,"  2) 급여",{"$nulls":10},{"v":28500000,"d":"28,500,000"},{"$nulls":5},{"v":57000000,"d":"57,000,000"},{"$nulls":5},{"v":28500000,"d":"28,500,000"},{"$nulls":5},{"v":57000000,"d":"57,000,000"}]
["O013000",null,null,"  3) 상여"]
["O014000",null,null,"  4) 퇴직급여"]
["O015000",null,null,"  5) 복리후생비"]
["O016000",null,null,"  6) 자산관리수수료(AMC수수료)",{"$nulls":10},0,{"$nulls":17},{"v":2530090830,"d":"2,530,090,830"}]
["O017000",null,null,"  7) 부동산관리수수료(PM, FM 등)"]
["O018000",null,null,"  8) 자산보관수수료",{"$nulls":10},{"v":2486339,"d":"2,486,339"},{"$nulls":5},{"v":5000000,"d":"5,000,000"},{"$nulls":5},{"v":2527473,"d":"2,527,473"},{"$nulls":5},{"v":4978597,"d":"4,978,597"}]
["O019000",null,null,"  9) 일반사무위탁수수료",{"$nulls":10},{"v":21781066,"d":"21,781,066"},{"$nulls":5},{"v":43729700,"d":"43,729,700"},{"$nulls":5},{"v":21483297,"d":"21,483,297"},{"$nulls":5},{"v":39780000,"d":"39,780,000"}]
["O020000",null,null,"  10) 기타지급수수료",{"$nulls":10},{"v":13145037,"d":"13,145,037"},{"$nulls":5},{"v":226110492,"d":"226,110,492"},{"$nulls":5},{"v":92635796,"d":"92,635,796"},{"$nulls":5},{"v":2880406647,"d":"2,880,406,647"}]
["O021000",null,null,"  11) 유형자산감가상각비"]
["O022000",null,null,"  12) 투자부동산감가상각비"]
["O023000",null,null,"  13) 무형자산감가상각비"]
["O024000",null,null,"  14) 세금과공과",{"$nulls":28},{"v":67500,"d":"67,500"}]
["O025000",null,null,"  15) 광고선전비",{"$nulls":10},{"v":99000000,"d":"99,000,000"},{"$nulls":5},{"v":99000000,"d":"99,000,000"}]
["O026000",null,null,"  16) 보험료"]
["O027000",null,null,"  17) 임차료"]
["O028000",null,null,"  18) 교육훈련비"]
["O029000",null,null,"  19) 여비교통비"]
["O030000",null,null,"  20) 통신비"]
["O031000",null,null,"  21) 수선유지비"]
["O032000",null,null,"  22) 청소비"]
["O033000",null,null,"  23) 수도광열비"]
["O034000",null,null,"  24) 대손상각비"]
["O035000",null,null,"  25) 접대비"]
["O036000",null,null,"  26) 판매촉진비"]
["O037000",null,null,"  27) 이자비용"]
["O038000",null,null,"  28) 금융리스이자비용"]
["O099000",null,null,"  29) 기타영업비용"]
["P000000",null,null,"Ⅲ. 영업이익",{"$nulls":10},{"$f":"O10-O18","v":{"v":4235208207,"d":"4,235,208,207"}},{"$nulls":5},{"$f":"U10-U18","v":{"v":19249482709,"d":"19,249,482,709"}},{"$nulls":5},{"$f":"AA10-AA18","v":{"v":4161912387,"d":"4,161,912,387"}},{"$nulls":5},{"$f":"AG10-AG18","v":{"v":-1205151745,"d":"(1,205,151,745)"}}]
["Q000000",null,null,"Ⅳ. 영업외수익",{"$nulls":10},{"$f":"+O50+O51+O52+O53+O54+O55+O56+O57+O58+O59","v":{"v":651004,"d":"651,004"}},{"$nulls":5},{"$f":"+U50+U51+U52+U53+U54+U55+U56+U57+U58+U59","v":{"v":2020103,"d":"2,020,103"}},{"$nulls":5},{"$f":"+AA50+AA51+AA52+AA53+AA54+AA55+AA56+AA57+AA58+AA59","v":{"v":-15433381,"d":"(15,433,381)"}},{"$nulls":5},{"$f":"+AG50+AG51+AG52+AG53+AG54+AG55+AG56+AG57+AG58+AG59","v":{"v":708921779,"d":"708,921,779"}}]
["Q011000",null,null,"  1) 이자수익",{"$nulls":10},{"v":641429,"d":"641,429"},{"$nulls":5},{"v":2006419,"d":"2,006,419"},{"$nulls":5},{"v":2107403,"d":"2,107,403"},{"$nulls":5},{"v":48593779,"d":"48,593,779"}]
["Q012000",null,null,"  2) 배당금수익"]
["Q013000",null,null,"  3) 유가증권관련이익(처분이익 등)",{"$nulls":22},{"v":-17540784,"d":"(17,540,784)"}]
["Q014000",null,null,"  4) 파생상품관련이익(처분이익 등)"]
["Q015000",null,null,"  5) 유형자산관련이익(처분이익 등)"]
["Q016000",null,null,"  6) 투자부동산관련이익(처분이익 등)"]
["Q017000",null,null,"  7) 외화환산이익"]
["Q018000",null,null,"  8) 외환차익"]
["Q019000",null,null,"  9) 충당부채환입"]
["Q099000",null,null,"  10) 기타영업외수익",{"$nulls":10},{"v":9575,"d":"9,575"},{"$nulls":5},{"v":13684,"d":"13,684"},{"$nulls":11},{"v":660328000,"d":"660,328,000"}]
["R000000",null,null,"Ⅴ. 영업외비용",{"$nulls":10},{"$f":"+O61+O62+O63+O64+O65+O66+O67+O68+O69+O70","v":{"v":189479452,"d":"189,479,452"}},{"$nulls":5},{"$f":"+U61+U62+U63+U64+U65+U66+U67+U68+U69+U70","v":{"v":362301369,"d":"362,301,369"}},{"$nulls":5},{"$f":"+AA61+AA62+AA63+AA64+AA65+AA66+AA67+AA68+AA69+AA70","v":0},{"$nulls":5},{"$f":"+AG61+AG62+AG63+AG64+AG65+AG66+AG67+AG68+AG69+AG70","v":0}]
["R011000",null,null,"  1) 이자비용",{"$nulls":10},{"v":189479452,"d":"189,479,452"},{"$nulls":5},{"v":362301369,"d":"362,301,369"}]
["R012000",null,null,"  2) 유가증권관련손실(처분손실 등)"]
["R013000",null,null,"  3) 파생상품관련손실(처분손실 등)"]
["R014000",null,null,"  4) 유형자산관련손실(처분손실 등)"]
["R015000",null,null,"  5) 투자부동산관련손실(처분손실 등)"]
["R016000",null,null,"  6) 외화환산손실"]
["R017000",null,null,"  7) 외환차손"]
["R018000",null,null,"  8) 기부금"]
["R019000",null,null,"  9) 충당부채전입"]
["R099000",null,null,"  10) 기타영업외비용"]
["S000000",null,null,"Ⅵ. 법인세비용차감전순이익(손실)",{"$nulls":10},{"$f":"O48+O49-O60","v":{"v":4046379759,"d":"4,046,379,759"}},{"$nulls":5},{"$f":"U48+U49-U60","v":{"v":18889201443,"d":"18,889,201,443"}},{"$nulls":5},{"$f":"AA48+AA49-AA60","v":{"v":4146479006,"d":"4,146,479,006"}},{"$nulls":5},{"$f":"AG48+AG49-AG60","v":{"v":-496229966,"d":"(496,229,966)"}}]
["T000000",null,null,"Ⅶ. 법인세비용(수익)"]
["U000000",null,null,"Ⅷ. 당기순이익(손실)",{"$nulls":10},{"v":4635234953,"d":"4,635,234,953"},{"$nulls":5},{"v":18889201443,"d":"18,889,201,443"},{"$nulls":5},{"v":4146479006,"d":"4,146,479,006"},{"$nulls":5},{"v":-496229966,"d":"(496,229,966)"}]
["V000000",null,null,"Ⅸ. 기타포괄이익(손실)",{"$nulls":10},{"$f":"+O75+O76+O77","v":0},{"$nulls":5},{"$f":"+U75+U76+U77","v":0},{"$nulls":5},{"$f":"+AA75+AA76+AA77","v":0},{"$nulls":5},{"$f":"+AG75+AG76+AG77","v":0}]
["V011000",null,null,"  1) 확정급여채무 관련 기타포괄손익"]
["V012000",null,null,"  2) 유가증권 관련 기타포괄손익"]
["V099000",null,null,"  3) 기타의 기타포괄손익"]
["W000000",null,null,"Ⅹ. 총포괄이익(손실)",{"$nulls":10},{"$f":"O73+O74","v":{"v":4635234953,"d":"4,635,234,953"}},{"$nulls":5},{"$f":"U73+U74","v":{"v":18889201443,"d":"18,889,201,443"}},{"$nulls":5},{"$f":"AA73+AA74","v":{"v":4146479006,"d":"4,146,479,006"}},{"$nulls":5},{"$f":"AG73+AG74","v":{"v":-496229966,"d":"(496,229,966)"}}]
["X000000",null,null,"ⅩⅠ. 주당이익",{"$nulls":10},32,{"$nulls":5},132,{"$nulls":5},29,{"$nulls":5},{"v":-4,"d":"(4)"}]
[]
[{"$nulls":38},"← 필요시 주석 기재"]
[]
[]
[null,"* 입력도움말\n1. 계정과목은 수정하지 마시기 바랍니다.(일치하는 계정과목이 없는경우 해당 대분류 아래 '기타'에 입력)\n2. 해당하는 계정과목에만 금액을 입력하시고, 그외는 기재하지 마시기 바랍니다.\n3. 전기는 당기와 동일한 기간으로 입력하시기 바랍니다.\n    (예) : 3분기 투자보고서인 경우, 당기 최근3개월(당기 3분기 발생액), 당기누적(당기 1~3분기 누적액)\n            전기 최근3개월(전기 3분기 발생액), 전기누적(전기 1~3분기 누적액) \n4. 회사별로 계정과목 대분류가 다를 수 있습니다.\n    각 회사 기존 감사보고서상 재무제표와 대분류(영업수익, 영업비용, 영업외수익, 영업외비용 등)를 일치시켜 주시기 바랍\n    니다. 예를들어 투자부동산평가이익을 영업수익으로 분류하는 회사는 Ⅰ. 영업수익 아래 4. 기타영업수익으로 입력하고, \n    투자부동산평가이익을 영업외수익으로 분류하는 회사는 Ⅳ. 영업외수익 아래 6.  투자부동산관련이익(처분이익 등)으로 \n    분류하시면 됩니다.\n5. 매출원가와 판매비와관리비는 영업비용에 넣으시기 바랍니다. \n6. 당기순손실, 기타포괄손실 등 음수인 계정과목은 숫자 앞에 '-'를 붙여 음수로 입력하시기 바랍니다.\n7. 표 왼쪽에 적혀있는 코드는 수정 및 삭제하지 마시기 바랍니다."]

{"sheet":"5부.Ⅲ","index":32,"n_rows":32,"n_cols":39,"rows_kept":32,"merged":[[1,1,1,37],[3,21,3,23],[3,28,3,30],[4,21,4,23],[4,28,4,30],[5,34,5,37],[6,3,8,13],[7,14,7,19],[7,20,7,25],[7,26,7,31],[7,32,7,37],[8,14,8,25],[8,26,8,37],[9,14,9,19],[9,20,9,25],[9,26,9,31],[9,32,9,37],[10,14,10,19],[10,20,10,25],[10,26,10,31],[10,32,10,37],[11,14,11,19],[11,20,11,25],[11,26,11,31],[11,32,11,37],[12,14,12,19],[12,20,12,25],[12,26,12,31],[12,32,12,37],[13,14,13,19],[13,20,13,25],[13,26,13,31],[13,32,13,37],[14,14,14,19],[14,20,14,25],[14,26,14,31],[14,32,14,37],[15,14,15,19],[15,20,15,25],[15,26,15,31],[15,32,15,37],[16,14,16,19],[16,20,16,25],[16,26,16,31],[16,32,16,37],[17,14,17,19],[17,20,17,25],[17,26,17,31],[17,32,17,37],[18,14,18,19],[18,20,18,25],[18,26,18,31],[18,32,18,37],[19,14,19,19],[19,20,19,25],[19,26,19,31],[19,32,19,37],[20,14,20,19],[20,20,20,25],[20,26,20,31],[20,32,20,37],[21,14,21,19],[21,20,21,25],[21,26,21,31],[21,32,21,37],[22,14,22,19],[22,20,22,25],[22,26,22,31],[22,32,22,37],[23,14,23,19],[23,20,23,25],[23,26,23,31],[23,32,23,37],[24,14,24,19],[24,20,24,25],[24,26,24,31],[24,32,24,37],[25,14,25,19],[25,20,25,25],[25,26,25,31],[25,32,25,37],[26,14,26,19],[26,20,26,25],[26,26,26,31],[26,32,26,37],[28,4,28,37],[31,1,31,37]]}
[]
[null,"Ⅲ. 이익잉여금처분계산서"]
[]
[{"$nulls":9},"당기",null,"제",{"$f":"'5부.Ⅰ'!Q6","v":4},"기",null,"기말",null,null,"시작일",null,null,{"$f":"'5부.Ⅱ'!V4","v":"2021.06.01"},{"$nulls":3},"종료일",null,null,{"$f":"'5부.Ⅱ'!AC4","v":"2021.11.30"}]
[{"$nulls":9},"전기",null,"제",{"$f":"'5부.Ⅰ'!Q7","v":3},"기",null,"기말",null,null,"시작일",null,null,{"$f":"'5부.Ⅱ'!V5","v":"2020.12.01"},{"$nulls":3},"종료일",null,null,{"$f":"'5부.Ⅱ'!AC5","v":"2021.05.31"}]
[{"$nulls":3},"회사명:",null,null,{"$f":"표지!E28","v":"이에스알켄달스퀘어위탁관리부동산투자회사(주)"},{"$nulls":27},"(단위: 원)"]
[{"$nulls":3},"과 목",{"$nulls":14},"제",{"$f":"M4","v":4},"(당)기",{"$nulls":9},"제",{"$f":"M5","v":3},"(전)기"]
[{"$nulls":14},"처분예정일",{"$nulls":5},"2022.02.25",{"$nulls":5},"처분확정일",{"$nulls":5},"2021.08.31"]
["코 드",{"$nulls":13},"금  액",{"$nulls":11},"금  액"]
["P000000",null,null,"Ⅰ. 미처분이익잉여금(미처리결손금)",{"$nulls":16},{"$f":"SUM(O11:T14)","v":{"v":20040809374,"d":"20,040,809,374"}},{"$nulls":11},{"$f":"SUM(AA11:AF14)","v":{"v":19715144069,"d":"19,715,144,069"}}]
["P000001",null,null,"  1. 전기이월미처분이익잉여금(미처리결손금)",{"$nulls":10},{"v":1151607931,"d":"1,151,607,931"},{"$nulls":11},{"v":20211374035,"d":"20,211,374,035"}]
["P000002",null,null,"  2. 당기순이익(손실)",{"$nulls":10},{"v":18889201443,"d":"18,889,201,443"},{"$nulls":11},{"v":-496229966,"d":"(496,229,966)"}]
["P000003",null,null,"  3. 확정급여채무의 재측정요소",{"$nulls":10},0,{"$nulls":11},0]
["P000004",null,null,"  4. 기타",{"$nulls":10},0,{"$nulls":11},0]
["P000005",null,null,"Ⅱ. 임의적립금등의 이입액",{"$nulls":16},0,{"$nulls":11},0]
["P000006",null,null,"Ⅲ. 이익잉여금처분액",{"$nulls":16},{"$f":"-(O17+O18+O19+O20+O25)","v":{"v":-9360706000,"d":"(9,360,706,000)"}},{"$nulls":11},{"$f":"-(AA17+AA18+AA19+AA20+AA25)","v":{"v":-18563536138,"d":"(18,563,536,138)"}}]
["P000007",null,null,"  1. 법정준비금",{"$nulls":10},0,{"$nulls":11},0]
["P000008",null,null,"  2. 임의준비금",{"$nulls":10},0,{"$nulls":11},0]
["P000009",null,null,"  3. 주식할인발행차금상각액",{"$nulls":10},0,{"$nulls":11},0]
["P000010",null,null,"  4. 배당금",{"$nulls":10},{"$f":"SUM(O21:T24)","v":{"v":19196706000,"d":"19,196,706,000"}},{"$nulls":11},{"$f":"SUM(AA21:AF24)","v":{"v":19263536138,"d":"19,263,536,138"}}]
["P000011",null,null,"보통주현금배당금",{"$nulls":10},{"v":19196706000,"d":"19,196,706,000"},{"$nulls":11},{"v":19263536138,"d":"19,263,536,138"}]
["P000012",null,null,"종류주현금배당금",{"$nulls":10},0,{"$nulls":11},0]
["P000013",null,null,"보통주주식배당금",{"$nulls":10},0,{"$nulls":11},0]
["P000014",null,null,"종류주주식배당금",{"$nulls":10},0,{"$nulls":11},0]
["P000015",null,null,"  5. 기타",{"$nulls":10},{"v":-9836000000,"d":"(9,836,000,000)"},{"$nulls":11},{"v":-700000000,"d":"(700,000,000)"}]
["P000016",null,null,"Ⅳ. 결손금처리액",{"$nulls":16},0,{"$nulls":11},0]
["P000017",null,null,"Ⅴ. 차기이월미처분이익잉여금(미처리결손금)",{"$nulls":16},{"$f":"U10+U15+U16+U26","v":{"v":10680103374,"d":"10,680,103,374"}},{"$nulls":11},{"$f":"AG10+AG15+AG16+AG26","v":{"v":1151607931,"d":"1,151,607,931"}}]
[]
[{"$nulls":38},"← 필요시 주석 기재"]
[]
[]
[null,"* 입력도움말\n1. 계정과목은 수정하지 마시기 바랍니다.(일치하는 계정과목이 없는경우 해당 대분류 아래 '기타'에 입력)\n2. 해당하는 계정과목에만 금액을 입력하시고, 그외는 기재하지 마시기 바랍니다.\n3 이익잉여금처분계산서는 결산기에만 입력하시기 바랍니다.\n4. 미처리결손금, 당기순손실, 결손금처리액과 같이 음수인 계정과목은 숫자 앞에 '-'를 붙여 음수로 입력하시기 바랍니다.\n5. 표 왼쪽에 적혀있는 코드는 수정 및 삭제하지 마시기 바랍니다.\n"]

{"sheet":"5부.Ⅳ","index":33,"n_rows":90,"n_cols":39,"rows_kept":90,"merged":[[0,3,0,36],[1,1,1,37],[3,21,3,23],[3,28,3,30],[4,21,4,23],[4,28,4,30],[5,34,5,37],[6,3,7,13],[7,14,7,25],[7,26,7,37],[8,14,8,19],[8,20,8,25],[8,26,8,31],[8,32,8,37],[9,14,9,19],[9,20,9,25],[9,26,9,31],[9,32,9,37],[10,14,10,19],[10,20,10,25],[10,26,10,31],[10,32,10,37],[11,14,11,19],[11,20,11,25],[11,26,11,31],[11,32,11,37],[12,14,12,19],[12,20,12,25],[12,26,12,31],[12,32,12,37],[13,14,13,19],[13,20,13,25],[13,26,13,31],[13,32,13,37],[14,14,14,19],[14,20,14,25],[14,26,14,31],[14,32,14,37],[15,14,15,19],[15,20,15,25],[15,26,15,31],[15,32,15,37],[16,14,16,19],[16,20,16,25],[16,26,16,31],[16,32,16,37],[17,14,17,19],[17,20,17,25],[17,26,17,31],[17,32,17,37],[18,14,18,19],[18,20,18,25],[18,26,18,31],[18,32,18,37],[19,14,19,19],[19,20,19,25],[19,26,19,31],[19,32,19,37],[20,14,20,19],[20,20,20,25],[20,26,20,31],[20,32,20,37],[21,14,21,19],[21,20,21,25],[21,26,21,31],[21,32,21,37],[22,14,22,19],[22,20,22,25],[22,26,22,31],[22,32,22,37],[23,14,23,19],[23,20,23,25],[23,26,23,31],[23,32,23,37],[24,14,24,19],[24,20,24,25],[24,26,24,31],[24,32,24,37],[25,14,25,19],[25,20,25,25],[25,26,25,31],[25,32,25,37],[26,14,26,19],[26,20,26,25],[26,26,26,31],[26,32,26,37],[27,14,27,19],[27,20,27,25],[27,26,27,31],[27,32,27,37],[28,14,28,19],[28,20,28,25],[28,26,28,31],[28,32,28,37],[29,14,29,19],[29,20,29,25],[29,26,29,31],[29,32,29,37],[30,14,30,19],[30,20,30,25],[30,26,30,31],[30,32,30,37],[31,14,31,19],[31,20,31,25],[31,26,31,31],[31,32,31,37],[32,14,32,19],[32,20,32,25],[32,26,32,31],[32,32,32,37],[33,14,33,19],[33,20,33,25],[33,26,33,31],[33,32,33,37],[34,14,34,19],[34,20,34,25],[34,26,34,31],[34,32,34,37],[35,14,35,19],[35,20,35,25],[35,26,35,31],[35,32,35,37],[36,14,36,19],[36,20,36,25],[36,26,36,31],[36,32,36,37],[37,14,37,19],[37,20,37,25],[37,26,37,31],[37,32,37,37],[38,14,38,19],[38,20,38,25],[38,26,38,31],[38,32,38,37],[39,14,39,19],[39,20,39,25],[39,26,39,31],[39,32,39,37],[40,14,40,19],[40,20,40,25],[40,26,40,31],[40,32,40,37],[41,14,41,19],[41,20,41,25],[41,26,41,31],[41,32,41,37],[42,14,42,19],[42,20,42,25],[42,26,42,31],[42,32,42,37],[43,14,43,19],[43,20,43,25],[43,26,43,31],[43,32,43,37],[44,14,44,19],[44,20,44,25],[44,26,44,31],[44,32,44,37],[45,14,45,19],[45,20,45,25],[45,26,45,31],[45,32,45,37],[46,14,46,19],[46,20,46,25],[46,26,46,31],[46,32,46,37],[47,14,47,19],[47,20,47,25],[47,26,47,31],[47,32,47,37],[48,14,48,19],[48,20,48,25],[48,26,48,31],[48,32,48,37],[49,14,49,19],[49,20,49,25],[49,26,49,31],[49,32,49,37],[50,14,50,19],[50,20,50,25],[50,26,50,31],[50,32,50,37],[51,14,51,19],[51,20,51,25],[51,26,51,31],[51,32,51,37],[52,14,52,19],[52,20,52,25],[52,26,52,31],[52,32,52,37],[53,14,53,19],[53,20,53,25],[53,26,53,31],[53,32,53,37],[54,14,54,19],[54,20,54,25],[54,26,54,31],[54,32,54,37],[55,14,55,19],[55,20,55,25],[55,26,55,31],[55,32,55,37],[56,14,56,19],[56,20,56,25],[56,26,56,31],[56,32,56,37],[57,14,57,19],[57,20,57,25],[57,26,57,31],[57,32,57,37],[58,14,58,19],[58,20,58,25],[58,26,58,31],[58,32,58,37],[59,14,59,19],[59,20,59,25],[59,26,59,31],[59,32,59,37],[60,14,60,19],[60,20,60,25],[60,26,60,31],[60,32,60,37],[61,14,61,19],[61,20,61,25],[61,26,61,31],[61,32,61,37],[62,14,62,19],[62,20,62,25],[62,26,62,31],[62,32,62,37],[63,14,63,19],[63,20,63,25],[63,26,63,31],[63,32,63,37],[64,14,64,19],[64,20,64,25],[64,26,64,31],[64,32,64,37],[65,14,65,19],[65,20,65,25],[65,26,65,31],[65,32,65,37],[66,14,66,19],[66,20,66,25],[66,26,66,31],[66,32,66,37],[67,14,67,19],[67,20,67,25],[67,26,67,31],[67,32,67,37],[68,14,68,19],[68,20,68,25],[68,26,68,31],[68,32,68,37],[69,14,69,19],[69,20,69,25],[69,26,69,31],[69,32,69,37],[70,14,70,19],[70,20,70,25],[70,26,70,31],[70,32,70,37],[71,14,71,19],[71,20,71,25],[71,26,71,31],[71,32,71,37],[72,14,72,19],[72,20,72,25],[72,26,72,31],[72,32,72,37],[73,14,73,19],[73,20,73,25],[73,26,73,31],[73,32,73,37],[74,14,74,19],[74,20,74,25],[74,26,74,31],[74,32,74,37],[75,14,75,19],[75,20,75,25],[75,26,75,31],[75,32,75,37],[76,14,76,19],[76,20,76,25],[76,26,76,31],[76,32,76,37],[77,14,77,19],[77,20,77,25],[77,26,77,31],[77,32,77,37],[78,14,78,19],[78,20,78,25],[78,26,78,31],[78,32,78,37],[79,14,79,19],[79,20,79,25],[79,26,79,31],[79,32,79,37],[80,14,80,19],[80,20,80,25],[80,26,80,31],[80,32,80,37],[81,14,81,19],[81,20,81,25],[81,26,81,31],[81,32,81,37],[82,14,82,19],[82,20,82,25],[82,26,82,31],[82,32,82,37],[83,14,83,19],[83,20,83,25],[83,26,83,31],[83,32,83,37],[84,14,84,19],[84,20,84,25],[84,26,84,31],[84,32,84,37],[86,4,86,37],[89,1,89,37]]}
[]
[null,"Ⅳ. 현금흐름표"]
[]
[{"$nulls":9},"당기",null,"제",{"$f":"'5부.Ⅰ'!Q6","v":4},"기",null,"기말",null,null,"시작일",null,null,{"$f":"'5부.Ⅱ'!V4","v":"2021.06.01"},{"$nulls":3},"종료일",null,null,{"$f":"'5부.Ⅱ'!AC4","v":"2021.11.30"}]
[{"$nulls":9},"전기",null,"제",{"$f":"'5부.Ⅰ'!Q7","v":3},"기",null,"기말",null,null,"시작일",null,null,{"$f":"'5부.Ⅱ'!V5","v":"2020.12.01"},{"$nulls":3},"종료일",null,null,{"$f":"'5부.Ⅱ'!AC5","v":"2021.05.31"}]
[{"$nulls":3},"회사명:",null,null,{"$f":"표지!E28","v":"이에스알켄달스퀘어위탁관리부동산투자회사(주)"},{"$nulls":27},"(단위: 원)"]
[{"$nulls":3},"과 목",{"$nulls":14},"제",{"$f":"M4","v":4},"(당)기",{"$nulls":9},"제",{"$f":"M5","v":3},"(전)기"]
["코 드",{"$nulls":13},"금  액",{"$nulls":11},"금  액"]
["Q000000",null,null,"Ⅰ. 영업활동으로 인한 현금흐름",{"$nulls":16},{"$f":"U10+U11+U24+U47+U48+U49+U50","v":{"v":21427123689,"d":"21,427,123,689"}},{"$nulls":11},{"$f":"AG10+AG11+AG24+AG47+AG48+AG49+AG50","v":{"v":-5747606914,"d":"(5,747,606,914)"}}]
["Q000001",null,null," 1. 당기순이익(손실)",{"$nulls":16},{"v":18889201443,"d":"18,889,201,443"},{"$nulls":11},{"v":-496229966,"d":"(496,229,966)"}]
["R000000",null,null," 2. 당기순이익 조정을 위한 가감",{"$nulls":16},{"$f":"SUM(O12:T23)","v":{"v":-19320027951,"d":"(19,320,027,951)"}},{"$nulls":11},{"$f":"SUM(AA12:AF23)","v":{"v":-5016093608,"d":"(5,016,093,608)"}}]
["R000001",null,null,"법인세비용"]
["R000002",null,null,"이자수익",{"$nulls":10},{"v":-2006419,"d":"(2,006,419)"},{"$nulls":11},{"v":-48593779,"d":"(48,593,779)"}]
["R000003",null,null,"이자비용",{"$nulls":10},{"v":362301369,"d":"362,301,369"}]
["R000004",null,null,"감가상각비"]
["R000005",null,null,"유가증권관련손실(이익)",{"$nulls":10},{"v":-19680322901,"d":"(19,680,322,901)"},{"$nulls":11},{"v":-4307171829,"d":"(4,307,171,829)"}]
["R000006",null,null,"파생상품관련손실(이익)"]
["R000007",null,null,"유형자산관련손실(이익)"]
["R000008",null,null,"투자부동산관련손실(이익)"]
["R000009",null,null,"외화환산손실(이익)"]
["R000011",null,null,"금융리스이자비용"]
["R000012",null,null,"금융리스이자수익"]
["R000010",null,null,"기타",{"$nulls":22},{"v":-660328000,"d":"(660,328,000)"}]
["S000000",null,null," 3. 영업활동 관련 자산(부채)의 감소(증가)",{"$nulls":16},{"$f":"SUM(O25:T46)","v":{"v":33344670,"d":"33,344,670"}},{"$nulls":11},{"$f":"SUM(AA25:AF46)","v":{"v":-274236311,"d":"(274,236,311)"}}]
["S000001",null,null,"재고자산의 변동"]
["S000002",null,null,"금융상품의 변동"]
["S000003",null,null,"매출채권의 변동"]
["S000004",null,null,"투자부동산의 변동"]
["S000005",null,null,"미청구공사의 변동"]
["S000006",null,null,"미수수익의 변동"]
["S000007",null,null,"분양미수금의 변동"]
["S000008",null,null,"기타미수금의 변동"]
["S000009",null,null,"선급금의 변동"]
["S000010",null,null,"선급비용의 변동"]
["S000011",null,null,"매입채무의 변동"]
["S000012",null,null,"초과청구공사의 변동"]
["S000013",null,null,"분양선수금의 변동"]
["S000014",null,null,"기타선수금의 변동"]
["S000015",null,null,"선수수익의 변동"]
["S000016",null,null,"미지급금의 변동",{"$nulls":10},{"v":33344670,"d":"33,344,670"},{"$nulls":11},{"v":-274873711,"d":"(274,873,711)"}]
["S000017",null,null,"미지급비용의 변동"]
["S000018",null,null,"예수금의 변동",{"$nulls":22},{"v":637400,"d":"637,400"}]
["S000019",null,null,"보증금의 변동"]
["S000020",null,null,"퇴직금의 지급"]
["S000021",null,null,"사외적립자산(퇴직보험예치금)의 변동"]
["S000022",null,null,"기타"]
["T000000",null,null," 4. 배당금의 수취",{"$nulls":16},{"v":22930247568,"d":"22,930,247,568"},{"$nulls":11},{"v":112876,"d":"112,876"}]
["T000001",null,null," 5. 이자의 지급",{"$nulls":16},{"v":-191561643,"d":"(191,561,643)"}]
["T000002",null,null," 6. 이자의 수취",{"$nulls":16},{"v":4616242,"d":"4,616,242"},{"$nulls":11},{"v":44919785,"d":"44,919,785"}]
["T000003",null,null," 7. 법인세의 납부",{"$nulls":16},{"v":-918696640,"d":"(918,696,640)"},{"$nulls":11},{"v":-6079690,"d":"(6,079,690)"}]
["U000000",null,null,"Ⅱ. 투자활동으로 인한 현금흐름",{"$nulls":16},{"$f":"U52+U60","v":{"v":-28700000000,"d":"(28,700,000,000)"}},{"$nulls":11},{"$f":"AG52+AG60","v":{"v":-691787014736,"d":"(691,787,014,736)"}}]
["U000001",null,null," 1. 투자활동으로 인한 현금유입액",{"$nulls":16},{"$f":"SUM(O53:T59)","v":0},{"$nulls":11},{"$f":"SUM(AA53:AF59)","v":0}]
["U000002",null,null,"매도가능금융자산의 처분"]
["U000003",null,null,"만기보유금융자산의 처분"]
["U000004",null,null,"관계기업투자주식의 처분"]
["U000005",null,null,"종속기업투자주식 처분"]
["U000006",null,null,"유형자산의 처분"]
["U000007",null,null,"투자부동산의 처분"]
["U000008",null,null,"기타"]
["U000009",null,null," 2. 투자활동으로 인한 현금유출액",{"$nulls":16},{"$f":"-SUM(O61:T67)","v":{"v":-28700000000,"d":"(28,700,000,000)"}},{"$nulls":11},{"$f":"-SUM(AA61:AF67)","v":{"v":-691787014736,"d":"(691,787,014,736)"}}]
["U000010",null,null,"매도가능금융자산의 취득"]
["U000011",null,null,"만기보유금융자산의 취득"]
["U000012",null,null,"관계기업투자주식의 취득",{"$nulls":10},{"v":26200000000,"d":"26,200,000,000"},{"$nulls":11},{"v":158238014736,"d":"158,238,014,736"}]
["U000013",null,null,"종속기업투자주식의 취득",{"$nulls":10},{"v":2500000000,"d":"2,500,000,000"},{"$nulls":11},{"v":533549000000,"d":"533,549,000,000"}]
["U000014",null,null,"유형자산의 취득"]
["U000015",null,null,"투자부동산의 취득"]
["U000016",null,null,"기타"]
["V000000",null,null,"Ⅲ. 재무활동으로 인한 현금흐름",{"$nulls":16},{"$f":"U69+U75","v":{"v":689251402,"d":"689,251,402"}},{"$nulls":11},{"$f":"AG69+AG75","v":{"v":348025380910,"d":"348,025,380,910"}}]
["V000001",null,null," 1. 재무활동으로 인한 현금유입액",{"$nulls":16},{"$f":"SUM(O70:T74)","v":{"v":20000000000,"d":"20,000,000,000"}},{"$nulls":11},{"$f":"SUM(AA70:AF74)","v":{"v":357295000000,"d":"357,295,000,000"}}]
["V000002",null,null,"주식의 발행",{"$nulls":22},{"v":357295000000,"d":"357,295,000,000"}]
["V000003",null,null,"단기차입금의 차입"]
["V000004",null,null,"장기차입금의 차입",{"$nulls":10},{"v":20000000000,"d":"20,000,000,000"}]
["V000005",null,null,"사채의 발행"]
["V000006",null,null,"기타"]
["V000007",null,null," 2. 재무활동으로 인한 현금유출액",{"$nulls":16},{"$f":"-SUM(O76:T80)","v":{"v":-19310748598,"d":"(19,310,748,598)"}},{"$nulls":11},{"$f":"-SUM(AA76:AF80)","v":{"v":-9269619090,"d":"(9,269,619,090)"}}]
["V000008",null,null,"단기차입금의 상환"]
["V000009",null,null,"장기차입금의 상환"]
["V000010",null,null,"사채의 상환"]
["V000011",null,null,"배당금의 지급",{"$nulls":10},{"v":19263536138,"d":"19,263,536,138"}]
["V000012",null,null,"기타",{"$nulls":10},{"v":47212460,"d":"47,212,460"},{"$nulls":11},{"v":9269619090,"d":"9,269,619,090"}]
["W000000",null,null,"Ⅳ. 환율변동효과 반영전 현금및현금성자산의 증감",{"$nulls":16},{"$f":"U9+U51+U68","v":{"v":-6583624909,"d":"(6,583,624,909)"}},{"$nulls":11},{"$f":"AG9+AG51+AG68","v":{"v":-349509240740,"d":"(349,509,240,740)"}}]
["W000001",null,null,"Ⅴ. 현금및현금성자산에 대한 환율변동효과"]
["W000002",null,null,"Ⅵ. 현금및현금성자산의 순증감",{"$nulls":16},{"$f":"U81+U82","v":{"v":-6583624909,"d":"(6,583,624,909)"}},{"$nulls":11},{"$f":"AG81+AG82","v":{"v":-349509240740,"d":"(349,509,240,740)"}}]
["W000003",null,null,"Ⅶ. 기초 현금및현금성자산",{"$nulls":16},{"v":8289912266,"d":"8,289,912,266"},{"$nulls":11},{"v":357799153006,"d":"357,799,153,006"}]
["W000004",null,null,"Ⅷ. 기말 현금및현금성자산",{"$nulls":16},{"$f":"U83+U84","v":{"v":1706287357,"d":"1,706,287,357"}},{"$nulls":11},{"$f":"AG83+AG84","v":{"v":8289912266,"d":"8,289,912,266"}}]
[]
[{"$nulls":38},"← 필요시 주석 기재"]
[]
[]
[null,"* 입력도움말\n1. 계정과목은 수정하지 마시기 바랍니다.(일치하는 계정과목이 없는경우 해당 대분류 아래 '기타'에 입력)\n2. 해당하는 계정과목에만 금액을 입력하시고, 그외는 기재하지 마시기 바랍니다.\n3. 현금흐름표는 결산기에만 입력하시기 바랍니다.\n4. 이자의 지급, 법인세납부 등과 같이 음수인 계정과목은 숫자 앞에 '-'를 붙여 음수로 입력하시기 바랍니다.\n5. 표 왼쪽에 적혀있는 코드는 수정하지 마시기 바랍니다.\n"]

{"sheet":"5부.Ⅴ","index":34,"n_rows":24,"n_cols":39,"rows_kept":24,"merged":[[1,1,1,37],[3,21,3,23],[3,28,3,30],[4,21,4,23],[4,28,4,30],[5,34,5,36],[6,2,6,7],[6,8,6,11],[6,12,6,14],[6,15,6,18],[6,19,6,22],[6,23,6,26],[6,27,6,30],[6,31,6,33],[6,34,6,36],[7,2,7,7],[7,8,7,11],[7,12,7,14],[7,15,7,18],[7,19,7,22],[7,23,7,26],[7,27,7,30],[7,31,7,33],[7,34,7,36],[8,2,8,7],[8,8,8,11],[8,12,8,14],[8,15,8,18],[8,19,8,22],[8,23,8,26],[8,27,8,30],[8,31,8,33],[8,34,8,36],[9,2,9,7],[9,8,9,11],[9,12,9,14],[9,15,9,18],[9,19,9,22],[9,23,9,26],[9,27,9,30],[9,31,9,33],[9,34,9,36],[10,2,10,7],[10,8,10,11],[10,12,10,14],[10,15,10,18],[10,19,10,22],[10,23,10,26],[10,27,10,30],[10,31,10,33],[10,34,10,36],[11,2,11,7],[11,8,11,11],[11,12,11,14],[11,15,11,18],[11,19,11,22],[11,23,11,26],[11,27,11,30],[11,31,11,33],[11,34,11,36],[12,2,12,7],[12,8,12,11],[12,12,12,14],[12,15,12,18],[12,19,12,22],[12,23,12,26],[12,27,12,30],[12,31,12,33],[12,34,12,36],[13,2,13,7],[13,8,13,11],[13,12,13,14],[13,15,13,18],[13,19,13,22],[13,23,13,26],[13,27,13,30],[13,31,13,33],[13,34,13,36],[14,2,14,7],[14,8,14,11],[14,12,14,14],[14,15,14,18],[14,19,14,22],[14,23,14,26],[14,27,14,30],[14,31,14,33],[14,34,14,36],[15,2,15,7],[15,8,15,11],[15,12,15,14],[15,15,15,18],[15,19,15,22],[15,23,15,26],[15,27,15,30],[15,31,15,33],[15,34,15,36],[16,2,16,7],[16,8,16,11],[16,12,16,14],[16,15,16,18],[16,19,16,22],[16,23,16,26],[16,27,16,30],[16,31,16,33],[16,34,16,36],[17,2,17,7],[17,8,17,11],[17,12,17,14],[17,15,17,18],[17,19,17,22],[17,23,17,26],[17,27,17,30],[17,31,17,33],[17,34,17,36],[18,2,18,7],[18,8,18,11],[18,12,18,14],[18,15,18,18],[18,19,18,22],[18,23,18,26],[18,27,18,30],[18,31,18,33],[18,34,18,36],[20,4,20,37],[23,1,23,36]]}
[]
[null,"Ⅴ. 자본변동표"]
[]
[{"$nulls":9},"당기",null,"제",{"$f":"'5부.Ⅱ'!M4","v":4},"기",null,"기말",null,null,"시작일",null,null,{"$f":"'5부.Ⅱ'!V4","v":"2021.06.01"},{"$nulls":3},"종료일",null,null,{"$f":"'5부.Ⅱ'!AC4","v":"2021.11.30"}]
[{"$nulls":9},"전기",null,"제",{"$f":"'5부.Ⅱ'!M5","v":3},"기",null,"기말",null,null,"시작일",null,null,{"$f":"'5부.Ⅱ'!V5","v":"2020.12.01"},{"$nulls":3},"종료일",null,null,{"$f":"'5부.Ⅱ'!AC5","v":"2021.05.31"}]
[{"$nulls":3},"회사명:",null,null,{"$f":"표지!E28","v":"이에스알켄달스퀘어위탁관리부동산투자회사(주)"},{"$nulls":27},"(단위: 원)"]
[null,null,"구 분",{"$nulls":5},"자본금",{"$nulls":3},"자본잉여금",null,null,"자본조정",{"$nulls":3},"기타포괄\n손익누계액",{"$nulls":3},"이익잉여금",{"$nulls":3},"기타",{"$nulls":3},"비지배지분",null,null,"총계"]
[null,null,"전기 초(2020-12-01)",{"$nulls":5},{"v":48200000000,"d":"48,200,000,000"},{"$nulls":3},{"v":192541961760,"d":"192,541,961,760"},null,null,0,{"$nulls":3},0,{"$nulls":3},{"v":-1446625965,"d":"-1,446,625,965"},{"$nulls":10},{"v":239295335795,"d":"239,295,335,795"}]
[null,null,"유상증자(보통주)",{"$nulls":5},{"v":71459000000,"d":"71,459,000,000"},{"$nulls":3},{"v":277064431350,"d":"277,064,431,350"},null,null,0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":10},{"v":348523431350,"d":"348,523,431,350"}]
[null,null,"전환사채의 전환",{"$nulls":5},{"v":23600000000,"d":"23,600,000,000"},{"$nulls":3},{"v":93901949560,"d":"93,901,949,560"},null,null,0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":10},{"v":117501949560,"d":"117,501,949,560"}]
[null,null,"결손보전",{"$nulls":9},{"v":-21658000000,"d":"-21,658,000,000"},null,null,0,{"$nulls":3},0,{"$nulls":3},{"v":21658000000,"d":"21,658,000,000"},{"$nulls":10},0]
[null,null,"당기순이익",{"$nulls":5},0,{"$nulls":3},0,null,null,0,{"$nulls":3},0,{"$nulls":3},{"v":-496229966,"d":"-496,229,966"},{"$nulls":10},{"v":-496229966,"d":"-496,229,966"}]
[null,null,"전기 말(2021-05-31)",{"$nulls":5},{"v":143259000000,"d":"143,259,000,000"},{"$nulls":3},{"v":541850342670,"d":"541,850,342,670"},null,null,0,{"$nulls":3},0,{"$nulls":3},{"v":19715144069,"d":"19,715,144,069"},{"$nulls":10},{"v":704824486739,"d":"704,824,486,739"}]
[null,null,"당기 초(2021-06-01)",{"$nulls":5},{"v":143259000000,"d":"143,259,000,000"},{"$nulls":3},{"v":541850342670,"d":"541,850,342,670"},null,null,0,{"$nulls":3},0,{"$nulls":3},{"v":19715144069,"d":"19,715,144,069"},{"$nulls":10},{"v":704824486739,"d":"704,824,486,739"}]
[null,null,"기타불입자본 이입액",{"$nulls":5},0,{"$nulls":3},{"v":-700000000,"d":"-700,000,000"},null,null,0,{"$nulls":3},0,{"$nulls":3},{"v":700000000,"d":"700,000,000"},{"$nulls":10},0]
[null,null,"신주발행비용",{"$nulls":5},0,{"$nulls":3},{"v":-47212460,"d":"-47,212,460"},null,null,0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":10},{"v":-47212460,"d":"-47,212,460"}]
[null,null,"배당",{"$nulls":5},0,{"$nulls":3},0,null,null,0,{"$nulls":3},0,{"$nulls":3},{"v":-19263536138,"d":"-19,263,536,138"},{"$nulls":10},{"v":-19263536138,"d":"-19,263,536,138"}]
[null,null,"당기순이익",{"$nulls":5},0,{"$nulls":3},0,null,null,0,{"$nulls":3},0,{"$nulls":3},{"v":18889201443,"d":"18,889,201,443"},{"$nulls":10},{"v":18889201443,"d":"18,889,201,443"}]
[null,null,"당기 말(2021-11-30)",{"$nulls":5},{"v":143259000000,"d":"143,259,000,000"},{"$nulls":3},{"v":541103130210,"d":"541,103,130,210"},null,null,0,{"$nulls":3},0,{"$nulls":3},{"v":20040809374,"d":"20,040,809,374"},{"$nulls":10},{"v":704402939584,"d":"704,402,939,584"}]
[]
[{"$nulls":38},"← 필요시 주석 기재"]
[]
[]
[null,"* 입력도움말\n1. 필요시 행추가(복사한 셀 삽입)하여 추가 작성하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n"]

{"sheet":"5부.Ⅵ","index":35,"n_rows":13,"n_cols":3,"rows_kept":13,"merged":[[1,1,1,37],[3,2,8,35],[12,0,12,36]]}
[]
[null,"Ⅵ. 재무제표에 대한 주석(차입에 관한 구체적인 사항을 포함)"]
[]
[null,null,"주석은 투자보고서 마지막에 별첨합니다."]
{"$rows_empty":8}
["* 입력도움말\n1. 주석은 별도의 PDF 파일로 업로드 해 주세요.\n"]

{"sheet":"5부.Ⅶ","index":36,"n_rows":35,"n_cols":9,"rows_kept":35,"merged":[[1,1,1,37],[3,1,3,36],[5,8,5,13],[7,2,15,35],[18,1,18,36],[20,8,20,13],[22,2,30,35],[34,0,34,36]]}
[]
[null,"Ⅶ. 감사인의 감사(검토) 의견"]
[]
[null,"- 외부감사인의 감사(검토) 의견 및 위반사항"]
[]
[null,null,"감사(검토)의견 :",{"$nulls":5},"적정"]
[null,null,"기타사항(특기사항 포함)"]
{"$rows_empty":11}
[null,"- 내부감사인의 감사(검토) 의견"]
[]
[null,null,"감사(검토)의견 :",{"$nulls":5},"적정"]
[null,null,"기타사항(특기사항 포함)"]
{"$rows_empty":12}
["* 입력도움말\n1. 외부감사인의 감사(검토)의견란에는 \"적정, 부적정, 한정, 의견거절, 해당사항 없음(분기 등 해당기간 아닌경우)\" 중 해당되는\n    사항을 선택해 주시기 바랍니다.\n2. 기타사항(특기사항 포함) 내용이 입력범위를 초과하는 경우 셀 높이를 조절하시기 바랍니다."]

{"sheet":"6부.Ⅰ","index":37,"n_rows":11,"n_cols":1,"rows_kept":11,"merged":[[1,0,1,36],[3,0,3,36],[5,2,7,36],[10,0,10,36]]}
[]
["제 6 부 중요한 소송등 진행 현황"]
[]
["Ⅰ. 중요한 소송진행사항"]
[]
[]
[]
[]
[]
[]
["* 입력도움말\n1. 입력범위를 초과하는 경우 셀 높이를 조절하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다.\n3. 해당 기에 소송이 진행 중인 경우 초기 진행사항부터 기재하시기 바랍니다."]

{"sheet":"7부.Ⅰ","index":38,"n_rows":12,"n_cols":5,"rows_kept":12,"merged":[[1,0,1,36],[3,0,3,36],[5,2,7,36],[8,4,8,36],[11,0,11,36]]}
[]
["제 7 부 특별관계자 등과의 거래 현황"]
[]
["Ⅰ. 거래현황"]
[]
[null,null,"주석22. 특수관계자 거래 참고"]
[]
[]
[{"$nulls":4},"※ 특별관계자 등은 다음에 해당하는 자를 말함 \n  1. 해당 부동산투자회사의 임직원 및 그 특별관계자\n  2. 해당 부동산투자회사의 주식을 100분의 10 이상 소유하고 있는 주주 및 그 특별관계자\n※ 특별관계자는 자본시장법 시행령 제141조제1항의 특수관계인 및 공동보유자를 말함\n※ 특별관계자 등과의 거래는 법 제30조제2항 각 호에 해당하는 거래를 말함"]
[]
[]
["* 입력도움말\n1. 입력범위를 초과하는 경우 셀 높이를 조절하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다."]

{"sheet":"8부.Ⅰ","index":39,"n_rows":11,"n_cols":1,"rows_kept":11,"merged":[[1,0,1,36],[3,0,3,36],[5,2,7,36],[10,0,10,36]]}
[]
["제 8 부 기타사항"]
[]
["Ⅰ. 제재현황"]
[]
[]
[]
[]
[]
[]
["* 입력도움말\n1. 입력범위를 초과하는 경우 셀 높이를 조절하시기 바랍니다.\n2. 해당사항 없는 항목은 기재하지 마시기 바랍니다."]