{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["How To Use","0- Financial Projection","1- Cost of production","2- Sales ","3- Salary","4- Set-Up Costs","5- Set-Up Capital"],"not_rendered":{"charts":0,"images":0,"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":"How To Use","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[8,5,8,9],[9,1,9,9],[10,1,10,9],[14,1,14,9],[0,1,0,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,5,7,9]]}
[null,"Financial projection template by Impact Hub Phnom Penh / គំរូព្យាករណ៍ហិរញ្ញវត្ថុដោយ Impact Hub ភ្នំពេញ"]
[]
[null,"This financial teamplate will help you with the following: / តារាងក្រុមហិរញ្ញវត្ថុនេះនឹងជួយអ្នកដូចខាងក្រោម៖"]
[null,"Understand the cost of running your business\nស្វែងយល់ពីគម្រោងចំណាយនៃដំណើរការអាជីវកម្មរបស់អ្នក\n\nTest different pricing scenario (to make sure it would cover the fix costs)\nសាកល្បងសេណារីយ៉ូកំណត់តម្លៃផ្សេងៗគ្នា (ដើម្បីប្រាកដថាវាអាចទូទាត់ជាមួយចំណាយទូទៅបាន)\n\nEstimate when you would be able to reach the break-even point (the time when you Start making profits)\nប៉ាន់ស្មានថាពេលណាអ្នកនឹងអាចឈានដល់ចំណុចដែលចំណូលផលិតកម្មសរុបស្មើនឹងថ្លៃដើមផលិតកម្មសរុប (ពេលវេលាដែលអ្នកចាប់ផ្តើមរកប្រាក់ចំណេញ)\n\nEstimate the cost of setting up your business and how much capital you would need to put to get started\nប៉ាន់ប្រមាណគម្រោងចំណាយនៃការបង្កើតអាជីវកម្មរបស់អ្នកនិងថាតើអ្នកត្រូវការដើមទុនប៉ុន្មានដើម្បីចាប់ផ្តើម"]
[]
[null,"How to use it? / តើត្រូវប្រើវាដោយរបៀបណា?"]
[null,"Select \"File\" and \"Make a copy\" of the document in order to be able to edit the file.\nជ្រើសរើស“ ឯកសារ” និង“ចម្លង” ឯកសារដើម្បីអាចកែសម្រួលឯកសារនេះបានពេលក្រោយ។\n\nGet familiar with each of the tabs\nស្គាល់ផ្ទាំងនីមួយឲ្យហើយ"]
[null,"Start inputting the missing cost on the yellow \n ចាប់ផ្តើមបញ្ចូលថ្លៃដើមដែលបាត់នៅលើ ប្រអប់ពណ៌លឿង"]
[null,"DO NOT edit\nហាមកែប្រែ លើពណ៌នេះ",null,"or \nឬ ពណ៌នេះ",null,"cells, as it countains a formula that will be automatically calculated\n ព្រោះវាមានរូបមន្តដែលត្រូវគណនាដោយស្វ័យប្រវត្តិ"]
[null,"Add as many lines as you wants, depending on the number of products you have. Make sure you add the right formula on the new lines\nបន្ថែមបន្ទាត់ប៉ុន្មានជួរក៏បានដែរបតាមដែលអ្នកចង់បាន អាស្រ័យលើចំនួនផលិតផលដែលអ្នកមាន។ ត្រូវប្រាកដថាអ្នកបន្ថែមរូបមន្តត្រឹមត្រូវនៅលើបន្ទាត់ថ្មី"]
[null,"Test different scenario of pricing strategy to find the best one that would cover your cost of operations\nសាកល្បងសេណារីយ៉ូផ្សេងៗគ្នានៃយុទ្ធសាស្រ្តកំណត់តម្លៃដើម្បីស្វែងរកអ្វីដែលល្អបំផុតដែលអាចចំណាយលើប្រតិបត្តិការរបស់អ្នក"]
[]
[]
[]
[null,"This template was designed by Impact Hub Phnom Penh with the support from Rithy San, Managing Director of Acclime. \n គម្រូរនេះត្រូវបានរចនាឡើងដោយ Impact Hub Phnom Penh ដោយមានការគាំទ្រពីលោករិទ្ធីសាននាយកគ្រប់គ្រងក្រុមហ៊ុន Acclime ។"]

{"sheet":"0- Financial Projection","index":1,"n_rows":39,"n_cols":37,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,1,2,12],[2,13,2,24],[2,25,2,36]]}
["Company Name / ឈ្មោះ​ក្រុម​ហ៊ុន"]
["By: / ដោយ៖"]
[null,"Year 2025",{"$nulls":11},"Year 2026",{"$nulls":11},"Year 2027"]
["Revenue projections / ការព្យាករណ៍ប្រាក់ចំណូល","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
["Total sales of products / ការលក់ផលិតផលសរុប",{"$f":"'2- Sales '!G19","v":0},{"$f":"'2- Sales '!H19","v":0},{"$f":"'2- Sales '!I19","v":0},{"$f":"'2- Sales '!J19","v":0},{"$f":"'2- Sales '!K19","v":0},{"$f":"'2- Sales '!L19","v":0},{"$f":"'2- Sales '!M19","v":0},{"$f":"'2- Sales '!N19","v":0},{"$f":"'2- Sales '!O19","v":0},{"$f":"'2- Sales '!P19","v":0},{"$f":"'2- Sales '!Q19","v":0},{"$f":"'2- Sales '!R19","v":0},{"$f":"'2- Sales '!S19","v":0},{"$f":"'2- Sales '!T19","v":0},{"$f":"'2- Sales '!U19","v":0},{"$f":"'2- Sales '!V19","v":0},{"$f":"'2- Sales '!W19","v":0},{"$f":"'2- Sales '!X19","v":0},{"$f":"'2- Sales '!Y19","v":0},{"$f":"'2- Sales '!Z19","v":0},{"$f":"'2- Sales '!AA19","v":0},{"$f":"'2- Sales '!AB19","v":0},{"$f":"'2- Sales '!AC19","v":0},{"$f":"'2- Sales '!AD19","v":0},{"$f":"'2- Sales '!AE19","v":0},{"$f":"'2- Sales '!AF19","v":0},{"$f":"'2- Sales '!AG19","v":0},{"$f":"'2- Sales '!AH19","v":0},{"$f":"'2- Sales '!AI19","v":0},{"$f":"'2- Sales '!AJ19","v":0},{"$f":"'2- Sales '!AK19","v":0},{"$f":"'2- Sales '!AL19","v":0},{"$f":"'2- Sales '!AM19","v":0},{"$f":"'2- Sales '!AN19","v":0},{"$f":"'2- Sales '!AO19","v":0},{"$f":"'2- Sales '!AP19","v":0}]
[]
[]
["Total revenues / ចំណូលសរុប",{"$f":"SUM(B5:B7)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"sum(N5:N7)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Z5:Z7)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["External Capital injected\nដើមទុនខាងក្រៅដែលបានដាក់បញ្ចូល",{"$f":"'5- Set-Up Capital'!C18","v":0}]
[]
[]
["Variable Cost ថ្លៃដើមអថេរ"]
["Total Cost of Production - Products\nថ្លៃដើមផលិតកម្មសរុប - ផលិតផល",{"$f":"'2- Sales '!G27","v":0},{"$f":"'2- Sales '!H27","v":0},{"$f":"'2- Sales '!I27","v":0},{"$f":"'2- Sales '!J27","v":0},{"$f":"'2- Sales '!K27","v":0},{"$f":"'2- Sales '!L27","v":0},{"$f":"'2- Sales '!M27","v":0},{"$f":"'2- Sales '!N27","v":0},{"$f":"'2- Sales '!O27","v":0},{"$f":"'2- Sales '!P27","v":0},{"$f":"'2- Sales '!Q27","v":0},{"$f":"'2- Sales '!R27","v":0},{"$f":"'2- Sales '!S27","v":0},{"$f":"'2- Sales '!T27","v":0},{"$f":"'2- Sales '!U27","v":0},{"$f":"'2- Sales '!V27","v":0},{"$f":"'2- Sales '!W27","v":0},{"$f":"'2- Sales '!X27","v":0},{"$f":"'2- Sales '!Y27","v":0},{"$f":"'2- Sales '!Z27","v":0},{"$f":"'2- Sales '!AA27","v":0},{"$f":"'2- Sales '!AB27","v":0},{"$f":"'2- Sales '!AC27","v":0},{"$f":"'2- Sales '!AD27","v":0},{"$f":"'2- Sales '!AE27","v":0},{"$f":"'2- Sales '!AF27","v":0},{"$f":"'2- Sales '!AG27","v":0},{"$f":"'2- Sales '!AH27","v":0},{"$f":"'2- Sales '!AI27","v":0},{"$f":"'2- Sales '!AJ27","v":0},{"$f":"'2- Sales '!AK27","v":0},{"$f":"'2- Sales '!AL27","v":0},{"$f":"'2- Sales '!AM27","v":0},{"$f":"'2- Sales '!AN27","v":0},{"$f":"'2- Sales '!AO27","v":0},{"$f":"'2- Sales '!AP27","v":0}]
[]
[]
["Fix Cost / ចំណាយទូទៅ"]
["- Salary / - ប្រាក់ខែ",{"$f":"'3- Salary'!B12","v":0},{"$f":"'3- Salary'!C12","v":0},{"$f":"'3- Salary'!D12","v":0},{"$f":"'3- Salary'!E12","v":0},{"$f":"'3- Salary'!F12","v":0},{"$f":"'3- Salary'!G12","v":0},{"$f":"'3- Salary'!H12","v":0},{"$f":"'3- Salary'!I12","v":0},{"$f":"'3- Salary'!J12","v":0},{"$f":"'3- Salary'!K12","v":0},{"$f":"'3- Salary'!L12","v":0},{"$f":"'3- Salary'!M12","v":0},{"$f":"'3- Salary'!N12","v":0},{"$f":"'3- Salary'!O12","v":0},{"$f":"'3- Salary'!P12","v":0},{"$f":"'3- Salary'!Q12","v":0},{"$f":"'3- Salary'!R12","v":0},{"$f":"'3- Salary'!S12","v":0},{"$f":"'3- Salary'!T12","v":0},{"$f":"'3- Salary'!U12","v":0},{"$f":"'3- Salary'!V12","v":0},{"$f":"'3- Salary'!W12","v":0},{"$f":"'3- Salary'!X12","v":0},{"$f":"'3- Salary'!Y12","v":0},{"$f":"'3- Salary'!Z12","v":0},{"$f":"'3- Salary'!AA12","v":0},{"$f":"'3- Salary'!AB12","v":0},{"$f":"'3- Salary'!AC12","v":0},{"$f":"'3- Salary'!AD12","v":0},{"$f":"'3- Salary'!AE12","v":0},{"$f":"'3- Salary'!AF12","v":0},{"$f":"'3- Salary'!AG12","v":0},{"$f":"'3- Salary'!AH12","v":0},{"$f":"'3- Salary'!AI12","v":0},{"$f":"'3- Salary'!AJ12","v":0},{"$f":"'3- Salary'!AK12","v":0}]
["- Rent / - ថ្លៃជួល",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["- Electricity​ / - ថ្លៃភ្លើងអគ្គិសនី",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["- Internet / - ថ្លៃអ៊ីនធឺណិត",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["- Water / - ថ្លៃទឹក",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["- Cleaning ថ្លៃសំអាត",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["- Boost Facebook posts - ថ្លៃផ្សព្វផ្សាយទំព័រហ្វេសប៊ុក",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["- Others ថ្លៃចំណាយផ្សេងៗ",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[]
[]
[]
["Capital Expenditure / ការចំណាយដើមទុន"]
["Renovation / ការជួសជុលឡើងវិញ",{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0},{"$f":"'4- Set-Up Costs'!$K$17","v":0}]
["Machinery / គ្រឿងម៉ាស៊ីន",{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0},{"$f":"'4- Set-Up Costs'!$S$17","v":0}]
["Equipment / ឧបករណ៍",{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0},{"$f":"'4- Set-Up Costs'!$Z$17","v":0}]
["Vehicles / យានជំនិះ",{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0},{"$f":"'4- Set-Up Costs'!$AG$17","v":0}]
[]
[]
["Total expenses ការចំណាយសរុប",{"$f":"SUM(B13:B36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Monthly Profit / Loss\nប្រាក់ចំណេញ / ប្រាកខាតបង់ប្រចាំខែ",{"$f":"B8+B10-B37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"1- Cost of production","index":2,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,10],[6,0,6,3]]}
["Cost of production​ / ថ្លៃដើមផលិតកម្ម"]
["1- List down all the raw materials required to make one product \n១- រាយឈ្មោះវត្ថុធាតុដើមទាំងអស់ដែលត្រូវការដើម្បីបង្កើតផលិតផលមួយ"]
["2- Add as many table as you have products \n២- បន្ថែមតារាងប៉ុន្មានក៏បានតាមផលិតផលដែលអ្នកមាន"]
["3- Only add cost of labor if you pay people by product. If you pay a monthly salary, don't add any labor cost here, but enter it on the \"Salary\" tab.\n៣- បន្ថែមថ្លៃដើមពលកម្មតែប៉ុណ្ណោះ ប្រសិនបើអ្នកបង់ប្រាក់ឱ្យមនុស្សតាមផលិតផល។ ប្រសិនបើអ្នកបង់ប្រាក់ប្រចាំខែ កុំបន្ថែមថ្លៃពលកម្មនៅទីនេះ ប៉ុន្តែបញ្ចូលវានៅលើផ្ទាំង“ ប្រាក់ខែ” ។"]
["The cost per product will appear automatically on the \"Sales\" Tab​\nថ្លៃដើមផលិតផលនីមួយៗនឹងលេចឡើងដោយស្វ័យប្រវត្តិនៅលើផ្ទាំង“ លក់”"]
[]
["Compost",{"$nulls":4},"Cost of production Product 2 / ថ្លៃដើមនៃផលិតផល ២",{"$nulls":4},"Cost of production Product 3 / ថ្លៃដើមនៃផលិតផល ៣",{"$nulls":4},"Cost of production Product 4"]
[null,"Cost per unit\nថ្លៃដើមក្នុងមួយឯកតា","# of unit required\n# ឯកតាដែលត្រូវការ","Total cost \nការចំណាយសរុប",null,null,"Cost per unit\nថ្លៃដើមក្នុងមួយឯកតា","# of unit required\n# ឯកតាដែលត្រូវការ","Total cost \nការចំណាយសរុប",null,null,"Cost per unit\nថ្លៃដើមក្នុងមួយឯកតា","# of unit required\n# ឯកតាដែលត្រូវការ","Total cost \nការចំណាយសរុប",null,null,"Cost per unit","# of unit required","Total cost "]
["- Raw material 1\n- វត្ថុធាតុដើម ១",null,null,{"$f":"B9*C9","v":0},null,"- Raw material 1\n- វត្ថុធាតុដើម ១",null,null,{"$f":"G9*H9","v":0},null,"- Raw material 1\n- វត្ថុធាតុដើម ១",null,null,{"$f":"L9*M9","v":0},null,"- Raw material 1",null,null,{"$f":"Q9*R9","v":0}]
["- Raw Material 2\n- វត្ថុធាតុដើម ២",null,null,0,null,"- Raw Material 2\n- វត្ថុធាតុដើម ២",null,null,0,null,"- Raw Material 2\n- វត្ថុធាតុដើម ២",null,null,0,null,"- Raw Material 2",null,null,0]
[null,null,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0]
[null,null,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0]
[null,null,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0]
[null,null,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0]
[null,null,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0]
[null,null,null,0,{"$nulls":4},0,{"$nulls":4},0,{"$nulls":4},0]
["Total Cost of Production Product 1\nការចំណាយសរុបនៃផលិតផលផលិតកម្ម ១",null,null,{"$f":"sum(D9:D16)","v":0},null,"Total Cost of Production Product 2\nការចំណាយសរុបនៃផលិតផលផលិតកម្ម ២",null,null,{"$f":"SUM(I9:I16)","v":0},null,"Total Cost of Production Product 3\nការចំណាយសរុបនៃផលិតផលផលិតកម្ម ៣",null,null,{"$f":"SUM(N9:N16)","v":0},null,"Total Cost of Production Product 4",null,null,{"$f":"SUM(S9:S16)","v":0}]

{"sheet":"2- Sales ","index":3,"n_rows":94,"n_cols":42,"rows_kept":94,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[5,6,5,17],[5,18,5,29],[5,30,5,41]]}
["1- Rename \"Product 1\" with the name of your products / \n១- ប្តូរឈ្មោះ“ ផលិតផល ១” ដោយដាក់ឈ្មោះផលិតផលរបស់អ្នកវិញ"]
["2- Add as many line as you have products​\n២- បន្ថែមជួរប៉ុន្មានក៏បានតាមផលិតផលដែលអ្នកមាន"]
["3- Estimate the number of order per product per month \n៣- ប៉ាន់ស្មានចំនួនការបញ្ជាទិញក្នុងមួយផលិតផលក្នុងមួយខែ"]
["4- Estimate the Price to sell to the public \n៤- ប៉ាន់ប្រមាណតម្លៃដែលត្រូវលក់ជាសាធារណៈ"]
[]
[{"$nulls":6},"Year 2021",{"$nulls":11},"Year 2022",{"$nulls":11},"Year 2023"]
["Product description\nពណ៌នា​ពី​ផលិតផល","Cost of production\nថ្លៃដើមផលិតកម្ម","Price to the public\nតម្លៃជាសាធារណៈ",null,null,"Expected Order By product\nការបញ្ជាទិញតាមការរំពឹងទុក","Month 1","Month 2 ","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Month 1","Month 2 ","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Month 1","Month 2 ","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
["Product 1\nផលិតផល ១",{"$f":"'1- Cost of production'!D17","v":0},null,null,null,"Product 1\nផលិតផល ១"]
["Product 2\nផលិតផល ២",{"$f":"'1- Cost of production'!I17","v":0},null,null,null,"Product 2\nផលិតផល ២"]
["Product 3\nផលិតផល ៣",{"$f":"'1- Cost of production'!N17","v":0},null,null,null,"Product 3\nផលិតផល ៣"]
["Product 4\nផលិតផល ៤",{"$f":"'1- Cost of production'!S17","v":0},null,null,null,"Product 4\nផលិតផល ៤"]
[]
[]
[{"$nulls":5},"Expected Revenue/product\nចំណូល/ផលិតផលរំពឹងទុក"]
[{"$nulls":5},"Product 1\nផលិតផល ១",{"$f":"$C$8*G8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Product 2\nផលិតផល ២",{"$f":"$C$9*G9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Product 3\nផលិតផល ៣",{"$f":"$C$10*G10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Product 4\nផលិតផល ៤",{"$f":"$C$11*G11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Total expected revenue\nចំណូលរំពឹងទុកសរុប",{"$f":"sum(G15:G18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[{"$nulls":5},"Expected Cost/product\nថ្លៃដើម ឬ ផលិតផលរំពឹងទុក"]
[{"$nulls":5},"Product 1\nផលិតផល ១",{"$f":"$B$8*G8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Product 2\nផលិតផល ២",{"$f":"$B$9*G9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Product 3\nផលិតផល ៣",{"$f":"$B$10*G10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Product 4\nផលិតផល ៤",{"$f":"$B$11*G11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Total expected cost\nការចំណាយរំពឹងទុកសរុប",{"$f":"sum(G23:G26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
{"$rows_empty":63}
[{"$nulls":5},"Total ",{"$f":"sum(G15:G90)","v":0},{"$f":"sum(H55:H90)","v":0},0,0]
[]
[{"$nulls":5},"Expected Expenses/product"]
[{"$nulls":5},"Bags water hyacinth",{"$f":"B8*G8","v":0}]

{"sheet":"3- Salary","index":4,"n_rows":12,"n_cols":37,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,12],[1,13,1,24],[1,25,1,36]]}
["Insert the name/ position of the staff + their monthly salary \nបញ្ចូលឈ្មោះ/ មុខតំណែងរបស់បុគ្គលិក + ប្រាក់ខែប្រចាំខែរបស់ពួកគេ"]
[null,"Year 2025",{"$nulls":11},"Year 2026",{"$nulls":11},"Year 2027"]
["Salary​​ / ប្រាក់ខែ","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
{"$rows_empty":8}
["Total / សរុប",{"$f":"sum(B4:B11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"4- Set-Up Costs","index":5,"n_rows":32,"n_cols":33,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,2],[13,1,13,2],[21,1,21,2],[27,1,27,2]]}
["Write here the Set Up Cost \nសរសេរ កំណត់ថ្លៃដើម នៅទីនេះ",{"$nulls":4},"Write here all the cost of each of your machinery\nសរសេរនៅទីនេះការចំណាយទាំងអស់នៃគ្រឿងម៉ាស៊ីនរបស់អ្នក"]
["The cost to Set Up the business are written for reference only. \nថ្លៃដើមដើម្បីបង្កើតអាជីវកម្ម គឺសរសេរសម្រាប់ជាឯកសារយោងតែប៉ុណ្ណោះ។"]
[]
[null,"I.Setting up the business / ការរៀបចំអាជីវកម្ម",null,"Remark",null,"Renovation / ការជួសជុលឡើងវិញ",{"$nulls":7},"Machinery / គ្រឿងម៉ាស៊ីន",{"$nulls":6},"Equipment / ឧបករណ៍",{"$nulls":6},"Vehicles / យានជំនិះ"]
[null,"Business Registration (MoC) - $252.5\nការចុះឈ្មោះអាជីវកម្ម (MoC) - ២៥២.៥ ដុល្លារ",null,null,null,"Description of the item\nការពិពណ៌នាវត្ថុ","Price per unit\nតម្លៃក្នុងមួយឯកតា","# of items\n# នៃ វត្ថុ","Total សរុប","Life expectancy in month\nអាយុកាលប្រចាំខែ","Monthly cost\nចំណាយប្រចាំខែ",null,null,"Description of the item","Price per unit","# of items","Total","Life expectancy in month","Monthly cost",null,"Description of the item","Price per unit","# of items","Total","Life expectancy","Monthly cost",null,"Description of the item","Price per unit","# of items","Total","Life expectancy","Monthly cost"]
[null,"Name Reservation - $6.25\nការកក់ឈ្មោះ - ៦.២៥ ដុល្លារ",{"$nulls":6},{"$f":"G6*H6","v":0},42.0,{"$f":"IFERROR(if(I6>0,I6/J6,0),0)","v":0},{"$nulls":5},{"$f":"O6*P6","v":0},null,{"$f":"IFERROR(if(Q6>0,Q6/R6,0),0)","v":0},{"$nulls":4},{"$f":"V6*W6","v":0},null,{"$f":"IFERROR(if(X6>0,X6/Y6,0),0)","v":0},{"$nulls":4},{"$f":"AC6*AD6","v":0},null,{"$f":"IFERROR(if(AE6>0,AE6/AF6,0),0)","v":0}]
[null,"Tax Registration (GDT) - $100\nការចុះឈ្មោះពន្ធ (GDT) - ១០០ ដុល្លារ",{"$nulls":6},0,42.0,0,{"$nulls":5},0,null,0,{"$nulls":4},0,null,0,{"$nulls":4},0,null,0]
[null,"Patent Fee of all Business - $150\nថ្លៃប៉ាតង់នៃអាជីវកម្មទាំងអស់ - ១៥០ ដុល្លារ",{"$nulls":6},0,42.0,0,{"$nulls":5},0,null,0,{"$nulls":4},0,null,0,{"$nulls":4},0,null,0]
[null,"Notification of Enteprise Opening (MLVT) - $30\nសេចក្តីជូនដំណឹងអំពីការបើកសហគ្រាស (MLVT) - ៣០ ដុល្លារ",{"$nulls":6},0,42.0,0,{"$nulls":5},0,null,0,{"$nulls":4},0,null,0,{"$nulls":4},0,null,0]
[null,"Licences / អាជ្ញាប័ណ្ណ",{"$nulls":6},0,null,0,{"$nulls":5},0,null,0,{"$nulls":4},0,null,0,{"$nulls":4},0,null,0]
[null,"Agent's fee - $1000  / ថ្លៃភ្នាក់ងារ - ១០០០ ដុល្លារ",{"$nulls":6},0,null,0,{"$nulls":5},0,null,0,{"$nulls":4},0,null,0,{"$nulls":4},0,null,0]
[null,"Total / សរុប",{"$f":"SUM(C4:C11)","v":0},{"$nulls":5},0,null,0,{"$nulls":5},0,null,0,{"$nulls":4},0,null,0,{"$nulls":4},0,null,0]
[{"$nulls":8},0,null,0,{"$nulls":5},0,null,0,{"$nulls":4},0,null,0,{"$nulls":4},0,null,0]
[null,"II.Setting up the premises and equipement\nការរៀបចំបរិវេណនិងឧបករណ៍",{"$nulls":6},0,null,0,{"$nulls":5},0,null,0,{"$nulls":4},0,null,0,{"$nulls":4},0,null,0]
[null,"Renovation / ការជួសជុលឡើងវិញ",{"$f":"I17","v":0},{"$nulls":5},0,null,0,{"$nulls":5},0,null,0,{"$nulls":4},0,null,0,{"$nulls":4},0,null,0]
[null,"Machinery / គ្រឿងម៉ាស៊ីន",{"$f":"Q17","v":0},{"$nulls":5},0,null,0,{"$nulls":5},0,null,0,{"$nulls":4},0,null,0,{"$nulls":4},0,null,0]
[null,"Equipment / ឧបករណ៍",{"$f":"X17","v":0},null,null,"Total",null,null,{"$f":"sum(I6:I16)","v":0},null,{"$f":"sum(K6:K16)","v":0},null,null,"Total",null,null,{"$f":"sum(Q6:Q16)","v":0},null,{"$f":"sum(S6:S16)","v":0},null,"Total",null,null,{"$f":"sum(X6:X16)","v":0},null,{"$f":"sum(Z6:Z16)","v":0},null,"Total",null,null,{"$f":"sum(AE6:AE16)","v":0},null,{"$f":"sum(AG6:AG16)","v":0}]
[null,"Vehicles / យានជំនិះ",{"$f":"AE17","v":0}]
[{"$nulls":5},"Total invesment machinery",null,{"$f":"I17+Q17+X17","v":0}]
[null,"Total / សរុប",{"$f":"sum(C15:C19)","v":0}]
[]
[null,"III.Starting Operations / ការចាប់ផ្តើមប្រតិបត្តិការ"]
[null,"Stock / ភាគហ៊ុន",null,null,null,"Write here the Maximum capacity of production per machine \nសរសេរនៅទីនេះសមត្ថភាពផលិតអតិបរមាក្នុងមួយម៉ាស៊ីន"]
[null,"Office deposit / ប្រាក់កក់ការិយាល័យ",{"$nulls":4},"Maximum Capacity of production\nសមត្ថភាពផលិតអតិបរមា","(when you exceed the capacity of production you would need to buy additonal machine)\n(នៅពេលអ្នកផលិតលើសពីសមត្ថភាពផលិតអ្នកនឹងត្រូវការទិញម៉ាស៊ីនបន្ថែម)"]
[null,"Working capital / ដើមទុនធ្វើការ",null,null,null,"Machine 1\nម៉ាស៊ីន ១"]
[null,"Total / សរុប",{"$f":"sum(C23:C25)","v":0},null,null,"Machine 2\nម៉ាស៊ីន ២"]
[{"$nulls":5},"Machine 3\nម៉ាស៊ីន ៣"]
[null,"IV.Total Set-up costs / ការចំណាយលើការរៀបចំសរុប"]
[null,"I.Setting up the business / ការរៀបចំអាជីវកម្ម",{"$f":"C12","v":0}]
[null,"II.Setting up the premises and equipement\nការរៀបចំបរិវេណនិងឧបករណ៍",{"$f":"C20","v":0}]
[null,"III.Starting Operations / ការចាប់ផ្តើមប្រតិបត្តិការ",{"$f":"C26","v":0}]
[null,"Total / សរុប (I+II+III)",{"$f":"SUM(C29:C31)","v":0}]

{"sheet":"5- Set-Up Capital","index":6,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,2],[8,1,8,2],[14,1,14,2]]}
[]
[]
[null,"I.Equity Investment\nការវិនិយោគសមធម៌",null,"How much each of the owner brought from their personal capital? \nតើម្ចាស់ម្នាក់ៗបានយកដើមទុនផ្ទាល់ខ្លួនរបស់ពួកគេប៉ុន្មាន?"]
[null,"Owner #1\nម្ចាស់លេខ ១"]
[null,"Owner #2\nម្ចាស់លេខ ២"]
[null,"Investor #1\nអ្នកវិនិយោគ ១",null,"Write here the amount of the capital brought by external investors\nសរសេរនៅទីនេះចំនួនដើមទុនដែលនាំមកដោយវិនិយោគិនខាងក្រៅ"]
[null,"Total សរុប",{"$f":"SUM(C4:C6)","v":0}]
[]
[null,"II.Borrowings​ / ប្រាក់កម្ចី"]
[null,"Borrowing #1\nការខ្ចីលេខ ១",null,"Write here the amount borrowed?\nសរសេរចំនួនប្រាក់កម្ចីនៅទីនេះ?"]
[null,"Borrowing #2\nការខ្ចីលេខ ២"]
[null,"Borrowing #3\nការខ្ចីលេខ ៣"]
[null,"Total",{"$f":"SUM(C9:C12)","v":0}]
[]
[null,"III.Start-up Capital​ \nដើមទុនចាប់ផ្តើម"]
[null,"I.Equity Investment\nI. ការវិនិយោគសមធម៌",{"$f":"C7","v":0}]
[null,"II.Borrowings ប្រាក់កម្ចី",{"$f":"C13","v":0}]
[null,"Total សរុប (I+II)",{"$f":"SUM(C16:C17)","v":0}]