Financial & Managerial Accounting
13th Edition
ISBN: 9781285866307
Author: Carl Warren, James M. Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 4.24EX
To determine
Spreadsheet: A spreadsheet is a worksheet. It is used while preparing a financial statement. It is a type of form having multiple columns and it is used in the adjustment process. The use of a worksheet is optional for any organization. A worksheet can neither be considered as a journal nor a part of the general ledger.
To Enter: The adjustment data in the adjusted
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Financial & Managerial Accounting
Ch. 4 - Why do some accountants prepare an end-of-period...Ch. 4 - Describe the nature of the assets that compose the...Ch. 4 - Prob. 3DQCh. 4 - What types of accounts are referred to as...Ch. 4 - Why are closing entries required at the end of an...Ch. 4 - Prob. 6DQCh. 4 - What is the purpose of the post-closing trial...Ch. 4 - Prob. 8DQCh. 4 - Prob. 9DQCh. 4 - Recent fiscal years for several well-known...
Ch. 4 - Prob. 4.1APECh. 4 - Flow of accounts into financial statements The...Ch. 4 - Retained earnings statement Marcie Davies owns and...Ch. 4 - Prob. 4.2BPECh. 4 - Prob. 4.3APECh. 4 - Prob. 4.3BPECh. 4 - Closing entries After the accounts have been...Ch. 4 - Closing entries After the accounts have been...Ch. 4 - Accounting cycle From the following list of steps...Ch. 4 - Accounting cycle From the following list of steps...Ch. 4 - Prob. 4.6APECh. 4 - Prob. 4.6BPECh. 4 - Flow of accounts into financial statements The...Ch. 4 - Classifying accounts Balances for each of the...Ch. 4 - Financial statements from the end-of-period...Ch. 4 - Prob. 4.4EXCh. 4 - Income statement The following account balances...Ch. 4 - Prob. 4.6EXCh. 4 - Prob. 4.7EXCh. 4 - Prob. 4.8EXCh. 4 - Retained earnings statement; net loss Selected...Ch. 4 - Classifying assets Identify each of the following...Ch. 4 - Balance sheet classification At the balance sheet...Ch. 4 - Prob. 4.12EXCh. 4 - Prob. 4.13EXCh. 4 - Prob. 4.14EXCh. 4 - Closing entries Prior to its closing, Income...Ch. 4 - Prob. 4.16EXCh. 4 - Closing entries with net loss Mira Services Co....Ch. 4 - Identifying permanent accounts Which of the...Ch. 4 - Post-closing trial balance An accountant prepared...Ch. 4 - Steps in the accounting cycle Rearrange the...Ch. 4 - Working capital and current ratio The following...Ch. 4 - Prob. 4.22EXCh. 4 - Appendix 1 Completing an end-of-period spreadsheet...Ch. 4 - Prob. 4.24EXCh. 4 - Prob. 4.25EXCh. 4 - Completing an end-of-period spreadsheet Alert...Ch. 4 - Adjustment data on an end-of-period spreadsheet...Ch. 4 - Completing an end-of-period spreadsheet Alert...Ch. 4 - Financial statements and closing entries Lamp...Ch. 4 - Financial statements and closing entries Finders...Ch. 4 - T accounts, adjusting entries, financial...Ch. 4 - Ledger accounts, adjusting entries, financial...Ch. 4 - Complete accounting cycle For the past several...Ch. 4 - Financial statements and closing entries Last...Ch. 4 - Financial statements and dosing entries The Gorman...Ch. 4 - T accounts, adjusting entries, financial...Ch. 4 - Prob. 4.4BPRCh. 4 - Complete accounting cycle For the past several...Ch. 4 - Comprehensive problem 1 Kelly Pitney began her...Ch. 4 - Continuing Problem The unadjusted trial balance of...Ch. 4 - Prob. 4.1CPCh. 4 - Financial statements The following is an excerpt...Ch. 4 - Financial statements Assume that you recently...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- T accounts, adjusting entries, financial statements, and closing entries; optional end-of-period spreadsheet The unadjusted trial balance of La Mesa Laundry at August 31, 20Y5, 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, and Insurance Expense. 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 stockholders equity, and a balance sheet. During the year ended August 31, 20Y5, common stock of 3,000 was issued. 6. Journalize and post the closing entries. Identify the closing entries by Clos. 7. Prepare a post-closing trial balance.arrow_forwardThe 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_forwardLedger accounts, adjusting entries, financial statements, and closing entries; optional spreadsheet The unadjusted trial balance of Lakota Freight Co. at March 31, 20Y4, the end of the year, follows: The data needed to determine year-end adjustments are as follows: (a) Supplies on hand at March 31 are 7,500. (b) Insurance premiums expired during year are 1,800. (c) Depreciation of equipment during year is 8,350. (d) Depreciation of trucks during year is 6,200. (e) Wages accrued but not paid at March 31 are 600. Instructions 1. For each account listed in the trial balance, enter the balance in the appropriate Balance column of a four-column account and place a check mark () in the Posting Reference column. 2. (Optional) Enter the unadjusted trial balance on an end-of-period spreadsheet and complete the spreadsheet. Add the accounts listed in part (3) as needed. 3. Journalize and post the adjusting entries, inserting balances in the accounts affected. Record the adjusting entries on Page 26 of the journal. The following additional accounts from Lakota Freight Co.s chart of accounts should be used: Wages Payable, 22; Supplies Expense, 52; Depreciation ExpenseEquipment, 55; Depreciation ExpenseTrucks, 56; Insurance Expense, 57. 4. Prepare an adjusted trial balance. 5. Prepare an income statement, a statement of stockholders equity, and a balance sheet. During the year ended March 31, 20Y4, additional common stock of 6,000 was issued. 6. Journalize and post the closing entries. Record the closing entries on Page 27 of the journal. Indicate closed accounts by inserting a line in both Balance columns opposite the closing entry. 7. Prepare a post-closing trial balance.arrow_forward
- Adjustment for supplies Answer each of the following independent questions concerning supplies and the adjustment for supplies. a. The balance in the supplies account, before adjustment at the end of the year, is $3,500. What is the amount of the adjustment if the amount of supplies on hand at the end of the year is $1,100? b. The supplies account has a balance of $650. and the supplies expense account has a balance of $1,950 at the end of the first year of operations. What was the amount of supp lies purchased during the year?arrow_forwardT accounts, adjusting entries, financial statements, and closing entries; optional end-of-period spreadsheet The unadjusted trial balance of Epicenter Laundry at June 30, 20Y6, the end of the fiscal year, follows: The data needed to determine year-end adjustments are as follows: (a) Laundry supplies on hand at June 30 are 8,600. (b) Insurance premiums expired during the year are 5,700. (c) Depreciation of laundry equipment during the year is 6,500. (d) Wages accrued but not paid at June 30 are 1,100. Instructions 1. For each account listed in the unadjusted trial balance, enter the balance in a T account. Identify the balance as June 30 Bal. In addition, add T accounts for Wages Payable, Depreciation Expense, Laundry Supplies Expense, and Insurance Expense. 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 stockholders equity, and a balance sheet. During the year ended June 30, 20Y6, additional common stock of 7,500 was issued. 6. Journalize and post the closing entries. Identify the closing entries by Clos. 7. Prepare a post-closing trial balance.arrow_forwardContinuing Problem The unadjusted trial balance of PS Music as of July 31, 2016, along with the adjustment data for the two months ended July 31, 2016, are shown in Chapter 3. Based upon the adjustment data, the following adjusted trial balance was prepared: PS Music Adjusted Trial Balance July 31,2016 Debit Credit Balances Balances 9,945 Accounts Receivable............................................... 4,150 Supplies.......................................................... 275 Prepaid Insurance................................................. 2,475 Office Equipment................................................. 7,500 Accumulated DepreciationOffice Equipment...................... 50 Accounts Payable................................................. 8,350 Wages Payable.................................................... 140 Unearned Revenue................................................ 3,600 Common Stock................................................... 9,000 Dividends........................................................ 1,750 Fees Earned....................................................... 21.200 Music Expense.................................................... 3,610 Wages Expense................................................... 2,940 Office Rent Expense............................................... 2,550 Advertising Expense............................................... 1,500 Equipment Rent Expense.......................................... 1,375 Utilities Expense.................................................. 1,215 Supplies Expense. 925 Insurance Expense................................................ 225 Depreciation Expense............................................. 50 Miscellaneous Expense............................................ 1,855 42,340 42,340 Instructions 1. (Optional) Using the data from Chapter 3, prepare an end-of-period spreadsheet. 2. Prepare an income statement, a retained earnings statement, and a balance sheet. 3. Journalize and post the dosing entries. The retained earnings account is #33 and the income summary account is #34 in the ledger of PS Music. Indicate closed accounts by inserting a line in both Balance columns opposite the closing entry. 4. Prepare a post-closing trial balance.arrow_forward
- The unadjusted trial balance of PS Music as of July 31, 2018, along with the adjustment data for the two months ended July 31, 2018, are shown in Chapter 3. Based upon the adjustment data, the following adjusted trial balance was prepared: PS Music Adjusted Trial Balance July 31, 2018 Account No. Debit Balances Credit Balances Cash................................................. 11 9,945 Accounts Receivable................................... 12 4,150 Supplies.............................................. 14 275 Prepaid Insurance..................................... 15 2,475 Office Equipment..................................... 17 7,500 Accumulated DepreciationOffice Equipment.......... 18 50 Accounts Payable..................................... 21 8,350 Wages Payable........................................ 22 140 Unearned Revenue.................................... 23 3,600 Common Stock....................................... 31 9,000 Dividends............................................ 33 1,750 Fees Earned........................................... 41 21,200 Music Expense........................................ 54 3,610 Wages Expense....................................... 50 2,940 Office Rent Expense................................... 51 2,550 Advertising Expense................................... 55 1,500 Equipment Rent Expense.............................. 52 1,375 Utilities Expense...................................... 53 1,215 Supplies Expense...................................... 56 925 Insurance Expense.................................... 57 225 Depreciation Expense................................. 58 50 Miscellaneous Expense................................ 59 1,855 42,340 42,340 Instructions 1. (Optional) Using the data from Chapter 3, prepare an end-of-period spreadsheet. 2. Prepare an income statement, a retained earnings statement, and a balance sheet. 3. Journalize and post the closing entries. The retained earnings account is #33 and the income summary account is #34 in the ledger of PS Music. Indicate closed accounts by inserting a line in both Balance columns opposite the closing entry. 4. Prepare a post-dosing trial balance.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. 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_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. 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_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. 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_forwardAdjusting entries and adjusted trial balances Reece Financial Services Co., which specializes in appliance repair services, is owned and operated by Joni Reece. Reece Financial Services accounting clerk prepared the following unadjusted trial balance at July 31, 20Y9: The data needed to determine year-end adjustments are as follows: Depreciation of building for the year, 6,400. Depreciation of equipment for the year, 2,800. Accrued salaries and wages at July 31, 900. Unexpired insurance at July 31, 1,500. Fees earned but unbilled on July 31, 10,200. Supplies on hand at July 31, 615. 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 Expense Equipment; and Supplies Expense. 2. Determine the balances of the accounts affected by the adjusting entries, and prepare an adjusted trial balance.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
- Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCorporate Financial AccountingAccountingISBN:9781305653535Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Corporate Financial Accounting
Accounting
ISBN:9781305653535
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License