ACC201 Financial Accounting: Intermaweb Computer Worksheet Solution

This assignment provides a detailed solution to a worksheet problem for Intermaweb Computer, a fictional technology boutique, focusing on the completion of the one-month accounting cycle. The worksheet includes unadjusted trial balance, adjustments, adjusted trial balance, income statement, and balance sheet columns. The adjustments cover various aspects such as depreciation of cash registers and store fixtures, accrued expenses for water, electricity, wages, and interest, as well as adjustments for prepaid rent, advertising, and insurance. The solution demonstrates how to calculate and record these adjustments in the worksheet, ultimately leading to the preparation of financial statements. Desklib offers a range of study tools and resources, including solved assignments and past papers, to support students in their academic endeavors.

08/02/2018 Worksheet
https://www.perdisco.com/elms/qsam/html/qsam.aspx 1/4
Your progress
Completed: 74% (approximately)
Remaining pages will take: up to 5.5 hours
The time frames we provide are a guide only. It may
take you more or less time to complete each step.
Your grading
Your grading outcome (still in progress)
Awarded Total
Points (prior to this page) 879 1,019
Points (on this page) 79 84
Points (after this page) − 178
Total 958 1,281
Manual Accounting Practice Set
Technology Boutique, Australasian Edition 3
Feedback: Worksheet
This is a feedback page. Please review this page carefully because later pages in this practice set build on the feedback provided here. After you have reviewed your feedback
page, click Continue at the bottom of this page to move on to the next page of your practice set.
Now that you have completed the end of month posting procedure, you are asked to complete the worksheet for Intermaweb Computer.
The worksheet is an internal document that exists outside the journals and ledgers. It is often used in the manual accounting system to help record adjusting entries and
prepare financial statements. After you have prepared the worksheet, in the next section of the practice set you will be asked to use the completed worksheet to help journalise
and post adjusting entries to general ledger. You will also use this worksheet to assist you in preparing the financial statements for Intermaweb Computer in a later section of
this practice set.
The details of the end of month adjustments for June are as follows:
Cash Registers owned by the business: original purchase price was $7,000, estimated useful life was 6 years, and estimated residual value was $1,500 at the end of the
useful life. Depreciation is calculated on a monthly basis using the straight line method. The monthly depreciation charge is calculated as the yearly depreciation expense
divided by the number of months in a year.
Store Fixtures owned by the business: original purchase price was $39,000, estimated useful life was 11 years, and estimated residual value was $5,500 at the end of
the useful life. Depreciation is calculated on a monthly basis using the straight line method. The monthly depreciation charge is calculated as the yearly depreciation
expense divided by the number of months in a year.
The water usage for the month of June is estimated to be $115.
The estimated electricity payable as at the end of June is $408.
Sales staff work every single day during the week including weekends and are paid on a weekly basis. Wages were last paid up to and including 24 June. Wages incurred
after that day (from 25 June to 30 June inclusive) are estimated to have been $1,870 per day.
Interest expense incurred during the month of June but not yet paid to BitiBank for the bank loan is $220.
Interest earned from short-term investments in MRMC Bank for the month of June is $125.
Office supplies totalling $1,780 are still on hand at 30 June.
15 days of rent remained pre-paid at the start of June.
3 months of advertising remained pre-paid at the start of June.
5 months of insurance remained pre-paid at the start of June.
When calculating the portion of prepayments that expire during the month of June, you are asked to assume that an equal amount of expense is incurred per month.
Additionally, a stocktake revealed that the balance of inventory on hand as at 30 June is equal to the closing balance of the Inventory account. This means there is no adjusting
entry required for inventory shrinkage.
Instructions for worksheet
Complete all columns in the worksheet. To do this, you need to use the unadjusted account balances provided in the general ledger. You are also required to calculate the
end of month adjustments for June and enter them into the worksheet before completing the remaining columns. Note that not all boxes in each column of the worksheet will
need to be filled.
Remember to enter all answers to the nearest whole dollar.
Back-On-Track functionality
Please note that any answers from previous pages carried through onto this page (either on the page or in a popup information page) have been reset, if necessary,
to the correct answers. Your particular answers from previous pages are no longer shown.
If you want to print this page, please read and follow the special printing information to ensure you can print the worksheet in full.
(Q=820.worksheetQuestion)
Intermaweb Computer
Worksheet

08/02/2018 Worksheet
https://www.perdisco.com/elms/qsam/html/qsam.aspx 2/4
As at 30/06/2018
Acct.
No. Account Name
Unadjusted Trial
Balance Adjustments Adjusted Trial
Balance Income Statement Balance Sheet
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
100 Cash at Bank 145222 145222 145222
102 Short-term Investments 25000 25000 25000
110 ARC - Accounts Receivable Control 164668 164668 164668
112 Interest Receivable 125 125 125
120 Inventory 76810 76810 76810
130 Office Supplies 2144 364 1780 1780
135 GST Outlays 21133 21133 21133
140 Prepaid Rent 3600 2400 1200 1200
141 Prepaid Advertising 6000 2000 4000 4000
142 Prepaid Insurance 3250 650 2600 2600
150 Cash Registers 7000 7000 7000
151 Accum Depn: Cash Registers 1757 76 1833 1833
160 Store Fixtures 39000 39000 39000
161 Accum Depn: Store Fixtures 11420 254 11674 11674
210 APC - Accounts Payable Control 17094 17094 17094
220 Wages Payable 11220 11220 11220
221 Electricity Payable 55 408 463 463
222 Water Payable 110 115 225 225
225 Interest Payable 220 220 440 440
240 GST Collections 53828 53828 53828
250 Bank Loan Payable 44000 44000 44000
300 Share Capital 50000 50000 50000
301 Retained Earnings 223302 223302 223302
400 Sales Revenue 346570 346570 346570
401 Sales Returns and Allowances 3600 3600 3600
402 Discount Received 300 300 300
403 Interest Revenue 826 125 1951 1951
500 Cost of Sales 199850 199850 199850
511 Advertising Expense 2000 2000 2000
516 Wages Expense 45134 11220 56354 56354
540 Rent Expense 2400 2400 2400
541 Electricity Expense 408 408 408
542 Water Expense 115 115 115
543 Insurance Expense 650 650 650
544 Office Supplies Expense 364 364 364
545 Salary Expense 6600 6600 6600
560 Depn Expense: Cash Registers 76 76 76
561 Depn Expense: Store Fixtures 254 254 254
571 Interest Expense 220 220 220
572 Bank Charges 11 11 11

08/02/2018 Worksheet
https://www.perdisco.com/elms/qsam/html/qsam.aspx 3/4
573 Discount Allowed 460 460 460
Totals 749482 749782 17832 17832 761900 761900 273362 347821 488538 414079
Profit/loss 74459 74459
Totals 347821 347821 488538 488538
Feedback
Intermaweb Computer
Worksheet
As at 30/06/2018
Acct. No. Account Name
Unadjusted Trial
Balance Adjustments Adjusted Trial
Balance Income Statement Balance Sheet
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
100 Cash at Bank 145,222 145,222 145,222
102 Short-term Investments 25,000 25,000 25,000
110 ARC - Accounts Receivable Control 164,668 164,668 164,668
112 Interest Receivable 125 125 125
120 Inventory 76,810 76,810 76,810
130 Office Supplies 2,144 364 1,780 1,780
135 GST Outlays 21,133 21,133 21,133
140 Prepaid Rent 3,600 2,400 1,200 1,200
141 Prepaid Advertising 6,000 2,000 4,000 4,000
142 Prepaid Insurance 3,250 650 2,600 2,600
150 Cash Registers 7,000 7,000 7,000
151 Accum Depn: Cash Registers 1,757 76 1,833 1,833
160 Store Fixtures 39,000 39,000 39,000
161 Accum Depn: Store Fixtures 11,420 254 11,674 11,674
210 APC - Accounts Payable Control 17,094 17,094 17,094
220 Wages Payable 11,220 11,220 11,220
221 Electricity Payable 55 353 408 408
222 Water Payable 110 115 225 225
225 Interest Payable 220 220 440 440
240 GST Collections 53,828 53,828 53,828
250 Bank Loan Payable 44,000 44,000 44,000
300 Share Capital 50,000 50,000 50,000
301 Retained Earnings 223,302 223,302 223,302
400 Sales Revenue 346,570 346,570 346,570
401 Sales Returns and Allowances 3,600 3,600 3,600
402 Discount Received 300 300 300
403 Interest Revenue 826 125 951 951
500 Cost of Sales 199,850 199,850 199,850
511 Advertising Expense 2,000 2,000 2,000
516 Wages Expense 45,134 11,220 56,354 56,354
540 Rent Expense 2,400 2,400 2,400
541 Electricity Expense 353 353 353
542 Water Expense 115 115 115
543 Insurance Expense 650 650 650
544 Office Supplies Expense 364 364 364
545 Salary Expense 6,600 6,600 6,600
560 Depn Expense: Cash Registers 76 76 76
561 Depn Expense: Store Fixtures 254 254 254
571 Interest Expense 220 220 220
572 Bank Charges 11 11 11
573 Discount Allowed 460 460 460
Totals 749,482 749,482 17,777 17,777 761,845 761,845 273,307 347,821 488,538 414,024

08/02/2018 Worksheet
https://www.perdisco.com/elms/qsam/html/qsam.aspx 4/4
Profit/loss 74,514 74,514
Totals 347,821 347,821 488,538 488,538
Manual Accounting Practice Set
Technology Boutique, Australasian Edition 3 (VTA3q)
© 2009 - 2014 Perdisco / latin /. v., learn thoroughly
http://www.perdisco.com
Terms Of Use | Privacy Policy | Thursday, February 08, 2018, 23:36