{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions--Start Here","INPUT","INPUT 2","Year 1","IS - Year 1","BS - Year 1","Year 2","IS - Year 2","BS -Year 2","Year 3","IS - Year 3","BS -Year 3","Loan"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Instructions--Start Here","index":0,"n_rows":130,"n_cols":4,"rows_kept":130,"cut":false,"hidden":false,"merged":[[0,0,0,1],[129,0,129,1]]}
["تعليمات استخدام النموذج المالي BizPlan"]
["الخطوة الأولى","اطبع ورقة العمل الخاصة بالتعليمات واحتفظ بها جانباً للرجوع إليها في وقت لاحق. "]
["الخطوة الثانية","اضغط على \"الملف\"، ثم \"حفظ باسم\" وأعد تسمية دليل العمل."]
["الخطوة الثالثة ","اضغط على علامة التبويب \"إدخال\" أدناه وأدخل بياناتك في الأقسام المشار إليها - أدخل الدولارات فقط - من دون سنت."]
[null," احتفظ بتعليماتك المطبوعة في متناول يدك  من أجل الرجوع إليها بسهولة."]
[]
["اضغط على ","المعلومات المطلوب ","نوع"]
["رقم الخلية ","إدخالها في الخلية","البيانات","المثل"]
[]
[null,"الإسم"]
["E4","اسم الشركة الخاصة بك","نصية","كابتيل سيتي كافيه "]
["E5","اسم صاحب الشركة ","نصية","ميشال جونسون"]
[null,"الإستثمار"]
["E7","مبلغ إجمالي الاستثمار من قبل صاحب العمل بالدولار. ويشمل النقد + القيمة السوقية للممتلكات والمعدات","رقمية",34000]
["E9","مبلغ القروض من العائلة أو الأصدقاء بالدولار (أي القروض التي ليس لها مدفوعات شهرية منتظمة)","رقمية",10000]
["E11","مبلغ طلب قرض مصرفي بالدولار","رقمية",86000]
["E12","مدة القرض المصرفي بالأشهر. على سبيل المثال، إذا كانت مدة القرض 5 سنوات، أدخل \"60\"","رقمية",60]
["E13","معدل الفائدة على القرض المصرفي. إذا لم يكن معروفاً، اكتب معدلاً تقديرياً. ","رقمية",7.5]
[null,"تكاليف بدء التشغيل "]
["E20","القيمة السوقية للمعدات التي قدمها صاحب العمل للعمل التجاري، أي الكاميرا الرقمية، والمركبة، إلخ.","رقمية",1425]
["E21","في حال قمت بشراء عمل تجاري قائم، أدخل قيمة لائحة العملاء (أي الشهرة التجارية). وإلا، أدخل \"0\".","رقمية",0]
["E22","في حال قمت بشراء عمل تجاري قائم، أدخل قيمة المخزون الحالي. وإلا، أدخل \"0\".","رقمية",0]
["E23","في حال قمت بشراء عمل تجاري قائم، أدخل قيمة المعدات التي ستحصل عليها. وإلا، أدخل \"0\".","رقمية",0]
["E24","في حال قمت بشراء عمل تجاري قائم، أدخل قيمة الأثاث والتجهيزات التي ستحصل عليها. وإلا، أدخل \"0\".","رقمية",0]
["E25","تكلفة أي تحسينات في المبنى الذي استأجرته أو اشتريته بالدولار.","رقمية",7450]
[null,"نفقات ما قبل الافتتاح"]
["E27","تكاليف الإعلان والتسويق قبل الافتتاح، أي طباعة الكتيبات وتطوير الموقع الإلكتروني","رقمية",2650]
["E28","الرسوم القانونية والمهنية قبل الافتتاح، أي أتعاب المحامي لتأسيس الموسسة","رقمية",1500]
["E29","التأمين، أي وجوب تسديد الدفعة الأولى قبل الافتتاح","رقمية",248]
["E30","الإيجار/ مبلغ التأمين - غالباً، يطلب مبلغ الإيجار الذي يعادل شهرين عند توقيع عقد الإيجار","رقمية",1850]
["E31","الهاتف والمرافق - غالباً، يطلب دفع إيداع و/أو رسوم التركيب - اتصل بالمرافق للحصول على التفاصيل","رقمية",187]
["E32","التراخيص والتصاريح - راجع http://medc.michigan.org/services/license/ لمعرفة ما إذا كان عملك","رقمية",0]
[null,"يتطلب ترخيصاً وما هي تكلفته."]
["E33","المخزون - قيمة المخزون الذي ستحتاجه لفتح مشروع تجاري على نفقتك الخاصة","رقمية",24000]
["E34","اللوازم - لوازم المكتب أو التنظيف اللازمة لفتح العمل التجاري","رقمية",95]
["E35","أخرى - أي تكاليف أخرى يتم تكبدها قبل الإفتتاح.","رقمية",650]
["اضغط على","المعلومات المطلوب","نوع"]
["رقم الخلية","إدخالها في الخلية","البيانات","المثل"]
[]
[null,"المبيعات المقدرة للسنة الأولى - من الشهر من 1 إلى 12"]
["E42","أدخل مبيعاتك الشهرية المقدرة من الخلية E42 إلى الخلية E53","رقمية",4800]
["E43",null,"رقمية",6300]
["E44","ثم اضغط على علامة التبويب \"إدخال 2\" أدناه لإعداد فئات المبيعات وتكلفة البضائع","رقمية",7250]
["E45",null,"رقمية",8600]
["E46","عند اكتمال فئات المبيعات وتكلفة البضائع، عد إلى علامة التبويب \"إدخال\"","رقمية",9400]
["E47",null,"رقمية",10550]
["E48",null,"رقمية",12420]
["E49",null,"رقمية",14500]
["E50",null,"رقمية",16000]
["E51",null,"رقمية",14500]
["E52",null,"رقمية",13000]
["E53",null,"رقمية",11500]
[null," الأجور المقدرة للسنة الأولى"]
["J42","أدخل تكلفة الأجور الشهرية المقدرة من الخلية J42 إلى الخلية J53","رقمية",3000]
["J43","أدخل المبلغ الإجمالي للأجور قبل الضرائب أو تكاليف الاستحقاقات","رقمية",3000]
["J44",null,"رقمية",3000]
["J45","على سبيل المثال: إذا فتحت عملك التجاري كل يوم لمدة 8 ساعات - وقررت أن تدفع لموظفيك مبلغ 10 دولار أمريكي في الساعة،","رقمية",3000]
["J46","علماً أن شهر حزيران/يونيو هو 30 يوم - اضرب 8 × 10 × 30 = 2400 ---","رقمية",3000]
["J47"," فإن الأجور المقدرة لشهر حزيران/يونيو هي 2400 دولاراً بافتراض أنك توظف شخصاً واحداً فقط في كل مرة.","رقمية",3000]
["J48",null,"رقمية",4000]
["J49","لا تشمل أي تعويض لصاحب أو لأصحاب العمل في هذا القسم.","رقمية",4000]
["J50",null,"رقمية",4000]
["J51",null,"رقمية",4000]
["J52",null,"رقمية",4000]
["J53",null,"رقمية",4000]
[null,"أسئلة أخرى متعلقة بالأجور"]
["O28","إذا كنت تملك مخزوناً، أدخل \"Y\". إذا لم يكن كذلك، أدخل \"N\"","نصية","Y"]
["O30","إذا كنت ستشتري مخزوناً من أجل إعادة بيعه، أدخل \"X\" في الخلية O30 \"شراء\"","نصية","X"]
["O31","إذا كنت ستشتري مخزوناً من أجل التصنيع أو التجميع، أدخل \"X\" في الخلية O31 \"جمع\"","نصية"]
["P44","هل ستزيد كلفة الأجور مع زيادة المبيعات؟ أدخل \"نعم\" أو \"لا\"","نصية","نعم"]
["P50","إذا كنت تخطط لتقديم استحقاقات الموظفين (كالتأمين الصحي)، أدخل التقدير كنسبة مئوية من الأجور بالدولار.","رقمية",0]
[null,"إذا لم تخطط لتقديم استحقاقات الموظفين في البداية، أدخل \"0\""]
["اضغط على","المعلومات المطلوب","نوع"]
["رقم الخلية","إدخالها في الخلية","البيانات","المثل"]
[null,"مسحوبات صاحب العمل الشخصية المقدرة خلال الأشهر 12 الأولى"]
["E72","أدخل المبلغ الذي تخطط أن تدفعه لنفسك، بصفتك صاحب العمل، من الخلية E72 إلى الخلية E83","رقمية",0]
["E73",null,"رقمية",0]
["E74",null,"رقمية",0]
["E75",null,"رقمية",500]
["E76",null,"رقمية",500]
["E77",null,"رقمية",500]
["E78",null,"رقمية",1000]
["E79",null,"رقمية",1000]
["E80",null,"رقمية",1000]
["E81",null,"رقمية",1000]
["E82",null,"رقمية",1000]
["E83",null,"رقمية",1000]
["L74","هل ستزيد مسحوبات صاحب العمل الشخصية مع زيادة المبيعات؟ أدخل \"نعم\" أو \"لا\" في الخلية L74","نصية","نعم"]
[null,"النفقات السنوية المقدرة "]
[null,"في هذا القسم، تأكد من إدخال الكلفة السنوية - وليس الشهرية"]
[null,"يمكنك تغيير أسماء الفئات لتتناسب مع عملك التجاري الخاص."]
["E88","الإعلان/التسويق - التلفزيون والراديو والصحف والمجلات والمواقع الإلكترونية والطباعة والبريد","رقمية",1200]
["E89","رسوم الخدمات المصرفية - وتشمل رسوم خصم بطاقة الائتمان في حال قبول الدفع من خلالها","رقمية",120]
["E90","العمولات - عمولات المبيعات المدفوعة لمندوبي المبيعات الخارجيين","رقمية",0]
["E91","الرسوم والاشتراكات - للجمعيات الصناعية، والمجلات التجارية، والعضويات","رقمية",60]
["E92","التأمين - الممتلكات أو المسؤولية أو شركات العمالة أو السندات","رقمية",1450]
["E93","العناية بالحديقة وإزالة الثلج","رقمية",0]
["E94","المعدات المؤجرة","رقمية",0]
["E95","الرسوم القانونية والمهنية - وتشمل الإعداد الضريبي السنوي، تجهيز جداول الأجور الأسبوعية، مراجعة العقد","رقمية",750]
["E96","التراخيص والتصاريح","رقمية",0]
["E97","نفقات متنوعة","رقمية",250]
["E98","النفقات المكتبية","رقمية",600]
["E99","المواد المرجعية - وتشمل كتيبات الإصلاح، والكتب المرجعية الضريبية والقانونية، Dun & Bradstreet","رقمية",0]
["E100","الإيجار - للمبنى أو المباني","رقمية",10500]
["E101","التصليح والصيانة - للمباني أو الممتلكات أو المعدات","رقمية",1000]
["E102","نفقات الأمن - المعدات بالإضافة إلى الرسوم الشهرية لشركة الأمن","رقمية",0]
["E103","المستلزمات - الحراسة أو لوازم أو غيرها","رقمية",300]
["E104","الضرائب -غير الأجور- ضريبة الممتلكات العقارية، ضريبة الممتلكات الشخصية","رقمية",200]
["E105","الهاتف/المرافق - تشمل أيضاً الوصول إلى الإنترنت","رقمية",2400]
["E106","العمالة المؤقتة - انتقال العمالة، مساعدة في الافتتاح الكبير، إلخ","رقمية",0]
["E107","المعارض التجارية/المؤتمرات - وتشمل رسوم الكشك والدخول وتكاليف السفر ودعم التسويق","رقمية",0]
["E108","إزالة القمامة","رقمية",260]
["E109","نفقات السفر/السيارة","رقمية",500]
[null,"نسبة المبيعات المتوقعة والزيادات في النفقات"]
["N98","أدخل النسبة المئوية لزيادة المبيعات التي تتوقعها من السنة الأولى إلى السنة الثانية","رقمية",15]
[null,"على سبيل المثال: إذا كنت تتوقع زيادة في المبيعات بنسبة 15٪ في السنة الثانية مقابل السنة الأولى، فأدخل \"15\""]
["N101","أدخل النسبة المئوية لزيادة المبيعات التي تتوقعها من السنة الثانية إلى السنة الثالثة","رقمية",7.5]
[]
["N105","أدخل النسبة المئوية المتوقعة للزيادة في النفقات غير المتعلقة بالأجور من السنة الأولى إلى السنة الثانية","رقمية",3]
[null,"على سبيل المثال: إذا كنت تتوقع ارتفاع النفقات غير المتعلقة بالأجور بنسبة 3٪ في السنة الثانية مقابل السنة الأولى، أدخل \"3\""]
["N107","أدخل النسبة المئوية المتوقعة للزيادة في النفقات غير المتعلقة بالأجور من السنة الأولى إلى السنة الثانية","رقمية",1.5]
[]
[]
[null,"يجب أن يكون الإدخال الأولي لبياناتك كاملاً الآن!"]
[null,"يمكنك الآن رؤية توقعاتك المالية من خلال الضغط على علامات تبويب أوراق العمل المتبقية:"]
[null,"توقعات التدفق النقدي - راجع علامات التبويب الخاصة ب \"السنة 1\" و \"السنة 2\" و \"السنة 3\""]
[null," بيانات الدخل - راجع علامات التبويب الخاصة ب \"IS-Year 1\" و \"IS - Year 2\" و \"IS - Year 3\""]
[null,"جداول الميزانية - راجع علامات التبويب الخاصة ب \"BS-Year 1\" و \"BS-Year 2\" و \"BS-Year 3\""]
[null,"جدول إستهلاك القرض - راجع علامة التبويب \"القرض\""]
["إشعار حقوق النشر : مركز تطوير الأعمال الصغيرة والتكنولوجيا،  2005"]

{"sheet":"INPUT","index":1,"n_rows":112,"n_cols":16,"rows_kept":112,"cut":false,"hidden":false,"merged":[[48,11,50,13],[72,8,75,10],[111,0,111,15],[97,15,98,16],[100,15,101,16],[71,5,80,6],[99,1,99,2],[100,1,100,2],[101,1,101,2],[102,1,102,2],[104,1,104,2],[103,1,103,2],[105,1,105,2],[106,1,106,2],[107,1,107,2],[70,0,70,2],[0,0,0,2],[3,0,3,2],[4,0,4,2],[6,0,6,2],[42,11,45,13],[8,0,8,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[17,0,17,2],[35,0,35,2],[25,0,25,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[37,0,37,2],[40,0,40,2],[40,6,40,7],[85,0,85,2],[108,1,108,2],[87,1,87,2],[88,1,88,2],[89,1,89,2],[90,1,90,2],[92,1,92,2],[93,1,93,2],[91,1,91,2],[94,1,94,2],[95,1,95,2],[96,1,96,2],[97,1,97,2],[98,1,98,2]]}
["ورقة عمل الإدخال",null,null,null,null,"هذه الصفحة مخصصة فقط لأغراض حسابية "]
[null,null,null,null,null,"ولا يجب أن تكون ضمن حزمة خطة العمل"]
[]
["اسم الشركة"]
["اسم صاحب الشركة"]
[]
["مقدار مساهمة صاحب الشركة",null,null,null,null,null,null,"(استثمار صاحب الشركة - نقداً أو ملكاً"]
[]
["مبلغ القروض غير المصرفية",null,null,null,null,null,null,"(يتم تسديد القروض من العائلة والأصدقاء عند توفرها)"]
[]
["مبلغ القرض التجاري المطلوب"]
["المدة (عدد الأشهر)"]
["معدل الفائدة السنوي"]
[]
[null,null,null,"إجمالي عائدات بدء التشغيل",null,{"$f":"F7+F9+F11","v":0}]
[]
[]
["تكاليف بدء التشغيل"]
[]
["المعدات التي قدمها صاحب الشركة",null,null,null,null,null,null,"قم بوضع قيمة سوقية عادلة في خانة \"استثمار صاحب الشركة\" أعلاه"]
["شراء قائمة العملاء"]
["شراء المخزون الحالي"]
["شراء المعدات"]
["شراء الأثاث والتجهيزات",null,null,null,null,0]
["تحسين/تجديد المباني",null,null,null,null,0]
["نفقات قبل الإفتتاح"]
[null,null,"الإعلان",null,null,0,null,"هل ستقوم بشراء المخزون أو بجمع/إنشاء"]
[null,null,"الرسوم القانونية والمهنية",null,null,0,null,"المخزون من المواد التي اشتريتها؟ اكتب حرف ن لنعم وك لكلا",null,null,null,null,null,null,"ن"]
[null,null,"التأمين",null,null,0]
[null,null,"الإيجار/ مبلغ التأمين",null,null,0,null,null,null,null,null,"اختر (x):",null,"شراء","x"]
[null,null,"الهاتف/المرافق",null,null,0,null,null,null,null,null,null,null,"جمع"]
[null,null,"التراخيص والتصاريح ",null,null,0]
[null,null,"المخزون",null,null,0]
[null,null,"اللوازم",null,null,0]
[null,null,"نفقات أخرى",null,null,0]
["      مجموع تكاليف بدء التشغيل",null,null,null,null,{"$f":"SUM(F20:F35)","v":0}]
[]
["صافي المركز النقدي عند بدء التشغيل",null,null,null,null,{"$f":"F15-SUM(F20:F35)","v":0}]
[]
[]
["المبيعات المقدرة خلال الأشهر 12 الأولى",null,null,null," ",null,"الأجور المقدرة خلال الأشهر 12 الأولى"]
[null,null,"الشهر 1",null,null,null,null,"الشهر 1"]
[null,null,"الشهر 2",null,null,null,null,"الشهر2  ",null,null,null,"هل ستزيد كلفة الأجور مع زيادة المبيعات؟  نعم أو لا"]
[null,null,"الشهر 3",null,null,null,null,"الشهر3",null,null,null,null,null,null,null,"كلا"]
[null,null,"الشهر 4",null,null,null,null,"الشهر4"]
[null,null,"الشهر 5",null,null,null,null,"الشهر5"]
[null,null,"الشهر 6",null,null,null,null,"الشهر6"]
[null,null,"الشهر 7",null,null,null,null,"الشهر7"]
[null,null,"الشهر 8",null,null,null,null,"الشهر8",null,null,null,"استحقاقات الموظفين، إن وجدت، كنسبة مئوية من الأجور"]
[null,null,"الشهر 9",null,null," ",null,"الشهر9",null,null,null,null,null,null,null,0.08]
[null,null,"الشهر 10",null,null,null,null,"الشهر10"]
[null,null,"الشهر 11",null,null,null,null,"الشهر11"]
[null,null,"الشهر 12",null,null,null,null,"الشهر12"]
[null,null,null,null,{"$f":"SUM(E42:E53)","v":0}]
[null,null,null,null," "]
["Estimated sales first 12 months (second revenue stream)"]
[null,null,"Month 1",null,0]
[null,null,"Month 2",null,0]
[null,null,"Month 3",null,0,null,"Does this second revenue stream use inventory?  "]
[null,null,"Month 4",null,0,null,null,"\"Y\" for Yes or \"N\" for No",null,null,"y"]
[null,null,"Month 5",null,0]
[null,null,"Month 6",null,0]
[null,null,"Month 7",null,0]
[null,null,"Month 8",null,0]
[null,null,"Month 9",null,0]
[null,null,"Month 10",null,0]
[null,null,"Month 11",null,0]
[null,null,"Month 12",null,0]
[]
[]
["مسحوبات صاحب العمل الشخصية المقدرة خلال الأشهر 12 الأولى"]
[null,null,"الشهر 1",null,0,"ملاحظة: ينطبق فقط على المؤسسات الفردية والشركات ذات المسؤولية المحدودة والشراكات.\n\nتعتبر مسحوبات صاحب المؤسسة الشخصية أجور."]
[null,null,"الشهر 2",null,0,null,null,null,"هل ستزيد مسحوبات صاحب الشركة الشخصية مع زيادة المبيعات؟ نعم أو لا"]
[null,null,"الشهر 3",null,0,null,null,null,null,null,null,"كلا"]
[null,null,"الشهر 4",null,0]
[null,null,"الشهر 5",null,0]
[null,null,"الشهر 6",null,0]
[null,null,"الشهر 7",null,0]
[null,null,"الشهر 8",null,0]
[null,null,"الشهر 9",null,0]
[null,null,"الشهر 10",null,0]
[null,null,"الشهر 11",null,0]
[null,null,"الشهر 12",null,0]
[]
[null,null,null,null,null,null,null,"Cost of inventory as a percentage of sales",null,null,null,null,null,{"$f":"'INPUT 2'!$C$10","v":0}]
["النفقات السنوية التقديرية - السنة الأولى"]
[]
[null,"الإعلان/التسويق",null,null,null,null,null," ",null,null,null,null,null," "]
[null,"رسوم الخدمات المصرفية",null,null,null,null,null," "]
[null,"العمولات"]
[null,"الرسوم والاشتراكات"]
[null,"التأمين"]
[null,"العناية بالحديقة/إزالة الثلج"]
[null,"المعدات المؤجرة"]
[null,"الرسوم القانونية والمهنية"]
[null,"التراخيص والتصاريح"]
[null,"نفقات متنوعة"]
[null,"النفقات المكتبية",null,null,null,null,null,"الزيادة المتوقعة في المبيعات في السنة الثانية",null,null,null,null,null,0.2,null,"يفترض زيادة المبيعات الإجمالية للعام الأول"]
[null,"المواد المرجعية"]
[null,"الإيجار"]
[null,"التصليح والصيانة",null,null,null,null,null,"الزيادة المتوقعة في المبيعات في السنة الثالثة",null,null,null,null,null,0.05,null,"يفترض زيادة المبيعات الإجمالية للعام الثاني"]
[null,"نفقات الأمن"]
[null,"المستلزمات"]
[null,"الضرائب -غير الأجور"]
[null,"الهاتف/المرافق",null,null,null,null,null,"الزيادة المتوقعة في النفقات في السنة الثانية",null,null,null,null,null,0.03]
[null,"العمالة المؤقتة "]
[null,"المعارض التجارية/المؤتمرات ",null,null,null,null,null,"الزيادة المتوقعة في النفقات في السنة الثالثة",null,null,null,null,null,0.03]
[null,"إزالة القمامة"]
[null,"نفقات السفر/السيارة"]
[null,null,null,null,null,null,null," "]
[]
["النهاية"]

{"sheet":"INPUT 2","index":2,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[20,0,20,5],[14,0,14,5],[16,0,16,5],[15,0,15,5],[17,0,17,5],[19,0,19,5],[21,0,21,5],[23,0,23,5],[24,0,24,5],[25,0,25,5],[27,0,27,5]]}
["ورقة عمل المبيعات"]
[]
[null,"النسبة من إجمالي "," النسبة من تكلفة "]
["فئة المبيعات","المبيعات","المخزون"]
["*",0,0,null,{"$f":"B5*C5","v":0}]
["*",0,0,null,{"$f":"B6*C6","v":0}]
["*",0,0,null,{"$f":"B7*C7","v":0}]
["فئة إضافية",0,null,null,{"$f":"B8*C8","v":0}]
["فئة إضافية",0,null,null,{"$f":"B9*C9","v":0}]
["المجموع",{"$f":"SUM(B5:B9)","v":0},{"$f":"E10","v":0},null,{"$f":"SUM(E5:E9)","v":0}]
[null,"يجب أن يعادل "," سيكون المجموع  "]
[null,"المجموع أعلاه 100%","متوسطاً مرجحاً %"]
[null,null," "]
[]
["التعليمات: "]
["الخطوة الأولى: املأ عناوين فئات المبيعات في الخلايا من A5 إلى A9 - يمكن أن يكون لديك ما يصل إلى 5 فئات."]
["أدخلنا \"المعدات\" و\"الأجزاء\" و\"الخدمة\" كمثال عن فئات المبيعات."]
["اضغط فقط على الخلية واكتب الاسم الذي تريده."]
[]
["الخطوة الثانية: أدخل النسبة المئوية لإجمالي المبيعات لكل فئة في الخلايا من B5 إلى B9. على سبيل المثال، إذا كنت تتوقع"]
["أن 40٪ من مبيعاتك ستكون للمعدات، أدخل \"المعدات\" في الخلية A5 و \"40\" في الخلية B5."]
["      اكمل نفس العملية إلى حد 5 فئات"]
[]
["الخطوة الثالثة: أدخل نسبة كلفة المخزون لكل فئة مبيعات في الخلايا من C5 إلى C9. على سبيل المثال ، إذا كانت ستكلفك المعدات"]
["التي تريد إعادة بيعها 35 دولاراً مقابل 50 دولاراً، أي 70٪ من الكلفة، إذاً، أدخل \"70\". هذه النسبة المئوية تسمى أيضاً"]
["تكلفة البضائع."]
[]
["الخطوة الرابعة: عند الانتهاء، اضغط على علامة التبويب \"إدخال\" أدناه وانتقل إلى الخلية J42 لإدخال الأجور"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Year 1","index":3,"n_rows":59,"n_cols":30,"rows_kept":59,"cut":false,"hidden":false,"merged":[[57,0,57,2],[0,0,0,2],[8,0,8,1],[9,0,9,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[54,0,54,1],[55,0,55,1],[1,0,1,1]]}
["التوقعات الشهرية للتدفق النقدي "]
["السنة الأولى (متوقعة)"]
["الشركة"]
[null," ",null,null,null,null,null,"صاحب الشركة ",{"$f":"INPUT!E5","v":0}]
[]
[null,null,"الوضع "]
[null,null,"الأولي","الشهر 1","الشهر 2","الشهر 3","الشهر 4","الشهر 5","الشهر 6","الشهر 7","الشهر 8","الشهر 9","الشهر 10","الشهر 11","الشهر 12","المجموع","نسبة المبيعات"]
[null,null,"قبل التشغيل"]
["1.) بداية الرصيد النقدي",null,null,{"$f":"C56","v":0},{"$f":"D56","v":0},{"$f":"E56","v":0},0,0,0,0,0,0,0,0,0]
["2.) المقبوضات النقدية "]
[null,"عائدات القرض المصرفي",{"$f":"INPUT!F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C11:O11)","v":0},{"$f":"P11/$P$14","v":{"$error":"#DIV/0!"}}]
[null,"قروض من مصادر غير مصرفية",{"$f":"INPUT!F9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C12:O12)","v":0},{"$f":"P12/$P$14","v":{"$error":"#DIV/0!"}}]
[null,"استثمار صاحب الشركة",{"$f":"INPUT!F7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C13:O13)","v":0},{"$f":"P13/$P$14","v":{"$error":"#DIV/0!"}}]
[null,"المبيعات",0,{"$f":"INPUT!E42","v":0},{"$f":"INPUT!E43","v":0},{"$f":"INPUT!E44","v":0},{"$f":"INPUT!E45","v":0},{"$f":"INPUT!E46","v":0},{"$f":"INPUT!E47","v":0},{"$f":"INPUT!E48","v":0},{"$f":"INPUT!E49","v":0},{"$f":"INPUT!E50","v":0},{"$f":"INPUT!E51","v":0},{"$f":"INPUT!E52","v":0},{"$f":"INPUT!E53","v":0},{"$f":"SUM(C14:O14)","v":0},{"$f":"P14/$P$16","v":{"$error":"#DIV/0!"}},null,{"$f":"IF($P$14=0,0,D14/$P$14)","v":0},{"$f":"IF($P$14=0,0,E14/$P$14)","v":0},0,0,0,0,0,0,0,0,0,0]
[null," ",null,{"$f":"INPUT!$E58","v":0},{"$f":"INPUT!$E59","v":0},{"$f":"INPUT!$E60","v":0},{"$f":"INPUT!$E61","v":0},{"$f":"INPUT!$E62","v":0},{"$f":"INPUT!$E63","v":0},{"$f":"INPUT!$E64","v":0},{"$f":"INPUT!$E65","v":0},{"$f":"INPUT!$E66","v":0},{"$f":"INPUT!$E67","v":0},{"$f":"INPUT!$E68","v":0},{"$f":"INPUT!$E69","v":0},{"$f":"SUM(C15:O15)","v":0},{"$f":"P15/$P$16","v":{"$error":"#DIV/0!"}},null,{"$f":"IF($P$15=0,0,D15/$P$15)","v":0},{"$f":"IF($P$15=0,0,E15/$P$15)","v":0},0,0,0,0,0,0,0,0,0,0]
["3.) مجموع المقبوضات النقدية ",null,{"$f":"SUM(C11:C14)","v":0},{"$f":"SUM(D11:D15)","v":0},{"$f":"SUM(E11:E15)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P14:P15)","v":0}]
["4.) مجموع النقد المتوفر ",null,{"$f":"C16","v":0},{"$f":"SUM(D9+D16)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["5.) المبالغ النقدية المدفوعة"]
[null,"كلفة البضاعة المباعة"]
[null,"تكلفة شراء المخزون للبيع",{"$f":"IF(INPUT!O30=\"x\",INPUT!F22+INPUT!F33,0)","v":0},{"$f":"IF(INPUT!O30=\"X\",'IS - Year 1'!C17,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 1'!D17,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 1'!E17,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 1'!F17,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 1'!G17,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 1'!H17,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 1'!I17,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 1'!J17,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 1'!K17,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 1'!L17,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 1'!M17,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 1'!N17,0)","v":0},{"$f":"SUM(D20:O20)","v":0},{"$f":"P20/$P$16","v":{"$error":"#DIV/0!"}}]
[null,"المواد المستخدمة في إنتاج البضائع المباعة",{"$f":"IF(INPUT!O31=\"x\",INPUT!F22+INPUT!F33,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!C17,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!D17,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!E17,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!F17,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!G17,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!H17,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!I17,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!J17,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!K17,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!L17,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!M17,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 1'!N17,0)","v":0},{"$f":"SUM(D21:O21)","v":0},{"$f":"P21/$P$16","v":{"$error":"#DIV/0!"}}]
[null,"النفقات التشغيلية"]
[null,{"$f":"INPUT!$B$88","v":"الإعلان/التسويق"},{"$f":"INPUT!F27","v":0},{"$f":"ROUND(INPUT!E88/12,-1)","v":0},{"$f":"D23","v":0},{"$f":"E23","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D23:O23)","v":0},{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$89","v":"رسوم الخدمات المصرفية"},null,{"$f":"ROUND(INPUT!E89/12,-1)","v":0},{"$f":"D24","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D24:O24)","v":0},{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$90","v":"العمولات"},null,{"$f":"ROUND(INPUT!E90/12,-1)","v":0},{"$f":"D25","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$91","v":"الرسوم والاشتراكات"},null,{"$f":"ROUND(INPUT!E91/12,-1)","v":0},{"$f":"D26","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"استحقاقات الموظفين",null,{"$f":"ROUND(D36*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(E36*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(F36*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(G36*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(H36*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(I36*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(J36*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(K36*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(L36*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(M36*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(N36*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(O36*INPUT!$P$50,-1)","v":0},0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$92","v":"التأمين"},{"$f":"INPUT!F29","v":0},{"$f":"ROUND(INPUT!E92/12,-1)","v":0},{"$f":"D28","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"الفائدة",null,{"$f":"ROUND(Loan!$D15,-1)","v":0},{"$f":"ROUND(Loan!$D16,-1)","v":0},{"$f":"ROUND(Loan!$D17,-1)","v":0},{"$f":"ROUND(Loan!$D18,-1)","v":0},{"$f":"ROUND(Loan!$D19,-1)","v":0},{"$f":"ROUND(Loan!$D20,-1)","v":0},{"$f":"ROUND(Loan!$D21,-1)","v":0},{"$f":"ROUND(Loan!$D22,-1)","v":0},{"$f":"ROUND(Loan!$D23,-1)","v":0},{"$f":"ROUND(Loan!$D24,-1)","v":0},{"$f":"ROUND(Loan!$D25,-1)","v":0},{"$f":"ROUND(Loan!$D26,-1)","v":0},0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$93","v":"العناية بالحديقة/إزالة الثلج"},null,{"$f":"ROUND(INPUT!E93/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$94","v":"المعدات المؤجرة"},null,{"$f":"ROUND(INPUT!E94/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$95","v":"الرسوم القانونية والمهنية"},{"$f":"INPUT!F28","v":0},{"$f":"ROUND(INPUT!E95/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$96","v":"التراخيص والتصاريح"},{"$f":"INPUT!F32","v":0},{"$f":"ROUND(INPUT!E96/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$97","v":"نفقات متنوعة"},{"$f":"INPUT!F35","v":0},{"$f":"ROUND(INPUT!E97/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$98","v":"النفقات المكتبية"},null,{"$f":"ROUND(INPUT!E98/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"الأجور",null,{"$f":"INPUT!J42","v":0},{"$f":"INPUT!J43","v":0},{"$f":"INPUT!J44","v":0},{"$f":"INPUT!J45","v":0},{"$f":"INPUT!J46","v":0},{"$f":"INPUT!J47","v":0},{"$f":"INPUT!J48","v":0},{"$f":"INPUT!J49","v":0},{"$f":"INPUT!J50","v":0},{"$f":"INPUT!J51","v":0},{"$f":"INPUT!J52","v":0},{"$f":"INPUT!J53","v":0},0,{"$error":"#DIV/0!"}]
[null,"ضرائب الأجور (11.15٪ من الأجور)",null,{"$f":"ROUND(D36*0.1115,0)","v":0},{"$f":"ROUND(E36*0.1115,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$99","v":"المواد المرجعية"},null,{"$f":"ROUND(INPUT!E99/12,-1)","v":0},{"$f":"D38","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$100","v":"الإيجار"},{"$f":"INPUT!F30","v":0},{"$f":"ROUND(INPUT!E100/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$101","v":"التصليح والصيانة"},null,{"$f":"ROUND(INPUT!E101/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$102","v":"نفقات الأمن"},null,{"$f":"ROUND(INPUT!E102/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$103","v":"المستلزمات"},{"$f":"INPUT!F34","v":0},{"$f":"ROUND(INPUT!E103/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$104","v":"الضرائب -غير الأجور"},null,{"$f":"ROUND(INPUT!E104/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$105","v":"الهاتف/المرافق"},{"$f":"INPUT!F31","v":0},{"$f":"ROUND(INPUT!E105/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$106","v":"العمالة المؤقتة "},null,{"$f":"ROUND(INPUT!E106/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$107","v":"المعارض التجارية/المؤتمرات "},null,{"$f":"ROUND(INPUT!E107/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$108","v":"إزالة القمامة"},null,{"$f":"ROUND(INPUT!E108/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$109","v":"نفقات السفر/السيارة"},null,{"$f":"ROUND(INPUT!E109/12,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"مجموع النفقات التشغيلية",{"$f":"SUM(C20:C48)","v":0},{"$f":"SUM(D20:D48)","v":0},{"$f":"SUM(E20:E48)","v":0},{"$f":"SUM(F20:F48)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"النفقات النقدية غير التشغيلية"]
[null," المسحوبات الشخصية لصاحب الشركة",null,{"$f":"INPUT!$E72","v":0},{"$f":"INPUT!$E73","v":0},{"$f":"INPUT!$E74","v":0},{"$f":"INPUT!$E75","v":0},{"$f":"INPUT!$E76","v":0},{"$f":"INPUT!$E77","v":0},{"$f":"INPUT!$E78","v":0},{"$f":"INPUT!$E79","v":0},{"$f":"INPUT!$E80","v":0},{"$f":"INPUT!$E81","v":0},{"$f":"INPUT!$E82","v":0},{"$f":"INPUT!$E83","v":0},{"$f":"SUM(D51:O51)","v":0},{"$error":"#DIV/0!"}]
[null," تسديد رأس المال الأصلي للقرض",null,{"$f":"ROUND(Loan!$C15,-1)","v":0},{"$f":"ROUND(Loan!$C16,-1)","v":0},{"$f":"ROUND(Loan!$C17,-1)","v":0},{"$f":"ROUND(Loan!$C18,-1)","v":0},{"$f":"ROUND(Loan!$C19,-1)","v":0},{"$f":"ROUND(Loan!$C20,-1)","v":0},{"$f":"ROUND(Loan!$C21,-1)","v":0},{"$f":"ROUND(Loan!$C22,-1)","v":0},{"$f":"ROUND(Loan!$C23,-1)","v":0},{"$f":"ROUND(Loan!$C24,-1)","v":0},{"$f":"ROUND(Loan!$C25,-1)","v":0},{"$f":"ROUND(Loan!$C26,-1)","v":0},{"$f":"SUM(D52:O52)","v":0},{"$error":"#DIV/0!"}]
[null,"شراء الأصول الثابتة (التجهيزات، الأثاث، التركيبات، إلخ)",{"$f":"INPUT!F20+INPUT!F23+INPUT!F24+INPUT!F25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D53:O53)","v":0},{"$error":"#DIV/0!"}]
[null,"شراء لائحة العملاء",{"$f":"INPUT!F21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D54:O54)","v":0},{"$error":"#DIV/0!"}]
["6.) مجموع المبالغ النقدية المدفوعة",null,{"$f":"C49+SUM(C51:C54)","v":0},{"$f":"D49+SUM(D51:D54)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D55:O55)","v":0},{"$error":"#DIV/0!"}]
["7.) الوضع النقدي في نهاية الشهر",null,{"$f":"C17-C55","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
["      المقبوضات النقدية الشهرية بحسب نقطة التعادل - السنة الأولى",null,null," ",null,null,{"$f":"(SUM(P23:P48)+SUM(P51:P54))/(1-'INPUT 2'!$C$10)/12","v":0}]
[null,null,null," ",null,null," "]

{"sheet":"IS - Year 1","index":4,"n_rows":64,"n_cols":14,"rows_kept":64,"cut":false,"hidden":false,"merged":[[3,0,3,10],[4,0,4,10]]}
["Income Statement"]
[{"$f":"'Year 1'!A2","v":"السنة الأولى (متوقعة)"}]
[{"$f":"'Year 1'!A3","v":"الشركة"}]
["بيان الدخل"]
["السنة الأولى (متوقعة)"]
["الشركة"]
[null,{"$f":"'Year 1'!B4","v":" "},null,null,null,null,"صاحب الشركة:",{"$f":"'Year 1'!I4","v":0}]
[]
[null,null,{"$f":"'Year 1'!D7","v":"الشهر 1"},{"$f":"'Year 1'!E7","v":"الشهر 2"},{"$f":"'Year 1'!F7","v":"الشهر 3"},{"$f":"'Year 1'!G7","v":"الشهر 4"},{"$f":"'Year 1'!H7","v":"الشهر 5"},{"$f":"'Year 1'!I7","v":"الشهر 6"},{"$f":"'Year 1'!J7","v":"الشهر 7"},{"$f":"'Year 1'!K7","v":"الشهر 8"},{"$f":"'Year 1'!L7","v":"الشهر 9"},{"$f":"'Year 1'!M7","v":"الشهر 10"},{"$f":"'Year 1'!N7","v":"الشهر 11"},{"$f":"'Year 1'!O7","v":"الشهر 12"}]
[]
[{"$f":"'Year 1'!B14","v":"المبيعات"},null,{"$f":"'Year 1'!D14","v":0},{"$f":"'Year 1'!E14","v":0},{"$f":"'Year 1'!F14","v":0},{"$f":"'Year 1'!G14","v":0},{"$f":"'Year 1'!H14","v":0},{"$f":"'Year 1'!I14","v":0},{"$f":"'Year 1'!J14","v":0},{"$f":"'Year 1'!K14","v":0},{"$f":"'Year 1'!L14","v":0},{"$f":"'Year 1'!M14","v":0},{"$f":"'Year 1'!N14","v":0},{"$f":"'Year 1'!O14","v":0}]
[" ",null,{"$f":"'Year 1'!D15","v":0},{"$f":"'Year 1'!E15","v":0},{"$f":"'Year 1'!F15","v":0},{"$f":"'Year 1'!G15","v":0},{"$f":"'Year 1'!H15","v":0},{"$f":"'Year 1'!I15","v":0},{"$f":"'Year 1'!J15","v":0},{"$f":"'Year 1'!K15","v":0},{"$f":"'Year 1'!L15","v":0},{"$f":"'Year 1'!M15","v":0},{"$f":"'Year 1'!N15","v":0},{"$f":"'Year 1'!O15","v":0}]
[null,"إجمالي المبيعات النقدية",{"$f":"SUM(C11:C12)","v":0},{"$f":"SUM(D11:D12)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["كلفة البضاعة المباعة"]
[null,"الرصيد الأولي للمخزون",{"$f":"'Year 1'!C20+'Year 1'!C21","v":0},{"$f":"C18","v":0},{"$f":"D18","v":0},0,0,0,0,0,0,0,0,{"$f":"M18","v":0}]
[null,"زائد المشتريات",{"$f":"C19-C16+C18","v":0},{"$f":"D19-D16+D18","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"الرصيد الختامي للمخزون",{"$f":"C16","v":0},{"$f":"D16","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"كلفة البضاعة المباعة"]
[]
[null,"اجمالي الربح",{"$f":"C11+C12-C19","v":0},{"$f":"D11+D12-D19","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["النفقات"]
["النفقات التشغيلية"]
[null,"قيمة الإستهلاك",{"$f":"C64","v":0},{"$f":"D64","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Year 1'!B23","v":"الإعلان/التسويق"},{"$f":"'Year 1'!D23+'Year 1'!C23","v":0},{"$f":"'Year 1'!E23","v":0},{"$f":"'Year 1'!F23","v":0},{"$f":"'Year 1'!G23","v":0},{"$f":"'Year 1'!H23","v":0},{"$f":"'Year 1'!I23","v":0},{"$f":"'Year 1'!J23","v":0},{"$f":"'Year 1'!K23","v":0},{"$f":"'Year 1'!L23","v":0},{"$f":"'Year 1'!M23","v":0},{"$f":"'Year 1'!N23","v":0},{"$f":"'Year 1'!O23","v":0}]
[null,{"$f":"'Year 1'!B24","v":"رسوم الخدمات المصرفية"},{"$f":"'Year 1'!D24+'Year 1'!C24","v":0},{"$f":"'Year 1'!E24","v":0},{"$f":"'Year 1'!F24","v":0},{"$f":"'Year 1'!G24","v":0},{"$f":"'Year 1'!H24","v":0},{"$f":"'Year 1'!I24","v":0},{"$f":"'Year 1'!J24","v":0},{"$f":"'Year 1'!K24","v":0},{"$f":"'Year 1'!L24","v":0},{"$f":"'Year 1'!M24","v":0},{"$f":"'Year 1'!N24","v":0},{"$f":"'Year 1'!O24","v":0}]
[null,{"$f":"'Year 1'!B25","v":"العمولات"},{"$f":"'Year 1'!D25+'Year 1'!C25","v":0},{"$f":"'Year 1'!E25","v":0},{"$f":"'Year 1'!F25","v":0},{"$f":"'Year 1'!G25","v":0},{"$f":"'Year 1'!H25","v":0},{"$f":"'Year 1'!I25","v":0},{"$f":"'Year 1'!J25","v":0},{"$f":"'Year 1'!K25","v":0},{"$f":"'Year 1'!L25","v":0},{"$f":"'Year 1'!M25","v":0},{"$f":"'Year 1'!N25","v":0},{"$f":"'Year 1'!O25","v":0}]
[null,"الإستهلاك (القسط الثابت لمدة 7 سنوات)",{"$f":"C62","v":0},{"$f":"D62","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Year 1'!B26","v":"الرسوم والاشتراكات"},{"$f":"'Year 1'!D26+'Year 1'!C26","v":0},{"$f":"'Year 1'!E26","v":0},{"$f":"'Year 1'!F26","v":0},{"$f":"'Year 1'!G26","v":0},{"$f":"'Year 1'!H26","v":0},{"$f":"'Year 1'!I26","v":0},{"$f":"'Year 1'!J26","v":0},{"$f":"'Year 1'!K26","v":0},{"$f":"'Year 1'!L26","v":0},{"$f":"'Year 1'!M26","v":0},{"$f":"'Year 1'!N26","v":0},{"$f":"'Year 1'!O26","v":0}]
[null,{"$f":"'Year 1'!B27","v":"استحقاقات الموظفين"},{"$f":"'Year 1'!D27+'Year 1'!C27","v":0},{"$f":"'Year 1'!E27","v":0},{"$f":"'Year 1'!F27","v":0},{"$f":"'Year 1'!G27","v":0},{"$f":"'Year 1'!H27","v":0},{"$f":"'Year 1'!I27","v":0},{"$f":"'Year 1'!J27","v":0},{"$f":"'Year 1'!K27","v":0},{"$f":"'Year 1'!L27","v":0},{"$f":"'Year 1'!M27","v":0},{"$f":"'Year 1'!N27","v":0},{"$f":"'Year 1'!O27","v":0}]
[null,{"$f":"'Year 1'!B28","v":"التأمين"},{"$f":"'Year 1'!D28+'Year 1'!C28","v":0},{"$f":"'Year 1'!E28","v":0},{"$f":"'Year 1'!F28","v":0},{"$f":"'Year 1'!G28","v":0},{"$f":"'Year 1'!H28","v":0},{"$f":"'Year 1'!I28","v":0},{"$f":"'Year 1'!J28","v":0},{"$f":"'Year 1'!K28","v":0},{"$f":"'Year 1'!L28","v":0},{"$f":"'Year 1'!M28","v":0},{"$f":"'Year 1'!N28","v":0},{"$f":"'Year 1'!O28","v":0}]
[null,{"$f":"'Year 1'!B29","v":"الفائدة"},{"$f":"'Year 1'!D29+'Year 1'!C29","v":0},{"$f":"'Year 1'!E29","v":0},{"$f":"'Year 1'!F29","v":0},{"$f":"'Year 1'!G29","v":0},{"$f":"'Year 1'!H29","v":0},{"$f":"'Year 1'!I29","v":0},{"$f":"'Year 1'!J29","v":0},{"$f":"'Year 1'!K29","v":0},{"$f":"'Year 1'!L29","v":0},{"$f":"'Year 1'!M29","v":0},{"$f":"'Year 1'!N29","v":0},{"$f":"'Year 1'!O29","v":0}]
[null,{"$f":"'Year 1'!B30","v":"العناية بالحديقة/إزالة الثلج"},{"$f":"'Year 1'!D30+'Year 1'!C30","v":0},{"$f":"'Year 1'!E30","v":0},{"$f":"'Year 1'!F30","v":0},{"$f":"'Year 1'!G30","v":0},{"$f":"'Year 1'!H30","v":0},{"$f":"'Year 1'!I30","v":0},{"$f":"'Year 1'!J30","v":0},{"$f":"'Year 1'!K30","v":0},{"$f":"'Year 1'!L30","v":0},{"$f":"'Year 1'!M30","v":0},{"$f":"'Year 1'!N30","v":0},{"$f":"'Year 1'!O30","v":0}]
[null,{"$f":"'Year 1'!B31","v":"المعدات المؤجرة"},{"$f":"'Year 1'!D31+'Year 1'!C31","v":0},{"$f":"'Year 1'!E31","v":0},{"$f":"'Year 1'!F31","v":0},{"$f":"'Year 1'!G31","v":0},{"$f":"'Year 1'!H31","v":0},{"$f":"'Year 1'!I31","v":0},{"$f":"'Year 1'!J31","v":0},{"$f":"'Year 1'!K31","v":0},{"$f":"'Year 1'!L31","v":0},{"$f":"'Year 1'!M31","v":0},{"$f":"'Year 1'!N31","v":0},{"$f":"'Year 1'!O31","v":0}]
[null,{"$f":"'Year 1'!B32","v":"الرسوم القانونية والمهنية"},{"$f":"'Year 1'!D32+'Year 1'!C32","v":0},{"$f":"'Year 1'!E32","v":0},{"$f":"'Year 1'!F32","v":0},{"$f":"'Year 1'!G32","v":0},{"$f":"'Year 1'!H32","v":0},{"$f":"'Year 1'!I32","v":0},{"$f":"'Year 1'!J32","v":0},{"$f":"'Year 1'!K32","v":0},{"$f":"'Year 1'!L32","v":0},{"$f":"'Year 1'!M32","v":0},{"$f":"'Year 1'!N32","v":0},{"$f":"'Year 1'!O32","v":0}]
[null,{"$f":"'Year 1'!B33","v":"التراخيص والتصاريح"},{"$f":"'Year 1'!D33+'Year 1'!C33","v":0},{"$f":"'Year 1'!E33","v":0},{"$f":"'Year 1'!F33","v":0},{"$f":"'Year 1'!G33","v":0},{"$f":"'Year 1'!H33","v":0},{"$f":"'Year 1'!I33","v":0},{"$f":"'Year 1'!J33","v":0},{"$f":"'Year 1'!K33","v":0},{"$f":"'Year 1'!L33","v":0},{"$f":"'Year 1'!M33","v":0},{"$f":"'Year 1'!N33","v":0},{"$f":"'Year 1'!O33","v":0}]
[null,{"$f":"'Year 1'!B34","v":"نفقات متنوعة"},{"$f":"'Year 1'!D34+'Year 1'!C34","v":0},{"$f":"'Year 1'!E34","v":0},{"$f":"'Year 1'!F34","v":0},{"$f":"'Year 1'!G34","v":0},{"$f":"'Year 1'!H34","v":0},{"$f":"'Year 1'!I34","v":0},{"$f":"'Year 1'!J34","v":0},{"$f":"'Year 1'!K34","v":0},{"$f":"'Year 1'!L34","v":0},{"$f":"'Year 1'!M34","v":0},{"$f":"'Year 1'!N34","v":0},{"$f":"'Year 1'!O34","v":0}]
[null,{"$f":"'Year 1'!B35","v":"النفقات المكتبية"},{"$f":"'Year 1'!D35+'Year 1'!C35","v":0},{"$f":"'Year 1'!E35","v":0},{"$f":"'Year 1'!F35","v":0},{"$f":"'Year 1'!G35","v":0},{"$f":"'Year 1'!H35","v":0},{"$f":"'Year 1'!I35","v":0},{"$f":"'Year 1'!J35","v":0},{"$f":"'Year 1'!K35","v":0},{"$f":"'Year 1'!L35","v":0},{"$f":"'Year 1'!M35","v":0},{"$f":"'Year 1'!N35","v":0},{"$f":"'Year 1'!O35","v":0}]
[null,{"$f":"'Year 1'!B36","v":"الأجور"},{"$f":"'Year 1'!D36+'Year 1'!C36","v":0},{"$f":"'Year 1'!E36","v":0},{"$f":"'Year 1'!F36","v":0},{"$f":"'Year 1'!G36","v":0},{"$f":"'Year 1'!H36","v":0},{"$f":"'Year 1'!I36","v":0},{"$f":"'Year 1'!J36","v":0},{"$f":"'Year 1'!K36","v":0},{"$f":"'Year 1'!L36","v":0},{"$f":"'Year 1'!M36","v":0},{"$f":"'Year 1'!N36","v":0},{"$f":"'Year 1'!O36","v":0}]
[null,{"$f":"'Year 1'!B37","v":"ضرائب الأجور (11.15٪ من الأجور)"},{"$f":"'Year 1'!D37+'Year 1'!C37","v":0},{"$f":"'Year 1'!E37","v":0},{"$f":"'Year 1'!F37","v":0},{"$f":"'Year 1'!G37","v":0},{"$f":"'Year 1'!H37","v":0},{"$f":"'Year 1'!I37","v":0},{"$f":"'Year 1'!J37","v":0},{"$f":"'Year 1'!K37","v":0},{"$f":"'Year 1'!L37","v":0},{"$f":"'Year 1'!M37","v":0},{"$f":"'Year 1'!N37","v":0},{"$f":"'Year 1'!O37","v":0}]
[null,{"$f":"'Year 1'!B38","v":"المواد المرجعية"},{"$f":"'Year 1'!D38+'Year 1'!C38","v":0},{"$f":"'Year 1'!E38","v":0},{"$f":"'Year 1'!F38","v":0},{"$f":"'Year 1'!G38","v":0},{"$f":"'Year 1'!H38","v":0},{"$f":"'Year 1'!I38","v":0},{"$f":"'Year 1'!J38","v":0},{"$f":"'Year 1'!K38","v":0},{"$f":"'Year 1'!L38","v":0},{"$f":"'Year 1'!M38","v":0},{"$f":"'Year 1'!N38","v":0},{"$f":"'Year 1'!O38","v":0}]
[null,{"$f":"'Year 1'!B39","v":"الإيجار"},{"$f":"'Year 1'!D39+'Year 1'!C39","v":0},{"$f":"'Year 1'!E39","v":0},{"$f":"'Year 1'!F39","v":0},{"$f":"'Year 1'!G39","v":0},{"$f":"'Year 1'!H39","v":0},{"$f":"'Year 1'!I39","v":0},{"$f":"'Year 1'!J39","v":0},{"$f":"'Year 1'!K39","v":0},{"$f":"'Year 1'!L39","v":0},{"$f":"'Year 1'!M39","v":0},{"$f":"'Year 1'!N39","v":0},{"$f":"'Year 1'!O39","v":0}]
[null,{"$f":"'Year 1'!B40","v":"التصليح والصيانة"},{"$f":"'Year 1'!D40+'Year 1'!C40","v":0},{"$f":"'Year 1'!E40","v":0},{"$f":"'Year 1'!F40","v":0},{"$f":"'Year 1'!G40","v":0},{"$f":"'Year 1'!H40","v":0},{"$f":"'Year 1'!I40","v":0},{"$f":"'Year 1'!J40","v":0},{"$f":"'Year 1'!K40","v":0},{"$f":"'Year 1'!L40","v":0},{"$f":"'Year 1'!M40","v":0},{"$f":"'Year 1'!N40","v":0},{"$f":"'Year 1'!O40","v":0}]
[null,{"$f":"'Year 1'!B41","v":"نفقات الأمن"},{"$f":"'Year 1'!C41+'Year 1'!D41","v":0},{"$f":"'Year 1'!E41","v":0},{"$f":"'Year 1'!F41","v":0},{"$f":"'Year 1'!G41","v":0},{"$f":"'Year 1'!H41","v":0},{"$f":"'Year 1'!I41","v":0},{"$f":"'Year 1'!J41","v":0},{"$f":"'Year 1'!K41","v":0},{"$f":"'Year 1'!L41","v":0},{"$f":"'Year 1'!M41","v":0},{"$f":"'Year 1'!N41","v":0},{"$f":"'Year 1'!O41","v":0}]
[null,{"$f":"'Year 1'!B42","v":"المستلزمات"},{"$f":"'Year 1'!C42+'Year 1'!D42","v":0},{"$f":"'Year 1'!E42","v":0},{"$f":"'Year 1'!F42","v":0},{"$f":"'Year 1'!G42","v":0},{"$f":"'Year 1'!H42","v":0},{"$f":"'Year 1'!I42","v":0},{"$f":"'Year 1'!J42","v":0},{"$f":"'Year 1'!K42","v":0},{"$f":"'Year 1'!L42","v":0},{"$f":"'Year 1'!M42","v":0},{"$f":"'Year 1'!N42","v":0},{"$f":"'Year 1'!O42","v":0}]
[null,{"$f":"'Year 1'!B43","v":"الضرائب -غير الأجور"},{"$f":"'Year 1'!C43+'Year 1'!D43","v":0},{"$f":"'Year 1'!E43","v":0},{"$f":"'Year 1'!F43","v":0},{"$f":"'Year 1'!G43","v":0},{"$f":"'Year 1'!H43","v":0},{"$f":"'Year 1'!I43","v":0},{"$f":"'Year 1'!J43","v":0},{"$f":"'Year 1'!K43","v":0},{"$f":"'Year 1'!L43","v":0},{"$f":"'Year 1'!M43","v":0},{"$f":"'Year 1'!N43","v":0},{"$f":"'Year 1'!O43","v":0}]
[null,{"$f":"'Year 1'!B44","v":"الهاتف/المرافق"},{"$f":"'Year 1'!D44+'Year 1'!C44","v":0},{"$f":"'Year 1'!E44","v":0},{"$f":"'Year 1'!F44","v":0},{"$f":"'Year 1'!G44","v":0},{"$f":"'Year 1'!H44","v":0},{"$f":"'Year 1'!I44","v":0},{"$f":"'Year 1'!J44","v":0},{"$f":"'Year 1'!K44","v":0},{"$f":"'Year 1'!L44","v":0},{"$f":"'Year 1'!M44","v":0},{"$f":"'Year 1'!N44","v":0},{"$f":"'Year 1'!O44","v":0}]
[null,{"$f":"'Year 1'!B45","v":"العمالة المؤقتة "},{"$f":"'Year 1'!D45+'Year 1'!C45","v":0},{"$f":"'Year 1'!E45","v":0},{"$f":"'Year 1'!F45","v":0},{"$f":"'Year 1'!G45","v":0},{"$f":"'Year 1'!H45","v":0},{"$f":"'Year 1'!I45","v":0},{"$f":"'Year 1'!J45","v":0},{"$f":"'Year 1'!K45","v":0},{"$f":"'Year 1'!L45","v":0},{"$f":"'Year 1'!M45","v":0},{"$f":"'Year 1'!N45","v":0},{"$f":"'Year 1'!O45","v":0}]
[null,{"$f":"'Year 1'!B46","v":"المعارض التجارية/المؤتمرات "},{"$f":"'Year 1'!D46+'Year 1'!C46","v":0},{"$f":"'Year 1'!E46","v":0},{"$f":"'Year 1'!F46","v":0},{"$f":"'Year 1'!G46","v":0},{"$f":"'Year 1'!H46","v":0},{"$f":"'Year 1'!I46","v":0},{"$f":"'Year 1'!J46","v":0},{"$f":"'Year 1'!K46","v":0},{"$f":"'Year 1'!L46","v":0},{"$f":"'Year 1'!M46","v":0},{"$f":"'Year 1'!N46","v":0},{"$f":"'Year 1'!O46","v":0}]
[null,{"$f":"'Year 1'!B47","v":"إزالة القمامة"},{"$f":"'Year 1'!D47+'Year 1'!C47","v":0},{"$f":"'Year 1'!E47","v":0},{"$f":"'Year 1'!F47","v":0},{"$f":"'Year 1'!G47","v":0},{"$f":"'Year 1'!H47","v":0},{"$f":"'Year 1'!I47","v":0},{"$f":"'Year 1'!J47","v":0},{"$f":"'Year 1'!K47","v":0},{"$f":"'Year 1'!L47","v":0},{"$f":"'Year 1'!M47","v":0},{"$f":"'Year 1'!N47","v":0},{"$f":"'Year 1'!O47","v":0}]
[null,{"$f":"'Year 1'!B48","v":"نفقات السفر/السيارة"},{"$f":"'Year 1'!D48+'Year 1'!C48","v":0},{"$f":"'Year 1'!E48","v":0},{"$f":"'Year 1'!F48","v":0},{"$f":"'Year 1'!G48","v":0},{"$f":"'Year 1'!H48","v":0},{"$f":"'Year 1'!I48","v":0},{"$f":"'Year 1'!J48","v":0},{"$f":"'Year 1'!K48","v":0},{"$f":"'Year 1'!L48","v":0},{"$f":"'Year 1'!M48","v":0},{"$f":"'Year 1'!N48","v":0},{"$f":"'Year 1'!O48","v":0}]
["مجموع النفقات التشغيلية",null,{"$f":"SUM(C25:C52)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["معدل الربح (الخسارة) قبل الضرائب",null,{"$f":"C21-C53","v":0},{"$f":"D21-D53","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["معدل الربح (الخسارة) التراكمي قبل الضرائب",null,null,{"$f":"C55+D55","v":0},{"$f":"D57+E55","v":0},{"$f":"E57+F55","v":0},0,0,0,0,0,0,0,0]
[]
[]
[null,"نفقات الإستهلاك (شهرياً)"]
[null,"المعدات والأثاث والتجهيزات وتحسين المباني (7 سنوات)",{"$f":"ROUND(('BS - Year 1'!D19+'BS - Year 1'!D20+'BS - Year 1'!D21)/7/12,0)","v":0},{"$f":"C61","v":0},{"$f":"D61","v":0},0,0,0,0,0,0,0,0,0]
[null,"هذا الشهر",{"$f":"SUM(C61:C61)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"استهلاك لائحة العملاء (شهرياً)",{"$f":"ROUND(INPUT!F21/60,-1)","v":0},{"$f":"C64","v":0},{"$f":"D64","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"BS - Year 1","index":5,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,0,4,11],[5,0,5,12]]}
["Balance Sheet"]
[{"$f":"'Year 1'!A2","v":"السنة الأولى (متوقعة)"}]
[{"$f":"'Year 1'!A3","v":"الشركة"}]
[null,{"$f":"'IS - Year 1'!B7","v":" "},null,null,null,null,null,"OWNER:",{"$f":"'IS - Year 1'!H7","v":0}]
[" جدول الميزانية "]
["السنة الأولى (متوقعة)"]
["الشركة"]
[null,null,null,null,null,null,null,"صاحب الشركة",0]
[]
[null,null,null,{"$f":"'Year 1'!D7","v":"الشهر 1"},{"$f":"'Year 1'!E7","v":"الشهر 2"},{"$f":"'Year 1'!F7","v":"الشهر 3"},{"$f":"'Year 1'!G7","v":"الشهر 4"},{"$f":"'Year 1'!H7","v":"الشهر 5"},{"$f":"'Year 1'!I7","v":"الشهر 6"},{"$f":"'Year 1'!J7","v":"الشهر 7"},{"$f":"'Year 1'!K7","v":"الشهر 8"},{"$f":"'Year 1'!L7","v":"الشهر 9"},{"$f":"'Year 1'!M7","v":"الشهر 10"},{"$f":"'Year 1'!N7","v":"الشهر 11"},{"$f":"'Year 1'!O7","v":"الشهر 12"}]
[]
["الأصول"]
[null," الأصول الحالية"]
[null,null,"النقد المتوفر في متناول اليد ",{"$f":"'Year 1'!D56","v":0},{"$f":"'Year 1'!E56","v":0},{"$f":"'Year 1'!F56","v":0},{"$f":"'Year 1'!G56","v":0},{"$f":"'Year 1'!H56","v":0},{"$f":"'Year 1'!I56","v":0},{"$f":"'Year 1'!J56","v":0},{"$f":"'Year 1'!K56","v":0},{"$f":"'Year 1'!L56","v":0},{"$f":"'Year 1'!M56","v":0},{"$f":"'Year 1'!N56","v":0},{"$f":"'Year 1'!O56","v":0}]
[null,null,"المخزون",{"$f":"'IS - Year 1'!C18","v":0},{"$f":"'IS - Year 1'!D18","v":0},{"$f":"'IS - Year 1'!E18","v":0},{"$f":"'IS - Year 1'!F18","v":0},{"$f":"'IS - Year 1'!G18","v":0},{"$f":"'IS - Year 1'!H18","v":0},{"$f":"'IS - Year 1'!I18","v":0},{"$f":"'IS - Year 1'!J18","v":0},{"$f":"'IS - Year 1'!K18","v":0},{"$f":"'IS - Year 1'!L18","v":0},{"$f":"'IS - Year 1'!M18","v":0},{"$f":"'IS - Year 1'!N18","v":0}]
[null,"مجموع الأصول الحالية",null,{"$f":"SUM(D14:D15)","v":0},{"$f":"SUM(E14:E15)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"الأصول الثابتة"]
[null,null,"المعدات",{"$f":"INPUT!F23+INPUT!F20","v":0},{"$f":"D19","v":0},{"$f":"E19","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"الأثاث والتجهيزات",{"$f":"INPUT!F24","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"تحسين المباني",{"$f":"INPUT!F25","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"معدل الاستهلاك المتراكم",{"$f":"-'IS - Year 1'!C29","v":0},{"$f":"-'IS - Year 1'!D29+D22","v":0},{"$f":"-'IS - Year 1'!E29+E22","v":0},{"$f":"-'IS - Year 1'!F29+F22","v":0},{"$f":"-'IS - Year 1'!G29+G22","v":0},{"$f":"-'IS - Year 1'!H29+H22","v":0},{"$f":"-'IS - Year 1'!I29+I22","v":0},{"$f":"-'IS - Year 1'!J29+J22","v":0},{"$f":"-'IS - Year 1'!K29+K22","v":0},{"$f":"-'IS - Year 1'!L29+L22","v":0},{"$f":"-'IS - Year 1'!M29+M22","v":0},{"$f":"-'IS - Year 1'!N29+N22","v":0}]
[null,"مجموع الأصول الثابتة",null,{"$f":"SUM(D19:D22)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"لائحة العملاء، معدل الاستهلاك الصافي",null,{"$f":"INPUT!F21-'IS - Year 1'!C25","v":0},{"$f":"D25-'IS - Year 1'!D25","v":0},{"$f":"E25-'IS - Year 1'!E25","v":0},{"$f":"F25-'IS - Year 1'!F25","v":0},{"$f":"G25-'IS - Year 1'!G25","v":0},{"$f":"H25-'IS - Year 1'!H25","v":0},{"$f":"I25-'IS - Year 1'!I25","v":0},{"$f":"J25-'IS - Year 1'!J25","v":0},{"$f":"K25-'IS - Year 1'!K25","v":0},{"$f":"L25-'IS - Year 1'!L25","v":0},{"$f":"M25-'IS - Year 1'!M25","v":0},{"$f":"N25-'IS - Year 1'!N25","v":0}]
[]
[null,"مجموع الأصول",null,{"$f":"D23+D16+D25","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["الإلتزامات وحقوق الملكية"]
[null,"التزامات طويلة الأجل"]
[null,null,"القروض غير المصرفية",{"$f":"INPUT!F9","v":0},{"$f":"D31","v":0},{"$f":"E31","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"القرض المصرفي",{"$f":"INPUT!F11-'Year 1'!D52","v":0},{"$f":"D32-'Year 1'!E52","v":0},{"$f":"E32-'Year 1'!F52","v":0},{"$f":"F32-'Year 1'!G52","v":0},{"$f":"G32-'Year 1'!H52","v":0},{"$f":"H32-'Year 1'!I52","v":0},{"$f":"I32-'Year 1'!J52","v":0},{"$f":"J32-'Year 1'!K52","v":0},{"$f":"K32-'Year 1'!L52","v":0},{"$f":"L32-'Year 1'!M52","v":0},{"$f":"M32-'Year 1'!N52","v":0},{"$f":"N32-'Year 1'!O52","v":0}]
[null,null,"مجموع الإلتزامات",{"$f":"SUM(D31:D32)","v":0},{"$f":"SUM(E31:E32)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"حقوق الملكية"]
[null,null,"حقوق ملكية صاحب الشركة",{"$f":"INPUT!F7","v":0},{"$f":"D35","v":0},{"$f":"E35","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"مسحوبات صاحب الشركة الشخصية",{"$f":"-'Year 1'!D51","v":0},{"$f":"-'Year 1'!E51+D36","v":0},{"$f":"-'Year 1'!F51+E36","v":0},{"$f":"-'Year 1'!G51+F36","v":0},{"$f":"-'Year 1'!H51+G36","v":0},{"$f":"-'Year 1'!I51+H36","v":0},{"$f":"-'Year 1'!J51+I36","v":0},{"$f":"-'Year 1'!K51+J36","v":0},{"$f":"-'Year 1'!L51+K36","v":0},{"$f":"-'Year 1'!M51+L36","v":0},{"$f":"-'Year 1'!N51+M36","v":0},{"$f":"-'Year 1'!O51+N36","v":0}]
[null,null,"الأرباح المحتجزة",0,0,0,{"$f":"F37","v":0},{"$f":"G37","v":0},0,0,0,0,0,{"$f":"M37","v":0},0]
[null,null,"معدل الدخل الصافي (خسارة)",{"$f":"'IS - Year 1'!C55","v":0},{"$f":"'IS - Year 1'!D55+D38","v":0},{"$f":"'IS - Year 1'!E55+E38","v":0},{"$f":"'IS - Year 1'!F55+F38","v":0},{"$f":"'IS - Year 1'!G55+G38","v":0},{"$f":"'IS - Year 1'!H55+H38","v":0},{"$f":"'IS - Year 1'!I55+I38","v":0},{"$f":"'IS - Year 1'!J55+J38","v":0},{"$f":"'IS - Year 1'!K55+K38","v":0},{"$f":"'IS - Year 1'!L55+L38","v":0},{"$f":"'IS - Year 1'!M55+M38","v":0},{"$f":"'IS - Year 1'!N55+N38","v":0}]
[null,"قيمة إجمالي حقوق الملكية ",null,{"$f":"SUM(D35:D38)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"قيمة إجمالي حقوق الملكية والالتزامات",null,{"$f":"D33+D39","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Year 2","index":6,"n_rows":58,"n_cols":17,"rows_kept":58,"cut":false,"hidden":false,"merged":[[9,0,9,1],[15,0,15,1],[57,1,57,3],[10,0,10,1],[13,0,13,1],[14,0,14,1],[52,0,52,1],[53,0,53,1]]}
["التوقعات الشهرية للتدفق النقدي "]
["السنة الثانية (متوقعة)"]
[]
["الشركة: "]
[null,{"$f":"INPUT!E4","v":0},null,null,null,null,null,"صاحب الشركة: ",{"$f":"INPUT!E5","v":0}]
[]
[]
[null,null,null,"الشهر 1","الشهر 2","الشهر 3","الشهر 4","الشهر 5","الشهر 6","الشهر 7","الشهر 8","الشهر 9","الشهر 10","الشهر 11","الشهر 12","المجموع","نسبة المبيعات"]
[]
["1.) بداية الرصيد النقدي",null,null,{"$f":"'Year 1'!O56","v":0},{"$f":"D54","v":0},{"$f":"E54","v":0},0,0,0,0,0,0,0,0,0]
["2.) المقبوضات النقدية "]
[null,"المبيعات",null,{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!S14,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!T14,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!U14,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!V14,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!W14,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!X14,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!Y14,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!Z14,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!AA14,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!AB14,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!AC14,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$14*(1+INPUT!$N$98)*'Year 1'!AD14,-1)","v":0},{"$f":"SUM(D12:O12)","v":0},{"$f":"P12/$P$14","v":{"$error":"#DIV/0!"}}]
[null," ",null,{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!S15,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!T15,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!U15,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!V15,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!W15,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!X15,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!Y15,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!Z15,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!AA15,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!AB15,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!AC15,-1)","v":0},{"$f":"ROUNDUP('Year 1'!$P$15*(1+INPUT!$N$98)*'Year 1'!AD15,-1)","v":0},{"$f":"SUM(C13:O13)","v":0},{"$f":"P13/$P$14","v":{"$error":"#DIV/0!"}}]
["3.) مجموع المقبوضات النقدية ",null,null,{"$f":"SUM(D12:D13)","v":0},{"$f":"SUM(E12:E13)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P12:P13)","v":0}]
["4.) مجموع النقد المتوفر ",null,null,{"$f":"SUM(D10+D14)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["5.) المبالغ النقدية المدفوعة"]
[null,"كلفة البضاعة المباعة"]
[null,"تكلفة شراء المخزون للبيع",null,{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!C14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!D14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!E14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!F14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!G14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!H14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!I14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!J14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!K14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!L14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!M14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 2'!N14,0)","v":0},{"$f":"SUM(D18:O18)","v":0},{"$f":"P18/$P$14","v":{"$error":"#DIV/0!"}}]
[null,"المواد المستخدمة في إنتاج البضائع المباعة",null,{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!C14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!D14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!E14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!F14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!G14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!H14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!I14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!J14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!K14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!L14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!M14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 2'!N14,0)","v":0},{"$f":"SUM(D19:O19)","v":0},{"$error":"#DIV/0!"}]
[null,"النفقات التشغيلية"]
[null,{"$f":"INPUT!$B$88","v":"الإعلان/التسويق"},null,{"$f":"ROUNDUP('Year 1'!D23*(1+INPUT!$N$105),-1)","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D21:O21)","v":0},{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$89","v":"رسوم الخدمات المصرفية"},null,{"$f":"ROUNDUP('Year 1'!D24*(1+INPUT!$N$105),-1)","v":0},{"$f":"D22","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$90","v":"العمولات"},null,{"$f":"ROUNDUP('Year 1'!D25*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$91","v":"الرسوم والاشتراكات"},null,{"$f":"ROUNDUP('Year 1'!D26*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"استحقاقات الموظفين",null,{"$f":"ROUND(D34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(E34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(F34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(G34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(H34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(I34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(J34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(K34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(L34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(M34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(N34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(O34*INPUT!$P$50,-1)","v":0},0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$92","v":"التأمين"},null,{"$f":"ROUNDUP('Year 1'!D28*(1+INPUT!$N$105),-1)","v":0},{"$f":"D26","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"الفائدة",null,{"$f":"ROUND(Loan!$D27,-1)","v":0},{"$f":"ROUND(Loan!$D28,-1)","v":0},{"$f":"ROUND(Loan!$D29,-1)","v":0},{"$f":"ROUND(Loan!$D30,-1)","v":0},{"$f":"ROUND(Loan!$D31,-1)","v":0},{"$f":"ROUND(Loan!$D32,-1)","v":0},{"$f":"ROUND(Loan!$D33,-1)","v":0},{"$f":"ROUND(Loan!$D34,-1)","v":0},{"$f":"ROUND(Loan!$D35,-1)","v":0},{"$f":"ROUND(Loan!$D36,-1)","v":0},{"$f":"ROUND(Loan!$D37,-1)","v":0},{"$f":"ROUND(Loan!$D38,-1)","v":0},0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$93","v":"العناية بالحديقة/إزالة الثلج"},null,{"$f":"ROUNDUP('Year 1'!D30*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$94","v":"المعدات المؤجرة"},null,{"$f":"ROUNDUP('Year 1'!D31*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$95","v":"الرسوم القانونية والمهنية"},null,{"$f":"ROUNDUP('Year 1'!D32*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$96","v":"التراخيص والتصاريح"},null,{"$f":"ROUNDUP('Year 1'!D33*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$97","v":"نفقات متنوعة"},null,{"$f":"ROUNDUP('Year 1'!D34*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$98","v":"النفقات المكتبية"},null,{"$f":"ROUNDUP('Year 1'!D35*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"الأجور",null,{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!D14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!E14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!F14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!G14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!H14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!I14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!J14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!K14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!L14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!M14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!N14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 1'!$N$40/'IS - Year 1'!$N$13)*'Year 2'!O14,'Year 1'!$O$36*(1+INPUT!$N$105)))","v":0},0,{"$error":"#DIV/0!"}]
[null,{"$f":"'Year 1'!B37","v":"ضرائب الأجور (11.15٪ من الأجور)"},null,{"$f":"ROUND(D34*0.1115,0)","v":0},{"$f":"ROUND(E34*0.1115,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$99","v":"المواد المرجعية"},null,{"$f":"ROUNDUP('Year 1'!D38*(1+INPUT!$N$105),-1)","v":0},{"$f":"D36","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$100","v":"الإيجار"},null,{"$f":"ROUNDUP('Year 1'!D39*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$101","v":"التصليح والصيانة"},null,{"$f":"ROUNDUP('Year 1'!D40*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$102","v":"نفقات الأمن"},null,{"$f":"ROUNDUP('Year 1'!D41*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$103","v":"المستلزمات"},null,{"$f":"ROUNDUP('Year 1'!D42*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$104","v":"الضرائب -غير الأجور"},null,{"$f":"ROUNDUP('Year 1'!D43*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$105","v":"الهاتف/المرافق"},null,{"$f":"ROUNDUP('Year 1'!D44*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$106","v":"العمالة المؤقتة "},null,{"$f":"ROUNDUP('Year 1'!D45*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$107","v":"المعارض التجارية/المؤتمرات "},null,{"$f":"ROUNDUP('Year 1'!D46*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$108","v":"إزالة القمامة"},null,{"$f":"ROUNDUP('Year 1'!D47*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$109","v":"نفقات السفر/السيارة"},null,{"$f":"ROUNDUP('Year 1'!D48*(1+INPUT!$N$105),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"مجموع النفقات التشغيلية",null,{"$f":"SUM(D18:D46)","v":0},{"$f":"SUM(E18:E46)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"النفقات النقدية غير التشغيلية"]
[null," المسحوبات الشخصية لصاحب الشركة",null,{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!D14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!E14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!F14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!G14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!H14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!I14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!J14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!K14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!L14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!M14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!N14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"IF('IS - Year 1'!$N$13=0,0,IF(INPUT!$L$74=\"Yes\",('Year 1'!$O$51/'IS - Year 1'!$N$13)*'Year 2'!O14,'Year 1'!$O$51*(1+INPUT!$N$105)))","v":0},{"$f":"SUM(D49:O49)","v":0},{"$error":"#DIV/0!"}]
[null," تسديد رأس المال الأصلي للقرض",null,{"$f":"ROUND(Loan!$C27,-1)","v":0},{"$f":"ROUND(Loan!$C28,-1)","v":0},{"$f":"ROUND(Loan!$C29,-1)","v":0},{"$f":"ROUND(Loan!$C30,-1)","v":0},{"$f":"ROUND(Loan!$C31,-1)","v":0},{"$f":"ROUND(Loan!$C32,-1)","v":0},{"$f":"ROUND(Loan!$C33,-1)","v":0},{"$f":"ROUND(Loan!$C34,-1)","v":0},{"$f":"ROUND(Loan!$C35,-1)","v":0},{"$f":"ROUND(Loan!$C36,-1)","v":0},{"$f":"ROUND(Loan!$C37,-1)","v":0},{"$f":"ROUND(Loan!$C37,-1)","v":0},{"$f":"SUM(D50:O50)","v":0},{"$error":"#DIV/0!"}]
[null,"شراء الأصول الثابتة (التجهيزات، الأثاث، التركيبات، إلخ)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:O51)","v":0},{"$error":"#DIV/0!"}]
[null,"شراء لائحة العملاء",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D52:O52)","v":0},{"$error":"#DIV/0!"}]
["6.) مجموع المبالغ النقدية المدفوعة",null,null,{"$f":"D47+SUM(D49:D52)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["7.) الوضع النقدي في نهاية الشهر",null,null,{"$f":"D15-D53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null," ",null,null," "]
[]
["                                                 Monthly Break-Even Cash Receipts for Year 2","      المقبوضات النقدية الشهرية بحسب نقطة التعادل - السنة الثانية",null,null,null,null,{"$f":"(SUM(P21:P46)+SUM(P49:P52))/(1-'INPUT 2'!C10)/12","v":0}]

{"sheet":"IS - Year 2","index":7,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["بيان الدخل "]
[{"$f":"'Year 2'!A2","v":"السنة الثانية (متوقعة)"}]
[{"$f":"'Year 1'!A3","v":"الشركة"}]
[null,{"$f":"'Year 1'!B4","v":" "},null,null,null,null,"صاحب الشركة",{"$f":"'Year 1'!I4","v":0}]
[]
[null,null,{"$f":"'Year 1'!D7","v":"الشهر 1"},{"$f":"'Year 1'!E7","v":"الشهر 2"},{"$f":"'Year 1'!F7","v":"الشهر 3"},{"$f":"'Year 1'!G7","v":"الشهر 4"},{"$f":"'Year 1'!H7","v":"الشهر 5"},{"$f":"'Year 1'!I7","v":"الشهر 6"},{"$f":"'Year 1'!J7","v":"الشهر 7"},{"$f":"'Year 1'!K7","v":"الشهر 8"},{"$f":"'Year 1'!L7","v":"الشهر 9"},{"$f":"'Year 1'!M7","v":"الشهر 10"},{"$f":"'Year 1'!N7","v":"الشهر 11"},{"$f":"'Year 1'!O7","v":"الشهر 12"}]
[]
[{"$f":"'Year 1'!B14","v":"المبيعات"},null,{"$f":"'Year 2'!D12","v":0},{"$f":"'Year 2'!E12","v":0},{"$f":"'Year 2'!F12","v":0},{"$f":"'Year 2'!G12","v":0},{"$f":"'Year 2'!H12","v":0},{"$f":"'Year 2'!I12","v":0},{"$f":"'Year 2'!J12","v":0},{"$f":"'Year 2'!K12","v":0},{"$f":"'Year 2'!L12","v":0},{"$f":"'Year 2'!M12","v":0},{"$f":"'Year 2'!N12","v":0},{"$f":"'Year 2'!O12","v":0}]
[{"$f":"'Year 1'!B15","v":" "},null,{"$f":"'Year 2'!D13","v":0},{"$f":"'Year 2'!E13","v":0},{"$f":"'Year 2'!F13","v":0},{"$f":"'Year 2'!G13","v":0},{"$f":"'Year 2'!H13","v":0},{"$f":"'Year 2'!I13","v":0},{"$f":"'Year 2'!J13","v":0},{"$f":"'Year 2'!K13","v":0},{"$f":"'Year 2'!L13","v":0},{"$f":"'Year 2'!M13","v":0},{"$f":"'Year 2'!N13","v":0},{"$f":"'Year 2'!O13","v":0}]
[null,"إجمالي المبيعات النقدية",{"$f":"SUM(C8:C9)","v":0},{"$f":"SUM(D8:D9)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["كلفة البضاعة المباعة"]
[null,"الرصيد الأولي للمخزون",{"$f":"'IS - Year 1'!N18","v":0},{"$f":"C15","v":0},{"$f":"D15","v":0},0,0,0,0,0,0,0,0,0]
[null,"زائد المشتريات",{"$f":"C16-C13+C15","v":0},{"$f":"D16-D13+D15","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"الرصيد الختامي للمخزون",{"$f":"C13","v":0},{"$f":"D13","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"كلفة البضاعة المباعة",{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!D12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!E12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!F12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!G12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!H12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!I12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!J12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!K12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!L12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!M12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!N12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 2'!O12*'INPUT 2'!$C$10,0)","v":0}]
[]
[null,"اجمالي الربح",{"$f":"C8+C9-C16","v":0},{"$f":"D8+D9-D16","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["النفقات"]
["النفقات التشغيلية"]
[null,"قيمة الإستهلاك",{"$f":"C61","v":0},{"$f":"D61","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Year 1'!B23","v":"الإعلان/التسويق"},{"$f":"'Year 2'!D21","v":0},{"$f":"'Year 2'!E21","v":0},{"$f":"'Year 2'!F21","v":0},{"$f":"'Year 2'!G21","v":0},{"$f":"'Year 2'!H21","v":0},{"$f":"'Year 2'!I21","v":0},{"$f":"'Year 2'!J21","v":0},{"$f":"'Year 2'!K21","v":0},{"$f":"'Year 2'!L21","v":0},{"$f":"'Year 2'!M21","v":0},{"$f":"'Year 2'!N21","v":0},{"$f":"'Year 2'!O21","v":0}]
[null,{"$f":"'Year 1'!B24","v":"رسوم الخدمات المصرفية"},{"$f":"'Year 2'!D22","v":0},{"$f":"'Year 2'!E22","v":0},{"$f":"'Year 2'!F22","v":0},{"$f":"'Year 2'!G22","v":0},{"$f":"'Year 2'!H22","v":0},{"$f":"'Year 2'!I22","v":0},{"$f":"'Year 2'!J22","v":0},{"$f":"'Year 2'!K22","v":0},{"$f":"'Year 2'!L22","v":0},{"$f":"'Year 2'!M22","v":0},{"$f":"'Year 2'!N22","v":0},{"$f":"'Year 2'!O22","v":0}]
[null,{"$f":"'Year 1'!B25","v":"العمولات"},{"$f":"'Year 2'!D23","v":0},{"$f":"'Year 2'!E23","v":0},{"$f":"'Year 2'!F23","v":0},{"$f":"'Year 2'!G23","v":0},{"$f":"'Year 2'!H23","v":0},{"$f":"'Year 2'!I23","v":0},{"$f":"'Year 2'!J23","v":0},{"$f":"'Year 2'!K23","v":0},{"$f":"'Year 2'!L23","v":0},{"$f":"'Year 2'!M23","v":0},{"$f":"'Year 2'!N23","v":0},{"$f":"'Year 2'!O23","v":0}]
[null,{"$f":"'IS - Year 1'!B29","v":"الإستهلاك (القسط الثابت لمدة 7 سنوات)"},{"$f":"C59","v":0},{"$f":"D59","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Year 1'!B26","v":"الرسوم والاشتراكات"},{"$f":"'Year 2'!D24","v":0},{"$f":"'Year 2'!E24","v":0},{"$f":"'Year 2'!F24","v":0},{"$f":"'Year 2'!G24","v":0},{"$f":"'Year 2'!H24","v":0},{"$f":"'Year 2'!I24","v":0},{"$f":"'Year 2'!J24","v":0},{"$f":"'Year 2'!K24","v":0},{"$f":"'Year 2'!L24","v":0},{"$f":"'Year 2'!M24","v":0},{"$f":"'Year 2'!N24","v":0},{"$f":"'Year 2'!O24","v":0}]
[null,{"$f":"'Year 1'!B27","v":"استحقاقات الموظفين"},{"$f":"'Year 2'!D25","v":0},{"$f":"'Year 2'!E25","v":0},{"$f":"'Year 2'!F25","v":0},{"$f":"'Year 2'!G25","v":0},{"$f":"'Year 2'!H25","v":0},{"$f":"'Year 2'!I25","v":0},{"$f":"'Year 2'!J25","v":0},{"$f":"'Year 2'!K25","v":0},{"$f":"'Year 2'!L25","v":0},{"$f":"'Year 2'!M25","v":0},{"$f":"'Year 2'!N25","v":0},{"$f":"'Year 2'!O25","v":0}]
[null,{"$f":"'Year 1'!B28","v":"التأمين"},{"$f":"'Year 2'!D26","v":0},{"$f":"'Year 2'!E26","v":0},{"$f":"'Year 2'!F26","v":0},{"$f":"'Year 2'!G26","v":0},{"$f":"'Year 2'!H26","v":0},{"$f":"'Year 2'!I26","v":0},{"$f":"'Year 2'!J26","v":0},{"$f":"'Year 2'!K26","v":0},{"$f":"'Year 2'!L26","v":0},{"$f":"'Year 2'!M26","v":0},{"$f":"'Year 2'!N26","v":0},{"$f":"'Year 2'!O26","v":0}]
[null,{"$f":"'Year 1'!B29","v":"الفائدة"},{"$f":"'Year 2'!D27","v":0},{"$f":"'Year 2'!E27","v":0},{"$f":"'Year 2'!F27","v":0},{"$f":"'Year 2'!G27","v":0},{"$f":"'Year 2'!H27","v":0},{"$f":"'Year 2'!I27","v":0},{"$f":"'Year 2'!J27","v":0},{"$f":"'Year 2'!K27","v":0},{"$f":"'Year 2'!L27","v":0},{"$f":"'Year 2'!M27","v":0},{"$f":"'Year 2'!N27","v":0},{"$f":"'Year 2'!O27","v":0}]
[null,{"$f":"'Year 1'!B30","v":"العناية بالحديقة/إزالة الثلج"},{"$f":"'Year 2'!D28","v":0},{"$f":"'Year 2'!E28","v":0},{"$f":"'Year 2'!F28","v":0},{"$f":"'Year 2'!G28","v":0},{"$f":"'Year 2'!H28","v":0},{"$f":"'Year 2'!I28","v":0},{"$f":"'Year 2'!J28","v":0},{"$f":"'Year 2'!K28","v":0},{"$f":"'Year 2'!L28","v":0},{"$f":"'Year 2'!M28","v":0},{"$f":"'Year 2'!N28","v":0},{"$f":"'Year 2'!O28","v":0}]
[null,{"$f":"'Year 1'!B31","v":"المعدات المؤجرة"},{"$f":"'Year 2'!D29","v":0},{"$f":"'Year 2'!E29","v":0},{"$f":"'Year 2'!F29","v":0},{"$f":"'Year 2'!G29","v":0},{"$f":"'Year 2'!H29","v":0},{"$f":"'Year 2'!I29","v":0},{"$f":"'Year 2'!J29","v":0},{"$f":"'Year 2'!K29","v":0},{"$f":"'Year 2'!L29","v":0},{"$f":"'Year 2'!M29","v":0},{"$f":"'Year 2'!N29","v":0},{"$f":"'Year 2'!O29","v":0}]
[null,{"$f":"'Year 1'!B32","v":"الرسوم القانونية والمهنية"},{"$f":"'Year 2'!D30","v":0},{"$f":"'Year 2'!E30","v":0},{"$f":"'Year 2'!F30","v":0},{"$f":"'Year 2'!G30","v":0},{"$f":"'Year 2'!H30","v":0},{"$f":"'Year 2'!I30","v":0},{"$f":"'Year 2'!J30","v":0},{"$f":"'Year 2'!K30","v":0},{"$f":"'Year 2'!L30","v":0},{"$f":"'Year 2'!M30","v":0},{"$f":"'Year 2'!N30","v":0},{"$f":"'Year 2'!O30","v":0}]
[null,{"$f":"'Year 1'!B33","v":"التراخيص والتصاريح"},{"$f":"'Year 2'!D31","v":0},{"$f":"'Year 2'!E31","v":0},{"$f":"'Year 2'!F31","v":0},{"$f":"'Year 2'!G31","v":0},{"$f":"'Year 2'!H31","v":0},{"$f":"'Year 2'!I31","v":0},{"$f":"'Year 2'!J31","v":0},{"$f":"'Year 2'!K31","v":0},{"$f":"'Year 2'!L31","v":0},{"$f":"'Year 2'!M31","v":0},{"$f":"'Year 2'!N31","v":0},{"$f":"'Year 2'!O31","v":0}]
[null,{"$f":"'Year 1'!B34","v":"نفقات متنوعة"},{"$f":"'Year 2'!D32","v":0},{"$f":"'Year 2'!E32","v":0},{"$f":"'Year 2'!F32","v":0},{"$f":"'Year 2'!G32","v":0},{"$f":"'Year 2'!H32","v":0},{"$f":"'Year 2'!I32","v":0},{"$f":"'Year 2'!J32","v":0},{"$f":"'Year 2'!K32","v":0},{"$f":"'Year 2'!L32","v":0},{"$f":"'Year 2'!M32","v":0},{"$f":"'Year 2'!N32","v":0},{"$f":"'Year 2'!O32","v":0}]
[null,{"$f":"'Year 1'!B35","v":"النفقات المكتبية"},{"$f":"'Year 2'!D33","v":0},{"$f":"'Year 2'!E33","v":0},{"$f":"'Year 2'!F33","v":0},{"$f":"'Year 2'!G33","v":0},{"$f":"'Year 2'!H33","v":0},{"$f":"'Year 2'!I33","v":0},{"$f":"'Year 2'!J33","v":0},{"$f":"'Year 2'!K33","v":0},{"$f":"'Year 2'!L33","v":0},{"$f":"'Year 2'!M33","v":0},{"$f":"'Year 2'!N33","v":0},{"$f":"'Year 2'!O33","v":0}]
[null,{"$f":"'Year 1'!B36","v":"الأجور"},{"$f":"'Year 2'!D34","v":0},{"$f":"'Year 2'!E34","v":0},{"$f":"'Year 2'!F34","v":0},{"$f":"'Year 2'!G34","v":0},{"$f":"'Year 2'!H34","v":0},{"$f":"'Year 2'!I34","v":0},{"$f":"'Year 2'!J34","v":0},{"$f":"'Year 2'!K34","v":0},{"$f":"'Year 2'!L34","v":0},{"$f":"'Year 2'!M34","v":0},{"$f":"'Year 2'!N34","v":0},{"$f":"'Year 2'!O34","v":0}]
[null,{"$f":"'Year 1'!B37","v":"ضرائب الأجور (11.15٪ من الأجور)"},{"$f":"'Year 2'!D35","v":0},{"$f":"'Year 2'!E35","v":0},{"$f":"'Year 2'!F35","v":0},{"$f":"'Year 2'!G35","v":0},{"$f":"'Year 2'!H35","v":0},{"$f":"'Year 2'!I35","v":0},{"$f":"'Year 2'!J35","v":0},{"$f":"'Year 2'!K35","v":0},{"$f":"'Year 2'!L35","v":0},{"$f":"'Year 2'!M35","v":0},{"$f":"'Year 2'!N35","v":0},{"$f":"'Year 2'!O35","v":0}]
[null,{"$f":"'Year 1'!B38","v":"المواد المرجعية"},{"$f":"'Year 2'!D36","v":0},{"$f":"'Year 2'!E36","v":0},{"$f":"'Year 2'!F36","v":0},{"$f":"'Year 2'!G36","v":0},{"$f":"'Year 2'!H36","v":0},{"$f":"'Year 2'!I36","v":0},{"$f":"'Year 2'!J36","v":0},{"$f":"'Year 2'!K36","v":0},{"$f":"'Year 2'!L36","v":0},{"$f":"'Year 2'!M36","v":0},{"$f":"'Year 2'!N36","v":0},{"$f":"'Year 2'!O36","v":0}]
[null,{"$f":"'Year 1'!B39","v":"الإيجار"},{"$f":"'Year 2'!D37","v":0},{"$f":"'Year 2'!E37","v":0},{"$f":"'Year 2'!F37","v":0},{"$f":"'Year 2'!G37","v":0},{"$f":"'Year 2'!H37","v":0},{"$f":"'Year 2'!I37","v":0},{"$f":"'Year 2'!J37","v":0},{"$f":"'Year 2'!K37","v":0},{"$f":"'Year 2'!L37","v":0},{"$f":"'Year 2'!M37","v":0},{"$f":"'Year 2'!N37","v":0},{"$f":"'Year 2'!O37","v":0}]
[null,{"$f":"'Year 1'!B40","v":"التصليح والصيانة"},{"$f":"'Year 2'!D38","v":0},{"$f":"'Year 2'!E38","v":0},{"$f":"'Year 2'!F38","v":0},{"$f":"'Year 2'!G38","v":0},{"$f":"'Year 2'!H38","v":0},{"$f":"'Year 2'!I38","v":0},{"$f":"'Year 2'!J38","v":0},{"$f":"'Year 2'!K38","v":0},{"$f":"'Year 2'!L38","v":0},{"$f":"'Year 2'!M38","v":0},{"$f":"'Year 2'!N38","v":0},{"$f":"'Year 2'!O38","v":0}]
[null,{"$f":"'Year 1'!B41","v":"نفقات الأمن"},{"$f":"'Year 2'!D39","v":0},{"$f":"'Year 2'!E39","v":0},{"$f":"'Year 2'!F39","v":0},{"$f":"'Year 2'!G39","v":0},{"$f":"'Year 2'!H39","v":0},{"$f":"'Year 2'!I39","v":0},{"$f":"'Year 2'!J39","v":0},{"$f":"'Year 2'!K39","v":0},{"$f":"'Year 2'!L39","v":0},{"$f":"'Year 2'!M39","v":0},{"$f":"'Year 2'!N39","v":0},{"$f":"'Year 2'!O39","v":0}]
[null,{"$f":"'Year 1'!B42","v":"المستلزمات"},{"$f":"'Year 2'!D40","v":0},{"$f":"'Year 2'!E40","v":0},{"$f":"'Year 2'!F40","v":0},{"$f":"'Year 2'!G40","v":0},{"$f":"'Year 2'!H40","v":0},{"$f":"'Year 2'!I40","v":0},{"$f":"'Year 2'!J40","v":0},{"$f":"'Year 2'!K40","v":0},{"$f":"'Year 2'!L40","v":0},{"$f":"'Year 2'!M40","v":0},{"$f":"'Year 2'!N40","v":0},{"$f":"'Year 2'!O40","v":0}]
[null,{"$f":"'Year 1'!B43","v":"الضرائب -غير الأجور"},{"$f":"'Year 2'!D41","v":0},{"$f":"'Year 2'!E41","v":0},{"$f":"'Year 2'!F41","v":0},{"$f":"'Year 2'!G41","v":0},{"$f":"'Year 2'!H41","v":0},{"$f":"'Year 2'!I41","v":0},{"$f":"'Year 2'!J41","v":0},{"$f":"'Year 2'!K41","v":0},{"$f":"'Year 2'!L41","v":0},{"$f":"'Year 2'!M41","v":0},{"$f":"'Year 2'!N41","v":0},{"$f":"'Year 2'!O41","v":0}]
[null,{"$f":"'Year 1'!B44","v":"الهاتف/المرافق"},{"$f":"'Year 2'!D42","v":0},{"$f":"'Year 2'!E42","v":0},{"$f":"'Year 2'!F42","v":0},{"$f":"'Year 2'!G42","v":0},{"$f":"'Year 2'!H42","v":0},{"$f":"'Year 2'!I42","v":0},{"$f":"'Year 2'!J42","v":0},{"$f":"'Year 2'!K42","v":0},{"$f":"'Year 2'!L42","v":0},{"$f":"'Year 2'!M42","v":0},{"$f":"'Year 2'!N42","v":0},{"$f":"'Year 2'!O42","v":0}]
[null,{"$f":"'Year 1'!B45","v":"العمالة المؤقتة "},{"$f":"'Year 2'!D43","v":0},{"$f":"'Year 2'!E43","v":0},{"$f":"'Year 2'!F43","v":0},{"$f":"'Year 2'!G43","v":0},{"$f":"'Year 2'!H43","v":0},{"$f":"'Year 2'!I43","v":0},{"$f":"'Year 2'!J43","v":0},{"$f":"'Year 2'!K43","v":0},{"$f":"'Year 2'!L43","v":0},{"$f":"'Year 2'!M43","v":0},{"$f":"'Year 2'!N43","v":0},{"$f":"'Year 2'!O43","v":0}]
[null,{"$f":"'Year 1'!B46","v":"المعارض التجارية/المؤتمرات "},{"$f":"'Year 2'!D44","v":0},{"$f":"'Year 2'!E44","v":0},{"$f":"'Year 2'!F44","v":0},{"$f":"'Year 2'!G44","v":0},{"$f":"'Year 2'!H44","v":0},{"$f":"'Year 2'!I44","v":0},{"$f":"'Year 2'!J44","v":0},{"$f":"'Year 2'!K44","v":0},{"$f":"'Year 2'!L44","v":0},{"$f":"'Year 2'!M44","v":0},{"$f":"'Year 2'!N44","v":0},{"$f":"'Year 2'!O44","v":0}]
[null,{"$f":"'Year 1'!B47","v":"إزالة القمامة"},{"$f":"'Year 2'!D45","v":0},{"$f":"'Year 2'!E45","v":0},{"$f":"'Year 2'!F45","v":0},{"$f":"'Year 2'!G45","v":0},{"$f":"'Year 2'!H45","v":0},{"$f":"'Year 2'!I45","v":0},{"$f":"'Year 2'!J45","v":0},{"$f":"'Year 2'!K45","v":0},{"$f":"'Year 2'!L45","v":0},{"$f":"'Year 2'!M45","v":0},{"$f":"'Year 2'!N45","v":0},{"$f":"'Year 2'!O45","v":0}]
[null,{"$f":"'Year 1'!B48","v":"نفقات السفر/السيارة"},{"$f":"'Year 2'!D46","v":0},{"$f":"'Year 2'!E46","v":0},{"$f":"'Year 2'!F46","v":0},{"$f":"'Year 2'!G46","v":0},{"$f":"'Year 2'!H46","v":0},{"$f":"'Year 2'!I46","v":0},{"$f":"'Year 2'!J46","v":0},{"$f":"'Year 2'!K46","v":0},{"$f":"'Year 2'!L46","v":0},{"$f":"'Year 2'!M46","v":0},{"$f":"'Year 2'!N46","v":0},{"$f":"'Year 2'!O46","v":0}]
["مجموع النفقات التشغيلية",null,{"$f":"SUM(C22:C49)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["معدل الربح (الخسارة) قبل الضرائب",null,{"$f":"C18-C50","v":0},{"$f":"D18-D50","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["معدل الربح (الخسارة) التراكمي قبل الضرائب",null,null,{"$f":"C52+D52","v":0},{"$f":"D54+E52","v":0},{"$f":"E54+F52","v":0},0,0,0,0,0,0,0,0]
[]
[]
[null,"نفقات الإستهلاك (شهرياً)"]
[null,"المعدات والأثاث والتجهيزات وتحسين المباني (7 سنوات)",{"$f":"ROUND(('BS - Year 1'!D19+'BS -Year 2'!D16+'BS -Year 2'!D17)/7/12,0)","v":0},{"$f":"C58","v":0},{"$f":"D58","v":0},0,0,0,0,0,0,0,0,0]
[null,"هذا الشهر",{"$f":"SUM(C58:C58)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"استهلاك لائحة العملاء (شهرياً)",{"$f":"ROUND(INPUT!F21/60,-1)","v":0},{"$f":"C61","v":0},{"$f":"D61","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"BS -Year 2","index":8,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["جدول الميزانية "]
[{"$f":"'Year 2'!A2","v":"السنة الثانية (متوقعة)"}]
[{"$f":"'Year 1'!A3","v":"الشركة"}]
[null,{"$f":"'IS - Year 1'!B7","v":" "},null,null,null,null,null,"صاحب الشركة",{"$f":"'IS - Year 1'!H7","v":0}]
[]
[null,null,null,{"$f":"'Year 1'!D7","v":"الشهر 1"},{"$f":"'Year 1'!E7","v":"الشهر 2"},{"$f":"'Year 1'!F7","v":"الشهر 3"},{"$f":"'Year 1'!G7","v":"الشهر 4"},{"$f":"'Year 1'!H7","v":"الشهر 5"},{"$f":"'Year 1'!I7","v":"الشهر 6"},{"$f":"'Year 1'!J7","v":"الشهر 7"},{"$f":"'Year 1'!K7","v":"الشهر 8"},{"$f":"'Year 1'!L7","v":"الشهر 9"},{"$f":"'Year 1'!M7","v":"الشهر 10"},{"$f":"'Year 1'!N7","v":"الشهر 11"},{"$f":"'Year 1'!O7","v":"الشهر 12"}]
[]
["الأصول"]
[null,"الأصول الحالية"]
[null,null,"النقد المتوفر في متناول اليد ",{"$f":"'Year 2'!D54","v":0},{"$f":"'Year 2'!E54","v":0},{"$f":"'Year 2'!F54","v":0},{"$f":"'Year 2'!G54","v":0},{"$f":"'Year 2'!H54","v":0},{"$f":"'Year 2'!I54","v":0},{"$f":"'Year 2'!J54","v":0},{"$f":"'Year 2'!K54","v":0},{"$f":"'Year 2'!L54","v":0},{"$f":"'Year 2'!M54","v":0},{"$f":"'Year 2'!N54","v":0},{"$f":"'Year 2'!O54","v":0}]
[null,null,"المخزون",{"$f":"'IS - Year 2'!C15","v":0},{"$f":"'IS - Year 2'!D15","v":0},{"$f":"'IS - Year 2'!E15","v":0},{"$f":"'IS - Year 2'!F15","v":0},{"$f":"'IS - Year 2'!G15","v":0},{"$f":"'IS - Year 2'!H15","v":0},{"$f":"'IS - Year 2'!I15","v":0},{"$f":"'IS - Year 2'!J15","v":0},{"$f":"'IS - Year 2'!K15","v":0},{"$f":"'IS - Year 2'!L15","v":0},{"$f":"'IS - Year 2'!M15","v":0},{"$f":"'IS - Year 2'!N15","v":0}]
[null,{"$f":"'BS - Year 1'!$B$16","v":"مجموع الأصول الحالية"},null,{"$f":"SUM(D10:D11)","v":0},{"$f":"SUM(E10:E11)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"'BS - Year 1'!$B$18","v":"الأصول الثابتة"}]
[null,null,"المعدات",{"$f":"'BS - Year 1'!O19","v":0},{"$f":"D15","v":0},{"$f":"E15","v":0},0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'BS - Year 1'!C20","v":"الأثاث والتجهيزات"},{"$f":"'BS - Year 1'!D20","v":0},{"$f":"'BS - Year 1'!E20","v":0},{"$f":"'BS - Year 1'!F20","v":0},{"$f":"'BS - Year 1'!G20","v":0},{"$f":"'BS - Year 1'!H20","v":0},{"$f":"'BS - Year 1'!I20","v":0},{"$f":"'BS - Year 1'!J20","v":0},{"$f":"'BS - Year 1'!K20","v":0},{"$f":"'BS - Year 1'!L20","v":0},{"$f":"'BS - Year 1'!M20","v":0},{"$f":"'BS - Year 1'!N20","v":0},{"$f":"'BS - Year 1'!O20","v":0}]
[null,null,{"$f":"'BS - Year 1'!C21","v":"تحسين المباني"},{"$f":"'BS - Year 1'!D21","v":0},{"$f":"'BS - Year 1'!E21","v":0},{"$f":"'BS - Year 1'!F21","v":0},{"$f":"'BS - Year 1'!G21","v":0},{"$f":"'BS - Year 1'!H21","v":0},{"$f":"'BS - Year 1'!I21","v":0},{"$f":"'BS - Year 1'!J21","v":0},{"$f":"'BS - Year 1'!K21","v":0},{"$f":"'BS - Year 1'!L21","v":0},{"$f":"'BS - Year 1'!M21","v":0},{"$f":"'BS - Year 1'!N21","v":0},{"$f":"'BS - Year 1'!O21","v":0}]
[null,null,"معدل الاستهلاك المتراكم",{"$f":"'BS - Year 1'!O22-'IS - Year 1'!C29","v":0},{"$f":"-'IS - Year 1'!D29+D18","v":0},{"$f":"-'IS - Year 1'!E29+E18","v":0},{"$f":"-'IS - Year 1'!F29+F18","v":0},{"$f":"-'IS - Year 1'!G29+G18","v":0},{"$f":"-'IS - Year 1'!H29+H18","v":0},{"$f":"-'IS - Year 1'!I29+I18","v":0},{"$f":"-'IS - Year 1'!J29+J18","v":0},{"$f":"-'IS - Year 1'!K29+K18","v":0},{"$f":"-'IS - Year 1'!L29+L18","v":0},{"$f":"-'IS - Year 1'!M29+M18","v":0},{"$f":"-'IS - Year 1'!N29+N18","v":0}]
[null,{"$f":"'BS - Year 1'!$B$23","v":"مجموع الأصول الثابتة"},null,{"$f":"SUM(D15:D18)","v":0},{"$f":"SUM(E15:E18)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"'BS - Year 1'!$B$25","v":"لائحة العملاء، معدل الاستهلاك الصافي"},null,{"$f":"'BS - Year 1'!O25 -'IS - Year 2'!C22","v":0},{"$f":"D21 -'IS - Year 2'!D22","v":0},{"$f":"E21-'IS - Year 1'!E25","v":0},{"$f":"F21-'IS - Year 1'!F25","v":0},{"$f":"G21-'IS - Year 1'!G25","v":0},{"$f":"H21-'IS - Year 1'!H25","v":0},{"$f":"I21-'IS - Year 1'!I25","v":0},{"$f":"J21-'IS - Year 1'!J25","v":0},{"$f":"K21-'IS - Year 1'!K25","v":0},{"$f":"L21-'IS - Year 1'!L25","v":0},{"$f":"M21-'IS - Year 1'!M25","v":0},{"$f":"N21-'IS - Year 1'!N25","v":0}]
[]
[null,{"$f":"'BS - Year 1'!$B$27","v":"مجموع الأصول"},null,{"$f":"D12+D19+D21","v":0},{"$f":"E19+E12+E21","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"'BS - Year 1'!$A$29","v":"الإلتزامات وحقوق الملكية"}]
[null,{"$f":"'BS - Year 1'!$B$30","v":"التزامات طويلة الأجل"}]
[null,null,{"$f":"'BS - Year 1'!$C$31","v":"القروض غير المصرفية"},{"$f":"INPUT!F9","v":0},{"$f":"D27","v":0},{"$f":"E27","v":0},0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'BS - Year 1'!$C$32","v":"القرض المصرفي"},{"$f":"'BS - Year 1'!O32-'Year 2'!D50","v":0},{"$f":"D28-'Year 2'!E50","v":0},{"$f":"E28-'Year 2'!F50","v":0},{"$f":"F28-'Year 2'!G50","v":0},{"$f":"G28-'Year 2'!H50","v":0},{"$f":"H28-'Year 2'!I50","v":0},{"$f":"I28-'Year 2'!J50","v":0},{"$f":"J28-'Year 2'!K50","v":0},{"$f":"K28-'Year 2'!L50","v":0},{"$f":"L28-'Year 2'!M50","v":0},{"$f":"M28-'Year 2'!N50","v":0},{"$f":"N28-'Year 2'!O50","v":0}]
[null,null,"مجموع الإلتزامات",{"$f":"SUM(D27:D28)","v":0},{"$f":"SUM(E27:E28)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'BS - Year 1'!$B$34","v":"حقوق الملكية"}]
[null,null,"حقوق ملكية صاحب الشركة",{"$f":"'BS - Year 1'!O35","v":0},{"$f":"D31","v":0},{"$f":"E31","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"مسحوبات صاحب الشركة الشخصية",{"$f":"-'Year 2'!D49","v":0},{"$f":"-'Year 2'!E49+D32","v":0},{"$f":"-'Year 2'!F49+E32","v":0},{"$f":"-'Year 2'!G49+F32","v":0},{"$f":"-'Year 2'!H49+G32","v":0},{"$f":"-'Year 2'!I49+H32","v":0},{"$f":"-'Year 2'!J49+I32","v":0},{"$f":"-'Year 2'!K49+J32","v":0},{"$f":"-'Year 2'!L49+K32","v":0},{"$f":"-'Year 2'!M49+L32","v":0},{"$f":"-'Year 2'!N49+M32","v":0},{"$f":"-'Year 2'!O49+N32","v":0}]
[null,null,"الأرباح المحتجزة",{"$f":"SUM('BS - Year 1'!O36:O38)","v":0},{"$f":"D33","v":0},{"$f":"E33","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"معدل الدخل الصافي (خسارة)",{"$f":"'IS - Year 2'!C52","v":0},{"$f":"D34+'IS - Year 2'!D52","v":0},{"$f":"E34+'IS - Year 2'!E52","v":0},{"$f":"F34+'IS - Year 2'!F52","v":0},{"$f":"G34+'IS - Year 2'!G52","v":0},{"$f":"H34+'IS - Year 2'!H52","v":0},{"$f":"I34+'IS - Year 2'!I52","v":0},{"$f":"J34+'IS - Year 2'!J52","v":0},{"$f":"K34+'IS - Year 2'!K52","v":0},{"$f":"L34+'IS - Year 2'!L52","v":0},{"$f":"M34+'IS - Year 2'!M52","v":0},{"$f":"N34+'IS - Year 2'!N52","v":0}]
[null,{"$f":"'BS - Year 1'!$B$39","v":"قيمة إجمالي حقوق الملكية "},null,{"$f":"SUM(D31:D34)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"'BS - Year 1'!$B$41","v":"قيمة إجمالي حقوق الملكية والالتزامات"},null,{"$f":"D29+D35","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Year 3","index":9,"n_rows":58,"n_cols":17,"rows_kept":58,"cut":false,"hidden":false,"merged":[[53,0,53,1],[57,1,57,3],[9,0,9,1],[10,0,10,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[52,0,52,1]]}
["التوقعات الشهرية للتدفق النقدي "]
["السنة الثالثة (متوقعة)"]
[]
["الشركة "]
[null,{"$f":"INPUT!E4","v":0},null,null,null,null,null,"صاحب الشركة ",{"$f":"INPUT!E5","v":0}]
[]
[]
[null,null,null,"الشهر 1","الشهر 2","الشهر 3","الشهر 4","الشهر 5","الشهر 6","الشهر 7","الشهر 8","الشهر 9","الشهر 10","الشهر 11","الشهر 12","المجموع","نسبة المبيعات"]
[]
["1.) بداية الرصيد النقدي",null,null,{"$f":"'Year 2'!O54","v":0},{"$f":"D54","v":0},{"$f":"E54","v":0},0,0,0,0,0,0,0,0,0]
["2.) المقبوضات النقدية "]
[null,"المبيعات",null,{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!S14,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!T14,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!U14,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!V14,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!W14,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!X14,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!Y14,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!Z14,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!AA14,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!AB14,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!AC14,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$12*(1+INPUT!$N$101)*'Year 1'!AD14,-1)","v":0},{"$f":"SUM(D12:O12)","v":0},{"$f":"P12/$P$14","v":{"$error":"#DIV/0!"}}]
[null," ",null,{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!S15,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!T15,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!U15,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!V15,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!W15,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!X15,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!Y15,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!Z15,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!AA15,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!AB15,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!AC15,-1)","v":0},{"$f":"ROUNDUP('Year 2'!$P$13*(1+INPUT!$N$101)*'Year 1'!AD15,-1)","v":0},{"$f":"SUM(D13:O13)","v":0},{"$f":"P13/$P$14","v":{"$error":"#DIV/0!"}}]
["3.) مجموع المقبوضات النقدية ",null,null,{"$f":"SUM(D12:D13)","v":0},{"$f":"SUM(E12:E13)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P12:P13)","v":0}]
["4.) مجموع النقد المتوفر ",null,null,{"$f":"SUM(D10+D14)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["5.) المبالغ النقدية المدفوعة"]
[null,"كلفة البضاعة المباعة"]
[null,"تكلفة شراء المخزون للبيع",null,{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!C14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!D14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!E14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!F14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!G14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!H14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!I14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!J14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!K14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!L14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!M14,0)","v":0},{"$f":"IF(INPUT!$O$30=\"X\",'IS - Year 3'!N14,0)","v":0},{"$f":"SUM(D18:O18)","v":0},{"$error":"#DIV/0!"}]
[null,"المواد المستخدمة في إنتاج البضائع المباعة",null,{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!C14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!D14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!E14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!F14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!G14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!H14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!I14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!J14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!K14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!L14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!M14,0)","v":0},{"$f":"IF(INPUT!$O$31=\"X\",'IS - Year 3'!N14,0)","v":0},{"$f":"SUM(D19:O19)","v":0},{"$error":"#DIV/0!"}]
[null,"النفقات التشغيلية"]
[null,{"$f":"INPUT!$B$88","v":"الإعلان/التسويق"},null,{"$f":"ROUNDUP('Year 2'!D21*(1+INPUT!$N$107),-1)","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D21:O21)","v":0},{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$89","v":"رسوم الخدمات المصرفية"},null,{"$f":"ROUNDUP('Year 2'!D22*(1+INPUT!$N$107),-1)","v":0},{"$f":"D22","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$90","v":"العمولات"},null,{"$f":"ROUNDUP('Year 2'!D23*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$91","v":"الرسوم والاشتراكات"},null,{"$f":"ROUNDUP('Year 2'!D24*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"استحقاقات الموظفين",null,{"$f":"ROUND(D34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(E34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(F34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(G34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(H34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(I34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(J34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(K34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(L34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(M34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(N34*INPUT!$P$50,-1)","v":0},{"$f":"ROUND(O34*INPUT!$P$50,-1)","v":0},0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$92","v":"التأمين"},null,{"$f":"ROUNDUP('Year 2'!D26*(1+INPUT!$N$107),-1)","v":0},{"$f":"D26","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"الفائدة",null,{"$f":"ROUND(Loan!$D39,-1)","v":0},{"$f":"ROUND(Loan!$D40,-1)","v":0},{"$f":"ROUND(Loan!$D41,-1)","v":0},{"$f":"ROUND(Loan!$D42,-1)","v":0},{"$f":"ROUND(Loan!$D43,-1)","v":0},{"$f":"ROUND(Loan!$D44,-1)","v":0},{"$f":"ROUND(Loan!$D45,-1)","v":0},{"$f":"ROUND(Loan!$D46,-1)","v":0},{"$f":"ROUND(Loan!$D47,-1)","v":0},{"$f":"ROUND(Loan!$D48,-1)","v":0},{"$f":"ROUND(Loan!$D49,-1)","v":0},{"$f":"ROUND(Loan!$D50,-1)","v":0},0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$93","v":"العناية بالحديقة/إزالة الثلج"},null,{"$f":"ROUNDUP('Year 2'!D28*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$94","v":"المعدات المؤجرة"},null,{"$f":"ROUNDUP('Year 2'!D29*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$95","v":"الرسوم القانونية والمهنية"},null,{"$f":"ROUNDUP('Year 2'!D30*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$96","v":"التراخيص والتصاريح"},null,{"$f":"ROUNDUP('Year 2'!D31*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$97","v":"نفقات متنوعة"},null,{"$f":"ROUNDUP('Year 2'!D32*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$98","v":"النفقات المكتبية"},null,{"$f":"ROUNDUP('Year 2'!D33*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"الأجور",null,{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!D14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!E14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!F14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!G14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!H14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!I14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!J14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!K14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!L14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!M14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!N14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$P$44=\"Yes\",('IS - Year 2'!$N$37/'IS - Year 2'!$N$10)*'Year 3'!O14,'Year 2'!$O$34*(1+INPUT!$N$107)))","v":0},0,{"$error":"#DIV/0!"}]
[null,{"$f":"'Year 2'!B35","v":"ضرائب الأجور (11.15٪ من الأجور)"},null,{"$f":"ROUND(D34*0.1115,0)","v":0},{"$f":"ROUND(E34*0.1115,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$99","v":"المواد المرجعية"},null,{"$f":"ROUNDUP('Year 2'!D36*(1+INPUT!$N$107),-1)","v":0},{"$f":"D36","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$100","v":"الإيجار"},null,{"$f":"ROUNDUP('Year 2'!D37*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$101","v":"التصليح والصيانة"},null,{"$f":"ROUNDUP('Year 2'!D38*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$102","v":"نفقات الأمن"},null,{"$f":"ROUNDUP('Year 2'!D39*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$103","v":"المستلزمات"},null,{"$f":"ROUNDUP('Year 2'!D40*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$104","v":"الضرائب -غير الأجور"},null,{"$f":"ROUNDUP('Year 2'!D41*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$105","v":"الهاتف/المرافق"},null,{"$f":"ROUNDUP('Year 2'!D42*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$106","v":"العمالة المؤقتة "},null,{"$f":"ROUNDUP('Year 2'!D43*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$107","v":"المعارض التجارية/المؤتمرات "},null,{"$f":"ROUNDUP('Year 2'!D44*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$108","v":"إزالة القمامة"},null,{"$f":"ROUNDUP('Year 2'!D45*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,{"$f":"INPUT!$B$109","v":"نفقات السفر/السيارة"},null,{"$f":"ROUNDUP('Year 2'!D46*(1+INPUT!$N$107),-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"مجموع النفقات التشغيلية",null,{"$f":"SUM(D18:D46)","v":0},{"$f":"SUM(E18:E46)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"النفقات النقدية غير التشغيلية"]
[null," المسحوبات الشخصية لصاحب الشركة",null,{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!D14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!E14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!F14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!G14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!H14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!I14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!J14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!K14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!L14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!M14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!N14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"IF('IS - Year 2'!$N$10=0,0,IF(INPUT!$L$74=\"Yes\",('Year 2'!$O$49/'IS - Year 2'!$N$10)*'Year 3'!O14,'Year 2'!$O$49*(1+INPUT!$N$107)))","v":0},{"$f":"SUM(D49:O49)","v":0},{"$error":"#DIV/0!"}]
[null," سداد رأس المال الأصلي للقرض",null,{"$f":"ROUND(Loan!$C39,-1)","v":0},{"$f":"ROUND(Loan!$C40,-1)","v":0},{"$f":"ROUND(Loan!$C41,-1)","v":0},{"$f":"ROUND(Loan!$C42,-1)","v":0},{"$f":"ROUND(Loan!$C43,-1)","v":0},{"$f":"ROUND(Loan!$C44,-1)","v":0},{"$f":"ROUND(Loan!$C45,-1)","v":0},{"$f":"ROUND(Loan!$C46,-1)","v":0},{"$f":"ROUND(Loan!$C47,-1)","v":0},{"$f":"ROUND(Loan!$C48,-1)","v":0},{"$f":"ROUND(Loan!$C49,-1)","v":0},{"$f":"ROUND(Loan!$C50,-1)","v":0},{"$f":"SUM(D50:O50)","v":0},{"$error":"#DIV/0!"}]
[null,"شراء الأصول الثابتة (التجهيزات، الأثاث، التركيبات، إلخ)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:O51)","v":0},{"$error":"#DIV/0!"}]
[null,"شراء لائحة العملاء",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D52:O52)","v":0},{"$error":"#DIV/0!"}]
["6.) مجموع المبالغ النقدية المدفوعة",null,null,{"$f":"D47+SUM(D49:D52)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["7.) الوضع النقدي في نهاية الشهر",null,null,{"$f":"D15-D53","v":0},{"$f":"E15-E53","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null," ",null,null," "]
[]
["              Monthly Break-Even Cash Receipts for Year 3","      المقبوضات النقدية الشهرية بحسب نقطة التعادل - السنة الثالثة",null,null,null,null,{"$f":"(SUM(P21:P52)/(1-'INPUT 2'!C10)/12)","v":0}]

{"sheet":"IS - Year 3","index":10,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["بيان الدخل"]
[{"$f":"'Year 3'!A2","v":"السنة الثالثة (متوقعة)"}]
[{"$f":"'Year 1'!A3","v":"الشركة"}]
[null,{"$f":"'Year 1'!B4","v":" "},null,null,null,null,"صاحب الشركة",{"$f":"'Year 1'!I4","v":0}]
[]
[null,null,{"$f":"'Year 1'!D7","v":"الشهر 1"},{"$f":"'Year 1'!E7","v":"الشهر 2"},{"$f":"'Year 1'!F7","v":"الشهر 3"},{"$f":"'Year 1'!G7","v":"الشهر 4"},{"$f":"'Year 1'!H7","v":"الشهر 5"},{"$f":"'Year 1'!I7","v":"الشهر 6"},{"$f":"'Year 1'!J7","v":"الشهر 7"},{"$f":"'Year 1'!K7","v":"الشهر 8"},{"$f":"'Year 1'!L7","v":"الشهر 9"},{"$f":"'Year 1'!M7","v":"الشهر 10"},{"$f":"'Year 1'!N7","v":"الشهر 11"},{"$f":"'Year 1'!O7","v":"الشهر 12"}]
[]
[{"$f":"'Year 1'!B14","v":"المبيعات"},null,{"$f":"'Year 3'!D12","v":0},{"$f":"'Year 3'!E12","v":0},{"$f":"'Year 3'!F12","v":0},{"$f":"'Year 3'!G12","v":0},{"$f":"'Year 3'!H12","v":0},{"$f":"'Year 3'!I12","v":0},{"$f":"'Year 3'!J12","v":0},{"$f":"'Year 3'!K12","v":0},{"$f":"'Year 3'!L12","v":0},{"$f":"'Year 3'!M12","v":0},{"$f":"'Year 3'!N12","v":0},{"$f":"'Year 3'!O12","v":0}]
[{"$f":"'Year 1'!B15","v":" "},null,{"$f":"'Year 3'!D13","v":0},{"$f":"'Year 3'!E13","v":0},{"$f":"'Year 3'!F13","v":0},{"$f":"'Year 3'!G13","v":0},{"$f":"'Year 3'!H13","v":0},{"$f":"'Year 3'!I13","v":0},{"$f":"'Year 3'!J13","v":0},{"$f":"'Year 3'!K13","v":0},{"$f":"'Year 3'!L13","v":0},{"$f":"'Year 3'!M13","v":0},{"$f":"'Year 3'!N13","v":0},{"$f":"'Year 3'!O13","v":0}]
[null,"إجمالي المبيعات النقدية",{"$f":"SUM(C8:C9)","v":0},{"$f":"SUM(D8:D9)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["كلفة البضاعة المباعة"]
[null,"الرصيد الأولي للمخزون",{"$f":"'IS - Year 2'!N15","v":0},{"$f":"C15","v":0},{"$f":"D15","v":0},0,0,0,0,0,0,0,0,0]
[null,"زائد المشتريات",{"$f":"C16-C13+C15","v":0},{"$f":"D16-D13+D15","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"الرصيد الختامي للمخزون",{"$f":"C13","v":0},{"$f":"D13","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"كلفة البضاعة المباعة",{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!D12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!E12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!F12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!G12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!H12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!I12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!J12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!K12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!L12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!M12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!N12*'INPUT 2'!$C$10,0)","v":0},{"$f":"IF(INPUT!$O$28=\"y\",'Year 3'!O12*'INPUT 2'!$C$10,0)","v":0}]
[]
[null,"اجمالي الربح",{"$f":"C10-C16","v":0},{"$f":"D10-D16","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["النفقات"]
["النفقات التشغيلية"]
[null,"قيمة الإستهلاك",{"$f":"C61","v":0},{"$f":"D61","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Year 1'!B23","v":"الإعلان/التسويق"},{"$f":"'Year 3'!D21","v":0},{"$f":"'Year 3'!E21","v":0},{"$f":"'Year 3'!F21","v":0},{"$f":"'Year 3'!G21","v":0},{"$f":"'Year 3'!H21","v":0},{"$f":"'Year 3'!I21","v":0},{"$f":"'Year 3'!J21","v":0},{"$f":"'Year 3'!K21","v":0},{"$f":"'Year 3'!L21","v":0},{"$f":"'Year 3'!M21","v":0},{"$f":"'Year 3'!N21","v":0},{"$f":"'Year 3'!O21","v":0}]
[null,{"$f":"'Year 1'!B24","v":"رسوم الخدمات المصرفية"},{"$f":"'Year 3'!D22","v":0},{"$f":"'Year 3'!E22","v":0},{"$f":"'Year 3'!F22","v":0},{"$f":"'Year 3'!G22","v":0},{"$f":"'Year 3'!H22","v":0},{"$f":"'Year 3'!I22","v":0},{"$f":"'Year 3'!J22","v":0},{"$f":"'Year 3'!K22","v":0},{"$f":"'Year 3'!L22","v":0},{"$f":"'Year 3'!M22","v":0},{"$f":"'Year 3'!N22","v":0},{"$f":"'Year 3'!O22","v":0}]
[null,{"$f":"'Year 1'!B25","v":"العمولات"},{"$f":"'Year 3'!D23","v":0},{"$f":"'Year 3'!E23","v":0},{"$f":"'Year 3'!F23","v":0},{"$f":"'Year 3'!G23","v":0},{"$f":"'Year 3'!H23","v":0},{"$f":"'Year 3'!I23","v":0},{"$f":"'Year 3'!J23","v":0},{"$f":"'Year 3'!K23","v":0},{"$f":"'Year 3'!L23","v":0},{"$f":"'Year 3'!M23","v":0},{"$f":"'Year 3'!N23","v":0},{"$f":"'Year 3'!O23","v":0}]
[null,{"$f":"'IS - Year 2'!B26","v":"الإستهلاك (القسط الثابت لمدة 7 سنوات)"},{"$f":"C59","v":0},{"$f":"D59","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Year 1'!B26","v":"الرسوم والاشتراكات"},{"$f":"'Year 3'!D24","v":0},{"$f":"'Year 3'!E24","v":0},{"$f":"'Year 3'!F24","v":0},{"$f":"'Year 3'!G24","v":0},{"$f":"'Year 3'!H24","v":0},{"$f":"'Year 3'!I24","v":0},{"$f":"'Year 3'!J24","v":0},{"$f":"'Year 3'!K24","v":0},{"$f":"'Year 3'!L24","v":0},{"$f":"'Year 3'!M24","v":0},{"$f":"'Year 3'!N24","v":0},{"$f":"'Year 3'!O24","v":0}]
[null,{"$f":"'Year 1'!B27","v":"استحقاقات الموظفين"},{"$f":"'Year 3'!D25","v":0},{"$f":"'Year 3'!E25","v":0},{"$f":"'Year 3'!F25","v":0},{"$f":"'Year 3'!G25","v":0},{"$f":"'Year 3'!H25","v":0},{"$f":"'Year 3'!I25","v":0},{"$f":"'Year 3'!J25","v":0},{"$f":"'Year 3'!K25","v":0},{"$f":"'Year 3'!L25","v":0},{"$f":"'Year 3'!M25","v":0},{"$f":"'Year 3'!N25","v":0},{"$f":"'Year 3'!O25","v":0}]
[null,{"$f":"'Year 1'!B28","v":"التأمين"},{"$f":"'Year 3'!D26","v":0},{"$f":"'Year 3'!E26","v":0},{"$f":"'Year 3'!F26","v":0},{"$f":"'Year 3'!G26","v":0},{"$f":"'Year 3'!H26","v":0},{"$f":"'Year 3'!I26","v":0},{"$f":"'Year 3'!J26","v":0},{"$f":"'Year 3'!K26","v":0},{"$f":"'Year 3'!L26","v":0},{"$f":"'Year 3'!M26","v":0},{"$f":"'Year 3'!N26","v":0},{"$f":"'Year 3'!O26","v":0}]
[null,{"$f":"'Year 1'!B29","v":"الفائدة"},{"$f":"'Year 3'!D27","v":0},{"$f":"'Year 3'!E27","v":0},{"$f":"'Year 3'!F27","v":0},{"$f":"'Year 3'!G27","v":0},{"$f":"'Year 3'!H27","v":0},{"$f":"'Year 3'!I27","v":0},{"$f":"'Year 3'!J27","v":0},{"$f":"'Year 3'!K27","v":0},{"$f":"'Year 3'!L27","v":0},{"$f":"'Year 3'!M27","v":0},{"$f":"'Year 3'!N27","v":0},{"$f":"'Year 3'!O27","v":0}]
[null,{"$f":"'Year 1'!B30","v":"العناية بالحديقة/إزالة الثلج"},{"$f":"'Year 3'!D28","v":0},{"$f":"'Year 3'!E28","v":0},{"$f":"'Year 3'!F28","v":0},{"$f":"'Year 3'!G28","v":0},{"$f":"'Year 3'!H28","v":0},{"$f":"'Year 3'!I28","v":0},{"$f":"'Year 3'!J28","v":0},{"$f":"'Year 3'!K28","v":0},{"$f":"'Year 3'!L28","v":0},{"$f":"'Year 3'!M28","v":0},{"$f":"'Year 3'!N28","v":0},{"$f":"'Year 3'!O28","v":0}]
[null,{"$f":"'Year 1'!B31","v":"المعدات المؤجرة"},{"$f":"'Year 3'!D29","v":0},{"$f":"'Year 3'!E29","v":0},{"$f":"'Year 3'!F29","v":0},{"$f":"'Year 3'!G29","v":0},{"$f":"'Year 3'!H29","v":0},{"$f":"'Year 3'!I29","v":0},{"$f":"'Year 3'!J29","v":0},{"$f":"'Year 3'!K29","v":0},{"$f":"'Year 3'!L29","v":0},{"$f":"'Year 3'!M29","v":0},{"$f":"'Year 3'!N29","v":0},{"$f":"'Year 3'!O29","v":0}]
[null,{"$f":"'Year 1'!B32","v":"الرسوم القانونية والمهنية"},{"$f":"'Year 3'!D30","v":0},{"$f":"'Year 3'!E30","v":0},{"$f":"'Year 3'!F30","v":0},{"$f":"'Year 3'!G30","v":0},{"$f":"'Year 3'!H30","v":0},{"$f":"'Year 3'!I30","v":0},{"$f":"'Year 3'!J30","v":0},{"$f":"'Year 3'!K30","v":0},{"$f":"'Year 3'!L30","v":0},{"$f":"'Year 3'!M30","v":0},{"$f":"'Year 3'!N30","v":0},{"$f":"'Year 3'!O30","v":0}]
[null,{"$f":"'Year 1'!B33","v":"التراخيص والتصاريح"},{"$f":"'Year 3'!D31","v":0},{"$f":"'Year 3'!E31","v":0},{"$f":"'Year 3'!F31","v":0},{"$f":"'Year 3'!G31","v":0},{"$f":"'Year 3'!H31","v":0},{"$f":"'Year 3'!I31","v":0},{"$f":"'Year 3'!J31","v":0},{"$f":"'Year 3'!K31","v":0},{"$f":"'Year 3'!L31","v":0},{"$f":"'Year 3'!M31","v":0},{"$f":"'Year 3'!N31","v":0},{"$f":"'Year 3'!O31","v":0}]
[null,{"$f":"'Year 1'!B34","v":"نفقات متنوعة"},{"$f":"'Year 3'!D32","v":0},{"$f":"'Year 3'!E32","v":0},{"$f":"'Year 3'!F32","v":0},{"$f":"'Year 3'!G32","v":0},{"$f":"'Year 3'!H32","v":0},{"$f":"'Year 3'!I32","v":0},{"$f":"'Year 3'!J32","v":0},{"$f":"'Year 3'!K32","v":0},{"$f":"'Year 3'!L32","v":0},{"$f":"'Year 3'!M32","v":0},{"$f":"'Year 3'!N32","v":0},{"$f":"'Year 3'!O32","v":0}]
[null,{"$f":"'Year 1'!B35","v":"النفقات المكتبية"},{"$f":"'Year 3'!D33","v":0},{"$f":"'Year 3'!E33","v":0},{"$f":"'Year 3'!F33","v":0},{"$f":"'Year 3'!G33","v":0},{"$f":"'Year 3'!H33","v":0},{"$f":"'Year 3'!I33","v":0},{"$f":"'Year 3'!J33","v":0},{"$f":"'Year 3'!K33","v":0},{"$f":"'Year 3'!L33","v":0},{"$f":"'Year 3'!M33","v":0},{"$f":"'Year 3'!N33","v":0},{"$f":"'Year 3'!O33","v":0}]
[null,{"$f":"'Year 1'!B36","v":"الأجور"},{"$f":"'Year 3'!D34","v":0},{"$f":"'Year 3'!E34","v":0},{"$f":"'Year 3'!F34","v":0},{"$f":"'Year 3'!G34","v":0},{"$f":"'Year 3'!H34","v":0},{"$f":"'Year 3'!I34","v":0},{"$f":"'Year 3'!J34","v":0},{"$f":"'Year 3'!K34","v":0},{"$f":"'Year 3'!L34","v":0},{"$f":"'Year 3'!M34","v":0},{"$f":"'Year 3'!N34","v":0},{"$f":"'Year 3'!O34","v":0}]
[null,{"$f":"'Year 1'!B37","v":"ضرائب الأجور (11.15٪ من الأجور)"},{"$f":"'Year 3'!D35","v":0},{"$f":"'Year 3'!E35","v":0},{"$f":"'Year 3'!F35","v":0},{"$f":"'Year 3'!G35","v":0},{"$f":"'Year 3'!H35","v":0},{"$f":"'Year 3'!I35","v":0},{"$f":"'Year 3'!J35","v":0},{"$f":"'Year 3'!K35","v":0},{"$f":"'Year 3'!L35","v":0},{"$f":"'Year 3'!M35","v":0},{"$f":"'Year 3'!N35","v":0},{"$f":"'Year 3'!O35","v":0}]
[null,{"$f":"'Year 1'!B38","v":"المواد المرجعية"},{"$f":"'Year 3'!D36","v":0},{"$f":"'Year 3'!E36","v":0},{"$f":"'Year 3'!F36","v":0},{"$f":"'Year 3'!G36","v":0},{"$f":"'Year 3'!H36","v":0},{"$f":"'Year 3'!I36","v":0},{"$f":"'Year 3'!J36","v":0},{"$f":"'Year 3'!K36","v":0},{"$f":"'Year 3'!L36","v":0},{"$f":"'Year 3'!M36","v":0},{"$f":"'Year 3'!N36","v":0},{"$f":"'Year 3'!O36","v":0}]
[null,{"$f":"'Year 1'!B39","v":"الإيجار"},{"$f":"'Year 3'!D37","v":0},{"$f":"'Year 3'!E37","v":0},{"$f":"'Year 3'!F37","v":0},{"$f":"'Year 3'!G37","v":0},{"$f":"'Year 3'!H37","v":0},{"$f":"'Year 3'!I37","v":0},{"$f":"'Year 3'!J37","v":0},{"$f":"'Year 3'!K37","v":0},{"$f":"'Year 3'!L37","v":0},{"$f":"'Year 3'!M37","v":0},{"$f":"'Year 3'!N37","v":0},{"$f":"'Year 3'!O37","v":0}]
[null,{"$f":"'Year 1'!B40","v":"التصليح والصيانة"},{"$f":"'Year 3'!D38","v":0},{"$f":"'Year 3'!E38","v":0},{"$f":"'Year 3'!F38","v":0},{"$f":"'Year 3'!G38","v":0},{"$f":"'Year 3'!H38","v":0},{"$f":"'Year 3'!I38","v":0},{"$f":"'Year 3'!J38","v":0},{"$f":"'Year 3'!K38","v":0},{"$f":"'Year 3'!L38","v":0},{"$f":"'Year 3'!M38","v":0},{"$f":"'Year 3'!N38","v":0},{"$f":"'Year 3'!O38","v":0}]
[null,{"$f":"'Year 1'!B41","v":"نفقات الأمن"},{"$f":"'Year 3'!D39","v":0},{"$f":"'Year 3'!E39","v":0},{"$f":"'Year 3'!F39","v":0},{"$f":"'Year 3'!G39","v":0},{"$f":"'Year 3'!H39","v":0},{"$f":"'Year 3'!I39","v":0},{"$f":"'Year 3'!J39","v":0},{"$f":"'Year 3'!K39","v":0},{"$f":"'Year 3'!L39","v":0},{"$f":"'Year 3'!M39","v":0},{"$f":"'Year 3'!N39","v":0},{"$f":"'Year 3'!O39","v":0}]
[null,{"$f":"'Year 1'!B42","v":"المستلزمات"},{"$f":"'Year 3'!D40","v":0},{"$f":"'Year 3'!E40","v":0},{"$f":"'Year 3'!F40","v":0},{"$f":"'Year 3'!G40","v":0},{"$f":"'Year 3'!H40","v":0},{"$f":"'Year 3'!I40","v":0},{"$f":"'Year 3'!J40","v":0},{"$f":"'Year 3'!K40","v":0},{"$f":"'Year 3'!L40","v":0},{"$f":"'Year 3'!M40","v":0},{"$f":"'Year 3'!N40","v":0},{"$f":"'Year 3'!O40","v":0}]
[null,{"$f":"'Year 1'!B43","v":"الضرائب -غير الأجور"},{"$f":"'Year 3'!D41","v":0},{"$f":"'Year 3'!E41","v":0},{"$f":"'Year 3'!F41","v":0},{"$f":"'Year 3'!G41","v":0},{"$f":"'Year 3'!H41","v":0},{"$f":"'Year 3'!I41","v":0},{"$f":"'Year 3'!J41","v":0},{"$f":"'Year 3'!K41","v":0},{"$f":"'Year 3'!L41","v":0},{"$f":"'Year 3'!M41","v":0},{"$f":"'Year 3'!N41","v":0},{"$f":"'Year 3'!O41","v":0}]
[null,{"$f":"'Year 1'!B44","v":"الهاتف/المرافق"},{"$f":"'Year 3'!D42","v":0},{"$f":"'Year 3'!E42","v":0},{"$f":"'Year 3'!F42","v":0},{"$f":"'Year 3'!G42","v":0},{"$f":"'Year 3'!H42","v":0},{"$f":"'Year 3'!I42","v":0},{"$f":"'Year 3'!J42","v":0},{"$f":"'Year 3'!K42","v":0},{"$f":"'Year 3'!L42","v":0},{"$f":"'Year 3'!M42","v":0},{"$f":"'Year 3'!N42","v":0},{"$f":"'Year 3'!O42","v":0}]
[null,{"$f":"'Year 1'!B45","v":"العمالة المؤقتة "},{"$f":"'Year 3'!D43","v":0},{"$f":"'Year 3'!E43","v":0},{"$f":"'Year 3'!F43","v":0},{"$f":"'Year 3'!G43","v":0},{"$f":"'Year 3'!H43","v":0},{"$f":"'Year 3'!I43","v":0},{"$f":"'Year 3'!J43","v":0},{"$f":"'Year 3'!K43","v":0},{"$f":"'Year 3'!L43","v":0},{"$f":"'Year 3'!M43","v":0},{"$f":"'Year 3'!N43","v":0},{"$f":"'Year 3'!O43","v":0}]
[null,{"$f":"'Year 1'!B46","v":"المعارض التجارية/المؤتمرات "},{"$f":"'Year 3'!D44","v":0},{"$f":"'Year 3'!E44","v":0},{"$f":"'Year 3'!F44","v":0},{"$f":"'Year 3'!G44","v":0},{"$f":"'Year 3'!H44","v":0},{"$f":"'Year 3'!I44","v":0},{"$f":"'Year 3'!J44","v":0},{"$f":"'Year 3'!K44","v":0},{"$f":"'Year 3'!L44","v":0},{"$f":"'Year 3'!M44","v":0},{"$f":"'Year 3'!N44","v":0},{"$f":"'Year 3'!O44","v":0}]
[null,{"$f":"'Year 1'!B47","v":"إزالة القمامة"},{"$f":"'Year 3'!D45","v":0},{"$f":"'Year 3'!E45","v":0},{"$f":"'Year 3'!F45","v":0},{"$f":"'Year 3'!G45","v":0},{"$f":"'Year 3'!H45","v":0},{"$f":"'Year 3'!I45","v":0},{"$f":"'Year 3'!J45","v":0},{"$f":"'Year 3'!K45","v":0},{"$f":"'Year 3'!L45","v":0},{"$f":"'Year 3'!M45","v":0},{"$f":"'Year 3'!N45","v":0},{"$f":"'Year 3'!O45","v":0}]
[null,{"$f":"'Year 1'!B48","v":"نفقات السفر/السيارة"},{"$f":"'Year 3'!D46","v":0},{"$f":"'Year 3'!E46","v":0},{"$f":"'Year 3'!F46","v":0},{"$f":"'Year 3'!G46","v":0},{"$f":"'Year 3'!H46","v":0},{"$f":"'Year 3'!I46","v":0},{"$f":"'Year 3'!J46","v":0},{"$f":"'Year 3'!K46","v":0},{"$f":"'Year 3'!L46","v":0},{"$f":"'Year 3'!M46","v":0},{"$f":"'Year 3'!N46","v":0},{"$f":"'Year 3'!O46","v":0}]
["مجموع النفقات التشغيلية",null,{"$f":"SUM(C22:C49)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["معدل الربح (الخسارة) قبل الضرائب",null,{"$f":"C18-C50","v":0},{"$f":"D18-D50","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["معدل الربح (الخسارة) التراكمي قبل الضرائب",null,null,{"$f":"C52+D52","v":0},{"$f":"D54+E52","v":0},{"$f":"E54+F52","v":0},0,0,0,0,0,0,0,0]
[]
[]
[null,"نفقات الإستهلاك (شهرياً)"]
[null,{"$f":"'IS - Year 2'!B58","v":"المعدات والأثاث والتجهيزات وتحسين المباني (7 سنوات)"},{"$f":"ROUND(('BS - Year 1'!D19+'BS -Year 3'!D16+'BS -Year 3'!D17)/7/12,0)","v":0},{"$f":"C58","v":0},{"$f":"D58","v":0},0,0,0,0,0,0,0,0,0]
[null,"هذا الشهر",{"$f":"SUM(C58:C58)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"استهلاك لائحة العملاء (شهرياً)",{"$f":"ROUND(INPUT!F21/60,-1)","v":0},{"$f":"C61","v":0},{"$f":"D61","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"BS -Year 3","index":11,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["جدول الميزانية "]
[{"$f":"'Year 3'!A2","v":"السنة الثالثة (متوقعة)"}]
[{"$f":"'Year 1'!A3","v":"الشركة"}]
[null,{"$f":"'IS - Year 1'!B7","v":" "},null,null,null,null,null,"صاحب الشركة: ",{"$f":"'IS - Year 1'!H7","v":0}]
[]
[null,null,null,{"$f":"'Year 1'!D7","v":"الشهر 1"},{"$f":"'Year 1'!E7","v":"الشهر 2"},{"$f":"'Year 1'!F7","v":"الشهر 3"},{"$f":"'Year 1'!G7","v":"الشهر 4"},{"$f":"'Year 1'!H7","v":"الشهر 5"},{"$f":"'Year 1'!I7","v":"الشهر 6"},{"$f":"'Year 1'!J7","v":"الشهر 7"},{"$f":"'Year 1'!K7","v":"الشهر 8"},{"$f":"'Year 1'!L7","v":"الشهر 9"},{"$f":"'Year 1'!M7","v":"الشهر 10"},{"$f":"'Year 1'!N7","v":"الشهر 11"},{"$f":"'Year 1'!O7","v":"الشهر 12"}]
[]
["الأصول"]
[null,"الأصول الحالية"]
[null,null,"النقد المتوفر في متناول اليد ",{"$f":"'Year 3'!D54","v":0},{"$f":"'Year 3'!E54","v":0},{"$f":"'Year 3'!F54","v":0},{"$f":"'Year 3'!G54","v":0},{"$f":"'Year 3'!H54","v":0},{"$f":"'Year 3'!I54","v":0},{"$f":"'Year 3'!J54","v":0},{"$f":"'Year 3'!K54","v":0},{"$f":"'Year 3'!L54","v":0},{"$f":"'Year 3'!M54","v":0},{"$f":"'Year 3'!N54","v":0},{"$f":"'Year 3'!O54","v":0}]
[null,null,"المخزون",{"$f":"'IS - Year 3'!C15","v":0},{"$f":"'IS - Year 3'!D15","v":0},{"$f":"'IS - Year 3'!E15","v":0},{"$f":"'IS - Year 3'!F15","v":0},{"$f":"'IS - Year 3'!G15","v":0},{"$f":"'IS - Year 3'!H15","v":0},{"$f":"'IS - Year 3'!I15","v":0},{"$f":"'IS - Year 3'!J15","v":0},{"$f":"'IS - Year 3'!K15","v":0},{"$f":"'IS - Year 3'!L15","v":0},{"$f":"'IS - Year 3'!M15","v":0},{"$f":"'IS - Year 3'!N15","v":0}]
[null,{"$f":"'BS - Year 1'!$B$16","v":"مجموع الأصول الحالية"},null,{"$f":"SUM(D10:D11)","v":0},{"$f":"SUM(E10:E11)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"'BS - Year 1'!$B$18","v":"الأصول الثابتة"}]
[null,null,"المعدات",{"$f":"'BS - Year 1'!O19","v":0},{"$f":"D15","v":0},{"$f":"E15","v":0},0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'BS - Year 1'!C20","v":"الأثاث والتجهيزات"},{"$f":"'BS -Year 2'!D16","v":0},{"$f":"'BS -Year 2'!E16","v":0},{"$f":"'BS -Year 2'!F16","v":0},{"$f":"'BS -Year 2'!G16","v":0},{"$f":"'BS -Year 2'!H16","v":0},{"$f":"'BS -Year 2'!I16","v":0},{"$f":"'BS -Year 2'!J16","v":0},{"$f":"'BS -Year 2'!K16","v":0},{"$f":"'BS -Year 2'!L16","v":0},{"$f":"'BS -Year 2'!M16","v":0},{"$f":"'BS -Year 2'!N16","v":0},{"$f":"'BS -Year 2'!O16","v":0}]
[null,null,{"$f":"'BS - Year 1'!C21","v":"تحسين المباني"},{"$f":"'BS -Year 2'!D17","v":0},{"$f":"'BS -Year 2'!E17","v":0},{"$f":"'BS -Year 2'!F17","v":0},{"$f":"'BS -Year 2'!G17","v":0},{"$f":"'BS -Year 2'!H17","v":0},{"$f":"'BS -Year 2'!I17","v":0},{"$f":"'BS -Year 2'!J17","v":0},{"$f":"'BS -Year 2'!K17","v":0},{"$f":"'BS -Year 2'!L17","v":0},{"$f":"'BS -Year 2'!M17","v":0},{"$f":"'BS -Year 2'!N17","v":0},{"$f":"'BS -Year 2'!O17","v":0}]
[null,null,"معدل الاستهلاك المتراكم",{"$f":"'BS -Year 2'!O18-'IS - Year 3'!C58","v":0},{"$f":"D18-'IS - Year 3'!D58","v":0},{"$f":"E18-'IS - Year 3'!E58","v":0},{"$f":"F18-'IS - Year 3'!F58","v":0},{"$f":"G18-'IS - Year 3'!G58","v":0},{"$f":"H18-'IS - Year 3'!H58","v":0},{"$f":"I18-'IS - Year 3'!I58","v":0},{"$f":"J18-'IS - Year 3'!J58","v":0},{"$f":"K18-'IS - Year 3'!K58","v":0},{"$f":"L18-'IS - Year 3'!L58","v":0},{"$f":"M18-'IS - Year 3'!M58","v":0},{"$f":"N18-'IS - Year 3'!N58","v":0}]
[null,{"$f":"'BS - Year 1'!$B$23","v":"مجموع الأصول الثابتة"},null,{"$f":"SUM(D15:D18)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"'BS - Year 1'!$B$25","v":"لائحة العملاء، معدل الاستهلاك الصافي"},null,{"$f":"'BS -Year 2'!O21-'IS - Year 3'!C61","v":0},{"$f":"D21-'IS - Year 3'!D61","v":0},{"$f":"E21-'IS - Year 3'!E61","v":0},{"$f":"F21-'IS - Year 3'!F61","v":0},{"$f":"G21-'IS - Year 3'!G61","v":0},{"$f":"H21-'IS - Year 3'!H61","v":0},{"$f":"I21-'IS - Year 3'!I61","v":0},{"$f":"J21-'IS - Year 3'!J61","v":0},{"$f":"K21-'IS - Year 3'!K61","v":0},{"$f":"L21-'IS - Year 3'!L61","v":0},{"$f":"M21-'IS - Year 3'!M61","v":0},{"$f":"N21-'IS - Year 3'!N61","v":0}]
[]
[null,{"$f":"'BS - Year 1'!$B$27","v":"مجموع الأصول"},null,{"$f":"D19+D12+D21","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"'BS - Year 1'!$A$29","v":"الإلتزامات وحقوق الملكية"}]
[null,{"$f":"'BS - Year 1'!$B$30","v":"التزامات طويلة الأجل"}]
[null,null,{"$f":"'BS - Year 1'!$C$31","v":"القروض غير المصرفية"},{"$f":"INPUT!F9","v":0},{"$f":"D27","v":0},{"$f":"E27","v":0},0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'BS - Year 1'!$C$32","v":"القرض المصرفي"},{"$f":"'BS -Year 2'!O28-'Year 3'!D50","v":0},{"$f":"D28-'Year 3'!E50","v":0},{"$f":"E28-'Year 3'!F50","v":0},{"$f":"F28-'Year 3'!G50","v":0},{"$f":"G28-'Year 3'!H50","v":0},{"$f":"H28-'Year 3'!I50","v":0},{"$f":"I28-'Year 3'!J50","v":0},{"$f":"J28-'Year 3'!K50","v":0},{"$f":"K28-'Year 3'!L50","v":0},{"$f":"L28-'Year 3'!M50","v":0},{"$f":"M28-'Year 3'!N50","v":0},{"$f":"N28-'Year 3'!O50","v":0}]
[null,null,"مجموع الإلتزامات",{"$f":"SUM(D27:D28)","v":0},{"$f":"SUM(E27:E28)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'BS - Year 1'!$B$34","v":"حقوق الملكية"}]
[null,null,"حقوق ملكية صاحب الشركة",{"$f":"'BS -Year 2'!D31","v":0},{"$f":"'BS -Year 2'!E31","v":0},{"$f":"'BS -Year 2'!F31","v":0},{"$f":"'BS -Year 2'!G31","v":0},{"$f":"'BS -Year 2'!H31","v":0},{"$f":"'BS -Year 2'!I31","v":0},{"$f":"'BS -Year 2'!J31","v":0},{"$f":"'BS -Year 2'!K31","v":0},{"$f":"'BS -Year 2'!L31","v":0},{"$f":"'BS -Year 2'!M31","v":0},{"$f":"'BS -Year 2'!N31","v":0},{"$f":"'BS -Year 2'!O31","v":0}]
[null,null,"مسحوبات صاحب الشركة الشخصية",{"$f":"-'Year 3'!D49","v":0},{"$f":"-'Year 3'!E49+D32","v":0},{"$f":"-'Year 3'!F49+E32","v":0},{"$f":"-'Year 3'!G49+F32","v":0},{"$f":"-'Year 3'!H49+G32","v":0},{"$f":"-'Year 3'!I49+H32","v":0},{"$f":"-'Year 3'!J49+I32","v":0},{"$f":"-'Year 3'!K49+J32","v":0},{"$f":"-'Year 3'!L49+K32","v":0},{"$f":"-'Year 3'!M49+L32","v":0},{"$f":"-'Year 3'!N49+M32","v":0},{"$f":"-'Year 3'!O49+N32","v":0}]
[null,null,"الأرباح المحتجزة",{"$f":"SUM('BS -Year 2'!O32:O34)","v":0},{"$f":"D33","v":0},{"$f":"E33","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"معدل الدخل الصافي (خسارة)",{"$f":"'IS - Year 3'!C52","v":0},{"$f":"D34+'IS - Year 3'!D52","v":0},{"$f":"E34+'IS - Year 3'!E52","v":0},{"$f":"F34+'IS - Year 3'!F52","v":0},{"$f":"G34+'IS - Year 3'!G52","v":0},{"$f":"H34+'IS - Year 3'!H52","v":0},{"$f":"I34+'IS - Year 3'!I52","v":0},{"$f":"J34+'IS - Year 3'!J52","v":0},{"$f":"K34+'IS - Year 3'!K52","v":0},{"$f":"L34+'IS - Year 3'!L52","v":0},{"$f":"M34+'IS - Year 3'!M52","v":0},{"$f":"N34+'IS - Year 3'!N52","v":0}]
[null,{"$f":"'BS - Year 1'!$B$39","v":"قيمة إجمالي حقوق الملكية "},null,{"$f":"SUM(D31:D34)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"'BS - Year 1'!$B$41","v":"قيمة إجمالي حقوق الملكية والالتزامات"},null,{"$f":"D29+D35","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Loan","index":12,"n_rows":134,"n_cols":5,"rows_kept":134,"cut":false,"hidden":false,"merged":[]}
["هذه الصفحة مخصصة فقط لأغراض حسابية "]
["ولا يجب أن تكون ضمن حزمة خطة العمل"]
[]
[]
[]
[]
["مبلغ القرض الأصلي",null,{"$f":"INPUT!F11","v":0}]
["معدل الفائدة",null,{"$f":"INPUT!F13","v":0}]
["تسديد القرض (الأشهر)",null,{"$f":"INPUT!F12","v":0}]
["تسديد القرض الشهري",null,{"$f":"IF(C7=0,0,-ROUND(PMT(C8/12,C9,C7,0),0))","v":0}]
[]
[]
[null,"استهلاك القرض"]
[null,null,"الأصلي ","الفائدة","الرصيد"]
[null,1,{"$f":"C10-D15","v":0},{"$f":"ROUND(C7*($C$8/12),2)","v":0},{"$f":"C7-C15","v":0}]
[null,2,{"$f":"$C$10-D16","v":0},{"$f":"ROUND(E15*($C$8/12),2)","v":0},{"$f":"E15-C16","v":0}]
[null,3,0,0,{"$f":"E16-C17","v":0}]
[null,4,0,0,{"$f":"E17-C18","v":0}]
[null,5,0,0,{"$f":"E18-C19","v":0}]
[null,6,0,{"$f":"ROUND(E19*($C$8/12),2)","v":0},{"$f":"E19-C20","v":0}]
[null,7,0,0,{"$f":"E20-C21","v":0}]
[null,8,0,0,0]
[null,9,0,0,0]
[null,10,0,0,0]
[null,11,0,0,0]
[null,12,0,0,0]
[null,13,{"$f":"IF(B27<$C$9,$C$10-D27,0)","v":0},{"$f":"IF(B27<$C$9,ROUND(E26*($C$8/12),2),0)","v":0},{"$f":"IF($C$9>=B27,E26-C27,0)","v":0}]
[null,14,{"$f":"IF(B28<$C$9,$C$10-D28,0)","v":0},{"$f":"IF(B28<$C$9,ROUND(E27*($C$8/12),2),0)","v":0},{"$f":"IF($C$9>=B28,E27-C28,0)","v":0}]
[null,15,0,0,0]
[null,16,0,0,0]
[null,17,0,0,0]
[null,18,0,0,0]
[null,19,0,0,0]
[null,20,0,0,0]
[null,21,0,0,0]
[null,22,0,0,0]
[null,23,0,0,0]
[null,24,0,0,0]
[null,25,0,0,0]
[null,26,0,0,0]
[null,27,0,0,0]
[null,28,0,0,0]
[null,29,0,0,0]
[null,30,0,0,0]
[null,31,0,0,0]
[null,32,0,0,0]
[null,33,0,0,0]
[null,34,0,0,0]
[null,35,0,0,0]
[null,36,0,0,0]
[null,37,0,0,0]
[null,38,0,0,0]
[null,39,0,0,0]
[null,40,0,0,0]
[null,41,0,0,0]
[null,42,0,0,0]
[null,43,0,0,0]
[null,44,0,0,0]
[null,45,0,0,0]
[null,46,0,0,0]
[null,47,0,0,0]
[null,48,0,0,0]
[null,49,0,0,0]
[null,50,0,0,0]
[null,51,0,0,0]
[null,52,0,0,0]
[null,53,0,0,0]
[null,54,0,0,0]
[null,55,0,0,0]
[null,56,0,0,0]
[null,57,0,0,0]
[null,58,0,0,0]
[null,59,0,0,0]
[null,60,{"$f":"IF($C$9>=B74,$C$10-D74,0)","v":0},{"$f":"IF($C$9>=B74,ROUND(E73*($C$8/12),2),0)","v":0},0]
[null,61,0,0,0]
[null,62,0,0,0]
[null,63,0,0,0]
[null,64,0,0,0]
[null,65,0,0,0]
[null,66,0,0,0]
[null,67,0,0,0]
[null,68,0,0,0]
[null,69,0,0,0]
[null,70,0,0,0]
[null,71,0,0,0]
[null,72,0,0,0]
[null,73,0,0,0]
[null,74,0,0,0]
[null,75,0,0,0]
[null,76,0,0,0]
[null,77,0,0,0]
[null,78,{"$f":"IF(B92<$C$9,$C$10-D92,0)","v":0},{"$f":"IF(B92<$C$9,ROUND(E91*($C$8/12),2),0)","v":0},{"$f":"IF($C$9>=B92,E91-C92,0)","v":0}]
[null,79,0,0,0]
[null,80,0,0,0]
[null,81,0,0,0]
[null,82,0,0,0]
[null,83,0,0,0]
[null,84,0,0,0]
[null,85,0,0,0]
[null,86,0,0,0]
[null,87,0,0,0]
[null,88,0,0,0]
[null,89,0,0,0]
[null,90,0,0,0]
[null,91,0,0,0]
[null,92,0,0,0]
[null,93,0,0,0]
[null,94,0,0,0]
[null,95,0,0,0]
[null,96,0,0,0]
[null,97,0,0,0]
[null,98,0,0,0]
[null,99,0,0,0]
[null,100,0,0,0]
[null,101,0,0,0]
[null,102,0,0,0]
[null,103,0,0,0]
[null,104,0,0,0]
[null,105,0,0,0]
[null,106,0,0,0]
[null,107,0,0,0]
[null,108,0,0,0]
[null,109,0,0,0]
[null,110,0,0,0]
[null,111,0,0,0]
[null,112,0,0,0]
[null,113,0,0,0]
[null,114,0,0,0]
[null,115,0,0,0]
[null,116,0,0,0]
[null,117,0,0,0]
[null,118,0,0,0]
[null,119,0,0,0]
[null,120,0,0,0]