Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fill in the ratio section opening FINANCIAL STATEMENTS STATEMENT OF PROFIT OR LOSS Sales revenue Cost of sales Gross profit Other revenue Selling and administration
Fill in the ratio section
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 (expensel/benefit Net profit Year 5 61,430 (42,974) 18,456 1,645 (7,851) (2,027) (1,402) (5,544) (1,779) 1.498 (471) 1,027 Year 4 67,120 (43,001) 24,119 1,345 (12,525) (4,041) (1,828) 3,472 (1,524) 9,018 (2,656) 6,362 Year 3 67,663 (46,467) 21,196 2,338 (10,041) (4,351) (1,625) (926) (2.368) 4.223 (1,261) 2,962 Year 2 66,681 (45,325) 21,356 2,255 (11,582) (3,761) (1,738) (1,177) (1,890) 3,463 (1,050) 2,413 Year 1 68,162 (45,856) 22.306 1,572 (7,348) (2,331) (1.398) 6,949 (1,265) 18,485 (5,494) 12.991 BALANCE SHEET Current Assets Cash and oash equivalents Trade and other receivables Inventories Other current assets Total Current Assets 19,393 4,988 5,382 6,622 36,385 19,648 4,698 3,047 7,430 34,823 20,634 5,941 2,862 7,084 36,521 27,291 4,241 3,932 5,848 41,312 21,900 5,187 4,182 7,102 38,371 29,976 5,200 5,600 650 41,426 Non-Current Assets Property, plant and equipment Investments Intangible assets Total Non-Current Assets TOTAL ASSETS 12,495 461 8,606 21,562 57,947 18,988 473 9,565 29,026 63,849 17,119 659 9,446 27,224 63,745 17,577 417 11,002 28,996 70,308 20,626 728 9,168 30,522 68,893 16,575 497 6,988 24,060 65,486 Current Liabilities Trade and other payables Interest-bearing loans and borrowings Provisions Unearned revenue Current tax payablellrefundable) Total Current Liabilities Non-Current Liabilities Interest-bearing loans and borrowings Provisions Total Non-Current Liabilities TOTAL LIABILITIES 5,537 4,954 2,171 12 84 12,758 5,608 3,260 2,845 2,752 446 14.911 6,615 1,909 2,558 907 204 12,193 5,621 2,650 2,724 1,807 5,918 3,325 2,245 164 934 12.586 6,759 3,107 2,470 1,625 1,962 15,923 218 13,020 19,889 842 20,731 33,489 18,950 723 19,673 34,584 22,475 1,064 23,539 35,732 24,895 1,059 25,954 38,974 21,729 715 22.444 35,030 21,750 748 22,498 38,421 NET ASSETS 24,458 29,265 28,013 31,334 33,863 27,065 4,176 EQUITY Contributed equity Reserves Retained earnings Total equity 4,494 500 19,464 24,458 4,580 494 24, 191 29,265 3,938 483 23,592 28,013 4,498 458 26,378 31,334 3,699 443 29,721 33,863 355 22,534 27,065 STATEMENT OF CASH FLOWS Cash flows relating to operating activities Receipts from customers for Service Receipts from oustomers 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 9,856 48,544 1,333 (55,005) 165 312 (1,944) (833) 2,428 10,683 59,525 1,054 (61,159) 115 291 (1,639) (2,414) 6,456 11,525 53,538 1,807 (60,192) 229 531 (2,597) (1.275) 3,566 12,202 57,068 1,874 (58,638) 247 381 (2,137) (1,766) 9,231 12,843 53,871 1,247 (61,668) 135 325 (1,400) (6,522) (1,169) 14,175 47,250 1,300 (51,773) 163 325 (2,649) (7,848) 943 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 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 (316) 893 (7) 33 (88) 3 518 (281) 123 (42) 10 (149) 181 (158) (1,673) 803 (9) 47 (781) 834 (779) (1,575) 244 (17) 11 (129) 77 (1,389) (1.759) 1,380 (47) 18 (657) 154 (911) (829) 829 (25) 25 (349) 349 0 7,017 (4,384) (87) (5,748) (3,201) 239 (2,413) 643 (5,752) (7,284) 5,397 (8,558) (561) (5,723) (9,444) 5,988 (3,497) 799 (5,741) (2,451) 5,451 (5,254) (477) (5,716) (5,996) 24,857 0 4,176 0 29,033 Net decrease in cash and cash equivalents Cash and cash equivalents at beginning of year CASH AND CASH EQUIVALENTS AT END OF YEAR (255) 19,648 19,393 (986) 20,634 19,648 (6,657) 27,291 20,634 5,391 21,900 27,291 (8,076) 29,976 21,900 29,976 0 29,976 ADDITIONAL DATA Number of shares outstanding Market share price 2,510 43.27 2,512 49.44 2,499 70.09 2,507 72.65 2,496 119.19 2,500 114.45 RATIOS Profitability Ratios Return on equity Return on assets Gross profit margin EBIT profit margin Cash flow to sales ratio Efficiency Ratios Asset turnover Days inventory turnover Days sales turnover Days payables turnover 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 learnings ratio 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 (expensel/benefit Net profit Year 5 61,430 (42,974) 18,456 1,645 (7,851) (2,027) (1,402) (5,544) (1,779) 1.498 (471) 1,027 Year 4 67,120 (43,001) 24,119 1,345 (12,525) (4,041) (1,828) 3,472 (1,524) 9,018 (2,656) 6,362 Year 3 67,663 (46,467) 21,196 2,338 (10,041) (4,351) (1,625) (926) (2.368) 4.223 (1,261) 2,962 Year 2 66,681 (45,325) 21,356 2,255 (11,582) (3,761) (1,738) (1,177) (1,890) 3,463 (1,050) 2,413 Year 1 68,162 (45,856) 22.306 1,572 (7,348) (2,331) (1.398) 6,949 (1,265) 18,485 (5,494) 12.991 BALANCE SHEET Current Assets Cash and oash equivalents Trade and other receivables Inventories Other current assets Total Current Assets 19,393 4,988 5,382 6,622 36,385 19,648 4,698 3,047 7,430 34,823 20,634 5,941 2,862 7,084 36,521 27,291 4,241 3,932 5,848 41,312 21,900 5,187 4,182 7,102 38,371 29,976 5,200 5,600 650 41,426 Non-Current Assets Property, plant and equipment Investments Intangible assets Total Non-Current Assets TOTAL ASSETS 12,495 461 8,606 21,562 57,947 18,988 473 9,565 29,026 63,849 17,119 659 9,446 27,224 63,745 17,577 417 11,002 28,996 70,308 20,626 728 9,168 30,522 68,893 16,575 497 6,988 24,060 65,486 Current Liabilities Trade and other payables Interest-bearing loans and borrowings Provisions Unearned revenue Current tax payablellrefundable) Total Current Liabilities Non-Current Liabilities Interest-bearing loans and borrowings Provisions Total Non-Current Liabilities TOTAL LIABILITIES 5,537 4,954 2,171 12 84 12,758 5,608 3,260 2,845 2,752 446 14.911 6,615 1,909 2,558 907 204 12,193 5,621 2,650 2,724 1,807 5,918 3,325 2,245 164 934 12.586 6,759 3,107 2,470 1,625 1,962 15,923 218 13,020 19,889 842 20,731 33,489 18,950 723 19,673 34,584 22,475 1,064 23,539 35,732 24,895 1,059 25,954 38,974 21,729 715 22.444 35,030 21,750 748 22,498 38,421 NET ASSETS 24,458 29,265 28,013 31,334 33,863 27,065 4,176 EQUITY Contributed equity Reserves Retained earnings Total equity 4,494 500 19,464 24,458 4,580 494 24, 191 29,265 3,938 483 23,592 28,013 4,498 458 26,378 31,334 3,699 443 29,721 33,863 355 22,534 27,065 STATEMENT OF CASH FLOWS Cash flows relating to operating activities Receipts from customers for Service Receipts from oustomers 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 9,856 48,544 1,333 (55,005) 165 312 (1,944) (833) 2,428 10,683 59,525 1,054 (61,159) 115 291 (1,639) (2,414) 6,456 11,525 53,538 1,807 (60,192) 229 531 (2,597) (1.275) 3,566 12,202 57,068 1,874 (58,638) 247 381 (2,137) (1,766) 9,231 12,843 53,871 1,247 (61,668) 135 325 (1,400) (6,522) (1,169) 14,175 47,250 1,300 (51,773) 163 325 (2,649) (7,848) 943 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 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 (316) 893 (7) 33 (88) 3 518 (281) 123 (42) 10 (149) 181 (158) (1,673) 803 (9) 47 (781) 834 (779) (1,575) 244 (17) 11 (129) 77 (1,389) (1.759) 1,380 (47) 18 (657) 154 (911) (829) 829 (25) 25 (349) 349 0 7,017 (4,384) (87) (5,748) (3,201) 239 (2,413) 643 (5,752) (7,284) 5,397 (8,558) (561) (5,723) (9,444) 5,988 (3,497) 799 (5,741) (2,451) 5,451 (5,254) (477) (5,716) (5,996) 24,857 0 4,176 0 29,033 Net decrease in cash and cash equivalents Cash and cash equivalents at beginning of year CASH AND CASH EQUIVALENTS AT END OF YEAR (255) 19,648 19,393 (986) 20,634 19,648 (6,657) 27,291 20,634 5,391 21,900 27,291 (8,076) 29,976 21,900 29,976 0 29,976 ADDITIONAL DATA Number of shares outstanding Market share price 2,510 43.27 2,512 49.44 2,499 70.09 2,507 72.65 2,496 119.19 2,500 114.45 RATIOS Profitability Ratios Return on equity Return on assets Gross profit margin EBIT profit margin Cash flow to sales ratio Efficiency Ratios Asset turnover Days inventory turnover Days sales turnover Days payables turnover 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 learnings ratioStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started