HI PLEASE ANSWER AND SHOW CALCULATION 
AutoSave Off H. Practical_Exam_ALMARAI_AB_Equity_Valuation_Q_9AM_. - Excel O Search m3853 M M 0 X File Home Insert Page Layout Formulas Data Review View Help Share Comments 3. Insert == ab Calibri > General 11 A A . AP A 280 5 DX Delete Paste BIU E .00 y - % %, Ideas y Sensitivity Conditional Format as Cell Formatting Table Styles Format Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity C41 fi D E F G . H 1 J FM As Z A A B 23 Part1: Capital Structure & WACC 24 Value Capital Structure Market Cap SAR 54,900.000 25 ST Debt SAR 1258.034 26 LT Debt SAR 10,419.935 27 Pref. Equity SAR 0.000 28 Total Capital Structure 29 0.25 0.25 0.25 0.25 0.50 30 7.2807 1.5807 31 Cost of Equity Expected Market Return 32 Risk Free Rate 33 Beta 34 Country (Market) Risk 35 Damir Equity Risk Premium 36 Cost of Equity 37 0.770 0.25 0.25 0.25 38 39 Cost of Debt Total Debt 40 41 Effective Tax Rate 42 1 - Effective Tax Rate 0.25 4.5527 0.25 Note Rate 0.1607 43 PracticalExam + Select destination and press ENTER or choose Paste + 70% Type here to search 31 AD ) ENG X 09:07 06/12/2021 AutoSave Off H. Practical_Exam_ALMARAI_AB_Equity_Valuation_Q_9AM_. - Excel O Search m3853 M M 0 X File Home Insert Page Layout Formulas Data Review View Help Share Comments 3. Insert Calibri == 11AA ab > General 2 O o DX Delete Paste BIU A .00 %) y Ideas y Conditional Format as Cell Formatting Table Styles Sensitivity Sort & Find & Filter Select Format Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity C41 X fx B c D E F G H 1 J K L M A 39 Cost of Debt 40 Total Debt 41 Effective Tax Rate 1 - Effective Tax Rate 42 0.25 4.5527 0.25 0.1607 43 Note Rate 1.5807 1.480 Risk Free Rate 44 Debt Adjustment 45 ES Total Pre-Tax Cost of 46 47 Total Pre-Tax Cost of - 48. Total Pre-Tax Cost of n-L. Cost of Debt 49 CT N-L. 0.50 0.50 0.25 ITD.L. 0.50 0.000 50 Cost of Preterred 51 Fauit 52 Preferred Dividend Preferred Equity 53 Cost of Preferred 54 0.000 0.25 0.25 0.25 0.000 55 56 WACC Capital Structure Cost Weighted Cost 59 57 Capital Structure Weights 58 Equity Debt Cost (A-T) 60 Preferred Equity IWACC PracticalExam 0.25 0.25 0.25 Ready + 65% Type here to search 2 314 W M AD 4) ENG X 09:08 06/12/2021 94 AutoSave Off H. Practical_Exam_ALMARAI_AB_Equity_Valuation_Q_9AM_. - Excel O Search m3853 M M 0 X File Home Insert Page Layout Formulas Data Review View Help Share Comments 3. Insert == ab Calibri > General 11 A A . AP A 280 5 DX Delete Paste BIU E .00 y - % %, Ideas y Sensitivity Conditional Format as Cell Formatting Table Styles Format Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity C41 fi D E F G . H 1 J FM As Z A A B 23 Part1: Capital Structure & WACC 24 Value Capital Structure Market Cap SAR 54,900.000 25 ST Debt SAR 1258.034 26 LT Debt SAR 10,419.935 27 Pref. Equity SAR 0.000 28 Total Capital Structure 29 0.25 0.25 0.25 0.25 0.50 30 7.2807 1.5807 31 Cost of Equity Expected Market Return 32 Risk Free Rate 33 Beta 34 Country (Market) Risk 35 Damir Equity Risk Premium 36 Cost of Equity 37 0.770 0.25 0.25 0.25 38 39 Cost of Debt Total Debt 40 41 Effective Tax Rate 42 1 - Effective Tax Rate 0.25 4.5527 0.25 Note Rate 0.1607 43 PracticalExam + Select destination and press ENTER or choose Paste + 70% Type here to search 31 AD ) ENG X 09:07 06/12/2021 AutoSave Off H. Practical_Exam_ALMARAI_AB_Equity_Valuation_Q_9AM_. - Excel O Search m3853 M M 0 X File Home Insert Page Layout Formulas Data Review View Help Share Comments 3. Insert Calibri == 11AA ab > General 2 O o DX Delete Paste BIU A .00 %) y Ideas y Conditional Format as Cell Formatting Table Styles Sensitivity Sort & Find & Filter Select Format Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity C41 X fx B c D E F G H 1 J K L M A 39 Cost of Debt 40 Total Debt 41 Effective Tax Rate 1 - Effective Tax Rate 42 0.25 4.5527 0.25 0.1607 43 Note Rate 1.5807 1.480 Risk Free Rate 44 Debt Adjustment 45 ES Total Pre-Tax Cost of 46 47 Total Pre-Tax Cost of - 48. Total Pre-Tax Cost of n-L. Cost of Debt 49 CT N-L. 0.50 0.50 0.25 ITD.L. 0.50 0.000 50 Cost of Preterred 51 Fauit 52 Preferred Dividend Preferred Equity 53 Cost of Preferred 54 0.000 0.25 0.25 0.25 0.000 55 56 WACC Capital Structure Cost Weighted Cost 59 57 Capital Structure Weights 58 Equity Debt Cost (A-T) 60 Preferred Equity IWACC PracticalExam 0.25 0.25 0.25 Ready + 65% Type here to search 2 314 W M AD 4) ENG X 09:08 06/12/2021 94
