Solution Enter a formula to calculate required ratios Saudi Ceramics Ratio Analysis 2 3 Ratio Analysis 5 Debt Management Analysis 6 Debt to Equity Ratio 97 Times-Interest-Earned Ratio 98 Liquidity Analysis 39 Current Ratio 00 Quick Ratio 01 Asset Management Analysis 02 Inventory Turnover Ratio Days Sales Outstanding or Account Rec. Turnover or Avg. 103 Collection Period 104 Profitability Analysis 105 Return on total assets 106 Return on Common Equity 107 Gross Margin 108 Net Margin 109 Market Value Analysis 110 Price per Share 111 Book Value per Share 112 Earnings Per Share 113 Price to Earnings (P-E) Ratio 114 115 116 117 118 N34 2016 ? ? ? ? ? ? ? ? ? 2015 ? ? ? ? ? ? ? ? ? ? ? 1 2 Financial Ratio Analysis Saudi Ceramics Balance Sheet (numbers in thousands) 2016 24,199 195,073 824,635 111,055 50,476 1,205,438 33,358 1,736,063 125,720 3,100,579 201,852 261,703 203,000 88,210 16,952 771,717 430,348 75,834 1,277,899 500,000 1.100.944 221,736 1,822,680 3,100,579 50,000 3 4 5 ASSETS 8 Current Assets 7 Cash & Cash Equivalents 8 Receivables (net) 9 Inventories 10 Prepayments 11 Others 12 13 Total Current Assets 14 15 Long-term Investments. 16 Fixed Assets 17 Other Assets 18 19 TOTAL ASSETS 20 21 LIABILITIES AND 22 SHAREHOLDER'S EQUITY 23 Current Liabilities 24 Accounts Payable 25 Current Portion of L.T. Debt 28 Short term borrowing 27 Accrued expenses 28 Zakat and income tax payable 29 30 Total Current Liabilities 31 32 Long-Term Debt 33 Other Liabilities 34 35 Total Liabilities 30 37 Preferred Stock 38 Common Shareholder's Equity 39 Common Stock (Note #1) 40 Retained Earnings 41 Other Stockholder Equity 42 Total Common Shareholder's 43 Equity 44 45 TOTAL LIABILITIES AND 46 SHAREHOLDER'S EQUITY 47 4 Shares Outstanding (000) 2015 185,556 171,546 737,513 138,202 30,476 1,263,293 81,812 1,407,831 506,508 3,259,444 242,652 277,110 83,747 15,345 618,854 669,176 73,520 1,361,550 500,000 1.180.257 217,637 1,897,894 3,259,444 50.000 52 53 54 55 56 57 58 59 Total Revenue 80 Cost of Revenue 61 62 Gross Margin 63 84 Operating Expenses 85 Selling Expense 86 General & Administrative 87 Operating Income 68 69 Add: Other income 70 71 Interest and Taxes (EBIT) 72 73 Interest Expense 74 Other Expenses 75 Taxes 76 77 Income Tax Expense 78 NET INCOME FROM OPERATIONS NET INCOME TO COMMON 79 SHARES 80 No. of shares outstanding (000) 81 EARNINGS PER COMMON SH. 82 83 PRICE PER SHARE (YR. END) 84 85 (THOUSANDS) Saudi Ceramics Statement of Operations for the Year Ended December 31, 2016 1,303,519 943,019 360,500 184,432 86,401 89,667 89,667 12,569 30,057 47,041 22,500 24,541 24,541 50,000 $0.49 $33.30 Net Income (Earnings) Before 2015 1,657,975 1,075,995 581,980 207,129 88,779 286,072 286,072 8,128 (21,739) 299,683 15,866 283,817 283,817 50,000 $5.68 $46.60
