These are the instructions for the Financial Ratio & Analysis Assignment You need to download from the class materials your Excel file, the Industrial file, and the Template. > The project is divided into three parts: First: Introduction about the company. Second: Estimating ratios for the period of 2015-2018, place them on the Template. Third: Write down your comment on; each of the ratios, the Group level, and finally your assessment of the company all in all by taking into consideration both Time Series and Cross Sectional. 1. Introduction - A short-brief about the company 2. Evaluation of the Liquidity Position Table (1): Liquidity Ratios Ratio 2015 2016 2017 2018 Current ratio Quick (acid-test) ratio 3. Evaluation of the Activity Position Table (2): Activity Ratios Ratio 2015 2016 2017 2018 Inventory turnover Average age of inventory Average collection period Average payment period Total assets turnover Note: Assuming the annual purchase is a 50% of CGS. 4. Evaluation of the Debt Position Table (3): Debt Ratios Ratio 2015 2016 2017 2018 Debt ratio Time interest earned ratio (Coverage ratio) 5. Evaluation of the Profitability Position Table (4): profitability Ratios Ratio 2015 2016 2017 2018 Gross profit margin Operating profit margin Net profit margin Earnings per share (EPS) Return on total assets (ROA) Return on common equity (ROE) 6. Evaluation of the Market Position Table (5): Market Ratios Ratio 2015 2016 2017 2018 Price/earnings (P/E) ratio Market/book (M/B) ratio 7. Overall Financial Position of the Firm Per each Ratio/ each Group/ company all in all ARAB COMPANY FOR INVESTMENT PROJECTS Trading Information Par Value / Share (JD) Closing Price (JD) Value Traded (JD) No. of Shares Traded No. of Transactions No. of Subscribed Shares Market Capitalization (JD) Fiscal Year Ended Assets(JD) Cash on Hand & at Banks Account Receivables, Net Notes Receivable Post Dated Cheques Short Term Investments Inventory Spare Parts Total Current Assets Long Term Investments Fixed Assets, Net Lands Projects in Progress Total Fixed Assets Other Assets Total Assets Liabilities & Owners Equity Liabilities (JD) Accounts and Notes Payable Credit Banks Short Term Loans Accrued Part of Long Term Loans Total Current Liabilities Long Term Loans & Notes Payable Corporate Bonds Other Liabilities Total Liabilities 2018 1.00 0.83 24,631 30,640 88 3,551,982 2,948,145 31/12/18 218,408 23,240 0 0 0 0 0 1,109,966 0 3,107 2,209,375 6,381,832 8,594,314 0 9,704,280 793,291 0 0 0 1,538,798 3,280,000 0 0 4,818,798 141003 2017 1.00 0.66 1,184,038 1,027,629 396 3,551,982 2,344,308 31/12/17 62,242 28,086 0 0 63,120 0 2,191.559 0 8,384 0 6,381,832 6,390,216 0 8,581,775 939,349 0 0 0 1,691,413 3,280,000 0 0 4,971,413 2016 1.00 1.09 3,691,363 7,424,827 2,414 3,551,982 3,871,660 31/12/16 3.971 16,104 0 0 0 150,971 0 2,208,933 0 790.354 0 6,381,832 7,172,186 0 9,381,119 718,390 0 0 0 1,868,449 3,280,000 0 0 5,148,449 2015 1.00 0.15 709,560 4,415,585 1,512 10,000,000 1,500,000 31/12/15 6,189 15,170 0 48,443 187,995 0 2,311,947 0 826,930 0 6,381,832 7,208,762 0 9,520,709 728,107 0 0 0 1,873,485 3,280,000 0 0 5,153,485 Shareholders Equity (JD) Authorized Capital Subscribed Capital Paid-in Capital Compulsory Reserves Voluntary Reserve Other Reserves Issuance Premium Issuance Discount Treasury Stocks Cash Dividends Stock Dividends Accumulated Change in Fair Value Retained Earnings Total Shareholders Equity Non-controlling Interest Total Liabilities & Shareholders Equity Income Statement (JD) Operating Revenues Operating Expenses Gross Profit General and Administrative Expenses Selling and Distribution Expenses Depreciation (period) Other Operating Expenses Net Operating Income Other Revenues Other Expenses Income Before Interest & Tax Interest Expenses Net Income before Tax Income Tax (Period) Income Tax (Previous Years) Universities and Research Train Fees Board of Directors Remuniration Net Income Non-controlling Interest Net Income Pertains to Shareholders Cash Flow (JD) Cash Balance (Beginning) Net Cash Flow from (Used In) Operating Activities Net Cash Flow from (Used In) Investing Activities Net Cash Flow from (Used In) Financing Activities Cash Balance (Ending) 3,551,982 3,551,982 3,551,982 298,310 0 0 0 0 0 0 0 0 171,009 4,021,301 864,181 9,704,280 19,183 76,710 (57,527) 106,241 0 5,478 0 (163,768) 2,457,841 1,006,896 1,287,177 0 1,287,177 0 12,057 0 0 1,275,120 135,190 1,139,930 62,242 2,412,259 (2,209,576) (46,517) 218,408 3,551,982 3,551.982 3,551,982 124,537 0 0 0 0 0 0 0 0 (795,148) 2,881,371 728,991 8,581,775 49,993 94,929 (44,936) 105,410 3,483 34,103 50,000 (203,829) 0 416,696 (620,525) 1,783 (622,308) 0 0 0 0 (622.308) (43) (622.265) 3,971 (594,474) 747,867 (95,122) 62,242 3,551.982 3.551.982 3,551,982 124,537 0 0 0 0 0 0 0 0 (172,883) 3,503,636 729,034 9,381,119 60,079 95,666 (35,587) 108,041 7,901 33,961 0 (151,529) 24,465 37,087 (164,151) 8,815 (172,966) 0 0 0 0 (172,966) (83) (172,883) 6,189 (53,447) 89,470 (38,241) 3,971 10,000,000 10,000,000 10,000,000 124,537 0 0 0 0 0 0 0 (38.412) (6,448,018) 3,638,107 729,117 9,520,709 54,056 176,308 (122,252) 151,175 35,565 107,687 0 (308,992) 0 7,663 (316,655) 12,996 (329,651) 0 0 0 0 (329,651) (1.242) (328,409) 202,109 (175,053) 30,460 (51,327) 6,189 These are the instructions for the Financial Ratio & Analysis Assignment You need to download from the class materials your Excel file, the Industrial file, and the Template. > The project is divided into three parts: First: Introduction about the company. Second: Estimating ratios for the period of 2015-2018, place them on the Template. Third: Write down your comment on; each of the ratios, the Group level, and finally your assessment of the company all in all by taking into consideration both Time Series and Cross Sectional. 1. Introduction - A short-brief about the company 2. Evaluation of the Liquidity Position Table (1): Liquidity Ratios Ratio 2015 2016 2017 2018 Current ratio Quick (acid-test) ratio 3. Evaluation of the Activity Position Table (2): Activity Ratios Ratio 2015 2016 2017 2018 Inventory turnover Average age of inventory Average collection period Average payment period Total assets turnover Note: Assuming the annual purchase is a 50% of CGS. 4. Evaluation of the Debt Position Table (3): Debt Ratios Ratio 2015 2016 2017 2018 Debt ratio Time interest earned ratio (Coverage ratio) 5. Evaluation of the Profitability Position Table (4): profitability Ratios Ratio 2015 2016 2017 2018 Gross profit margin Operating profit margin Net profit margin Earnings per share (EPS) Return on total assets (ROA) Return on common equity (ROE) 6. Evaluation of the Market Position Table (5): Market Ratios Ratio 2015 2016 2017 2018 Price/earnings (P/E) ratio Market/book (M/B) ratio 7. Overall Financial Position of the Firm Per each Ratio/ each Group/ company all in all ARAB COMPANY FOR INVESTMENT PROJECTS Trading Information Par Value / Share (JD) Closing Price (JD) Value Traded (JD) No. of Shares Traded No. of Transactions No. of Subscribed Shares Market Capitalization (JD) Fiscal Year Ended Assets(JD) Cash on Hand & at Banks Account Receivables, Net Notes Receivable Post Dated Cheques Short Term Investments Inventory Spare Parts Total Current Assets Long Term Investments Fixed Assets, Net Lands Projects in Progress Total Fixed Assets Other Assets Total Assets Liabilities & Owners Equity Liabilities (JD) Accounts and Notes Payable Credit Banks Short Term Loans Accrued Part of Long Term Loans Total Current Liabilities Long Term Loans & Notes Payable Corporate Bonds Other Liabilities Total Liabilities 2018 1.00 0.83 24,631 30,640 88 3,551,982 2,948,145 31/12/18 218,408 23,240 0 0 0 0 0 1,109,966 0 3,107 2,209,375 6,381,832 8,594,314 0 9,704,280 793,291 0 0 0 1,538,798 3,280,000 0 0 4,818,798 141003 2017 1.00 0.66 1,184,038 1,027,629 396 3,551,982 2,344,308 31/12/17 62,242 28,086 0 0 63,120 0 2,191.559 0 8,384 0 6,381,832 6,390,216 0 8,581,775 939,349 0 0 0 1,691,413 3,280,000 0 0 4,971,413 2016 1.00 1.09 3,691,363 7,424,827 2,414 3,551,982 3,871,660 31/12/16 3.971 16,104 0 0 0 150,971 0 2,208,933 0 790.354 0 6,381,832 7,172,186 0 9,381,119 718,390 0 0 0 1,868,449 3,280,000 0 0 5,148,449 2015 1.00 0.15 709,560 4,415,585 1,512 10,000,000 1,500,000 31/12/15 6,189 15,170 0 48,443 187,995 0 2,311,947 0 826,930 0 6,381,832 7,208,762 0 9,520,709 728,107 0 0 0 1,873,485 3,280,000 0 0 5,153,485 Shareholders Equity (JD) Authorized Capital Subscribed Capital Paid-in Capital Compulsory Reserves Voluntary Reserve Other Reserves Issuance Premium Issuance Discount Treasury Stocks Cash Dividends Stock Dividends Accumulated Change in Fair Value Retained Earnings Total Shareholders Equity Non-controlling Interest Total Liabilities & Shareholders Equity Income Statement (JD) Operating Revenues Operating Expenses Gross Profit General and Administrative Expenses Selling and Distribution Expenses Depreciation (period) Other Operating Expenses Net Operating Income Other Revenues Other Expenses Income Before Interest & Tax Interest Expenses Net Income before Tax Income Tax (Period) Income Tax (Previous Years) Universities and Research Train Fees Board of Directors Remuniration Net Income Non-controlling Interest Net Income Pertains to Shareholders Cash Flow (JD) Cash Balance (Beginning) Net Cash Flow from (Used In) Operating Activities Net Cash Flow from (Used In) Investing Activities Net Cash Flow from (Used In) Financing Activities Cash Balance (Ending) 3,551,982 3,551,982 3,551,982 298,310 0 0 0 0 0 0 0 0 171,009 4,021,301 864,181 9,704,280 19,183 76,710 (57,527) 106,241 0 5,478 0 (163,768) 2,457,841 1,006,896 1,287,177 0 1,287,177 0 12,057 0 0 1,275,120 135,190 1,139,930 62,242 2,412,259 (2,209,576) (46,517) 218,408 3,551,982 3,551.982 3,551,982 124,537 0 0 0 0 0 0 0 0 (795,148) 2,881,371 728,991 8,581,775 49,993 94,929 (44,936) 105,410 3,483 34,103 50,000 (203,829) 0 416,696 (620,525) 1,783 (622,308) 0 0 0 0 (622.308) (43) (622.265) 3,971 (594,474) 747,867 (95,122) 62,242 3,551.982 3.551.982 3,551,982 124,537 0 0 0 0 0 0 0 0 (172,883) 3,503,636 729,034 9,381,119 60,079 95,666 (35,587) 108,041 7,901 33,961 0 (151,529) 24,465 37,087 (164,151) 8,815 (172,966) 0 0 0 0 (172,966) (83) (172,883) 6,189 (53,447) 89,470 (38,241) 3,971 10,000,000 10,000,000 10,000,000 124,537 0 0 0 0 0 0 0 (38.412) (6,448,018) 3,638,107 729,117 9,520,709 54,056 176,308 (122,252) 151,175 35,565 107,687 0 (308,992) 0 7,663 (316,655) 12,996 (329,651) 0 0 0 0 (329,651) (1.242) (328,409) 202,109 (175,053) 30,460 (51,327) 6,189