Microsoft Excel - (1) Assignment 1 E SSL % - - 2 1 H - G F Pay out ratio D BIS E B A 1 2 3 4 Assement 1 Please find out the financial reports for two companis which are listed in the Palestine Exchange (PEX) 1 2 Note It is prefer that the two companies in the same sector 5 6 7 8 9 B 10 # 1 12 13 3 4 Use excel functions and formulas to assume the results below from the statements that you are fill in sheet 1 & 2 2. 1 Ordinary Preference Ordinary Preference Item Authorized Share Issued Share outstanding share Treasury Share Par Value Per Share Share Capital Share Premium Return on ordinary share equity Pay out ratio Book value per share Note Do not hard coded the above cells (Only formules are accepted) 15 16 17 18 19 20 21 6 7 8 9 22 Explain the financial sitution for each company based on the above mentioned data (Max. 200 word) D 23 Make a comparison between the two companies based on the above mentioned data (Max 100 word) Finally attached the two financial Reports that you are selected (PDF) E 24 25 20 27 28 29 30 32 33 34 Insert the tegured statments 1 100% Insert the required statments 2 CH 15 Equity 2 3:36 2421/4/19 E (40) NE VIEWTNT Microsoft Excel - (1) Assignment 1 E SSL % - - 2 1 H - G F Pay out ratio D BIS E B A 1 2 3 4 Assement 1 Please find out the financial reports for two companis which are listed in the Palestine Exchange (PEX) 1 2 Note It is prefer that the two companies in the same sector 5 6 7 8 9 B 10 # 1 12 13 3 4 Use excel functions and formulas to assume the results below from the statements that you are fill in sheet 1 & 2 2. 1 Ordinary Preference Ordinary Preference Item Authorized Share Issued Share outstanding share Treasury Share Par Value Per Share Share Capital Share Premium Return on ordinary share equity Pay out ratio Book value per share Note Do not hard coded the above cells (Only formules are accepted) 15 16 17 18 19 20 21 6 7 8 9 22 Explain the financial sitution for each company based on the above mentioned data (Max. 200 word) D 23 Make a comparison between the two companies based on the above mentioned data (Max 100 word) Finally attached the two financial Reports that you are selected (PDF) E 24 25 20 27 28 29 30 32 33 34 Insert the tegured statments 1 100% Insert the required statments 2 CH 15 Equity 2 3:36 2421/4/19 E (40) NE VIEWTNT