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

{"sheet":"现金流量预测","index":0,"n_rows":64,"n_cols":16,"rows_kept":64,"merged":[[4,14,5,14]]}
[{"$nulls":15}," "]
[]
[null,"初始库存现金",{"v":10000,"d":"¥10,000.00"},null,"开始日期",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)","v":"2019-11-01"},null,"现金余额下限警报",null,{"v":2000,"d":"¥2,000.00"}]
[]
[null,null,{"$f":"IF(开始日期=\"\",\"\",开始日期)","v":"2019-11-01"},{"$f":"IF(C5=\"\",\"\",DATE(YEAR(C5),MONTH(C5)+1,1))","v":"2019-12-01"},{"$f":"IF(D5=\"\",\"\",DATE(YEAR(D5),MONTH(D5)+1,1))","v":"2020-01-01"},"2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","汇总"]
[null,"库存现金（月初）",{"$f":"C3","v":{"v":10000,"d":"¥10,000.00"}},{"$f":"C55","v":{"v":8050,"d":"¥8,050.00"}},{"v":9350,"d":"¥9,350.00"},{"v":890,"d":"¥890.00"},{"v":2190,"d":"¥2,190.00"},{"v":13590,"d":"¥13,590.00"},{"v":13790,"d":"¥13,790.00"},{"v":15290,"d":"¥15,290.00"},{"v":16410,"d":"¥16,410.00"},{"v":14360,"d":"¥14,360.00"},{"v":16560,"d":"¥16,560.00"},{"v":18780,"d":"¥18,780.00"}]
[]
[null,"现金收入"]
[]
[null,"销售入账",{"v":2500,"d":"¥2,500.00"},{"v":3000,"d":"¥3,000.00"},{"v":3600,"d":"¥3,600.00"},{"v":3000,"d":"¥3,000.00"},{"v":14000,"d":"¥14,000.00"},{"v":6000,"d":"¥6,000.00"},{"v":3000,"d":"¥3,000.00"},{"v":2800,"d":"¥2,800.00"},{"v":3500,"d":"¥3,500.00"},{"v":4000,"d":"¥4,000.00"},{"v":3800,"d":"¥3,800.00"},{"v":4200,"d":"¥4,200.00"},{"$f":"SUM(C10:N10)","v":{"v":53400,"d":"¥53,400.00"}}]
[null,"退货和折让",null,null,{"v":200,"d":"¥200.00"},{"$nulls":9},{"v":200,"d":"¥200.00"}]
[null,"应收帐款的收款",{"$nulls":12},0]
[null,"利息、其他收入",{"$nulls":12},0]
[null,"贷款收益",{"$nulls":12},0]
[null,"所有者出资",{"$nulls":12},0]
[null,"其他收入",{"$nulls":12},0]
[null,"现金收入合计",{"$f":"SUM(C10,C12:C16,(C11*-1))","v":{"v":2500,"d":"¥2,500.00"}},{"$f":"SUM(D10,D12:D16,(D11*-1))","v":{"v":3000,"d":"¥3,000.00"}},{"v":3400,"d":"¥3,400.00"},{"v":3000,"d":"¥3,000.00"},{"v":14000,"d":"¥14,000.00"},{"v":6000,"d":"¥6,000.00"},{"v":3000,"d":"¥3,000.00"},{"v":2800,"d":"¥2,800.00"},{"v":3500,"d":"¥3,500.00"},{"v":4000,"d":"¥4,000.00"},{"v":3800,"d":"¥3,800.00"},{"v":4200,"d":"¥4,200.00"},{"$f":"SUM(O10:O16)","v":{"v":53600,"d":"¥53,600.00"}}]
[null,"可用现金合计",{"$f":"(C6+C17)","v":{"v":12500,"d":"¥12,500.00"}},{"v":11050,"d":"¥11,050.00"},{"v":12750,"d":"¥12,750.00"},{"v":3890,"d":"¥3,890.00"},{"v":16190,"d":"¥16,190.00"},{"v":19590,"d":"¥19,590.00"},{"v":16790,"d":"¥16,790.00"},{"v":18090,"d":"¥18,090.00"},{"v":19910,"d":"¥19,910.00"},{"v":18360,"d":"¥18,360.00"},{"v":20360,"d":"¥20,360.00"},{"v":22980,"d":"¥22,980.00"}]
[]
[null,"已付现金"]
[]
[null,"广告",{"v":3000,"d":"¥3,000.00"},{"$nulls":11},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"¥3,000.00"}}]
[null,"佣金和费用",{"v":250,"d":"¥250.00"},{"v":300,"d":"¥300.00"},{"v":360,"d":"¥360.00"},{"v":300,"d":"¥300.00"},{"v":1400,"d":"¥1,400.00"},{"v":400,"d":"¥400.00"},{"v":300,"d":"¥300.00"},{"v":280,"d":"¥280.00"},{"v":350,"d":"¥350.00"},{"v":400,"d":"¥400.00"},{"v":380,"d":"¥380.00"},{"v":420,"d":"¥420.00"},{"v":5140,"d":"¥5,140.00"}]
[null,"合同工",null,{"v":200,"d":"¥200.00"},null,{"v":200,"d":"¥200.00"},null,{"v":200,"d":"¥200.00"},null,{"v":200,"d":"¥200.00"},null,{"v":200,"d":"¥200.00"},null,{"v":200,"d":"¥200.00"},{"v":1200,"d":"¥1,200.00"}]
[null,"员工福利计划",{"$nulls":12},0]
[null,"保险（非健康问题）",null,null,{"v":4000,"d":"¥4,000.00"},null,null,{"v":4000,"d":"¥4,000.00"},null,null,{"v":4000,"d":"¥4,000.00"},null,null,{"v":4000,"d":"¥4,000.00"},{"v":16000,"d":"¥16,000.00"}]
[null,"利息支出",{"$nulls":12},0]
[null,"材料和供应（COGS 中）",{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":7500,"d":"¥7,500.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":20700,"d":"¥20,700.00"}]
[null,"餐饮和娱乐",{"$nulls":12},0]
[null,"抵押贷款利息",{"$nulls":12},0]
[null,"办公费用",{"$nulls":12},0]
[null,"其他利息支出",{"$nulls":12},0]
[null,"退休金和利润共享计划",{"$nulls":12},0]
[null,"用于转售的采购",{"$nulls":12},0]
[null,"租金或租赁",{"$nulls":12},0]
[null,"租金或租赁：车辆、设备",{"$nulls":12},0]
[null,"修理和维护",{"$nulls":12},0]
[null,"供应（不在 COGS 中）",{"$nulls":12},0]
[null,"税费和许可证",{"$nulls":12},0]
[null,"差旅",{"$nulls":12},0]
[null,"水电费",{"$nulls":12},0]
[null,"工资（扣除员工信贷）",{"$nulls":12},0]
[null,"其他费用",{"$nulls":12},0]
[null,"其他费用",{"$nulls":12},0]
[null,"其他费用",{"$nulls":12},0]
[null,"杂项",{"$nulls":12},0]
[null,"小计",{"$f":"SUM(C22:C46)","v":{"v":4450,"d":"¥4,450.00"}},{"v":1700,"d":"¥1,700.00"},{"v":11860,"d":"¥11,860.00"},{"v":1700,"d":"¥1,700.00"},{"v":2600,"d":"¥2,600.00"},{"v":5800,"d":"¥5,800.00"},{"v":1500,"d":"¥1,500.00"},{"v":1680,"d":"¥1,680.00"},{"v":5550,"d":"¥5,550.00"},{"v":1800,"d":"¥1,800.00"},{"v":1580,"d":"¥1,580.00"},{"v":5820,"d":"¥5,820.00"},{"v":46040,"d":"¥46,040.00"}]
[]
[null,"贷款本金付款",{"$nulls":12},0]
[null,"资本购买",{"$nulls":12},0]
[null,"其他启动成本",{"$nulls":12},0]
[null,"准备金和/或暂管",{"$nulls":12},0]
[null,"所有者取款",{"$nulls":12},0]
[null,"已付现金总计",{"$f":"C47-SUM(C49:C53)","v":{"v":4450,"d":"¥4,450.00"}},{"$f":"D47-SUM(D49:D53)","v":{"v":1700,"d":"¥1,700.00"}},{"v":11860,"d":"¥11,860.00"},{"v":1700,"d":"¥1,700.00"},{"v":2600,"d":"¥2,600.00"},{"v":5800,"d":"¥5,800.00"},{"v":1500,"d":"¥1,500.00"},{"v":1680,"d":"¥1,680.00"},{"v":5550,"d":"¥5,550.00"},{"v":1800,"d":"¥1,800.00"},{"v":1580,"d":"¥1,580.00"},{"v":5820,"d":"¥5,820.00"},{"$f":"SUM(O47,O49:O53)","v":{"v":46040,"d":"¥46,040.00"}}]
[null,"库存现金（月末）",{"$f":"(C18-C54)","v":{"v":8050,"d":"¥8,050.00"}},{"v":9350,"d":"¥9,350.00"},{"v":890,"d":"¥890.00"},{"v":2190,"d":"¥2,190.00"},{"v":13590,"d":"¥13,590.00"},{"v":13790,"d":"¥13,790.00"},{"v":15290,"d":"¥15,290.00"},{"v":16410,"d":"¥16,410.00"},{"v":14360,"d":"¥14,360.00"},{"v":16560,"d":"¥16,560.00"},{"v":18780,"d":"¥18,780.00"},{"v":17160,"d":"¥17,160.00"}]
[]
[null,"其他营业数据"]
[]
[null,"销售额（美元）"]
[null,"应收帐款余额"]
[null,"坏帐余额"]
[null,"现有库存"]
[null,"应付帐款余额"]
[null,"折旧"]

{"sheet":"现金流量图表","index":1,"n_rows":15,"n_cols":15,"rows_kept":15}
[{"$nulls":11}," "]
[]
[null,"月份","库存现金",{"$nulls":10},"不低于下限","低于下限"]
[null,{"$f":"现金流量预测!C5","v":"2019-11-01"},{"$f":"现金流量预测!C6","v":{"v":10000,"d":"¥10,000.00"}},{"$nulls":9},{"$f":"B4","v":"2019-11-01"},{"$f":"IF(C4<现金下限,0,C4)","v":{"v":10000,"d":"¥10,000.00"}},{"$f":"IF(C4<现金下限,C4,0)","v":0}]
[null,{"$f":"现金流量预测!D5","v":"2019-12-01"},{"$f":"现金流量预测!D6","v":{"v":8050,"d":"¥8,050.00"}},{"$nulls":9},"2019-12-01",{"v":8050,"d":"¥8,050.00"},0]
[null,{"$f":"现金流量预测!E5","v":"2020-01-01"},{"$f":"现金流量预测!E6","v":{"v":9350,"d":"¥9,350.00"}},{"$nulls":9},"2020-01-01",{"v":9350,"d":"¥9,350.00"},0]
[null,{"$f":"现金流量预测!F5","v":"2020-02-01"},{"$f":"现金流量预测!F6","v":{"v":890,"d":"¥890.00"}},{"$nulls":9},"2020-02-01",0,{"v":890,"d":"¥890.00"}]
[null,{"$f":"现金流量预测!G5","v":"2020-03-01"},{"$f":"现金流量预测!G6","v":{"v":2190,"d":"¥2,190.00"}},{"$nulls":9},"2020-03-01",{"v":2190,"d":"¥2,190.00"},0]
[null,{"$f":"现金流量预测!H5","v":"2020-04-01"},{"$f":"现金流量预测!H6","v":{"v":13590,"d":"¥13,590.00"}},{"$nulls":9},"2020-04-01",{"v":13590,"d":"¥13,590.00"},0]
[null,{"$f":"现金流量预测!I5","v":"2020-05-01"},{"$f":"现金流量预测!I6","v":{"v":13790,"d":"¥13,790.00"}},{"$nulls":9},"2020-05-01",{"v":13790,"d":"¥13,790.00"},0]
[null,{"$f":"现金流量预测!J5","v":"2020-06-01"},{"$f":"现金流量预测!J6","v":{"v":15290,"d":"¥15,290.00"}},{"$nulls":9},"2020-06-01",{"v":15290,"d":"¥15,290.00"},0]
[null,{"$f":"现金流量预测!K5","v":"2020-07-01"},{"$f":"现金流量预测!K6","v":{"v":16410,"d":"¥16,410.00"}},{"$nulls":9},"2020-07-01",{"v":16410,"d":"¥16,410.00"},0]
[null,{"$f":"现金流量预测!L5","v":"2020-08-01"},{"$f":"现金流量预测!L6","v":{"v":14360,"d":"¥14,360.00"}},{"$nulls":9},"2020-08-01",{"v":14360,"d":"¥14,360.00"},0]
[null,{"$f":"现金流量预测!M5","v":"2020-09-01"},{"$f":"现金流量预测!M6","v":{"v":16560,"d":"¥16,560.00"}},{"$nulls":9},"2020-09-01",{"v":16560,"d":"¥16,560.00"},0]
[null,{"$f":"现金流量预测!N5","v":"2020-10-01"},{"$f":"现金流量预测!N6","v":{"v":18780,"d":"¥18,780.00"}},{"$nulls":9},"2020-10-01",{"v":18780,"d":"¥18,780.00"},0]