Custom Bundle: Accounting, Loose-leaf Version, 26th + Working Papers, Chapters 1-17, 26th Edition
26th Edition
ISBN: 9781305714731
Author: Warren/Reeve/Duchac
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
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 solution
Students have asked these similar questions
Prepare adjusting Journal entry with explanation
Prepare the general journal entries to record the accounts receivable 'write-offs' and the 'write-off recoveries' for 2023. Label Debit accounts with "Dr" and Credit accounts with "Cr". For example: (Dr) Asset $XXXXX, (Cr) Revenues $XXXXX. Ignore GST & narrations
Adjustment data on an end-of-period spreadsheetAlert Security Services Co. offers security services to business clients.The trial balance for Alert Security Services has been prepared on thefollowing end-of-period spreadsheet for the year ended October 31,20Y3:
The data for year-end adjustments are as follows:a. Fees earned, but not yet billed, $13.b. Supplies on hand, $4.c. Insurance premiums expired, $10.d. Depreciation expense, $3.e. Wages accrued, but not paid, $1.Enter the adjustment data, and place the balances in the Adjusted TrialBalance columns.
Chapter 4 Solutions
Custom Bundle: Accounting, Loose-leaf Version, 26th + Working Papers, Chapters 1-17, 26th Edition
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 - Prob. 4DQCh. 4 - Why are closing entries required at the end of an...Ch. 4 - What is the difference between adjusting entries...Ch. 4 - What is the purpose of the post-closing trial...Ch. 4 - Prob. 8DQCh. 4 - What is the natural business year?Ch. 4 - Prob. 10DQ
Ch. 4 - Prob. 4.1APECh. 4 - Flow of accounts into financial statements The...Ch. 4 - Statement of owner's equity Marcie Davies owns and...Ch. 4 - Statement of owners equity Blake Knudson owns and...Ch. 4 - Classified balance sheet The following accounts...Ch. 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 - Prob. 4.2EXCh. 4 - Financial statements from the end-of-period...Ch. 4 - Financial statements from the end-of-period...Ch. 4 - Income statement The following account balances...Ch. 4 - Prob. 4.6EXCh. 4 - Prob. 4.7EXCh. 4 - Statement of owner's equity Apex Systems Co....Ch. 4 - Statement of owners equity; net loss Selected...Ch. 4 - Prob. 4.10EXCh. 4 - Balance sheet classification At the balance sheet...Ch. 4 - Balance sheet Optimum Weight Loss Co. offers...Ch. 4 - Prob. 4.13EXCh. 4 - Prob. 4.14EXCh. 4 - Closing entries Prior to its closing, Income...Ch. 4 - Closing entries with net income After all revenue...Ch. 4 - Closing entries with net loss Mira Services Co....Ch. 4 - Prob. 4.18EXCh. 4 - Prob. 4.19EXCh. 4 - Steps in the accounting cycle Rearrange the...Ch. 4 - Prob. 4.21EXCh. 4 - Prob. 4.22EXCh. 4 - Completing an end-of-period spreadsheet List (a)...Ch. 4 - Prob. 4.24EXCh. 4 - Prob. 4.25EXCh. 4 - Appendix Completing an end-of-period spreadsheet...Ch. 4 - Appendix Adjustment data on an end-of-period...Ch. 4 - Appendix Completing an end-of-period spreadsheet...Ch. 4 - Prob. 4.1APRCh. 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 closing entries The...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 - The unadjusted trial balance of PS Music as of...Ch. 4 - Kelly Pitney began her consulting business, Kelly...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
- Assume the following data for Lusk Inc. before its year-end adjustments: Journalize the adjusting entries for the following: a. Estimated customer allowances b. Estimated customer returnsarrow_forwardSALES RETURNS AND ALLOWANCES ADJUSTMENT At the end of year 1, MCs estimates that 2,400 of the current years sales will be returned in year 2. Prepare the adjusting entry at the end of year 1 to record the estimated sales returns and allowances and customer refunds payable for this 2,400. Use accounts as illustrated in the chapter.arrow_forwardAdjusting Entries Kretz Corporation prepares monthly financial statements and therefore adjusts its accounts at the end of every month. The following information is available for March 2016: Kretz Corporation takes out a 90-day, 8%, $15,000 note on March 1, 2016, with interest and principal to be paid at maturity. The asset account Office Supplies on Hand has a balance of $1,280 on March 1, 2016. During March, Kretz adds $750 to the account for purchases during the period. A count of the supplies on hand at the end of March indicates a balance of $1,370. The company purchased office equipment last year for $62,600. The equipment has an estimated useful life of six years and an estimated salvage value of $5,000. The companys plant operates seven days per week with a daily payroll of $950. Wage earners are paid every Sunday. The last day of the month is Thursday, March 31. The company rented an idle warehouse to a neighboring business on February 1, 2016, at a rate of $2,500 per month. On this date, Kretz Corporation credited Rent Collected in Advance for six months rent received in advance. On March 1, 2016, Kretz Corporation credited a liability account, Customer Deposits, for $4,800. This sum represents an amount that a customer paid in advance and that Kretz will earn evenly over a four-month period. Based on its income for the month, Kretz Corporation estimates that federal income taxes for March amount to $3,900. Required For each of the preceding situations, prepare in general journal form the appropriate adjusting entry to be recorded on March 31, 2016.arrow_forward
- Preparing Adjusting Entries The Sang Tae Company presented the following information pertaining to accounts that will need adjustments for its November 30, 2019 year-end financial statements. On Oct. 1,2019 Sang Tae paid P10, 800 for 6 month's insurance premiums 2. The balance in the leger account Office Supplies amounted to P32,000. A count of the supplies on November 30, 2019 totaled P12,800. 1. 3. Sang Tae received P22,800 on November 1, 2019 from a customer for services to be rendered during the months of November, December, January and February 2020. 4. Sang Tae acquired Office Equipment costing P352,800 on April 1, 2019, the equipment is expected to last 5 years after which it will be worthless. The scrap value is 10,500. 5. Assume that November 30, 2019 is a Friday and that Sang Tae pays its employees a total of P87,500 on Saturday. Requirements: 1. Prepare the adjusting entries as of November 30,2019 2. Prepare ihe Dec. 1, 2019 entry to record the paymeni of the salaries. 43arrow_forwardAdjusting entries for prepaid insurance Instructions Chart of Accounts Journal Instructions The balance in the prepaid insurance account, before adjustment at the end of the year, is $18,135. Journalize the March 31 adjusting entry required under each of the following alternatives for determining the amount of the adjustment: (a) the amount of insurance expired during the year is $15,480; (b) the amount of unexpired insurance applicable to future periods is $2,655. Refer to the chart of accounts for the exact wording of the account titles. CNOW journals do not use lines for journal explanations. Every line on a journal page is used for debit or credit entries. CNOW journals will automatically indent a credit entry when a credit amount is entered. Chart of Accounts CHART OF ACCOUNTS General Ledger ASSETS 11 Cash 12 Accounts Receivable 13 Supplies 14 Prepaid Insurance 15 Land 16 Equipment 17…arrow_forwardFAITH Company presented the following information pertaining to accounts that will need adjustments forits November 30, 2020 year-end financial statements:a. On Oct. 1, 2020, Faith Company paid $10,800 for 6-months’ insurance premiums. Debited InsuranceExpense for the amount paid.b. The balance in the ledger account Office Supplies amounted to $32,000. A count of the officesupplies on hand as of Nov. 30, 2020 totaled $12,800.c. Faith Company received $22,800 on Nov. 1, 2020 from a customer for future services to be renderedduring the months of November, December, January, and February.d. Faith acquired Office Equipment costing $355,000 on April 1, 2020. The equipment is expected to last5 years after which it will have a salvage value of $2,200.e. Assume that Nov. 30, 2020 is a Thursday and that Faith pays its employees a total of $87,500 everyFridays for a 5-day working week.Required: Prepare the necessary adjusting entries for Faith Company at November 30, 2020arrow_forward
- REQUIRED Record the adjustment journal entry in respect of rent income in the books of NT Stores as at 28 February 2022. INFORMATION The Rent Income account of NT Stores reflected a total of R276 000 on 28 February 2022, the end of the accounting period. This was in respect of rent for an office occupied by a tenant for the entire financial year. The monthly rental was increased by 10% with effect from 01 September 2021. The rent for February 2022 was due to be received on 01 March 2022.arrow_forward9arrow_forwardUncollectible Accounts—Percentage of Sales and Percentage of Receivables At the end of the current year, the accounts receivable account of Malik's Lanscaping Service has a debit balance of $390,000. Credit sales are $2,880,000. Record the end-of-period adjusting entry on December 31, in general journal form, for the estimated uncollectible accounts. Assume the following independent conditions existed prior to the adjustment: 1. Allowance for Doubtful Accounts has a credit balance of $1,840. a. The percentage of sales method is used and bad debt expense is estimated to be 1% of credit sales.arrow_forward
- Information to prepare adjusting journal entries The following information relates to Gatsby, Inc. as of December 31 of the current year. The company uses the calendar year as its annual reporting period and the Accrual Method of Accounting. Prepaid and unearned items are recorded as assets and liabilities, respectively. Prepare all necessary adjusting journal entries and post to the T-accounts. 1 The company's weekly payroll is $3,000 and is paid each Friday for a five-day work week. Assume December 31st falls on a Thursday, but the employees will not be paid their wages until Friday, January 3rd. 2 Eighteen months earlier, on July 1st the company purchased equipment that cost $160,000. Its useful life is predicted to be ten years, at which time the equipment is expected to have a zero salvage/residual value. Gatsby, Inc. uses the straight-line depreciation method. Deprecation has NOT been recorded for this year. 3 On September 1st of the current year Gatsby, Inc. was paid $60,000 in…arrow_forwardAdjusting entries for prepaid insurance The balance in the prepaid insurance account, before adjustment at the end of the year, is $21,910. Journalize the adjusting entry required under each of the following alternatives for determining the amount of the adjustment: a. The amount of insurance expired during the year is $16,650. If an amount box does not require an entry, leave it blank. b. The amount of unexpired insurance applicable to future periods is $5,260. If an amount box does not require an entry, leave it blank. Σ .arrow_forwardComprehensive On November 30, 2019. Davis Company had the following account balance. During the month of December, Davis entered into the following transactions: Required: a.Prepare generaljournal entries to record the preceding transactions. b.Post to general ledger T accoun c.Prepare a year-end trial balance on a worksheet and complete theworksheet using the following information: (a) accrued salaries at year-end total s1,200; (b) for simplicity, the building and equipment are being depreciated using the straight-line method over an estimated life of 20 yean with no residual value;(c) supplies on hand at the end of the year total $630; (d) bad debts expense for the year totals $830; and (e)the income tax rate is 30%; income taxes are payable in the first quarter of d.Prepare the companis financial statements for 2019. e.Prepare the 2019 (a) adjusting and (b) closing entries in the general journal.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY