Calculate the following five ratios for each of the two years:(i) Return on capital employed(ii) Net profit margin(iii) Current ratio(iv) Average Receivable days/ Debtors collection period(v) Average Payable days/ Creditors collection period As at year to 31 Dec.2018As at year to 31 Dec.2019Statement of financial position£000£000£000£000Non-current assets2,9556,000Current assets7501200450InventoryReceivables - trade900PrepaymentsCash901052,0708,070751,515154,470Issued share capitalShare premium accountRetained earnings9009003003001,6502,8501,1252,325on-current liabilities10% loan notesCurrent liabilities1,5003,000Payables – tradeAccruals2,100120570756452,2204,4708,07011:32re to search4) ENG28/04/202 A Read aloudV DrawD HighlightErase(D Page viewFor the year ended31 Dec. 2018For the year ended31 Dec. 2019£000£000£000£000Sales revenue4,8006,000Cost of sales450Opening inventoryPurchases1,2002,7004,8005,250(900)3,900(4,350)Less: Closing inventoryGross profitOperating expensesFinance cost(450)(3,450)1,350(600)(150)1,650(675)(300)Net profit600675As at year to 31 Dec.2018As at year to 31 Dec.2019Statement of financial position£0006,000£000£000£000Non-current assets2,955Current assets450InventoryReceivables – trade900907501200105PrepaymentsCash1,5154,4702,0708,0707515Issued share capitalShare premium account90090030030011:28/04nere to searchN) ENG

Hi student Since there are multiple subparts, we will answer only first three subparts. If you want…

Answered: Calculate the following five ratios for…

Calculate the following five ratios for each of the two years: (i) Return on capital employed (ii) Net profit margin (iii) Current ratio

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The following schedule of assets and liabilities relates to Kona Enterprises. Their year-end is 28 February. Income received in advance Input VAT Output VAT Prepaid expenses Accumulated depreciation: Equipment Equipment Fixed deposit (maturing on 31 May 2023) Savings account Bank overdraft Accrued expenses Accrued income Trade receivables Trading inventory Land and Buildings Mortgage loan: Vida Bank Trade payables 2022 2 000 3 000 6 500 7500 30 000 90 000 40 000 13 500 0 16 000 9 500 34 000 105 000 950 000 450 000 150 000 2023 Calculate the level of working capital (total current assets) as at the financial years ended 28 February 2022 and 28 February 2023. Calculate the total for current liabilities as at the financial year ending 28 February 2022 and 2023. 1000 3 500 11 500 5 000 35 000 100 000 40 000 18 500 4 500 10 500 12 000 41 500 115 000 950 000 380 000 170 000
Ratio Analysis Presented below are summary financial data from Porter's annual report: Amounts in millions Balance Sheet Cash and Cash Equivalents Marketable Securities Accounts Receivable (net) Total Current Assets Total Assets Current Liabilities Long-Term Debt- Shareholders' Equity Income Statement Interest Expense Net Income Before Taxes b. Quick ratio $1,850 19,100 9,367 39,088 123,078 38,450 7,279 68,278 Calculate the following ratios: (Round to 2 decimal points) a. Times-interest-earned ratio c. Current ratio 400 14,007
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash Marketable securities Accounts and notes receivable (net) Inventories Prepaid expenses Total current assets Current liabilities: Accounts and notes payable (short-term) Accrued liabilities Total current liabilities a. Determine for each year (1) the working Current Year 1. Working capital 2. Current ratio 3. Quick ratio b. The liquidity of Nilo has current assets relative to current liabilities. $690,500 799,500 327,000 1,042,800 537,200. $3,397,000 $458,200 $579,600 652,100 217,300 673,400 430,600 $2,553,000 $483,000 331,800 207,000 $790,000 $690,000 capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place. Previous Year from the preceding year to the current year. The working capital, current ratio, and quick ratio have all . Most of these changes are the result of an in
2) Ratios Based on the information given in picture #1, complete the following ratios for the last TWO years and indicate whether the trend is favorable or unfavorable. Note percentages and times should be to one decimal place (e.g. 14.8%; 5.8x) Profitability Ratios Current Yr. Prior Yr. Fav/Unfav. Gross Margin (%) {Gross Income/Sales Revenue} Profit Margin (%) {Net income/ Sales Revenue} Return on Assets (%) {Net Income/ Average Total Assets}
2) Ratios Based on the information given in picture #1, complete the following ratios for the last TWO years and indicate whether the trend is favorable or unfavorable. Note percentages and times should be to one decimal place (e.g. 14.8%; 5.8x) Liq./Solv. Ratios Current Yr. Prior Yr. Fav/Unfav. Current Ratio (X) {Total. Current Assets/ Total Current Liabilities} Quick Ratio (X) {Cash + Short term Investments + Current Receivables/ Current Liabilities} Day's Sales Uncollected (days) {Total Accounts Receivables / Sales x 365}
Required: Compute the following ratios for 2020: 1. Current Ratio 2. Quick Ratio 3. Receivable Turnover 4. Average Collection Period 5. Inventory Turnover 6. Average Sales Period 7. Working Capital 8. Debt Ratio 9. Equity Ratio 10. Debt to Equity Ratio 11. Time Interest Earned 12. Gross Profit Ratio 13. Operating Profit Margin 14. Net Profit Margin 15. Return on Assets
5 )
Indicate the effect of the transactions listed in the following table on total current assets, current ration, and net income. Use (+) to indicate an increase, (-) to indicate a decrease, and (0) to indicate either no effect or an indeterminate effect. Be prepared to state any necessary assumptions and assume an initial current ratio of more than 1.0. Federal income tax due for the previous year is paid.
The image uploaded is the calculation of Access Bank's Profitability ratios, shorter liquidity ratios, long-term liquidity ratios, and investment ratios for 2020, 2021, 2022. A base year of 2019 was also added. Evaluate the financial performance by comparing the three (3) years' financial performance that is 2020, 2021, and 2022 I have provided in the table with the base year.
Examine the selected data over the 5-year period as shown in the table below for Dumbledore Ltd. Item Sales Cost of sales EBIT Interest NPAT Current assets Total assets current liabilities Total liabilities Equity Gross margin Interest coverage Current ratio 2021 $m 286.41 180.03 51.18 37.07 35.13 43.85 226.18 55.99 98.99 127.19 0.37 1.38 0.78 Year 2020 $m 280.80 166.69 51.08 33.70 35.10 43.20 221.75 53.58 91.66 130.09 0.41 1.52 0.81 2019 $m 275.29 154.35 50.98 30.64 35.06 42.56 217.40 51.27 84.87 132.53 0.44 1.66 0.89 2018 $m 269.89 142.91 50.88 27.85 35.03 41.93 213.13 49.06 78.58 134.56 0.47 1.83 U.OJ 2017 $m 264.60 134.19 49.88 25.32 34.51 41.31 206.93 47.40 74.48 132.44 0.49 1.97 0.87 2016 $m 252.00 126.00 48.90 24.00 34.00 40.70 200.90 45.80 70.60 130.30 0.50 2.04 0.89
How do I make a tabular format, to provide the revenues, gross profit, income from operations, net income, and earnings per share for the most recent three fiscal years. For the two most recent fiscal years, compute and indicate the annual percentage growth (or decline) in each of these numbers?
Please do not give image format and explanation