excel sheet

renaadaf
Bindawood.xlsx
Home>Business & Finance homework help>Accounting homework help>excel sheet

DCF

(in million) Historical Period CAGR Projection Period Sensitivity Analysis
2018 2019 2020 (18 - 20) 2021 2022 2023 2024 2025 Input Output Perpetuity growth %
Sales 4,554 4,844 5,157 6% 5,497 5,865 6,258 6,677 7,125 Wacc Calculation Enterprise value 26,011 26,011 -1.0% -0.5% 0.0% 0.5% 1.0%
% growth 6.4% 6.5% 6.6% 6.7% 6.7% 6.7% 6.7% Target Capital Structure Present value of Free Cash Flow 6,785 WACC -2.0% 0 0 0 0 0
COGS 3,001 3,199 3,485 8% 3,732 4,516 4,819 5,142 5,486 Debt to Total Capitalization 65.79% -1.0% ERROR:#DIV/0! 0 0 0 0
% sales 65.9% 66.0% 67.6% 67.9% 77.0% 77.0% 77.0% 77.0% Equity to Total Capitalization 34.21% Terminal Value 25,320 0.0% 0 0 ERROR:#DIV/0! 0 0
Gross Profit 1553 1645 1672 4% 1764 1349 1439 1536 1639 Debt to Equity Ratio 1.9234 Discount Factor 0.76 1.0% 0 0 0 0 ERROR:#DIV/0!
% margin 34.1% 34.0% 32.4% 32.1% 23.0% 23.0% 23.0% 23.0% Present Value of Terminal Value 19,226 2.0% 0 0 0 0 0
SG&A 1,047 1,006 1,002 -2% 0 0 0 0 0 Cost of Equity % of Enterprise Value 74%
% of sales 22.99% 20.77% 19.43% Risk-free rate 3.06%
EBIT 506 639 670 15% 1,764 1,349 1,439 1,536 1,639 Market risk Premium 6.08% Enterprise value 26,011
% margin 11.1% 13.2% 13.0% 32.1% 23.0% 23.0% 23.0% 23.0% Levered Beta -0.19 Less: Total debt 3,456,710
Plus: Depreciation & Amortization 155,523 160,093 165,448 0 0 0 0 0 Cost of Equity 1.9% Plus: Cash and Cash Equi. 232,197
% of sales 34 33 32 Net Debt 3,224,513
EBITDA 156,029 160,732 166,118 3% 1,764 1,349 1,439 1,536 1,639 Cost of Debt Less: Preferred Stock 0
% margin 34 33 32 0 0 0 0 0 Cost of Debt 8.82% Less: Noncontrolling Interest 0
Taxes 0 34 36 38 41 Taxes 2.5% Implied Equity Value -3,198,502
% of EBIT 0 0 0 After Tax Cost of Debt 8.6% Fully Diluted Outstanding shares 114,130,000
EBIAT 506 639 670 1,764 1,315 1,403 1,497 1,598 Implied share price -0.03
Less: Capex 144 42 46 0 0 0 0 0 WACC 6.31%
% sales 3.2% 0.9% 0.9%
Less: Incr./(Dec.) in NWC 181 377 -36 -311 0 63 0 0
Unlevered Free Cash Flow 155,704 160,313 166,108 2,075 1,315 1,340 1,497 1,598
WACC 6.3%
Discount Period 0.5 1.5 2.5 3.5 4.5
Discount Factor 0.97 0.91 0.86 0.81 0.76
Present value of free cash flow 2,013 1,200 1,150 1,209 1,213
Terminal Value
Terminal Year Free Cash Flow 1,598
Perpetuity Growth Rate 0.0%
Terminal Value 25,320
Discount Period 4.5
Discount Factor 0.8
Present Value of Terminal Value 19,226
% of Enterprise Value 74%
(in million) Actual Forecast period
Net Working Capital 2017 2018 2019 2020 2021 2022 2023 2024 2025
Account receivables 145 157 260 313
Inventory 760 806 919 1,000
Prepaid expenses and other 0 53 52 61
Total Current Assets 905 1,016 1,231 1,374 0 0 0 0 0
% sales 22.3% 25.4% 26.6% 0.0% 0.0% 0.0% 0.0% 0.0%
Account payable 1,152 1,059 884 1,063
Accrued Liabilities
Other Current Liabilities 27 50 63 63 63 63
Total Current Liabilities 1,179 1,109 947 1,126 63 63 0 0 0
% sales -24.4% -19.6% -21.8% 1.1% 1.1% 0.0% 0.0% 0.0%
Net Working Capital -274 -93 284 248 -63 -63 0 0 0
% sales -2% 6% 5% -1% -1% 0% 0% 0%

Income statment

STATEMENT OF INCOME 2017-12-31 2018-12-31 2019-12-31 2020-12-31
Sales 4,766,276 4,554,154 4,843,772 5,156,472
Sales Cost 3,762,659 3,668,492 3,199,242 -3,484,580
Total Income (COGS) 1,003,617 885,662 1,644,530 1,671,892
Other Revenues 560,014 690,150 19,261 26,241
Total Revenues (Gross profit) 1,563,631 1,575,812 1,663,791 1,698,133
Admin and Marketing Expenses 977,840 1,018,680 717,595 -731,796
Depreciation 149,722 155,523 420,068 -434,760
Other Expenses - - 98,028 -71,207
Total Expenses 1,127,562 1,174,203 1,235,691 -1,237,763
Net Income Before Zakat 436,069 401,609 428,100 460,370
Zakat 2,762 424 11,192 15,183
Net Income 433,307 401,185 416,908 445,187
Balance First Period 204,002 203,685 354,751 866
Reserves 43,331 -40,118 -525,793 -44,772
Cash Dividends 253,452 -210,000 -245,000 -318,600
Other Distributions - - - -
Balance End Period 340,526 354,752 866 82,681

Ratios

Efficiency Ratios: Formula 2018 2019 2020
Inventory Turnover COGS/ Inventory 3.73 3.48 3.48
Accounts Receivable Turnover Sales/ AR 29.08 18.61 15.50
Collection Period 365/ AR Turnover 12.55 19.61 23.54
Fixed Assets Turnover Sales/ Fixed Assets 4.27 5.15 6.29
Total Assets Turnover Sales/ Total Assets 2.07 1.02 1.08
Coverage Ratios:
interest coverage EBIT/Interest payment 5.907 6.682 6.974
coverage of interest and principal payments 90 million Saudi Riyal 79 million Saudi Riyal 69 million Saudi Riyal
Coverage of all fixed payments (EBIT + Lease Payments)/(Interest Payments + Lease Payments) 3.788 4.304 4.418
Liquidity Indicator:
Current ratio Current Assets/ Current Liabilities 1.026 1.238 1.512
Acid-test ratio Current Assets-Inventory/ Current Liabilities 0.300 0.451 0.592
Net liquid assets Liquid Assets - Current Liabilities
Net working capital Current Assets - Current Liabilities 28974 278260 556504
Proftability Ratios:
Net Profit Margin Net Income/ Sales 8.81% 8.61% 8.63%
Gross Profit Margin (Revenue - COGS) / Revenue
Return On Assets Net Income/ Total Assets 18.20% 8.79% 9.33%
Return On Equity Net Income/ Total Equity 39.55% 35.14% 33.91%
Return On Investment EBIT/ (Total Assets - Current Liabilities)
Financial Leverage:
Total debt ratio Debt/ Asset 0.540 0.531 0.529
debt equity Ratio debt to total capitlization/ equity to total capitalization 1.173 2.123 1.923
Debt to Sales Ratio Debt/Sales 0.261 0.520 0.670

debt to equity ratio

Balance Sheet 2020-12-31 2019-12-31 2018-12-31 NON-CURRENT LIABILITIES 2020
Current Assets 643,161 527,166 332,867 Employees' terminal benefits 104,581
Inventory 1,000,268 918,984 805,629 Lease liabilities 2,265,203
Investments - - - TOTAL NON-CURRENT LIABILITIES 2,369,784
Fixed Assets 819,740 940,399 1,065,125 CURRENT LIABILITIES
Other Assets 2,306,481 2,357,025 572 Due to related parties 16,930
Total Assets 4,769,650 4,743,574 2,204,193 Accounts payable, accruals and other financial liabilities 756,207
Current Liabilities 1,086,925 1,167,891 1,109,521 Unearned income and other payable 36,349
Non-Current Liabilities 2,369,785 2,389,330 80,227 Lease liabilities — current portion 260,064
Other Liabilities - - - Zakat payable 17,373
Shareholders Equity 1,312,940 1,186,353 1,014,445 TOTAL CURRENT LIABILITIES 1,086,925
Total Liabilities and Shareholder Equity 4,769,650 4,743,574 2,204,193 TOTAL LIABILITIES 3,456,710
Total Liabilites 3,456,710 3,557,221 1,189,748 TOTAL EQUITY AND LIABILTIES 4,769,649
Total Debt 2,525,267 2,518,438 1,189,748 Total Debt 2,525,267
Debt to Total Capitalization 0.6579288194 0.6797786974 0.5397658009
Equity to Total Capitalization 0.3420711806 0.3202213026 0.4602341991

Sheet12_conflict810647278

beta

Bindawood TASI
date closing price daily return closing price daily return
10/21/20 105.6 8,496.85
10/22/20 116 0.098 8,505.18 0.00098
10/25/20 127.6 0.100 8,154.59 -0.04122
10/26/20 127 -0.005 8,155.31 0.00009
10/27/20 126.8 -0.002 8,198.90 0.00534
10/28/20 124.2 -0.021 8,123.05 -0.00925
10/29/20 126.6 0.019 7,907.72 -0.02651
11/1/20 124 -0.021 7,864.78 -0.00543
11/2/20 124.8 0.006 8,021.02 0.01987
11/3/20 123.8 -0.008 7,998.59 -0.00280
11/4/20 124.2 0.003 8,088.73 0.01127
11/5/20 123.2 -0.008 8,089.15 0.00005
11/8/20 124.6 0.011 8,160.35 0.00880
11/9/20 125.8 0.010 8,366.46 0.02526
11/10/20 125.8 0.000 8,405.11 0.00462
11/11/20 125 -0.006 8,449.66 0.00530
11/12/20 125 0.000 8,434.90 -0.00175
11/15/20 125.2 0.002 8,501.58 0.00791
11/16/20 124.2 -0.008 8,526.64 0.00295
11/17/20 124.8 0.005 8,572.73 0.00541
11/18/20 124.4 -0.003 8,621.19 0.00565
11/19/20 124 -0.003 8,578.42 -0.00496
11/22/20 122.4 -0.013 8,588.17 0.00114
11/23/20 120 -0.020 8,610.84 0.00264
11/24/20 119.8 -0.002 8,636.15 0.00294
11/25/20 119.6 -0.002 8,688.76 0.00609
11/26/20 119.8 0.002 8,693.47 0.00054
11/29/20 119.6 -0.002 8,708.59 0.00174
11/30/20 119.6 0.000 8,747.09 0.00442
12/1/20 118.8 -0.007 8,722.12 -0.00285
12/2/20 118 -0.007 8,694.13 -0.00321
12/3/20 118.4 0.003 8,674.97 -0.00220
12/6/20 117.8 -0.005 8,580.92 -0.01084
12/7/20 117.2 -0.005 8,633.38 0.00611
12/8/20 118.2 0.009 8,612.13 -0.00246
12/9/20 118.6 0.003 8,660.21 0.00558
12/10/20 118 -0.005 8,643.97 -0.00188
12/13/20 117.8 -0.002 8,644.47 0.00006
12/14/20 117.8 0.000 8,660.31 0.00183
12/15/20 117.6 -0.002 8,659.37 -0.00011
12/16/20 117.4 -0.002 8,721.18 0.00714
12/17/20 117.6 0.002 8,711.58 -0.00110
12/20/20 116.6 -0.009 8,686.89 -0.00283
12/21/20 114.2 -0.021 8,538.68 -0.01706
12/22/20 115.4 0.011 8,680.45 0.01660
12/23/20 116 0.005 8,720.67 0.00463
12/24/20 115.8 -0.002 8,702.68 -0.00206
12/27/20 115.8 0.000 8,740.66 0.00436
12/28/20 115.2 -0.005 8,715.38 -0.00289
12/29/20 115 -0.002 8,746.76 0.00360
12/30/20 117.8 0.024 8,760.08 0.00152
12/31/20 119 0.010 8,689.53 -0.00805
1/3/21 118.2 -0.007 8,612.82 -0.00883
1/4/21 118.8 0.005 8,667.66 0.00637
1/5/21 119 0.002 8,682.11 0.00167
1/6/21 117.8 -0.010 8,670.80 -0.00130
1/7/21 117.8 0.000 8,737.20 0.00766
1/10/21 118.8 0.008 8,817.05 0.00914
1/11/21 121.6 0.024 8,869.47 0.00595
1/12/21 121.8 0.002 8,884.46 0.00169
1/13/21 120.2 -0.013 8,914.29 0.00336
1/14/21 119.8 -0.003 8,898.68 -0.00175
1/17/21 119 -0.007 8,874.90 -0.00267
1/18/21 118.8 -0.002 8,931.29 0.00635
1/19/21 117.8 -0.008 8,901.87 -0.00329
1/20/21 117.6 -0.002 8,878.30 -0.00265
1/21/21 117.8 0.002 8,876.49 -0.00020
1/24/21 116.4 -0.012 8,829.52 -0.00529
1/25/21 116.2 -0.002 8,846.95 0.00197
1/26/21 115.8 -0.003 8,789.87 -0.00645
1/27/21 115 -0.007 8,784.12 -0.00065
1/28/21 115.6 0.005 8,807.02 0.00261
1/31/21 115 -0.005 8,702.55 -0.01186
2/1/21 114.6 -0.003 8,648.43 -0.00622
2/2/21 115 0.003 8,618.57 -0.00345
2/3/21 113.8 -0.010 8,542.55 -0.00882
2/4/21 113.4 -0.004 8,617.87 0.00882
2/7/21 113.6 0.002 8,687.93 0.00813
2/8/21 114.6 0.009 8,809.34 0.01397
2/9/21 114 -0.005 8,892.92 0.00949
2/10/21 113.8 -0.002 8,901.63 0.00098
2/11/21 113.6 -0.002 8,943.85 0.00474
2/14/21 114 0.004 9,035.53 0.01025
2/15/21 114 0.000 9,081.78 0.00512
2/16/21 114.2 0.002 9,101.96 0.00222
2/17/21 113.8 -0.004 9,084.31 -0.00194
2/18/21 113.2 -0.005 9,024.23 -0.00661
2/21/21 113 -0.002 9,085.97 0.00684
2/22/21 111.4 -0.014 9,077.62 -0.00092
2/23/21 112 0.005 9,151.71 0.00816
2/24/21 109.8 -0.020 9,115.76 -0.00393
2/25/21 109.4 -0.004 9,194.92 0.00868
2/28/21 107.4 -0.018 9,144.99 -0.00543
3/1/21 108 0.006 9,138.37 -0.00072
3/2/21 107.8 -0.002 9,248.28 0.01203
3/3/21 107.6 -0.002 9,310.28 0.00670
3/4/21 107.4 -0.002 9,242.28 -0.00730
3/7/21 107.8 0.004 9,351.08 0.01177
3/8/21 107 -0.007 9,374.37 0.00249
3/9/21 106.2 -0.007 9,473.20 0.01054
3/10/21 109.2 0.028 9,595.45 0.01290
3/11/21 109 -0.002 9,587.79 -0.00080
3/14/21 109 0.000 9,664.61 0.00801
3/15/21 108.2 -0.007 9,645.74 -0.00195
3/16/21 109.8 0.015 9,660.27 0.00151
3/17/21 109.4 -0.004 9,602.26 -0.00601
3/18/21 108.6 -0.007 9,485.96 -0.01211
3/21/21 108.4 -0.002 9,498.85 0.00136
3/22/21 107.4 -0.009 9,547.42 0.00511
3/23/21 108.2 0.007 9,489.63 -0.00605
3/24/21 107.4 -0.007 9,464.08 -0.00269
3/25/21 110 0.024 9,417.71 -0.00490
3/28/21 110 0.000 9,482.95 0.00693
3/29/21 107.8 -0.020 9,615.63 0.01399
3/30/21 107.4 -0.004 9,635.34 0.00205
3/31/21 109 0.015 9,907.82 0.02828
4/1/21 107.8 -0.011 9,895.56 -0.00124
4/4/21 107.8 0.000 9,962.77 0.00679
4/5/21 108 0.002 9,964.84 0.00021
4/6/21 107.8 -0.002 9,988.98 0.00242
4/7/21 107 -0.007 10,014.30 0.00253
4/8/21 107 0.000 10,012.13 -0.00022
4/11/21 107 0.000 9,938.32 -0.00737
4/12/21 107 0.000 9,907.62 -0.00309
4/13/21 106.6 -0.004 9,838.28 -0.00700
4/14/21 106.4 -0.002 9,847.62 0.00095
4/15/21 106.8 0.004 9,987.92 0.01425
4/18/21 107.2 0.004 10,048.70 0.00609
4/19/21 106.6 -0.006 10,097.65 0.00487
4/20/21 108 0.013 10,116.98 0.00191
4/21/21 107.8 -0.002 10,095.36 -0.00214
4/22/21 110.2 0.022 10,134.08 0.00384
4/25/21 109 -0.011 10,142.48 0.00083
4/26/21 110.2 0.011 10,231.06 0.00873
4/27/21 110.6 0.004 10,267.17 0.00353
4/28/21 111 0.004 10,531.22 0.02572
4/29/21 112.6 0.014 10,418.98 -0.01066
5/2/21 114 0.012 10,365.51 -0.00513
5/3/21 113.8 -0.002 10,309.37 -0.00542
5/4/21 114 0.002 10,318.94 0.00093
5/5/21 114.4 0.004 10,252.15 -0.00647
5/6/21 113.8 -0.005 10,228.35 -0.00232
5/9/21 112.4 -0.012 10,228.19 -0.00002
5/10/21 112.6 0.002 10,322.68 0.00924
Average 0.06% 0.14%
Standard Deviation 1.47% 0.84%
Variance 0.0002168288
Covarance with TASI -0.0000132558
Correlation with TASI -0.1074766704
Beta -0.1889465408

Bindawood Correlation with Tasi

Bindawood 44129 44130 44131 44132 44133 44136 44137 44138 44139 44140 44143 44144 44145 44146 44147 44150 44151 44152 44153 44154 44157 44158 44159 44160 44161 44164 44165 44166 44167 44168 44171 44172 44173 44174 44175 44178 44179 44180 44181 44182 44185 44186 44187 44188 44189 44192 44193 44194 44195 44196 44199 44200 44201 44202 44203 44206 44207 44208 44209 44210 44213 44214 44215 44216 44217 44220 44221 44222 44223 44224 44227 44228 44229 44230 44231 44234 44235 44236 44237 44238 44241 44242 44243 44244 44245 44248 44249 44250 44251 44252 44255 44256 44257 44258 44259 44262 44263 44264 44265 44266 44269 44270 44271 44272 44273 44276 44277 44278 44279 44280 44283 44284 44285 44286 44287 44290 44291 44292 44293 44294 44297 44298 44299 44300 44301 44304 44305 44306 44307 44308 44311 44312 44313 44314 44315 44318 44319 44320 44321 44322 44325 44326 9.999999999999995E-2 -4.7021943573667272E-3 -1.5748031496063215E-3 -2.0504731861198694E-2 1.9323671497584471E-2 -2.0537124802527604E-2 6.4516129032257839E-3 -8.0128205128205138E-3 3.2310177705977845E-3 -8.0515297906602248E-3 1.1363636363636295E-2 9.6308186195826883E-3 0 -6.3593004769475136E-3 0 1.6000000000000228E-3 -7.9872204472843447E-3 4.8309178743960891E-3 -3.2051282051281369E-3 -3.2154340836013317E-3 -1.2903225806451568E-2 -1.9607843137254947E-2 -1.6666666666666904E-3 -1.6694490818030287E-3 1.6722408026756091E-3 -1.6694490818030287E-3 0 -6.6889632107023176E-3 -6.7340067340067103E-3 3.3898305084746243E-3 -5.067567567567639E-3 -5.093378607809799E-3 8.5324232081911266E-3 3.3840947546530582E-3 -5.0590219224282825E-3 -1.6949152542373122E-3 0 -1.6977928692699733E-3 -1.700680272108747E-3 1.7035775127767344E-3 -8.5034013605442185E-3 -2.0583190394511078E-2 1.0507880910683037E-2 5.1993067590987369E-3 -1.7241379310345072E-3 0 -5.1813471502590181E-3 -1.7361111111111357E-3 2.4347826086956497E-2 1.0186757215619719E-2 -6.7226890756302282E-3 5.0761421319796473E-3 1.6835016835017075E-3 -1.0084033613445401E-2 0 8.4889643463497456E-3 2.3569023569023545E-2 1.6447368421052867E-3 -1.3136288998357918E-2 -3.327787021630663E-3 -6.6777963272119968E-3 -1.680672268907587E-3 -8.4175084175084174E-3 -1.6977928692699733E-3 1.7006802721088678E-3 -1.1884550084889572E-2 -1.7182130584192682E-3 -3.4423407917384308E-3 -6.9084628670120652E-3 5.2173913043477771E-3 -5.1903114186850723E-3 -3.478260869565267E-3 3.4904013961606084E-3 -1.0434782608695677E-2 -3.5149384885763751E-3 1.7636684303349967E-3 8.8028169014084511E-3 -5.2356020942407886E-3 -1.7543859649123057E-3 -1.75746924428825E-3 3.5211267605634307E-3 0 1.7543859649123057E-3 -3.5026269702277207E-3 -5.2724077328646247E-3 -1.7667844522968449E-3 -1.415929203539818E-2 5.3859964093356761E-3 -1.9642857142857167E-2 -3.642987249544549E-3 -1.8281535648994516E-2 5.5865921787708961E-3 -1.8518518518518782E-3 -1.8552875695733103E-3 -1.8587360594794484E-3 3.7243947858472204E-3 -7.4211502782931095E-3 -7.476635514018665E-3 2.8248587570621469E-2 -1.8315018315018575E-3 0 -7.3394495412843772E-3 1.4787430683918617E-2 -3.642987249544549E-3 -7.3126142595979094E-3 -1.8416206261509082E-3 -9.2250922509225092E-3 7.4487895716945727E-3 -7.3937153419593084E-3 2.4208566108007396E-2 0 -2.0000000000000025E-2 -3.7105751391464888E-3 1.4897579143389145E-2 -1.1009174311926632E-2 0 1.8552875695733103E-3 -1.8518518518518782E-3 -7.4211502782931095E-3 0 0 0 -3.7383177570093989E-3 -1.8761726078798185E-3 3.7593984962405211E-3 3.7453183520599785E-3 -5.5970149253732138E-3 1.3133208255159529E-2 -1.8518518518518782E-3 2.2263450834879461E-2 -1.0889292196007285E-2 1.1009174311926632E-2 3.6297640653356758E-3 3.6166365280289846E-3 1.4414414414414363E-2 1.2433392539964528E-2 -1.7543859649123057E-3 1.75746924428825E-3 3.5087719298246113E-3 -5.2447552447553187E-3 -1.23022847100175E-2 1.7793594306048811E-3 Tasi 44129 44130 44131 44132 44133 44136 44137 44138 44139 44140 44143 44144 44145 44146 44147 44150 44151 44152 44153 44154 44157 44158 44159 44160 44161 44164 44165 44166 44167 44168 44171 44172 44173 44174 44175 44178 44179 44180 44181 44182 44185 44186 44187 44188 44189 44192 44193 44194 44195 44196 44199 44200 44201 44202 44203 44206 44207 44208 44209 44210 44213 44214 44215 44216 44217 44220 44221 44222 44223 44224 44227 44228 44229 44230 44231 44234 44235 44236 44237 44238 44241 44242 44243 44244 44245 44248 44249 44250 44251 44252 44255 44256 44257 44258 44259 44262 44263 44264 44265 44266 44269 44270 44271 44272 44273 44276 44277 44278 44279 44280 44283 44284 44285 44286 44287 44290 44291 44292 44293 44294 44297 44298 44299 44300 44301 44304 44305 44306 44307 44308 44311 44312 44313 44314 44315 44318 44319 44320 44321 44322 44325 44326 -4.1220761935667455E-2 8.8293832062710036E-5 5.3449838203574402E-3 -9.2512410201367815E-3 -2.6508515889967429E-2 -5.4301366259807511E-3 1.9865781369599746E-2 -2.7964024525559453E-3 1.1269486246950951E-2 5.1924096860702828E-5 8.8019136744899931E-3 2.525749508293134E-2 4.6196360228820147E-3 5.3003470507821159E-3 -1.7468158482116698E-3 7.9052508032105059E-3 2.9476873710533209E-3 5.4054117448373747E-3 5.6528083819274546E-3 -4.9610320616991889E-3 1.1365729353424057E-3 2.6396776030283603E-3 2.9393183475711418E-3 6.0918349032845175E-3 5.4207965233233821E-4 1.739236461390078E-3 4.4209223307102525E-3 -2.8546636652874665E-3 -3.2090821956131765E-3 -2.2037857726994944E-3 -1.084153605142142E-2 6.113563580594986E-3 -2.4613766566512771E-3 5.5828 232969079581E-3 -1.8752432100376068E-3 5.7843791683682385E-5 1.8323853284238532E-3 -1.085411492196804E-4 7.1379326671570202E-3 -1.1007684739909466E-3 -2.8341586715613597E-3 -1.7061341861126265E-2 1.6603268889336574E-2 4.6334003421480844E-3 -2.0629148907136473E-3 4.364172875481985E-3 -2.8922301061934286E-3 3.6005314742444988E-3 1.5228496037389511E-3 -8.0535794193659499E-3 -8.8278652585353796E-3 6.367252537496447E-3 1.6671166150957384E-3 -1.3026787267152004E-3 7.6578862388708606E-3 9.1390834592316224E-3 5.9452991646866101E-3 1.6900671629758919E-3 3.3575478982404952E-3 -1.7511209529867864E-3 -2.6723064544405075E-3 6.3538744098526447E-3 -3.2940370316046248E-3 -2.6477582800020138E-3 -2.0386785758529118E-4 -5.291505989416914E-3 1.9740597450371355E-3 -6.451941064434627E-3 -6.5416212071395816E-4 2.6069771360135831E-3 -1.1862128165940483E-2 -6.2188668838442738E-3 -3.4526497873025026E-3 -8.8204887817817153E-3 8.8170394086076794E-3 8.1296190357941674E-3 1.3974560108103985E-2 9.4876574181493641E-3 9.7943082811934967E-4 4.7429515717909154E-3 1.0250619140526763E-2 5.1186814719225097E-3 2.2220313638954556E-3 -1.9391427780389759E-3 -6.6136008128300254E-3 6.8415809437480856E-3 -9.1899929231535496E-4 8.161830964503727E-3 -3.9282276208488813E-3 8.6838617953960886E-3 -5.4301723125378242E-3 -7.2389362918920429E-4 1.2027309027758762E-2 6.7039492748921957E-3 -7.303754559476191E-3 1.1771986998878985E-2 2.4906214041587574E-3 1.054257512771524E-2 1.2904826246674829E-2 -7.9829502524632551E-4 8.0122739442561527E-3 -1.9524843733995266E-3 1.5063644676303379E-3 -6.0050081415944081E-3 -1.2111732029751443E-2 1.3588503430334133E-3 5.1132505513825054E-3 -6.0529441461673284E-3 -2.692412665193 4033E-3 -4.8995781946053708E-3 6.927374064395868E-3 1.3991426718478792E-2 2.0497876894182646E-3 2.8279230416363051E-2 -1.2374064123086832E-3 6.7919349688143928E-3 2.0777354089271445E-4 2.4225175717823284E-3 2.5347933422631449E-3 -2.1669013310966049E-4 -7.3720576940171072E-3 -3.0890532806348465E-3 -6.9986535616020943E-3 9.4935293567576288E-4 1.4247097268172337E-2 6.0853511041338588E-3 4.8712768815865641E-3 1.9143067941550685E-3 -2.1370013581126961E-3 3.8354253835424733E-3 8.288862925889312E-4 8.7335641775975834E-3 3.5294485615371802E-3 2.5717894999303534E-2 -1.0657834514899489E-2 -5.131980289817175E-3 -5.4160383811312149E-3 9.2828174757523575E-4 -6.4725640424307994E-3 -2.3214642782244965E-3 -1.5642796736507302E-5 9.2381936588975932E-3

Date

Bindawood and Tasi /daily return

Cost of debt

4yrs 5300 Saudi Government Sukuk 2020-07-04 8yrs 5301 Saudi Government Sukuk 2020-07-08 7Yrs Saudi Government SAR Sukuk 2020-01-07 10 Yrs Saudi Government SAR Sukuk 2021-03-10
DATE CLOSE DATE CLOSE 2021/05/05 104 0.64 2021/05/05 101.39 0.27
5/5/21 101.54 0.26 2021/05/05 100.83 0.94 2021/05/04 103.36 -0.54 2021/05/04 101.12 -0.439
5/4/21 101.28 0.26 2021/05/04 99.89 1.621 2021/04/25 103.9 0.31 2021/04/21 101.559 0.609
4/6/21 101.02 -0.244 4/21/21 101.001 -0.95 2021/04/21 103.59 0.659 2021/04/20 100.95 -1.16
3/30/21 101.264 -0.241 4/6/21 99.38 -0.37 2021/04/20 102.931 0.441 2021/04/18 102.11 1.3
3/17/21 101.505 0.025 3/14/21 100.33 0 2021/04/06 102.49 -0.651 2021/04/14 100.81 0.02
3/14/21 101.48 -0.14 3/7/21 100.7 -0.87 2021/03/17 103.141 -0.119 2021/04/07 100.79 -0.51
3/7/21 101.62 0.01 3/3/21 100.7 0.271 2021/03/14 103.26 -0.39 2021/04/06 101.3 1.08
3/3/21 101.61 -0.32 2/22/21 101.57 -0.771 2021/03/07 103.65 -0.05 2021/03/29 100.22 -0.35
2/22/21 101.93 0.018 2/21/21 101.299 0.37 2021/03/03 103.7 -0.45 2021/03/24 100.57 0.57
2/21/21 101.912 -0.018 2/14/21 102.07 -0.2 2021/02/22 104.15 -0.4 Average 13.90%
2/14/21 101.93 0.11 2/11/21 101.7 0.51 2021/02/21 104.55 -0.1 AAA 0.75%
2/11/21 101.82 -0.04 2/9/21 101.9 -0.62 2021/02/14 104.65 0.16 Total 14.65%
2/9/21 101.86 -0.06 1/25/21 101.39 1.2 2021/02/11 104.49 -0.03
2/3/21 101.92 0.03 1/24/21 102.01 -0.45 2021/02/09 104.52 0.36
1/25/21 101.89 -0.24 1/10/21 100.81 -0.14 2021/1/25 104.16 -0.56
1/24/21 102.13 0.226 12/27/20 101.26 -0.47 2021/1/24 104.72 1.017
1/10/21 101.904 0.277 12/22/20 101.4 0.04 2021/1/10 103.703 -0.297
1/6/21 101.627 -0.143 12/15/20 101.87 0.36 2020/12/27 104 -0.025
1/5/21 101.77 0.16 12/8/20 101.83 -0.36 2020/12/22 104.025 -0.012
12/27/20 101.61 -0.07 12/6/20 101.47 -2.77 2020/12/15 104.037 -0.253
12/24/20 101.68 0.05 11/29/20 101.83 2.69 2020/12/8 104.29 0.29
12/22/20 101.63 0.17 11/26/20 104.6 -0.15 2020/12/6 104 -0.18
12/21/20 101.46 -0.124 11/23/20 101.91 0.21 2020/11/29 104.18 0
12/15/20 101.584 -0.126 11/10/20 102.06 -0.79 2020/11/23 104.18 -0.1
12/8/20 101.71 0.12 11/8/20 101.85 0.6 2020/11/10 104.28 0.2
12/6/20 101.59 -0.02 10/20/20 102.64 0.01 2020/11/8 104.08 0.49
12/3/20 101.61 -0.03 10/13/20 102.04 2.6 2020/10/20 103.59 0.52
12/1/20 101.64 0.18 10/11/20 102.03 2.6 2020/10/13 103.07 0.01
11/29/20 101.46 -0.01 10/6/20 99.43 -2.8 2020/10/11 103.06 2.25
11/23/20 101.47 0 9/27/20 102.23 0.15 2020/10/06 100.81 -2.37
11/23/20 101.47 -0.09 9/21/20 102.08 -0.2 2020/09/27 103.18 0.11
11/10/20 101.56 0.15 9/10/20 102.28 0 2020/09/21 103.07 -0.19
11/8/20 101.41 -0.409 9/10/20 102.28 -0.24 2020/09/10 103.26 -0.17
11/2/20 101.819 0.319 9/9/20 102.52 0.18 2020/09/09 103.43 0.29
10/20/20 101.5 0.21 9/7/20 102.34 0.01 2020/09/07 103.14 2.43
10/13/20 101.29 0 9/6/20 102.33 -0.02 2020/09/06 100.71 -2.85
10/11/20 101.29 -0.01 8/31/20 102.35 0.27 2020/08/27 103.56 -0.39
10/6/20 101.3 0.04 8/30/20 102.08 0.24 2020/08/25 103.95 -0.95
10/5/20 101.26 1.26 8/26/20 101.84 1.84 2020/08/06 104.9 -0.13
Average 3.95% Average 11.64% 2020/08/05 105.03 1.03
BBB 2.25% BB 3.50% 2020/07/23 104 0.07
cost of debt 6.20% cost of debt 15.14% 2020/07/19 103.93 0.94
2020/07/15 102.99 -2.47
2020/07/08 105.46 0.57
2020/07/02 104.89 0.46
2020/06/07 104.43 -0.07
2020/06/04 104.5 0.32
2020/06/03 104.18 0
2020/06/01 104.18 -0.39
2020/05/31 104.57 0.3
2020/05/17 104.27 1.83
2020/05/05 102.44 -0.39
2020/04/21 102.83 -0.2
2020/04/12 103.03 -0.67
2020/03/10 103.7 2
2020/03/04 101.7 1.7
Average 7.02%
A 1.80%
cost of debt 8.82%