{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["현금 흐름표"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"현금 흐름표","index":0,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[13,1,13,18],[37,1,37,18],[46,1,46,18]]}
[null,"현금 흐름표"]
[]
[null,"회계연도 시작:",null,"시작 (전)",{"$f":"UPPER(TEXT(FiscalYearStartDate,\"m 월\"))","v":"1 월"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,1),\"m 월\"))","v":"2 월"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,2),\"m 월\"))","v":"3 월"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,3),\"m 월\"))","v":"4 월"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,4),\"m 월\"))","v":"5 월"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,5),\"m 월\"))","v":"6 월"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,6),\"m 월\"))","v":"7 월"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,7),\"m 월\"))","v":"8 월"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,8),\"m 월\"))","v":"9 월"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,9),\"m 월\"))","v":"10 월"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,10),\"m 월\"))","v":"11 월"},{"$f":"UPPER(TEXT(EOMONTH(FiscalYearStartDate,11),\"m 월\"))","v":"12 월"},null,"합계"]
[null,"2012-01-05",null,"추산",{"$f":"FiscalYearStartDate","v":"2012-01-05"},{"$f":"EOMONTH(E4,0)+DAY(FiscalYearStartDate)","v":"2012-02-05"},{"$f":"EOMONTH(F4,0)+DAY(FiscalYearStartDate)","v":"2012-03-05"},{"$f":"EOMONTH(G4,0)+DAY(FiscalYearStartDate)","v":"2012-04-05"},{"$f":"EOMONTH(H4,0)+DAY(FiscalYearStartDate)","v":"2012-05-05"},{"$f":"EOMONTH(I4,0)+DAY(FiscalYearStartDate)","v":"2012-06-05"},{"$f":"EOMONTH(J4,0)+DAY(FiscalYearStartDate)","v":"2012-07-05"},{"$f":"EOMONTH(K4,0)+DAY(FiscalYearStartDate)","v":"2012-08-05"},{"$f":"EOMONTH(L4,0)+DAY(FiscalYearStartDate)","v":"2012-09-05"},{"$f":"EOMONTH(M4,0)+DAY(FiscalYearStartDate)","v":"2012-10-05"},{"$f":"EOMONTH(N4,0)+DAY(FiscalYearStartDate)","v":"2012-11-05"},{"$f":"EOMONTH(O4,0)+DAY(FiscalYearStartDate)","v":"2012-12-05"},null,"항목 추산"]
[]
[null,"보유 현금(월초)",null,10000,{"$f":"D48","v":10000},{"$f":"E48","v":-12500},4500,-100,22400,26900,26900,26900,26900,26900,26900,26900,null,{"$f":"P6","v":26900}]
[]
[null,"현금 수입"]
[null,"현금 판매",null,null,12500,12000,13000,10000,{"$nulls":9},{"$f":"SUM(현금_수입[[#This Row],[Period 0]:[Period 12]])","v":47500}]
[null,"CR 계정 징수",{"$nulls":5},7500,4500,{"$nulls":8},{"$f":"SUM(현금_수입[[#This Row],[Period 0]:[Period 12]])","v":12000}]
[null,"대출/기타 현금 유입",null,null,5000,5000,5000,5000,{"$nulls":9},{"$f":"SUM(현금_수입[[#This Row],[Period 0]:[Period 12]])","v":20000}]
[null,"합계",null,{"$f":"SUBTOTAL(109,현금_수입[Period 0])","v":0},{"$f":"SUBTOTAL(109,현금_수입[Period 1])","v":17500},{"$f":"SUBTOTAL(109,현금_수입[Period 2])","v":17000},{"$f":"SUBTOTAL(109,현금_수입[Period 3])","v":18000},{"$f":"SUBTOTAL(109,현금_수입[Period 4])","v":22500},{"$f":"SUBTOTAL(109,현금_수입[Period 5])","v":4500},{"$f":"SUBTOTAL(109,현금_수입[Period 6])","v":0},{"$f":"SUBTOTAL(109,현금_수입[Period 7])","v":0},{"$f":"SUBTOTAL(109,현금_수입[Period 8])","v":0},{"$f":"SUBTOTAL(109,현금_수입[Period 9])","v":0},{"$f":"SUBTOTAL(109,현금_수입[Period 10])","v":0},{"$f":"SUBTOTAL(109,현금_수입[Period 11])","v":0},{"$f":"SUBTOTAL(109,현금_수입[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,현금_수입[Total])","v":79500}]
[null,"총 보유 현금(출금 전)",null,{"$f":"D6+SUM(현금_수입[Period 0])","v":10000},{"$f":"E6+SUM(현금_수입[Period 1])","v":27500},{"$f":"F6+SUM(현금_수입[Period 2])","v":4500},{"$f":"G6+SUM(현금_수입[Period 3])","v":22500},{"$f":"H6+SUM(현금_수입[Period 4])","v":22400},{"$f":"I6+SUM(현금_수입[Period 5])","v":26900},{"$f":"J6+SUM(현금_수입[Period 6])","v":26900},{"$f":"K6+SUM(현금_수입[Period 7])","v":26900},{"$f":"L6+SUM(현금_수입[Period 8])","v":26900},{"$f":"M6+SUM(현금_수입[Period 9])","v":26900},{"$f":"N6+SUM(현금_수입[Period 10])","v":26900},{"$f":"O6+SUM(현금_수입[Period 11])","v":26900},{"$f":"P6+SUM(현금_수입[Period 12])","v":26900},null,{"$f":"R6+SUM(현금_수입[Total])","v":106400}]
[]
[null,"현금 지출"]
[null,"구매(상품화)",null,null,40000,null,22600,{"$nulls":10},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":62600}]
[null,"구매(지정)",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"구매(지정)",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"총 급여(정확한 인출액)",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"급료(세금 등)",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"외부 서비스",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"소모품(사무실/운영)",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"수리 및 유지 관리",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"광고",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"교통, 운송 및 출장",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"회계 및 법적 비용",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"임대",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"전화",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"가스, 수도, 전기",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"보험",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"세금(부동산 취득세 등)",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"이자",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"기타 비용(지정)",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"기타(지정)",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"기타(지정)",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"기타",{"$nulls":15},{"$f":"SUM(현금_지출[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"합계",null,{"$f":"SUBTOTAL(109,현금_지출[Period 0])","v":0},{"$f":"SUBTOTAL(109,현금_지출[Period 1])","v":40000},{"$f":"SUBTOTAL(109,현금_지출[Period 2])","v":0},{"$f":"SUBTOTAL(109,현금_지출[Period 3])","v":22600},{"$f":"SUBTOTAL(109,현금_지출[Period 4])","v":0},{"$f":"SUBTOTAL(109,현금_지출[Period 5])","v":0},{"$f":"SUBTOTAL(109,현금_지출[Period 6])","v":0},{"$f":"SUBTOTAL(109,현금_지출[Period 7])","v":0},{"$f":"SUBTOTAL(109,현금_지출[Period 8])","v":0},{"$f":"SUBTOTAL(109,현금_지출[Period 9])","v":0},{"$f":"SUBTOTAL(109,현금_지출[Period 10])","v":0},{"$f":"SUBTOTAL(109,현금_지출[Period 11])","v":0},{"$f":"SUBTOTAL(109,현금_지출[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,현금_지출[Total])","v":62600}]
[]
[null,"현금 지출(손익 외)"]
[null,"주요 융자 상환금",{"$nulls":15},{"$f":"SUM(현금_지출2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"자본 구매(지정)",{"$nulls":15},{"$f":"SUM(현금_지출2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"기타 시작 비용",{"$nulls":15},{"$f":"SUM(현금_지출2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"예비 및/또는 에스크로",{"$nulls":15},{"$f":"SUM(현금_지출2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"소유자 인출",{"$nulls":15},{"$f":"SUM(현금_지출2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"합계",null,{"$f":"SUBTOTAL(109,현금_지출2[Period 0])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 1])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 2])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 3])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 4])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 5])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 6])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 7])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 8])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 9])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 10])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 11])","v":0},{"$f":"SUBTOTAL(109,현금_지출2[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,현금_지출2[Total])","v":0}]
[null,"총 현금 지출",null,{"$f":"SUM(현금_지출[Period 0],현금_지출2[Period 0])","v":0},{"$f":"SUM(현금_지출[Period 1],현금_지출2[Period 1])","v":40000},{"$f":"SUM(현금_지출[Period 2],현금_지출2[Period 2])","v":0},{"$f":"SUM(현금_지출[Period 3],현금_지출2[Period 3])","v":22600},{"$f":"SUM(현금_지출[Period 4],현금_지출2[Period 4])","v":0},{"$f":"SUM(현금_지출[Period 5],현금_지출2[Period 5])","v":0},{"$f":"SUM(현금_지출[Period 6],현금_지출2[Period 6])","v":0},{"$f":"SUM(현금_지출[Period 7],현금_지출2[Period 7])","v":0},{"$f":"SUM(현금_지출[Period 8],현금_지출2[Period 8])","v":0},{"$f":"SUM(현금_지출[Period 9],현금_지출2[Period 9])","v":0},{"$f":"SUM(현금_지출[Period 10],현금_지출2[Period 10])","v":0},{"$f":"SUM(현금_지출[Period 11],현금_지출2[Period 11])","v":0},{"$f":"SUM(현금_지출[Period 12],현금_지출2[Period 12])","v":0},null,{"$f":"SUM(현금_지출[Total],현금_지출2[Total])","v":62600}]
[]
[null,"현금 현황(월말)",null,{"$f":"D13-D46","v":10000},-12500,4500,-100,22400,26900,26900,26900,26900,26900,26900,26900,26900,null,{"$f":"R13-R46","v":43800}]