Accounting Ratios - CE
Accounting Ratios - CE
Accounting Ratios - CE
1/8
Sales were $270,500 and $337,500 for the years ended 31 March 1994 and 1995 Balance sheet as at 31 December 1996
respectively. Corresponding figures for cost of sales were $184,500 and $240,500 $ $
respectively. Purchases for 1994 amounted to $194,500. Fixed assets (at net book value)
Plant and equipment 610,400
Required: Furniture and fittings 173,600
784,000
Calculate the following ratios for 1994 and 1995: Current assets
(a) gross profit ratio; Stock 154,000
(b) stock turnover rate; Debtors 105,000
(c) current ratio; Bank 7,000 266,000
(d) quick ratio; and 1,050,000
(e) credit period received from trade creditors (in months). Shareholders’ fund
(Calculations to one decimal place) (10 marks) Share capital ($1 ordinary shares) 770,000
Retained earnings 64,400
834,400
1997 Q.2 Current liabilities
The financial information of Games Limited for the year ended 31 December 1996 Creditors 168,000
is presented below: Accruals 47,600 215,600
$ $ 1,050,000
Credit sales 504,000
Opening stock 84,000 Required:
Add: Purchases 382,200
466,200 (a) Calculate the following for 1996:
Less: Closing stock 154,000 (i) Working capital;
Cost of sales 312,200 (ii) Return capital employed;
Gross profit 191,800 (iii) Quick ratio;
(iv) Stock turnover rate;
Net profit 47,600 (v) Debtors’ collection period (in months); and
(vi) creditors’ repayment period (in months).
(Calculations to one decimal place.) (6 marks)
(b) Give two possible dangers of having too little working capital. (4 marks)
HKCEE-11-accounting ratios P.3/8
1993 Q.10 Bank Reconciliation + Ratios Mr. Lee tried to draw up a balance sheet to reveal the financial situation of the
Mr. Lee commenced his business with $50,000,000, of which $40,000,000 was used business but he was hesitant on most of the figures:
in buying an office. He was engaged in retail trading and all sales were made on a
credit basis. $000 $000 $000 $000
Fixed assets Capital 50,000
After a year’s trading, he was surprised to have a bank overdraft of $8,255,000 as Premises, net ? Net profit ?
indicated by the bank statement at 30 April 1993 whereas the cash book showed a Delivery van, net ? ? ?
credit balance of $7,865,300. Drawings ?
Current assets ?
Upon investigation, he found that: Stock ? Current liabilities
Debtors ? Creditors ?
(i) Six cheques (which amounted to $750,000 in total) were deposited on 30 April Cash ? Bank O/D ?
1993 but were not yet credited by the bank. ? ?
? ?
(ii) An electricity bill settled by the bank’s autopay system in April 1993
amounted to $6,290. It is the practice of the company to record this expense The following data have been complied for your information:
upon receipt of the bank statement of the month.
Sales for the year $60,000,000
(iii) The March balance of $65,870 in the cash book was carried forward as Gross profit margin 40%
$56,780. Net profit to sales 11%
Return on total assets employed 12.5%
(iv) A debtor settled his account of $87,500 by credit transfer. Depreciation of fixed assets 25%
Stock turnover (stock level
(v) Interest of $58,000 was charged by the bank on the overdraft. No record of constant throughout the year) 6 times
this had yet been made. Credit period allowed to debtors 2 months
Current ratio 1.4 : 1
(vi) A cheque for $89,000 received from a debtor was returned by the bank marked Working capital $5,000,000
“UNPAID”. This amount was deducted from the balance in the bank statement
but had not been entered in the books. Required:
(vii) Two cheques drawn by Mr. Lee were not yet presented to the bank for (a) Update the bank balance in the hooks of Mr. Lee as at 30 April 1993.
payment. They were (#80967) $420,000 and (#80973) $75,000. (7 marks)
(viii) A debt of $78,000 previously written off as bad was now recovered and a (b) Prepare a bank reconciliation statement as at 30 April 1993. (3 marks)
cheque dated 2 May 1993 was received from the customer concerned. This
had been recorded in the cash book but the cheque still remained in the cash (c) Draw up the balance sheet for Mr. Lee as at 30 April 1993, filling in all the
till. missing figures. (10 marks)
HKCEE-11-accounting ratios P.6/8
(iii) Debtors’ collection period for the year was two months and creditors’
repayment period was three months.
(v) All purchases and 90% of the net sales were on credit.
(vii) Current assets consisted of cash at bank, debtors, stock and prepayments.
HKCEE-11-accounting ratios P.7/8
(vi) He achieved the following accounting ratios in his operation through the year: Balance sheet data as at 31 March 2003 2004
$ $
Current ratio 2:1 Furniture and fixtures (net) 18,420
Office equipment (net) 32,480
Liquid ratio 1:1
Stock 28,750 26,400
Sales to fixed assets (valued at the beginning
Trade debtors 29,260 30,340
of the year) ratio 8:1
Bank 660
Debtors (at the end of the year) to sales ratio 1:20
108,300
Gross profit margin 25%
Ordinary share capital 50,000
Stock turnover per year 6 times
Share premium 12,890
General expenses (excluding depreciation)
Retained profits 15,500
to sales ratio 1:10 Trade creditors 26,900
Depreciation on fixed assets Accruals 3,010
(reducing balance method was adopted) 10% p.a. 108,300
Required:
(a) Calculate the returns on the total assets employed and quick ratios for the accounting years
1990 and 1991. Basing on your calculations, comment on me profitability and liquidity
position of Stonemoss Lid.
(b) Prepare journal entries to record the issue of shares
(c) Prepare an extract of the balance sheet (capital section only) after the
issue of shares.
(20 marks)
Accounting Ratios
2008 – Q4c 1992 - Q.7
The Macho Club is a non-profit making organisation which aims at promoting long distance The following are the balance sheets of Stonemoss Ltd.:
running. Members are required to pay an annual membership fee of $500. The Club also sells Balance sheets as at 30 June
T-shirts to members for cash. 1991 1990
$ $
The account balances relating to membership fees and T-shirt trading are as follows: Fixed assets 739 000 650 000
As at 1 January 2007 As at 31 December 2007 Premises (net) 84 000 71 000
$ $ Plant and machinery (net) 8 000 20 000
Prepaid membership fee 3 000 1 500 Motor vehicles (net)
Accrued membership fee 5 500 7 500
Amount owing to suppliers 8 970 13 980 Current assets
Stock of T-shirts 6 320 5 730 Stock 32 000 43 000
Sundry debtors 37 500 52 000
The following are the related cash receipts and payments during the year ended 31 December Cash in hand 56 320 61 200
2007: 956 820 897 200
$
Membership fee received 84 000 Authorised capital 1 000 000
Payment to suppliers 22 890 Ordinary shares of $1 each 1 000 000 1 000 000
Commission on T-shirt sales 4 200
T-shirt sales 48 200 Issued capital 500 000 ordinary shares of $1 each 500 000 500 000
General reserves 47 900 84 600
Accrued membership fee of $2500 brought down from 2006 was confirmed to be uncollectible Profit and loss account 82 390 12 330
and written off in 2007. Profit for the year 37 670 70 060
Required:
(a) Calculate the returns on the total assets employed and quick ratios for the accounting years
1990 and 1991. Basing on your calculations, comment on me profitability and liquidity
position of Stonemoss Lid.
(b) Prepare journal entries to record the issue of shares
(c) Prepare an extract of the balance sheet (capital section only) after the
issue of shares.
(20 marks)
Accounting Ratios
2006-Q.4b (Issue of Shares + Ratio)
Ball Limited had an issued share capital consisting of 650 000 ordinary shares of $l each as at
1 January 2005. On 1 July 2005, the company made an additional issue of 250 000 ordinary
shares at $1.50 per share, payable in full on application. Applications were received for 260 000
shares on 8 July 2005. The shares were allotted to the successful applicants on 15 July 2005.
Cash was returned to the unsuccessful applicants on the same day.
The company’s information below relates to the year ended 31 December 2005:
$
As at 1 January 2005:
Stock 62 430
Debtors 60 080
Share premium 75 000
Retained profits 213 000
As at 31 December 2005:
Stock 156 230
Debtors 102 400
Cash in bank 168 370
Creditors 184 200
Accruals 4 000