Ten Column Worksheet as at 30 June 2013 – Verona Spaceships Pty Ltd Trial Balanc
ID: 2460220 • Letter: T
Question
Ten Column Worksheet as at 30 June 2013 – Verona Spaceships Pty Ltd
Trial Balance
Adjustments
Trading Acc
P&L Account
Balance Sheet
Dr
Cr
Dr
Cr
Dr
Cr
Dr
Cr
Dr
Cr
Inventory
20,000
Accounts Receivable
13,400
Allowance for doubtful debts
340
Bank
10,600
Land and Buildings
87,200
Furniture and Fittings
16,800
Acc Depreciation Furniture and fittings
5,100
Motor Vehicle
70,860
Acc Depreciation MV
28,000
Accounts Payable
9,020
GST Clearing(GST Payable)
3,000
Mortgage
21,000
Capital
136,000
Drawings
9,800
Sales
97,000
Rental income
3,600
Interest income
800
Cost of goods sold
36,000
Advertising
2,400
Insurance
5,000
Lease expenses
1,300
Postage
400
Salaries
28,900
Bad Debt
1,200
303,860
303,860
Ten Column Worksheet as at 30 June 2013 – Verona Spaceships Pty Ltd
Trial Balance
Adjustments
Trading Acc
P&L Account
Balance Sheet
Dr
Cr
Dr
Cr
Dr
Cr
Dr
Cr
Dr
Cr
Inventory
20,000
Accounts Receivable
13,400
Allowance for doubtful debts
340
Bank
10,600
Land and Buildings
87,200
Furniture and Fittings
16,800
Acc Depreciation Furniture and fittings
5,100
Motor Vehicle
70,860
Acc Depreciation MV
28,000
Accounts Payable
9,020
GST Clearing(GST Payable)
3,000
Mortgage
21,000
Capital
136,000
Drawings
9,800
Sales
97,000
Rental income
3,600
Interest income
800
Cost of goods sold
36,000
Advertising
2,400
Insurance
5,000
Lease expenses
1,300
Postage
400
Salaries
28,900
Bad Debt
1,200
303,860
303,860
Question 1 Verona Spaceships Pty Ltd maintains inventory on a perpetual basis and advises you of the following: The following adjustments are required to be completed for the year ended 30 June 2013 Further Bad debt of $2,000 GST $0 (exempt from GST) to be written off. Allowance (Provision) for doubtful debts to be increased to 5% of Accounts Receivable balance. Annual insurance premium of $3,600 (GST exclusive) was paid on February 1, 2013. Account for the amount that has been prepaid at 30 June 2013. Salaries and wages to be accrued at 30 June 2013 is $9,800 Rental Income received in Advance $440 Depreciation for the year (not recorded in the accounts) was · . Motor Vehicle $15,500 Furniture and Fittings $4,500 Required From the above information and the Trial Balance (already posted to the 10 column worksheet on the following page): ial Balance (already posted to the 1. Post all necessary balance day adjustments to the Ten Column Worksheet. 2. Balance the worksheet to calculate the Gross and Net Profit amounts. 3. Prepare a Classified Income Statement for the year ended 30 June 2013 4. Prepare a Classified Balance Sheet as at 30 June 2013 Note - the Perpetual Inventory system is used.Explanation / Answer
Trial Balance (Adjusted) (as on June 30, 2013) S.No Account Head Debit Credit 1 Inventory 20000 2 Account receivable 15400 3 Allowance for doubtfull debt 2670 4 Bank 7000 5 Land & Buildings 87200 6 Furniture and fittings 16800 7 Acc dep (F & F) 9600 8 Motor vehicle 70860 9 Acc. Dep -MV 43500 10 Account Payble 9020 11 GST payble 3000 12 Mortgage 21000 13 Capital 136000 14 Drawings 9800 15 Sales 97000 16 Rental Income 3160 17 Interest Income 800 18 Cost of goods sold 36000 19 Advertising 2400 20 Insurance 6500 21 Lease expenses 1300 22 Postage 400 23 Salaries 38700 24 Bad Debt 1530 25 Prepaid Insurance 2100 26 Outstanding salaries & wages 9800 27 Rent received in advance 440 28 Depreciation expense 20000 Totals 335990 335990 Trading and P/L Account (as on June 30, 2013) Particulars Amount Particulars Amount To Cost of goods sold 36000 By Sales 97000 To Gross Profit c/d 61000 97000 97000 By gross profit b/f 61000 To Advertisement 2400 By rental Income 3160 To Insurance 6500 By Interest Income 800 To lease expense 1300 To postage 400 To salaries 38700 To bad debts 1530 To depreciation expense 20000 To Net Profit/loss carried to Balance sheet -5870 64960 64960 Balance Sheet (as on June 30, 2013) Liabilities Amount Assets Amount Account payble 9020 Inventory 20000 GST payble 3000 Account receivable 15400 Mortgage 21000 Less: Allowance for bad debt -2670 Capital 136000 Bank 7000 Add Net Profit/(Loss) -5870 Land & Buildings 87200 Less Drawings -9800 Furniture and fittings 16800 Salaries accrued 9800 Less : Acc. Dep -9600 Rent received in advance 440 Motor vehicle 70860 Less : Acc. Dep -43500 Prepaid Insurance 2100 163590 163590
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.