Can someone please complete the CAPITAL STRUCTURE RATIOS thx!
Year 4 opening FINANCIAL STATEMENTS STATEMENT OF PROFIT OR LOSS Sales revenue Cost of sales Gross profit Other revenue Selling and administration expenses Other expenses Depreciation, amortisation & impairment net gains (losses) on non-current assets Finance costs Profit before tax Income tax (expense)/benefit Net profit Year 5 61,704 (42,338) 19,366 810 (9,009) (2,666) (1,015) (1,579) (1,971) 60,981 (40,831) 20,150 1,499 (6,549) (2,884) (994) 4,313 (1,487) Year 3 53,844 (37,319) 16,525 1,943 (5,481) (3,570) (982) 3,306 (2,110) 9,631 (2,944) 6,687 Year 2 58,693 (39,816) 18,877 1,919 (7,243) (2,729) (871) (12,654) (1,877) (4,578) 1,315 (3,263) Year 1 60,084 (37,847) 22,237 998 (7,985) (3,617) (1,308) 4,293 (1,703) 12,915 (4,046) 8,869 3,936 14,048 (1,115) 2.821 (4,457) 9,591 22,097 BALANCE SHEET Current Assets Cash and cash equivalents Trade and other receivables Inventories Other current assets Total Current Assets 5,089 24,235 4,535 3,050 6,263 38,083 22,339 5,702 4,994 6,244 39,279 23,191 3,726 2,885 5,864 35,666 26,361 3,932 4,419 6,133 40,845 4,385 6,225 37,796 30,995 5,200 5,600 650 42,445 Non-Current Assets Property, plant and equipment Investments Intangible assets Total Non-Current Assets TOTAL ASSETS 14,747 565 3,554 18,866 56,949 12,629 256 8,025 20,910 60,189 9,821 236 7,490 17,547 53,213 11,422 383 2,852 14,657 55,502 19,371 709 7,841 27,921 65,717 16,575 497 6,988 24,060 66,505 Current Liabilities Trade and other payables Interest-bearing loans and borrowings Provisions Unearned revenue Current tax payable/refundable) Total Current Liabilities Non-Current Liabilities Interest-bearing loans and borrowings Provisions Total Non-Current Liabilities TOTAL LIABILITIES 6,507 2,778 2,315 938 221 12,759 5,128 4,427 2,006 2,476 677 14,714 4,784 2,455 1,735 269 679 4,750 1,254 2,043 1,526 (253) 9,320 5,570 2,542 2,160 1,178 693 12,143 6,759 3,107 2,470 1,625 1,962 15,923 9,922 20,277 820 21,097 33,856 18,032 425 18,457 33,171 19,387 810 20,197 23,677 508 24,185 33,505 21,412 729 22,141 34,284 21,750 748 22,498 38,421 30,119 NET ASSETS 23,093 27,018 23,094 21.997 31,433 28,084 EQUITY Contributed equity Reserves Retained earnings Total equity 4,350 728 18,014 23,093 5,278 681 21,060 27,018 5,085 551 17,458 23,094 4,949 441 16,606 21,997 5,405 454 25,574 31,433 5,195 355 22,534 28,084 STATEMENT OF CASH FLOWS 15,223 44,525 769 STATEMENT OF CASH FLOWS Cash flows relating to operating activities Receipts from customers for Service Receipts from customers for Product Receipts - other revenue Payments to suppliers and employees Interest received Dividends received Interest paid Income tax paid Net cash flows from operating activities 14,216 47,117 642 (50,005) 74 168 (2,045) (1,571) 8,596 13,421 47,791 1,201 (52,523) 175 298 (1,662) (4,459) 4,242 11,707 41,086 1,502 (44,539) 208 441 (2,318) (2,012) 6,075 13,508 46,690 1,549 (50,888) 200 370 (2,077) 369 9,721 (55,327) 90 229 (1,793) (5,315) (1,599) 14,175 47,250 1,300 (51,773) 163 325 (2,649) (7,848) 943 (881) (28) 250 Cash flows relating to investing activities Payments for property, plant & equipment Proceeds from disposal of property, plant & equipment Payments for investments Proceeds from disposal of investments Payments for intangible assets Proceeds from disposal of intangible assets Net cash flows from investing activities (910) 304 (42) 52 (110) 156 (550) (11) 9 (631) 367 (44) 716 (10) 7 (637) 239 (566) (777) 444 (32) 13 (69) 160 (261) (1,728) 451 (1) 55 (120) 467 (876) (829) 829 (25) 25 (349) 349 0 24,857 0 Cash flows relating to financing activities Proceeds from borrowings Repayment of borrowings Net proceeds from issue of shares & buy-backs Dividends paid Net cash flows used in/ (from) financing activities 2,359 (1,763) (927) (5,820) (6,151) 6,900 (6,283) 193 (5,859) (5,049) 2,843 (5,932) 135 (5,725) (8,679) 3,031 (2,054) (456) (5,718) (5,197) 4,763 (5,666) 210 (5,730) (6,423) 5,195 0 30,052 Net decrease in cash and cash equivalents Cash and cash equivalents at beginning of year CASH AND CASH EQUIVALENTS AT END OF YEAR 1,895 22,339 24,235 (851) 23,191 22,339 (3,170) 26,361 23,191 4,263 22,097 26,361 (8,898) 30,995 22,097 30,995 0 30,995 ADDITIONAL DATA Number of shares outstanding Market share price 2,487 54.55 2,504 48.25 2,500 45.11 2,497 91.14 2,502 104.91 2,500 114.45 RATIOS Profitability Ratios Return on equity Return on assets Gross profit margin EBIT profit margin Cash flow to sales ratio 11.26% 4.82% 31.36% 10.43% 13.93% 38.26% 16.93% 33.04% 25.77% 6.96% 29.66% 12.31% 30.69% 20.46% 11.28% -12.21% -5.38% 32.16% -2.65% 16.56% 29.80% 13.42% 37.01% 26.59% -2.66% Efficiency Ratios Asset turnover Days inventory turnover Days sales turnover Days payables turnover 105.35% 34.67 30.28 107.55% 17.92 27.76 44.30 99.06% 35.72 25.91 46.62 96.84% 40.35 28.05 47.30 90.88% 48.15 31.25 57.99 50.16 Liquidity Ratios Current ratio Quick ratio Cash flow ratio Capital Structure Ratios Debt Ratio Interest Coverage Ratio Average interest rate Debt coverage ratio Market Performance Ratios Net tangible asset backing Earnings per share Dividends per share Dividend payout ratio Price /earnings ratio
