REQUIREMENT #6: Prepare an Adjusted Trial Balance in the space below.
Transcribed Image Text:AutoSave
Milestone 1_CourseProject_ACCT212_Tiffany Bishop (version 1) - AutoRecovered -
O X
ff
Tiffany Bishop
TB
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Developer
Help
Table Design
A Share
P Comments
VA Show Formulas
fx I
O Define Name v
B, Trace Precedents
Calculate Now
K Use in Formula v
a Trace Dependents
A Error Checking
Insert
AutoSum Recently Financial Logical Text Date & Lookup & Math &
More
Name
Watch
Calculation
Calculate Sheet
Function
Used v
Time v Reference Trig v Functions
Manager Create from Selection
E Remove Arrows O Evaluate Formula
Window
Options
Function Library
Defined Names
Formula Auditing
Calculation
B12
fe
Equipment
A
B
D
E
F
H
J
K
M
N
REQUIREMENT #3: Prepare a trial balance for July in the space below.
1
Peter's Pool Corporation
В
D
E
G
H
J
Trial Balance
General Journal
Account
July 31
Once you've completed
this requirement print your
Number from
3 Account
4 Number
Account
Balance
Chart of
General Journal to
complete Requirement #2
on the General Ledger
worksheet.
Date
Accounts tab
Account Title from Chart of Accounts tab
Debit
Credit
Title
Debit
Credit
1-Jul
111 Cash
40,000
311
Common Stock
40,000
5 111
6 411
7 119
8 511
9 514
10 517
11 512
Cash
37,700
1-Jul
119 Prepaid Insurance
4,800
Revenue
8,900
111
Cash
4,800
1-Jul
511 Store Rent Expense
3,600
Prepaid Insurance
Rent Expense
Supplies Expense
Electricity Expense
Telephone Expense
Equipment
Accounts Payable
Common Stock
Dividend
4,800
111
Cash
3,600
3,600
6-Jul
144 Repair Equipment
7,800
11
Cash
600
450
Accounts Payable
514 Repair Supplies Expense
Accounts Payable
512 Telephone Expense
212
7,200
500
8-Jul
450
300
212
450
10-Jul
300
12 144
13 212
7,800
11
411 Cash
Cash
300
7,350
11-Jul
2,650
111
117 Accounts Payable
212
411 Cash
Pool Service Revenue
2,650
14 311
40,000
18-Jul
300
15 313
1,100
Cash
300
20-Jul
4,000
16
111
Pool Service Revenue
4,000
17
31-Jul
411 Cash
2,250
18
111
Pool Service Revenue
2,250
31-Jul
517 Electric Expense
500
19
111
Cash
500
20
31-Jul
313 Dividends
1,100
111
Cash
1,100
3 - Trial Balance
4&5 Adjusting Entries
6 - Adjusted TB
7 - Financial Statemen
1 - Journal Entries
2 - General Ledger
3 - Trial Balance
485 Adjusting Entries
6 - Adjusted TB
7 - Finan
Ready
dy
P Type here to search
Type here to search
画
Transcribed Image Text:Peter's Pool Corporation
Adjusted Trial Balance
July 31
2
3 Account
4 Number
Account
Balance
Title
Debit
Credit
5
8
9.
10
11
12
1 Requirement #4: Prepare adjusting entries using the following information in the General Journal belo
1 Show your calculations!
a) One month's insurance has expired.
b) The remaining inventory of repair supplies is $250.
e) The estimated depreciation on repair equipment is $160.
d) The estimated income taxes are $95.
Requirement #5: Post the adjusting entries on Julr 31 below to the General Ledger T-accounts
(Step 2) and compute adjusted balances. Just add to the balances that are already listed.
+ 100%
Requirement #4
Account
Number
from Chart
of Accounts
Date
tab
Account Title from Chart of Accounts tab
Debit
Credit
513 Insurance Expense
119
514 Supply Expense
31-Ju
400
Prepaid Insurance
400
200
Supplies
200
515 Depreciation Expense
145
160
Accumulated Depreciation Expense
160
516 Income Tax Expense
213
95
Income Tax Payable
95
Definition Definition Statement that shows the ending balance of all the ledger accounts of a firm at the end of the accounting period. The trial balance is prepared after all the entries have been posted to the ledger accounts and assists in preparing the final accounts of a firm.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
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.
