repare an adjusted trial balance. If an amount Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; Optional Spreadsheet The unadjusted trial balance of Recessive Interiors at January 31, 2019, the end of the year, follows: Recessive InteriorsUnadjusted Trial BalanceJanuary 31, 2019   Account No. Debit Balances Credit Balances Cash   11 13,100       Supplies   13 8,000       Prepaid Insurance   14 7,500       Equipment   16 113,000       Accumulated Depreciation-Equipment   17     12,000   Trucks   18 90,000       Accumulated Depreciation-Trucks   19     27,100   Accounts Payable   21     4,500   Jeanne McQuay, Capital   31     126,400   Jeanne McQuay, Drawing   32 3,000       Service Revenue   41     155,000   Wages Expense   51 72,000       Rent Expense   52 7,600       Truck Expense   53 5,350       Miscellaneous Expense   59 5,450             325,000   325,000   The following additional accounts from Recessive Interiors' chart of accounts should be used: Wages Payable, 22; Depreciation Expense-Equipment, 54; Supplies Expense, 55; Depreciation Expense-Trucks, 56; Insurance Expense, 57. The data needed to determine year-end adjustments are as follows: Supplies on hand at January 31 are $2,850. Insurance premiums expired during the year are $3,150. Depreciation of equipment during the year is $5,250. Depreciation of trucks during the year is $4,000. Wages accrued but not paid at January 31 are $900. Use the attached spreadsheet to complete parts 2, 3, and 6. Click on the Spreadsheet icon above to open and save the Excel file to your computer. Your input into the spreadsheet will not be included in your grade in CengageNOW on this problem. Required: 1.  For each account listed in the trial balance, notice that the balance has been entered in the appropriate general ledger account balance column of the spreadsheet. Posting to the general ledger will take place in step 3 and step 6. 2.  (Optional) In the attached spreadsheet, notice that the unadjusted trial balance amounts have been entered. Enter the adjusting entries and complete the worksheet. 3.  Journalize the adjusting entries on page 26 of the journal. Then post to the appropriate accounts in the general ledger in the attached spreadsheet, inserting balances in the accounts affected. Journal PAGE 26 Date Account Post. Ref. Debit Credit           a.                           b.                             c.                             d.                             e.                   4.  Prepare an adjusted trial balance. If an amount box does not require an entry, leave it blank. Recessive InteriorsAdjusted Trial BalanceJanuary 31, 2019   Debit Balances Credit Balances                                                                                                                               5.  Prepare an income statement. Recessive InteriorsIncome StatementFor the Year Ended January 31, 2019     $ Expenses:       $                                             Total expenses         $ Prepare a Statement of Owner's Equity (no additional investments were made during the year.) Recessive InteriorsStatement of Owner's Equity For the Year Ended January 31, 2019     $   $                   $ Prepare a balance sheet. Recessive InteriorsBalance SheetJanuary 31, 2019 Assets Liabilities Current assets:       Current liabilities:         $     $                         Total liabilities   $ Total current assets     $       Property, plant, and equipment:       Owner's Equity   $               $           $                       Total property, plant, and equipment             Total assets     $ Total liabilities and owner's equity   $ 6. Journalize the closing entries on page 27 of the journal. Then post to the general ledger in the attached spreadsheet. For a compound transaction, if an amount box does not require an entry, leave it blank. Journal PAGE 27 Date Account Post. Ref. Debit Credit Close expenses, revenues&income/loss                                                                                                             Close drawing                   7.  Prepare a post-closing trial balance. If an amount box does not require an entry, leave it blank. Recessive InteriorsPost-Closing Trial BalanceJanuary 31, 2019   Debit Balances Credit Balances                                                             Totals     Check My Work1 more Check My Work uses remaining.

Corporate Financial Accounting
14th Edition
ISBN:9781305653535
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter4: Completing The Accounting Cycle
Section: Chapter Questions
Problem 1CP: The unadjusted trial balance of PS Music as of July 31, 2018, along with the adjustment data for the...
icon
Related questions
icon
Concept explainers
Question
100%
repare an adjusted trial balance. If an amount

Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; Optional Spreadsheet

The unadjusted trial balance of Recessive Interiors at January 31, 2019, the end of the year, follows:

Recessive Interiors
Unadjusted Trial Balance
January 31, 2019
  Account No. Debit Balances Credit Balances
Cash   11 13,100      
Supplies   13 8,000      
Prepaid Insurance   14 7,500      
Equipment   16 113,000      
Accumulated Depreciation-Equipment   17     12,000  
Trucks   18 90,000      
Accumulated Depreciation-Trucks   19     27,100  
Accounts Payable   21     4,500  
Jeanne McQuay, Capital   31     126,400  
Jeanne McQuay, Drawing   32 3,000      
Service Revenue   41     155,000  
Wages Expense   51 72,000      
Rent Expense   52 7,600      
Truck Expense   53 5,350      
Miscellaneous Expense   59 5,450      
      325,000   325,000  

The following additional accounts from Recessive Interiors' chart of accounts should be used: Wages Payable, 22; Depreciation Expense-Equipment, 54; Supplies Expense, 55; Depreciation Expense-Trucks, 56; Insurance Expense, 57.

The data needed to determine year-end adjustments are as follows:

  1. Supplies on hand at January 31 are $2,850.
  2. Insurance premiums expired during the year are $3,150.
  3. Depreciation of equipment during the year is $5,250.
  4. Depreciation of trucks during the year is $4,000.
  5. Wages accrued but not paid at January 31 are $900.

Use the attached spreadsheet to complete parts 2, 3, and 6. Click on the Spreadsheet icon above to open and save the Excel file to your computer. Your input into the spreadsheet will not be included in your grade in CengageNOW on this problem.

Required:

1.  For each account listed in the trial balance, notice that the balance has been entered in the appropriate general ledger account balance column of the spreadsheet. Posting to the general ledger will take place in step 3 and step 6.

2.  (Optional) In the attached spreadsheet, notice that the unadjusted trial balance amounts have been entered. Enter the adjusting entries and complete the worksheet.

3.  Journalize the adjusting entries on page 26 of the journal. Then post to the appropriate accounts in the general ledger in the attached spreadsheet, inserting balances in the accounts affected.


Journal PAGE 26
Date Account Post. Ref. Debit Credit
         
a.        
         
       
b.        
         
         
c.        
         
         
d.        
         
         
e.        
         

4.  Prepare an adjusted trial balance. If an amount box does not require an entry, leave it blank.


Recessive Interiors
Adjusted Trial Balance
January 31, 2019
  Debit Balances Credit Balances
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     

5.  Prepare an income statement.


Recessive Interiors
Income Statement
For the Year Ended January 31, 2019
    $
Expenses:    
  $  
     
     
     
     
     
     
     
Total expenses    
    $

Prepare a Statement of Owner's Equity (no additional investments were made during the year.)


Recessive Interiors
Statement of Owner's Equity
For the Year Ended January 31, 2019
    $
  $  
     
     
    $

Prepare a balance sheet.


Recessive Interiors
Balance Sheet
January 31, 2019
Assets Liabilities
Current assets:       Current liabilities:    
    $     $  
             
        Total liabilities   $
Total current assets     $      
Property, plant, and equipment:       Owner's Equity
  $          
    $        
  $        
             
Total property, plant, and equipment            
Total assets     $ Total liabilities and owner's equity   $

6. Journalize the closing entries on page 27 of the journal. Then post to the general ledger in the attached spreadsheet. For a compound transaction, if an amount box does not require an entry, leave it blank.


Journal PAGE 27
Date Account Post. Ref. Debit Credit
Close expenses, revenues
&income/loss
       
         
         
         
         
         
         
         
         
         
         
Close drawing        
         

7.  Prepare a post-closing trial balance. If an amount box does not require an entry, leave it blank.


Recessive Interiors
Post-Closing Trial Balance
January 31, 2019
  Debit Balances Credit Balances
     
     
     
     
     
     
     
     
     
     
Totals    
Check My Work1 more Check My Work uses remaining.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 5 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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
Recommended textbooks for you
Corporate Financial Accounting
Corporate Financial Accounting
Accounting
ISBN:
9781305653535
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College