{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["الربح والخسارة","الميزانية العمومية","التدفق النقدي"],"read":"whole","date_system":"1900"}

{"sheet":"الربح والخسارة","index":0,"n_rows":35,"n_cols":11,"rows_kept":35,"merged":[[2,6,2,10]]}
[null,"السيناريو","الحالة الأسوأ"]
[]
[{"$nulls":6},"توقعات"]
[null,"ريال سعودي (بالمليون)  ",2020,2021,2022,null,2023,2024,2025,2026,2027]
[null,"الإيرادات",{"v":2922,"d":"2,922"},{"v":2984,"d":"2,984"},{"v":3040,"d":"3,040"},null,{"v":3070,"d":"3,070"},{"v":3101,"d":"3,101"},{"v":3132,"d":"3,132"},{"v":3163,"d":"3,163"},{"v":3195,"d":"3,195"}]
[null,"تكلفة البضائع المباعة",{"v":-1401,"d":"-1,401"},{"v":-1383,"d":"-1,383"},{"v":-1367,"d":"-1,367"},null,{"v":-1443,"d":"-1,443"},{"v":-1458,"d":"-1,458"},{"v":-1472,"d":"-1,472"},{"v":-1487,"d":"-1,487"},{"v":-1502,"d":"-1,502"}]
[null,"الربح الإجمالي",{"$f":"SUM(C5:C6)","v":{"v":1521,"d":"1,521"}},{"v":1601,"d":"1,601"},{"v":1673,"d":"1,673"},null,{"$f":"SUM(G5:G6)","v":{"v":1627,"d":"1,627"}},{"v":1643,"d":"1,643"},{"v":1660,"d":"1,660"},{"v":1676,"d":"1,676"},{"v":1693,"d":"1,693"}]
[null,"النفقات التشغيلية",{"v":-1212,"d":"-1,212"},{"v":-1245,"d":"-1,245"},{"v":-1068,"d":"-1,068"},null,{"v":-1259,"d":"-1,259"},{"v":-1271,"d":"-1,271"},{"v":-1284,"d":"-1,284"},{"v":-1297,"d":"-1,297"},{"v":-1310,"d":"-1,310"}]
[null,"إيرادات قبل الفائدة، والضرائب، والاستهلاك، والاطفاء",{"$f":"SUM(C7:C8)","v":309},356,605,null,{"$f":"SUM(G7:G8)","v":368},372,376,379,383]
[null,"الاستهلاك والاطفاء",-31,-44,-41,null,-44,-45,-46,-47,-47]
[null,"إيرادات قبل الفائدة والضرائب",{"$f":"SUM(C9:C10)","v":278},312,564,null,{"$f":"SUM(G9:G10)","v":324},327,330,332,336]
[null,"نفقات الفائدة",-50,-67,-55,null,-59,-55,-51,-47,-41]
[null,"الربح قبل الضرائب",{"$f":"SUM(C11:C12)","v":228},245,509,null,{"$f":"SUM(G11:G12)","v":265},272,279,285,295]
[null,"الضرائب",-208,-210,-209,null,-93,-95,-98,-100,-103]
[null,"الدخل الصافي",{"$f":"SUM(C13:C14)","v":20},35,300,null,{"$f":"SUM(G13:G14)","v":172},177,181,185,192]
[]
[null,"نسبة نمو الإيرادات"]
[null,"الحالة المختارة",{"$nulls":4},{"$f":"VLOOKUP($C$1,$B19:$K21,COLUMNS($B19:G23),FALSE)","v":{"v":0.01,"d":"1%"}},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"}]
[null,"الحالة الأمثل",{"$nulls":4},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"}]
[null," الحالة الأساسية",{"$nulls":4},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"}]
[null,"الحالة الأسوأ",{"$nulls":4},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"}]
[]
[null,"تكلفة البضائع المباعة كنسبة من الإيرادات"]
[null,"الحالة المختارة",{"$f":"C6/C5","v":{"v":-0.4794661190965092,"d":"-48%"}},{"v":-0.46347184986595175,"d":"-46%"},{"v":-0.44967105263157897,"d":"-45%"},null,{"$f":"VLOOKUP($C$1,$B25:$K27,COLUMNS($B25:G29),FALSE)","v":{"v":-0.47,"d":"-47%"}},{"v":-0.47,"d":"-47%"},{"v":-0.47,"d":"-47%"},{"v":-0.47,"d":"-47%"},{"v":-0.47,"d":"-47%"}]
[null,"الحالة الأمثل",{"v":-0.48,"d":"-48%"},{"v":-0.46,"d":"-46%"},{"v":-0.45,"d":"-45%"},null,{"v":-0.45,"d":"-45%"},{"v":-0.45,"d":"-45%"},{"v":-0.45,"d":"-45%"},{"v":-0.45,"d":"-45%"},{"v":-0.45,"d":"-45%"}]
[null," الحالة الأساسية",{"v":-0.48,"d":"-48%"},{"v":-0.46,"d":"-46%"},{"v":-0.45,"d":"-45%"},null,{"v":-0.46,"d":"-46%"},{"v":-0.46,"d":"-46%"},{"v":-0.46,"d":"-46%"},{"v":-0.46,"d":"-46%"},{"v":-0.46,"d":"-46%"}]
[null,"الحالة الأسوأ",{"v":-0.48,"d":"-48%"},{"v":-0.46,"d":"-46%"},{"v":-0.45,"d":"-45%"},null,{"v":-0.47,"d":"-47%"},{"v":-0.47,"d":"-47%"},{"v":-0.47,"d":"-47%"},{"v":-0.47,"d":"-47%"},{"v":-0.47,"d":"-47%"}]
[]
[null,"النفقات التشغيلية كنسبة من الإيرادات"]
[null,"الحالة المختارة",{"$f":"C8/C5","v":{"v":-0.41478439425051333,"d":"-41%"}},{"v":-0.41722520107238603,"d":"-42%"},{"v":-0.3513157894736842,"d":"-35%"},null,{"$f":"VLOOKUP($C$1,$B31:$K33,COLUMNS($B31:G33),FALSE)","v":{"v":-0.41,"d":"-41%"}},{"v":-0.41,"d":"-41%"},{"v":-0.41,"d":"-41%"},{"v":-0.41,"d":"-41%"},{"v":-0.41,"d":"-41%"}]
[null,"الحالة الأمثل",{"v":-0.41,"d":"-41%"},{"v":-0.42,"d":"-42%"},{"v":-0.35,"d":"-35%"},null,{"v":-0.35,"d":"-35%"},{"v":-0.35,"d":"-35%"},{"v":-0.35,"d":"-35%"},{"v":-0.35,"d":"-35%"},{"v":-0.35,"d":"-35%"}]
[null," الحالة الأساسية",{"v":-0.41,"d":"-41%"},{"v":-0.42,"d":"-42%"},{"v":-0.35,"d":"-35%"},null,{"v":-0.39,"d":"-39%"},{"v":-0.39,"d":"-39%"},{"v":-0.39,"d":"-39%"},{"v":-0.39,"d":"-39%"},{"v":-0.39,"d":"-39%"}]
[null,"الحالة الأسوأ",{"v":-0.41,"d":"-41%"},{"v":-0.42,"d":"-42%"},{"v":-0.35,"d":"-35%"},null,{"v":-0.41,"d":"-41%"},{"v":-0.41,"d":"-41%"},{"v":-0.41,"d":"-41%"},{"v":-0.41,"d":"-41%"},{"v":-0.41,"d":"-41%"}]
[]
[null,"الضرائب",{"$nulls":4},{"v":0.225,"d":"22.5%"},{"v":0.225,"d":"22.5%"},{"v":0.225,"d":"22.5%"},{"v":0.225,"d":"22.5%"},{"v":0.225,"d":"22.5%"}]

{"sheet":"الميزانية العمومية","index":1,"n_rows":26,"n_cols":10,"rows_kept":26,"merged":[[2,5,2,9]]}
[null,"الميزانية العمومية"]
[]
[{"$nulls":5},"توقعات"]
[null,"ريال سعودي (بالمليون)  ","2020-12-31","2021-12-31","2022-12-31","2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31"]
[null,"المديونات التجارية",143.9,154.8,169.3,160.5,162.1,163.7,165.4,{"v":167,"d":"167.00"}]
[null,"المخزون",85,92,110,99.9,100.9,101.9,102.9,{"v":103.9,"d":"103.90"}]
[null,"الأصول الثابتة والمعدات",632.5,632.5,659.5,673.6,684.3,694.3,703.7,{"v":712.4,"d":"712.40"}]
[null,"النقد",24.8,21.8,220,360.8,406.6,451.7,495.8,{"v":538.6,"d":"538.60"}]
[null,"أصول أخرى",45.9,46.9,68,55.1,55.6,56.2,56.7,{"v":57.3,"d":"57.30"}]
[null,"الأصول",{"$f":"SUM(C5:C9)","v":932.0999999999999},947.9999999999999,1226.8,1349.8999999999999,1409.5,1467.8,1524.5,{"v":1579.2,"d":"1579.20"}]
[]
[null,"الديون التجارية",68,68.9,68.9,71.6,72.3,73,73.7,{"v":74.5,"d":"74.50"}]
[null,"الاحتياطيات",32.5,28.7,28.7,28.7,28.7,28.7,28.7,{"v":28.7,"d":"28.70"}]
[null,"الالتزامات المالية",615.8,610.4,605,616.1,568.8,517.2,461,{"v":399.7,"d":"399.70"}]
[null,"الالتزامات الأخرى",48.3,43.3,38.9,44.9,45.3,45.8,46.2,{"v":46.7,"d":"46.70"}]
[null,"حقوق الملكية",167.5,196.7,485.3,588.6,694.4,803.1,914.8,{"v":1029.7,"d":"1029.70"}]
[null,"الالتزامات وحقوق الملكية",{"$f":"SUM(C12:C16)","v":932.0999999999999},948,1226.8,1349.9,1409.5,1467.8000000000002,1524.4,{"v":1579.3000000000002,"d":"1579.30"}]
[]
[]
[null,"أيام مبيعات الحسابات المدينة (DSO)",{"$f":"C5/'الربح والخسارة'!C5*360","v":{"v":17.72895277207392,"d":"17.7"}},{"$f":"D5/'الربح والخسارة'!D5*360","v":{"v":18.675603217158177,"d":"18.7"}},{"$f":"E5/'الربح والخسارة'!E5*360","v":{"v":20.048684210526318,"d":"20.0"}},{"$f":"AVERAGE(C20:E20)","v":{"v":18.817746733252804,"d":"18.8"}},{"$f":"AVERAGE(C20:E20)","v":{"v":18.817746733252804,"d":"18.8"}},{"$f":"AVERAGE(C20:E20)","v":{"v":18.817746733252804,"d":"18.8"}},{"$f":"AVERAGE(C20:E20)","v":{"v":18.817746733252804,"d":"18.8"}},{"$f":"AVERAGE(C20:E20)","v":{"v":18.817746733252804,"d":"18.8"}}]
[null," أيام مخزون البضائع (DIO)",{"$f":"-C6/'الربح والخسارة'!C6*360","v":{"v":21.841541755888652,"d":"21.8"}},{"$f":"-D6/'الربح والخسارة'!D6*360","v":{"v":23.947939262472886,"d":"23.9"}},{"$f":"-E6/'الربح والخسارة'!E6*360","v":{"v":28.96854425749817,"d":"29.0"}},{"v":24.919341758619904,"d":"24.9"},{"v":24.919341758619904,"d":"24.9"},{"v":24.919341758619904,"d":"24.9"},{"v":24.919341758619904,"d":"24.9"},{"v":24.919341758619904,"d":"24.9"}]
[null,"أيام الحسابات الدائنة (DPO)",{"$f":"-C12/'الربح والخسارة'!C6*360","v":{"v":17.47323340471092,"d":"17.5"}},{"$f":"-D12/'الربح والخسارة'!D6*360","v":{"v":17.934924078091107,"d":"17.9"}},{"$f":"-E12/'الربح والخسارة'!E6*360","v":{"v":18.144842721287493,"d":"18.1"}},{"v":17.851000068029837,"d":"17.9"},{"v":17.851000068029837,"d":"17.9"},{"v":17.851000068029837,"d":"17.9"},{"v":17.851000068029837,"d":"17.9"},{"v":17.851000068029837,"d":"17.9"}]
[null,"نسبة الأصول الأخرى %",{"$f":"C9/'الربح والخسارة'!C5","v":{"v":0.01570841889117043,"d":"1.6%"}},{"$f":"D9/'الربح والخسارة'!D5","v":{"v":0.015717158176943698,"d":"1.6%"}},{"$f":"E9/'الربح والخسارة'!E5","v":{"v":0.02236842105263158,"d":"2.2%"}},{"v":0.017931332706915236,"d":"1.8%"},{"v":0.017931332706915236,"d":"1.8%"},{"v":0.017931332706915236,"d":"1.8%"},{"v":0.017931332706915236,"d":"1.8%"},{"v":0.017931332706915236,"d":"1.8%"}]
[null,"نسبة الالتزامات الأخرى %",{"$f":"C15/'الربح والخسارة'!C5","v":{"v":0.016529774127310062,"d":"1.65%"}},{"$f":"D15/'الربح والخسارة'!D5","v":{"v":0.014510723860589811,"d":"1.45%"}},{"$f":"E15/'الربح والخسارة'!E5","v":{"v":0.012796052631578948,"d":"1.28%"}},{"v":0.014612183539826273,"d":"1.46%"},{"v":0.014612183539826273,"d":"1.46%"},{"v":0.014612183539826273,"d":"1.46%"},{"v":0.014612183539826273,"d":"1.46%"},{"v":0.014612183539826273,"d":"1.46%"}]
[]
[null,"Check",{"$f":"C10-C17","v":0},0,0,0,0,0,{"v":0.09999999999990905,"d":"0"},{"v":-0.10000000000013642,"d":"-0"}]

{"sheet":"التدفق النقدي","index":2,"n_rows":19,"n_cols":7,"rows_kept":19,"merged":[[2,2,2,6]]}
[null,"التدفق النقدي"]
[]
[null,null,"توقعات"]
[null,"ريال سعودي (بالمليون)  ",{"v":2023,"d":"2023.0"},{"v":2024,"d":"2024.0"},{"v":2025,"d":"2025.0"},{"v":2026,"d":"2026.0"},{"v":2027,"d":"2027.0"}]
[null,"إيرادات قبل الفائدة، والضرائب، والاستهلاك، والاطفاء",{"$f":"'الربح والخسارة'!G9","v":{"v":368,"d":"368.0"}},{"$f":"'الربح والخسارة'!H9","v":{"v":372,"d":"372.0"}},{"$f":"'الربح والخسارة'!I9","v":{"v":376,"d":"376.0"}},{"$f":"'الربح والخسارة'!J9","v":{"v":379,"d":"379.0"}},{"$f":"'الربح والخسارة'!K9","v":{"v":383,"d":"383.0"}}]
[null,"نفقات الفائدة",{"$f":"'الربح والخسارة'!G12","v":{"v":-59,"d":"-59.0"}},{"$f":"'الربح والخسارة'!H12","v":{"v":-55,"d":"-55.0"}},{"$f":"'الربح والخسارة'!I12","v":{"v":-51,"d":"-51.0"}},{"$f":"'الربح والخسارة'!J12","v":{"v":-47,"d":"-47.0"}},{"$f":"'الربح والخسارة'!K12","v":{"v":-41,"d":"-41.0"}}]
[null,"الضرائب",{"$f":"'الربح والخسارة'!G14","v":{"v":-93,"d":"-93.0"}},{"$f":"'الربح والخسارة'!H14","v":{"v":-95,"d":"-95.0"}},{"$f":"'الربح والخسارة'!I14","v":{"v":-98,"d":"-98.0"}},{"$f":"'الربح والخسارة'!J14","v":{"v":-100,"d":"-100.0"}},{"$f":"'الربح والخسارة'!K14","v":{"v":-103,"d":"-103.0"}}]
[null,"التغيير في الحسابات التجارية المستحقة",{"$f":"-('الميزانية العمومية'!F5-'الميزانية العمومية'!E5)","v":{"v":8.800000000000011,"d":"8.8"}},{"$f":"-('الميزانية العمومية'!G5-'الميزانية العمومية'!F5)","v":{"v":-1.5999999999999943,"d":"-1.6"}},{"$f":"-('الميزانية العمومية'!H5-'الميزانية العمومية'!G5)","v":{"v":-1.5999999999999943,"d":"-1.6"}},{"$f":"-('الميزانية العمومية'!I5-'الميزانية العمومية'!H5)","v":{"v":-1.700000000000017,"d":"-1.7"}},{"$f":"-('الميزانية العمومية'!J5-'الميزانية العمومية'!I5)","v":{"v":-1.5999999999999943,"d":"-1.6"}}]
[null," التغيير في المخزون",{"$f":"-('الميزانية العمومية'!F6-'الميزانية العمومية'!E6)","v":{"v":10.099999999999994,"d":"10.1"}},{"$f":"-('الميزانية العمومية'!G6-'الميزانية العمومية'!F6)","v":{"v":-1,"d":"-1.0"}},{"$f":"-('الميزانية العمومية'!H6-'الميزانية العمومية'!G6)","v":{"v":-1,"d":"-1.0"}},{"$f":"-('الميزانية العمومية'!I6-'الميزانية العمومية'!H6)","v":{"v":-1,"d":"-1.0"}},{"$f":"-('الميزانية العمومية'!J6-'الميزانية العمومية'!I6)","v":{"v":-1,"d":"-1.0"}}]
[null," التغيير في الديون التجارية",{"$f":"'الميزانية العمومية'!F12-'الميزانية العمومية'!E12","v":{"v":2.6999999999999886,"d":"2.7"}},{"$f":"'الميزانية العمومية'!G12-'الميزانية العمومية'!F12","v":{"v":0.7000000000000028,"d":"0.7"}},{"$f":"'الميزانية العمومية'!H12-'الميزانية العمومية'!G12","v":{"v":0.7000000000000028,"d":"0.7"}},{"$f":"'الميزانية العمومية'!I12-'الميزانية العمومية'!H12","v":{"v":0.7000000000000028,"d":"0.7"}},{"$f":"'الميزانية العمومية'!J12-'الميزانية العمومية'!I12","v":{"v":0.7999999999999972,"d":"0.8"}}]
[null,"التغيير في الأصول الأخرى",{"$f":"-('الميزانية العمومية'!F9-'الميزانية العمومية'!E9)","v":{"v":12.899999999999999,"d":"12.9"}},{"$f":"-('الميزانية العمومية'!G9-'الميزانية العمومية'!F9)","v":-0.5},{"$f":"-('الميزانية العمومية'!H9-'الميزانية العمومية'!G9)","v":{"v":-0.6000000000000014,"d":"-0.6"}},{"$f":"-('الميزانية العمومية'!I9-'الميزانية العمومية'!H9)","v":-0.5},{"$f":"-('الميزانية العمومية'!J9-'الميزانية العمومية'!I9)","v":{"v":-0.5999999999999943,"d":"-0.6"}}]
[null,"التغيير في الالتزامات الأخرى",{"$f":"'الميزانية العمومية'!F15-'الميزانية العمومية'!E15","v":{"v":6,"d":"6.0"}},{"$f":"'الميزانية العمومية'!G15-'الميزانية العمومية'!F15","v":{"v":0.3999999999999986,"d":"0.4"}},{"$f":"'الميزانية العمومية'!H15-'الميزانية العمومية'!G15","v":0.5},{"$f":"'الميزانية العمومية'!I15-'الميزانية العمومية'!H15","v":{"v":0.4000000000000057,"d":"0.4"}},{"$f":"'الميزانية العمومية'!J15-'الميزانية العمومية'!I15","v":0.5}]
[null,"التكاليف الرأسمالية",{"v":-58,"d":"-58.0"},{"v":-56,"d":"-56.0"},{"v":-56,"d":"-56.0"},{"v":-56,"d":"-56.0"},{"v":-56,"d":"-56.0"}]
[null,"تدفق النقد التشغيلي",{"$f":"SUM(C5:C13)","v":198.5},{"v":164.00000000000003,"d":"164.0"},{"v":169.00000000000003,"d":"169.0"},173.9,181.1]
[null,"الأرباح",{"v":-69,"d":"-69.0"},{"v":-71,"d":"-71.0"},{"v":-72,"d":"-72.0"},{"v":-74,"d":"-74.0"},{"v":-77,"d":"-77.0"}]
[null,"التغيير في الالتزامات المالية",{"$f":"'الميزانية العمومية'!F14-'الميزانية العمومية'!E14","v":{"v":11.100000000000023,"d":"11.1"}},{"$f":"'الميزانية العمومية'!G14-'الميزانية العمومية'!F14","v":{"v":-47.30000000000007,"d":"-47.3"}},{"$f":"'الميزانية العمومية'!H14-'الميزانية العمومية'!G14","v":{"v":-51.59999999999991,"d":"-51.6"}},{"$f":"'الميزانية العمومية'!I14-'الميزانية العمومية'!H14","v":{"v":-56.200000000000045,"d":"-56.2"}},{"$f":"'الميزانية العمومية'!J14-'الميزانية العمومية'!I14","v":{"v":-61.30000000000001,"d":"-61.3"}}]
[null," التغيير في الاحتياطيات","-","-","-","-","-"]
[null,"التغيير في حقوق الملكية","-","-","-","-",{"v":0,"d":"0.0"}]
[null," تدفق النقد الصافي",{"$f":"SUM(C14:C16)","v":{"v":140.60000000000002,"d":"140.6"}},{"v":45.69999999999996,"d":"45.7"},{"v":45.40000000000012,"d":"45.4"},{"v":43.69999999999996,"d":"43.7"},{"v":42.79999999999998,"d":"42.8"}]