{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["十二個月現金流量","現金流量摘要"],"not_rendered":{"charts":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"十二個月現金流量","index":0,"n_rows":41,"n_cols":16,"rows_kept":41,"merged":[[7,0,7,15],[11,0,11,15],[17,0,17,15],[33,0,33,15]]}
[]
["十二個月現金流量",{"$nulls":13},"會計會度開始：","2013-07-01"]
["公司名稱"]
["郵遞區號，縣/市，鄉鎮市區，地址"]
["電話、電子郵件、網站"]
[]
[null,"期初",{"$f":"FiscalYear","v":"2013-07-01"},{"$f":"DATE(YEAR(C7),MONTH(C7)+1,1)","v":"2013-08-01"},{"$f":"DATE(YEAR(D7),MONTH(D7)+1,1)","v":"2013-09-01"},"2013-10-01","2013-11-01","2013-12-01","2014-01-01","2014-02-01","2014-03-01","2014-04-01","2014-05-01","2014-06-01","月\n平均","總覽"]
["現金摘要"]
["庫存現金\n(月初)",{"v":1650000,"d":"1,650,000"},{"$f":"IF(Receipts[[#Totals],[Column3]]+PaidOut[[#Totals],[Column3]]=0,\"\",B11)","v":{"v":2027790,"d":"2,027,790"}},{"$f":"IF(Receipts[[#Totals],[Column4]]+PaidOut[[#Totals],[Column4]]=0,\"\",C11)","v":{"v":1627950,"d":"1,627,950"}},{"$f":"IF(Receipts[[#Totals],[Column5]]+PaidOut[[#Totals],[Column5]]=0,\"\",D11)","v":{"v":1672170,"d":"1,672,170"}},{"$f":"IF(Receipts[[#Totals],[Column6]]+PaidOut[[#Totals],[Column6]]=0,\"\",E11)","v":{"v":2078700,"d":"2,078,700"}},{"$f":"IF(Receipts[[#Totals],[Column7]]+PaidOut[[#Totals],[Column7]]=0,\"\",F11)","v":{"v":1968540,"d":"1,968,540"}},null,{"$f":"IF(Receipts[[#Totals],[Column9]]+PaidOut[[#Totals],[Column9]]=0,\"\",H11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column10]]+PaidOut[[#Totals],[Column10]]=0,\"\",I11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column11]]+PaidOut[[#Totals],[Column11]]=0,\"\",J11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column12]]+PaidOut[[#Totals],[Column12]]=0,\"\",K11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column13]]+PaidOut[[#Totals],[Column13]]=0,\"\",L11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column14]]+PaidOut[[#Totals],[Column14]]=0,\"\",M11)","v":""},{"$f":"IFERROR(AVERAGE(Summary[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":1875030,"d":"1,875,030"}}]
["可用現金\n(庫存 + 收入，提款之前) ",{"$f":"SUM(B9,Receipts[[#Totals],[Column2]])","v":{"v":2027790,"d":"2,027,790"}},{"$f":"IF(C9=\"\",\"\",SUM(C9,Receipts[[#Totals],[Column3]]))","v":{"v":2281950,"d":"2,281,950"}},{"$f":"IF(D9=\"\",\"\",SUM(D9,Receipts[[#Totals],[Column4]]))","v":{"v":2499030,"d":"2,499,030"}},{"$f":"IF(E9=\"\",\"\",SUM(E9,Receipts[[#Totals],[Column5]]))","v":{"v":2730960,"d":"2,730,960"}},{"$f":"IF(F9=\"\",\"\",SUM(F9,Receipts[[#Totals],[Column6]]))","v":{"v":2689860,"d":"2,689,860"}},{"$f":"IF(G9=\"\",\"\",SUM(G9,Receipts[[#Totals],[Column7]]))","v":{"v":2286000,"d":"2,286,000"}},null,{"$f":"IF(I9=\"\",\"\",SUM(I9,Receipts[[#Totals],[Column9]]))","v":""},{"$f":"IF(J9=\"\",\"\",SUM(J9,Receipts[[#Totals],[Column10]]))","v":""},{"$f":"IF(K9=\"\",\"\",SUM(K9,Receipts[[#Totals],[Column11]]))","v":""},{"$f":"IF(L9=\"\",\"\",SUM(L9,Receipts[[#Totals],[Column12]]))","v":""},{"$f":"IF(M9=\"\",\"\",SUM(M9,Receipts[[#Totals],[Column13]]))","v":""},{"$f":"IF(N9=\"\",\"\",SUM(N9,Receipts[[#Totals],[Column14]]))","v":""},{"$f":"IFERROR(AVERAGE(Summary[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":2497560,"d":"2,497,560"}}]
["現金狀況\n(月底)",{"$f":"(B10-PaidOut[[#Totals],[Column2]])","v":{"v":2027790,"d":"2,027,790"}},{"$f":"IFERROR(C10-PaidOut[[#Totals],[Column3]],\"\")","v":{"v":1627950,"d":"1,627,950"}},{"$f":"IFERROR(D10-PaidOut[[#Totals],[Column4]],\"\")","v":{"v":1672170,"d":"1,672,170"}},{"$f":"IFERROR(E10-PaidOut[[#Totals],[Column5]],\"\")","v":{"v":2078700,"d":"2,078,700"}},{"$f":"IFERROR(F10-PaidOut[[#Totals],[Column6]],\"\")","v":{"v":1968540,"d":"1,968,540"}},{"$f":"IFERROR(G10-PaidOut[[#Totals],[Column7]],\"\")","v":{"v":1542390,"d":"1,542,390"}},null,{"$f":"IFERROR(I10-PaidOut[[#Totals],[Column9]],\"\")","v":""},{"$f":"IFERROR(J10-PaidOut[[#Totals],[Column10]],\"\")","v":""},{"$f":"IFERROR(K10-PaidOut[[#Totals],[Column11]],\"\")","v":""},{"$f":"IFERROR(L10-PaidOut[[#Totals],[Column12]],\"\")","v":""},{"$f":"IFERROR(M10-PaidOut[[#Totals],[Column13]],\"\")","v":""},{"$f":"IFERROR(N10-PaidOut[[#Totals],[Column14]],\"\")","v":""},{"$f":"IFERROR(AVERAGE(Summary[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":1777950,"d":"1,777,950"}}]
[]
["現金收入"]
["現金銷售",{"v":168480,"d":"168,480"},{"v":116670,"d":"116,670"},{"v":732330,"d":"732,330"},{"v":949260,"d":"949,260"},{"v":439410,"d":"439,410"},{"v":91020,"d":"91,020"}]
["從貸方帳戶收款",{"v":134940,"d":"134,940"},{"v":104790,"d":"104,790"},{"v":59610,"d":"59,610"},{"v":30870,"d":"30,870"},{"v":87330,"d":"87,330"},{"v":127020,"d":"127,020"}]
["貸款/ 其他現金",{"v":74370,"d":"74,370"},{"v":32700,"d":"32,700"},{"v":79140,"d":"79,140"},{"v":78660,"d":"78,660"},{"v":84420,"d":"84,420"},{"v":99420,"d":"99,420"}]
["總現金收入",{"$f":"SUBTOTAL(109,Receipts[Column2])","v":{"v":377790,"d":"377,790"}},{"$f":"SUBTOTAL(109,Receipts[Column3])","v":{"v":254160,"d":"254,160"}},{"$f":"SUBTOTAL(109,Receipts[Column4])","v":{"v":871080,"d":"871,080"}},{"$f":"SUBTOTAL(109,Receipts[Column5])","v":{"v":1058790,"d":"1,058,790"}},{"$f":"SUBTOTAL(109,Receipts[Column6])","v":{"v":611160,"d":"611,160"}},{"$f":"SUBTOTAL(109,Receipts[Column7])","v":{"v":317460,"d":"317,460"}},{"$f":"SUBTOTAL(109,Receipts[Column8])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column9])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column10])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column11])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column12])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column13])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column14])","v":0},{"$f":"IFERROR(AVERAGE(Receipts[[#Totals],[Column3]:[Column14]]),\"\")","v":{"v":259387.5,"d":"259,388"}}]
[]
["現金出支"]
["購物 (詳細說明)",null,{"v":15630,"d":"15,630"},{"v":9690,"d":"9,690"},{"v":8220,"d":"8,220"},{"v":13530,"d":"13,530"},{"v":3120,"d":"3,120"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":8365,"d":"8,365"}}]
["薪資總額 (實際提領)",null,{"v":317160,"d":"317,160"},{"v":435420,"d":"435,420"},{"v":316830,"d":"316,830"},{"v":395100,"d":"395,100"},{"v":374340,"d":"374,340"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":306475,"d":"306,475"}}]
["用品 (辦公與營運)",null,{"v":7500,"d":"7,500"},{"v":12840,"d":"12,840"},{"v":4950,"d":"4,950"},{"v":35040,"d":"35,040"},{"v":10350,"d":"10,350"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":11780,"d":"11,780"}}]
["維修保養",null,null,{"v":66000,"d":"66,000"},{"v":4890,"d":"4,890"},{"v":2010,"d":"2,010"},{"$nulls":7},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":18225,"d":"18,225"}}]
["廣告",null,{"v":33000,"d":"33,000"},{"v":18750,"d":"18,750"},{"v":40680,"d":"40,680"},null,{"v":76800,"d":"76,800"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":33846,"d":"33,846"}}]
["房租",null,{"v":105000,"d":"105,000"},{"v":105000,"d":"105,000"},{"v":105000,"d":"105,000"},{"v":105000,"d":"105,000"},{"v":105000,"d":"105,000"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":87500,"d":"87,500"}}]
["水電費",null,{"v":8550,"d":"8,550"},{"v":9540,"d":"9,540"},{"v":4530,"d":"4,530"},{"v":4020,"d":"4,020"},{"v":6840,"d":"6,840"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":5580,"d":"5,580"}}]
["其他 (詳細說明)",null,{"v":3690,"d":"3,690"},{"v":7020,"d":"7,020"},{"v":3690,"d":"3,690"},{"v":7020,"d":"7,020"},{"v":3690,"d":"3,690"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":4185,"d":"4,185"}}]
["貸款本金付款",null,{"v":120000,"d":"120,000"},{"v":120000,"d":"120,000"},{"v":120000,"d":"120,000"},{"v":120000,"d":"120,000"},{"v":120000,"d":"120,000"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":100000,"d":"100,000"}}]
["資本購買 (詳細說明)",null,{"v":20370,"d":"20,370"},{"v":21000,"d":"21,000"},{"v":20370,"d":"20,370"},{"v":19500,"d":"19,500"},{"v":20370,"d":"20,370"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":16935,"d":"16,935"}}]
["其他創業成本",null,{"v":12000,"d":"12,000"},{"v":10500,"d":"10,500"},{"v":12000,"d":"12,000"},{"v":9000,"d":"9,000"},{"v":12000,"d":"12,000"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":9250,"d":"9,250"}}]
["儲備金與/或委付",null,{"v":9000,"d":"9,000"},{"v":9000,"d":"9,000"},{"v":9000,"d":"9,000"},{"v":9000,"d":"9,000"},{"v":9000,"d":"9,000"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":7500,"d":"7,500"}}]
["持有人提領款項",null,{"v":2100,"d":"2,100"},{"v":2100,"d":"2,100"},{"v":2100,"d":"2,100"},{"v":2100,"d":"2,100"},{"v":2100,"d":"2,100"},{"$nulls":6},{"$f":"30*PaidOut[[#This Row],[Column8]]","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":1750,"d":"1,750"}}]
["總現金支出",null,{"$f":"SUBTOTAL(109,PaidOut[Column3])","v":{"v":654000,"d":"654,000"}},{"$f":"SUBTOTAL(109,PaidOut[Column4])","v":{"v":826860,"d":"826,860"}},{"$f":"SUBTOTAL(109,PaidOut[Column5])","v":{"v":652260,"d":"652,260"}},{"$f":"SUBTOTAL(109,PaidOut[Column6])","v":{"v":721320,"d":"721,320"}},{"$f":"SUBTOTAL(109,PaidOut[Column7])","v":{"v":743610,"d":"743,610"}},{"$f":"SUBTOTAL(109,PaidOut[Column8])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column9])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column10])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column11])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column12])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column13])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column14])","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#Totals],[Column3]:[Column14]]),\"\")","v":{"v":299837.5,"d":"299,838"}}]
[]
["基本營運資料 (非現金流量資訊)"]
["銷售量 (美元)",{"v":60000,"d":"60,000"},{"v":75000,"d":"75,000"},{"v":67710,"d":"67,710"},{"v":71610,"d":"71,610"},{"v":79920,"d":"79,920"},{"v":69720,"d":"69,720"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":70660,"d":"70,660"}}]
["應收帳款",{"v":45000,"d":"45,000"},{"v":15000,"d":"15,000"},{"v":26580,"d":"26,580"},{"v":31050,"d":"31,050"},{"v":53250,"d":"53,250"},{"v":25170,"d":"25,170"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":32675,"d":"32,675"}}]
["呆帳 (月底)",{"v":9000,"d":"9,000"},{"v":6000,"d":"6,000"},{"v":6750,"d":"6,750"},{"v":8070,"d":"8,070"},{"v":13440,"d":"13,440"},{"v":10770,"d":"10,770"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":9005,"d":"9,005"}}]
["現有存貨 (月底)",{"$nulls":7},{"$f":"30*EssencialOperatingData[[#This Row],[Column2]]","v":0},{"$nulls":5},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":0}]
["應付帳款 (月底)",{"$nulls":7},{"$f":"30*EssencialOperatingData[[#This Row],[Column2]]","v":0},{"$nulls":5},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":0}]
["折舊",{"$nulls":7},{"$f":"30*EssencialOperatingData[[#This Row],[Column2]]","v":0},{"$nulls":5},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":0}]

{"sheet":"現金流量摘要","index":1,"n_rows":27,"n_cols":11,"rows_kept":27}
{"$rows_empty":25}
[{"$nulls":9},"資料點：",5]
[null,null,"(拖曳上方的滑桿，即可變更圖表中的資料點總數。)"]