Calculate the following ratios all are required 1-Receivables Turnover 2-Inventory Turnover 3-Payables Turnover 4-Debt-Equity Ratio 5-Debt Ratio Balance sheet Group Parent Company 31 December 2018 31 March 2018 31 December 2018 31 March 2018 Notes RO RO RO RO ASSETS Non-current Property, plant and equipment 5 6,406,433 7,113,759 3,683,610 4,182,275 Investment in subsidiaries - - 515,750 515,750 Fixed deposit 9.1 1,048,399 - 1,048,399 - Deferred tax assets 27 675,393 537,722 727,632 602,078 Non-current assets 8,130,225 7,651,481 5,975,391 5,300,103 Current Inventories 6 4,481,209 3,832,010 4,450,529 3,651,720 Trade and other receivables 7 3,771,104 3,502,574 3,244,883 2,758,158 Due from related parties 18 - - 351,897 2,439,914 Financial assets at fair value through profit or loss 8 187,604 193,088 187,604 193,088 Fixed deposit 9.1 - 1,025,000 - 1,025,000 Cash and bank balances 9 908,878 1,193,601 901,098 1,173,652 Current assets 9,348,795 9,746,273 9,136,011 11,241,532 Total assets 17,479,020 17,397,754 15,111,402 16,541,635 EQUITY AND LIABILITIES Equity Share capital 10 12,500,000 12,500,000 12,500,000 12,500,000 Legal reserve 11 3,480,985 3,480,985 3,314,319 3,314,319 Capital reserve 12 29,269 29,269 29,269 29,269 Retained earnings (2,024,793) (1,340,564) (3,838,147) (3,239,839) Total equity 13,985,461 14,669,690 12,005,441 12,603,749 LIABILITIES Non-current Term loans 13 684,360 861,368 34,387 61,393 Employees' end of service benefits 14 101,855 132,220 90,330 123,072 Non-current liabilities 786,215 993,588 124,717 184,465 Current Term loans 13 234,682 234,682 34,678 34,678 Short term loan 15 1,500,000 - 1,500,000 - Trade and other payables 16 969,718 1,478,341 883,279 1,177,208 Income tax payable 2,944 21,453 - - Due to related parties 18 - - 563,287 2,541,535 Current liabilities 2,707,344 1,734,476 2,981,244 3,753,421 Total liabilities 3,493,559 2,728,064 3,105,961 3,937,886 Total equity and liabilities 17,479,020 17,397,754 15,111,402 16,541,635 Income statment Group Parent Company Period from 1 Period from Period from 1 Period from April 2018 to 1 April 2017 April 2018 to 1 April 2017 31 December to 31 March 31 December to 31 March 2018 2018 2018 2018 Notes RO RO RO RO Revenue 19 14,580,554 23,759,287 13,502,536 21,183,600 Direct costs 21 (12,665,192) (19,914,768) (12,137,274) (18,244,219) Gross profit 1,915,362 3,844,519 1,365,262 2,939,381 Administration and general expenses 22 (1,957,272) (2,583,579) (1,554,571) (2,138,154) Selling and distribution expenses 23 (924,445) (1,350,347) (994,766) (1,456,472) Loss on disposal of property, plant and equipment 5 - (90,988) - (90,988) Loss on investment – net 24 (4,375) (13,927) (4,375) (13,927) Other income 20 209,349 375,285 483,187 765,957 Finance income 25 26,606 65,746 26,606 65,746 Operating (loss)/profit (734,775) 246,709 (678,657) 71,543 Finance costs 25 (80,489) (100,314) (36,276) (29,665) (Loss)/profit before tax (815,264) 146,395 (714,933) 41,878 Tax income/(expense) 27 139,964 (30,324) 125,554 (22,960) (Loss)/profit for the period/year (675,300) 116,071 (589,379) 18,918 Other comprehensive income for the period/year - - - - Total comprehensive (loss)/income for the period/year (675,300) 116,071 (589,379) 18,918
Calculate the following ratios all are required
1-Receivables Turnover
2-Inventory Turnover
3-Payables Turnover
4-Debt-Equity Ratio
5-Debt Ratio
|
|
Group |
|
Parent Company |
|
|
|
31 December 2018 |
31 March 2018 |
31 December 2018 |
31 March 2018 |
|
Notes |
RO |
RO |
RO |
RO |
ASSETS |
|
|
|
|
|
Non-current |
|
|
|
|
|
Property, plant and equipment |
5 |
6,406,433 |
7,113,759 |
3,683,610 |
4,182,275 |
Investment in subsidiaries |
|
- |
- |
515,750 |
515,750 |
Fixed deposit |
9.1 |
1,048,399 |
- |
1,048,399 |
- |
|
27 |
675,393 |
537,722 |
727,632 |
602,078 |
Non-current assets |
|
8,130,225 |
7,651,481 |
5,975,391 |
5,300,103 |
Current |
|
|
|
|
|
Inventories |
6 |
4,481,209 |
3,832,010 |
4,450,529 |
3,651,720 |
Trade and other receivables |
7 |
3,771,104 |
3,502,574 |
3,244,883 |
2,758,158 |
Due from related parties |
18 |
- |
- |
351,897 |
2,439,914 |
Financial assets at fair value through profit or loss |
8 |
187,604 |
193,088 |
187,604 |
193,088 |
Fixed deposit |
9.1 |
- |
1,025,000 |
- |
1,025,000 |
Cash and bank balances |
9 |
908,878 |
1,193,601 |
901,098 |
1,173,652 |
Current assets |
|
9,348,795 |
9,746,273 |
9,136,011 |
11,241,532 |
Total assets |
|
17,479,020 |
17,397,754 |
15,111,402 |
16,541,635 |
EQUITY AND LIABILITIES |
|
|
|
|
|
Equity |
|
|
|
|
|
Share capital |
10 |
12,500,000 |
12,500,000 |
12,500,000 |
12,500,000 |
Legal reserve |
11 |
3,480,985 |
3,480,985 |
3,314,319 |
3,314,319 |
Capital reserve |
12 |
29,269 |
29,269 |
29,269 |
29,269 |
|
|
(2,024,793) |
(1,340,564) |
(3,838,147) |
(3,239,839) |
Total equity |
|
13,985,461 |
14,669,690 |
12,005,441 |
12,603,749 |
LIABILITIES |
|
|
|
|
|
Non-current |
|
|
|
|
|
Term loans |
13 |
684,360 |
861,368 |
34,387 |
61,393 |
Employees' end of service benefits |
14 |
101,855 |
132,220 |
90,330 |
123,072 |
Non-current liabilities |
|
786,215 |
993,588 |
124,717 |
184,465 |
Current |
|
|
|
|
|
Term loans |
13 |
234,682 |
234,682 |
34,678 |
34,678 |
Short term loan |
15 |
1,500,000 |
- |
1,500,000 |
- |
Trade and other payables |
16 |
969,718 |
1,478,341 |
883,279 |
1,177,208 |
Income tax payable |
|
2,944 |
21,453 |
- |
- |
Due to related parties |
18 |
- |
- |
563,287 |
2,541,535 |
Current liabilities |
|
2,707,344 |
1,734,476 |
2,981,244 |
3,753,421 |
Total liabilities |
|
3,493,559 |
2,728,064 |
3,105,961 |
3,937,886 |
Total equity and liabilities |
|
17,479,020 |
17,397,754 |
15,111,402 |
16,541,635 |
Income statment
|
|
|
Group |
|
Parent Company |
||
|
|
Period from 1 |
|
Period from |
|
Period from 1 |
Period from |
|
|
April 2018 to |
|
1 April 2017 |
|
April 2018 to |
1 April 2017 |
|
|
31 December |
|
to 31 March |
|
31 December |
to 31 March |
|
|
2018 |
|
2018 |
|
2018 |
2018 |
|
Notes |
RO |
|
RO |
|
RO |
RO |
Revenue |
19 |
14,580,554 |
23,759,287 |
|
13,502,536 |
21,183,600 |
|
Direct costs |
21 |
(12,665,192) |
(19,914,768) |
|
(12,137,274) |
(18,244,219) |
|
Gross profit |
|
1,915,362 |
3,844,519 |
|
1,365,262 |
2,939,381 |
|
Administration and general expenses |
22 |
(1,957,272) |
(2,583,579) |
|
(1,554,571) |
(2,138,154) |
|
Selling and distribution expenses |
23 |
(924,445) |
(1,350,347) |
|
(994,766) |
(1,456,472) |
|
Loss on disposal of property, plant and |
|
|
|
|
|
|
|
equipment |
5 |
- |
|
(90,988) |
|
- |
(90,988) |
Loss on investment – net |
24 |
(4,375) |
(13,927) |
|
(4,375) |
(13,927) |
|
Other income |
20 |
209,349 |
375,285 |
|
483,187 |
765,957 |
|
Finance income |
25 |
26,606 |
65,746 |
|
26,606 |
65,746 |
|
Operating (loss)/profit |
|
(734,775) |
246,709 |
|
(678,657) |
71,543 |
|
Finance costs |
25 |
(80,489) |
(100,314) |
|
(36,276) |
(29,665) |
|
(Loss)/profit before tax |
|
(815,264) |
146,395 |
|
(714,933) |
41,878 |
|
Tax income/(expense) |
27 |
139,964 |
(30,324) |
|
125,554 |
(22,960) |
|
(Loss)/profit for the period/year |
|
(675,300) |
116,071 |
|
(589,379) |
18,918 |
|
Other comprehensive income for the |
|
|
|
|
|
|
|
period/year |
|
- |
|
- |
|
- |
- |
Total comprehensive (loss)/income |
|
|
|
|
|
|
|
for the period/year |
|
(675,300) |
116,071 |
|
(589,379) |
18,918 |
Step by step
Solved in 3 steps with 22 images