{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["No discounts monthly-KH","Discounts monthly-KH","No discounts monthly-Eng","Discounts monthly_Eng"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"No discounts monthly-KH","index":0,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[11,3,11,12]]}
{"$rows_empty":9}
[null,null,"សេចក្តីណែនាំ","គោលបំណង៖ ដើម្បីជួយម្ចាស់អាជីវកម្មធ្វើការទស្សន៍ទាយថាតើពេលណាសាច់ប្រាក់ចូលហើយពេលណាសាច់ប្រាក់ចេញពីអាជីវកម្មរបស់អ្នក (លំហូរសាច់ប្រាក់)"]
[null,null,null,"បញ្ចូលទិន្នន័យនៅក្នុងតារាងដែលមានពណ៌ទឹកក្រូច (តារាងផ្សេងទៀតមានរូបមន្តរួចហើយហាមប៉ះពាល់)"]
[null,null,null,"ជំហានទី ១. បញ្ចូលចំនួនសាច់ប្រាក់ដែលអ្នកមានបច្ចុប្បន្ន (ជាសាច់ប្រាក់ដែលមានទាំងក្នុងដៃនិងគណនីធនាគាររបស់អ្នក) ក្នុងប្រអប់សមតុល្យសាច់ប្រាក់ (C17) ។ កុំបញ្ចូលសាច់ប្រាក់ណាមួយដែលអ្នកមិនទាន់មាន។ បញ្ជូលតែសាច់ប្រាក់ដែលអ្នកមានប៉ុណ្ណោះ"]
[null,null,null,"ជំហានទី ២. បញ្ចូលសាច់ប្រាក់ដែលអ្នករំពឹងទុកពីការលក់ (ជួរទី 22)"]
[null,null,null,"ជំហានទី ៣. បញ្ចូលការចំណាយដែលអ្នករំពឹងទុក (ក្រោម“ លំហូរសាច់ប្រាក់ចេញ” ជួរទី 24)"]
[null,null,null,"ជំហានទី ៤. នៅតារាងចុងក្រោយនឹងប្រាប់អ្នកថាតើអ្នកនៅ មានសាច់ប្រាក់នៅចុងខែ។ ប្រសិនបើវាជាពណ៌ក្រហមអ្នកត្រូវផ្លាស់ប្តូរអ្វីមួយ "]
[null,null,"ថ្ងៃទី","2020-07-07"]
[null,null,"សមតុល្យសាច់ប្រាក់",7000.0]
[]
[]
[{"$nulls":4},{"$f":"D16+7","v":"2020-07-14"},{"$f":"E20+7","v":"2020-07-21"},"2020-07-28","2020-08-04","2020-08-11","2020-08-18","2020-08-25","2020-09-01","2020-09-08"]
[null,null,"លំហូរសាច់ប្រាក់ចូល"]
[null,null,null,"ការរំពឹងទុកពីការលក់",1000.0,1000.0,1000.0,750.0,750.0,750.0,750.0,750.0,750.0]
[]
[null,null,"លំហូរសាច់ប្រាក់ចេញ"]
[null,null,null,"ចំណាយថ្លៃដើម (អ្នកផ្គត់ផ្គង់)",0.0,4000.0,0.0,0.0,0.0,1500.0,0.0,0.0,0.0]
[null,null,null,"ជួល",0.0,0.0,0.0,1000.0,0.0,0.0,0.0,1000.0,0.0]
[null,null,null,"ប្រាក់ខែ",1500.0,0.0,0.0,1500.0,0.0,1500.0,0.0,1500.0,0.0]
[null,null,null,"ទឹកភ្លើង",0.0,0.0,0.0,1000.0,0.0,0.0,0.0,500.0,0.0]
[null,null,null,"ចំណាាយក្នុងការិយាល័យ",25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0]
[null,null,null,"ចំណាយផ្សេងៗ",15.0,15.0,15.0,15.0,15.0,15.0,15.0,15.0,15.0]
[null,null,null,"ពន្ធ",0.0,1000.0,0.0,0.0,0.0,0.0,750.0,0.0,0.0]
[null,null,"សរុបលំហូរសាច់ប្រាក់ចេញ",null,{"$f":"SUM(E25:E31)","v":1540},5040,40,3540,40,3040,790,3040,40]
[]
[null,null,"លំហូរសាច់ប្រាក់ចុងគ្រា",null,{"$f":"E22-E32","v":-540},-4040,960,-2790,710,-2290,-40,-2290,710]
[]
[null,null,"សរុុបសាច់ប្រាក់ដែលមាន",null,{"$f":"D17+E34","v":6460},{"$f":"E36+F34","v":2420},3380,590,1300,-990,-1030,-3320,-2610]
[]
[]
[]
[null,null,"Powered By"]

{"sheet":"Discounts monthly-KH","index":1,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[11,3,11,12],[12,3,12,12]]}
{"$rows_empty":9}
[null,null,"សេចក្តីណែនាំ","គោលបំណង៖ ដើម្បីជួយម្ចាស់អាជីវកម្មធ្វើការទស្សន៍ទាយថាតើពេលណាសាច់ប្រាក់ចូលហើយពេលណាសាច់ប្រាក់ចេញពីអាជីវកម្មរបស់អ្នក (លំហូរសាច់ប្រាក់)"]
[null,null,null,"បញ្ចូលទិន្នន័យនៅក្នុងតារាងដែលមានពណ៌ទឹកក្រូច (តារាងផ្សេងទៀតមានរូបមន្តរួចហើយហាមប៉ះពាល់)"]
[null,null,null,"ជំហានទី ១. បញ្ចូលចំនួនសាច់ប្រាក់ដែលអ្នកមានបច្ចុប្បន្ន (ជាសាច់ប្រាក់ដែលមានទាំងក្នុងដៃនិងគណនីធនាគាររបស់អ្នក) ក្នុងប្រអប់សមតុល្យសាច់ប្រាក់ (D19) ។ កុំបញ្ចូលសាច់ប្រាក់ណាមួយដែលអ្នកមិនទាន់មាន។ បញ្ជូលតែសាច់ប្រាក់ដែលអ្នកមានប៉ុណ្ណោះ"]
[null,null,null,"ជំហានទី ២. តើអ្នករំពឹងថានឹងទទួលបានការបញ្ចុះតម្លៃ លើការចំណាយបច្ចុប្បន្នរបស់អ្នកទេ? (តើម្ចាស់ផ្ទះរបស់អ្នកនឹងផ្តល់ឱ្យអ្នកនូវការបញ្ចុះតម្លៃ 50% ក្នុងកំឡុងពេល Covide-19 ដែរឬទេ? ប្រសិនបើដូច្នេះសូមធ្វើបច្ចុប្បន្នភាព \"ការកាត់បន្ថយចំណាយដែលរំពឹងទុក\" ជាមួយនឹងការបញ្ចុះតម្លៃដែលអ្នករំពឹងថានឹងទទួលបាន (ជួរទី 21)"]
[null,null,null,"ជំហានទី ៣. បញ្ចូលសាច់ប្រាក់ដែលអ្នករំពឹងទុកពីការលក់ (ជួរទី ១៨)"]
[null,null,null,"ជំហានទី ៤. បញ្ចូលការចំណាយដែលអ្នករំពឹងទុក (ក្រោម“ លំហូរសាច់ប្រាក់ចេញ” ជួរទី 26)"]
[null,null,null,"ជំហានទី ៥. នៅតារាងចុងក្រោយនឹងប្រាប់អ្នកថាតើអ្នកនៅ មានសាច់ប្រាក់នៅចុងខែ។ ប្រសិនបើវាជាពណ៌ក្រហមអ្នកត្រូវផ្លាស់ប្តូរអ្វីមួយ "]
[]
[null,null,"ថ្ងៃទី","2020-07-07"]
[null,null,"សមតុល្យសាច់ប្រាក់",7000.0]
[]
[null,null,"ការរំពឹងនៃការកាត់បន្ថយចំណាយ","ជួល",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.3]
[null,null,null,"ប្រាក់ខែ",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.3]
[]
[{"$nulls":4},{"$f":"D18+7","v":"2020-07-14"},{"$f":"E24+7","v":"2020-07-21"},"2020-07-28","2020-08-04","2020-08-11","2020-08-18","2020-08-25","2020-09-01","2020-09-08"]
[null,null,"លំហូរសាច់ប្រាក់ចូល"]
[null,null,null,"ការរំពឹងទុកពីការលក់",1000.0,1000.0,1000.0,750.0,750.0,750.0,750.0,750.0,750.0]
[]
[null,null,"លំហូរសាច់ប្រាក់ចេញ"]
[null,null,null,"ចំណាយថ្លៃដើម (អ្នកផ្គត់ផ្គង់)",0.0,4000.0,0.0,0.0,0.0,1500.0,0.0,0.0,0.0]
[null,null,null,"ជួល",0.0,0.0,0.0,1000.0,0.0,0.0,0.0,1000.0,0.0]
[null,null,null,"ប្រាក់ខែ",1500.0,0.0,0.0,1500.0,0.0,1500.0,0.0,1500.0,0.0]
[null,null,null,"ទឹកភ្លើង",0.0,0.0,0.0,1000.0,0.0,0.0,0.0,500.0,0.0]
[null,null,null,"ចំណាាយក្នុងការិយាល័យ",25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0]
[null,null,null,"ចំណាយផ្សេងៗ",15.0,15.0,15.0,15.0,15.0,15.0,15.0,15.0,15.0]
[null,null,null,"ពន្ធ",0.0,1000.0,0.0,0.0,0.0,0.0,1000.0,0.0,0.0]
[null,null,"សរុបលំហូរសាច់ប្រាក់ចេញ",null,{"$f":"SUM(E29:E35)","v":1540},5040,40,3540,40,3040,1040,3040,40]
[]
[null,null,"រំពឹងពីការសន្សំ","ជួល",{"$f":"E21*E30","v":0},0,0,500,0,0,0,500,0]
[null,null,null,"ប្រាក់ខែ",{"$f":"E22*E31","v":750},0,0,750,0,750,0,750,0]
[null,null,null,"សរុប",{"$f":"SUM(E38:E39)","v":750},0,0,1250,0,750,0,1250,0]
[]
[null,null,"លំហូរសាច់ប្រាក់ចេញ ថ្មី",null,{"$f":"E36-E40","v":790},5040,40,2290,40,2290,1040,1790,40]
[]
[null,null,"លំហូរសាច់ប្រាក់ចុងគ្រា",null,{"$f":"E26-E42","v":210},-4040,960,-1540,710,-1540,-290,-1040,710]
[]
[null,null,"សរុុបសាច់ប្រាក់ដែលមាន",null,{"$f":"D19+E44","v":7210},{"$f":"E46+F44","v":3170},4130,2590,3300,1760,1470,430,1140]
[]
[]
[]
[]
[null,null,"Powered By"]

{"sheet":"No discounts monthly-Eng","index":2,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":9}
[null,null,"Instructions","Purpose: To help you predict when cash comes IN and when it goes OUT of your business (cash-flow)"]
[null,null,null,"Only enter data in the Dark Green  cells (all other cells have formulas already)"]
[null,null,null,"Step 1. Enter how much cash you currently have (in cash and in your bank account) in the cash balance box ( E8 ).  Do not input any cash that you do not already have. Only EXISTING money. "]
[null,null,null,"2. Enter your expected cash (money that you expect to receive from sales) ( row 13 )"]
[null,null,null,"3. Enter your expected expenses ( under \"Cash Outflows\", row 19 )"]
[null,null,null,"4. The last line will tell you if you will still have cash at the end of the month.  If it is RED then you need to change something -  Go to the next tab, \"Discounts Monthly\" "]
[]
[null,null,"Date","2020-07-07"]
[null,null,"Cash Balance",7000.0]
[]
[]
[{"$nulls":4},{"$f":"D17+7","v":"2020-07-14"},{"$f":"E21+7","v":"2020-07-21"},"2020-07-28","2020-08-04","2020-08-11","2020-08-18","2020-08-25","2020-09-01","2020-09-08"]
[null,null,"Cash Inflows"]
[null,null,null,"Expected Sales",1000.0,1000.0,1000.0,750.0,750.0,750.0,750.0,750.0,750.0]
[]
[null,null,"Cash Outflows"]
[null,null,null,"Cost of Goods Sold (suppliers)",0.0,4000.0,0.0,0.0,0.0,1500.0,0.0,0.0,0.0]
[null,null,null,"Rent",0.0,0.0,0.0,1000.0,0.0,0.0,0.0,1000.0,0.0]
[null,null,null,"Staff Salaries",1500.0,0.0,0.0,1500.0,0.0,1500.0,0.0,1500.0,0.0]
[null,null,null,"Utilities",0.0,0.0,0.0,1000.0,0.0,0.0,0.0,500.0,0.0]
[null,null,null,"Office/Shopfront expenses",25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0]
[null,null,null,"Other expenses",15.0,15.0,15.0,15.0,15.0,15.0,15.0,15.0,15.0]
[null,null,null,"Tax",0.0,1000.0,0.0,0.0,0.0,0.0,750.0,0.0,0.0]
[null,null,"Total Outflows",null,{"$f":"SUM(E26:E32)","v":1540},5040,40,3540,40,3040,790,3040,40]
[]
[null,null,"Cashflow for period",null,{"$f":"E23-E33","v":-540},-4040,960,-2790,710,-2290,-40,-2290,710]
[]
[null,null,"Total Cash Remaining",null,{"$f":"D18+E35","v":6460},{"$f":"E37+F35","v":2420},3380,590,1300,-990,-1030,-3320,-2610]
[]
[]
[]
[null,null,"Powered By"]

{"sheet":"Discounts monthly_Eng","index":3,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":9}
[null,null,"Instructions","Purpose: To help you predict when cash comes IN and when it goes OUT of your business (cash-flow)"]
[null,null,null,"Only enter data in the Dark Green cells (all other cells have formulas already)"]
[null,null,null,"Step 1. Enter how much cash you currently have (in cash and in your bank account) in the cash balance box ( E8 ).  Do not input any cash that you do not already have. Only EXISTING money. "]
[null,null,null,"2. Do you expect to get some expected discounts on your current expenses?  (e.g. will your landlord give you a 50% discount during COVID-19)?  If so, update the \"Expected Cost Reduction\" rows with the discount you expect to get ( row 12 )"]
[null,null,null,"3. Enter your expected cash (money that you expect to receive from sales) ( row 13 )"]
[null,null,null,"4. Enter your expected expenses ( under \"Cash Outflows\", row 19 )"]
[null,null,null,"5. The last line will tell you if you will still have cash at the end of the month.  If it is RED then you need to change something (reduce expenses further)"]
[]
[null,null,"Date","2020-07-07"]
[null,null,"Cash Balance",7000.0]
[]
[null,null,"Expected Cost Reductions","Rent",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.3]
[null,null,null,"Salaries",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.3]
[]
[{"$nulls":4},{"$f":"D18+7","v":"2020-07-14"},{"$f":"E24+7","v":"2020-07-21"},"2020-07-28","2020-08-04","2020-08-11","2020-08-18","2020-08-25","2020-09-01","2020-09-08"]
[null,null,"Cash Inflows"]
[null,null,null,"Expected Sales",1000.0,1000.0,1000.0,750.0,750.0,750.0,750.0,750.0,750.0]
[]
[null,null,"Cash Outflows"]
[null,null,null,"Cost of Goods Sold (suppliers)",0.0,4000.0,0.0,0.0,0.0,1500.0,0.0,0.0,0.0]
[null,null,null,"Rent",0.0,0.0,0.0,1000.0,0.0,0.0,0.0,1000.0,0.0]
[null,null,null,"Staff Salaries",1500.0,0.0,0.0,1500.0,0.0,1500.0,0.0,1500.0,0.0]
[null,null,null,"Utilities",0.0,0.0,0.0,1000.0,0.0,0.0,0.0,500.0,0.0]
[null,null,null,"Office/Shopfront expenses",25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0]
[null,null,null,"Other expenses",15.0,15.0,15.0,15.0,15.0,15.0,15.0,15.0,15.0]
[null,null,null,"Tax",0.0,1000.0,0.0,0.0,0.0,0.0,1000.0,0.0,0.0]
[null,null,"Total Outflows",null,{"$f":"SUM(E29:E35)","v":1540},5040,40,3540,40,3040,1040,3040,40]
[]
[null,null,"Expected Savings","Rent",{"$f":"E21*E30","v":0},0,0,500,0,0,0,500,0]
[null,null,null,"Salaries",{"$f":"E22*E31","v":750},0,0,750,0,750,0,750,0]
[null,null,null,"Total",{"$f":"SUM(E38:E39)","v":750},0,0,1250,0,750,0,1250,0]
[]
[null,null,"New Outflows",null,{"$f":"E36-E40","v":790},5040,40,2290,40,2290,1040,1790,40]
[]
[null,null,"Cashflow for period",null,{"$f":"E26-E42","v":210},-4040,960,-1540,710,-1540,-290,-1040,710]
[]
[null,null,"Total Cash Remaining",null,{"$f":"D19+E44","v":7210},{"$f":"E46+F44","v":3170},4130,2590,3300,1760,1470,430,1140]
[]
[]
[]
[]
[null,null,"Powered By"]