REQUIREMENTS: 1. Prepare Journal Entries in the General Journal and post to the General Ledger. 2....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
REQUIREMENTS: 1. Prepare Journal Entries in the General Journal and post to the General Ledger. 2. Prepare adjusting entries in the General Journal and post to the General Ledger. 3. Prepare an Income Statement, Equity Statement, and Balance Sheet 4. Prepare closing entries in the General Journal for the month of October. Note: If you are using the Journal Forms provided in Excel, you will only need to enter your transactions in the journal. The General Ledger and the Financial Statements will be updated once you enter your answers into the journal. You should enter your transactions in the green-colored cells. You should not change or alter any other part of the spreadsheet as formulas from the General Ledger and Financial Statements are linked to the journal. If you are completing this project manually, then I suggest that you use T-accounts as your General Ledger. For each transaction below, record journal entries in proper format before you post to the ledger. Use the following accounts: Cash, Accounts Payable, Accounts Receivable, Equipment, Supplies, Capital, Drawing, Repair Revenue, Prepaid Insurance, Wages Expense, Utilities Expense, Depreciation Expense, Accumulated Depreciation, Insurance Expense, Supplies Expense, Wages Payable Note: These Accounts are already set up for you in the Chart of Accounts in the Excel Document that has been provided. October Transactions October 1 The owner invested $40,000 cash in the business October 1 Purchased equipment for $15,000 on account. October 1 Purchased a 4-year insurance policy to insure the business for $2000 for cash. October 2 Paid $2000 cash for supplies. October 4 Received $3,000 cash from customers for services rendered October 14 Paid for the equipment purchase on October 1. October 15 Paid wages $1,750 October 16 Performed services worth $4,500 for credit customers October 20 Received $1,400 cash from customers previously billed on account October 22 The owner withdrew $3,400 cash for personal use October 31 Paid utility bill for October $500. End of Month Adjustments-October 31 1. Assume that the equipment purchased on October 1 has no trade-in value and an expected life of 5 years. Prepare the adjusting entry for the month of October. 2. Prepare the adjusting entry for the insurance policy purchased on October 1 for the month of October. 3. After taking a physical count of the supplies, you discover that there are actually $1,400 of supplies left in the supply room. Prepare the adjusting entry for supplies for the month of October. 4. Wages for October 29 - 31 are unpaid at the end of the month. Normally, wages for a regular 5-day work week total $5,000. Prepare the adjusting entry for unpaid wages for the month of October. Note: The Financial Statements will be updated automatically after you have entered your adjusting entries. Additionally, you will need to refer to your General ledger to assist you with calculating the adjusting entries. Financial Statements 1. Prepare an Income Statement for the month of October. 2. Prepare an Equity Statement for the month of October. 3. Prepare a Balance Sheet for the month of October. Note: The Financial Statements will be updated automatically once you have entered your adjusting entries into the general journal. Closing Entries 1. Prepare the closing entries for the month of October. Note: You will need to refer to the General Ledger to assist you with completing the closing entries. REQUIREMENTS: 1. Prepare Journal Entries in the General Journal and post to the General Ledger. 2. Prepare adjusting entries in the General Journal and post to the General Ledger. 3. Prepare an Income Statement, Equity Statement, and Balance Sheet 4. Prepare closing entries in the General Journal for the month of October. Note: If you are using the Journal Forms provided in Excel, you will only need to enter your transactions in the journal. The General Ledger and the Financial Statements will be updated once you enter your answers into the journal. You should enter your transactions in the green-colored cells. You should not change or alter any other part of the spreadsheet as formulas from the General Ledger and Financial Statements are linked to the journal. If you are completing this project manually, then I suggest that you use T-accounts as your General Ledger. For each transaction below, record journal entries in proper format before you post to the ledger. Use the following accounts: Cash, Accounts Payable, Accounts Receivable, Equipment, Supplies, Capital, Drawing, Repair Revenue, Prepaid Insurance, Wages Expense, Utilities Expense, Depreciation Expense, Accumulated Depreciation, Insurance Expense, Supplies Expense, Wages Payable Note: These Accounts are already set up for you in the Chart of Accounts in the Excel Document that has been provided. October Transactions October 1 The owner invested $40,000 cash in the business October 1 Purchased equipment for $15,000 on account. October 1 Purchased a 4-year insurance policy to insure the business for $2000 for cash. October 2 Paid $2000 cash for supplies. October 4 Received $3,000 cash from customers for services rendered October 14 Paid for the equipment purchase on October 1. October 15 Paid wages $1,750 October 16 Performed services worth $4,500 for credit customers October 20 Received $1,400 cash from customers previously billed on account October 22 The owner withdrew $3,400 cash for personal use October 31 Paid utility bill for October $500. End of Month Adjustments-October 31 1. Assume that the equipment purchased on October 1 has no trade-in value and an expected life of 5 years. Prepare the adjusting entry for the month of October. 2. Prepare the adjusting entry for the insurance policy purchased on October 1 for the month of October. 3. After taking a physical count of the supplies, you discover that there are actually $1,400 of supplies left in the supply room. Prepare the adjusting entry for supplies for the month of October. 4. Wages for October 29 - 31 are unpaid at the end of the month. Normally, wages for a regular 5-day work week total $5,000. Prepare the adjusting entry for unpaid wages for the month of October. Note: The Financial Statements will be updated automatically after you have entered your adjusting entries. Additionally, you will need to refer to your General ledger to assist you with calculating the adjusting entries. Financial Statements 1. Prepare an Income Statement for the month of October. 2. Prepare an Equity Statement for the month of October. 3. Prepare a Balance Sheet for the month of October. Note: The Financial Statements will be updated automatically once you have entered your adjusting entries into the general journal. Closing Entries 1. Prepare the closing entries for the month of October. Note: You will need to refer to the General Ledger to assist you with completing the closing entries.
Expert Answer:
Related Book For
College Accounting A Contemporary Approach
ISBN: 978-0077639730
3rd edition
Authors: David Haddock, John Price, Michael Farina
Posted Date:
Students also viewed these accounting questions
-
Prepare journal entries in the general fund for the following 2018 transactions that represent inflows of financial resources to Tyler City: 1. To pay the wages of part-time city maintenance...
-
Prepare journal entries in the General Fund of the Brownville School District. a. The District had outstanding encumbrances of $13,000 for band instruments from the previous year. It is the Districts...
-
If you are using data mining to develop a prospecting program for a client, what would you be trying to accomplish?
-
Once down to about 15, the worlds only wild flock of whooping cranes now numbers a record 237 birds in its Texas Coastal Bend wintering ground (www.SunHerald.com). The average whooping crane egg...
-
Helen makes cheesecakes using equipment that she rents for $300 and cheese and butter that cost $4.55 a cake. She hires workers and finds that they produce according to the following schedule:...
-
Which of the following is true? a. Continuous monitoring is the CAEs responsibility. b. If a control breakdown is identified through continuous auditing, it should be reported to management on a...
-
The condition for irreversibility of a cycle is: (a) \(\oint \frac{d Q}{T} <0\) (b) \(\oint \frac{d Q}{T}>0\) (c) \(\oint \frac{d Q}{T}=0\) (d) None of the above
-
On October 15, 2020, the board of directors of Ensor Materials Corporation approved a stock option plan for key executives. On January 1, 2021, 20 million stock options were granted, exercisable for...
-
The big hope housing company uses a predetermined overhead rate to allocate overhead based on Direct Labor cost. This years budget includes Overhead equal to $500,000 and Direct Labor cost of...
-
Laval produces lighting fixtures. Budgeted Information for Its two production departments follows. The departments use machine hours (MH) and direct labor hours (DLH). Overhead cost Direct labor...
-
1. Write a value returning function that receives three integers and returns the largest of the three. Assume the integers are not equal to one another. 2. Write a value returning function that...
-
Illustrate how the Fed goes about setting the federal funds rate (policy rate) at its target using open market operations (assume initially that the Fed does not pay interest on excess reserves)....
-
What is meant by fiscal agency? How might the Feds role as fiscal agent differ from that of many other central banks?
-
Why do you think that electronic communications networks (ECNs) are gaining market share over other platforms? What are the economic forces favoring them?
-
What determines whether an increase in the share of retained earnings increases or decreases share prices?
-
What is meant by disinflation? If the United States were experiencing disinflation, what would you conclude about the relationship between actual output (aggregate demand) and potential output...
-
Consider a European put option on a non-dividend paying stock. The price for this put option has a lower bound: X 2 mar (0. (1+277-5) So R) Po 0, Po is put price today. X is the strike price, 7 is...
-
Extend Algorithms 3.4 and 3.5 to include as output the first and second derivatives of the spline at the nodes.
-
On July 1, Guy Fernandez established Fernandez Home Appraisal Services, a firm that provides expert residential appraisals and represents clients in home appraisal hearings. INSTRUCTIONS Analyze the...
-
Why is Prepaid Rent considered an asset account?
-
The following information relates to Ponte Manufacturing Companys workers compensation insurance premiums for 2016. On January 15, 2016, the company estimated its premium for workers compensation...
-
Shown below is a boxplot of a sample of 20 brain volumes (cm 3 ). What do the numbers in the boxplot represent? 963 1034.5 1079 1439 1188.5
-
Consider the prices of regular movie tickets (not 3-D, and not discounted for children or seniors). a. Estimate the mean price. b. Use the range rule of thumb to make a rough estimate of the standard...
-
A survey included 4230 responses from Internet users who decided to respond to a question posted by America OnLine (AOL). Here is the question: How often do you use credit cards for purchases? Among...
Study smarter with the SolutionInn App