Knowee
Questions
Features
Study Tools

The following trial balance was extracted from the books of Kamau’s a soletrader as at 31/12/2017.DEBITSHSCREDITSHSFurniture 12,000Motor Vehicle 20,000Bank loan 20,000Debtors 39,000Stock 1/1/2017 14,000Sales 96,000Discount Allowed 3,500Advertising expenses 1,800Insurance expenses 4,000Return Inwards 6,000Salaries Expenses 2,800Electricity expenses 2,000Purchases 38,000Rent Income 12,000Carriage inwards 5,000Return outwards 3,000Discount received 4,500Dividend income 7,000Creditors 16,000Drawings 4,000Cash 15,000Capital 8,600167,100 167,100Additional Information:Value of closing stock shs.5,000Bad debts to be written off shs.1,500Prepaid insurance expenses was shs.2,500Unpaid electricity bill as at 31/12/2017 was shs.1,000.Rent income received in advance was shs.4,000Dividend income receivable was shs.3,000Required:i) Prepare a Trading and profit and loss account for the year ended31/12/2017

Question

The following trial balance was extracted from the books of Kamau’s a soletrader as at 31/12/2017.DEBITSHSCREDITSHSFurniture 12,000Motor Vehicle 20,000Bank loan 20,000Debtors 39,000Stock 1/1/2017 14,000Sales 96,000Discount Allowed 3,500Advertising expenses 1,800Insurance expenses 4,000Return Inwards 6,000Salaries Expenses 2,800Electricity expenses 2,000Purchases 38,000Rent Income 12,000Carriage inwards 5,000Return outwards 3,000Discount received 4,500Dividend income 7,000Creditors 16,000Drawings 4,000Cash 15,000Capital 8,600167,100 167,100Additional Information:Value of closing stock shs.5,000Bad debts to be written off shs.1,500Prepaid insurance expenses was shs.2,500Unpaid electricity bill as at 31/12/2017 was shs.1,000.Rent income received in advance was shs.4,000Dividend income receivable was shs.3,000Required:i) Prepare a Trading and profit and loss account for the year ended31/12/2017

...expand
🧐 Not the exact question you are looking for?Go ask a question

Solution

To prepare the Trading and Profit and Loss account for the year ended 31/12/2017, we need to follow these steps:

Step 1: Calculate the Cost of Goods Sold (COGS)

  • Opening Stock: Shs.14,000
  • Purchases: Shs.38,000
  • Carriage Inwards: Shs.5,000
  • Less: Closing Stock: Shs.5,000 COGS = (14,000 + 38,000 + 5,000) - 5,000 = Shs.52,000

Step 2: Calculate the Gross Profit Gross Profit = Sales - COGS Gross Profit = Shs.96,000 - Shs.52,000 = Shs.44,000

Step 3: Calculate the Net Profit

  • Add: Rent Income: Shs.12,000
  • Add: Dividend Income: Shs.7,000
  • Less: Discount Allowed: Shs.3,500
  • Less: Advertising Expenses: Shs.1,800
  • Less: Insurance Expenses: Shs.4,000
  • Less: Salaries Expenses: Shs.2,800
  • Less: Electricity Expenses: Shs.2,000
  • Less: Return Outwards: Shs.3,000
  • Add: Discount Received: Shs.4,500 Net Profit = Gross Profit + Rent Income + Dividend Income - Discount Allowed - Advertising Expenses - Insurance Expenses - Salaries Expenses - Electricity Expenses - Return Outwards + Discount Received Net Profit = Shs.44,000 + Shs.12,000 + Shs.7,000 - Shs.3,500 - Shs.1,800 - Shs.4,000 - Shs.2,800 - Shs.2,000 - Shs.3,000 + Shs.4,500 Net Profit = Shs.60,400

Step 4: Prepare the Trading and Profit and Loss Account

Trading and Profit and Loss Account for the year ended 31/12/2017

Particulars Amount (Shs.) Particulars Amount (Shs.) Sales 96,000 COGS 52,000 Gross Profit 44,000 Gross Profit 44,000 Rent Income 12,000 Discount Allowed 3,500 Dividend Income 7,000 Advertising Expenses 1,800 Insurance Expenses 4,000 Salaries Expenses 2,800 Electricity Expenses 2,000 Return Outwards 3,000 Discount Received 4,500 Net Profit 60,400 Total 159,000 159,000

Note: The Net Profit of Shs.60,400 will be transferred to the Capital account.

This problem has been solved

Similar Questions

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.

You've been provided with the following Trial BalanceCalculate TOTAL ASSETSCash 25,450Accounts Receivable 25,500Inventory 85,000Prepaid Expenses 4,950Motor vehicle 68,000Equipment 155,000Accounts Payable 35,000Unearned Revenue 8,000Wages Payable 15,000Bank Loan 50,000Share Capital 235,000Retained Earnings 10,000Dividends -5,000Revenue 53,650Cost of Sales -12,450Wages Expense -15,000Interest expense -2,500Marketing expense -2,800Insurance expense -5,000

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

Kristina Tailoring Trial Balance (extract) as at 30th June 2018 K K Interest on Loan 1300+300=1600 Loan (8% p.a due 2022) 20 000 Rent 4 200-300=3900 Accumulated Depreciation on Equipment 3750+1500=4250 Equipment 15 000 Provision for Doubtful Debts 90 Bad Debts 60 Commission 1040 Insurance 650 Accounts Receivable 2500 Rent expense +300 Interest expense +300 Additional Information as at 30th June 2018 1. Rent per month is K300 2. Interest on loan is due K300 3. Depreciation on equipment is yet to be provided K1500_(Depreciation Expense) 4. Commission received in advance K80_ Required: 1. Draw accounts to record the initial account records 2. Prepare Balance Day Adjustment for adjustments 1-4 given above.

The trial balance of Gayathri business on 2021.12.31 is as follows.Rs. ‘000’Details Debit CreditCash and cash equivalentsStock on 31.12.2021Bonus payment for sales employeesInsuranceTrade payableCapitalBank loan interest20% Bank loanElectricity chargeMotor vehicle repairOther expensesAccumulated depreciation on 2021.01.01Property, plant and equipment – cost on 2021.01.01Trade receivableOther administrative expensesProvision for doubtful debt on 2021.01.01Office rentTelephone chargeSalesCost of sales1504503007001006506501 22012 70080090030527010 0004008 7001 0003 02510015 97029 195 29 195Additional information:1. Details of accumulated depreciation of property, plant and equipment are as follows.Assets Cost Rs. ‘000’ Accumulateddepreciation Rs. ‘000’Motor vehicleOffice equipmentLand and building(Land cost Rs. 5 000)2 0001 0009 7006006251 80012 700 3 0252. In accordance with inventory records, cost value of stock on 31.12.2021 is Rs. 450 000. However, thegoods taken by Gayathri for her private need have not been recorded.3. Telephone charge not paid up to 31.12.2021 is Rs. 30 000.4. Property, plant and equipment are depreciated on straight line method. The details useful life time andresidual value are given below.Grade - 12 (2023) – 2023 FWC - 7 - Accounting- IAssets Useful life time Residual valueMotor vehicleOffice equipmentBuilding20 years10 years18 years---5. Other expenses include the following expenses.Fire loss Rs. 220 000Business fees Rs. 100 000Employee salary Rs. 400 0006. A new office equipment was purchased for Rs. 500 000 on 2021.07.01. This amount was erroneouslyrecorded in other administrative expenses. Life time of this equipment was estimated as 5 years andthere is no residual value.7. Rs. 100 000 should be written off from debtors and allowance for doubtful debt on 2021.12.31 shouldbe adjusted as 10% of closing trade receivable.8. Cash control account balance of the business on 2021.12.31 and bank statement balance on the samedate were different due to the following reasons.(a) Rs. 50 000 directly deposited by a debtor directly at bank was not recorded in the books.(b) Own life insurance premium of Gayathri paid from the business fund was not recorded in theaccounting books.(c) Bank overdraft interest Rs. 15 000 in bank statement was not recorded in the accounting booksup to 31.12.2021.Required,1. Profit or loss statement for the year ended 2021.12.312. Statement of financial position as at 2021.12.31

1/3

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.