{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["现金流","现金流量图表"],"not_rendered":{"charts":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"现金流","index":0,"n_rows":62,"n_cols":16,"rows_kept":62,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"ADATUM 公司"]
[null,"小型企业版现金流预测"]
[]
[null,"开始日期",{"$f":"TODAY()","v":"2023-03-22"}]
[null,"现金余额警报最低限额",null,{"$f":"Cash_minimum","v":0},{"$f":"Cash_minimum","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"期初","1 月-xx","2 月-xx","3 月-xx","4 月-xx","5 月-xx","6 月-xx","7 月-xx","8 月-xx","9 月-xx","10 月-xx","11 月-xx","12 月-xx","汇总"]
[null,"库存现金（月初）",null,{"$f":"C54","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"现金回执"," ","1 月-xx","2 月-xx","3 月-xx","4 月-xx","5 月-xx","6 月-xx","7 月-xx","8 月-xx","9 月-xx","10 月-xx","11 月-xx","12 月-xx","汇总"]
[null,"现金销售",{"$nulls":13},{"$f":"SUM(D11:O11)","v":0}]
[null,"退货和折让",{"$nulls":13},0]
[null,"应收帐款的收款",{"$nulls":13},0]
[null,"利息、其他收入",{"$nulls":13},0]
[null,"贷款收益",{"$nulls":13},0]
[null,"所有者出资",{"$nulls":13},0]
[null,"现金回执合计",null,{"$f":"SUM(D11,D13:D16,(D12*-1))","v":0},{"$f":"SUM(E11,E13:E16,(E12*-1))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,现金回执[汇总])","v":0}]
[null,"可用现金合计",{"$f":"(C8+现金回执[[#Totals],[ ]])","v":0},{"$f":"(D8+现金回执[[#Totals],[1 月-xx]])","v":0},{"$f":"(E8+现金回执[[#Totals],[2 月-xx]])","v":0},{"$f":"(F8+现金回执[[#Totals],[3 月-xx]])","v":0},{"$f":"(G8+现金回执[[#Totals],[4 月-xx]])","v":0},{"$f":"(H8+现金回执[[#Totals],[5 月-xx]])","v":0},{"$f":"(I8+现金回执[[#Totals],[6 月-xx]])","v":0},{"$f":"(J8+现金回执[[#Totals],[7 月-xx]])","v":0},{"$f":"(K8+现金回执[[#Totals],[8 月-xx]])","v":0},{"$f":"(L8+现金回执[[#Totals],[9 月-xx]])","v":0},{"$f":"(M8+现金回执[[#Totals],[10 月-xx]])","v":0},{"$f":"(N8+现金回执[[#Totals],[11 月-xx]])","v":0},{"$f":"(O8+现金回执[[#Totals],[12 月-xx]])","v":0}]
[]
[null,"支付的现金"," ","1 月-xx","2 月-xx","3 月-xx","4 月-xx","5 月-xx","6 月-xx","7 月-xx","8 月-xx","9 月-xx","10 月-xx","11 月-xx","12 月-xx","汇总"]
[null,"广告",{"$nulls":13},{"$f":"SUM(D21:O21)","v":0}]
[null,"佣金和费用",{"$nulls":13},0]
[null,"合同工",{"$nulls":13},0]
[null,"员工福利计划",{"$nulls":13},0]
[null,"保险（非健康问题）",{"$nulls":13},0]
[null,"利息支出",{"$nulls":13},0]
[null,"材料和供应（COGS 中）",{"$nulls":13},0]
[null,"餐饮和娱乐",{"$nulls":13},0]
[null,"抵押贷款利息",{"$nulls":13},0]
[null,"办公费用",{"$nulls":13},0]
[null,"其他利息支出",{"$nulls":13},0]
[null,"退休金和利润共享计划",{"$nulls":13},0]
[null,"用于转售的采购",{"$nulls":13},0]
[null,"租金或租赁",{"$nulls":13},0]
[null,"租金或租赁：车辆、设备",{"$nulls":13},0]
[null,"修理和维护",{"$nulls":13},0]
[null,"供应（不在 COGS 中）",{"$nulls":13},0]
[null,"税费和许可证",{"$nulls":13},0]
[null,"差旅",{"$nulls":13},0]
[null,"水电费",{"$nulls":13},0]
[null,"工资（扣除员工信贷）",{"$nulls":13},0]
[null,"其他费用",{"$nulls":13},0]
[null,"其他费用",{"$nulls":13},0]
[null,"其他费用",{"$nulls":13},0]
[null,"杂项",{"$nulls":13},0]
[null,"小计",null,{"$f":"SUBTOTAL(109,支出[1 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[2 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[3 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[4 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[5 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[6 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[7 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[8 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[9 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[10 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[11 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[12 月-xx])","v":0},{"$f":"SUBTOTAL(109,支出[汇总])","v":0}]
[null,"支付的现金"," ","1 月-xx","2 月-xx","3 月-xx","4 月-xx","5 月-xx","6 月-xx","7 月-xx","8 月-xx","9 月-xx","10 月-xx","11 月-xx","12 月-xx","汇总"]
[null,"贷款本金付款",{"$nulls":13},{"$f":"SUM(D48:O48)","v":0}]
[null,"资本购买",{"$nulls":13},0]
[null,"其他启动成本",{"$nulls":13},0]
[null,"准备金和/或暂管",{"$nulls":13},0]
[null,"所有者取款",{"$nulls":13},0]
[null,"支付的现金总计",null,{"$f":"支出[[#Totals],[1 月-xx]]+SUBTOTAL(109,支付的现金[1 月-xx])","v":0},{"$f":"支出[[#Totals],[2 月-xx]]+SUBTOTAL(109,支付的现金[2 月-xx])","v":0},{"$f":"支出[[#Totals],[3 月-xx]]+SUBTOTAL(109,支付的现金[3 月-xx])","v":0},{"$f":"支出[[#Totals],[4 月-xx]]+SUBTOTAL(109,支付的现金[4 月-xx])","v":0},{"$f":"支出[[#Totals],[5 月-xx]]+SUBTOTAL(109,支付的现金[5 月-xx])","v":0},{"$f":"支出[[#Totals],[6 月-xx]]+SUBTOTAL(109,支付的现金[6 月-xx])","v":0},{"$f":"支出[[#Totals],[7 月-xx]]+SUBTOTAL(109,支付的现金[7 月-xx])","v":0},{"$f":"支出[[#Totals],[8 月-xx]]+SUBTOTAL(109,支付的现金[8 月-xx])","v":0},{"$f":"支出[[#Totals],[9 月-xx]]+SUBTOTAL(109,支付的现金[9 月-xx])","v":0},{"$f":"支出[[#Totals],[10 月-xx]]+SUBTOTAL(109,支付的现金[10 月-xx])","v":0},{"$f":"支出[[#Totals],[11 月-xx]]+SUBTOTAL(109,支付的现金[11 月-xx])","v":0},{"$f":"支出[[#Totals],[12 月-xx]]+SUBTOTAL(109,支付的现金[12 月-xx])","v":0},0]
[null,"库存现金（月末）",{"$f":"C18","v":0},{"$f":"D18-支付的现金[[#Totals],[1 月-xx]]","v":0},{"$f":"E18-支付的现金[[#Totals],[2 月-xx]]","v":0},{"$f":"F18-支付的现金[[#Totals],[3 月-xx]]","v":0},{"$f":"G18-支付的现金[[#Totals],[4 月-xx]]","v":0},{"$f":"H18-支付的现金[[#Totals],[5 月-xx]]","v":0},{"$f":"I18-支付的现金[[#Totals],[6 月-xx]]","v":0},{"$f":"J18-支付的现金[[#Totals],[7 月-xx]]","v":0},{"$f":"K18-支付的现金[[#Totals],[8 月-xx]]","v":0},{"$f":"L18-支付的现金[[#Totals],[9 月-xx]]","v":0},{"$f":"M18-支付的现金[[#Totals],[10 月-xx]]","v":0},{"$f":"N18-支付的现金[[#Totals],[11 月-xx]]","v":0},{"$f":"O18-支付的现金[[#Totals],[12 月-xx]]","v":0}]
[]
[null,"其他营业数据"," ","1 月-xx","2 月-xx","3 月-xx","4 月-xx","5 月-xx","6 月-xx","7 月-xx","8 月-xx","9 月-xx","10 月-xx","11 月-xx","12 月-xx","汇总"]
[null,"销量（以美元计）",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[1 月-xx]:[12 月-xx]])","v":0}]
[null,"应收帐款余额",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[12 月-xx]])","v":0}]
[null,"坏帐余额",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[12 月-xx]])","v":0}]
[null,"现有库存",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[12 月-xx]])","v":0}]
[null,"应付帐款余额",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[12 月-xx]])","v":0}]
[null,"折旧",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[1 月-xx]:[12 月-xx]])","v":0}]

{"sheet":"现金流量图表","index":1,"n_rows":2,"n_cols":7,"rows_kept":2,"merged":[[1,1,1,5],[53,2,53,3]]}
[]
[null,"现金余额警报最低限额：",{"$nulls":4},{"$f":"[0]!Cash_minimum","v":{"v":0,"d":"¥0"}}]