The general ledger of ABC Company shows the following balances at December 31, 2019 before adjustments:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The general ledger of ABC Company shows the following balances at December 31, 2019 before adjustments: Cash Supplies Accounts receivable Prepaid insurance Equipment Accumulated depreciation--equipment Accounts payable Unearned revenue James Smith, capital James Smith, drawing Revenue Consulting fees Rent expense Salaries and wages expense Utilities expense Miscellaneous expense $9,515 7,785 6,750 1,950 109,000 38,500 2,900 5,000 178,870 99,050 92,000 35,400 10,250 37,200 250 120 Smith has asked you to develop a worksheet that will serve as a trial balance. Use the data above as input your model. Information for the adjusting entries is as follows: a. Depreciation on equipment is $800 for the accounting period. b. ABC purchased $5000 of office supplies during the period. At the end of the period $3,000 of supplies were on hand. c. Prepaid insurance had a $1,950 normal balance prior to adjustment. By year end $600 was unexpired. d. Services provided but unrecorded totaled $1,500. e. Accrued salaries but not paid at year-end are $2,000. f. A 6-month, $30,000 note was signed in November 1, 2019. The annual interest rate is 6%. Principal and interest are payable at the end of the 6th month. Interest was accrued for 2019. g. On 7/1/2019, ABC received $3,000 as a down payment from a client for the service in the coming 12 months. Required 1. As the accountant for ABC Company, you have been asked to prepare financial statements for the year. A file called WORKSHEET has been provided to assist you in this assignment. 2. The general ledger before adjustment and adjusting entries for the year ended 2019 are given above. Develop a worksheet that will serve as a trial balance in first tab "ABC Company Worksheet" in the Excel file). Account Title Cash Supplies Accounts receivable Prepaid insurance Equipment Accumulated depreciation-equipment Accounts payable Uneamed revenue James Smith, capital. James Smith, drawing Revenue Consulting fees Rent expense Salaries and wages expense Utilities expense Miscellaneous expense Depreciation expense Supplies expense Insurance expense Interest expense Interest payable Salaries and wages payable Totals Net income Totals Trial Balance Dr. Cr ABC Company Work Sheet For Year Ended December 31, 2019 Adjustments FORM1 FORM2 Dr. 0 Cr. 0 FORM3 FORM4 Adj. T/Balance Cr. Dr. FORM5 FORM6 Income Statement Cr. Dr. FORM7 0 0 FORM8 0 0 Balance Sheet Cr. Dr. FORM9 0 0 FORM10 0 0 What-if Analysis 7. Suppose you discover that an assistant in your department had misunderstood your instructions and had provided you with wrong information on two of the adjusting entries. Supplies consumed during the year should have been $3,000, and the insurance premiums expired at year end were $600. Make the corrections and provide your answer in the third tab "What-if analysis" in the Excel file. Financial Statements 8. Use the corrected worksheet to prepare an income statement, a statement of changes in owner's equity, and a statement of financial position in the fourth tab "Financial statements" in the Excel file. ABC Company Income Statement For Year Ended December 31, 2019 ABC Company Statement of Changes in Owner's Equity For Year Ended December 31, 2019 Beginning Capital, January 1, 2019 Add: Investment by Owner Net Income Less: Drawings Owner Ending Capital, December 31, 2019. ABC Company Statement of Financial Position December 31, 2019 The general ledger of ABC Company shows the following balances at December 31, 2019 before adjustments: Cash Supplies Accounts receivable Prepaid insurance Equipment Accumulated depreciation--equipment Accounts payable Unearned revenue James Smith, capital James Smith, drawing Revenue Consulting fees Rent expense Salaries and wages expense Utilities expense Miscellaneous expense $9,515 7,785 6,750 1,950 109,000 38,500 2,900 5,000 178,870 99,050 92,000 35,400 10,250 37,200 250 120 Smith has asked you to develop a worksheet that will serve as a trial balance. Use the data above as input your model. Information for the adjusting entries is as follows: a. Depreciation on equipment is $800 for the accounting period. b. ABC purchased $5000 of office supplies during the period. At the end of the period $3,000 of supplies were on hand. c. Prepaid insurance had a $1,950 normal balance prior to adjustment. By year end $600 was unexpired. d. Services provided but unrecorded totaled $1,500. e. Accrued salaries but not paid at year-end are $2,000. f. A 6-month, $30,000 note was signed in November 1, 2019. The annual interest rate is 6%. Principal and interest are payable at the end of the 6th month. Interest was accrued for 2019. g. On 7/1/2019, ABC received $3,000 as a down payment from a client for the service in the coming 12 months. Required 1. As the accountant for ABC Company, you have been asked to prepare financial statements for the year. A file called WORKSHEET has been provided to assist you in this assignment. 2. The general ledger before adjustment and adjusting entries for the year ended 2019 are given above. Develop a worksheet that will serve as a trial balance in first tab "ABC Company Worksheet" in the Excel file). Account Title Cash Supplies Accounts receivable Prepaid insurance Equipment Accumulated depreciation-equipment Accounts payable Uneamed revenue James Smith, capital. James Smith, drawing Revenue Consulting fees Rent expense Salaries and wages expense Utilities expense Miscellaneous expense Depreciation expense Supplies expense Insurance expense Interest expense Interest payable Salaries and wages payable Totals Net income Totals Trial Balance Dr. Cr ABC Company Work Sheet For Year Ended December 31, 2019 Adjustments FORM1 FORM2 Dr. 0 Cr. 0 FORM3 FORM4 Adj. T/Balance Cr. Dr. FORM5 FORM6 Income Statement Cr. Dr. FORM7 0 0 FORM8 0 0 Balance Sheet Cr. Dr. FORM9 0 0 FORM10 0 0 What-if Analysis 7. Suppose you discover that an assistant in your department had misunderstood your instructions and had provided you with wrong information on two of the adjusting entries. Supplies consumed during the year should have been $3,000, and the insurance premiums expired at year end were $600. Make the corrections and provide your answer in the third tab "What-if analysis" in the Excel file. Financial Statements 8. Use the corrected worksheet to prepare an income statement, a statement of changes in owner's equity, and a statement of financial position in the fourth tab "Financial statements" in the Excel file. ABC Company Income Statement For Year Ended December 31, 2019 ABC Company Statement of Changes in Owner's Equity For Year Ended December 31, 2019 Beginning Capital, January 1, 2019 Add: Investment by Owner Net Income Less: Drawings Owner Ending Capital, December 31, 2019. ABC Company Statement of Financial Position December 31, 2019
Expert Answer:
Answer rating: 100% (QA)
1 Worksheet Accounts Title Cash Supplies Accounts Receivable Prepaid Insurance Equipment Accumulated ... View the full answer
Related Book For
Financial Accounting
ISBN: 978-1259307959
4th edition
Authors: David Spiceland, Wayne Thomas, Don Herrmann
Posted Date:
Students also viewed these accounting questions
-
Jen and Berry's sells ice-creams from its factory-shop in Petone. There is a managing director (Maynard Dibble), a marketing manager (Mary Salman) and a production manager (Peter Pritchard). Maynard...
-
The completed financial statement columns of the worksheet for Woods Company Inc. are shown below. Instructions (a) Prepare an income statement, a retained earnings statement, and a classified...
-
Using the test model data, design a column chart that will show the components of cash flow from operating activities (net income etc.) Snanna Company reported a net income of $105.000 for the...
-
The Whitewater LLP is equally owned by three partners and has the following balance sheet at the end of the current tax year: Partner Petula is an active (i.e., general) partner retiring from the...
-
The accounting system for Dolment Co. reflected the following quality costs for 2012 and 2013: a. Which of these are costs of compliance, and which are costs of noncompliance? b. Calculate the...
-
When does price discrimination violate antitrust laws?
-
Which of the following procedures would help an auditor test for overstatements of accounts payable at the balance sheet date? a. Trace entries in the cash disbursements records to items in the...
-
Lindsay Electronics, a small manufacturer of electronic research equipment, has approximately 7,000 items in its inventory and has hired Joan Blasco- Paul to manage its inventory. Joan has determined...
-
Explore key security features implemented at the kernel level, such as mandatory access controls (e.g., SELinux, AppArmor) and address space layout randomization (ASLR). How do these features...
-
Refer to the information in Exercise 4.16. Suppose that Telemark-Kjemi uses the FIFO method instead of the weighted-average method in all its departments. The only changes under the FIFO method are...
-
O Discuss the existante o Solution of the unique following di fferential equation 1-1 da da dy * dr +lo y=Inx y ()= 2, y (w=0 e If y,= siex is u Solulion o f the DE S + e tana) -ay=o, 1E (0). da Find...
-
What is the name of the position for a person responsible for determining information needs of a business and designing a system to meet those needs? a. Chief information officer b. Controller c. IT...
-
Which of the following charts is generally considered the best way to show proportions? a. Bar charts b. Scatter plots c. Line charts d. Pie charts e. Treemaps
-
An article on bloomberg.com observes that GDP and GDI are both estimates of the size of the economy. . . . They should in theory add up to the same amount, but they apparently never do, even after...
-
A supply chain a. supplies jewelry chains. b. refers to the flow of materials, information, payments, and services. c. is similar in function and purpose to the value chain. d. does not apply to a...
-
Explain the difference between exploratory and explanatory visualizations. Why are their aims different from each other?
-
Homework (2D equilibrium - sample) G a B Two beams of lengths 4a (horizontal) and 2a (a = /4), both of distributed linear unit weight q [N/m], are connected at B by a cylindrical bearing (joint) as...
-
What mass of KBr (in grams) should you use to make 350.0 mL of a 1.30 M KBr solution?
-
Indicate whether the definition provided is true or false. True /False) Accounting can be defined as: 1. ----- The language of business. 2.------ A measurement/communication process. 3. ------A...
-
As a long-term investment at the beginning of the year, Acquisitions, Inc., purchased 3 million shares (30%) of Takeover Target's 10 million shares outstanding for $52 million. During the year,...
-
Sanders Inc. is a small brick manufacturer that uses the direct write-off method to account for uncollectible accounts. At the end of 2018, its balance for Accounts Receivable is $35,000. The company...
-
Determine the required cross-sectional area of member BC if the allowable normal stress is allow = 24 ksi. 800 lb 400 lb 6 ft 6 ft B 60 6 ft 30 -45' D 6 ft
-
The hangers support the joist in such a way that the four nails on each hanger can be assumed to support an equal portion of the load. If the joist is subjected to the loading shown, determine the...
-
The hangers support the joist in such a way that the four nails on each hanger can be assumed to support an equal portion of the load. Determine the smallest diameter of the nails at A and B to the...
Study smarter with the SolutionInn App