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

Fundamentals of Financial Management (MindTap Course List)
15th Edition
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Eugene F. Brigham, Joel F. Houston
Chapter4: Analysis Of Financial Statements
Section: Chapter Questions
Problem 11P: RATIO CALCULATIONS Assume the following relationships for the Caulder Corp.: Sales/Total assets 1.3...
icon
Related questions
Question

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

 

 

Expert Solution
steps

Step by step

Solved in 3 steps with 22 images

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning