Enter the adjusting entries into the spreadsheet

Assignment Help Accounting Basics
Reference no: EM131122116

The steps performed in completing an end-of-period spreadsheet (work sheet) are listed below in random order.

a. Add the Debit and Credit columns of the Unadjusted Trial Balance columns of the spreadsheet (work sheet) to verify that the totals are equal.

b. Add the Debit and Credit columns of the Balance Sheet and Income Statement columns of the spreadsheet (work sheet) to verify that the totals are equal.

c. Add or deduct adjusting entry data to trial balance amounts, and extend amounts to the Adjusted Trial Balance columns.

d. Add the Debit and Credit columns of the Adjustments columns of the spreadsheet (work sheet) to verify that the totals are equal.

e. Add the Debit and Credit columns of the Balance Sheet and Income Statement columns of the spreadsheet (work sheet) to determine the amount of net income or net loss for the period.

f. Add the Debit and Credit columns of the Adjusted Trial Balance columns of the spreadsheet (work sheet) to verify that the totals are equal.

g. Enter the adjusting entries into the spreadsheet (work sheet), based on the adjustment data.

h. Enter the amount of net income or net loss for the period in the proper Income Statement column and Balance Sheet column.

i. Enter the unadjusted account balances from the general ledger into the Unadjusted Trial Balance columns of the spreadsheet (work sheet).

j. Extend the adjusted trial balance amounts to the Income Statement columns and the Balance Sheet columns.
Indicate the order in which the preceding steps would be performed in preparing and completing a spreadsheet (work sheet).

Reference no: EM131122116

Questions Cloud

Prepare the adjusting entries for homeland security services : Based on the data in Exercise 4-22, prepare the adjusting entries for Homeland Security Services Co.
Prepare an income statement statement of owners equity : Based on the data in Exercise 4-23, prepare an income statement, statement of owner’s equity, and balance sheet for Homeland Security Services Co.
Complete the following end of period spreadsheet : Homeland Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet (work sheet) for Homeland Security ServicesCo.
Corporations are considered person in the law : Ever since the Ford Pinto case, Enron and now Murdoch there is an increasing number of laws passed that make corporations criminally responsible for their actions. The Supreme Court recently decided that because corporations are considered "a person"..
Enter the adjusting entries into the spreadsheet : Extend the adjusted trial balance amounts to the Income Statement columns and the Balance Sheet columns.Indicate the order in which the preceding steps would be performed in preparing and completing a spreadsheet
What is the effective cost of this loan : The loan requires that interest payments be made at the end of each of the next five years. At the end of five years, the entire loan balance must be repaid. The finance company requires U.S. Fax to pay a $25,000 loan-processing fee at the time the l..
Calculate the effective interest rate on this loan : A $1 million loan requires five end-of-year equal payments of $284,333. a. Calculate the effective interest rate on this loan. b. How much interest (in dollars) is paid over the life of this loan?
Structure the financing of the corporation : Joan comes to you five years later after choosing to start her own business. It has been successful and she now wants to go national. However, she needs capital. If you tell her to incorporate, how would you suggest that she structure the financing o..
Adjusting entries are journalized and posted to the ledger : Rearrange the following steps in the accounting cycle in proper sequence:

Reviews

Write a Review

Accounting Basics Questions & Answers

  Limited efficiency in collecting receivables

What conclusions can be drawn from these analyses regarding The Limited's efficiency in collecting receivables?

  Prepare an analysis for ed management

Prepare an analysis for ED management that compares processing the butter further with selling the product immediately at split off.

  Mainline produce corporation acquired all the outstanding

mainline produce corporation acquired all the outstanding common stock of iceberg lettuce corporation for 40000000 in

  Grant film productions wants to expand and has borrowed

grant film productions wants to expand and has borrowed 100000. as a condition for making this loan the bank requires

  Reporting the interest revenue

The cash selling price of the equipment is $5,174,552, which is equal to the present value of the lease payments at 8%. Marshall purchased the equipment for $4,300,000.For 2011, Marshall should report interest revenue of ?

  Problem regarding the mild deflation

During the late nineteenth century in the United States, many farmers borrowed heavily to buy land. During most of the period between 1870 and the mid-1890s, the United States experienced mild deflation

  Preparing accurate and truthful financial statements

Who would you say benefits more when a company prepares accurate and truthful financial statements?

  The current year and expects to earn

Pinecone Company has plan assets of $500,000 at the beginning of the current year and expects to earn 12% on its plan assets during the year.

  Resolve interoffice accountability and disciplinary process

I will be writing an analytical report in order to resolve interoffice accountability and disciplinary processes. The recipients of this report will be the Chief Mojo Maker and the Chief Operating Officer Of Mojo Art & Image LLC, Located in Baltim..

  Why is this an incorrect approach to measuring periodic

Why is this an incorrect approach to measuring periodic depreciation?

  On march 31 2010 willey market issued 150000 worth of

on march 31 2010 willey market issued 150000 worth of 10-year eight percent bonds when the market rate was nine

  Smith and jones each own tracts of land because of the

smith and jones each own tracts of land. because of the location of their current operations each would prefer to have

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd