With all of the transactions for the October-December 2021 period recorded, the company is facing their...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
With all of the transactions for the October-December 2021 period recorded, the company is facing their first year-end at December 31. The following additional facts are collected for use in making adjusting entries prior to preparing financial statements for the company's first three months: a. The December 31 inventory count of computer supplies shows $850 still available. b. Three months have expired since the 12-month insurance premium was paid in advance. c. As of December 31, Lyn Addie has not been paid for five days of work at $150 per day. d. The computer system is expected to have a five-year life with no salvage value. e. The office equipment is expected to have a ten-year life with no salvage value. f. Three of the four months' prepaid rent has expired. g. A count of physical inventory at December 31 resulted in an ending value of $ 7,425. h. Management estimates that 10% of ending Accounts Receivable balance will be uncollectable. i. Interest on the short-term note payable will be paid at maturity (March 2, 2022). Please perform the following tasks: 1- Prepare the Adjusting Journal Entries at December 31, 2021 based on the information provided in a. through i. above and record them on the 2021 Trial Balance' worksheet and post them to the General Ledger. 2- Post the adjusting entries to the General Ledger and extend that data to compute the Adjusted Trial Balance on the 2021 Trial Balance worksheet. 3- From the Adjusted Trial Balance, prepare the four fundamental financial statements at December 31, 2021: a. Income Statement b. Statement of Retained Earnings c. Balance Sheet d. Statement of Cash Flows 4- Prepare the Closing Journal Entries, record them on the '2021 Trial Balance' worksheet and post the Closing Journal entries to the general ledger at December 31, 2021. 5- Extend closing entries to the post-closing trial balance columns on '2021 Trial Balance' worksheet. Important Note: If necessary, update your General Ledger to ensure balances agree with these check figures. You may do this by using Dec 31, 2021 as the date, Correct Balance as the item, and enter the correct balance in the balance column 3. (2 points) Use the additional information provided in the beginning of this document to prepare Adjusting Journal Entries at December 31, 2021. These entries should be recorded in your 2021 General Journal and then posted to the General Ledger. 4. (3 points) Record your adjusting entries to the 12-31-21 Trial Balance Excel worksheet and prepare the Adjusted Trial Balance as of December 31, 2021. You may want to create a formula in the adjusted balance column for each account. This formula should be such that if amounts in unadjusted column and/or the adjusting entry column changed, the adjusted balance would change. 5. (5 points) Prepare the following financial statements: a. Income statement for the three months ended December 31, 2021. b. Statement of retained earnings for the three months ended December 31, 2021. c. Balance sheet as of December 31, 2021. Note: Statements may be prepared in worksheet in your Excel file or manually and uploaded as a PDF to Canvas. 6. (2 points) Prepare and record closing entries in your 2021 General Journal and then post those entries to the General Ledger. 7. (3 points) Complete the 12-31-21 Trial Balance Excel spreadsheet through the closing process: a. Record closing entries prepared earlier in the closing entries' columns. b. You may want to use formulas to complete the post-closing trial balance. (These numbers should (must) agree with your General Ledger balances.) 8. (4 points) To ensure numbers have been carried over properly use the SUM formula to total your columns (2 points). Debit/credit columns must balance! Find and credit errors so they balance (2 points). The Chart of Accounts (modeled after the sample Chart of Accounts in handout) established by Computer Solutions is as follows: No. 101 Account Cash 106.1 A/R - Alex's Engineering Co. 106.2 A/R-Wildcat Services 106.3 A/R-West Leasing 106.4 A/R-IFM Co. 106.5 A/R-Liu Corp. 106.6 A/R-Gomez Co. 106.7 A/R-Delta Co. 106.8 A/R -KC, Inc. 106.9 107 119 126 128 131 163 164 Accumulated depreciation-Office equipment 167 Computer equipment 168 Accumulated depreciation-Computer equipment 201 203 210 236 240 245 A/R -Dream, Inc. Allowance for Doubtful Accounts Merchandise inventory Computer supplies Prepaid insurance Prepaid rent Office equipment Accounts payable Interest Payable Wages payable Unearned computer services revenue Short-Term Notes Payable Notes Payable No. Account 307 311 318 319 403 413 414 415 502 612 613 623 Wages expense 633 Interest expense 637 Insurance expense 640 Rent expense 652 Computer supplies expense 655 Advertising expense 656 Bad Debt Expense 676 Mileage expense 677 684 705 808 Common stock Paid In Capital in excess of par value Retained earnings Dividends Computer services revenue Sales Sales returns and allowances Sales discounts Cost of goods sold Depreciation expense-Office equipment Depreciation expense-Computer equipment Miscellaneous expenses Repairs expense-Computer Gain on Sale of Equipment Loss on Sale of Equipment 901 Income Summary No. 101 106.1 106.2 A/R -Wildcat Services 106.3 106.4 106.5 106.6 106.7 A/R-Delta Co 106.8 A/R-KC, Inc. 106.9 A/R -Dream, Inc. 107 Allowance for Doubtful Accounts 119 Merchandise inventory 126 128 131 163 164 Accumulated depreciation-Office equipment 167 Computer equipment 168 Accumulated depreciation-Computer equipment 201 203 210 236 240 245 Notes Payable 307 Common stock. 318 Retained earnings 319 Dividends Cash A/R- Alex's Engineering Co. A/R-West Leasing A/R-IFM Co. A/R -Liu Corp. A/R -Gomez Co. Computer supplies Prepaid insurance Prepaid rent Office equipment Accounts payable Interest Payable Wages payable Unearned computer services revenue Short-Term Notes Payable 403 Computer services revenue 413 414 415 502 Cost of goods sold 612 Depreciation expense-Office equipment 613 Depreciation expense-Computer equipment 623 633 637 Sales Sales returns and allowances Sales discounts Wages Expense Interest Expense Insurance Expense Rent Expense Computer Supplies Expense Advertising Expense Bad Debt Expense Mileage Expense Account 640 652 655 656 676 677 Miscellaneous Expenses 684 705 808 901 Repairs Expense-Computer Gain on Sale of Equipment Loss on Sale of Equipment Income Summary Totals unadjusted trial balance Debit Credit 103,550 3,000 2,750 4,200 3,200 7,861 3,775 4,380 4,500 5,000 39,000 7,900 600 43 6,650 4,200 2,400 576 400 1,305 205,290 1,100 3,000 50,000 102,000 38,540 10,650 205,290 With all of the transactions for the October-December 2021 period recorded, the company is facing their first year-end at December 31. The following additional facts are collected for use in making adjusting entries prior to preparing financial statements for the company's first three months: a. The December 31 inventory count of computer supplies shows $850 still available. b. Three months have expired since the 12-month insurance premium was paid in advance. c. As of December 31, Lyn Addie has not been paid for five days of work at $150 per day. d. The computer system is expected to have a five-year life with no salvage value. e. The office equipment is expected to have a ten-year life with no salvage value. f. Three of the four months' prepaid rent has expired. g. A count of physical inventory at December 31 resulted in an ending value of $ 7,425. h. Management estimates that 10% of ending Accounts Receivable balance will be uncollectable. i. Interest on the short-term note payable will be paid at maturity (March 2, 2022). Please perform the following tasks: 1- Prepare the Adjusting Journal Entries at December 31, 2021 based on the information provided in a. through i. above and record them on the 2021 Trial Balance' worksheet and post them to the General Ledger. 2- Post the adjusting entries to the General Ledger and extend that data to compute the Adjusted Trial Balance on the 2021 Trial Balance worksheet. 3- From the Adjusted Trial Balance, prepare the four fundamental financial statements at December 31, 2021: a. Income Statement b. Statement of Retained Earnings c. Balance Sheet d. Statement of Cash Flows 4- Prepare the Closing Journal Entries, record them on the '2021 Trial Balance' worksheet and post the Closing Journal entries to the general ledger at December 31, 2021. 5- Extend closing entries to the post-closing trial balance columns on '2021 Trial Balance' worksheet. Important Note: If necessary, update your General Ledger to ensure balances agree with these check figures. You may do this by using Dec 31, 2021 as the date, Correct Balance as the item, and enter the correct balance in the balance column 3. (2 points) Use the additional information provided in the beginning of this document to prepare Adjusting Journal Entries at December 31, 2021. These entries should be recorded in your 2021 General Journal and then posted to the General Ledger. 4. (3 points) Record your adjusting entries to the 12-31-21 Trial Balance Excel worksheet and prepare the Adjusted Trial Balance as of December 31, 2021. You may want to create a formula in the adjusted balance column for each account. This formula should be such that if amounts in unadjusted column and/or the adjusting entry column changed, the adjusted balance would change. 5. (5 points) Prepare the following financial statements: a. Income statement for the three months ended December 31, 2021. b. Statement of retained earnings for the three months ended December 31, 2021. c. Balance sheet as of December 31, 2021. Note: Statements may be prepared in worksheet in your Excel file or manually and uploaded as a PDF to Canvas. 6. (2 points) Prepare and record closing entries in your 2021 General Journal and then post those entries to the General Ledger. 7. (3 points) Complete the 12-31-21 Trial Balance Excel spreadsheet through the closing process: a. Record closing entries prepared earlier in the closing entries' columns. b. You may want to use formulas to complete the post-closing trial balance. (These numbers should (must) agree with your General Ledger balances.) 8. (4 points) To ensure numbers have been carried over properly use the SUM formula to total your columns (2 points). Debit/credit columns must balance! Find and credit errors so they balance (2 points). The Chart of Accounts (modeled after the sample Chart of Accounts in handout) established by Computer Solutions is as follows: No. 101 Account Cash 106.1 A/R - Alex's Engineering Co. 106.2 A/R-Wildcat Services 106.3 A/R-West Leasing 106.4 A/R-IFM Co. 106.5 A/R-Liu Corp. 106.6 A/R-Gomez Co. 106.7 A/R-Delta Co. 106.8 A/R -KC, Inc. 106.9 107 119 126 128 131 163 164 Accumulated depreciation-Office equipment 167 Computer equipment 168 Accumulated depreciation-Computer equipment 201 203 210 236 240 245 A/R -Dream, Inc. Allowance for Doubtful Accounts Merchandise inventory Computer supplies Prepaid insurance Prepaid rent Office equipment Accounts payable Interest Payable Wages payable Unearned computer services revenue Short-Term Notes Payable Notes Payable No. Account 307 311 318 319 403 413 414 415 502 612 613 623 Wages expense 633 Interest expense 637 Insurance expense 640 Rent expense 652 Computer supplies expense 655 Advertising expense 656 Bad Debt Expense 676 Mileage expense 677 684 705 808 Common stock Paid In Capital in excess of par value Retained earnings Dividends Computer services revenue Sales Sales returns and allowances Sales discounts Cost of goods sold Depreciation expense-Office equipment Depreciation expense-Computer equipment Miscellaneous expenses Repairs expense-Computer Gain on Sale of Equipment Loss on Sale of Equipment 901 Income Summary No. 101 106.1 106.2 A/R -Wildcat Services 106.3 106.4 106.5 106.6 106.7 A/R-Delta Co 106.8 A/R-KC, Inc. 106.9 A/R -Dream, Inc. 107 Allowance for Doubtful Accounts 119 Merchandise inventory 126 128 131 163 164 Accumulated depreciation-Office equipment 167 Computer equipment 168 Accumulated depreciation-Computer equipment 201 203 210 236 240 245 Notes Payable 307 Common stock. 318 Retained earnings 319 Dividends Cash A/R- Alex's Engineering Co. A/R-West Leasing A/R-IFM Co. A/R -Liu Corp. A/R -Gomez Co. Computer supplies Prepaid insurance Prepaid rent Office equipment Accounts payable Interest Payable Wages payable Unearned computer services revenue Short-Term Notes Payable 403 Computer services revenue 413 414 415 502 Cost of goods sold 612 Depreciation expense-Office equipment 613 Depreciation expense-Computer equipment 623 633 637 Sales Sales returns and allowances Sales discounts Wages Expense Interest Expense Insurance Expense Rent Expense Computer Supplies Expense Advertising Expense Bad Debt Expense Mileage Expense Account 640 652 655 656 676 677 Miscellaneous Expenses 684 705 808 901 Repairs Expense-Computer Gain on Sale of Equipment Loss on Sale of Equipment Income Summary Totals unadjusted trial balance Debit Credit 103,550 3,000 2,750 4,200 3,200 7,861 3,775 4,380 4,500 5,000 39,000 7,900 600 43 6,650 4,200 2,400 576 400 1,305 205,290 1,100 3,000 50,000 102,000 38,540 10,650 205,290
Expert Answer:
Related Book For
Fundamental Accounting Principles
ISBN: 978-0078110870
20th Edition
Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta
Posted Date:
Students also viewed these accounting questions
-
An analysis of the transactions for S. Moses & Co., was presented in E. Instructions Prepare and income statement and a retained earnings statement for August and a statement of financial position at...
-
Prior to preparing financial statements at the end of FY 2014, it is necessary to record depreciation expenses for the year for governmental activities at the government-wide level. Based on general...
-
In making adjusting entries at the end of its accounting period, Gomez Consulting failed to record $1,600 of insurance coverage that had expired. This $1,600 cost had been initially debited to the...
-
From the information below, 1. List of the working capital accounts. 2. Calculate the net working capital. Buildings $100,000 Cash ... 5,000 Trade receivables ... 25,000 Trade and other payables .....
-
Determine the minimum thickness of a soap film (n = 1.330) that will result in constructive interference of (a) The red H line ( = 656.3 nm); (b) The blue H line ( = 434.0 nm).
-
Which one of the following correctly represents a firm's after-tax cost of debt? a.yield to maturity x (1 - tax rate) b.current yield x (1 - tax rate) c.current yield x tax rate d.coupon rate x (1 -...
-
Inland Corporation issued 30,000 shares of \(\$ 5\) par value common stock at \(\$ 15\) per share and 8,000 shares of \(\$ 50\) par value, eight percent preferred stock at \(\$ 85\) per share. Later,...
-
You are scheduling production of your popular Rustic Coffee Table. The table requires a top, four legs, 1/8 gallon of stain, 1/16 gallon of glue, 2 short braces between the legs and 2 long braces...
-
Evaluate the integral by making the given substitution. x 3 ( 6 + x 4 ) 5 dx , u = 6 + x 4
-
The 450-room Hotel Fernando is a four-star full-service hotel in San Petresco. It is highly regarded among both locals and tourists. Its service standards and ameni- ties complement its exquisite...
-
MARS Company, a small high-end retailer of fashion goods, has a store in Seattle and an on-line site. Demand for on-line store is currently satisfied from its own warehouse. Consider the...
-
BabyGear is a retailer of high quality baby products in the European market. Their best selling product is E-Chupetin65, a pacifier enabled with sensors and AI technology that sends a warning to your...
-
1*5*9*13 1*5*9*13*17 Find a formula,, for the general term of the sequence. Is the sequence convergent or divergent? Explain your answer? (15 1*5*9 1*5*9 124
-
May I recieve some help with this. It would be very much appreciated. Jeff Dougherty, Chairman of the Board of Mil & Mod Incorporated, wishes to know how a change in capital structure would affect...
-
assume you are explaining to a customer how to identify ammunition cartridges. Explain the purpose and use of a headstamp. What are the elements found on cartridges? Provide some examples of the...
-
An amount of $1,000 is invested on 22 December 2020 at12% pacompounded quarterly. Calculate the interest (I) earned between 22 December 2023 and 22 December 2026. Give your answer in dollars and...
-
Describe the transformations on the logarithmic function g ( x ) = 2 1 l o g [ 7 1 ( x 2 ) ] + 9 Write the equation of a logarithmic function that has been vertically stretched by 4, reflected in the...
-
Modify the counter from Exercise 5.44 such that the counter will either increment by 4 or load a new 32-bit value, D, on each clock edge, depending on a control signal Load. When Load = 1, the...
-
How do step-wise costs and curvilinear costs differ?
-
Describe the procedures involving the use of copies of a companys sales invoices as a sales journal.
-
The following three separate situations require adjusting journal entries to prepare financial statements as of April 30. For each situation, present both the April 30 adjusting entry and the...
-
Look up three not-for-profit organization's Web sites and find a recent annual report or IRS filing. Many charities are also listed at http://www.charitynavigator.org. a. How much did each of the...
-
Refer to the information in Problem P11-43. a. Assume the net realizable values of the joint products are as follows: Allocate the joint cost incurred in March on the basis of net realizable value....
-
Read Joseph McCafferty's article entitled "Misgivings" at CFO.com (January 2007); https://www.cfo.com/accounting-tax/2007/01/misgivings/ (accessed 12/10/19). a. Discuss your thoughts about...
Study smarter with the SolutionInn App