CHAPTER 8 QUESTION
Use the data provided to answer the questions that follow relating to Newtech Ltd for 2017:
Statement of Financial Position:
Assets 2017 2016
Non-Current/Fixed 4 200 000 3 000 000
Inventory 400 000 600 000
Receivables 1 550 000 1 200 000
Cash 600 000 300 000
6 750 000 5 100 000
Equity and Liabilities
Share Capital (R2 shares) 4 200 000 4 000 000
Retained Income 600 000 300 000
Long term Debt 250 000 200 000
Payables 1 700 000 600 000
6 750 000 5 100 000
The Statement of Comprehensive Income for the year ended 2017:
Sales (10% on credit) 10 200 000
Cost of sales (80% on credit) 4 080 000
Expenses 3 200 000
Net Income after Tax 2 000 000
Dividends 1 700 000
Retained Income 3 000 000
NB: Shares are currently trading at R2, 80 per share.
Required:
1.1. Calculate the net profit on turnover for 2015. (2)
1.2. Calculate the current ratio for both years. (4)
1.3. Calculate the acid test ratio for both years. (4)
1.4. Accounts Payable Turnover
1.4.1. Calculate the accounts payable period (in days), noting that Newtech Ltd has, after tough negotiations secured a 90 day account with all its creditors.
Note: Use average accounts payable for this calculation. (4)
1.4.2. Offer constructive advice to Newtech Traders as to whether this is an ideal situation. (3)
1.5. Calculate the return on equity. Explain if the shareholders will be satisfied with the return. (4)
1.6. Calculate the inventory turnover ratio (use average inventory) and explain the significance of this ratio.
2017 | 2016 | ||
1.1) | Net profit on turnover = 2000000/10200000 = | 19.61% | |
1.2) | Current Ratio: | ||
= (400000+1550000+600000)/1700000 = | 1.50 | ||
= (600000+1200000+300000)/600000 = | 3.50 | ||
1.3) | Acid test ratio: | ||
= (1550000+600000)/1700000 = | 1.26 | ||
= (1200000+300000)/600000 = | 2.50 | ||
1.4) | Accounts payable turnover: | ||
= 4080000/((1700000+600000)/2)) = | 3.55 | ||
1.4.1) | Accounts payable period = 365/3.55 = | 103 | Days |
1.4.2) | As against the negotiated period the actual payment period is higher at 103 days | ||
which is not an ideal situation. Delaying payments past due will affect relationship | |||
with suppliers. | |||
1.5) | ROE = 2000000*((4800000+4300000)/2)) = | 43.96% | |
Yes, the shareholders should be satisfied with the return. | |||
1.6) | Inventory turnover = 4080000/((400000+600000)/2)) = | 8.16 | |
The ratio tell us how many times inventory is turned over by cost | |||
of goods sold. More the turnover more the efficiency. |
CHAPTER 8 QUESTION Use the data provided to answer the questions that follow relating to Newtech...
VillaMaria Ltd provides you the following information that has been extracted from the financial statements. Cash assets Marketable securities Receivables Inventories Prepaid expenses Property, plant and equipment Current liabilities Revenue (sales on credit) Cost of sales 2017 $33 100 107 000 72 500 182 000 4 200 300 000 178 200 950 600 570 700 2016 $35 900 100 300 73 900 166 800 6 300 258 700 160 500 902 900 532 800 Required 1) Calculate the following for...
QUESTION 3 REQUIRED Use the information provided below to prepare the Cash Flow Statement of Tempest Limited for the year ended 31 December 2019. INFORMATION TEMPEST LIMITED STATEMENT OF COMPREHENSIVE INCOME FOR THE YEAR ENDED 31 DECEMBER 2019 Sales Cost of sales Gross profit Operating expenses Selling and administrative expenses Depreciation Operating profit Interest expense Profit before tax Income tax Profit after tax 2 200 000 (1 300 000) 900 000 (570 000) (420 000) (150 000) 330 000 (90...
The income statement and additional data of Bayleaf Travel Products Pty Ltd are as follows: Income statement for the year ended 31 December 2016 Revenue: Service revenue R225 000 Dividend revenue R6 300 Total Revenues R231 300 Cost of goods sold R100 000 Salary expense R52 000 Depreciation expense R23 000 Advertising expense R2 300 Interest expense R2 400 Income tax expense R5 000 Total Expenses (R184 700) Net Profit...
Cumi Ltd. and Ciki Ltd. are both computer component manufacturers in Longford. You are provided with the following summarized information in relation to both companies. Income statements for year ended 31 March 2018 Cumi Lid. Cik Lid. AED'000 AED'000 Revenue 1.500 2000 Cost of sales 1.000 1.600 Gross profit 500 Operating expenses 150 200 Operating profit 350 200 Interest on debentures 100 50 Profit before tak 250 Tax SO Profit after tax 200 Dividends 70 Retained profits 350 30 120...
Financial statements for Askew Industries for 2021 are shown below in thousands): • 4-12 Calculating ctivity and ofitability ratios L04-10 2021 Income Statement Net sales Cost of goods sold Gross profit Operating expenses Interest expense Income tax expense Net income $9.000 (6,300) 2,700 (2,100) (200) (100) $ 300 Comparative Balance Sheets Dec. 31 2021 2020 Assets Cash Accounts receivable Inventory Property, plant, and equipment (net) $ 600 600 800 2,000 $4,000 $ 500 400 600 2,100 $3,600 Liabilities and Shareholders'...
Use the data from below. For the most recent year (2014)
calculate the following ratios.
Current ratio
Inventory turnover
Rate of return on total assets
Accounts receivable turnover (assume all sales are on
account)
Debt ratio.
Data:
Additional information:
There were no write-offs of delinquent accounts during the
year.
A building was sold during the year for $120.
P.S: Explain calculations too please!
Nroklesah Company Comparative Balance Sheets and Income Statement For the Years 2013 and 2014 BALANCE SHEETS Assets...
Make a cash flow statement using the following information
below.
2017 Income Statement Sales 989 100 479 500 Cost of goods sold Selling and administrative 218 300 Depreciation 95 500 EBIT 195 800 Interest 33 760 EBT 162 040 Taxes 84 200 Net Income 77 840 Dividends 16 800 Additions to retained earnings 61 040 Cash $ 9 500 Accounts receivable Eumeralla Ltd Balance Sheet as at 30 June 2016 $ 13 300 Accounts payable 18 900 Notes payable 13...
Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $48,900: total assets, $189.400; common stock, $90,000: and retained earnings, $22748.) CABOT CORPORATION Income Statement For Year Ended Decenber 31, 2017 ts Sales Cost of goods sold Gross profit Operating expenses Interest expense Income before taxes Income tares Net income $448, 600 297, 250 151, 350 98, 600 4, 100 48, 650 19, 598 $ 29, 052...
The income statement and balance sheet for GATA, Inc. are provided below. (Note that the reported figures are expressed in thousands of dollars). GATA, INC. Balance Sheets as of December 31, 2016 and 2017 (in 000s) 2016 2017 2016 2017 Assets Liabilities and Owners’ Equity Current assets Current liabilities Cash $ 500 $ 1,000 Accounts payable $ 500 $ 700 Accounts receivable 500 400 Notes payable 900 700 Inventory 900 600 Total $ 1,900 $ 2,000 Total $ 1,400...
(Ratio analysis) The financial statements and industry norms for Pamplin Inc. are shown in the popup window: a. Compute the ratios in the popup window,, for 2017 and 2018 to compare both against the industry norms. b. How liquid is the firm? c. Are its managers generating an adequate operating profit on the firm's assets? d. How is the firm financing its assets? e. Are its managers generating a good return on equity? Note: 15% of sales are cash sales,...