College Accounting, Chapters 1-27
23rd Edition
ISBN: 9781337794756
Author: HEINTZ, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 27, Problem 6SPA
SPRE ADSHEET,
Data for adjusting the accounts are as follows:
Additional information needed to prepare the financial statements is as follows:
Required
- 1. Prepare a 6-column spreadsheet.
- 2. Prepare the following financial statements and schedule:
- (a) income statement
- (b) schedule of cost of goods manufactured
- (c) statement of
retained earnings - (d)
balance sheet
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Select the letter of the item below that best matches the definitions that follow.
a. Balance Sheet Standard report.
b. To date
c. Summary Balance Sheet report
d. QuickZoom
e. Transactions by Account report
f. % of Column
g. Memorizing a report
h. Divided by 1000
1. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to add a column representing the percentage of each item compared to total assets.
2. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to round amounts to the nearest whole dollar.
3. ________ The start of the reporting period.
4. ________ A financial statement reporting in detail the assets, liabilities, and equities of a business as of a certain date.
5. ________ A process by which modified reports are saved for later use.
6. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to report amounts in thousands.
7. ________ The end…
Match each of the five items listed below with one of the following locations:
1. Located on the Income Statement debit column of the worksheet
2. Located on the Income Statement credit column of the worksheet
3. Located on the Balance Sheet debit column of the worksheet
4. Located on the Balance Sheet credit column of the worksheet
a. Sales Returns and Allowances
b. Accrued Salaries Payable
c. Sales
d. Merchandise Inventory
e. Accounts Receivable
a. Sales Returns and Allowance
1.
Located on the Income Statement debit column of the worksheet
2.
Located on the Income Statement credit column of the worksheet
3.
Located on the Balance Sheet debit column of the worksheet
4.
Located on the Balance Sheet credit column of the…
Financial Statements, Closing Entries & Ratio Analysis
You are asked to support Telcel Company with its Financial Reporting requirements. The
Senior Manager provided you with the following Adjusted Trial Balance:
Telcel Company
TRIAL BALANCE (Adjusted)
31-Mar-21
Debit
Credit
Cash
10,450
Accounts Receivable
16,800
Prepaid Rent
Supplies
7,600
1,500
Inventory
Buildings
Equipment
6,400
125,000
32,000
Accumulated Depreciation – Equipment
7,200
Accumulated Depreciation – Buildings
Accounts Payable
Notes Payable (due 2024)
21,000
13,900
49,000
Unearned Service Revenue
9,450
Share Capital
Retained Earnings
76,000
31,650
Dividends
8,000
Service Revenue
68,400
Advertising Expense
Salaries and Wages Expense
1,750
47,800
Utilities Expense
5,400
Supplies Expense
Depreciation Expense
Interest Expense
Rent Expense
2,600
8,400
1,100
1,800
Total
276,600
276,600
Additional Information:
2020 Data
Accounts Receivable
$8,100
Total Assets
$158,930
Chapter 27 Solutions
College Accounting, Chapters 1-27
Ch. 27 - Under the perpetual inventory system, Cost of...Ch. 27 - Prob. 2TFCh. 27 - On the spreadsheet, the factory overhead account...Ch. 27 - Prob. 4TFCh. 27 - The adjustment for factory overhead applied to...Ch. 27 - LO2 The adjustment for the amount of factory...Ch. 27 - The adjustment for depreciation expense for the...Ch. 27 - At the end of the accounting period, a credit...Ch. 27 - Prob. 4MCCh. 27 - Prob. 5MC
Ch. 27 - LO2 Prepare adjusting entries at December 31 for J...Ch. 27 - Prob. 2CECh. 27 - Prob. 3CECh. 27 - Prob. 1RQCh. 27 - Prob. 2RQCh. 27 - Prob. 3RQCh. 27 - Prob. 4RQCh. 27 - Prob. 5RQCh. 27 - What are the distinctive features of ToyJoys...Ch. 27 - Prob. 7RQCh. 27 - Prob. 8RQCh. 27 - Prob. 9RQCh. 27 - ADJUSTING ENTRIES INCLUDING ADJUSTMENT FOR...Ch. 27 - Prob. 2SEACh. 27 - Prob. 3SEACh. 27 - CLOSING JOURNAL ENTRIES Prepare closing journal...Ch. 27 - REVERSING JOURNAL ENTRIES Prepare reversing...Ch. 27 - SPRE ADSHEET, ADJUSTING ENTRIES, AND FIN ANCIAL...Ch. 27 - FINANCIAL STATEMENTS The adjusted trial balance...Ch. 27 - ADJUSTING. CLOSING. AND REVERSING ENTRIES A...Ch. 27 - ADJUSTING ENTRIES INCLUDING ADJUSTMENT FOR...Ch. 27 - Prob. 2SEBCh. 27 - ADJUSTING JOURNAL ENTRIES FOR A MANUFACTURING...Ch. 27 - Prob. 4SEBCh. 27 - REVERSING ENTRIES Prepare reversing journal...Ch. 27 - SPREADSHEET, ADJUSTING ENTRIES, AND FINANCIAL...Ch. 27 - FINANCIAL STATEMENTS The adjusted trial balance...Ch. 27 - Prob. 8SPBCh. 27 - Prob. 1MYWCh. 27 - Reese Manufacturing Company manufactures and sells...Ch. 27 - Drafts of the condensed income statement and...
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
- SPREADSHEET, ADJUSTING ENTRIES, AND FINANCIAL STATEMENTS Woods Companys trial balance columns from its spreadsheet are shown on the next page. Data for adjusting the accounts are as follows: Additional information needed to prepare the financial statements is as follows: Assume that all materials inventory items are direct materials. REQUIRED 1. Prepare a spreadsheet. 2. Prepare the following financial statements and schedule: (a) income statement (b) schedule of cost of goods manufactured (c) statement of retained earnings (d) balance sheetarrow_forwardFINANCIAL STATEMENTS The adjusted trial balance columns of Braiden Company’s spreadsheet are shown on the next page. Additional information needed to prepare the financial statements is as follows: Required Prepare an income statement and a schedule of cost of goods manufactured for the year ended December 31, 20--. Prepare a statement of retained earnings for the year ended December 31, 20--. Prepare a balance sheet as of December 31, 20--.arrow_forwardWhat is the operating income and the net income?arrow_forward
- Creating a chart of accounts Raymond Autobody Shop has the following accounts: Accounts Payable Service Revenue Create a chart of accounts for Raymond Autobody Shop using the standard numbering system. Each account is separated by a factor of 10. For example, the first asset account will be 100 and the next asset account will 110.arrow_forwardAfter completing the preparation, the necessary credit adjustments are made to adjust the balances of the accounts shown in * the balance with a view to Photographing the compang's general profit and loss accounts and photographing the balance sheet Balance Sheet - Asset Side circulated Profit and loss account on the revenue side Administrative expenses statementarrow_forwardThe following contains the various steps of the financial reporting process. Arrange them in proper order and indicate whether each step is a function of the TPS, GLS pr FRS., *Record transaction in special journal. *Make adjusting entries. *Capture the transaction. *Prepare the postclosing trial balance. *Prepare the adjusted trial balance. *Prepare the sales invoices. *Prepare the financial statements. *Journalize and post the adjusting entries. *Post to the subsidiary ledger. *Post to the general ledger. *Issue Official Receipts. *Journalize and post the closing entries. *Prepare the unadjusted trial balance.arrow_forward
- Select 30 transactions of various kinds such as sales, costs (direct and indirect), revenues earned, revenue received in advance, expenses incurred, paid in advance, outstanding expenses, assets (current, non-current), liabilities (current, long term), Equity and so on.1. Record those transactions in journal,2. post them to ledger,3. Transfer the balances in trail balance,4. Prepare income statement and balance sheet.5. Follow the proper format considering IAS-1.6. Explanation: At the end, apply the concepts such as long term assets, capital or revenueincomes or expenses and their treatment involved in your above requirements Transactions of Mr. Akram travel world business Mr Akram started business with cash for rs 400,000. Paid wages rs 20,000. Paid office rent in advance 2000. Paid rs 10000 for insurance in advance. Babar and sons paid 2500 for goods on advance. Purchased office equipment on credit rs 5000. Paid 7000 for advertising expenses. Paid 3000 to accounts payable. Provided…arrow_forwardCREATE YOUR OWN FORM OF “CHART OF ACCOUNTS”arrow_forwardWhat is the difference between a trial balance and a balance sheet?arrow_forward
- After journalizing, the journal entries are transferred to a four-column record where the balances of each account after each transaction can be found. This record is called a/an ____________. Group of answer choices ledger or a general ledger financial statement journal balance sheetarrow_forwardIn the Excel, or spreadsheet, approach to recording financial transactions, the revenues and expenses on the income statement can be determined by summing each column. True or False True Falsearrow_forwardThe first step in posting the sales journal to the general ledger is to total and verify the equality of the amount columns. enter the date in the Date column of the ledger account. enter the new balance in the Balance columns of the ledger account. enter the ledger account number below the column totals in the 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,
College Accounting, Chapters 1-27 (New in Account...AccountingISBN:9781305666160Author:James A. Heintz, Robert W. ParryPublisher:Cengage Learning
College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
College Accounting (Book Only): A Career ApproachAccountingISBN:9781305084087Author:Cathy J. ScottPublisher:Cengage Learning
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
College Accounting, Chapters 1-27 (New in Account...
Accounting
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781305084087
Author:Cathy J. Scott
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY