{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["12개월 현금 흐름","현금 흐름 요약"],"not_rendered":{"charts":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"12개월 현금 흐름","index":0,"n_rows":41,"n_cols":16,"rows_kept":41,"merged":[[7,0,7,15],[11,0,11,15],[17,0,17,15],[33,0,33,15]]}
[]
["12개월 현금 흐름",{"$nulls":13},"회계 연도 시작:","2013-07-01"]
["회사 이름"]
["시/도, 구/군/시, 주소, 우편 번호"]
["전화, 전자 메일, 웹"]
[]
[null,"초기",{"$f":"회계_연도","v":"2013-07-01"},{"$f":"DATE(YEAR(C7),MONTH(C7)+1,1)","v":"2013-08-01"},{"$f":"DATE(YEAR(D7),MONTH(D7)+1,1)","v":"2013-09-01"},"2013-10-01","2013-11-01","2013-12-01","2014-01-01","2014-02-01","2014-03-01","2014-04-01","2014-05-01","2014-06-01","월 평균","개요"]
["현금 요약"]
["보유 현금\n(월초)",{"v":55000000,"d":"55,000,000"},{"$f":"IF(영수증[[#Totals],[Column3]]+지출[[#Totals],[Column3]]=0,\"\",B11)","v":{"v":67593000,"d":"67,593,000"}},{"$f":"IF(영수증[[#Totals],[Column4]]+지출[[#Totals],[Column4]]=0,\"\",C11)","v":{"v":54265000,"d":"54,265,000"}},{"$f":"IF(영수증[[#Totals],[Column5]]+지출[[#Totals],[Column5]]=0,\"\",D11)","v":{"v":55739000,"d":"55,739,000"}},{"$f":"IF(영수증[[#Totals],[Column6]]+지출[[#Totals],[Column6]]=0,\"\",E11)","v":{"v":69290000,"d":"69,290,000"}},{"$f":"IF(영수증[[#Totals],[Column7]]+지출[[#Totals],[Column7]]=0,\"\",F11)","v":{"v":65618000,"d":"65,618,000"}},{"$f":"IF(영수증[[#Totals],[Column8]]+지출[[#Totals],[Column8]]=0,\"\",G11)","v":""},{"$f":"IF(영수증[[#Totals],[Column9]]+지출[[#Totals],[Column9]]=0,\"\",H11)","v":""},{"$f":"IF(영수증[[#Totals],[Column10]]+지출[[#Totals],[Column10]]=0,\"\",I11)","v":""},{"$f":"IF(영수증[[#Totals],[Column11]]+지출[[#Totals],[Column11]]=0,\"\",J11)","v":""},{"$f":"IF(영수증[[#Totals],[Column12]]+지출[[#Totals],[Column12]]=0,\"\",K11)","v":""},{"$f":"IF(영수증[[#Totals],[Column13]]+지출[[#Totals],[Column13]]=0,\"\",L11)","v":""},{"$f":"IF(영수증[[#Totals],[Column14]]+지출[[#Totals],[Column14]]=0,\"\",M11)","v":""},{"$f":"IFERROR(AVERAGE(요약[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":62501000,"d":"62,501,000"}}]
["사용 가능 현금\n(보유 + 수입, 지출) ",{"$f":"SUM(B9,영수증[[#Totals],[Column2]])","v":{"v":67593000,"d":"67,593,000"}},{"$f":"IF(C9=\"\",\"\",SUM(C9,영수증[[#Totals],[Column3]]))","v":{"v":76065000,"d":"76,065,000"}},{"$f":"IF(D9=\"\",\"\",SUM(D9,영수증[[#Totals],[Column4]]))","v":{"v":83301000,"d":"83,301,000"}},{"$f":"IF(E9=\"\",\"\",SUM(E9,영수증[[#Totals],[Column5]]))","v":{"v":91032000,"d":"91,032,000"}},{"$f":"IF(F9=\"\",\"\",SUM(F9,영수증[[#Totals],[Column6]]))","v":{"v":89662000,"d":"89,662,000"}},{"$f":"IF(G9=\"\",\"\",SUM(G9,영수증[[#Totals],[Column7]]))","v":{"v":76200000,"d":"76,200,000"}},{"$f":"IF(H9=\"\",\"\",SUM(H9,영수증[[#Totals],[Column8]]))","v":""},{"$f":"IF(I9=\"\",\"\",SUM(I9,영수증[[#Totals],[Column9]]))","v":""},{"$f":"IF(J9=\"\",\"\",SUM(J9,영수증[[#Totals],[Column10]]))","v":""},{"$f":"IF(K9=\"\",\"\",SUM(K9,영수증[[#Totals],[Column11]]))","v":""},{"$f":"IF(L9=\"\",\"\",SUM(L9,영수증[[#Totals],[Column12]]))","v":""},{"$f":"IF(M9=\"\",\"\",SUM(M9,영수증[[#Totals],[Column13]]))","v":""},{"$f":"IF(N9=\"\",\"\",SUM(N9,영수증[[#Totals],[Column14]]))","v":""},{"$f":"IFERROR(AVERAGE(요약[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":83252000,"d":"83,252,000"}}]
["현금 유동성\n(월말)",{"$f":"(B10-지출[[#Totals],[Column2]])","v":{"v":67593000,"d":"67,593,000"}},{"$f":"IFERROR(C10-지출[[#Totals],[Column3]],\"\")","v":{"v":54265000,"d":"54,265,000"}},{"$f":"IFERROR(D10-지출[[#Totals],[Column4]],\"\")","v":{"v":55739000,"d":"55,739,000"}},{"$f":"IFERROR(E10-지출[[#Totals],[Column5]],\"\")","v":{"v":69290000,"d":"69,290,000"}},{"$f":"IFERROR(F10-지출[[#Totals],[Column6]],\"\")","v":{"v":65618000,"d":"65,618,000"}},{"$f":"IFERROR(G10-지출[[#Totals],[Column7]],\"\")","v":{"v":51413000,"d":"51,413,000"}},{"$f":"IFERROR(H10-지출[[#Totals],[Column8]],\"\")","v":""},{"$f":"IFERROR(I10-지출[[#Totals],[Column9]],\"\")","v":""},{"$f":"IFERROR(J10-지출[[#Totals],[Column10]],\"\")","v":""},{"$f":"IFERROR(K10-지출[[#Totals],[Column11]],\"\")","v":""},{"$f":"IFERROR(L10-지출[[#Totals],[Column12]],\"\")","v":""},{"$f":"IFERROR(M10-지출[[#Totals],[Column13]],\"\")","v":""},{"$f":"IFERROR(N10-지출[[#Totals],[Column14]],\"\")","v":""},{"$f":"IFERROR(AVERAGE(요약[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":59265000,"d":"59,265,000"}}]
[]
["현금 수입"]
["현금 판매",{"v":5616000,"d":"5,616,000"},{"v":3889000,"d":"3,889,000"},{"v":24411000,"d":"24,411,000"},{"v":31642000,"d":"31,642,000"},{"v":14647000,"d":"14,647,000"},{"v":3034000,"d":"3,034,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(영수증[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":15524600,"d":"15,524,600"}}]
["CR 계정에서 모은 금액",{"v":4498000,"d":"4,498,000"},{"v":3493000,"d":"3,493,000"},{"v":1987000,"d":"1,987,000"},{"v":1029000,"d":"1,029,000"},{"v":2911000,"d":"2,911,000"},{"v":4234000,"d":"4,234,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(영수증[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":2730800,"d":"2,730,800"}}]
["대출/기타 현금",{"v":2479000,"d":"2,479,000"},{"v":1090000,"d":"1,090,000"},{"v":2638000,"d":"2,638,000"},{"v":2622000,"d":"2,622,000"},{"v":2814000,"d":"2,814,000"},{"v":3314000,"d":"3,314,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(영수증[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":2495600,"d":"2,495,600"}}]
["총 현금 수입",{"$f":"SUBTOTAL(109,영수증[Column2])","v":{"v":12593000,"d":"12,593,000"}},{"$f":"SUBTOTAL(109,영수증[Column3])","v":{"v":8472000,"d":"8,472,000"}},{"$f":"SUBTOTAL(109,영수증[Column4])","v":{"v":29036000,"d":"29,036,000"}},{"$f":"SUBTOTAL(109,영수증[Column5])","v":{"v":35293000,"d":"35,293,000"}},{"$f":"SUBTOTAL(109,영수증[Column6])","v":{"v":20372000,"d":"20,372,000"}},{"$f":"SUBTOTAL(109,영수증[Column7])","v":{"v":10582000,"d":"10,582,000"}},{"$f":"SUBTOTAL(109,영수증[Column8])","v":0},{"$f":"SUBTOTAL(109,영수증[Column9])","v":0},{"$f":"SUBTOTAL(109,영수증[Column10])","v":0},{"$f":"SUBTOTAL(109,영수증[Column11])","v":0},{"$f":"SUBTOTAL(109,영수증[Column12])","v":0},{"$f":"SUBTOTAL(109,영수증[Column13])","v":0},{"$f":"SUBTOTAL(109,영수증[Column14])","v":0},{"$f":"IFERROR(AVERAGE(영수증[[#Totals],[Column3]:[Column14]]),\"\")","v":{"v":8646250,"d":"8,646,250"}}]
[]
["현금 지출"]
["구매(지정)",null,{"v":521000,"d":"521,000"},{"v":323000,"d":"323,000"},{"v":274000,"d":"274,000"},{"v":451000,"d":"451,000"},{"v":104000,"d":"104,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":334600,"d":"334,600"}}]
["총 급여(정확한 인출액)",null,{"v":10572000,"d":"10,572,000"},{"v":14514000,"d":"14,514,000"},{"v":10561000,"d":"10,561,000"},{"v":13170000,"d":"13,170,000"},{"v":12478000,"d":"12,478,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":12259000,"d":"12,259,000"}}]
["소모품(사무실 및 운영)",null,{"v":250000,"d":"250,000"},{"v":428000,"d":"428,000"},{"v":165000,"d":"165,000"},{"v":1168000,"d":"1,168,000"},{"v":345000,"d":"345,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":471200,"d":"471,200"}}]
["수리 및 유지 관리",null,0,{"v":2200000,"d":"2,200,000"},{"v":163000,"d":"163,000"},{"v":67000,"d":"67,000"},0,{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":486000,"d":"486,000"}}]
["광고",null,{"v":1100000,"d":"1,100,000"},{"v":625000,"d":"625,000"},{"v":1356000,"d":"1,356,000"},0,{"v":2560000,"d":"2,560,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":1128200,"d":"1,128,200"}}]
["임대",null,{"v":3500000,"d":"3,500,000"},{"v":3500000,"d":"3,500,000"},{"v":3500000,"d":"3,500,000"},{"v":3500000,"d":"3,500,000"},{"v":3500000,"d":"3,500,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":3500000,"d":"3,500,000"}}]
["전기, 가스, 수도",null,{"v":285000,"d":"285,000"},{"v":318000,"d":"318,000"},{"v":151000,"d":"151,000"},{"v":134000,"d":"134,000"},{"v":228000,"d":"228,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":223200,"d":"223,200"}}]
["기타(지정)",null,{"v":123000,"d":"123,000"},{"v":234000,"d":"234,000"},{"v":123000,"d":"123,000"},{"v":234000,"d":"234,000"},{"v":123000,"d":"123,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":167400,"d":"167,400"}}]
["주요 융자 상환금",null,{"v":4000000,"d":"4,000,000"},{"v":4000000,"d":"4,000,000"},{"v":4000000,"d":"4,000,000"},{"v":4000000,"d":"4,000,000"},{"v":4000000,"d":"4,000,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":4000000,"d":"4,000,000"}}]
["자본 구매(지정)",null,{"v":679000,"d":"679,000"},{"v":700000,"d":"700,000"},{"v":679000,"d":"679,000"},{"v":650000,"d":"650,000"},{"v":679000,"d":"679,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":677400,"d":"677,400"}}]
["기타 시작 비용",null,{"v":400000,"d":"400,000"},{"v":350000,"d":"350,000"},{"v":400000,"d":"400,000"},{"v":300000,"d":"300,000"},{"v":400000,"d":"400,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":370000,"d":"370,000"}}]
["은행 예탁",null,{"v":300000,"d":"300,000"},{"v":300000,"d":"300,000"},{"v":300000,"d":"300,000"},{"v":300000,"d":"300,000"},{"v":300000,"d":"300,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":300000,"d":"300,000"}}]
["소유주 인출",null,{"v":70000,"d":"70,000"},{"v":70000,"d":"70,000"},{"v":70000,"d":"70,000"},{"v":70000,"d":"70,000"},{"v":70000,"d":"70,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(지출[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":70000,"d":"70,000"}}]
["총 현금 지출",null,{"$f":"SUBTOTAL(109,지출[Column3])","v":{"v":21800000,"d":"21,800,000"}},{"$f":"SUBTOTAL(109,지출[Column4])","v":{"v":27562000,"d":"27,562,000"}},{"$f":"SUBTOTAL(109,지출[Column5])","v":{"v":21742000,"d":"21,742,000"}},{"$f":"SUBTOTAL(109,지출[Column6])","v":{"v":24044000,"d":"24,044,000"}},{"$f":"SUBTOTAL(109,지출[Column7])","v":{"v":24787000,"d":"24,787,000"}},{"$f":"SUBTOTAL(109,지출[Column8])","v":0},{"$f":"SUBTOTAL(109,지출[Column9])","v":0},{"$f":"SUBTOTAL(109,지출[Column10])","v":0},{"$f":"SUBTOTAL(109,지출[Column11])","v":0},{"$f":"SUBTOTAL(109,지출[Column12])","v":0},{"$f":"SUBTOTAL(109,지출[Column13])","v":0},{"$f":"SUBTOTAL(109,지출[Column14])","v":0},{"$f":"IFERROR(AVERAGE(지출[[#Totals],[Column3]:[Column14]]),\"\")","v":{"v":9994583.333333334,"d":"9,994,583"}}]
[]
["필수 운영 데이터(현금 외 흐름 정보)"]
["판매액(원)",{"v":2000000,"d":"2,000,000"},{"v":2500000,"d":"2,500,000"},{"v":2257000,"d":"2,257,000"},{"v":2387000,"d":"2,387,000"},{"v":2664000,"d":"2,664,000"},{"v":2324000,"d":"2,324,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(필수_운영_데이터[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":2355333.3333333335,"d":"2,355,333"}}]
["외상 매출금",{"v":1500000,"d":"1,500,000"},{"v":500000,"d":"500,000"},{"v":886000,"d":"886,000"},{"v":1035000,"d":"1,035,000"},{"v":1775000,"d":"1,775,000"},{"v":839000,"d":"839,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(필수_운영_데이터[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":1089166.6666666667,"d":"1,089,167"}}]
["악성 부채(월말)",{"v":300000,"d":"300,000"},{"v":200000,"d":"200,000"},{"v":225000,"d":"225,000"},{"v":269000,"d":"269,000"},{"v":448000,"d":"448,000"},{"v":359000,"d":"359,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(필수_운영_데이터[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":300166.6666666667,"d":"300,167"}}]
["재고 정리 자산(월말)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(필수_운영_데이터[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["외상 매입금(월말)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(필수_운영_데이터[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["감가 상각",{"$nulls":13},{"$f":"IFERROR(AVERAGE(필수_운영_데이터[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]

{"sheet":"현금 흐름 요약","index":1,"n_rows":27,"n_cols":11,"rows_kept":27}
{"$rows_empty":25}
[{"$nulls":9},"데이터 요소:",5]
[null,null,"차트로 된 전체 데이터 요소를 변경하려면 위의 슬라이더를 끕니다."]