Concept explainers
Preparing a worksheet, financial statements, and closing entries
The unadjusted
Adjustment data at December 31, 2016:
a. Unearned Revenue earned during the year, $700.
b. Office Supplies on hand, $2,000.
c.
d. Accrued Salaries Expense, $5, 000.
e. Accrued Service Revenue, $6,000.
Requirements
1. Prepare a worksheet for Farmer Investment Advisers at December 31, 2016.
2. Prepare the income statement, the statement of
3. Prepare closing entries.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Horngren's Financial & Managerial Accounting, The Financial Chapters Plus MyAccountingLab with Pearson eText -- Access Card Package (5th Edition)
- The unadjusted trial balance of La Mesa Laundry at August 31, 2016, the end of the fiscal year, follows: The data needed to determine year-end adjustments are as follows: a. Wages accrued but not paid at August 31 are 2,200. b. Depreciation of equipment during the year is 8,150. c. Laundry supplies on hand at August 31 are 2,000. d. Insurance premiums expired during the year are 5,300. Instructions 1. For each account listed in the unadjusted trial balance, enter the balance in a T account. Identify the balance as Aug. 31 Bal. In addition, add T accounts for Wages Payable, Depreciation Expense, Laundry Supplies Expense, Insurance Expense, and Income Summary. 2. (Optional) Enter the unadjusted trial balance on an end-of-period spreadsheet and complete the spreadsheet. Add the accounts listed in part (1) as needed. 3. Journalize and post the adjusting entries. Identify the adjustments by Adj. and the new balances as Adj. Bal. 4. Prepare an adjusted trial balance. 5. Prepare an income statement, a statement of owners equity (no additional investments were made during the year), and a balance sheet. 6. Journalize and post the closing entries. Identify the closing entries by Clos. 7. Prepare a post-closing trial balance.arrow_forwardElite Realty acts as an agent in buying, selling, renting, and managing real estate. The unadjusted trial balance on March 31, 2019, follows: The following business transactions were completed by Elite Realty during April 2019: Apr. 1. Paid rent on office for month, 6,500. 2.Purchased office supplies on account, 2,300. 5.Paid insurance premiums, 6,000. 10.Received cash from clients on account, 52,300. 15.Purchased land for a future building site for 200,000, paying 30,000 in cash and giving a note payable for the remainder. 17.Paid creditors on account, 6,450. 20.Returned a portion of the office supplies purchased on April 2, receiving full credit for their cost, 325. 23.Paid advertising expense, 4,300. Enter the following transactions on Page 19 of the two-column journal: 27.Discovered an error in computing a commission; received cash from the salesperson for the overpayment, 2,500. 28.Paid automobile expense (including rental charges for an automobile), 1,500. 29.Paid miscellaneous expenses, 1,400. 30.Recorded revenue earned and billed to clients during the month, 57,000. 30.Paid salaries and commissions for the month, 11,900. 30.Withdrew cash for personal use, 4,000. 30.Rented land purchased on April 15 to local merchants association for use as a parking lot in May and June, during a street rebuilding program; received advance payment of 10,000. Instructions 1. Record the April 1, 2019, balance of each account in the appropriate balance column of a four-column account, write Balance in the item section, and place a check mark () in the Posting Reference column. 2. Journalize the transactions for April in a two-column journal beginning on Page 18. Journal entry explanations may be omitted. 3. Post to the ledger, extending the account balance to the appropriate balance column after each posting. 4. Prepare an unadjusted trial balance of the ledger as of April 30, 2019. 5. Assume that the April 30 transaction for salaries and commissions should have been 19,100. (a) Why did the unadjusted trial balance in (4) balance? (b) Journalize the correcting entry. (c) Is this error a transposition or slide?arrow_forwardValley Realty acts as an agent in buying, selling, renting, and managing real estate. The unadjusted trial balance on July 31, 2019, follows: The following business transactions were completed by Valley Realty during August 2019: Aug. 1. Purchased office supplies on account, 3,150. 2.Paid rent on office for month, 7,200. 3.Received cash from clients on account, 83,900. 5.Paid insurance premiums, 12,000. 9.Returned a portion of the office supplies purchased on August 1, receiving full credit for their cost, 400. Analyzing Transactions Aug. 17. Paid advertising expense, 8,000. 23.Paid creditors on account, 13,750. Enter the following transactions on Page 19 of the two-column journal: 29.Paid miscellaneous expenses, 1,700. 30.Paid automobile expense (including rental charges for an automobile), 2,500. 31.Discovered an error in computing a commission during July; received cash from the salesperson for the overpayment, 2,000. 31.Paid salaries and commissions for the month, 53,000. 31.Recorded revenue earned and billed to clients during the month, 183,500. 31.Purchased land for a future building site for 75,000, paying 7,500 in cash and giving a note payable for the remainder. 31.Withdrew cash for personal use, 1,000. 31.Rented land purchased on August 31 to a local university for use as a parking lot during football season (September, October, and November); received advance payment of 5,000. Instructions 1. Record the August 1 balance of each account in the appropriate balance column of a four-column account, write Balance in the item section, and place a check mark () in the Posting Reference column. 2. Journalize the transactions for August in a two-column journal beginning on Page 18. Journal entry explanations may be omitted. 3. Post to the ledger, extending the account balance to the appropriate balance column after each posting. 4. Prepare an unadjusted trial balance of the ledger as of August 31, 2019. 5. Assume that the August 31 transaction for Cindy Getmans cash withdrawal should have been 10,000. (a) Why did the unadjusted trial balance in (4) balance? (b) Journalize the correcting entry. (c) Is this error a transposition or slide?arrow_forward
- The trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as follows: Adjustment information is as follows: a. Supplies on hand as of June 30, 2013, 450. b. Insurance premiums that expired during the year, 2,420. c. Depreciation on equipment during the year, 1,500. d. Included in the rent expense of 30,000 is 1,200 that is prepaid for July 2013. e. Salaries accrued but not paid at June 30, 2013, 1,440. f. Merchandise inventory on June 30, 2013, 68,864. Open the file P2WORK from the website for this book at cengagebrain.com. Enter the formulas in the appropriate cells on the worksheet. Then enter the adjusting amounts in columns E and G. Also, in column D or F, insert the letter corresponding to the adjusting entry (ae). (Note: Not all textbooks handle the change in inventory as an adjustment. Use the method for handling inventory that is prescribed in your textbook.) Column A is frozen on the screen to assist you in completing requirement 3.arrow_forwardThe trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as follows: Adjustment information is as follows: a. Supplies on hand as of June 30, 2013, 450. b. Insurance premiums that expired during the year, 2,420. c. Depreciation on equipment during the year, 1,500. d. Included in the rent expense of 30,000 is 1,200 that is prepaid for July 2013. e. Salaries accrued but not paid at June 30, 2013, 1,440. f. Merchandise inventory on June 30, 2013, 68,864. As the accountant for Sports Connection, you have been asked to prepare adjusting entries and financial statements to complete the accounting cycle for the year. A worksheet called P2WORK has been provided to assist you in this assignment. As you review this worksheet, it should be noted that columns H and I will automatically change when you enter values in columns E and G.arrow_forwardThe trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as follows: Adjustment information is as follows: a. Supplies on hand as of June 30, 2013, 450. b. Insurance premiums that expired during the year, 2,420. c. Depreciation on equipment during the year, 1,500. d. Included in the rent expense of 30,000 is 1,200 that is prepaid for July 2013. e. Salaries accrued but not paid at June 30, 2013, 1,440. f. Merchandise inventory on June 30, 2013, 68,864. Complete the income statement and balance sheet by entering formulas in columns J, K, L, and M that reference the appropriate cells in column H or I. Net income will be automatically calculated at the bottom of the income statement and balance sheet columns. Check to be sure that these numbers are the same. Enter your name in cell A1. Save the completed file as P2WORK3. Print the worksheet. Also print your formulas using landscape orientation and fit-to-1 page scaling. Check figure: Net income (cell J34), 37,902.arrow_forward
- The trial balance of Sports Connection at June 30, 2013, the end of the current fiscal year, is as follows: Adjustment information is as follows: a. Supplies on hand as of June 30, 2013, 450. b. Insurance premiums that expired during the year, 2,420. c. Depreciation on equipment during the year, 1,500. d. Included in the rent expense of 30,000 is 1,200 that is prepaid for July 2013. e. Salaries accrued but not paid at June 30, 2013, 1,440. f. Merchandise inventory on June 30, 2013, 68,864. In the space provided below, prepare an income statement, a capital statement (statement of owners equity), and a balance sheet. Use the corrected worksheet (P2WORK4) as a basis for your work. Assume no additional owner investments were made during the year.arrow_forwardReece Financial Services Co., which specializes in appliance repair services, is owned and operated by Joni Reece. Reece Financial Services Co.s accounting clerk prepared the following unadjusted trial balance at July 31, 2016: The data needed to determine year-end adjustments are as follows: a. Depreciation of building for the year, 6,400. b. Depreciation of equipment for the year, 2,800. c. Accrued salaries and wages at July 31, 900. d. Unexpired insurance at July 31, 1,500. e. Fees earned but unbilled on July 31, 10,200. f. Supplies on hand at July 31, 615. g. Rent unearned at July 31, 300. Instructions 1. Journalize the adjusting entries using the following additional accounts: Salaries and Wages Payable; Rent Revenue; Insurance Expense; Depreciation ExpenseBuilding; Depreciation ExpenseEquipment; and Supplies Expense. 2. Determine the balances of the accounts affected by the adjusting entries and preparean adjusted trial balance.arrow_forward
- Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning