Question

In: Accounting

The following is the summarized financial information of Number Holding Limited for the year ended 31...

The following is the summarized financial information of Number Holding Limited for the year ended 31 December, 2017 (with comparative figures):

Statement of profit or loss for the year ended 31 December

2017

2016

$

$

Sales revenue

29,026

29,887

Cost of goods sold

(22,176)

(25,116)

Gross margin

6,850

4,771

Operating expenses

(1,176)

(1,395)

Operating profits

5,674

3,376

Finance cost

(830)

(1,278)

Profits before tax

4,844

2,098

Profits tax

(748)

(494)

Profits after tax

4,096

1,604

Statement of financial position as at 31 December

2017

2016

Non-current assets

$

$

Property, plant and equipment

48,628

43,360

Investment properties

6,516

7,560

Intangible assets

1,251

755

Current assets

56,395

51,675

Inventory

3,758

6,196

Trade receivables

3,502

3,080

Others receivables

1,905

2,535

Cash

2,912

4,031

Total assets

12,077

15,842

68,472

67,517

Current liabilities

Trade payables

3,511

7,731

Other payables

2,493

3,710

Tax payables

194

288

Short-term bank loans

3,003

5,102

9,201

16,831

Non-current liabilities

Borrowings

31,879

27,397

Owners’ equity

Ordinary shares

10,200

9,202

Other reserves

1,621

1,613

Retained profits

15,571

12,474

27,392

23,289

Total liabilities and equity

68,472

67,517

Other information:

1 Balances as of 31 December 2015:

$

Accounts receivables

6,000

Inventory

4,800

Total assets

42,930

Owners’ equity

20,350

Assume all sales and purchases are on credit terms.

Industry norms:

Current ratio

1.5

Quick ratio

1

Net profit margin

15%

Return on assets

10%

Return on shareholders’ equity

14%

Required

Calculate the following financial ratios for 2017 and 2016 (round up to two decimal places):

1. Current ratio

2. Quick ratio

3. Accounts receivable turnover (use average accounts receivable)

4. Inventory turnover (use average inventory)

5. Net profit margin

6. Return on assets (use average total assets)

7. Return on shareholders’ equity (use average shareholders’equity)

Based on the information and your calculations in (a) above, comment on the company’s liquidity and profitability.

Solutions

Expert Solution

Metric 2017 2016 Industry Comment
Current Ratio 1.31 0.94 1 The Current Ratio has increased significantly and is above industry average thereby suggesting that the company's liquidity is good
Quick Ratio 1.10 0.57 1 The Quick Ratio has increased significantly and is above industry average thereby suggesting that the company's liquidity is good
Net Profit Margin 14.11% 5.30% 15% Though the Net Profit margin increased dramatically, it is below the industrial average and there is scope for improvement of profitability of the firm
Accounts Receivable Turoner 8.82 times 6.58 times -- No Comments
Inventory Turnover 4.46 times 4.57 times -- No Comments
Return on Assets 6% 2.9% 10% Though there is significant increase in the metric, the Return on Assets is far below the industrial average suggesting there is scope for more efficient use of assets of the company
Return on Shareholders' Equity 16% 7.35% 14% There is increase in ROSE and it is higher than the industrial average suggesting that the company is adding better value to the shareholders when compared to the industry as a whole.


Related Solutions

The Statements of Financial Position of Dream Limited for the year ended 31 December 2015 are...
The Statements of Financial Position of Dream Limited for the year ended 31 December 2015 are provided below: Dream Limited Statement of Financial Position as at 31 December: 2015 2014 $’000 $’000 Assets: Land 350 200 PPE 950 510 Accumulated depreciation (380) (240) 570 270 Cash at bank 20 - Inventories 110 200 Accounts receivable 200 180 Total 1,250 850 Liabilities: Accounts payable 160 210 Bank overdraft 0 20 Salary payable 40 20 Tax payable 80 60 Dividends Payable 50...
The draft financial statements of Socket Limited for the year ended 31 December 2017 are as...
The draft financial statements of Socket Limited for the year ended 31 December 2017 are as below: Statement of profit or loss and other comprehensive income for the year ended 31 December 2017 ? ? ? ? $m Revenue ? ? ? ? 168,300 Cost of sales ? ? ? ? -115,850 Gross profits ? ? ? ? 52,450 Administration expense ? ? ? ? -2,750 Distribution expense ? ? ? ? -1,200 Profits before tax ? ? ? ?...
The summarized financial statements of Indira, a limited liability company, at 31 October 2012 and 31...
The summarized financial statements of Indira, a limited liability company, at 31 October 2012 and 31 October 2013 are given below: Balance sheet Notes 2012 2013 GHS GHS GHS GHS Non-current assets(net book value) 1,2,3 1,000,000 1,800,000 Current Assets Inventories 600,000 1,600,000 receivables 1,270,000 1,800,000 cash 140,000 2,010,000 3,400,000 3,010,000 5,200,000 Capital and reserve Ordinary share capital 4 500,000 600,000 Share premium account 4 420,000 820,000 Revaluation reserve 5 300,000 Accumulated profits 920,000 1,340,000 1,080,000 2,200,000 1,840,000 2,800,000 Current Liabilities...
The draft financial statements of Pedro, a limited liability company, for the year ended 31 December...
The draft financial statements of Pedro, a limited liability company, for the year ended 31 December 2019 are currently under review. The following points have been raised: An ex-employee has started an action against Pedro for wrongful dismissal. The company’s legal team have stated that the ex-employee is likely to succeed. The following estimates have been given by the lawyers relating to the case:           a) Legal costs (to be incurred whether the claim is successful or not) $10,000          ...
The draft financial statements of Pedro, a limited liability company, for the year ended 31 December...
The draft financial statements of Pedro, a limited liability company, for the year ended 31 December 2019 are currently under review. The following points have been raised: An ex-employee has started an action against Pedro for wrongful dismissal. The company’s legal team have stated that the ex-employee is likely to succeed. The following estimates have been given by the lawyers relating to the case:           a) Legal costs (to be incurred whether the claim is successful or not) $10,000          ...
The financial statements of Pouchie Co. included the following information for the year ended December 31,...
The financial statements of Pouchie Co. included the following information for the year ended December 31, 2016 (amountsin millions Depreciation and amortization expense $260 Cash dividends declared and paid 343 Purchase of equipment 818 Net income 396 Beginning cash balance 128 Proceeds of common stock issued 171 Proceeds from sale of building (at book value) 215 Accounts receivable increase 16 Ending cash balance 92 Inventory decrease 45 Accounts payable increase 54 Required: Complete the following statement of cash flows, using...
Following is financial information for NetFlix, Inc., for the year ended December 31, 2016 (in thousands)....
Following is financial information for NetFlix, Inc., for the year ended December 31, 2016 (in thousands). Use the parsimonious method of forecasting to project net operating profit after tax (NOPAT) and net operating assets (NOA) for 2017 through 2020, inclusive. Sales $ 8,830,669 Net operating profit after tax (NOPAT) 261,828 Operating assets 11,852,828 Operating liabilities 7,542,499 Assume that net operating profit margin (NOPM) and net operating asset turnover (NOAT) will remain at 2016 levels. Assume that sales will grow at...
The following information is from Alberta Ltd financial statements for the year ended Dec 31, 2020:...
The following information is from Alberta Ltd financial statements for the year ended Dec 31, 2020: - Net income for the year $ 460,000. - 8% Convertible bonds issued at par $1,000,000 ($1000 per bond), each bond convertible into 20 common shares $1,000,000 - 6% non-cumulative preferred shares $100 par value. $1,000,000 - Common shares 120,000 authorized, 60,000 issued and outstanding $ 600,000 - Stock options (call option granted in a prior year) to purchase 30,000 common shares at $10...
The following information is from Alberta Ltd financial statements for the year ended Dec 31, 2020:...
The following information is from Alberta Ltd financial statements for the year ended Dec 31, 2020: - Net income for the year $ 460,000. - 8% Convertible bonds issued at par $1,000,000 ($1000 per bond), each bond convertible into 20 common shares $1,000,000 - 6% non-cumulative preferred shares $100 par value. $1,000,000 - Common shares 120,000 authorized, 60,000 issued and outstanding $ 600,000 - Stock options (call option granted in a prior year) to purchase 30,000 common shares at $10...
The following data has been summarized for the year ended December 31, 2021: Cost Retail Inventory,...
The following data has been summarized for the year ended December 31, 2021: Cost Retail Inventory, January 1 $ 88,000 $ 132,000 Purchases 163,000 240,000 Net markups 10,100 Net markdowns 9,200 Normal spoilage 43,200 Net sales 213,000 Required: Estimate the cost of ending inventory applying the conventional retail method.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT