Fundamental Accounting Principles
23rd Edition
ISBN: 9781259536359
Author: John J Wild, Ken Shaw Accounting Professor, Barbara Chiappetta Fundamental Accounting Principles
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 4, Problem 6APSA
To determine
The
Six-Column Table
It is accounting worksheet which shows the unadjusted, adjustment and adjusted balance of the
To determine:
1. Complete the six-column table by entering adjustments.
2. Prepare adjusting entries for the adjustments entered in the six-column table.
3. Prepare journal entries to reverse the effects of the adjusting entries.
4. Prepare journal entries to record the cash payment and cash collections described for January.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Could you help me solve this financial accounting question using appropriate calculation techniques?
B2
A
1 DATE VALUE
X✓ fx
2
1
3
9
4
548
56
3835
40468
VALUE
B
C
D
E
F
G
H
MEASURE
Current Date (TODAY)
VALUE
FORMULA
MEASURE
VALUE
FORMULA
Current Time (NOW)
#N/A
#N/A
Use E6 "Problem Date" for green cells in col. E & I
Cumulative full days this year
#N/A
Year to date fraction (YEARFRAC)
#N/A
Use E6 "Problem Date" for green cells in col. E & I
Month to date fraction of year
#N/A
10/8/2019
Day of the week
#N/A
6
Problem Date
7
Year (YEAR)
8 Date Value
Fractional Date
Month (MONTH)
9
40468.25
Day (DAY)
10
40468.375
11
40468.625
12
13
14
15 DATE DATA CLEANUP and MANIPULATION
End of month
Start of month
Start of next month
First day of the year
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
TIP: Use custom date format to display
as the name of the day (dddd)
Name of month
Workdays in current month
#N/A
#N/A
30 workdays (excluding weekends) from today
Days between today and 30 workdays from now
#N/A
#N/A
16
Target
$2,000
17
18 DATE
REVENUE
MONTH
DAY OF WEEK
Hit Target?
MONTH
DAY OF WEEK
FORMULAS for…
Get correct answer with accounting question
Chapter 4 Solutions
Fundamental Accounting Principles
Ch. 4 - Prob. 1DQCh. 4 - Prob. 2DQCh. 4 - Prob. 3DQCh. 4 - Prob. 4DQCh. 4 - Prob. 5DQCh. 4 - Prob. 6DQCh. 4 - 7. Why are the debit and credit entries in the...Ch. 4 - Prob. 8DQCh. 4 - Prob. 9DQCh. 4 - Prob. 10DQ
Ch. 4 - Prob. 11DQCh. 4 - 12. How do reversing entries simplify...Ch. 4 - If a company recorded accrued salaries expense of...Ch. 4 - Prob. 14DQCh. 4 - Prob. 15DQCh. 4 - Prob. 16DQCh. 4 - Prob. 17DQCh. 4 - Prob. 1QSCh. 4 - Prob. 2QSCh. 4 - Prob. 3QSCh. 4 - Prob. 4QSCh. 4 - Prob. 5QSCh. 4 - Prob. 6QSCh. 4 - Prob. 7QSCh. 4 - Prob. 8QSCh. 4 - Prob. 9QSCh. 4 - Prob. 10QSCh. 4 - Prob. 11QSCh. 4 - Prob. 12QSCh. 4 - Exercise 4-1
Extending adjusted account balances...Ch. 4 - Prob. 2ECh. 4 - Prob. 3ECh. 4 - Exercise 4-4 Completing a work sheet Pl The...Ch. 4 - Exercise 4-5 Determining effects of closing...Ch. 4 - Prob. 6ECh. 4 - Exercise 4-7 Preparing a work sheet and recording...Ch. 4 - Prob. 8ECh. 4 - Prob. 9ECh. 4 - Prob. 10ECh. 4 - Prob. 11ECh. 4 - Prob. 12ECh. 4 - Exercise 4-13 Computing the current ratio A1 Use...Ch. 4 - Prob. 14ECh. 4 - Prob. 15ECh. 4 - Prob. 16ECh. 4 - Prob. 17ECh. 4 - Problem 4-1A Applying the accounting cycle C1 C2...Ch. 4 - Prob. 2APSACh. 4 - Prob. 3APSACh. 4 - Prob. 4APSACh. 4 - Problem 4-5A Preparing trial balances, closing...Ch. 4 - Prob. 6APSACh. 4 - Prob. 1BPSBCh. 4 - Prob. 2BPSBCh. 4 - Prob. 3BPSBCh. 4 - Prob. 4BPSBCh. 4 - Prob. 5BPSBCh. 4 - Prob. 6BPSBCh. 4 - Business Solutions P2 P3 (This serial problem...Ch. 4 - Prob. 1GLPCh. 4 - Prob. 2GLPCh. 4 - Prob. 3GLPCh. 4 - Prob. 4GLPCh. 4 - Prob. 5GLPCh. 4 - Prob. 1BTNCh. 4 - Prob. 2BTNCh. 4 - Prob. 3BTNCh. 4 - Prob. 4BTNCh. 4 - Prob. 5BTNCh. 4 - Prob. 6BTNCh. 4 - Prob. 7BTNCh. 4 - Prob. 8BTNCh. 4 - Prob. 9BTN
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
- General accountingarrow_forwardText Data Cleaning and Manipulation Beginning in row 16, columns B and C contain raw names and numeric zip codes. In columns D through H, you are asked to clean and manipulate that data in specific ways. Good thing is that you only have to create formulas for the first row then you can fill down. Enter the values for the last row below. Note: These are meant to be challenging. So just take your time and work thought each column logically using trial and error if necessary. Hint: The last column for zip code, will require a nested IF function to first see if the numeric zip code is 5 or 4 characters long so you then know which formatting to apply. Proper Name First Name Last Name Short Name (First L.) New Zip Code Valarrow_forwardI am looking for the correct answer to this general accounting question with appropriate explanations.arrow_forward
- Financial Accounting Question please answerarrow_forwardGet correct answer with accounting questionarrow_forwardB2 A 1 DATE VALUE X✓ fx 2 1 3 9 4 548 56 3835 40468 VALUE B C D E F G H MEASURE Current Date (TODAY) VALUE FORMULA MEASURE VALUE FORMULA Current Time (NOW) #N/A #N/A Use E6 "Problem Date" for green cells in col. E & I Cumulative full days this year #N/A Year to date fraction (YEARFRAC) #N/A Use E6 "Problem Date" for green cells in col. E & I Month to date fraction of year #N/A 10/8/2019 Day of the week #N/A 6 Problem Date 7 Year (YEAR) 8 Date Value Fractional Date Month (MONTH) 9 40468.25 Day (DAY) 10 40468.375 11 40468.625 12 13 14 15 DATE DATA CLEANUP and MANIPULATION End of month Start of month Start of next month First day of the year #N/A #N/A #N/A #N/A #N/A #N/A #N/A TIP: Use custom date format to display as the name of the day (dddd) Name of month Workdays in current month #N/A #N/A 30 workdays (excluding weekends) from today Days between today and 30 workdays from now #N/A #N/A 16 Target $2,000 17 18 DATE REVENUE MONTH DAY OF WEEK Hit Target? MONTH DAY OF WEEK FORMULAS for…arrow_forward
- Job 528 was one of the many jobs started and completed during the year. The job required $11,200 in direct materials and 40 hours of direct labor time at a total direct labor cost of $12,600. If the job contained five units and the company billed at 65% above the unit product cost on the job cost sheet, what price per unit would have been charged to the customer?arrow_forwardC2 X✓ fx Σ N A B 1 Product ☑ Order Quantity C D E F G H K L Product ID ✓ Unit Price Gross Sales Formulas for Columns C, D, & E Product Product ID Unit Price 2 Carry-on Suitcase 3 Carry-on Suitcase 4 Bluetooth Headphones 5 Carry-on Suitcase 6 Travel Pillow 7 Travel Umbrella 8 Battery Pack 9 Travel Pillow 10 Travel Pillow 11 Battery Pack 23 #N/A #N/A #N/A Travel Umbrella B07NQKQ19S $12.51 #N/A #N/A #N/A Bluetooth Headphones B01NAJGGA2 $35.39 12 Battery Pack 13 Travel Pillow 14 Bluetooth Headphones 15 Battery Pack 16 Bluetooth Headphones 17 Travel Umbrella 18 Carry-on Suitcase 19 Bluetooth Headphones 20 Travel Umbrella 21 Bluetooth Headphones 22 Travel Umbrella 23 Battery Pack 24 Bluetooth Headphones 25 Carry-on Suitcase 26 Travel Pillow 27 Battery Pack 28 Carry-on Suitcase 29 Carry-on Suitcase 30 Battery Pack 31 Carry-on Suitcase 32 Travel Pillow 33 Bluetooth Headphones 34 Bluetooth Headphones 22226-22 22272122227222432-29 10 9 23 27 27 23 #N/A #N/A #N/A Battery Pack B00Z9QVE4Q $34.98…arrow_forwardGeneral accountingarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY