Question

CHAPTER 8 QUESTION Use the data provided to answer the questions that follow relating to Newtech...

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.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
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.
Add a comment
Know the answer?
Add Answer to:
CHAPTER 8 QUESTION Use the data provided to answer the questions that follow relating to Newtech...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • VillaMaria Ltd provides you the following information that has been extracted from the financial statements. Cash...

    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...

    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...

    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...

    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...

    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...

    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...

    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; co...

    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...

    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. Comp...

    (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,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT