please help me fill out the ratios. Thanks
Year 5 Year 4 Year 3 Year 2 Year 1 opening 2,494 (5,464) 66 (5,882) (8,786) 2,257 (7,179) (548) (5,879) (11,349) 5,520 (2,854) (923) (5,784) (4,041) 353 (8,209) (532) (5,700) (14,087) 3,168 (3,913) (290) (5,718) (6,753) 24,857 0 5,170 0 30,027 1 FINANCIAL STATEMENTS 2 STATEMENT OF PROFIT OR LOSS 75 Cash flows relating to financing activities 76 Proceeds from borrowings 77 Repayment of borrowings 78 Net proceeds from issue of shares & buy-backs 79 Dividends paid 80 Net cash flows used in/ (from) financing activities 81 82 Net decrease in cash and cash equivalents 83 Cash and cash equivalents at beginning of year 84 CASH AND CASH EQUIVALENTS AT END OF YEAR 85 86 87 ADDITIONAL DATA 88 Number of shares outstanding 89 Market share price 90 (222) 12,258 12,036 (4,866) 17,124 12,258 2,559 14,565 17,124 (7,559) 22,125 14,565 (8,845) 30,970 22,125 30,970 0 30,970 2,461 65.99 2,460 45.63 2,472 54.28 2,489 66.46 2.497 96.77 2,500 114.45 91 92 RATIOS 93 94 Profitability Ratios 95 Return on equity 96 Return on assets 97 Gross profit margin 98 EBIT profit margin 99 Cash flow to sales ratio 100 101 Efficiency Ratios 102 Asset turnover 103 Days inventory turnover 104 Days sales turnover 105 Days payables turnover 106 107 Liquidity Ratios 108 Current ratio 109 Quick ratio 110 Cash flow ratio 111 112 Capital Structure Ratios 113 Debt Ratio 91 92 RATIOS 93 94 Profitability Ratios 95 Return on equity 96 Return on assets 97 Gross profit margin 98 EBIT profit margin 99 Cash flow to sales ratio 100 101 Efficiency Ratios 102 Asset turnover 103 Days inventory turnover 104 Days sales turnover 105 Days payables turnover 106 107 Liquidity Ratios 108 Current ratio 109 Quick ratio 110 Cash flow ratio 111 112 Capital Structur 113 Debt Ratio 114 Interest Coverage Ratio 115 Average interest rate 116 Debt coverage ratio 117 118 Market Performance Ratios 119 Net tangible asset backing 120 Earnings per share 121 Dividends per share 122 Dividend payout ratio 123 Price /earnings ratio 124 opening Year 5 58,795 (38,638) 20,157 1,566 (9,184) (3,869) (1,836) (3,638) (956) 2,240 (649) 1,591 Year 4 63,672 (40,950) 22,722 2,289 (6,819) (4,151) (1,806) 6,026 (840) 17,421 (5,005) 12,416 Year 3 59,870 (37,867) 22,003 1,016 (9,837) (3,107) Year 2 63,245 (43,254) 19,991 1,990 (10,290) (4,364) (1,417) 3,674 (905) 8,679 (2,711) 5,968 Year 1 61,548 (42,043) 19,505 2,218 (6,973) (3,804) (1,137) 794 (1,736) 8,867 (2,799) 6,068 (1,820) 4,046 (1,673) 10,628 (3,071) 7,557 1 FINANCIAL STATEMENTS 2 STATEMENT OF PROFIT OR LOSS 3 Sales revenue 4 Cost of sales 5 Gross profit 6 Other revenue 7 Selling and administration expenses 8 Other expenses 9 Depreciation, amortisation & impairment 10 net gains (losses) on non-current assets 11 Finance costs 12 Profit before tax 13 Income tax (expense)/benefit 14 Net profit 15 16 17 BALANCE SHEET 18 Current Assets 19 Cash and cash equivalents 20 Trade and other receivables 21 Inventories 22 Other current assets 23 Total Current Assets 24 25 Non-Current Assets 26 Property, plant and equipment 27 Investments 28 Intangible assets 29 Total Non-Current Assets 30 TOTAL ASSETS 31 32 Current Liabilities 33 Trade and other payables 34 Interest-bearing loans and borrowings 35 Provisions 36 Unearned revenue 37 Current tax payable/(refundable) 38 Total Current Liabilities 39 Non-Current Liabilities 40 Interest-bearing loans and borrowings 41 Provisions 12,036 4,498 4,463 5,139 26,136 12,258 5,851 3,535 6,679 28,323 17,124 4,945 3,394 5,370 30,833 14,565 6,154 3,140 5,964 29,823 22,125 4,001 4,113 6,303 36,542 30,970 5,200 5,600 650 42,420 16,480 638 19,554 463 9,137 20,178 648 10,525 31,351 59,674 7,166 15,280 414 10,132 25,826 55,649 16,329 603 6,863 23,795 60,337 16,575 497 6,988 24,060 66,480 26,255 52,391 27,183 58,016 5,244 1,364 2,278 2,787 146 11,819 5,347 1,375 2,091 1,840 784 11,437 5,904 1,022 2,377 826 515 10,644 5,672 823 2,500 2,030 542 11,567 4,893 2,291 2,068 49 523 9,824 6,759 3,107 2,470 1,625 1,962 15,923 9,666 437 12,625 918 17,900 767 15,433 794 21,821 573 21,750 748 Year 5 Year 4 Year 3 Year 2 Year 1 opening 21,750 748 9,666 437 10,103 21,922 12,625 918 13,543 24,980 17,900 767 18,667 29,311 15,433 794 16,227 27,794 21,821 573 22,394 32,218 22,498 38,421 30,469 34,694 28,705 27,855 28,119 28,059 2,944 651 26,874 30,469 2,878 630 31,186 34,694 3,426 542 24,738 28,705 4,348 485 23,022 27,855 4,880 387 22,852 28,119 5,170 355 22,534 28,059 1 FINANCIAL STATEMENTS 2 STATEMENT OF PROFIT OR LOSS 39 Non-Current Liabilities 40 Interest-bearing loans and borrowings 41 Provisions 42 Total Non-Current Liabilities 43 TOTAL LIABILITIES 44 45 NET ASSETS 46 47 EQUITY 48 Contributed equity 49 Reserves 50 Retained earnings 51 Total equity 52 53 54 STATEMENT OF CASH FLOWS 55 Cash flows relating to operating activities 56 Receipts from customers for Service 57 Receipts from customers for Product 58 Receipts - other revenue 59 Payments to suppliers and employees 60 Interest received 61 Dividends received 62 Interest paid 63 Income tax paid 64 Net cash flows from operating activities 65 66 Cash flows relating to investing activities 67 Payments for property, plant & equipment 68 Proceeds from disposal of property, plant & equipment 69 Payments for investments 70 Proceeds from disposal of investments 71 Payments for intangible assets 72 Proceeds from disposal of intangible assets 73 Net cash flows from investing activities 74 75 Cash flows relating to financing activities 76 Proceeds from borrowings 77 Repayment of borrowings 13,552 47,543 1,223 (51,476) 157 343 (1,113) (1,287) 8,942 14,800 48,980 1,783 (54,062) 242 506 (1,082) (4,736) 6,431 15,863 44,012 796 (50,389) 85 220 (1,758) (3,098) 5,731 15,595 47,478 1,651 (55,164) 170 339 (1,075) (2,692) 6,302 15,001 46,170 1,711 (59,429) 199 507 (1,935) (4,238) (2,014) 14,175 47,250 1,300 (51,773) 163 325 (2,649) (7,848) 943 (928) 399 (21) 25 (492) 639 (378) (1,227) 1,513 (13) 60 (696) 415 52 (1,058) 1,470 (41) 21 (58) 535 869 (761) 700 (10) 22 (160) 435 226 (854) 926 (55) 34 (509) 380 (78) (829) 829 (25) 25 (349) 349 0 24,857 2,494 (5,464) 2,257 (7,179) 5,520 (2,854) 353 (8,209) 3,168 (3,913) 0 Year 5 Year 4 Year 3 Year 2 Year 1 opening 2,494 (5,464) 66 (5,882) (8,786) 2,257 (7,179) (548) (5,879) (11,349) 5,520 (2,854) (923) (5,784) (4,041) 353 (8,209) (532) (5,700) (14,087) 3,168 (3,913) (290) (5,718) (6,753) 24,857 0 5,170 0 30,027 1 FINANCIAL STATEMENTS 2 STATEMENT OF PROFIT OR LOSS 75 Cash flows relating to financing activities 76 Proceeds from borrowings 77 Repayment of borrowings 78 Net proceeds from issue of shares & buy-backs 79 Dividends paid 80 Net cash flows used in/ (from) financing activities 81 82 Net decrease in cash and cash equivalents 83 Cash and cash equivalents at beginning of year 84 CASH AND CASH EQUIVALENTS AT END OF YEAR 85 86 87 ADDITIONAL DATA 88 Number of shares outstanding 89 Market share price 90 (222) 12,258 12,036 (4,866) 17,124 12,258 2,559 14,565 17,124 (7,559) 22,125 14,565 (8,845) 30,970 22,125 30,970 0 30,970 2,461 65.99 2,460 45.63 2,472 54.28 2,489 66.46 2.497 96.77 2,500 114.45 91 92 RATIOS 93 94 Profitability Ratios 95 Return on equity 96 Return on assets 97 Gross profit margin 98 EBIT profit margin 99 Cash flow to sales ratio 100 101 Efficiency Ratios 102 Asset turnover 103 Days inventory turnover 104 Days sales turnover 105 Days payables turnover 106 107 Liquidity Ratios 108 Current ratio 109 Quick ratio 110 Cash flow ratio 111 112 Capital Structure Ratios 113 Debt Ratio 91 92 RATIOS 93 94 Profitability Ratios 95 Return on equity 96 Return on assets 97 Gross profit margin 98 EBIT profit margin 99 Cash flow to sales ratio 100 101 Efficiency Ratios 102 Asset turnover 103 Days inventory turnover 104 Days sales turnover 105 Days payables turnover 106 107 Liquidity Ratios 108 Current ratio 109 Quick ratio 110 Cash flow ratio 111 112 Capital Structur 113 Debt Ratio 114 Interest Coverage Ratio 115 Average interest rate 116 Debt coverage ratio 117 118 Market Performance Ratios 119 Net tangible asset backing 120 Earnings per share 121 Dividends per share 122 Dividend payout ratio 123 Price /earnings ratio 124 opening Year 5 58,795 (38,638) 20,157 1,566 (9,184) (3,869) (1,836) (3,638) (956) 2,240 (649) 1,591 Year 4 63,672 (40,950) 22,722 2,289 (6,819) (4,151) (1,806) 6,026 (840) 17,421 (5,005) 12,416 Year 3 59,870 (37,867) 22,003 1,016 (9,837) (3,107) Year 2 63,245 (43,254) 19,991 1,990 (10,290) (4,364) (1,417) 3,674 (905) 8,679 (2,711) 5,968 Year 1 61,548 (42,043) 19,505 2,218 (6,973) (3,804) (1,137) 794 (1,736) 8,867 (2,799) 6,068 (1,820) 4,046 (1,673) 10,628 (3,071) 7,557 1 FINANCIAL STATEMENTS 2 STATEMENT OF PROFIT OR LOSS 3 Sales revenue 4 Cost of sales 5 Gross profit 6 Other revenue 7 Selling and administration expenses 8 Other expenses 9 Depreciation, amortisation & impairment 10 net gains (losses) on non-current assets 11 Finance costs 12 Profit before tax 13 Income tax (expense)/benefit 14 Net profit 15 16 17 BALANCE SHEET 18 Current Assets 19 Cash and cash equivalents 20 Trade and other receivables 21 Inventories 22 Other current assets 23 Total Current Assets 24 25 Non-Current Assets 26 Property, plant and equipment 27 Investments 28 Intangible assets 29 Total Non-Current Assets 30 TOTAL ASSETS 31 32 Current Liabilities 33 Trade and other payables 34 Interest-bearing loans and borrowings 35 Provisions 36 Unearned revenue 37 Current tax payable/(refundable) 38 Total Current Liabilities 39 Non-Current Liabilities 40 Interest-bearing loans and borrowings 41 Provisions 12,036 4,498 4,463 5,139 26,136 12,258 5,851 3,535 6,679 28,323 17,124 4,945 3,394 5,370 30,833 14,565 6,154 3,140 5,964 29,823 22,125 4,001 4,113 6,303 36,542 30,970 5,200 5,600 650 42,420 16,480 638 19,554 463 9,137 20,178 648 10,525 31,351 59,674 7,166 15,280 414 10,132 25,826 55,649 16,329 603 6,863 23,795 60,337 16,575 497 6,988 24,060 66,480 26,255 52,391 27,183 58,016 5,244 1,364 2,278 2,787 146 11,819 5,347 1,375 2,091 1,840 784 11,437 5,904 1,022 2,377 826 515 10,644 5,672 823 2,500 2,030 542 11,567 4,893 2,291 2,068 49 523 9,824 6,759 3,107 2,470 1,625 1,962 15,923 9,666 437 12,625 918 17,900 767 15,433 794 21,821 573 21,750 748 Year 5 Year 4 Year 3 Year 2 Year 1 opening 21,750 748 9,666 437 10,103 21,922 12,625 918 13,543 24,980 17,900 767 18,667 29,311 15,433 794 16,227 27,794 21,821 573 22,394 32,218 22,498 38,421 30,469 34,694 28,705 27,855 28,119 28,059 2,944 651 26,874 30,469 2,878 630 31,186 34,694 3,426 542 24,738 28,705 4,348 485 23,022 27,855 4,880 387 22,852 28,119 5,170 355 22,534 28,059 1 FINANCIAL STATEMENTS 2 STATEMENT OF PROFIT OR LOSS 39 Non-Current Liabilities 40 Interest-bearing loans and borrowings 41 Provisions 42 Total Non-Current Liabilities 43 TOTAL LIABILITIES 44 45 NET ASSETS 46 47 EQUITY 48 Contributed equity 49 Reserves 50 Retained earnings 51 Total equity 52 53 54 STATEMENT OF CASH FLOWS 55 Cash flows relating to operating activities 56 Receipts from customers for Service 57 Receipts from customers for Product 58 Receipts - other revenue 59 Payments to suppliers and employees 60 Interest received 61 Dividends received 62 Interest paid 63 Income tax paid 64 Net cash flows from operating activities 65 66 Cash flows relating to investing activities 67 Payments for property, plant & equipment 68 Proceeds from disposal of property, plant & equipment 69 Payments for investments 70 Proceeds from disposal of investments 71 Payments for intangible assets 72 Proceeds from disposal of intangible assets 73 Net cash flows from investing activities 74 75 Cash flows relating to financing activities 76 Proceeds from borrowings 77 Repayment of borrowings 13,552 47,543 1,223 (51,476) 157 343 (1,113) (1,287) 8,942 14,800 48,980 1,783 (54,062) 242 506 (1,082) (4,736) 6,431 15,863 44,012 796 (50,389) 85 220 (1,758) (3,098) 5,731 15,595 47,478 1,651 (55,164) 170 339 (1,075) (2,692) 6,302 15,001 46,170 1,711 (59,429) 199 507 (1,935) (4,238) (2,014) 14,175 47,250 1,300 (51,773) 163 325 (2,649) (7,848) 943 (928) 399 (21) 25 (492) 639 (378) (1,227) 1,513 (13) 60 (696) 415 52 (1,058) 1,470 (41) 21 (58) 535 869 (761) 700 (10) 22 (160) 435 226 (854) 926 (55) 34 (509) 380 (78) (829) 829 (25) 25 (349) 349 0 24,857 2,494 (5,464) 2,257 (7,179) 5,520 (2,854) 353 (8,209) 3,168 (3,913) 0
