MBA516 Managerial Finance The Saudi Stock Exchange Market Analysis

Anonymous
timer Asked: Feb 8th, 2019
account_balance_wallet $250

Question Description

Aims of assignment

You should develop, through research and analytical skills, the ability to:

  • Locate sources of information for your companies, industries and market of choice.
  • Use several quantitative and IT tools to present and analyze collected data
  • Check the performance of a particular sector of the market

Important Notes

  • The assignment should be conducted as individual or a group of 3 maximum.
  • Submit a hard copy in the class.
  • The use of Word and Excel is a must.
  • Late submission will have 20% of the mark deducted per day.
  • Copying from the Internet or any other source without referencing is considered as a cheating case and the student will be penalized according to Al Faisal University policy.

Task

You are required to analyze 10 companies from Tadawul.

The Company annual reports

Collect data on the companies for the past 3 years (2015, 2016 and 2017) for the following variables:

  • Balance sheet;
  • Income statement;
  • Cash flow statement;

Investigate and analyse the latest three Financial Statements (you can find them from the company’s website or from Tadawul).Assess the companies’ performance by looking at the appropriate liquidity ratios, asset management ratios, Leverage ratios, Profitability ratios and market value ratios. Compare the company performance over the past three years (time-series analysis) and with each other, peer group analysis.

You are required to rank the companies and to provide statistical measures to prove your analysis.



10 companies selected from tadawul

  • Hail Cement Co.
  • Najran Cement Co.
  • Qassim Cement Co.
  • Tabuk Cement Co.
  • Al Jouf Cement Co.
  • Umm Al-Qura Cement Co.
  • Northern Region Cement Co.

  • Southern Province Cement Co.
  • Eastern Province Cement Co.
  • Yanbu Cement Co.


through below link:


https://www.tadawul.com.sa/wps/portal/tadawul/mark...


Please I need your support to calculate the ratio ,I have developed attached excel but I'm not sure about my calculations ,please check attched excel & review all data for me :( also I need you to create the market value ratios

but I could not find the market price & book price

please when you do the analysis ,I need you to explain everything in details so I can understand it.


Also I Have attached the slides & the book for your reference


At the end I need complete excel plus Word 10 to 12 pages



Unformatted Attachment Preview

10 Materials Companies 1. Hail Cement Co. 2. Najran Cement Co. 3. Qassim Cement Co. 4. Tabuk Cement Co. 5. Al Jouf Cement Co. 6. Umm Al-Qura Cement Co. 7. Northern Region Cement Co. 8. Southern Province Cement Co. 9. Eastern Province Cement Co. 10. Yanbu Cement Co. Hail Cement Co. Balance Sheet 2017 Current Assets Balance Sheet Inventory Investments Fixed Assets Other Assets Total Assets Current Liabilities Non-Current Liabilities 2016 73.063 162.758 277.224 197.099 38.620 38.500 933.515 972.102 93 202 1.322.515 1.370.661 82.024 76.002 212.376 233.370 Other Liabilities Shareholders Equity 0 0 1.028.115 1.061.289 Total Liabilities and Shareholder Equity 1.322.515 1.370.661 STATEMENT OF INCOME 2017 Sales 164.540 272.119 49.360 72.153 115.180 199.966 2.882 6.228 118.062 206.194 Admin and Marketing Expenses 24.361 30.314 Depreciation 66.583 62.778 Sales Cost Total Income Other Revenues Total Revenues STATEMENT OF INCOME 2016 Other Expenses 4.323 0 Total Expenses 95.267 93.092 Net Income Before Zakat 22.795 113.102 7.254 8.586 Zakat Net Income 15.541 104.516 Balance First Period 43.124 1.055.919 Reserves Cash Dividends -1.554 - -39.160 -97.900 Other Distributions -4.691 -1.247 Balance End Period 13.260 1.061.288 Cash Flow 2017 Net Income 22.796 113.102 Depreciation 66.583 62.778 Accounts Receivable Inventory Cash flow 2016 9.148 4.093 -87.418 -77.640 Prepaid Expenses 243 10 Accounts Payable 3.174 -2.765 -9.766 -6.032 -23.922 -16.672 25 - -22.000 -18.000 Other Changes in Oper. Activity Purchases of Fixed Assets Other Changes in Investing Act. Increase in Debts Cash Other Changes in Financing Act. -39.160 -97.900 Cash at Begining of Period 120.698 159.732 40.401 120.706 Cash at End of Period Liquidity Ratios Current Ratio Quick Ratio Net Working Capital Ratio Cash Ratio Interval Measure Leverage ratios Total Debt Ratio Time Interest Cash coverage Assets Management Ratios Inventory turnover Receivable turnover Total Assets turnover Net Working Capital Turnover Fixed Assets Turnover Profitability ratios Profit Margin Return on Assets Return on Equity Market value ratios Market Price Share outstanding 2017 2016 4,741380572 -2,489039793 -0,006775727 0,890751487 184,3915382 5,241401542 -0,451843373 0,063295009 2,141496276 359,5066114 2017 2016 0,222606171 3,142404191 12,3212021 0,225710077 13,17283951 20,48450967 2017 2016 0,178050962 17,98644512 0,124414468 -18,36178998 -768975 1,293405472 66,48399707 0,19853122 3,136601503 -699983 2017 2016 14% 0,017236856 0,022172617 42% 0,082516392 0,106570406 2017 2016 Najran Cement Co. Balance Sheet 2017 2015 Current Assets 199.136 46.157 Inventory 306.377 36.759 Investments Fixed Assets Other Assets 0 2.222.185 Total Assets 2.730.733 285.258 1.012.075 296 1.380.545 73.053 251.573 0 Current Liabilities Non-Current Liabilities 3.035 176.484 525.366 1.055.919 Other Liabilities Shareholders Equity 0 2.028.883 1.380.545 Total Liabilities and Shareholder Equity 2.730.733 STATEMENT OF INCOME 2015 2017 356.363 Sales 346.244 130.129 Sales Cost 299.332 226.234 Total Income -10.454 Other Revenues 5.150 215.780 Total Revenues 52.062 33.698 Admin and Marketing Expenses 36.688 61.362 Depreciation 0 95.060 120.720 7.174 46.912 2.329 Other Expenses 23.605 Total Expenses 62.622 Net Income Before Zakat Zakat -10.560 11.300 Net Income -21.860 67.872 Balance First Period 253.770 11.355 Reserves 0 Cash Dividends 0 113.546 117.480 52.584 Other Distributions Balance End Period 6.086 225.824 Cash Flow 2015 2017 120.720 Net Income -10.560 61.362 Depreciation 109.864 1.581 -27.537 Accounts Receivable Inventory 4.263 423 -186 Prepaid Expenses 2.933 -5.184 Accounts Payable -2.627 Other Changes in Oper. Activity -24.665 -14.662 Purchases of Fixed Assets -14.928 -49.981 Other Changes in Investing Act. -13.000 Increase in Debts 9.599 1.424 -100.000 Other Changes in Financing Act. -2.309 194.436 Cash at Begining of Period 48.812 159.667 Cash at End of Period 12.630 -117.481 2015 5,039820404 3,272979891 0,153711034 3,904808837 462,3634813 2015 0,235143367 16,82743239 25,38081963 2015 1,309342857 225,4035421 0,258132114 1,679333663 -655712 2015 34% 0,087443727 0,114326951 2015 Liquidity Ratios Current Ratio Quick Ratio Net Working Capital Ratio Cash Ratio Interval Measure Leverage ratios Total Debt Ratio Time Interest Cash coverage Assets Management Ratios Inventory turnover Receivable turnover Total Assets turnover Net Working Capital Turnover Fixed Assets Turnover Profitability ratios Profit Margin Return on Assets Return on Equity Market value ratios Market Price Share outstanding 2017 2,864355976 -0,607652818 0,008295209 1,128351579 200,8118159 0,257018903 -0,934513274 -0,72840708 2017 0,977005454 81,22073657 0,12679526 15,28536112 -1875941 2017 -3% -0,003867094 -0,005204834 2017 jran Cement Co. Qassim Cement Co. Balance Sheet Balance Sheet 2016 2015 239.202 276.357 Current Assets 306.800 361.902 Inventory 0 Investments Fixed Assets Other Assets 0 2.318.367 2.430.434 3.381 4.579 2.867.750 3.073.272 189.812 230.104 621.109 714.808 0 0 2.056.829 2.128.360 Other Liabilities Shareholders Equity 2.867.750 3.073.272 Total Liabilities and Shareholder Equity Total Assets Current Liabilities Non-Current Liabilities TEMENT OF INCOME STATEMENT OF INCOME 2016 2015 Sales 631.197 1.086.649 425.808 446.380 Sales Cost 205.389 640.269 Total Income 7.525 5.776 212.914 646.045 Total Revenues 42.935 209.832 Admin and Marketing Expenses 2.346 121.171 Depreciation Other Revenues 28.391 29.279 Other Expenses 73.672 360.282 Total Expenses 139.242 285.763 Net Income Before Zakat 13.500 30.139 125.742 255.624 Net Income 337.772 296.710 Balance First Period 12.471 25.562 187.000 187.000 10.273 2.000 253.770 337.772 Zakat Reserves Cash Dividends Other Distributions Balance End Period Cash Flow Cash Flow 2016 2015 139.242 285.763 Net Income 117.040 121.171 Depreciation 39.755 -8.163 Accounts Receivable -68.358 32.534 Inventory 457 2.472 Prepaid Expenses -21.939 8.812 Accounts Payable -21.661 2.111 Other Changes in Oper. Activity -8.256 -11.844 Purchases of Fixed Assets -658 -11.957 Other Changes in Investing Act. -100.000 -101.757 Increase in Debts -188.871 -188.803 162.061 31.722 48.812 162.061 2016 2015 2,876540998 -0,35613133 0,017222561 1,260204834 174,7992512 2,773784897 -0,371766679 0,015050083 1,201009109 125,0465561 0,282772557 10,31422222 10,488 0,307461233 9,481502372 13,50190783 2016 2015 1,39523801 1,444909226 15,87717268 -133,1188289 0,220101822 0,353580484 12,77985422 23,4935896 -1687170 -1343785 2016 2015 22% 0,048554442 0,067697412 26% 0,092983309 0,13426441 2016 2015 Other Changes in Financing Act. Cash at Begining of Period Cash at End of Period Liquidity Ratios Current Ratio Quick Ratio Net Working Capital Ratio Cash Ratio Interval Measure Leverage ratios Total Debt Ratio Time Interest Cash coverage Assets Management Ratios Inventory turnover Receivable turnover Total Assets turnover Net Working Capital Turnover Fixed Assets Turnover Profitability ratios Profit Margin Return on Assets Return on Equity Market value ratios Market Price Share outstanding Qassim Cement Co. Balance Sheet 2017 Tabuk Cement Co. Balance Sheet 2016 2015 840.162 889.063 927.976 Current Assets 268.003 233.869 222.099 Inventory 0 0 0 836.972 840.781 900.971 43.747 80.006 62.161 1.988.884 2.043.719 2.113.207 205.351 213.524 197.166 0 0 0 39.328 33.543 32.452 1.744.205 1.796.652 1.883.589 Other Liabilities Shareholders Equity 1.988.884 2.043.719 2.113.207 Total Liabilities and Shareholder Equity Investments Fixed Assets Other Assets Total Assets Current Liabilities Non-Current Liabilities STATEMENT OF INCOME 2017 STATEMENT OF INCOME 2016 2015 Sales 625.946 852.044 1.023.897 352.267 405.173 394.218 Sales Cost 273.679 446.871 629.679 Total Income 16.657 27.693 26.046 Other Revenues 290.336 474.564 655.725 Total Revenues 29.045 28.921 28.290 0 0 0 Depreciation Other Expenses Admin and Marketing Expenses 0 0 0 29.045 28.921 28.290 261.291 445.643 627.435 9.500 35.800 41.000 251.791 409.843 586.435 Net Income 514.391 254.141 290.650 Balance First Period 0 -150.148 58.644 261.000 427.500 562.500 2.900 2.900 1.800 502.282 383.732 254.141 Total Expenses Net Income Before Zakat Zakat Reserves Cash Dividends Other Distributions Balance End Period Cash Flow Cash Flow 2017 2016 2015 261.291 445.643 627.435 Net Income 69.179 73.707 76.233 Depreciation 13.886 -30.759 -22.568 -34.782 -12.785 3.330 Accounts Receivable Inventory 0 0 0 Prepaid Expenses 2.571 10.971 6.416 Accounts Payable -39.022 -41.188 -35.067 Other Changes in Oper. Activity -12.630 -33.359 -40.845 Purchases of Fixed Assets -3.357 58.543 86.177 0 0 0 Other Changes in Investing Act. Increase in Debts Other Changes in Financing Act. -276.481 -491.602 -684.331 71.611 39.814 23.034 Cash at Begining of Period 52.266 18.985 39.814 Cash at End of Period 2017 2016 2015 5,396443163 2,78624891 0,3191795 4,091346037 804,2210316 5,25904348 3,068479422 0,330543974 4,163761451 747,5523619 5,833029021 3,580115233 0,345829822 4,706572127 801,6682288 0,123023263 27,50431579 27,50431579 0,120890886 12,44812849 12,44812849 0,108658546 15,30329268 15,30329268 2017 2016 2015 1,314414391 1,13863731 1,122974279 45,07748812 -27,70064046 -45,36941687 0,314722226 0,416908587 0,484522813 0,986035214 1,261280252 1,401044047 -211026 11263 122926 2017 2016 2015 42% 0,131375686 0,149805212 52% 0,218054928 0,2480408 61% 0,296911282 0,333106108 2017 2016 2015 Liquidity Ratios Current Ratio Quick Ratio Net Working Capital Ratio Cash Ratio Interval Measure Leverage ratios Total Debt Ratio Time Interest Cash coverage Assets Management Ratios Inventory turnover Receivable turnover Total Assets turnover Net Working Capital Turnover Fixed Assets Turnover Profitability ratios Profit Margin Return on Assets Return on Equity Market value ratios Market Price Share outstanding Tabuk Cement Co. Al Jouf Cement Co. Balance Sheet Balance Sheet 2017 2016 2015 57.587 44.758 120.860 Current Assets 248.441 234.275 215.674 Inventory 169.349 169.349 169.349 1.409.466 1.459.227 1.501.337 9.116 20.022 24.212 Investments Fixed Assets Other Assets 1.893.959 1.927.631 2.031.432 280.507 368.626 327.947 462.375 380.952 501.043 0 0 0 1.151.077 1.178.053 1.202.442 Other Liabilities Shareholders Equity 1.893.959 1.927.631 2.031.432 Total Liabilities and Shareholder Equity Total Assets Current Liabilities Non-Current Liabilities STATEMENT OF INCOME 2017 STATEMENT OF INCOME 2016 2015 166.608 246.530 272.412 Sales 157.359 164.919 158.456 Sales Cost 9.249 81.611 113.956 Total Income 5.693 1.341 1.335 14.942 82.952 115.291 22.599 20.635 21.059 0 0 0 Depreciation Other Expenses Other Revenues Total Revenues Admin and Marketing Expenses 11.535 0 0 34.134 20.635 21.059 Total Expenses -19.192 62.317 94.232 Net Income Before Zakat 2.696 4.306 4.400 -21.888 58.011 89.832 Net Income 0 85.655 51.206 Balance First Period 0 5.801 8.983 0 0 81.000 Zakat Reserves Cash Dividends 0 1.400 1.400 Other Distributions 0 55.465 85.655 Balance End Period Cash Flow Cash Flow 2017 2016 2015 -23.762 58.011 94.232 Net Income 93.101 75.611 62.932 Depreciation 5.206 -538 -238 -38.766 -18.601 -24.510 Accounts Receivable Inventory 0 0 0 Prepaid Expenses -26.294 -17.431 66.412 Accounts Payable 6.293 6.476 -15.741 -8.807 -26.651 -123.381 Purchases of Fixed Assets 0 -2.659 -101.849 Other Changes in Investing Act. 10.410 -72.269 98.316 Other Changes in Oper. Activity Increase in Debts Other Changes in Financing Act. -448 -78.589 -44.259 12.136 88.776 76.862 Cash at Begining of Period 29.069 12.136 88.776 Cash at End of Period 2017 2016 2015 0,205296125 -0,680389438 -0,117700542 1,22447586 109,765135 0,121418457 -0,51411729 -0,168013484 1,238676868 88,04267221 0,36853516 -0,28911379 -0,101941389 1,24857332 245,7393533 0,392237636 -7,118694362 -7,118694362 0,388859694 14,47213191 14,47213191 0,40808159 21,41636364 21,41636364 2017 2016 2015 0,633385794 1,637996762 1,691097783 32,00307338 -458,2342007 -1144,588235 0,087968113 0,127892735 0,134098508 -0,747389198 -0,761205182 -1,315447131 -1242858 -1212697 -1228925 2017 2016 2015 -14% -0,012546206 -0,020643276 24% 0,030094453 0,049243116 35% 0,046386982 0,078367189 2017 2016 2015 Liquidity Ratios Current Ratio Quick Ratio Net Working Capital Ratio Cash Ratio Interval Measure Leverage ratios Total Debt Ratio Time Interest Cash coverage Assets Management Ratios Inventory turnover Receivable turnover Total Assets turnover Net Working Capital Turnover Fixed Assets Turnover Profitability ratios Profit Margin Return on Assets Return on Equity Market value ratios Market Price Share outstanding Al Jouf Cement Co. Umm Al-Qura Cement Co. Balance Sheet 2017 2016 Balance Sheet 2017 2015 232.460 231.087 167.103 Current Assets 107.928 205.000 233.534 192.148 Inventory 105.366 52.404 72.797 121.360 934.920 978.061 1.029.853 1.017.688 993.446 997.717 1.015.145 Investments Fixed Assets Other Assets 2.418.230 2.513.196 2.525.609 Total Assets 1.230.982 286.990 348.045 229.900 493.587 567.290 771.443 5.923 5.845 5.200 1.631.730 1.592.016 1.519.066 2.418.230 2.513.196 2.525.609 0 Current Liabilities Non-Current Liabilities 82.256 590.743 Other Liabilities Shareholders Equity Total Liabilities and Shareholder Equity STATEMENT OF INCOME 2017 0 0 557.983 1.230.982 STATEMENT OF INCOME 2016 2015 2017 265.895 319.890 336.287 Sales 193.240 186.425 211.659 214.268 Sales Cost 121.366 79.470 108.231 122.019 Total Income 71.874 4.250 7.002 1.575 Other Revenues 28.237 83.720 115.233 123.594 Total Revenues 100.111 24.795 29.536 33.236 0 0 0 16.115 11.630 11.021 Other Expenses 19.892 40.910 41.166 44.257 Total Expenses 31.434 42.810 74.067 79.337 Net Income Before Zakat 68.677 1.700 2.000 3.000 Admin and Marketing Expenses Depreciation Zakat Net Income 41.110 72.067 76.337 242.730 177.869 108.164 4.111 7.207 7.634 0 0 0 Cash Dividends Other Distributions 0 0 0 149.729 242.730 176.867 Balance First Period Reserves Balance End Period Cash Flow 11.542 0 2.975 65.702 242.730 4.111 0 0 149.729 Cash Flow 2017 2016 2015 2017 42.810 74.068 79.337 Net Income 68.677 60.903 60.456 59.525 Depreciation 53.519 -65.842 -16.480 -42.839 Accounts Receivable -35.375 28.533 -41.386 -2.182 Inventory -61.714 4.078 22.298 -8.929 Prepaid Expenses 0 7.312 -15.195 6.801 Accounts Payable 7.413 48.979 8.014 -20.519 Other Changes in Oper. Activity -49.079 -302 -64.636 14.347 47.450 -29.341 0 0 0 Purchases of Fixed Assets Other Changes in Investing Act. Increase in Debts -1.522 -15.722 -71.556 0 -130.588 -72.027 9.935 99.028 32.132 44.980 Other Changes in Financing Act. Cash at Begining of Period 60.481 99.028 32.132 Cash at End of Period 2017 2016 2015 0,80999338 0,6639572 0,726850805 0,095682776 -0,007031 -0,10893867 -0,02254955 -0,046538 -0,0248641 0,890751487 0,8907515 0,890751487 184,3915382 359,50661 462,3634813 0,325237881 0,3665373 0,398534769 25,18235294 37,0335 26,44566667 25,18235294 37,0335 26,44566667 2017 2016 2015 0,909390244 1,5798912 1,663932969 -4,03837976 -19,4108 -7,85001984 0,109954388 0,1272841 0,133150856 -4,87612323 -2,735084 -5,35514435 -669025 -658171 -693566 2017 2016 2015 16% 23% 24% 0,017703031 0,0294716 0,031413018 0,026235958 0,0465247 0,052227487 2017 2016 2015 73.621 23.681 41.022 2017 Liquidity Ratios Current Ratio 1,312098813 Quick Ratio 0,031146664 Net Working Capital Ratio 0,020854895 Cash Ratio 0,890751487 Interval Measure 184,3915382 Leverage ratios Total Debt Ratio 0,546717174 Time Interest 23,08470588 Cash coverage 23,08470588 2017 Assets Management Ratios Inventory turnover 1,151851641 Receivable turnover -5,462614841 Total Assets turnover 0,156980362 Net Working Capital Turnover 7,527267061 Fixed Assets Turnover -824448 2017 Profitability ratios Profit Margin 36% Return on Assets 0,055790418 Return on Equity 0,123080811 2017 Market value ratios Market Price Share outstanding m Al-Qura Cement Co. Northern Region Cement Co. Balance Sheet 2016 Balance Sheet 2017 2015 63.388 97.552 43.652 4.619 2.552 960.345 1.047.651 2.581 45.948 54.795 1.203.191 1.119.892 186.258 169.410 524.507 447.625 0 0 492.426 502.857 1.203.191 1.119.892 Current Assets 244.444 Inventory 507.890 Investments Fixed Assets Other Assets 1.569.542 Total Assets 3.112.851 Current Liabilities Non-Current Liabilities 1.048.784 81.588 709.387 17.290 Other Liabilities Shareholders Equity 2.039.322 Total Liabilities and Shareholder Equity 3.112.851 TATEMENT OF INCOME 0 STATEMENT OF INCOME 2016 40.045 2015 0 2017 Sales 462.669 28.105 0 Sales Cost 289.452 11.940 0 Total Income 173.217 0 0 Other Revenues 11.940 0 Total Revenues 15.337 11.045 0 0 Admin and Marketing Expenses 4.043 177.260 70.985 Depreciation 0 5.951 6.870 Other Expenses 45.126 21.288 17.915 Total Expenses 116.111 -9.348 -17.915 1.083 1.230 Net Income Before Zakat Zakat 61.149 8.644 -10.431 -19.145 Net Income 52.505 177.869 108.164 Balance First Period 81.018 7.207 7.634 Reserves -5.250 0 0 Cash Dividends 0 0 Other Distributions 242.730 176.867 Balance End Period Cash Flow 0 0 128.273 Cash Flow 2016 2015 -9.348 -17.915 14.269 95 -30.887 -50.662 -38.554 -4.619 2017 Net Income 61.149 Depreciation 64.700 Accounts Receivable 69.791 Inventory 55.088 0 0 Prepaid Expenses 73.907 8.521 4.844 Accounts Payable -6.346 -1.505 - -7.257 -1.922 -82.586 -438.566 0 0 Other Changes in Oper. Activity -22.061 Purchases of Fixed Assets -13.781 Other Changes in Investing Act. Increase in Debts -169.310 -5.000 123.218 236.532 Other Changes in Financing Act. 47.810 320.022 Cash at Begining of Period 86.143 23.681 47.809 Cash at End of Period 19.669 2016 2015 0,340323637 0,105960549 -0,102120112 0,890751487 359,5066114 0,575833776 0,548568561 -0,064165116 0,890751487 462,3634813 0,590733308 -8,631578947 -8,631578947 0,550977237 -14,56504065 -14,56504065 2016 2015 2,447488557 -1,296500146 0,03328233 -0,325913567 -1007606 2,231065691 0 0 0 -2581 2016 2015 -23% -0,00776934 -0,018983563 #DIV/0! -0,015997078 -0,035626431 2016 2015 Liquidity Ratios Current Ratio Quick Ratio Net Working Capital Ratio Cash Ratio Interval Measure Leverage ratios Total Debt Ratio Time Interest Cash coverage Assets Management Ratios Inventory turnover Receivable turnover Total Assets turnover Net Working Capital Turnover Fixed Assets Turnover Profitability ratios Profit Margin Return on Assets Return on Equity Market value ratios Market Price Share outstanding -174.611 2017 0,23307373 -0,2511919 -0,2583934 0,89075149 184,391538 0,34247511 7,07415548 7,07415548 2017 0,56991081 6,62935049 0,14863191 -0,5752157 -1106873 2017 13% 0,01964405 0,02998497 2017 n Region Cement Co. Southern Province Cement Co. Balance Sheet Balance Sheet 2016 2015 2017 441.532 445.476 Current Assets 149.086 562.978 581.330 Inventory 658.141 77.812 77.812 1.497.258 1.566.219 592.160 566.461 3.171.740 Investments Fixed Assets Other Assets 0 3.349.436 3.237.298 Total Assets 4.156.6 ...
Purchase answer to see full attachment

Tutor Answer

Emilyprofessor
School: University of Maryland

Attached.

10 Materials Companies
1.
Hail Cement Co.
2.
Najran Cement Co.
3.
Qassim Cement Co.
4.
Tabuk Cement Co.
5.
Al Jouf Cement Co.
6.
Umm Al-Qura Cement Co.
7.
Northern Region Cement Co.
8.
Southern Province Cement Co.
9.
Eastern Province Cement Co.
10. Yanbu Cement Co.

Hail Cement Co.
Balance Sheet
2017
Current Assets

Balance Sheet

Inventory
Investments
Fixed Assets
Other Assets
Total Assets
Current Liabilities
Non-Current Liabilities

2016

73,063

162,758

277,224

197,099

38,620

38,500

933,515

972,102

93

202

1,322,515

1,370,661

82,024

76,002

212,376

233,370

Other Liabilities
Shareholders Equity

0

0

1,028,115

1,061,289

Total Liabilities and Shareholder Equity

1,322,515

1,370,661

STATEMENT OF INCOME
2017
Sales

164,540

272,119

49,360

72,153

115,180

199,966

2,882

6,228

118,062

206,194

Admin and Marketing Expenses

24,361

30,314

Depreciation

66,583

62,778

Sales Cost
Total Income
Other Revenues
Total Revenues

STATEMENT OF INCOME

2016

Other Expenses

4,323

0

Total Expenses

95,267

93,092

Net Income Before Zakat

22,795

113,102

7,254

8,586

Zakat
Net Income

15,541

104,516

Balance First Period

43,124

1,055,919

Reserves
Cash Dividends

-1,554

-

-39,160

-97,900

Other Distributions

-4,691

-1,247

Balance End Period

13,260

1,061,288

Cash Flow
2017
Net Income

22,796

113,102

Depreciation

66,583

62,778

Accounts Receivable
Inventory

Cash flow

2016

9,148

4,093

-87,418

-77,640

Prepaid Expenses

243

10

Accounts Payable

3,174

-2,765

-9,766

-6,032

-23,922

-16,672

25

-

-22,000

-18,000

Other Changes in Oper. Activity
Purchases of Fixed Assets
Other Changes in Investing Act.
Increase in Debts

Cash
Other Changes in Financing Act.

-39,160

-97,900

Cash at Begining of Period

120,698

159,732

40,401

120,706

Cash at End of Period

Liquidity Ratios
Current Ratio
Quick Ratio
Net Working Capital Ratio
Cash Ratio
Interval Measure
Leverage ratios
Total Debt Ratio
Time Interest
Cash coverage
Assets Management Ratios
Inventory turnover
Receivable turnover
Total Assets turnover
Net Working Capital Turnover
Fixed Assets Turnover
Profitability ratios
Profit Margin
Return on Assets
Return on Equity
Market value ratios
Market Price
Share outstanding
Book Value

2017

2016

4.741380572
-2.489039793
-0.006775727
0.890751487
184.3915382

5.241401542
-0.451843373
0.063295009
2.141496276
359.5066114

2017

2016

0.222606171
3.142404191
12.3212021

0.225710077
13.17283951
20.48450967

2017

2016

0.178050962
17.98644512
0.124414468
-18.36178998
0.124414468

1.293405472
66.48399707
0.19853122
3.136601503
0.19853122

2017

2016

14%
0.017236856
0.022172617

42%
0.082516392
0.106570406

2017

2016

9.9
979000
1.050168539

11.54
979000
1.084054137

Najran Cement Co.
Balance Sheet
2017

2015
Current Assets

199,136

46,157

Inventory

306,377

36,759

Investments
Fixed Assets
Other Assets

0
2,222,185

Total Assets

2,730,733

285,258

1,012,075
296
1,380,545
73,053
251,573

0

Current Liabilities
Non-Current Liabilities

3,035
176,484
525,366

1,055,919

Other Liabilities
Shareholders Equity

0
2,028,883

1,380,545

Total Liabilities and Shareholder Equity

2,730,733

STATEMENT OF INCOME
2015

2017

356,363

Sales

346,244

130,129

Sales Cost

299,332

226,234

Total Income

-10,454

Other Revenues

5,150

215,780

Total Revenues

52,062

33,698

Admin and Marketing Expenses

36,688

61,362

Depreciation

0
95,060
120,720
7,174

46,912

2,329

Other Expenses

23,605

Total Expenses

62,622

Net Income Before Zakat
Zakat

-10,560
11,300

Net Income

-21,860

67,872

Balance First Period

253,770

11,355

Reserves

0

Cash Dividends

0

113,546

117,480

52,584

Other Distributions
Balance End Period

6,086
225,824

Cash Flow
2015

2017

120,720

Net Income

-10,560

61,362

Depreciation

109,864

1,581
-27,537

Accounts Receivable
Inventory

4,263
423

-186

Prepaid Expenses

2,933

-5,184

Accounts Payable

-2,627

Other Changes in Oper. Activity

-24,665

-14,662

Purchases of Fixed Assets

-14,928

-49,981

Other Changes in Investing Act.

-13,000

Increase in Debts

9,599

1,424
-100,000

Other Changes in Financing Act.

-2,309

194,436

Cash at Begining of Period

48,812

159,667

Cash at End of Period

12,630

-117,481

2015

5.039820404
3.272979891
0.153711034
3.904808837
462.3634813
2015

0.235143367
16.82743239
25.38081963
2015

1.309342857
225.4035421
0.258132114
1.679333663
0.258132114
2015

34%
0.087443727
0.114326951
2015

12.81
979000
1.078568948

Liquidity Ratios
Current Ratio
Quick Ratio
Net Working Capital Ratio
Cash Ratio
Interval Measure
Leverage ratios
Total Debt Ratio
Time Interest
Cash coverage
Assets Management Ratios
Inventory turnover
Receivable turnover
Total Assets turnover
Net Working Capital Turnover
Fixed Assets Turnover
Profitability ratios
Profit Margin
Return on Assets
Return on Equity
Market value ratios
Market Price
Share outstanding
Book Value

2017

2.864355976
-0.607652818
0.008295209
1.128351579
200.8118159
0.257018903
-0.934513274
-0.72840708
2017

0.977005454
81.22073657
0.12679526
15.28536112
0.15581241
2017

-3%
-0.003867094
-0.005204834
2017

8.53
1700000
1.193460588

jran Cement Co.

Qassim Cement Co.

Balance Sheet

Balance Sheet
2016

2015

239,202

276,357

Current Assets

306,800

361,902

Inventory

0

Investments
Fixed Assets
Other Assets

0
2,318,367

2,430,434

3,381

4,579

2,867,750

3,073,272

189,812

230,104

621,109

714,808

0

0

2,056,829

2,128,360

Other Liabilities
Shareholders Equity

2,867,750

3,073,272

Total Liabilities and Shareholder Equity

Total Assets
Current Liabilities
Non-Current Liabilities

TEMENT OF INCOME

STATEMENT OF INCOME
2016

2015
Sales

631,197

1,086,649

425,808

446,380

Sales Cost

205,389

640,269

Total Income

7,525

5,776

212,914

646,045

Total Revenues

42,935

209,832

Admin and Marketing Expenses

2,346

121,171

Depreciation

Other Revenues

28,391

29,279

Other Expenses

73,672

360,282

Total Expenses

139,242

285,763

Net Income Before Zakat

13,500

30,139

125,742

255,624

Net Income

337,772

296,710

Balance First Period

12,471

25,562

187,000

187,000

10,273

2,000

253,770

337,772

Zakat

Reserves
Cash Dividends
Other Distributions
Balance End Period

Cash Flow

Cash Flow
2016

2015

139,242

285,763

Net Income

117,040

121,171

Depreciation

39,755

-8,163

Accounts Receivable

-68,358

32,534

Inventory

457

2,472

Prepaid Expenses

-21,939

8,812

Accounts Payable

-21,661

2,111

Other Changes in Oper. Activity

-8,256

-11,844

Purchases of Fixed Assets

-658

-11,957

Other Changes in Investing Act.

-100,000

-101,757

Increase in Debts

-188,871

-188,803

162,061

31,722

48,812

162,061

2016

2015

2.876540998
-0.35613133
0.017222561
1.260204834
174.7992512

2.773784897
-0.371766679
0.015050083
1.201009109
125.0465561

0.282772557
10.31422222
10.488

0.307461233
9.481502372
13.50190783

2016

2015

1.387900913
1.233427834
15.87717268
-133.1188289
0.220101822
0.353580484
12.77985422
23.4935896
0.27225931
0.447100806
2016

2015

22%
0.048554442
0.067697412

26%
0.092983309
0.13426441

2016

2015

11.95
1700000
1.209899412

11.07
1700000
1.251976471

Other Changes in Financing Act.
Cash at Begining of Period
Cash at End of Period

Liquidity Ratios
Current Ratio
Quick Ratio
Net Working Capital Ratio
Cash Ratio
Interval Measure
Leverage ratios
Total Debt Ratio
Time Interest
Cash coverage
Assets Management Ratios
Inventory turnover
Receivable turnover
Total Assets turnover
Net Working Capital Turnover
Fixed Assets Turnover
Profitability ratios
Profit Margin
Return on Assets
Return on Equity
Market value ratios
Market Price
Share outstanding
Book Value

Qassim Cement Co.
Balance Sheet
2017

Tabuk Cement Co.
Balance Sheet
2016

2015

840,162

889,063

927,976

Current Assets

268,003

233,869

222,099

Inventory

0

0

0

836,972

840,781

900,971

43,747

80,006

62,161

1,988,884

2,043,719

2,113,207

205,351

213,524

197,166

0

0

0

39,328

33,543

32,452

1,744,205

1,796,652

1,883,589

Other Liabilities
Shareholders Equity

1,988,884

2,043,719

2,113,207

Total Liabilities and Shareholder Equity

Investments
Fixed Assets
Other Assets
Total Assets
Current Liabilities
Non-Current Liabilities

STATEMENT OF INCOME
2017

STATEMENT OF INCOME
2016

2015
Sales

625,946

852,044

1,023,897

352,267

405,173

394,218

Sales Cost

273,679

446,871

629,679

Total Income

16,657

27,693

26,046

Other Revenues

290,336

474,564

655,725

Total Revenues

29,045

28,921

28,290

0

0

0

Depreciation
Other Expenses

Admin and Marketing Expenses

0

0

0

29,045

28,921

28,290

261,291

445,643

627,435

9,500

35,800

41,000

251,791

409,843

586,435

Net Income

514,391

254,141

290,650

Balance First Period

0

-150,148

58,644

261,000

427,500

562,500

2,900

2,900

1,800

502,282

383,732

254,141

Total Expenses
Net Income Before Zakat
Zakat

Reserves
Cash Dividends
Other Distributions
Balance End Period

Cash Flow

Cash Flow
2017

2016

2015

261,291

445,643

627,435

Net Income

69,179

73,707

76,233

Depreciation

13,886

-30,759

-22,568

-34,782

-12,785

3,330

Accounts Receivable
Inventory

0

0

0

Prepaid Expenses

2,571

10,971

6,416

Accounts Payable

-39,022

-41,188

-35,067

Other Changes in Oper. Activity

-12,630

-33,359

-40,845

Purchases of Fixed Assets

-3,357

58,543

86,177

0

0

0

Other Changes in Investing Act.
Increase in Debts

Other Changes in Financing Act.

-276,481

-491,602

-684,331

71,611

39,814

23,034

Cash at Begining of Period

52,266

18,985

39,814

Cash at...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors