Question

In: Accounting

Ernest and his partner Mary run a second-hand bookshop. The business is incorporated under the name...

Ernest and his partner Mary run a second-hand bookshop. The business is incorporated under the name of Ketchum Ltd, and they are the only shareholders.

As the business is small they do not employ a full-time accountant, but pay a local firm to prepare their accounts after the end of the accounting period from information they supply. You are on a summer work placement with this firm and have been asked to prepare             a first draft of the accounts for Ketchum Ltd for the year ending 31st December 2019.

A list of closing balances reported in Ketchum Ltd’s statement of financial position as at 31st December 2018 is set out below:

Ketchum Ltd.

Statement of Financial Position

31st December 2018

£

£

Shop premises (cost)

56,250

Shop premises (accumulated depreciation)

3,375

Fixtures and fittings (cost)

12,500

Fixtures and fittings (accumulated depreciation)

3,750

Inventories of books at cost

42,375

Trade receivables

39,000

Prepayment

500

Total assets

143,500

Trade payables

6,962.50

Accruals

1,250

Bank overdraft

6,250

Bank loan repayable in 2022

33,750

Total liabilities

48,212.50

Share capital (£1 ordinary shares)

62,500

Retained profits

32,787.50

Total equity

95,287.50

Further information:

  1. The shop premises were acquired under a 50-year lease on 1st January 2016 and are being depreciated to a zero residual value.
  2. The fixtures and fittings were also bought on 1st January 2016 and are being depreciated over 10 years to a zero residual value.
  3. Depreciation is provided on a straight line basis for both the shop premises and the fixtures and fittings.
  4. The business pays its insurance premium annually on 1st July to cover the following twelve month period. This is the only prepayment as at 31st December 2018.
  5. The accrued expenses relate to the accountant’s fees for preparing last year’s accountants, paid in March 2019. This is the only accrual as at 31st December 2018.
  6. All profits earned are subject to a 20% corporate income tax paid on 31st December of the year in which they are earned.

During the year to 31st December 2019, the following transactions and events took place:

  1. The business made cash sales of £107,375. It also made credit sales to internet retailers of £76,787.50.
  2. Inventory costing £94,725 was bought during the year. All items were bought on credit. Suppliers were paid £96,437.50 over the course of the year.
  3. The inventory of books as at 31st December 2019 cost £34,375.
  4. During the year some fixtures that had cost £2,500 when purchased were sold for £1,375. New fixtures were acquired for cash at a cost of £3,750 and are also being depreciated over 10 years to a zero residual value. No depreciation is charged in the year of disposal but a full year’s depreciation is charged in the year of acquisition.
  5. The part-time shop assistant was paid wages of £13,625 over the year.
  6. Receipts from credit customers totalled £68,162.50.
  7. Electricity bills totalling £2,287.50 were paid during the year. The company has recently changed its electricity supplier and is now being billed quarterly in arrears. At the end of December 2019 the bill for the quarter ended on 31st January 2020 had not yet been received, but was estimated to be £862.50.
  8. You have been told that the fees charged for preparing the accounts will be the same as last year. The bill will be sent out in March 2020.
  9. The insurance premium of £1,125 for the year to 30th June 2020 was paid during July 2019.
  10. In December 2019 £10,000 was paid off the bank loan, and interest of £1,000 was paid on 31st December 2019. Overdraft interest of £118.75 was charged and paid.
  11. Administrative expenses of £1,581.25 were paid as they arose.
  12. Ernest and Mary received directors’ wages of £1,250 per month each.

Required:

  1. Using the information provided by Ernest and Mary, and Ketchum Ltd’s statement of financial position as at 31st December 2018, prepare the following:
    1. A table summarising the effects of all transactions and events listed above on assets, liabilities, equity, revenue, and expenses of Ketchum Ltd.

  1. A statement of profit or loss for 2019.

  1. A statement of cash flows for 2019.

  1. A statement of financial position as at 31st December 2019.

Show your workings.

  1. Ernest and Mary meet you to discuss the draft accounts. They say they had hoped to be able to pay a dividend of around 15 pence per share, but they fear that they might not have enough cash to do this. They query whether this is the case, since they are making reasonable profits.
    1. Calculate the amount of the proposed dividend payment.

(1 mark)

  1. Advise Ernest and Mary if their company can pay out such dividend based on the figures reported in the financial statements you prepared.

(1 mark)

  1. Provide a brief explanation of the difference between cash flow and profit.

  1. The owners of the business also want to find out more about the financial health of their firm and are particularly interested in its liquidity and long-term solvency.
    1. They would like you to calculate the current ratio, quick (acid test) ratio, gearing ratio and working capital figures for 2018 using the figures reported in previous year’s statement of financial position, and for 2019 using the statement of financial position you prepared. Show your workings.

  1. Comment on whether the position of the business improved over the last year.

  1. Briefly outline the key limitations of ratio analysis.

Solutions

Expert Solution

Summary of all the transactions
Particulars Amount
Sales
Cash    107,375.00
Credit      76,787.50
Total Sales    184,162.50
Inventory
Opg.      42,375.00
Closing      34,375.00
Purchases      94,725.00
Trade Payables
(6962.5 + 95725 - 96437.5)        5,250.00
Gain/Loss on sale of Fixtures
Cost of Fixtures        2,500.00
Less : Deprecition
(2500/10) x 3            750.00
Book Value as on Jan. 1, 2019        1,750.00
Less : Sales        1,375.00
Loss on sale of fixtures          (375.00)
Depreciation on fixtures for the year
(12,500 - 2500 + 3750)/ 10        1,375.00
Receivables
(39000 + 76787.5 - 68162.5)      47,625.00
Electricity Exps Payable 862.5
Insurance Premium
Prepaid Insurance
(1125/2)            562.50
Insurance Expense            562.50
Bank Loan
(33750 - 10000)      23,750.00
Interest on Bank Loan        1,000.00
Interest on Overdraft            118.75
Director Wages
Ernest (1250 x 12)      15,000.00
Mary (1250 x 12)      15,000.00      30,000.00

2.

Ketchum's Ltd
Statement of Profit or loss for the year 2019
Particular Amount Particular Amount
Opening Stock      42,375.00 Sales    184,162.50
Purchases      94,725.00
Depreciation Closing Stock      34,375.00
(1125 + 1375)        2,500.00
Loss on sale of fixtures            375.00
Electricity Expenses
(2287.5+862.5)        3,150.00
Insurance Expenses            562.50
Interest on Bank Loan        1,000.00
Interest on Overdraft            118.75
Assistant Wages      13,625.00
Administrative Expenses        1,581.25
Accounting        1,250.00
Director Wages      30,000.00
Provision for Tax @ 20%        5,455.00
Net Profit T/f to Bal. Sheet      21,820.00
   218,537.50    218,537.50
Calculation of Provision for Tax
Earnings    218,537.50
Less : Expenses    191,012.50
Profit Before Tax      27,275.00
Less : Tax        5,455.00
PAT      21,820.00

3.

Ketchum's Ltd
Statement of Cash Flows
Dr Cr
Particular Amount Amount
Cash Sales    107,375.00
Cash Received from Receivables      68,162.50
Purchases      94,725.00
Payment to Trade payables      96,437.50
Sale of fixtures        1,375.00
Purchases of fixtures        3,750.00
Wages to Assistant      13,625.00
Electricity Bill        2,287.50
Insurance Premium        1,125.00
Bank Loan      10,000.00
Interest on Bank Loan        1,000.00
Interest on Overdraft            118.75
Administrative Expenses        1,581.25
Director's Wages      30,000.00
Bank Overdraft      77,737.50
   254,650.00    254,650.00

4. Statment of Financial Position

Ketchum's Ltd
Statement of Financial Position
Particular Amount Amount
Shop premises (cost)      56,250.00
Shop premises (accumulated depreciation)        4,500.00
Fixtures and fittings (cost)      13,750.00
Fixtures and fittings (accumulated depreciation)        5,125.00
Inventories of books at cost      34,375.00
Trade receivables      47,625.00
Prepayment            562.50
Total assets    162,187.50
Trade payables 5,250.00
Accruals        1,250.00
Bank overdraft      13,967.50
Bank loan repayable in 2022      23,750.00
Electricity Exps Payable            862.50
Total liabilities 45,080.00
Share capital (£1 ordinary shares)      62,500.00
Retained profits      54,607.50
Total equity    117,107.50
   324,375.00    324,375.00

Related Solutions

Ernest and his partner Mary run a second-hand bookshop. The business is incorporated under the name...
Ernest and his partner Mary run a second-hand bookshop. The business is incorporated under the name of Ketchum Ltd, and they are the only shareholders. As the business is small they do not employ a full-time accountant, but pay a local firm to prepare their accounts after the end of the accounting period from information they supply. You are on a summer work placement with this firm and have been asked to prepare             a first draft of the accounts for...
QUESTION 1 Ernest and his partner Mary run a second-hand bookshop. The business is incorporated under...
QUESTION 1 Ernest and his partner Mary run a second-hand bookshop. The business is incorporated under the name of Ketchum Ltd, and they are the only shareholders. As the business is small they do not employ a full-time accountant, but pay a local firm to prepare their accounts after the end of the accounting period from information they supply. You are on a summer work placement with this firm and have been asked to prepare             a first draft of the...
QUESTION 1 Ernest and his partner Mary run a second-hand bookshop. The business is incorporated under...
QUESTION 1 Ernest and his partner Mary run a second-hand bookshop. The business is incorporated under the name of Ketchum Ltd, and they are the only shareholders. As the business is small they do not employ a full-time accountant, but pay a local firm to prepare their accounts after the end of the accounting period from information they supply. You are on a summer work placement with this firm and have been asked to prepare             a first draft of the...
Mary and Tony have owned a bookshop in Ryde for many years and their business has...
Mary and Tony have owned a bookshop in Ryde for many years and their business has been very successful. In January 2020, they were approached by a major competitor to buy the business. Mary and Tony carry on the bookshop business as partners and also own adjacent premises that are used mainly as a warehouse for their trading stock. The potential purchaser is only willing to buy the bookshop, and not the adjacent premises because it already has adequate storage...
Alwi, a second-hand seller has exhibited his wares at the Cheap Sales Expo.
Alwi, a second-hand seller has exhibited his wares at the Cheap Sales Expo. Customers are allowed to view and check the condition of the goods before making a payment. However, after two days a customer came to see Alwi and wanted to return the item he bought for the low quality item. Advise Alwi by providing the provision from Sales of Goods Act 1957and ONE (1) relevant case.course: Business Law
Alwi, a second-hand seller has exhibited his wares at the Cheap Sales Expo.
business lawAlwi, a second-hand seller has exhibited his wares at the Cheap Sales Expo. Customers are allowed to view and check the condition of the goods before making any payment. However, after two days a customer came to see Alwi and wanted to return the item that he bought due to the item being of low quality.what is the issue in this case?
Ron McLellan established his business, McLellan’s Shoes, in 1985. Since then, he has run his business...
Ron McLellan established his business, McLellan’s Shoes, in 1985. Since then, he has run his business as a sole proprietor. Ron keeps records and his wife helps him prepare basic accounting records. As McLellan’s Shoes has no outside owners, Ron has never seen the need to have his accounts audited. When Chip Masters from Cloud 9 Inc. expressed an interest in buying McLellan’s Shoes in 2020, Ron was asked to provide audited financial statements. Ron discussed his concerns about having...
Mary, Elizabeth and Bill run a business which sells imported European groceries online and at its...
Mary, Elizabeth and Bill run a business which sells imported European groceries online and at its bricks and mortar store in Melbourne. The business has an annual turnover of $6,000,000 and 30 employees, and profits of the business are shared between Mary, Elizabeth and Bill. Mary, Elizabeth and Bill would like to expand their business by importing new groceries from Asia and buying another store in the Docklands which they hear is running at a loss. They do not want...
QUESTION 1 Kasabrunu Enterprise is a business operating in the second-hand clothing in Kwadaso. Mr. Bruni...
QUESTION 1 Kasabrunu Enterprise is a business operating in the second-hand clothing in Kwadaso. Mr. Bruni the owner of Kasabrunu Enterprise (KE) employed Mr. Ojidomi a BSc. Accounting graduate as the Accountant. Business is booming and KE is expected to be in operation for a long time. Mr. Odjidomi has been with the business for 5 years and has assured Mr. Bruni that profits declared will not be deceptive since the same method will be continuously used for the accounting...
QUESTION 1 Kasabrunu Enterprise is a business operating in the second-hand clothing in Kwadaso. Mr. Bruni...
QUESTION 1 Kasabrunu Enterprise is a business operating in the second-hand clothing in Kwadaso. Mr. Bruni the owner of Kasabrunu Enterprise (KE) employed Mr. Ojidomi a BSc. Accounting graduate as the Accountant. Business is booming and KE is expected to be in operation for a long time. Mr. Odjidomi has been with the business for 5 years and has assured Mr. Bruni that profits declared will not be deceptive since the same method will be continuously used for the accounting...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT