The following trial balance has been extracted from the ledger of Herbert Howell, a sole trader,as at 31 May 2019, the end of his most recent financial year.Herbert HowellTrial Balance As At 31 May 2019Dr CrSh. Sh.Property at cost 90,000Equipment at cost 57,500Provision for depreciation (as at 1 June2018)Property 12,500Equipment 32,500Stock as at 1 June 2018 27,400Purchases 259,600Sales 405,000Discounts allowed 3,370Discounts received 4,420Wages and salaries 52,360Bad debts 1,720Loan interest 1,560Carriage out 5,310Other operating expenses 38,800Trade debtors 46,200Trade creditors 33,600Provision for bad debts 280Cash on hand 151Bank overdraft 14,500Drawings 28,93013% loan 12,000Capital, as at 1 June 2018 ______ 98,101612,901 612,901The following additional information as at 31 May 2019 is available:(a) Stock as at the close of business was valued at Sh.25,900.(b) Depreciation for the year ended 31 May 2019 has yet to be provided as follows:Property - 1% using the straight-line methodEquipment - 15% using the straight-line methodCUEA/ACD/EXM/SEPT - DEC 2022/GABA/BCOM Page 4ISO 9001:2015 Certified by the Kenya Bureau of Standards.(c) Wages and salaries are accrued by Sh.140.(d) Other operating expenses include certain expenses prepaid by Sh.500. Other expensesincluded under this heading are accrued by Sh.200.(e) The provision for bad debts is to be adjusted so that it is 0.5% of trade debtors as at 31 May2019.(f) Purchases include goods valued at Sh.1,040, which were withdrawn by Mr Howell for hisown personal use.Required:Prepare Mr. Howell’s trading and profit and loss account for the year ended 31 May 2019 and hisbalance sheet as at 31 May 2019.
Question
The following trial balance has been extracted from the ledger of Herbert Howell, a sole trader,as at 31 May 2019, the end of his most recent financial year.Herbert HowellTrial Balance As At 31 May 2019Dr CrSh. Sh.Property at cost 90,000Equipment at cost 57,500Provision for depreciation (as at 1 June2018)Property 12,500Equipment 32,500Stock as at 1 June 2018 27,400Purchases 259,600Sales 405,000Discounts allowed 3,370Discounts received 4,420Wages and salaries 52,360Bad debts 1,720Loan interest 1,560Carriage out 5,310Other operating expenses 38,800Trade debtors 46,200Trade creditors 33,600Provision for bad debts 280Cash on hand 151Bank overdraft 14,500Drawings 28,93013% loan 12,000Capital, as at 1 June 2018 ______ 98,101612,901 612,901The following additional information as at 31 May 2019 is available:(a) Stock as at the close of business was valued at Sh.25,900.(b) Depreciation for the year ended 31 May 2019 has yet to be provided as follows:Property - 1% using the straight-line methodEquipment - 15% using the straight-line methodCUEA/ACD/EXM/SEPT - DEC 2022/GABA/BCOM Page 4ISO 9001:2015 Certified by the Kenya Bureau of Standards.(c) Wages and salaries are accrued by Sh.140.(d) Other operating expenses include certain expenses prepaid by Sh.500. Other expensesincluded under this heading are accrued by Sh.200.(e) The provision for bad debts is to be adjusted so that it is 0.5% of trade debtors as at 31 May2019.(f) Purchases include goods valued at Sh.1,040, which were withdrawn by Mr Howell for hisown personal use.Required:Prepare Mr. Howell’s trading and profit and loss account for the year ended 31 May 2019 and hisbalance sheet as at 31 May 2019.
Solution
Sure, let's break down the information and prepare the trading and profit and loss account for the year ended 31 May 2019 and the balance sheet as at 31 May 2019.
Step 1: Trading Account
Sales: 405,000 Less: Opening Stock: 27,400 Add: Purchases: 259,600 Less: Drawings: 1,040 Equals: Net Purchases: 258,560 Add: Direct Expenses: Carriage Out: 5,310 Equals: Cost of Goods Available for Sale: 291,270 Less: Closing Stock: 25,900 Equals: Cost of Goods Sold: 265,370 Gross Profit: 139,630 (Sales - Cost of Goods Sold)
Step 2: Profit and Loss Account
Gross Profit: 139,630 Less: Expenses: Depreciation: Property (90,0001%): 900 Depreciation: Equipment (57,50015%): 8,625 Wages and Salaries: 52,360 Add: Accrued Wages and Salaries: 140 Equals: Total Wages and Salaries: 52,500 Bad Debts: 1,720 Add: Provision for Bad Debts (46,200*0.5%): 231 Equals: Total Bad Debts: 1,951 Loan Interest: 1,560 Other Operating Expenses: 38,800 Less: Prepaid Expenses: 500 Add: Accrued Expenses: 200 Equals: Total Other Operating Expenses: 38,500 Equals: Total Expenses: 103,036 Net Profit: 36,594 (Gross Profit - Total Expenses)
Step 3: Balance Sheet
Fixed Assets: Property at Cost: 90,000 Less: Accumulated Depreciation: 13,400 (12,500 + 900) Equals: Net Property: 76,600 Equipment at Cost: 57,500 Less: Accumulated Depreciation: 41,125 (32,500 + 8,625) Equals: Net Equipment: 16,375 Current Assets: Stock: 25,900 Trade Debtors: 46,200 Less: Provision for Bad Debts: 231 Equals: Net Trade Debtors: 45,969 Cash on Hand: 151 Equals: Total Current Assets: 72,020 Less: Current Liabilities: Trade Creditors: 33,600 Bank Overdraft: 14,500 Equals: Net Current Assets (Working Capital): 23,920 Total Assets: 116,895 (Net Property + Net Equipment + Working Capital) Financed by: 13% Loan: 12,000 Capital: 98,101 Add: Net Profit: 36,594 Less: Drawings: 28,930 Equals: Adjusted Capital: 105,765 Total Financing: 117,765 (Loan + Adjusted Capital) Less: Prepaid Expenses: 500 Add: Accrued Expenses: 200 Add: Accrued Wages and Salaries: 140 Equals: Adjusted Total Financing: 117,605
The difference between Total Assets and Adjusted Total Financing is due to rounding errors in the calculations.
Similar Questions
The trial balance extracted from the books ofTim on 31/12/2020 is as follows.Dr. Cr.Kshs. Kshs.Capital 217,500Land and building 150,000Equipment at cost 37,500Depreciation provision for equipment 15,000Fitting at cost 37,500Depreciation provision fittings 17,250Stock 21,375Salaries and wages 57,750Purchases 225,000Administrative expenses 30,000Cash in bank 37,500Cash at hand 7,500Debtors 37,500Creditors 21,375CUEA/ACAD/EXAMINATIONS/DIRECTORATE OF EXAMINATIONS & TIMETABLING Page 3ISO 9001:2015 Certified by the Kenya Bureau of Standards.Sales 375,000Carriage out ward 1,500Carriage inward 750Return inward 1,125Return out ward 1,400Discount allowed 2,250Discount received 1,225Bad debts written 1,500Total 648,750 848,750Additional informationi) Closing stock was valued at kshs30,000ii) Wages paid in advance shs2000iii) Administrative expenses outstanding shs 1500iv) Depreciation to be charged 10% on cost of equipment and 5% on cost of fittings.v) 5% provision for doubtful debts .Required;i) Trading profit and loss account for the period ending 31/12/20 (13 Marks)ii) Balance sheet as at 31/12/20
The following trial balance was extracted from the books of Rose Martins, a sole trader on 31 December 2005. Sh. Sh.Capital 2,880,000Freehold land and buildings at cost 1,120,000Motor vehicles at cost 1,094,000Furniture and fittings at cost 240,000Stock at 1 January 2005 960,000Purchases and sales 9,408,000 11,088,000Debtors and creditors 936,000 695,200Discounts allowed and received 195,200 119,200 Returns inwards and outwards 16,000 28,800Rent received 44,000 Loan (interest payable 5% per annum) 192,000Interest on loan 4,800Proceeds of sale of motor vehicle 150,000Provision for doubtful debts 27,200Bad debts 52,000Wages and salaries 1,127,200Drawings 256,000General expenses 138,400Bank balance 108,800Rates and insurance 48,000Provisions for depreciation: Furniture and fittings 160,000 Motor vehicle 320,000 15,704,400 15,704,400Notes:1. Stock at 31 December 2005 was valued at Sh. 1,360,000.2. Included in general expenses is a sum of Sh. 26,400 being expenses on electricity for domestic use.3. A vehicle purchased on 1 January 2003 at Sh. 450,000 was sold for Sh. 150,000. The only record of the transaction is the credit of Sh. 150,000 to the proceeds of sale of motor vehicle account.4. As at 31 December 2005, wages and salaries outstanding amounted to Sh. 66,400.5. Prepaid rates and insurance as at 31 December 2005 stood at Sh. 12,000.6. Interest paid is only a half of the amount due for the year ended 31 December 2005.7. Provision for doubtful debts is to be adjusted to 5% of the debtors.8. Depreciation is to be provided for as follows:(i) Furniture and fittings at 5% on reducing balance method(ii) Motor vehicles at 20% on straight line method.9. Rent owing from a tenant who occupies a part of the building was Sh. 40,000 on 31 December 20005.Required:a) Profit and loss account for the year ended 31 December 2005.b) Balance sheet as at 31 December 2005.
Nicolette, a sole proprietor, extracted the following trial balance from her ledgerson 31 March 2017.Dr (Sh.) Cr (Sh.)Sales 126,500Purchases 99,850Premises at cost 100,000Depreciation for premises 1 April 2016 25,000Plant at cost 18,000Depreciation for plant 1 April 2016 2,300Wages and salaries 8,900Rent 7,500Stock at 1 April 2016 5,000Capital at 1 April 2016 80,000Drawings 25,000Carriage inwards (freight-in) 4,000Receivables 27,500Bad debts written off 5,000Payables 16,000Rent revenue 2,000Bank balance 18,950Loan 30,000300,750 300,750P.O. Box 6215700200 Nairobi - KENYATelephone: 891601-6Fax: 254-20-891084E-mail:[email protected]. M. E. C. E. ACuea/ACD/EXM/APRIL 2017/Commerce Page 2ISO 9001:2008 Certified by the Kenya Bureau of StandardsAdditional information:a. Stock at 31 March 2017 was valued at Sh12,500.b. Wages and salaries accrued amounted to Sh 700c. Loan interest of 10 per cent per annum had not yet been paid.d. Rent had been prepaid by Sh300.e. Provision for doubtful debts of 2 per cent is to be made.f. Depreciation is provided at 2 per cent of cost on premises and at 10 per cent onplant.Required:Prepare the following statements for Nicolette;a) Income statement for the year ended 31 March 2017. (15 marks)b) Balance sheet as at 31 March 2017.
The following summarized trial balance appeared in the books of MakossaEnterprises.Purchases and SalesDR _120,000CR200,000Debtors and creditors 80,000 50,000Cash 40,000Other assets and other Liabilities 240,000 200,000Suspense Account 30,000Total 480,000 480,000Subsequent investigations revealed the following errors:i) A sales invoice of Sh.20,000 had not been recognized in the books of accountsii) A cash receipt from a debtor of Sh.15,000 had not been adjusted in the debtors accountiii) A cash payment to a creditor of Sh.9,500 had been debited to the creditor’s account asSh.4,900iv) A purchase of a computer of Sh.50,000 for use in office work had been debited tothe purchases accountP.O. Box 90830100 Eldoret – KenyaTelephone: 0728458276Fax: 254-20-891084Email:[email protected]/ACD/EXM/SEPT - DEC 2022/GABA/BCOM Page 2ISO 9001:2015 Certified by the Kenya Bureau of Standards.v) The accountant had failed to bring forward a balance of Sh.19,600 in the wagespayable account in the post-closing trial balance of the previous financial yearRequired:i) Journal entries to correct the identified accounting errors (5 Marks)ii) The suspense account (5 Marks)iii) The corrected trial balance
From the trial balance of Ajith and the adjustments given below, prepare tradin and profit and loss A/c for the year ended 31st March 2022 and the balance shee as on that date. Debit Credit Particulars Opening stock 15,000 Capital 25,000 Furniture and fixtures 30,000 Returns outward 1,000 Purchases 40,000 Bills payable 10,000 Sales returns 2,000 Sales 1,24,000 Carriage inwards 10,000 Provision for doubtful debts 500 Office rent 23,000 Sundry debtors 20,100 Bank balance 19,600 Bad debts 900 Provision for discount on debtors 100 1,60,600 1,60,600 (a) Stock at the end of the year was ₹8,000 (b) Further bad debts amounted to ₹ 100 (c) Create 2% provision for doubtful debts on sundry debtors (d) Create 1% provision for discount on sundry debtors
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.