{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["시나리오 요약","무작정따라하기","기출01","시나리오 요약 2","시나리오 요약 3","기출02"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"시나리오 요약","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"시나리오 요약"]
[null,null,null,"현재 값:","수익률증가","수익률감소"]
[null,null,null,null,"만든 사람 englishysh@gmail.com 날짜 6/5/2026","만든 사람 englishysh@gmail.com 날짜 6/5/2026"]
[null,"변경 셀:"]
[null,null,"A반품수량",19,9,29]
[null,null,"B반품수량",31,21,41]
[null,"결과 셀:"]
[null,null,"매출액합계",6693900,6754900,6632900]
[null,"참고: 현재 값 열은 시나리오 요약 보고서가 작성될 때의"]
[null,"변경 셀 값을 나타냅니다. 각 시나리오의 변경 셀들은"]
[null,"회색으로 표시됩니다."]

{"sheet":"무작정따라하기","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,7],[13,5,13,6]]}
["연간매출액"]
[]
["번호","물품명","단가","매출수량","반품수량","매출액","수익율","순수매출액"]
[2657,"A",2600,240,19,{"$f":"C4*D4","v":624000},{"$f":"H4/F4","v":0.92083333333333328},{"$f":"F4-(C4*E4)","v":574600}]
[4284,"B",3500,154,31,{"$f":"C5*D5","v":539000},{"$f":"H5/F5","v":0.79870129870129869},{"$f":"F5-(C5*E5)","v":430500}]
[3541,"C",4200,209,22,877800,0.89473684210526316,785400]
[2875,"D",1800,452,26,813600,0.94247787610619471,766800]
[3016,"E",2200,321,13,706200,0.95950155763239875,677600]
[4250,"F",5400,120,48,648000,0.6,388800]
[2586,"G",2800,410,35,1148000,0.91463414634146345,1050000]
[1462,"H",3600,215,106,774000,0.50697674418604655,392400]
[2253,"I",4500,325,87,1462500,0.73230769230769233,1071000]
[2028,"J",3200,248,74,793600,0.70161290322580649,556800]
[null,null,null,null,null,"매출액합계",null,{"$f":"SUM(H4:H13)","v":6693900}]

{"sheet":"기출01","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["적금 만기 금액"]
[]
["매월적립액",250000]
["연이율",0.1075]
["적립기간(년)",2]
["만기금액",{"$f":"FV($B$4/12,$B$5*12,-$B$3,0)","v":6660712.6162617523}]

{"sheet":"시나리오 요약 2","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"시나리오 요약"]
[null,null,null,"현재 값:","이율10%","이율11.5%"]
[null,null,null,null,"만든 사람 englishysh@gmail.com 날짜 6/5/2026","만든 사람 englishysh@gmail.com 날짜 6/5/2026"]
[null,"변경 셀:"]
[null,null,"이율",0.1075,0.1,0.115]
[null,"결과 셀:"]
[null,null,"만기금액",6660712.6162617505,6611728.8412667699,6710151.6766047599]
[null,"참고: 현재 값 열은 시나리오 요약 보고서가 작성될 때의"]
[null,"변경 셀 값을 나타냅니다. 각 시나리오의 변경 셀들은"]
[null,"회색으로 표시됩니다."]

{"sheet":"시나리오 요약 3","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"시나리오 요약"]
[null,null,null,"현재 값:","200원인하","200원인상"]
[null,null,null,null,"만든 사람 englishysh@gmail.com 날짜 6/5/2026","만든 사람 englishysh@gmail.com 날짜 6/5/2026"]
[null,"변경 셀:"]
[null,null,"$B$4",1500,1300,1700]
[null,"결과 셀:"]
[null,null,"$B$8",19539000,9139000,29939000]
[null,"참고: 현재 값 열은 시나리오 요약 보고서가 작성될 때의"]
[null,"변경 셀 값을 나타냅니다. 각 시나리오의 변경 셀들은"]
[null,"회색으로 표시됩니다."]

{"sheet":"기출02","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["이익률 계산"]
[]
["항목","금액"]
["버스요금",1500]
["이용고객",52000]
["매출액",{"$f":"B4*B5","v":78000000}]
["제조원가",58461000]
["영업이익",{"$f":"B6-B7","v":19539000}]
["영업이익률",{"$f":"B8/B6","v":0.2505}]