The worksheet is an internal document that exists outside the journals and ledgers. It is often...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 journalize 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: ▪ Office Furniture owned by the business: original purchase price was $8,000, estimated useful life was 5 years, and estimated residual value was $1,000 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. • Office Equipment owned by the business: original purchase price was $53,000, estimated useful life was 11 years, and estimated residual value was $3,000 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. ▪ Electricity expense for the month of June is estimated to be $828. The water usage for the month of June is estimated to be $211. Sales staff work every single day during the week including weekends and are not paid until the end of each two weeks. Wages were last paid up to and including June 28. Wages incurred after that day (from June 29 to June 30 inclusive) are estimated to have been $660 per day. • Interest expense incurred during the month of June but not yet paid to EastPac Bank for the bank loan is $245. . Interest earned from short-term investments in MRMC Bank for the month of June is $120. ■ Office supplies totalling $2,336 are still on hand at June 30. . 2 months 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. Acct. No. Account Name 100 Cash 102 Short-term Investments 110 ARC-Accounts Receivable Control 112 Interest Receivable 120 Merchandise Inventory 130 Office Supplies 140 Prepaid Rent 141 Prepaid Advertising 142 Prepaid Insurance 150 Office Furniture 151 Accum Depn: Office Furniture 160 Office Equipment 161 Accum Depn: Office Equipment. 210 APC Accounts Payable Control 220 Wages Payable 221 Electricity Payable 222 Water Payable 225 Interest Payable 250 Bank Loan Payable 300 Common Stock sojusted tha Balance Debit Credit 96484 24000 4438 74065 4408 5000 12000 3500 8000 53000 2100 23106 1230 49000 55000 Adjustments Debit 120 Credit 660 828 211 245 Adjusted Triatr Balance Debit Credit 96484 24000 4438 120 74065 2336 8000 53000 12:30 660 828 211 245 49000 55000 Income Statement Debit Credit 74065 59993 Balance Sheet Debit Credit 96484 24000 4438 120 59993 8000 53000 1230 660 828 211 245 49000 55000 250 Bank Loan Payable 300 Common Stock 301 Retained Earnings 400 Sales Revenue 401 Sales Returns and Allowances 402 Sales Discounts 403 Interest Revenue 500 Purchases 501 Purchase Returns and Allowances 502 Purchase Discounts 511 Advertising Expense 516 Wages Expense 540 Rent Expense 541 Electricity Expense 542 Water Expense 543 Insurance Expense 544 Office Supplies Expense 545 Salary Expense 560 Depn Expense: Office Furniture 561 Depn Expense: Office Equipment 571 Interest Expense 572 Admin Expense-Bank Charges 1157 173 3210 10510 6600 10 49000 55000 126025 48722 232 1055 85 120 1157 173 6600 10 49000 55000 126025 48722 352 1055 85 1157 173 6600 48722 352 1055 85 49000 55000 126025 502 Purchase Discounts 511 Advertising Expense 516 Wages Expense 540 Rent Expense 541 Electricity Expense 542 Water Expense 543 Insurance Expense 544 Office Supplies Expense 545 Salary Expense 560 Depn Expense: Office Furniture 561 Depn Expense: Office Equipment 571 Interest Expense 572 Admin. Expense - Bank Charges Submit answers Totals 10510 6600 10 85 6600 10 85 Net income or loss Totals 6600 www. 85 10 Account No. Name 100 Cash 102 Short-term Investments 110 ARC-Accounts Receivable Control 112 Interest Receivable 120 Merchandise Inventory 130 Office Supplies 140 Prepaid Rent 141 Prepaid Advertising 142 Prepaid Insurance 150 Office Furniture 151 Accum Depn: Office Furniture 160 Office Equipment 161 Accum Depn: Office Equipment 210 APC-Accounts Payable Control 220 Wages Payable Debit ($) 27,917 24,000 9,183 74,065 4,408 5,000 12,000 3,500 8,000 53,000 Credit ($) ............ Works 2,10 23,10 14,842 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 journalize 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: ▪ Office Furniture owned by the business: original purchase price was $8,000, estimated useful life was 5 years, and estimated residual value was $1,000 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. • Office Equipment owned by the business: original purchase price was $53,000, estimated useful life was 11 years, and estimated residual value was $3,000 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. ▪ Electricity expense for the month of June is estimated to be $828. The water usage for the month of June is estimated to be $211. Sales staff work every single day during the week including weekends and are not paid until the end of each two weeks. Wages were last paid up to and including June 28. Wages incurred after that day (from June 29 to June 30 inclusive) are estimated to have been $660 per day. • Interest expense incurred during the month of June but not yet paid to EastPac Bank for the bank loan is $245. . Interest earned from short-term investments in MRMC Bank for the month of June is $120. ■ Office supplies totalling $2,336 are still on hand at June 30. . 2 months 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. Acct. No. Account Name 100 Cash 102 Short-term Investments 110 ARC-Accounts Receivable Control 112 Interest Receivable 120 Merchandise Inventory 130 Office Supplies 140 Prepaid Rent 141 Prepaid Advertising 142 Prepaid Insurance 150 Office Furniture 151 Accum Depn: Office Furniture 160 Office Equipment 161 Accum Depn: Office Equipment. 210 APC Accounts Payable Control 220 Wages Payable 221 Electricity Payable 222 Water Payable 225 Interest Payable 250 Bank Loan Payable 300 Common Stock sojusted tha Balance Debit Credit 96484 24000 4438 74065 4408 5000 12000 3500 8000 53000 2100 23106 1230 49000 55000 Adjustments Debit 120 Credit 660 828 211 245 Adjusted Triatr Balance Debit Credit 96484 24000 4438 120 74065 2336 8000 53000 12:30 660 828 211 245 49000 55000 Income Statement Debit Credit 74065 59993 Balance Sheet Debit Credit 96484 24000 4438 120 59993 8000 53000 1230 660 828 211 245 49000 55000 250 Bank Loan Payable 300 Common Stock 301 Retained Earnings 400 Sales Revenue 401 Sales Returns and Allowances 402 Sales Discounts 403 Interest Revenue 500 Purchases 501 Purchase Returns and Allowances 502 Purchase Discounts 511 Advertising Expense 516 Wages Expense 540 Rent Expense 541 Electricity Expense 542 Water Expense 543 Insurance Expense 544 Office Supplies Expense 545 Salary Expense 560 Depn Expense: Office Furniture 561 Depn Expense: Office Equipment 571 Interest Expense 572 Admin Expense-Bank Charges 1157 173 3210 10510 6600 10 49000 55000 126025 48722 232 1055 85 120 1157 173 6600 10 49000 55000 126025 48722 352 1055 85 1157 173 6600 48722 352 1055 85 49000 55000 126025 502 Purchase Discounts 511 Advertising Expense 516 Wages Expense 540 Rent Expense 541 Electricity Expense 542 Water Expense 543 Insurance Expense 544 Office Supplies Expense 545 Salary Expense 560 Depn Expense: Office Furniture 561 Depn Expense: Office Equipment 571 Interest Expense 572 Admin. Expense - Bank Charges Submit answers Totals 10510 6600 10 85 6600 10 85 Net income or loss Totals 6600 www. 85 10 Account No. Name 100 Cash 102 Short-term Investments 110 ARC-Accounts Receivable Control 112 Interest Receivable 120 Merchandise Inventory 130 Office Supplies 140 Prepaid Rent 141 Prepaid Advertising 142 Prepaid Insurance 150 Office Furniture 151 Accum Depn: Office Furniture 160 Office Equipment 161 Accum Depn: Office Equipment 210 APC-Accounts Payable Control 220 Wages Payable Debit ($) 27,917 24,000 9,183 74,065 4,408 5,000 12,000 3,500 8,000 53,000 Credit ($) ............ Works 2,10 23,10 14,842
Expert Answer:
Answer rating: 100% (QA)
Shivatal You have not closed Sales Revenue alc Interest Revenue Ale Cos... View the full answer
Related Book For
Horngrens Accounting
ISBN: 978-0134674681
12th edition
Authors: Tracie L. Miller-nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these accounting questions
-
When is the general journal used in a manual accounting information system? Provide some examples of transactions that would be recorded in the general journal.
-
When is the general journal used in a manual accounting information system? Provide some examples of transactions that would be recorded in the general journal.
-
Pooh Inc. constructed a machine at a total cost of $70 million. Construction was completed at the end of 2010 and the machine was placed in service at the beginning of 2011. The machine was being...
-
Glass bottles can be either recycled (crushed and re-melted) or reused. The market will tend to choose the cheapest path. What factors will tend to affect the relative cost of these options? Is the...
-
Telly, age 38, has a $140,000 IRA with Blue Mutual Fund. He has read good things about the management of Green Mutual Fund, so he opens a Green Fund IRA. Telly asked for and received his balance from...
-
The Toyota Camry is one of the best-selling cars in North America. The cost of a previously owned Camry depends on many factors, including the model year, mileage, and condition. To investigate the...
-
Table B. 22 contains data on 1916 team performance for Major League Baseball. Use all possible regressions to build a model for this data. Perform a residual analysis on the final model and comment...
-
You are the accountant for Rolla Inc. (Rolla). For each of the following situations, prepare the necessary adjusting entries. Also show the related transactional entries and the date the entries...
-
On January 1, 2021, Entity A Company acquired all the assets and assumed all the liabilities of Entity B Company and merged Entity B into Entity A. In exchange for the net assets of Entity B, Entity...
-
During 2001, many European markets for mobile phones reached saturation. Because of this, mobile phone operators started to shift their focus from growth and market share to cut-ting costs. One way...
-
ATT Inc. is developing a new type of cordless phone that would be sold for $50 per unit. The unit material cost is $ 10 and unit labor cost is $15. The R&D costs incurred so far for the prototype are...
-
Compute the convolution sum of the following pairs of sequences: (a) \(x(n)=\left\{\begin{array}{ll}1, & 0 \leq n \leq 4 \\ 0, & \text { otherwise }\end{array} \quad ight.\) and \(\quad h(n)=...
-
A sample of size 64 has standard deviation \(s=3.6\). Approximately how large a sample is needed so that a \(99 \%\) confidence interval will specify the mean to within \(\pm 1.0\) ?
-
Extend the AVL tree implementation discussed in this chapter to support node deletion. In particular, modify the DeleteItem method of the TreeType class and the helper function Delete (originally...
-
Write a Matlab program to plot the samples of the solutions of the difference equations in Exercise 1.9 from \(n=0\) to \(n=20\). Exercise 1.9 Find one solution for each of the difference equations...
-
Suppose we want to process the continuous-time signal \[x_{\mathrm{a}}(t)=3 \cos (2 \pi 1000 t)+7 \sin (2 \pi 1100 t)\] using a discrete-time system. The sampling frequency used is 4000 samples per...
-
Have leadership scholars, over the past 50 years, managed to produce a clear, cookie-cutter profile of the ideal leader through more than 1,000 studies
-
Express mass density in kg/m3 and weight density in lb/ft3. 1. Find the mass density of a chunk of rock of mass 215 g that displaces a volume of 75.0 cm3 of water. 2. A block of wood is 55.9 in. x...
-
Give five examples of manufacturing overhead costs. Why are they considered indirect costs?
-
Jackson Corporation has the following amounts as of December 31, 2018. Total assets ............................ $ 55,250 Total liabilities ........................ 22,750 Total equity...
-
How does a manufacturing company calculate unit product cost?
-
What stimulates the heart to beat?
-
Oxygen moves from the alveoli in the lungs into the bloodstream through the process of (a) active transport. (b) endocytosis. (c) diffusion. (d) exocytosis.
-
The cells that carry oxygen to body tissues are (a) red blood cells. (b) white blood cells. (c) platelets. (d) hemoglobin.
Study smarter with the SolutionInn App