Question

In: Accounting

A- Tracy Underhill operates as a sole trader. Below is a trial balance extracted from her...

A- Tracy Underhill operates as a sole trader. Below is a trial balance extracted from her books as at

     31 December 2017.

Trial balance for Tracy Underhill as at 31 December 2017

Debit

Credit

     £                    _ .

£

Sales revenue

695,000

Inventory (as at 1 January 2017)

105,800

Purchases

625,200

Non-current assets at cost:

Equipment

100,000

Motor vehicle

80,000

Accumulated depreciation:

Equipment

10,000

Motor vehicle

10,000

Insurance

14,700

Rent

30,000

Heating and lighting

10,000

Salaries and wages

40,000

Motor expenses

15,300

Miscellaneous expenses

28,500

Receivables

110,000

Allowance for receivables

14,000

Payables

101,500

Cash

71,000

Bank loan

100,000

Capital

300,000

Total

1,230,500

1,230,500

Additional information is provided for use in preparing the company’s adjustments:

  1. The value of closing inventory is £102,500.
  2. Interest is payable on the bank loan at eight per cent per annum. The annual amount due as at 31 December 2017 had not yet been paid.
  3. Tracy has paid her rent until 31 March 2018. Her annual rent is £24,000.
  4. Office equipment has a useful life of ten years and a residual value of £0. It is to be depreciated on a straight-line basis.
  5. The motor vehicle with a useful life of ten years and an estimated residual value of £30,000 is to be depreciated on a straight-line basis at a rate of 10%.
  6. Tracy finds that receivables of £10,000 need to be written off as irrecoverable.
  7. The allowance for receivables is to be set at ten per cent of the remaining outstanding receivables as at 31 December 2017.
  8. The heating bill will arrive on 5 January and about £1,000 is expected to relate to the period until 31 December.

Required:

  1. Make the end-of-period adjustments entries   
  2. Prepare Tracy’s income statement for the year ended December 31, 2017.
  3. Prepare Tracy’s balance sheet as at December 31, 2017.   

B- What will be the effect on financial statements if an accrued expense is not recorded at the end of the year?                                                                                                                        

C- On June 30 of the current calendar year, Apricot Co. paid $9,500 cash for management services to be performed over a two-year period. Apricot follows a policy of recording all prepaid expenses to expense accounts at the time of cash payment.

Required:

1- Prepare the adjusting entry on December 31 for Apricot Co.

2- Show the effect of the adjusting entry on Income statement and balance sheet at the end of the

    Current calendar year                                            

Solutions

Expert Solution

(A)-1

Adjustment Entries on 31st December 2017-

Accounts and Explanation Debit Credit
(1). Inventory Closing 102500
COGS (Balancing fig) 628500
Purchases 625200
Inventory(Opening) 105800
(Being COGS recorded)(COGS= Oprning inventory+purchases-closing inventory)
(2)Interest Expenses 8000
Interest Payable 8000
(being interest expenses recorede =100000*8%)
(3)Prepaid Rent 6000
Rent 6000
(being 3 month prepaid rent recorded=2000*3month) for jan-march 2018)
(4) Depreciation Expenses 10000
Accumulated depreciation(Equipment) 10000
(depreciation for equioment recorded =100000/10 year = 10000 per year)
(5) Depreciation Expenses 5000
Accumulated depreciation(Motor Vehicle) 5000
(depreciation for motor vehicle recorded =(80000-30000)/10 year = 5000 per year)
(6) Allowances for receivable 10000
Accounts receivable 10000
(being bad debts are charged against allowances for receivables)
(7) Profit &loss 6000
Allowances for receivable 6000
(being allowances for receivables created)
(8)Heating and lighting expenses 1000
Expenses payable 1000
(accrued expenses charged)

working(Point-7)

Gross receivables as on 31 dec 2017 = 110000

bad debts=10000

Receivable after bad debt = 110000-10000= 100000

Allowances for receivables required = 100000*10% = 10000

Allowances already left after charging bad debt = 14000-10000 = 4000

allowances required to create = 10000-4000 = 6000

-----------------

(A)-2

Income statement

Tracy Underhill

For the year ended 31 december 2017

Sales 695000
Less-Expenses
COGS 628500
Employees expenses 40000
Administrative expenses
Rent 24000
insurance 14700
Heating & Lighting 11000
Motor Expenses 15300
Finance Cost
Interest Expenses 8000
Depreciation expenses 15000
Misc. Expenses 28500
Allowances for Receivables 6000
Net Income(loss) -96000

-----------------

(A)-3

Balance sheet

Tracy Underhill

As on 31-12-2017

Assets
Current Assets
Cash 71000
inventory 102500
Accounts receivable (100000-10000) 90000
Prepaid Rent 6000
Non Current Assets
Equioment(100000-20000) 80000
Motor vehicle(80000-15000) 65000
Total Assets 414500
Liabilities
Current Liabilities
Payables 101500
Interest Payable 8000
Expenses payable 1000
Non current liabilities
Bank loan 100000
Capital(300000-96000) 204000
Total Liability and equity 414500

-------------------------------------------------

(B)

If an accrued expenses is not recorded then,

1. Profit will be over stated

2. Current liability will be under stated

---------------------------------------

(C)

1. Adjustment entry on 31 december

Prepaid Management service Expenses 7125
Management Service Expenses 7125

Working-

Total payment made for 24 months on june 30= $9500

Upto 31 December total expenses will be for 6 months ( JULY-DEC)

Hence balance 18 months expenses will be prepaid = $9500/24*18 = 7125

2.

-on income statement expenses will be less by 7125

-on balance sheet prepaid expenses will be shown under current asset = 7125

---------------------------


Related Solutions

Question 1 (40 marks) A- Tracy Underhill operates as a sole trader. Below is a trial...
Question 1 A- Tracy Underhill operates as a sole trader. Below is a trial balance extracted from her books as at      31 December 2017. Trial balance for Tracy Underhill as at 31 December 2017 Debit Credit      £                    _ . £ Sales revenue 695,000 Inventory (as at 1 January 2017) 105,800 Purchases 625,200 Non-current assets at cost: Equipment 100,000 Motor vehicle 80,000 Accumulated depreciation: Equipment 10,000 Motor vehicle 10,000 Insurance 14,700 Rent 30,000 Heating and lighting 10,000 Salaries...
The following trial balance was extracted from the books of Al Mawaleh Traders, sole trader as...
The following trial balance was extracted from the books of Al Mawaleh Traders, sole trader as at 31 May 2018. Trial balance as at 31 May 2018 Particulars Debit Credit $ $ Capital 51,960 Drawings 4,080 Buildings at cost 53,000 Receivables and Payables 8,600 6,000 Opening Inventory 11,300 Salaries 5,080 Freight In 2,390 Freight Out 2,140 Insurance 2,790 Purchases and sales 97,600 140,385 Returns 980 1,640 Selling Expenses 1,440 Bad debts 541 Discount Received 960 Equipment at cost 8,000 Furniture...
Joe Wright, a sole trader, extracted the following trial balance from his books at the close...
Joe Wright, a sole trader, extracted the following trial balance from his books at the close of business on 31st March 2006. GH¢ GH¢ Sales 400,000 Purchases 350,000 Sales returns 5,000 Purchases returns 6,200 Opening stock at 1st January 2006 100,000 Provision for doubtful debts 800 Wages and salaries 30,000 Rates 6,000 Telephone 1,000 Shop fittings at cost 40,000 Van at cost 30,000 Debtors and creditors 9,800 7,000 Bad debts 200 Capital 179,000 Bank balance 3,000 Drawings 18,000 593,000 593,000...
Mr Modisa, sole trader, extracted the following trail balance off the books. Trial Balance as at...
Mr Modisa, sole trader, extracted the following trail balance off the books. Trial Balance as at 31 December 2019 Pula Pula Sales                                     135,000.00 Purchases                               67,500.00 Carriage inwards                                 2,300.00 Returns Inwards                                 3,200.00 Returns Outwards                                          2,400.00 Drawings                               19,600.00 Capital                                        44,800.00 Rent                                 7,000.00 Discount Allowed                                 2,400.00 Advertising                                    600.00 Salaries & wages                               42,000.00 Provision for doubtful debts                                             600.00 Accounts Receivable                               12,500.00 Accounts Payable                                        10,400.00 Cash in hand 500 Cash at...
Question 5 a) Jamie operates as a sole trader. He has extracted the following data from...
Question 5 a) Jamie operates as a sole trader. He has extracted the following data from his books of account. Financial data extracts for the year ended 31st January 2019. 6 Sales Purchases Opening Inventory Closing Inventory REQUIRED £ 140 000 100 000 40 000 20 000 Prepare Jamie’s Trading Account for the year ended 31st January 2019. Clearly show the value of Cost of Sales and Gross Profit. b) Explain the difference between the straight-line method and the reducing...
The following trial balance was extracted from the ledger accounts of William Enterprise, a sole proprietor...
The following trial balance was extracted from the ledger accounts of William Enterprise, a sole proprietor as at 31 December 2019. Trial Balance as at 31 December 2019 DR CR GH¢ GH¢ Building, at cost 650,000 Office equipment at cost 135,000 Plant and Machinery 263,500 Purchases 248,000 Sales 500,000 Inventory 1 January 2019 27,500 Discount allowed 4,800 Returns inwards 3,200 Wages and Salaries 64,885 Rent 5,580 Insurance 6,000 Trade receivables 145,000 Trade payables 132,750 Bank overdraft 58,956 Cash in hand...
Question 1 The following balances have been extracted from the accounts of Peya, a sole trader,...
Question 1 The following balances have been extracted from the accounts of Peya, a sole trader, for the period ended 31 March 2020. N$ Sales 427,726 Carriage inwards 476 Wages and salaries 64,210 Carriage outwards 829 Purchases 302,419 Rent and rates 12,466 Heat and light 4,757 Stock at 1 April 2019 15,310 Drawings 21,600 Equipment at cost 102,000 Motor vehicles at cost 43,270 Provision for depreciation – equipment 22,250 – motor vehicles 8,920 Debtors 50,633 Creditors 41,792 Bank 3,295 cr...
“The following balances were taken from Jane's books who is a sole trader and operates a...
“The following balances were taken from Jane's books who is a sole trader and operates a catering business.                                                                                                                                                                           Jane's trial balance for the year to 30th June 2019 was as follows: Trial Balance Dr (£) Cr (£) Equipment at cost 42,000 Accumulated depreciation of equipment as at 1st July 2018 35,000 Inventory as at 1st July 2018 50,800 Debtors 32,000 Bank / cash 112,678 Creditors 23,027 Provision for doubtful debts as at 1st July 2018 1,280 Long term...
Below is a trial balance (extracted) of Kasturi Dewi Sdn Bhd. for the year ended         31...
Below is a trial balance (extracted) of Kasturi Dewi Sdn Bhd. for the year ended         31 December 2019: Debit (RM) Credit (RM) Account receivable 100,000 Allowance for impairment of Account receivable as at 1 January 2019 8,500 As at 31 December 2019, the following transactions are not yet recorded: One of the debtors was declared bankrupt by the Court. The amount due from the debtor is RM2,000. The company received RM1,500 from a debtor who was previously written off as...
The following trial balance was extracted from the books of MNZ Bhd as at 31 December...
The following trial balance was extracted from the books of MNZ Bhd as at 31 December 2019. MNZ Bhd Trial Balance as at 31 December 2019 Debit RM’000        Credit        RM’000 Turnover 440,000 Inventory at 1 January 2019 5,000 Trade receivables and payables 30,000 27,500 Purchases 200,000 Administrative salaries 49,000 Selling and distribution expenses 32,500 Other expenses 2,750 Investment 117,000 Cash in hand and bank 5,250 Director’s remuneration 17,000 Auditor’s fees 1,500 Ordinary share capital -200 million shares as...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT