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

{"sheet":"现金流","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"小型企业版现金流预测"]
[null,"公司名称"]
[null,"开始日期",{"$f":"TODAY()","v":"2019-04-25"}]
[null,"现金余额警报最低限额",null,{"$f":"Cash_minimum","v":0},{"$f":"Cash_minimum","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"期初","2018年1月","2018年2月","2018年3月","2018年4月","2018年5月","2018年6月","2018年7月","2018年8月","2018年9月","2018年10月","2018年11月","2018年12月","总计"]
[null,"库存现金（月初）",null,{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"现金回执"," ","2018年1月","2018年2月","2018年3月","2018年4月","2018年5月","2018年6月","2018年7月","2018年8月","2018年9月","2018年10月","2018年11月","2018年12月","总计"]
[null,"现金销售",{"$nulls":13},{"$f":"SUM(D10:O10)","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(D10,D12:D15,(D11*-1))","v":0},{"$f":"SUM(E10,E12:E15,(E11*-1))","v":0},{"$f":"SUM(F10,F12:F15,(F11*-1))","v":0},{"$f":"SUM(G10,G12:G15,(G11*-1))","v":0},{"$f":"SUM(H10,H12:H15,(H11*-1))","v":0},{"$f":"SUM(I10,I12:I15,(I11*-1))","v":0},{"$f":"SUM(J10,J12:J15,(J11*-1))","v":0},{"$f":"SUM(K10,K12:K15,(K11*-1))","v":0},{"$f":"SUM(L10,L12:L15,(L11*-1))","v":0},{"$f":"SUM(M10,M12:M15,(M11*-1))","v":0},{"$f":"SUM(N10,N12:N15,(N11*-1))","v":0},{"$f":"SUM(O10,O12:O15,(O11*-1))","v":0},{"$f":"SUBTOTAL(109,CashReceipts[总计])","v":0}]
[null,"可用现金合计",{"$f":"(C7+CashReceipts[[#Totals],[ ]])","v":0},{"$f":"(D7+CashReceipts[[#Totals],[2018年1月]])","v":0},{"$f":"(E7+CashReceipts[[#Totals],[2018年2月]])","v":0},{"$f":"(F7+CashReceipts[[#Totals],[2018年3月]])","v":0},{"$f":"(G7+CashReceipts[[#Totals],[2018年4月]])","v":0},{"$f":"(H7+CashReceipts[[#Totals],[2018年5月]])","v":0},{"$f":"(I7+CashReceipts[[#Totals],[2018年6月]])","v":0},{"$f":"(J7+CashReceipts[[#Totals],[2018年7月]])","v":0},{"$f":"(K7+CashReceipts[[#Totals],[2018年8月]])","v":0},{"$f":"(L7+CashReceipts[[#Totals],[2018年9月]])","v":0},{"$f":"(M7+CashReceipts[[#Totals],[2018年10月]])","v":0},{"$f":"(N7+CashReceipts[[#Totals],[2018年11月]])","v":0},{"$f":"(O7+CashReceipts[[#Totals],[2018年12月]])","v":0}]
[]
[null,"支付的现金"," ","2018年1月","2018年2月","2018年3月","2018年4月","2018年5月","2018年6月","2018年7月","2018年8月","2018年9月","2018年10月","2018年11月","2018年12月","总计"]
[null,"广告",{"$nulls":13},{"$f":"SUM(D20:O20)","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,支出[2018年1月])","v":0},{"$f":"SUBTOTAL(109,支出[2018年2月])","v":0},{"$f":"SUBTOTAL(109,支出[2018年3月])","v":0},{"$f":"SUBTOTAL(109,支出[2018年4月])","v":0},{"$f":"SUBTOTAL(109,支出[2018年5月])","v":0},{"$f":"SUBTOTAL(109,支出[2018年6月])","v":0},{"$f":"SUBTOTAL(109,支出[2018年7月])","v":0},{"$f":"SUBTOTAL(109,支出[2018年8月])","v":0},{"$f":"SUBTOTAL(109,支出[2018年9月])","v":0},{"$f":"SUBTOTAL(109,支出[2018年10月])","v":0},{"$f":"SUBTOTAL(109,支出[2018年11月])","v":0},{"$f":"SUBTOTAL(109,支出[2018年12月])","v":0},{"$f":"SUBTOTAL(109,支出[总计])","v":0}]
[null,"支付的现金"," ","2018年1月","2018年2月","2018年3月","2018年4月","2018年5月","2018年6月","2018年7月","2018年8月","2018年9月","2018年10月","2018年11月","2018年12月","总计"]
[null,"贷款本金付款",{"$nulls":13},{"$f":"SUM(D47:O47)","v":0}]
[null,"资本购买",{"$nulls":13},0]
[null,"其他启动成本",{"$nulls":13},0]
[null,"准备金和/或暂管",{"$nulls":13},0]
[null,"所有者取款",{"$nulls":13},0]
[null,"支付的现金总计",null,{"$f":"支出[[#Totals],[2018年1月]]+SUBTOTAL(109,CashPaidOut[2018年1月])","v":0},{"$f":"支出[[#Totals],[2018年2月]]+SUBTOTAL(109,CashPaidOut[2018年2月])","v":0},{"$f":"支出[[#Totals],[2018年3月]]+SUBTOTAL(109,CashPaidOut[2018年3月])","v":0},{"$f":"支出[[#Totals],[2018年4月]]+SUBTOTAL(109,CashPaidOut[2018年4月])","v":0},{"$f":"支出[[#Totals],[2018年5月]]+SUBTOTAL(109,CashPaidOut[2018年5月])","v":0},{"$f":"支出[[#Totals],[2018年6月]]+SUBTOTAL(109,CashPaidOut[2018年6月])","v":0},{"$f":"支出[[#Totals],[2018年7月]]+SUBTOTAL(109,CashPaidOut[2018年7月])","v":0},{"$f":"支出[[#Totals],[2018年8月]]+SUBTOTAL(109,CashPaidOut[2018年8月])","v":0},{"$f":"支出[[#Totals],[2018年9月]]+SUBTOTAL(109,CashPaidOut[2018年9月])","v":0},{"$f":"支出[[#Totals],[2018年10月]]+SUBTOTAL(109,CashPaidOut[2018年10月])","v":0},{"$f":"支出[[#Totals],[2018年11月]]+SUBTOTAL(109,CashPaidOut[2018年11月])","v":0},{"$f":"支出[[#Totals],[2018年12月]]+SUBTOTAL(109,CashPaidOut[2018年12月])","v":0},0]
[null,"库存现金（月末）",{"$f":"C17","v":0},{"$f":"D17-CashPaidOut[[#Totals],[2018年1月]]","v":0},{"$f":"E17-CashPaidOut[[#Totals],[2018年2月]]","v":0},{"$f":"F17-CashPaidOut[[#Totals],[2018年3月]]","v":0},{"$f":"G17-CashPaidOut[[#Totals],[2018年4月]]","v":0},{"$f":"H17-CashPaidOut[[#Totals],[2018年5月]]","v":0},{"$f":"I17-CashPaidOut[[#Totals],[2018年6月]]","v":0},{"$f":"J17-CashPaidOut[[#Totals],[2018年7月]]","v":0},{"$f":"K17-CashPaidOut[[#Totals],[2018年8月]]","v":0},{"$f":"L17-CashPaidOut[[#Totals],[2018年9月]]","v":0},{"$f":"M17-CashPaidOut[[#Totals],[2018年10月]]","v":0},{"$f":"N17-CashPaidOut[[#Totals],[2018年11月]]","v":0},{"$f":"O17-CashPaidOut[[#Totals],[2018年12月]]","v":0}]
[]
[null,"其他营业数据"," ","2018年1月","2018年2月","2018年3月","2018年4月","2018年5月","2018年6月","2018年7月","2018年8月","2018年9月","2018年10月","2018年11月","2018年12月","总计"]
[null,"销量（以美元计）",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[2018年1月]:[2018年12月]])","v":0}]
[null,"应收帐款余额",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[2018年1月]:[2018年12月]])","v":0}]
[null,"坏帐余额",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[2018年1月]:[2018年12月]])","v":0}]
[null,"现有库存",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[2018年1月]:[2018年12月]])","v":0}]
[null,"应付帐款余额",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[2018年1月]:[2018年12月]])","v":0}]
[null,"折旧",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[2018年1月]:[2018年12月]])","v":0}]

{"sheet":"现金流图表","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"此单元格中为显示库存现金最低限额警报和现金流预测的组合图表。"]
{"$rows_empty":34}
[null,"现金余额警报最低限额",null,{"$f":"[0]!Cash_minimum","v":{"v":0,"d":"¥0"}}]