Accounting_Course_ Project_ ACCT500_
.xlsx
keyboard_arrow_up
School
University Of Arizona *
*We aren’t endorsed by this school
Course
500B
Subject
Accounting
Date
Feb 20, 2024
Type
xlsx
Pages
17
Uploaded by KidRainPorpoise37
Requirement
1
2
3
There are also hints c
You can hover over t
Hints are provided for th
1) The debits for the jour
2) The credits for the jou
3) The cash balance is on
4) The debits for the trial
5) The credits for the tria
ACCT500: Course Project
Requirement Description
Prepare the Journal Entries in the General Journal
Post Journal Entries to the General Ledger
Prepare a Trial Balance
contained within certain cells on some of the Worksheet ta
the red pointer at the top right-hand corner of the cell to re
he following balances:
rnal entries are on the Journal Entries tab.
urnal entries are on the Journal Entries tab.
n the General Ledger tab.
l balance are on the Trial Balance tab.
al balance are on the Trial Balance tab.
Worksheet Name
1 - Journal Entries
2 - General Ledger
3 - Trial Balance
abs. ead the hint.
September Transactions
Date
Transaction Description
September 1
September 1
Purchased insurance for the year and paid $3,000 cash.
September 2
September 5
September 6
Purchased supplies for $2,000 on account. September 7
Paid $750 cash for advertising in local newspapers.
September 10
Received $15,000 in cash for plumbing services provided. September 12
September 15
Provided plumbing services on account for $2,500.
September 23
Received $22,000 in cash for plumbing services provided. September 25
September 28
Paid $500 cash for a utility bill.
September 30
Paid cash dividends of $1,000.
September 30
One month's insurance expired.
September 30
During its first month of operation, the Plumbing Repair Company, which, specializes in plumbing repair services, completed the following transactions.
Started a plumbing repair business by making a $100,000 deposit in a company bank account, in exchange for 20,000 shares of $5 par value common stock.
Paid monthly rent with $3,500 cash on a warehouse to store the plumbing equipment.
Purchased plumbing equipment for $25,000, making a $5,000 down payment and placing $20,000 on account. Paid $5,000 for plumbing equipment previously purchased on account on September 5th. Received $1,500 cash for plumbing services performed on account on September 15th.
The inventory of supplies showed a balance of $1,200 on hand at the end of the month.
Use the following account descriptions for journal entries.
Chart of Accounts
Account Type
Account Title
Normal Balance
Assets
111
Cash Debit
115
Accounts Receivable
Debit
117
Supplies
Debit
119
Prepaid Insurance
Debit
144
Equipment Debit
Liabilities
212
Accounts Payable Credit
Stockholders Equity
311
Common Stock Credit
313
Dividends Debit
Revenue
411
Service Revenue
Credit
Expenses
510
Insurance Expense
Debit
511
Rent Expense Debit
512
Advertising Expense Debit
514
Supplies Expense
Debit
517
Utility Expense
Debit
Account Number
Journal Entries
General Journal
Date
Account Title from Chart of Accounts tab
Debit
1-Sep
111
Cash
100,000
311
Common Stock
1-Sep
119
Prepaid Insurance
3,000
111
Cash
2-Sep
511
Rent 3,500
111
Cash
5-Sep
144
Equipment
25,000
111
Cash
212
Accounts Payable
.
6-Sep
117
Supplies Expense
2,000
212
Accounts Payable
7-Sep
512
Advertising Expense
750
111
Cash
10-Sep
111
Cash
15,000
411
Service Revenue
12-Sep
212
Accounts Payable
5,000
111
Cash
15-Sep
115
Accounts Recievable
2,500
411
Service Revenue
23-Sep
111
Cash
22,000
411
Service Revenue
25-Sep
111
Cash
1,500
115
Accounts Recievable
28-Sep
517
Utility Expense
500
111
Cash
30-Sep
313
Dividends
1,000
REQUIREMENT #1:
Prepare journal entries to record the September transactions in the
Journal below. Remember that Debits must equal Credits—All of your Journal Entries shou
balance.
Account Number from Chart of Accounts tab
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
History
Bookmarks
Window Help
A education.wiley.c
WP NWP Assessment Player UI Application
Question 18 of 42
View Policies
Current Attempt in Progress
The double-entry system requires that each transaction must be recorded
in a journal and in a ledger.
in two sets of books.
first as a revenue and then as an expense.
in at least two different accounts.
Save for Later
arrow_forward
pokmarks
Window Help
A edu
Exam 1
WP NWP Assessment Player UI Application
Question 21 of 42
View Policies
Current Attempt in Progress
A compound journal entry involves
four or more accounts.
three accounts only.
two accounts.
three or more accounts.
Save for Later
arrow_forward
WP NWP Assessment Player UI Applic
Question 17 of 42
View Policies
Current Attempt in Progress
Credits
decrease both assets and liabilities.
increase both assets and liabilities.
decrease assets and increase liabilities.
O increase assets and decrease liabilities.
Save for Later
arrow_forward
whats the answer for number 2
arrow_forward
Directions
1
Given
cose =
2, and is in Quadrant 1, what is tane?
You must show all of your work to receive credit for this problem.
Please choose one option to complete this activity.
Sketchpad
FILE UPLOAD i
Question 7
OR
1
File Upload
Upload your work. Show all steps to receive credit for this problem.
arrow_forward
View
History
Bookmarks
Window Help
A education.wiley
Exam 1
WP NWP Assessment Player UI Application
Question 20 of 42
View Policies
Current Attempt in Progress
The usual sequence of steps in the transaction recording process is:
journal ledger → analyze.
analyze journal ledger.
journal analyze ledger.
ledger journal → analyze.
Save for Later
arrow_forward
Personal Financial Statement Project
For the Personal Financial Statement Project:
1. Record the events on the next page in the accompanying
formula worksheet
2. Write out the journal entries for the events on the next page
3. Create the financial statements with the ending information
from the worksheet
4. Once you have your Financial Statements completed,
please make a comment or two in the online text input box
about what the information is telling you
Event List
1. Opened a bank account with previously earned (retained
earnings) money for $100,000
2. Bought a house by paying $75,000 down in cash and taking a
loan of $225,000
3. Bought a vehicle by paying $1,000 down in cash and taking a
loan of $44,000
4. Worked (performed services) to clients for $80,000 cash
5. Paid for materials used (expense) in the services performed
with cash for $50,000
6. Paid for repairs and utilities of the house and vehicle (just
regular expenses) with cash for $8,500
7. During the year, you paid $5,000…
arrow_forward
Make a general ledger for each account title from the general journal below.
arrow_forward
Prepare the following journal entries
arrow_forward
1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…
arrow_forward
Please use the workbook page, it has the steps on how to solve the problems.
arrow_forward
Academic access to the FASB Codification is available through university subscriptions, obtained from the American Accounting Association. This subscription covers an unlimited number of students within a single institution. Once this access has been obtained by your school, you should log in to prepare responses to the following exercises.
CE1.1 Describe the main elements of the link labeled “Help, FAQ, Learning Guide, and About the Codification.”
CE1.2 Describe the procedures for providing feedback.
CE1.3 Briefly describe the purpose and content of the “What’s New” link.
arrow_forward
Need help in feeling out the chart. Thank you
arrow_forward
View Assessment
se data from Rollaird
Live balance sheets, perform a
Use Chapter 13 "Financial
ture" as a guidance.
g your numbers, use whole
ation, and one decimal point
een in the example below. The
ht red if incorrect after clicking
bottom right corner).
Terminology Matching - Academic Resources
EHCS380 Week 4 Horizontal and Vertical Analysis
00
multimedia.phoenix.edu
b Answered: Terminology Matching Independent... | bartleby
Accounts Receivable
Inventory
Total Assets
DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a vertical
analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance.
Dec. 31, 2022
460,000
780,000
3,164,000
Example:
Dec. 31, 2021
Accounts Receivable 2022
400,000
650,000
2,800,000
NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point
for the answer, as seen in the example below. The text box will highlight red if incorrect after
clicking the Submit button (bottom right corner).…
arrow_forward
Hi I need help with the balance sheet
arrow_forward
Question 6
What are 2 ways to begin setting up a recurring transaction in
QuickBooks Online?
Gear > Account and settings > Advanced > Enable recurring transactions
Accountant Tools > Recurring transactions
Gear > Recurring transactions
+New > Recurring transaction
Select the Make recurring option at the bottom of the desired transaction
arrow_forward
Do not use chatgpt
arrow_forward
Assessment Builder UI App X
iley.com/was/ui/v2/assessment-player/index.html?launchld%3D562228aa-1a3a-4c39-9085-b90c7defbe14#/question/1
NWP Assessment Player UI Appli X
Chapter 3
Question 2 of 5
The ledger of Blossom, Inc. on March 31, 2022, includes the following selected accounts before adju
Debit
Credit
Prepaid Insurance
$2,000
Supplies
2,000
Equipment
29,000
Unearned Service Revenue
$8,500
An analysis of the accounts shows the following.
1.
Insurance expires at the rate of $400 per month.
2.
Supplies on hand total $1,400.
3.
The equipment depreciates $300 per month.
4.
During March, services were performed for two-fifths of the unearned service revenue.
Prepare the adjusting entries for the month of March. (List all debit entries before credit entries. Credit account titles are autn
Credu
indented when the amount is entered. Do not indent manually.)
Debit
Date
Account Titles and Explanation
No.
rch
arrow_forward
A course.apexlearning.com
pugarWeb for Applicants
Mail - Kylee Willison - Outlook
Student Email | Columbus State Com..
Ap
L 1.2.7 Quiz: Accounts Payable Process
Question 2 of 10
Which of the following is recorded in the purchases journal?
A. orders made by the customer paid for with cash
B. orders made by the business paid for with cash
C. orders made by the customer on credit or account
D. orders made by the business on credit or account
SUBMIT
E PREVIOUS
FEB
TO
6.
(30)
MacBook Air
arrow_forward
LinkedIn Learning
Free App for Android
in
Question 3 of 14:
Select an answer:
The US GAAP provides rules and guidance
for what two primary financial reporting
purposes?
Return to course
recognition and measurement
risk assessment and presentation
recognition and presentation
Open
initial and subsequent measurement
Previous
Skip
arrow_forward
E
Question 2 of 20:
Select the best answer for the question.
2. Accounts are generally grouped and kept together in the
O A. ledger
O B. general journal.
OC. book of original entry
OD. trial balance.
Mark for review (Will be highlighted on the review page)
<< Previol Question
Type here to search
Next Question
O
arrow_forward
I want a explain how i can fill this table with details ask me In this question
arrow_forward
Image 1 is the information
Do #2 on image 2 plz
arrow_forward
!
Required information
[The following information applies to the questions displayed below.]
Clopack Company manufactures one product that goes through one processing department called Mixing. All raw
materials are introduced at the start of work in the Mixing Department. The company uses the weighted-average method
of process costing. Its Work in Process T-account for the Mixing Department for June follows (all forthcoming questions
pertain to June):
June 1 balance
Materials
Direct labor
Overhead
June 30 balance.
Debit
Work in Process-Mixing Department
View transaction list
27,000
151, 13
95,500
113,000
?
The June 1 work in process inventory consisted of 4,400 units with $14,100 in materials cost and $12,900 in conve
cost. The June 1 work in process inventory was 100% complete with respect to materials and 60% complete with respect
to conversion. During June, 36,900 units were started into production. The June 30 work in process inventory consisted
of 8,800 units that were 100%…
arrow_forward
Conduct the below exercise
Step-1: Click the link
The student can use any of the below links to download the same
a) https://www.imf.org/-
/media/Files/Publications/WEO/2021/Update/January/English/data/WEOJan2021updat
e.ashx
b) https://www.imf.org/en/Publications/WEO/Issues/2021/01/26/2021-world-economicoutlook-
update
(And click on download data)
Step-2: Answer the below questions
What do you understand by Real GDP? What is the Real GDP Growth Rate of India and
China in 2019? What is the estimated real GDP growth rate of India and China in 2020?
What is the projected real GDP growth rate of India and China in 2021 and 2022?
What is the estimated 2022 GDP Loss (in percentage) in comparison to pre-covid levels
(January 2020 forecast) in China and Other Emerging Economies in Asia other than
China?
arrow_forward
Need help with these questions please. Thank you
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Related Questions
- History Bookmarks Window Help A education.wiley.c WP NWP Assessment Player UI Application Question 18 of 42 View Policies Current Attempt in Progress The double-entry system requires that each transaction must be recorded in a journal and in a ledger. in two sets of books. first as a revenue and then as an expense. in at least two different accounts. Save for Laterarrow_forwardpokmarks Window Help A edu Exam 1 WP NWP Assessment Player UI Application Question 21 of 42 View Policies Current Attempt in Progress A compound journal entry involves four or more accounts. three accounts only. two accounts. three or more accounts. Save for Laterarrow_forwardWP NWP Assessment Player UI Applic Question 17 of 42 View Policies Current Attempt in Progress Credits decrease both assets and liabilities. increase both assets and liabilities. decrease assets and increase liabilities. O increase assets and decrease liabilities. Save for Laterarrow_forward
- whats the answer for number 2arrow_forwardDirections 1 Given cose = 2, and is in Quadrant 1, what is tane? You must show all of your work to receive credit for this problem. Please choose one option to complete this activity. Sketchpad FILE UPLOAD i Question 7 OR 1 File Upload Upload your work. Show all steps to receive credit for this problem.arrow_forwardView History Bookmarks Window Help A education.wiley Exam 1 WP NWP Assessment Player UI Application Question 20 of 42 View Policies Current Attempt in Progress The usual sequence of steps in the transaction recording process is: journal ledger → analyze. analyze journal ledger. journal analyze ledger. ledger journal → analyze. Save for Laterarrow_forward
- Personal Financial Statement Project For the Personal Financial Statement Project: 1. Record the events on the next page in the accompanying formula worksheet 2. Write out the journal entries for the events on the next page 3. Create the financial statements with the ending information from the worksheet 4. Once you have your Financial Statements completed, please make a comment or two in the online text input box about what the information is telling you Event List 1. Opened a bank account with previously earned (retained earnings) money for $100,000 2. Bought a house by paying $75,000 down in cash and taking a loan of $225,000 3. Bought a vehicle by paying $1,000 down in cash and taking a loan of $44,000 4. Worked (performed services) to clients for $80,000 cash 5. Paid for materials used (expense) in the services performed with cash for $50,000 6. Paid for repairs and utilities of the house and vehicle (just regular expenses) with cash for $8,500 7. During the year, you paid $5,000…arrow_forwardMake a general ledger for each account title from the general journal below.arrow_forwardPrepare the following journal entriesarrow_forward
- 1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…arrow_forwardPlease use the workbook page, it has the steps on how to solve the problems.arrow_forwardAcademic access to the FASB Codification is available through university subscriptions, obtained from the American Accounting Association. This subscription covers an unlimited number of students within a single institution. Once this access has been obtained by your school, you should log in to prepare responses to the following exercises. CE1.1 Describe the main elements of the link labeled “Help, FAQ, Learning Guide, and About the Codification.” CE1.2 Describe the procedures for providing feedback. CE1.3 Briefly describe the purpose and content of the “What’s New” link.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning