Ques.1 Horizontal analysis

Ques.2 Vertical analysis

Ques.3 Calculate following ratios

a. Current ratio

b. Times interest earned

c. Current cash debt coverage

d. Inventory turnover

e. Profit margin

f. Average collection period

g. Asset turnover

h. Average days in inventory

i. Price-earnings ratio

j. Payout ratio

Summer -I- 2016-2017 Group Assignment Summer-I 2016-2017 Group Assignment TEST INFORMATION Course Code: ACT 205 Last date of submission : 10th July 2017 Course Title: Introduction To Accounting Number of Pages: 11 STUDENT INFORMATION Student Name and ID S.No. 1. 2. 3. 4. 5. Student Name ID Number ASSIGNMENTS GUIDED INSTRUCTIONS 1. This is a group assignment comprising 5 students in a group. 2. The last date for the submission of assignment is 10th July 2017 3. All questions in the assignments are compulsory. 4. Respective marks for the questions are assigned in brackets ( ) 5. Completed assignments can only be accepted in typed form, no hand written assignments is allowed. 6. A separate MS Word file for related ratios has to be attached while solving Question no. 3 7. A completed assignments has to be in MS- EXCEL format. FOR EXAMINER'S USE ONLY Item Question no. CLO's Addressed Marks allocated Marks obtained Section A (5 Marks) 1 Section B (5 Marks) 2 Section C (10 Marks) 3 part a - j LO 1,2, LO 2,3,4 LO 5,6 (5 Marks) (5 Marks) (10 Marks) Marks obtained (words) Page 1 of 1 Total 20 (20%) Assignments ACT 205 Introduction to Accounting Given below is the condensed financial statement of Emmar PJSC for the Q1 2016 and the Q1 2017. On the basis of information you are requested to perform Ques. 1 Horizontal analysis (5 marks) Ques. 2 Vertical analysis (5 marks) Ques. 3 Calculate following ratios a. b. c. d. e. f. g. h. i. j. Current ratio Times interest earned Current cash debt coverage Inventory turnover Profit margin Average collection period Asset turnover Average days in inventory Price-earnings ratio Payout ratio (10 marks)