{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["نموذج معدل دوران المخزون"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"نموذج معدل دوران المخزون","index":0,"n_rows":39,"n_cols":3,"rows_kept":39,"merged":[[6,1,6,2],[19,1,19,2],[25,1,25,2],[29,1,29,2]]}
["نموذج معدل دوران المخزون",2025,2026]
[null,"(ريال سعودي)","(ريال سعودي)"]
["قائمة الدخل"]
["الإيرادات",{"v":200355,"d":"200,355"},{"v":150779,"d":"150,779"}]
[" تكلفة البضائع المباعة",{"v":70525,"d":"70,525"},{"v":45162,"d":"45,162"}]
[" الربح الإجمالي",{"$f":"B4-B5","v":{"v":129830,"d":"129,830"}},{"v":105617,"d":"105,617"}]
[" المصروفات"]
[" التسويق والإعلان والترويج",{"v":25245,"d":"25,245"},{"v":28194,"d":"28,194"}]
["الإدارة العامة والإدارية",{"v":11412,"d":"11,412"},{"v":15000,"d":"15,000"}]
[" الإهلاك والاستهلاك",{"v":16080,"d":"16,080"},{"v":13132,"d":"13,132"}]
["الفوائد",{"v":1500,"d":"1,500"},{"v":3000,"d":"3,000"}]
[" إجمالي المصروفات",{"$f":"SUM(B8:B11)","v":{"v":54237,"d":"54,237"}},{"v":59326,"d":"59,326"}]
["الأرباح قبل الضريبة",{"$f":"B6-B12","v":{"v":75593,"d":"75,593"}},{"v":46291,"d":"46,291"}]
[]
["الضرائب",{"v":11598,"d":"11,598"},{"v":10322,"d":"10,322"}]
[" الدخل الصافي",{"$f":"B13-B15","v":{"v":63995,"d":"63,995"}},{"v":35969,"d":"35,969"}]
[]
["قائمة الميزانية العامة"]
[]
[" الأصول"]
["النقد",{"v":139550,"d":"139,550"},{"v":161050,"d":"161,050"}]
[" المديونيات التجارية",{"v":7539,"d":"7,539"},{"v":8179,"d":"8,179"}]
[" المخزون",{"v":11342,"d":"11,342"},{"v":15267,"d":"15,267"}]
[" الأصول الثابتة والمعدات",{"v":37521,"d":"37,521"},{"v":39389,"d":"39,389"}]
[" إجمالي الأصول",{"$f":"SUM(B21:B24)","v":{"v":195952,"d":"195,952"}},{"v":223885,"d":"223,885"}]
[" الالتزامات"]
[" الديون التجارية",{"v":5671,"d":"5,671"},{"v":7061,"d":"7,061"}]
["الديون",{"v":30000,"d":"30,000"},{"v":30000,"d":"30,000"}]
[" إجمالي الالتزامات",{"$f":"SUM(B27:B28)","v":{"v":35671,"d":"35,671"}},{"v":37061,"d":"37,061"}]
[" حقوق المساهمين"]
[" رأس المال الخاص",{"v":70000,"d":"70,000"},{"v":70000,"d":"70,000"}]
[" الأرباح المبقاة",{"v":90280,"d":"90,280"},{"v":116824,"d":"116,824"}]
[" حقوق المساهمين",{"$f":"SUM(B31:B32)","v":{"v":160280,"d":"160,280"}},{"v":186824,"d":"186,824"}]
[" إجمالي الالتزامات وحقوق المساهمين",{"$f":"B29+B33","v":{"v":195951,"d":"195,951"}},{"v":223885,"d":"223,885"}]
[]
["حساب معدل دوران المخزون"]
[]
[" نسبة دوران المخزون",{"$f":"B5/AVERAGE(B23)","v":{"v":6.218039146535003,"d":"6.22"}},{"$f":"C5/AVERAGE(C23,B23)","v":{"v":3.3944905858919916,"d":"3.39"}}]
[" أيام المخزون",{"$f":"1/B38*365","v":{"v":58.70017724211273,"d":"58.70"}},{"v":107.52717993002966,"d":"107.53"}]