Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

The trial balance for pioneer advertising is shown below

16/10/2021 Client: muhammad11 Deadline: 2 Day

Accounting Assignment

LEARNING OBJECTIVE 1 Prepare a worksheet.

A worksheet is a multiple-column form used in the adjustment process and in preparing financial statements. As its name suggests, the worksheet is a working tool. It is not a permanent accounting record; it is neither a journal nor a part of the general ledger. The worksheet is merely a device used in preparing adjusting entries and the financial statements. Companies generally computerize worksheets using an electronic spreadsheet program such as Excel. Illustration 4-1 shows the basic form of a worksheet and the five steps for preparing it. Each step is performed in sequence. The use of a worksheet is optional. When a company chooses to use one, it prepares financial statements from the worksheet. It enters the adjustments in the worksheet columns and then journalizes and posts the adjustments after it has prepared the financial statements. Thus, worksheets make it possible to provide the financial statements to management and other interested parties at an earlier date.

Illustration 4-1 Form and procedure for a worksheet

Page 1 of 10Chapter 4. Completing the Accounting Cycle

7/16/2014http://edugen.wiley.com/edugen/courses/crs6417/weygandt9780470929384/c04/d2V5Z2F...

Steps in Preparing a Worksheet We will use the October 31 trial balance and adjustment data of Pioneer Advertising Agency Inc., from Chapter 3, to illustrate how to prepare a worksheet. We describe each step of the process and demonstrate these steps in Illustration 4-2 and transparencies 4-3A, B, C, and D.

Illustration 4-2 Preparing a trial balance

Page 2 of 10Chapter 4. Completing the Accounting Cycle

7/16/2014http://edugen.wiley.com/edugen/courses/crs6417/weygandt9780470929384/c04/d2V5Z2F...

Illustration 4-3A Entering the adjustments in the adjustments columns

Page 3 of 10Chapter 4. Completing the Accounting Cycle

7/16/2014http://edugen.wiley.com/edugen/courses/crs6417/weygandt9780470929384/c04/d2V5Z2F...

Illustration 4-3B Entering adjusted balances in the adjusted trial balance columns

Page 4 of 10Chapter 4. Completing the Accounting Cycle

7/16/2014http://edugen.wiley.com/edugen/courses/crs6417/weygandt9780470929384/c04/d2V5Z2F...

Illustration 4-3C Extending the adjusted trial balance amounts to appropriate financial statement columns

Page 5 of 10Chapter 4. Completing the Accounting Cycle

7/16/2014http://edugen.wiley.com/edugen/courses/crs6417/weygandt9780470929384/c04/d2V5Z2F...

Illustration 4-3D Computing net income or net loss and completing the worksheet

STEP 1. PREPARE A TRIAL BALANCE ON THE WORKSHEET Enter all ledger accounts with balances in the account titles space. Enter debit and credit amounts from the ledger in the trial balance columns. Illustration 4-2 shows the worksheet trial balance for Pioneer Advertising Agency Inc. This trial balance is the same one that appears in Illustration 2-32 and Illustration 3-3.

STEP 2. ENTER THE ADJUSTMENTS IN THE ADJUSTMENTS COLUMNS Turn over the first transparency, Illustration 4-3A. When using a worksheet, enter all adjustments in the adjustments columns. In entering the adjustments, use applicable trial balance accounts. If additional accounts are needed, insert them on the lines immediately below the trial balance totals. A different letter identifies the debit and credit for each adjusting entry. The term used to describe this process is keying. Companies do not journalize the adjustments until after they complete the worksheet and prepare the financial statements. The adjustments for Pioneer Advertising Agency Inc. are the same as the adjustments in Illustration 3-23. They are keyed in the adjustments columns of the worksheet as follows.

Page 6 of 10Chapter 4. Completing the Accounting Cycle

7/16/2014http://edugen.wiley.com/edugen/courses/crs6417/weygandt9780470929384/c04/d2V5Z2F...

(a) Pioneer debits an additional account, Supplies Expense, $1,500 for the cost of supplies used, and credits Supplies $1,500. (b) Pioneer debits an additional account, Insurance Expense, $50 for the insurance that has expired, and credits Prepaid

Insurance $50. (c) The company needs two additional depreciation accounts. It debits Depreciation Expense $40 for the month's depreciation,

and credits Accumulated Depreciation—Equipment $40. (d) Pioneer debits Unearned Service Revenue $400 for services provided, and credits Service Revenue $400. (e) Pioneer debits an additional account, Accounts Receivable, $200 for services provided but not billed, and credits Service

Revenue $200. (f) The company needs two additional accounts relating to interest. It debits Interest Expense $50 for accrued interest, and

credits Interest Payable $50. (g) Pioneer debits Salaries and Wages Expense $1,200 for accrued salaries, and credits an additional account, Salaries and

Wages Payable, $1,200. After Pioneer has entered all the adjustments, the adjustments columns are totaled to prove their equality.

STEP 3. ENTER ADJUSTED BALANCES IN THE ADJUSTED TRIAL BALANCE COLUMNS Turn over the second transparency, Illustration 4-3B. Pioneer determines the adjusted balance of an account by combining the amounts entered in the first four columns of the worksheet for each account. For example, the Prepaid Insurance account in the trial balance columns has a $600 debit balance and a $50 credit in the adjustments columns. The result is a $550 debit balance recorded in the adjusted trial balance columns. For each account, the amount in the adjusted trial balance columns is the balance that will appear in the ledger after journalizing and posting the adjusting entries. The balances in these columns are the same as those in the adjusted trial balance in Illustration 3-25. After Pioneer has entered all account balances in the adjusted trial balance columns, the columns are totaled to prove their equality. If the column totals do not agree, the financial statement columns will not balance and the financial statements will be incorrect.

STEP 4. EXTEND ADJUSTED TRIAL BALANCE AMOUNTS TO APPROPRIATE FINANCIAL STATEMENT COLUMNS

Helpful Hint Every adjusted trial balance amount must be extended to one of the four statement columns.

Turn over the third transparency, Illustration 4-3C. The fourth step is to extend adjusted trial balance amounts to the income statement and balance sheet columns of the worksheet. Pioneer enters balance sheet accounts in the appropriate balance sheet debit and credit columns. For instance, it enters Cash in the balance sheet debit column, and Notes Payable in the credit column. Pioneer extends Accumulated Depreciation—Equipment to the balance sheet credit column; the reason is that accumulated depreciation is a contra-asset account with a credit balance. Because the worksheet does not have columns for the retained earnings statement, Pioneer extends the balance in Common Stock and Retained Earnings, if any, to the balance sheet credit column. In addition, it extends the balance in Dividends to the balance sheet debit column because it is a stockholders' equity account with a debit balance. The company enters the expense and revenue accounts such as Salaries and Wages Expense and Service Revenue in the appropriate income statement columns. Illustration 4-3C shows all of these extensions.

STEP 5. TOTAL THE STATEMENT COLUMNS, COMPUTE THE NET INCOME (OR NET LOSS), AND COMPLETE THE WORKSHEET Turn over the fourth transparency, Illustration 4-3D. The company now must total each of the financial statement columns. The net income or loss for the period is the difference between the totals of the two income statement columns. If total credits exceed total debits, the result is net income. In such a case, as shown in Illustration 4-3D, the company inserts the words “Net Income” in the account titles space. It then enters the amount in the income statement debit column and the balance sheet credit column. The debit amount balances the income statement columns; the credit amount balances the balance sheet columns. In addition, the credit in the balance sheet column indicates the increase in stockholders' equity resulting from net income. What if total debits in the income statement columns exceed total credits? In that case, the company has a net loss. It enters the amount of the net loss in the income statement credit column and the balance sheet debit column. After entering the net income or net loss, the company determines new column totals. The totals shown in the debit and credit income statement columns will match. So will the totals shown in the debit and credit balance sheet columns. If either the income statement columns or the balance sheet columns are not equal after the net income or net loss has been entered, there is an error in the worksheet. Illustration 4-3D shows the completed worksheet for Pioneer Advertising Agency Inc.

Page 7 of 10Chapter 4. Completing the Accounting Cycle

7/16/2014http://edugen.wiley.com/edugen/courses/crs6417/weygandt9780470929384/c04/d2V5Z2F...

Preparing Financial Statements from a Worksheet After a company has completed a worksheet, it has at hand all the data required for preparation of financial statements. The income statement is prepared from the income statement columns. The balance sheet and retained earnings statement are prepared from the balance sheet columns. Illustration 4-4 shows the financial statements prepared from Pioneer's worksheet. At this point, the company has not journalized or posted adjusting entries. Therefore, ledger balances for some accounts are not the same as the financial statement amounts.

Page 8 of 10Chapter 4. Completing the Accounting Cycle

7/16/2014http://edugen.wiley.com/edugen/courses/crs6417/weygandt9780470929384/c04/d2V5Z2F...

Illustration 4-4 Financial statements from a worksheet

Page 9 of 10Chapter 4. Completing the Accounting Cycle

7/16/2014http://edugen.wiley.com/edugen/courses/crs6417/weygandt9780470929384/c04/d2V5Z2F...

The amount shown for common stock on the worksheet does not change from the beginning to the end of the period unless the company issues additional stock during the period. Because there was no balance in Pioneer's retained earnings, the account is not listed on the worksheet. Only after dividends and net income (or loss) are posted to retained earnings does this account have a balance at the end of the first year of the business.

Using a worksheet, companies can prepare financial statements before they journalize and post adjusting entries. However, the completed worksheet is not a substitute for formal financial statements. The format of the data in the financial statement columns of the worksheet is not the same as the format of the financial statements. A worksheet is essentially a working tool of the accountant; companies do not distribute it to management and other parties.

Preparing Adjusting Entries from a Worksheet

Helpful Hint Note that writing the explanation to the adjustment at the bottom of the worksheet is not required.

A worksheet is not a journal, and it cannot be used as a basis for posting to ledger accounts. To adjust the accounts, the company must journalize the adjustments and post them to the ledger. The adjusting entries are prepared from the adjustments columns of the worksheet. The reference letters in the adjustments columns and the explanations of the adjustments at the bottom of the worksheet help identify the adjusting entries. The journalizing and posting of adjusting entries follows the preparation of financial statements when a worksheet is used. The adjusting entries on October 31 for Pioneer Advertising Agency Inc. are the same as those shown in Illustration 3-23.

DO IT! Worksheet Susan Elbe is preparing a worksheet. Explain to Susan how she should extend the following adjusted trial balance accounts to the financial statement columns of the worksheet.

Cash Accumulated Depreciation Accounts Payable Dividends Service Revenue Salaries and Wages Expense

Action Plan ✓ Balance sheet: Extend assets to debit column. Extend liabilities to credit column. Extend contra assets to credit column.

Extend dividends account to debit column. ✓ Income statement: Extend expenses to debit column. Extend revenues to credit column.

Solution Income statement debit column—Salaries and Wages Expense Income statement credit column—Service Revenue Balance sheet debit column—Cash; Dividends Balance sheet credit column—Accumulated Depreciation; Accounts Payable

Related exercise material: BE4-1, BE4-2, BE4-3, E4-1, E4-2, E4-5, E4-6, and 4-1.

Copyright © 2012 John Wiley & Sons, Inc. All rights reserved.

Page 10 of 10Chapter 4. Completing the Accounting Cycle

7/16/2014http://edugen.wiley.com/edugen/courses/crs6417/weygandt9780470929384/c0

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Assignment Guru
ECFX Market
Accounting & Finance Specialist
Top Grade Tutor
Professional Coursework Help
A+GRADE HELPER
Writer Writer Name Offer Chat
Assignment Guru

ONLINE

Assignment Guru

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$47 Chat With Writer
ECFX Market

ONLINE

ECFX Market

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$48 Chat With Writer
Accounting & Finance Specialist

ONLINE

Accounting & Finance Specialist

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$31 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade Tutor

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$41 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$42 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$23 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Kamala harris leadership style - Short essay - Resistance and Communication - An invisible thread cliff notes - Cash receipts budget managerial accounting - Assignment 1: Developing Your Personal Financial Plan - Dance - 10.0.0.1 Piso Wifi - Class Two: Part Two - Cloud computing security and integrity - Ethics and Talent Management - Role of access control in protecting data privacy - What is the electron configuration for ti - The hunger games australian rating - Listen to podcast - Reflections About Theories - Centrelink rockingham opening hours - Flinders street station ballroom renovation - Business finance practice exam - Blood basics assignment answer key - Management - What is quaternary industry - Taylormade r540 xd driver illegal - Menulog stuck on assigning driver - Effective training systems strategies and practices 5th edition pdf - Vanderbilt assessment teacher follow up - Upper lower jeff nippard - Marketing plan for coconut water - Maned wolf interesting facts - Health insurance database design - Imperial college closure dates - Dmaic project report - The life span of smaller stars are much - Pavlovian model of consumer behaviour - Environmental argumentative essay - Examples of closed ended questions in nursing - 1-1 Discussion: Value of the Humanities - How does jack treat piggy - What will the job market look like in 5 to 10 years? - Toys plus inc case study solution - Java magazine 2017 pdf - Personality Disorders - Where to invade next summary - Network defense and countermeasures principles and practices 2nd edition pdf - Assignment on marketing mix of pepsi - St augustine's coffs harbour - Translational research graphic organizer example - Minho personality maze runner - C10 x 25 steel channel - Founding brothers the revolutionary generation sparknotes - How to solve corresponding angles - Current planning applications corby - Kalidasa poems in tamil - Business plan - Tactical assassin substratum cheat codes - Topic: Why students go to pubs and the key motivators - RouteShopping - Activity 5 - Write a discussion post and weather u think the score u received is accurate of your intelligence level .why or why not? - Zoot suit character analysis - Wide eye alcohol - Principles of Microeconomics - Telstra thanks gold class - 4 peer responses - due in 24 hours - Ways in which the Italian Renaissance in Florence was a rebirth of the Greco-Roman classical beliefs and practices - One step backward taken robert frost - From mayo’s aristotelian perspective, where is the best place to look for moral guidance? - How to find sd on calculator - Electrolytes in sports drinks science fair - Business - Afsl tier 1 products - Is steroid a carbohydrate lipid or protein - Robert hayden middle passage analysis - Catch up maths and stats - How to write a practical report biology - TCP/IP Attack Lab- SEED Labs Project - Exercises - All spells used in harry potter - Risk management pmp ppt - Chapter 4 physical development in infancy and toddlerhood - Elements of business letter - Mafs 8 ee 3.7 answers - CPSC 355 Assignment 3 - How to compute the degree of operating leverage - Declare a 8x8 two dimensional array of strings named chessboard - Creative writing about photography - Assume that a bond will make payments every six months as shown on the following timeline - 5.03 argument analysis graphic organizer - A4 a5 a6 a7 - Punctuated equilibrium model of team development - Why did orgo iron his four leaf clover answer - Breaking silence poem by janice mirikitani pdf - Computer hardware components ppt - Dr adrian winbow review - Kaiser permanente opportunities and threats - Jaguar land rover annual report 2013 - Important metrics for operations managers - Railway station symbol os map - Excellent written skills selection criteria - Find the eigenvalues of the given matrix