Question

In: Accounting

You are required to use the following information relating to Gone Limited, and answer the questions...

You are required to use the following information relating to Gone Limited, and answer the questions below: Gone Limited Income Statement for the year to 31 March 2017 ($) 2018 ($) Sales 160,000 200,000 Cost of goods sold (96,000) (114,000) Gross profit 64,000 86,000 Operating expenses (35,000) (39,000) Net profit before tax 29,000 47,000 Gone Limited Statement of Financial Position As At 31 March Assets 2017 2018 $ $ $ $ Non Current Assets (at Net Book Value) 300,000 320,000 Current Assets Inventory 18,000 20,000 Trade Receivables 30,000 40,000 Cash at Bank 7,000 9,000 Cash in Hand 3,000 58,000 2,000 71,000 Total assets 358,000 391,000 Equity: Ordinary Share Capital 200,000 200,000 Retained earnings 123,000 323,000 146,000 346,000 Current Liabilities Trade Payables 25,000 35,000 Accrued salaries payable 10,000 35,000 10,000 45,000 Total Equity and Liabilities 358,000 391,000 (a) Calculate the following ratios for each of the 2 years:

i. Current Ratio [4 marks]

ii. Acid-Test Ratio [4 marks]

iii. Gross Profit Ratio [4 marks]

iv. Net Profit Ratio [4 marks]

(b) From the results of the ratios computed, what advice would you give to the management regarding the state of the business?

Solutions

Expert Solution

(a) Calculate the following ratios for each of the 2 years:

.

i. Current Ratio = Current assets / Current liabilities

.

For 2017 =

Current Assets= Inventory 18,000 + Trade Receivables 30,000 + Cash at Bank 7,000 + Cash in Hand 3,000 = 58000

Current liabilities = Trade Payables 25,000 + Accrued salaries payable 10,000 = 35000

Current Ratio = 58000 / 35000 = 1.66 : 1

.

For 2018=

Current Assets= 71000

Current liabilities = 45000

Current Ratio = 71000/ 45000 = 1.58 : 1

.

ii. Acid-Test Ratio ( Quick ratio ) = Quick assets / Current liabilities

.

For 2017

Quick assets = Trade Receivables 30,000 + Cash at Bank 7,000 + Cash in Hand 3,000 = 40000

Current liabilities = 35000

Acid-Test Ratio ( Quick ratio ) = 40000 / 35000 = 1.14 : 1

.

For 2018

Quick assets = Trade Receivables 40000 + Cash at Bank 9000 + Cash in Hand 2000 = 51000

Current liabilities = 45000

Acid-Test Ratio ( Quick ratio ) = 51000 / 45000 = 1.13 : 1

.

iii. Gross Profit Ratio = Gross profit / Sales

.

For 2017

Gross profit = 64000

Sales = 160000

Gross Profit Ratio = 64000 / 160000 = 0.40 or 40%

.

For 2018

Gross profit = 86000

Sales = 200000

Gross Profit Ratio = 86000 / 200000 = 0.43 or 43%

iv. Net Profit Ratio [4 marks]

.

For 2017

Net profit = 29000

Sales = 160000

Net Profit Ratio = 29000 / 160000 = 0.1813 or 18.13%

.

For 2018

Net profit = 47000

Sales = 200000

Net Profit Ratio = 47000 / 200000 = 0.235 or 23.5%

.

(b) From the results of the ratios computed, what advice would you give to the management regarding the state of the business?

> In the case of current ratio, Decreased in 2018 compared to 2017, it create a affect to business, so should improve the current ratio.

The standard ration is 2 : 1, so try to be in this ratio.

Curren5t ratio is liquidity ratio, which compute the ability of company to pay its short term obligation with in one cycle period or with in one year. Higher the liquidity ratio is better to the company.

.

> In the case of quick ratio also same as current ratio, decrease compare to 2017 ratio, but the standard ratio was 1 : 1.

.

>In the case of Gross profit ratio and net profit ratio, the ratio are improved in 2018 compare to 2017, so keep those performance.


Related Solutions

Required information Use the following information to answer questions [The following information applies to the questions...
Required information Use the following information to answer questions [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 31,000 $ 30,000 Work in process 9,500 18,200 Finished goods 54,000 34,000 Activities and information for May Raw materials purchases (paid with cash) 197,000 Factory payroll (paid with cash) 200,000 Factory overhead Indirect materials...
Use the following information to answer the questions below that are required to ultimately calculate a...
Use the following information to answer the questions below that are required to ultimately calculate a company’s WACC: - Long-term bonds: 3,500 bonds outstanding with 7.20% p.a. coupons paid semi-annually, $1000 face value, 25 years to maturity, current market yield is 5.72% p.a. - Preference shares: pay a dividend of 8% p.a. forever on a $15 face value, 45,000 outstanding, currently selling for $14.20 per share. - Ordinary shares: 175,000 shares outstanding selling for $37 per share with beta of...
Use the following information to answer the questions below that are required to ultimately calculate a...
Use the following information to answer the questions below that are required to ultimately calculate a company’s WACC: - Long-term bonds: 3,500 bonds outstanding with 7.20% p.a. coupons paid semi-annually, $1000 face value, 25 years to maturity, current market yield is 5.72% p.a. - Preference shares: pay a dividend of 8% p.a. forever on a $15 face value, 45,000 outstanding, currently selling for $14.20 per share. - Ordinary shares: 175,000 shares outstanding selling for $37 per share with beta of...
Required information [The following information applies to the questions displayed below.] The financial statements for Limited...
Required information [The following information applies to the questions displayed below.] The financial statements for Limited Brands, Inc. follow (fiscal years ending January): Limited Brands, Inc. Balance Sheets ($ Millions) 2007 2006 2005 Total Assets 7,093.000 6,346.000 6,089.000 Liabilities Long-Term Debt Due In One Year 8.000 7.000 0.000 Payables and Accrued Expenses 1,701.000 1,568.000 1,451.000 Total Current Liabilities 1,709.000 1,575.000 1,451.000 Long-Term Debt 1,665.000 1,669.000 1,646.000 Deferred Taxes 173.000 146.000 177.000 Minority Interest 71.000 33.000 33.000 Other Liabilities 520.000 452.000...
REQUIRED Use the information provided below to answer each of the following questions independently: 1.1 Calculate...
REQUIRED Use the information provided below to answer each of the following questions independently: 1.1 Calculate the break-even value using the marginal income ratio. 1.2 The sales manager proposes a R2 per unit reduction in selling price with the expectation that this would increase sales by 2 000 units. Is this a good idea? Motivate your answer. 1.3 Determine the selling price per unit if a net profit of R486 000 is desired. INFORMATION The following forecasts for January 2021...
Use the following information to answer the questions below:
Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: 2016 2017 Sales $ 975,000 $        1,072,500 less Cost of Goods Sold: 325,000 346,125 Gross Profit 650,000 726,375 Operating Expenses 575,000 609,500 Earnings before Interest & Taxes 75,000 116,875 Interest exp 25,000 31,000 earnings before Taxes 50,000 85,875 Taxes 20,000 34,350 Net Income $ 30,000 $              51,525 Balance Sheet info: 12/31/2016 12/31/2017 Cash 60,000 $ 63,600 Accounts Receivable 80,000 $ 84,000 Inventory...
Use the following information to answer questions [The following information applies to the questions displayed below.]...
Use the following information to answer questions [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 48,000 $ 48,000 Work in process 9,900 19,700 Finished goods 67,000 33,700 Activities and information for May Raw materials purchases (paid with cash) 194,000 Factory payroll (paid with cash) 150,000 Factory overhead Indirect materials 14,000 Indirect...
Use the following information to answer questions [The following information applies to the questions displayed below.]...
Use the following information to answer questions [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 44,000 $ 54,000 Work in process 9,500 18,800 Finished goods 59,000 34,000 Activities and information for May Raw materials purchases (paid with cash) 185,000 Factory payroll (paid with cash) 250,000 Factory overhead Indirect materials 10,000 Indirect...
Use the following information to answer questions 12-13 [The following information applies to the questions displayed...
Use the following information to answer questions 12-13 [The following information applies to the questions displayed below.] On May 1, Donovan Company reported the following account balances: Current assets $ 130,000 Buildings & equipment (net) 260,000 Total assets $ 390,000 Liabilities $ 98,500 Common stock 150,000 Retained earnings 141,500 Total liabilities and equities $ 390,000 On May 1, Beasley paid $465,200 in stock (fair value) for all of the assets and liabilities of Donovan, which will cease to exist as...
Use the following information to answer questions 7-11 [The following information applies to the questions displayed...
Use the following information to answer questions 7-11 [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system.    April 30 May 31   Inventories      Raw materials $ 33,000   $ 58,000      Work in process 9,600 18,200      Finished goods 59,000 33,400   Activities and information for May      Raw materials purchases (paid with cash) 174,000      Factory payroll (paid with cash) 330,000      Factory overhead         Indirect materials...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT