Question

In: Finance

Big Bang Co provided you with the trial balance as at 31st Dec 20X3 Dr Cr...

Big Bang Co provided you with the trial balance as at 31st Dec 20X3

Dr Cr

£000 £000

Land and Buildings at cost 5,000

Fixtures and Fittings at cost 1,980

Motor Vehicles at cost 200

Accum depn at 1/1/20X3 – Land 1,000

Accum depn at 1/1/20X3 – F&F 260

Accum depn at 1/1/20X3 – MV 80

Overdraft 55

Revenue 2,090

Purchases 360

Inventory 1/1/20X3 30

Trade payables 75

Trade receivables 120

Operating expenses 280

Allowance for receivables 5

Retained earnings at 1/1/20X3 3,905

Equity share capital 500 7,970 7,970

Additional information

 Depreciation is treated as an operating expense, a full year is
charged in the year of acquisition and none in the year of disposal,
following rates apply: Building 5% pa straight line basis; Fixtures
and fittings 20% pa reducing balance; Motor vehicles 25% pa reducing
balance.

 At the end of the year fixtures and fittings at a cost of £120,000
were scrapped. The accumulated depreciation associated with these
assets were £90,000.

At the end of the year motor vehicles with a cost of £70,000 were sold
for £10,000, the accumulated depreciation on these vehicles was
£50,000. The sales proceeds have not yet been received and have not
been accounted for.

 Of the land and buildings figure £3m relates to land.

 The allowance for receivables is to be maintained at 5% of the
closing receivables balance.

 Closing inventory is £35,000

 An electricity bill for £3,000 covering the quarter ended 31st
December 20X3 was received on 2nd January 20X4. This has not been
included in the accounts.

 Public liability insurance of £18,000 for the 12 months to 30th
April 20X4 was paid on 1st May 20X3. Tax to be accrued for the period
is £180,000.

Required

Prepare statement of profit and loss and the statement of financial
position for Big Bang Co as at 31st December 20X3

Solutions

Expert Solution

Adjustments
1 Land & Buildings
Total of Land & Buildings          5,000,000
Less
Value of Land          3,000,000
Value of Buildings          2,000,000
1 Depreciation on Buildings - Straight Line 100,000
2 Fixtures & Fittings A/c
Date Description Dr Amount Date Particulars Cr.Amount
To By
01-Jan To Opening Balance          1,980,000 31-Dec Sale of Fixtures         120,000
31-Dec By Balance c/d 1,860,000
Total          1,980,000 Total     1,980,000
1/1/ To Balance b/d          1,860,000
Accumulated Depreciation - Fixtures & Fittings A/c
Date Description Dr Amount Date Particulars Cr.Amount
To By
31-Dec Depreciation on Sale of Fixtures 90,000 01-Jan By Opening Balance         260,000
31-Dec By Balance c/d 263,000 31-Dec By Income Statement ( Depreciation for the year on closing balance)           93,000
Total 353,000 Total         353,000
1/1/ T0 Balance b/d         263,000
Sale of Fixture & Fittings A/c
Date Description Dr Amount Date Particulars Cr.Amount
To By
31-Dec Fixtures A/c 120,000 31-Dec By Accum Dep A/c           90,000
31-Dec By Sale (Sold as Scrap) -  
31-Dec By Income Statement (P& L A/c) -Loss on Sale           30,000
Total 120,000 Total         120,000
3 Motor Vehicles A/c
Date Description Dr Amount Date Particulars Cr.Amount
To By
01-Jan To Opening Balance 200,000 31-Dec Sale of Motor Vehicle           70,000
31-Dec By Balance c/d         130,000
Total 200,000 Total         200,000
1/1/ To Balance b/d 130,000
Accumulated Depreciation - Motor Vehicles A/c
Date Description Dr Amount Date Particulars Cr.Amount
To By
31-Dec Depreciation - Sale of Motor Vehicle          50,000.00 01-Jan By Balance b/d     80,000.00
31-Dec By Balance c/d          62,500.00 31-Dec By Income Statement (Depreciation for the year on closing balance)     32,500.00
Total        112,500.00 Total 112,500.00
1/1/ T0 Balance b/d     62,500.00
Sale of Motor Vehicles A/c
Date Description Dr Amount Date Particulars Cr.Amount
To By
31-Dec Motor Vehicles A/c 70,000 31-Dec By Accum Dep A/c           50,000
31-Dec By Revenue A/c - Sale           10,000
31-Dec By Income Statement (P& L A/c) -Loss on Sale           10,000
Total 70,000 Total           70,000
Revenue A/c
Date Description Dr Amount Date Particulars Cr.Amount
To By
31-Dec Motor Vehicles A/c 10,000 31-Dec Balance     2,090,000
31-Dec By Income Statement ( P & L A/c)          2,080,000
Total          2,090,000 Total     2,090,000
1/1/20X4 By Balance b/c     2,080,000
4 Trade Receivables A/c
Date Description Dr Amount Date Particulars Cr.Amount
To By
31-Dec Balance B/d              120,000
Dec-31 By Balance c/d         120,000
Total 120,000 Total         120,000
01-Jan To Balance b/d 120,000
5 Allowance for Trade Receivables A/c
Date Description Dr Amount Date Particulars Cr.Amount
To By
01-Jan By Balance B/d 5,000
Dec 31 To Income Statement 1,000
Dec 31 By Balance c/d 6,000    
Total 6,000 Total 6,000
1/1/20X4 By Balance b/d 6,000
6 Insurance Prepaid Account
Date Description Dr Amount Date Particulars Cr.Amount
To By
May 1, 20X3 Bank (Assumption: Not included in Overdraft) 18,000 Dec 31, 20x3 Insurance Expense Account           12,000
    Dec 31, 20x3 By Balance c/d 6,000
Total 18,000 Total           18,000
Jan 1, 20X4 To Balance B/d 6,000    
Insurance Expense Account
Date Description Dr Amount Date Particulars Cr.Amount
To By
Dec 31, 20x3 Insurance Prepaid Account 12,000 Dec 31, 20X3 By Income Statement ( P & L A/c)           12,000
       
Total 12,000 Total           12,000
1/1/ By Balance b/d    
7 Electricity Account Accrued (Outstanding) Account
Date Description Dr Amount Date Particulars Cr.Amount
To By
Dec 31, 20X3 Balance c/d 3,000 Dec 31, 20X3 Electricity Expense Account 3,000
       
Total 3,000 Total 3,000
1/1/ By Balance b/d              3,000
7 Electricity Expense Account
Date Description Dr Amount Date Particulars Cr.Amount
To By
Dec 31, 20X3 Electricity Expense Outstanding Account 3,000 Dec 31, 20X3 By Income Statement ( P & L A/c) 3,000
       
Total 3,000 Total 3,000
1/1/ By Balance b/d    
8 Taxation Expense Accrued (Outstanding/ Provision) Account
Date Description Dr Amount Date Particulars Cr.Amount
To By
Dec 31, 20X3 Balance c/d              180,000 Dec 31, 20X3 Taxation expense         180,000
       
Total 180,000 Total         180,000
1/1/ By Balance b/d         180,000
7 Taxation Expense Account
Date Description Dr Amount Date Particulars Cr.Amount
To By
Dec 31, 20X3 Taxation Expense Outstanding Account              180,000 Dec 31, 20X3 By Income Statement ( P & L A/c)         180,000
       
Total 180,000 Total         180,000
1/1/ By Balance b/d         180,000

Notes and Assumptions:

1. The sale of motor vehicles for Pound 10,000 should normally disclosed seprately, and not clubbed with Product or service revenue account. In these workings, it has been clubbed for convenience purposes. Sale Account shown in the workings should read Revenue Account.

2. As the sale proceeds of motor vehicles has not been received, or accounted for, as at the date of the Balance sheet, the sale and accrual have been done accordingly. On receipt of sale proceeds, the Casbh/Bank Account will be debitted, and Sale/ Revenue Account credit.

3. It is assumed that Public Liability insurance payment has not been taken into consideration. The same is now reflected,and the Overdraft account adjusted for the Insurance Payment.


Related Solutions

Below is the trial balance of Rod Ropes Ltd, year ending 31st May 2020: DR CR...
Below is the trial balance of Rod Ropes Ltd, year ending 31st May 2020: DR CR £ £ 10% Debenture, 2030 100,000 Debenture Interest 8,000 Inventory (stock) at (01/06/19) 210,000 Administration expenses 23,000 Purchase returns 2,000 Marketing expenses 11,500 Bank 13,200 Sales 392,000 Purchases 252,000 Discounts Allowed 5,300 Discounts Received 3,000 Provision for Doubtful Debtors (at 01/06/19) 3,000 Non-current Assets at costs: Motor Vehicles 50,000 Fixtures and Fittings 12,000 Freehold land 50,000 Accumulated Depreciation (at 01/06/19): Motor Vehicles 10,000 Fixtures...
Balance Sheets as on 31st Dec 2017 & 31st Dec 2018 31st Dec 2017 31st Dec...
Balance Sheets as on 31st Dec 2017 & 31st Dec 2018 31st Dec 2017 31st Dec 2018 Current Assets: Cash $65,000 $80,000 Accounts Receivables $2,500,000 $4,000,000 Inventory $1,500,000 $2,500,000 Total Current Assets $4,065,000 $6,580,000 Fixed Assets: Buildings $2,000,000 $3,000,000 Furniture & office equipment $1,100,000 $1,400,000 Good Will $6,100,000 $5,700,000 Patents $1,000,000 $1,100,000 Total Fixed Assets $10,200,000 $11,200,000 Total Assets $14,265,000 $17,780,000 Liabilities: Current Liabilities: Accounts Payable $1,200,000 $1,350,000 Notes Payable $500,000 $550,000 Interest Payable $110,000 $125,000 Total Current Liabilities $1,810,000...
Selected worksheet data for jane Freeman Company presented below: Trial Balance Adjusted Trial Balance Dr Cr...
Selected worksheet data for jane Freeman Company presented below: Trial Balance Adjusted Trial Balance Dr Cr Dr Cr Account Receivable ? 34000 Prepaid Insurance 26000 18000 Supplies 7000 ? Accumulated Depreciation 12000 ? Salaries payable ? 5000 Service Revenue 88000 95000 Insurance Expenses ? Depreciation Expenses 10000 Supplies Expenses 4000 Salaries Expenses ? 49000 Instructions: A)Fill in the missing amounts Trial Balance Adjusted Trial balance Dr Cr Dr Cr Account Receivable ? 34000 Prepaid Insurance 26000 18000 Supplies 7000 ?...
A partial trial balance of Indigo Corporation is as follows on December 31, 2021. Dr. Cr....
A partial trial balance of Indigo Corporation is as follows on December 31, 2021. Dr. Cr. Supplies $2,900 Salaries and wages payable $1,500 Interest Receivable 5,100 Prepaid Insurance 95,700 Unearned Rent 0 Interest Payable 15,400 Additional adjusting data: 1. A physical count of supplies on hand on December 31, 2021, totaled $1,200. 2. Through oversight, the Salaries and Wages Payable account was not changed during 2021. Accrued salaries and wages on December 31, 2021, amounted to $4,400. 3. The Interest...
A partial trial balance of Novak Corporation is as follows on December 31, 2021. Dr. Cr....
A partial trial balance of Novak Corporation is as follows on December 31, 2021. Dr. Cr. Supplies $2,600 Salaries and wages payable $1,300 Interest Receivable 5,000 Prepaid Insurance 89,600 Unearned Rent 0 Interest Payable 14,900 Additional adjusting data: 1. A physical count of supplies on hand on December 31, 2021, totaled $1,000. 2. Through oversight, the Salaries and Wages Payable account was not changed during 2021. Accrued salaries and wages on December 31, 2021, amounted to $4,700. 3. The Interest...
A partial trial balance of Pharoah Corporation is as follows on December 31, 2021. Dr. Cr....
A partial trial balance of Pharoah Corporation is as follows on December 31, 2021. Dr. Cr. Supplies $2,600 Salaries and wages payable $1,600 Interest Receivable 5,100 Prepaid Insurance 90,400 Unearned Rent 0 Interest Payable 15,300 Additional adjusting data: 1. A physical count of supplies on hand on December 31, 2021, totaled $1,000. 2. Through oversight, the Salaries and Wages Payable account was not changed during 2021. Accrued salaries and wages on December 31, 2021, amounted to $4,200. 3. The Interest...
A partial trial balance of Larkspur Corporation is as follows on December 31, 2021. Dr. Cr....
A partial trial balance of Larkspur Corporation is as follows on December 31, 2021. Dr. Cr. Supplies $2,500 Salaries and wages payable $1,500 Interest Receivable 5,100 Prepaid Insurance 95,100 Unearned Rent 0 Interest Payable 15,400 Additional adjusting data: 1. A physical count of supplies on hand on December 31, 2021, totaled $1,000. 2. Through oversight, the Salaries and Wages Payable account was not changed during 2021. Accrued salaries and wages on December 31, 2021, amounted to $4,300. 3. The Interest...
URGENT Following are Balance Sheet of a Limited Co. as on 31st Dec.2013 and 2014. (15...
URGENT Following are Balance Sheet of a Limited Co. as on 31st Dec.2013 and 2014. Balance Sheet Liabilities 2013 2014 Assets 2013 2014 Share Capital 61,000 74,000 Plant 45,000 43,000 Reserves 13,000 15,500 Building 50,950 48,000 Creditors 28,000 24,000 Stock 20,500 18,800 Bank O/D 18,000 0 Debtors 20,000 16,200 Prov for Tax 8,000 8,500 Cash 150 180 Profit & Loss 8,600 8,800 Bank 0 2,100 Goodwill 0 2,520 1,36,600 1,30,800 1,36,600 1,30,800 Considering the following information, calculate funds from operations,...
Question One: The following data extracted from the trial balance of ABC Company on Dec 31st...
Question One: The following data extracted from the trial balance of ABC Company on Dec 31st 2020: Financial Statement item Amount Financial Statement Item Amount Buildings 1,200,000 Motor vehicles – Accumulated depreciations 180,000 Cash 320,000 Depreciation expenses 630,000 Sales revenues 16,000,000 Purchases returns and allowance 96,000 Sales commission 120,000 Interest expenses 1,150,000 Travel expense - sale 75,000 Gains on sale of lands 455,000 Equipment 840,000 Notes payable 2,890,000 Account payable 420,000 Equipment – accumulated depreciation 440,000 Goodwill 3,000,000 Impairment loss...
Provide the closing entry for the following trial balance at year end: DR.                   CR. Cash          &n
Provide the closing entry for the following trial balance at year end: DR.                   CR. Cash                             $5,275 A/R                               $1,850 Equipment                   $56,480 A/P                                                       $12,350 Owners Capital                                     $70,405 Owners Withdrawals    $6,000 Revenue                                              $85,000 Cost of Goods Sold        $25,000 Salaries                        $50,000           Payroll Taxes                $8,900 Utilities                        $13,800
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT