{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Dòng Tiền Mười hai Tháng","Tóm tắt Dòng Tiền"],"not_rendered":{"charts":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Dòng Tiền Mười hai Tháng","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]]}
[]
["Dòng Tiền Mười hai Tháng",{"$nulls":13},"Năm tài chính Bắt đầu:","2013-07-01"]
["Tên Công ty"]
["Địa chỉ, Thành phố, Bang, ZIP"]
["Điện thoại, Email, Web"]
[]
[null,"Bắt đầu",{"$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","Hàng tháng","Tổng quan"]
["Tóm tắt tiền mặt"]
["Tiền mặt tồn quỹ\n(bắt đầu tháng)",{"v":1144000000,"d":"1,144,000,000"},{"$f":"IF(Receipts[[#Totals],[Column3]]+PaidOut[[#Totals],[Column3]]=0,\"\",B11)","v":{"v":1405934400,"d":"1,405,934,400"}},{"$f":"IF(Receipts[[#Totals],[Column4]]+PaidOut[[#Totals],[Column4]]=0,\"\",C11)","v":{"v":1128712000,"d":"1,128,712,000"}},{"$f":"IF(Receipts[[#Totals],[Column5]]+PaidOut[[#Totals],[Column5]]=0,\"\",D11)","v":{"v":1159371200,"d":"1,159,371,200"}},{"$f":"IF(Receipts[[#Totals],[Column6]]+PaidOut[[#Totals],[Column6]]=0,\"\",E11)","v":{"v":1441232000,"d":"1,441,232,000"}},{"$f":"IF(Receipts[[#Totals],[Column7]]+PaidOut[[#Totals],[Column7]]=0,\"\",F11)","v":{"v":1364854400,"d":"1,364,854,400"}},{"$f":"IF(Receipts[[#Totals],[Column8]]+PaidOut[[#Totals],[Column8]]=0,\"\",G11)","v":""},{"$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":1300020800,"d":"1,300,020,800"}}]
["Tiền mặt có sẵn\n(tồn quỹ + biên nhận, trước khi rút tiền ra) ",{"$f":"SUM(B9,Receipts[[#Totals],[Column2]])","v":{"v":1405934400,"d":"1,405,934,400"}},{"$f":"IF(C9=\"\",\"\",SUM(C9,Receipts[[#Totals],[Column3]]))","v":{"v":1582152000,"d":"1,582,152,000"}},{"$f":"IF(D9=\"\",\"\",SUM(D9,Receipts[[#Totals],[Column4]]))","v":{"v":1732660800,"d":"1,732,660,800"}},{"$f":"IF(E9=\"\",\"\",SUM(E9,Receipts[[#Totals],[Column5]]))","v":{"v":1893465600,"d":"1,893,465,600"}},{"$f":"IF(F9=\"\",\"\",SUM(F9,Receipts[[#Totals],[Column6]]))","v":{"v":1864969600,"d":"1,864,969,600"}},{"$f":"IF(G9=\"\",\"\",SUM(G9,Receipts[[#Totals],[Column7]]))","v":{"v":1584960000,"d":"1,584,960,000"}},{"$f":"IF(H9=\"\",\"\",SUM(H9,Receipts[[#Totals],[Column8]]))","v":""},{"$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":1731641600,"d":"1,731,641,600"}}]
["Tình trạng tiền mặt\n(kết thúc tháng)",{"$f":"(B10-PaidOut[[#Totals],[Column2]])","v":{"v":1405934400,"d":"1,405,934,400"}},{"$f":"IFERROR(C10-PaidOut[[#Totals],[Column3]],\"\")","v":{"v":1128712000,"d":"1,128,712,000"}},{"$f":"IFERROR(D10-PaidOut[[#Totals],[Column4]],\"\")","v":{"v":1159371200,"d":"1,159,371,200"}},{"$f":"IFERROR(E10-PaidOut[[#Totals],[Column5]],\"\")","v":{"v":1441232000,"d":"1,441,232,000"}},{"$f":"IFERROR(F10-PaidOut[[#Totals],[Column6]],\"\")","v":{"v":1364854400,"d":"1,364,854,400"}},{"$f":"IFERROR(G10-PaidOut[[#Totals],[Column7]],\"\")","v":{"v":1069390400,"d":"1,069,390,400"}},{"$f":"IFERROR(H10-PaidOut[[#Totals],[Column8]],\"\")","v":""},{"$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":1232712000,"d":"1,232,712,000"}}]
[]
["Biên nhận Tiền mặt"]
["Doanh thu Tiền mặt",{"v":116812800,"d":"116,812,800"},{"v":80891200,"d":"80,891,200"},{"v":507748800,"d":"507,748,800"},{"v":658153600,"d":"658,153,600"},{"v":304657600,"d":"304,657,600"},{"v":63107200,"d":"63,107,200"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":322911680,"d":"322,911,680"}}]
["Khoảng thu từ các tài khoản CR",{"v":93558400,"d":"93,558,400"},{"v":72654400,"d":"72,654,400"},{"v":41329600,"d":"41,329,600"},{"v":21403200,"d":"21,403,200"},{"v":60548800,"d":"60,548,800"},{"v":88067200,"d":"88,067,200"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":56800640,"d":"56,800,640"}}]
["Vay/ tiền mặt khác",{"v":51563200,"d":"51,563,200"},{"v":22672000,"d":"22,672,000"},{"v":54870400,"d":"54,870,400"},{"v":54537600,"d":"54,537,600"},{"v":58531200,"d":"58,531,200"},{"v":68931200,"d":"68,931,200"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":51908480,"d":"51,908,480"}}]
["Tổng biên nhận tiền mặt",{"$f":"SUBTOTAL(109,Receipts[Column2])","v":{"v":261934400,"d":"261,934,400"}},{"$f":"SUBTOTAL(109,Receipts[Column3])","v":{"v":176217600,"d":"176,217,600"}},{"$f":"SUBTOTAL(109,Receipts[Column4])","v":{"v":603948800,"d":"603,948,800"}},{"$f":"SUBTOTAL(109,Receipts[Column5])","v":{"v":734094400,"d":"734,094,400"}},{"$f":"SUBTOTAL(109,Receipts[Column6])","v":{"v":423737600,"d":"423,737,600"}},{"$f":"SUBTOTAL(109,Receipts[Column7])","v":{"v":220105600,"d":"220,105,600"}},{"$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":179842000,"d":"179,842,000"}}]
[]
["Tiền mặt Chi Ra"]
["Các khoản mua (xác định)",null,{"v":10836800,"d":"10,836,800"},{"v":6718400,"d":"6,718,400"},{"v":5699200,"d":"5,699,200"},{"v":9380800,"d":"9,380,800"},{"v":2163200,"d":"2,163,200"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":6959680,"d":"6,959,680"}}]
["Tổng lương (khoản rút ra chính xác)",null,{"v":219897600,"d":"219,897,600"},{"v":301891200,"d":"301,891,200"},{"v":219668800,"d":"219,668,800"},{"v":273936000,"d":"273,936,000"},{"v":259542400,"d":"259,542,400"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":254987200,"d":"254,987,200"}}]
["Vật dụng (văn phòng & hoạt động)",null,{"v":5200000,"d":"5,200,000"},{"v":8902400,"d":"8,902,400"},{"v":3432000,"d":"3,432,000"},{"v":24294400,"d":"24,294,400"},{"v":7176000,"d":"7,176,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":9800960,"d":"9,800,960"}}]
["Sửa chữa & bảo trì",null,0,{"v":45760000,"d":"45,760,000"},{"v":3390400,"d":"3,390,400"},{"v":1393600,"d":"1,393,600"},0,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":10108800,"d":"10,108,800"}}]
["Quảng cáo",null,{"v":22880000,"d":"22,880,000"},{"v":13000000,"d":"13,000,000"},{"v":28204800,"d":"28,204,800"},0,{"v":53248000,"d":"53,248,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":23466560,"d":"23,466,560"}}]
["Tiền thuê",null,{"v":72800000,"d":"72,800,000"},{"v":72800000,"d":"72,800,000"},{"v":72800000,"d":"72,800,000"},{"v":72800000,"d":"72,800,000"},{"v":72800000,"d":"72,800,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":72800000,"d":"72,800,000"}}]
["Tiện ích",null,{"v":5928000,"d":"5,928,000"},{"v":6614400,"d":"6,614,400"},{"v":3140800,"d":"3,140,800"},{"v":2787200,"d":"2,787,200"},{"v":4742400,"d":"4,742,400"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":4642560,"d":"4,642,560"}}]
["Khác (xác định)",null,{"v":2558400,"d":"2,558,400"},{"v":4867200,"d":"4,867,200"},{"v":2558400,"d":"2,558,400"},{"v":4867200,"d":"4,867,200"},{"v":2558400,"d":"2,558,400"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":3481920,"d":"3,481,920"}}]
["Trả nợ vay gốc",null,{"v":83200000,"d":"83,200,000"},{"v":83200000,"d":"83,200,000"},{"v":83200000,"d":"83,200,000"},{"v":83200000,"d":"83,200,000"},{"v":83200000,"d":"83,200,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":83200000,"d":"83,200,000"}}]
["Chi phí vốn (xác định)",null,{"v":14123200,"d":"14,123,200"},{"v":14560000,"d":"14,560,000"},{"v":14123200,"d":"14,123,200"},{"v":13520000,"d":"13,520,000"},{"v":14123200,"d":"14,123,200"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":14089920,"d":"14,089,920"}}]
["Các chi phí thành lập khác",null,{"v":8320000,"d":"8,320,000"},{"v":7280000,"d":"7,280,000"},{"v":8320000,"d":"8,320,000"},{"v":6240000,"d":"6,240,000"},{"v":8320000,"d":"8,320,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":7696000,"d":"7,696,000"}}]
["Dự trữ và/hoặc Ký quỹ",null,{"v":6240000,"d":"6,240,000"},{"v":6240000,"d":"6,240,000"},{"v":6240000,"d":"6,240,000"},{"v":6240000,"d":"6,240,000"},{"v":6240000,"d":"6,240,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":6240000,"d":"6,240,000"}}]
["Chủ sở hữu rút tiền",null,{"v":1456000,"d":"1,456,000"},{"v":1456000,"d":"1,456,000"},{"v":1456000,"d":"1,456,000"},{"v":1456000,"d":"1,456,000"},{"v":1456000,"d":"1,456,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":1456000,"d":"1,456,000"}}]
["Tổng Tiền mặt Chi Ra",null,{"$f":"SUBTOTAL(109,PaidOut[Column3])","v":{"v":453440000,"d":"453,440,000"}},{"$f":"SUBTOTAL(109,PaidOut[Column4])","v":{"v":573289600,"d":"573,289,600"}},{"$f":"SUBTOTAL(109,PaidOut[Column5])","v":{"v":452233600,"d":"452,233,600"}},{"$f":"SUBTOTAL(109,PaidOut[Column6])","v":{"v":500115200,"d":"500,115,200"}},{"$f":"SUBTOTAL(109,PaidOut[Column7])","v":{"v":515569600,"d":"515,569,600"}},{"$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":207887333.33333334,"d":"207,887,333"}}]
[]
["Dữ liệu hoạt động cần thiết (thông tin dòng không phải tiền mặt)"]
["Doanh thu (đô-la)",{"v":41600000,"d":"41,600,000"},{"v":52000000,"d":"52,000,000"},{"v":46945600,"d":"46,945,600"},{"v":49649600,"d":"49,649,600"},{"v":55411200,"d":"55,411,200"},{"v":48339200,"d":"48,339,200"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":48990933.333333336,"d":"48,990,933"}}]
["Khoản phải Thu",{"v":31200000,"d":"31,200,000"},{"v":10400000,"d":"10,400,000"},{"v":18428800,"d":"18,428,800"},{"v":21528000,"d":"21,528,000"},{"v":36920000,"d":"36,920,000"},{"v":17451200,"d":"17,451,200"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":22654666.666666668,"d":"22,654,667"}}]
["Nợ xấu (cuối tháng)",{"v":6240000,"d":"6,240,000"},{"v":4160000,"d":"4,160,000"},{"v":4680000,"d":"4,680,000"},{"v":5595200,"d":"5,595,200"},{"v":9318400,"d":"9,318,400"},{"v":7467200,"d":"7,467,200"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":6243466.666666667,"d":"6,243,467"}}]
["Hàng tồn kho (eom)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["Khoản phải trả (eom)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["Khấu hao",{"$nulls":13},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]

{"sheet":"Tóm tắt Dòng Tiền","index":1,"n_rows":27,"n_cols":11,"rows_kept":27}
{"$rows_empty":25}
[{"$nulls":9},"Điểm Dữ liệu:",4]
[null,null,"(Kéo con trượt để thay đổi điểm dữ liệu được vẽ trên biểu đồ.)"]