Assets 101 Cash Eli's Consulting Services Chart of Accounts 111 Accounts Receivable 121 Supplies 134 Prepaid...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assets 101 Cash Eli's Consulting Services Chart of Accounts 111 Accounts Receivable 121 Supplies 134 Prepaid Insurance 137 Prepaid Rent 141 Equipment 142 Accumulated Depreciation- Equipment Liabilities 202 Accounts Payable Owner's Equity 301 Trayton Eli. Capital 302 Trayton Eli. Drawing 309 Income Summary ہے Revenue 401 Fees Income Expenses 511 Salaries Expense 514 Utilities Expense 517 Supplies Expense 520 Rent Expense 523 Depreciation Expense- Equipment 526 Advertising Expense 529 Maintenance Expense 532 Telephone Expense 535 Insurance Expense Jan. 2 Purchased supplies for $7,000; issued Check 1015. 2 Purchased a one-year insurance policy for $8,400; issued Check 1016. 7 Sold services for $20,000 in cash and $5,000 on credit during the first week of January. Collected a total of $4,000 on account from credit customers during the first week of Jan Issued Check 1017 for $3,600 to pay for special promotional advertising to new business station during the month. 13 Collected a total of $4.500 on account from credit customers during the second week of 14 Returned supplies that were damaged for a cash refund of $750. 15 20 20 Sold services for $20.700 in cash and $2.300 on credit during the second week of January Purchased supplies for $5,000 from White's, Inc.: received Invoice 2384 payable in 30 da Sold services for $12,500 in cash and $3.500 on credit during the third week of January. Collected a total of $5.600 on account from credit customers during the third week of Jan Issued Check 1018 for $7,065 to pay for maintenance work on the office equipment. 20 21 Issued Check 1019 for $3.600 to pay for special promotional advertising to new businesse newspaper. 23 Received the monthly telephone bill for $1.025 and paid it with Check 1020. 12 12 22 23 Received the monthly telephone bill for $1,025 and paid it with Check 1020. 26 Collected a total of $1,600 on account from credit customers during the fourth week of January. 27 Issued Check 1021 for $3,000 to Office Plus as payment on account for Invoice 2223. 28 Sent Check 1022 for $2,675 in payment of the monthly bill for utilities. 29 Sold services for $19,000 in cash and $2,750 on credit during the fourth week of January. 31 Issued Checks 1023-1027 for $32,800 to pay the monthly salaries of the regular employees and t time workers. Issued Check 1028 for $12,000 for personal use. Issued Check 1029 for $4.150 to pay for maintenance services for the month. Purchased additional equipment for $15.000 from Contemporary Equipment Company: issued Che $10,000 and bought the rest on credit. The equipment has a five-year life and no salvage value. Sold services for $7.600 in cash and $1.620 on credit on January 31. 31 31 31 31 The forms you need have been set up in Excel and are labeled along the bottom left of the scree in the sheet tabs. You will need to customize your worksheet by giving your group a unique nam and entering the group name in cell B1 of each sheet. Follow the directions carefully to comple the project. You will then perform the following operations in the order given. Please read and follow the directions carefully. 1. Record the transactions in the journal Use tab "Gen Journal" to record the journal entries listed on page 193 of the textbook. Use the accounts given on page 192, do not add any additional accounts. Record the journal entries on tab "Gen Journal" in the order given. You do not need to include explanations for the entries. Skip a line between journal entries. Do not do the adjusting entries yet. 2. Post the journal entries to the T-Accts Post your journal entries to the T-Accounts in the Excel file on tab "T-Accts". The amounts already in the T-Accounts are the beginning balances and should be included in your balances. You do not need to enter the date or journal page number of the transaction in Excel. Start at the top of each side of the T-accounts as the journal entries require, do not skip lines in the T- accounts. Do not add any new accounts, all the accounts you need have already been set up. The account balance will update with each posting. Do not do the adjustments yet! 3. Prepare a Trial Balance Click on the Trial Balance tab and enter the accounts and ending balances from the T-accounts. The total of your Trial Balance should be $234,320. If it does not, make any necessary corrections before you proceed. 4. Record the Adjusting Entries in the Journal and post to the T-Accts Record the adjusting entries on the "Gen Journal" tab after the journal entries you recorded in step #1. The adjusting entries are found on page 192 (5 a-d). Skip a line after the last entry and write "Adjusting Entries" in the middle of the account column then journalize the adjusting entries. You do not need an explanation, but skip a line between entries. All the adjusting entries should be dated January 31. Post the adjusting entries to the T-Accounts. You do not need to enter the page number or date in the T-Accounts. Use the same set of T-accounts that you used in Step #2, the adjusting entries are to adjust those T-account balances. 5. Prepare an Adjusted Trial Balance Click on the Adjusted Trial Balance tab and enter the accounts and ending balances from the T- accounts, after you have posted your adjusting entries. The total of your Adjusted Trial Balance should be $234,503. If it does not, make any necessary corrections before you proceed. 6. Prepare the Financial Statements Click on the Financials tab in Excel and complete the financial statements using the information from the Adjusted Trial Balance. The accounts and amounts should only be entered in the outlined cells. The totals should update as you enter the amounts. Check Figures: Net Income $28,122.00; Total Assets $155,289.00. 7. Prepare the Closing Entries and post to the T-Accts Record the closing entries in the journal after the adjusting entries you recorded in step #4. Skip a line after the last adjusting entry and write "Closing Entries" in the middle of the account column then journalize the closing entries. Make sure you prepare the entries in the correct orde as we learned in class. You do not need an explanation, but skip a line between entries. All the closing entries should be dated January 31. Post the closing entries to the T-Accounts. You do not need to enter the page number or date in the T-Accounts. Use the same set of T-accounts tha you used in Step #2 & 4, the closing entries are to close those T-account balances. 8. Prepare a Post-Closing Trial Balance Click the Post-Closing TB tab in Excel. Complete the post closing trial balance with the balances from the T-Accounts. Points will be assigned based on the following: RUBRIC General Journal (3) T-Accts (3) Trial Balance (4) Adj Trial Balance (3) Financials (BS 3, IS 3, RE 3) Post Closing (3) TOTAL: 25 pts. Assets 101 Cash Eli's Consulting Services Chart of Accounts 111 Accounts Receivable 121 Supplies 134 Prepaid Insurance 137 Prepaid Rent 141 Equipment 142 Accumulated Depreciation- Equipment Liabilities 202 Accounts Payable Owner's Equity 301 Trayton Eli. Capital 302 Trayton Eli. Drawing 309 Income Summary ہے Revenue 401 Fees Income Expenses 511 Salaries Expense 514 Utilities Expense 517 Supplies Expense 520 Rent Expense 523 Depreciation Expense- Equipment 526 Advertising Expense 529 Maintenance Expense 532 Telephone Expense 535 Insurance Expense Jan. 2 Purchased supplies for $7,000; issued Check 1015. 2 Purchased a one-year insurance policy for $8,400; issued Check 1016. 7 Sold services for $20,000 in cash and $5,000 on credit during the first week of January. Collected a total of $4,000 on account from credit customers during the first week of Jan Issued Check 1017 for $3,600 to pay for special promotional advertising to new business station during the month. 13 Collected a total of $4.500 on account from credit customers during the second week of 14 Returned supplies that were damaged for a cash refund of $750. 15 20 20 Sold services for $20.700 in cash and $2.300 on credit during the second week of January Purchased supplies for $5,000 from White's, Inc.: received Invoice 2384 payable in 30 da Sold services for $12,500 in cash and $3.500 on credit during the third week of January. Collected a total of $5.600 on account from credit customers during the third week of Jan Issued Check 1018 for $7,065 to pay for maintenance work on the office equipment. 20 21 Issued Check 1019 for $3.600 to pay for special promotional advertising to new businesse newspaper. 23 Received the monthly telephone bill for $1.025 and paid it with Check 1020. 12 12 22 23 Received the monthly telephone bill for $1,025 and paid it with Check 1020. 26 Collected a total of $1,600 on account from credit customers during the fourth week of January. 27 Issued Check 1021 for $3,000 to Office Plus as payment on account for Invoice 2223. 28 Sent Check 1022 for $2,675 in payment of the monthly bill for utilities. 29 Sold services for $19,000 in cash and $2,750 on credit during the fourth week of January. 31 Issued Checks 1023-1027 for $32,800 to pay the monthly salaries of the regular employees and t time workers. Issued Check 1028 for $12,000 for personal use. Issued Check 1029 for $4.150 to pay for maintenance services for the month. Purchased additional equipment for $15.000 from Contemporary Equipment Company: issued Che $10,000 and bought the rest on credit. The equipment has a five-year life and no salvage value. Sold services for $7.600 in cash and $1.620 on credit on January 31. 31 31 31 31 The forms you need have been set up in Excel and are labeled along the bottom left of the scree in the sheet tabs. You will need to customize your worksheet by giving your group a unique nam and entering the group name in cell B1 of each sheet. Follow the directions carefully to comple the project. You will then perform the following operations in the order given. Please read and follow the directions carefully. 1. Record the transactions in the journal Use tab "Gen Journal" to record the journal entries listed on page 193 of the textbook. Use the accounts given on page 192, do not add any additional accounts. Record the journal entries on tab "Gen Journal" in the order given. You do not need to include explanations for the entries. Skip a line between journal entries. Do not do the adjusting entries yet. 2. Post the journal entries to the T-Accts Post your journal entries to the T-Accounts in the Excel file on tab "T-Accts". The amounts already in the T-Accounts are the beginning balances and should be included in your balances. You do not need to enter the date or journal page number of the transaction in Excel. Start at the top of each side of the T-accounts as the journal entries require, do not skip lines in the T- accounts. Do not add any new accounts, all the accounts you need have already been set up. The account balance will update with each posting. Do not do the adjustments yet! 3. Prepare a Trial Balance Click on the Trial Balance tab and enter the accounts and ending balances from the T-accounts. The total of your Trial Balance should be $234,320. If it does not, make any necessary corrections before you proceed. 4. Record the Adjusting Entries in the Journal and post to the T-Accts Record the adjusting entries on the "Gen Journal" tab after the journal entries you recorded in step #1. The adjusting entries are found on page 192 (5 a-d). Skip a line after the last entry and write "Adjusting Entries" in the middle of the account column then journalize the adjusting entries. You do not need an explanation, but skip a line between entries. All the adjusting entries should be dated January 31. Post the adjusting entries to the T-Accounts. You do not need to enter the page number or date in the T-Accounts. Use the same set of T-accounts that you used in Step #2, the adjusting entries are to adjust those T-account balances. 5. Prepare an Adjusted Trial Balance Click on the Adjusted Trial Balance tab and enter the accounts and ending balances from the T- accounts, after you have posted your adjusting entries. The total of your Adjusted Trial Balance should be $234,503. If it does not, make any necessary corrections before you proceed. 6. Prepare the Financial Statements Click on the Financials tab in Excel and complete the financial statements using the information from the Adjusted Trial Balance. The accounts and amounts should only be entered in the outlined cells. The totals should update as you enter the amounts. Check Figures: Net Income $28,122.00; Total Assets $155,289.00. 7. Prepare the Closing Entries and post to the T-Accts Record the closing entries in the journal after the adjusting entries you recorded in step #4. Skip a line after the last adjusting entry and write "Closing Entries" in the middle of the account column then journalize the closing entries. Make sure you prepare the entries in the correct orde as we learned in class. You do not need an explanation, but skip a line between entries. All the closing entries should be dated January 31. Post the closing entries to the T-Accounts. You do not need to enter the page number or date in the T-Accounts. Use the same set of T-accounts tha you used in Step #2 & 4, the closing entries are to close those T-account balances. 8. Prepare a Post-Closing Trial Balance Click the Post-Closing TB tab in Excel. Complete the post closing trial balance with the balances from the T-Accounts. Points will be assigned based on the following: RUBRIC General Journal (3) T-Accts (3) Trial Balance (4) Adj Trial Balance (3) Financials (BS 3, IS 3, RE 3) Post Closing (3) TOTAL: 25 pts.
Expert Answer:
Answer rating: 100% (QA)
Elis Consulting Services Journal entries Date Account 2Jan Supplies Cash 2Jan Prepaid Insurance Cash ... View the full answer
Related Book For
Andersons Business Law and the Legal Environment
ISBN: 978-0324786668
21st Edition
Authors: David p. twomey, Marianne moody Jennings
Posted Date:
Students also viewed these accounting questions
-
The balance sheets of Hill Corp. and McGraw Ltd. on December 31, Year 4, were as follows: On December 31, Year 4, Hill purchased 80% of the common shares of McGraw for $288,000 plus a commitment to...
-
McGraw Trucking Company is considering a cash acquisition of Hill Storage Company for $3 million. Hill Storage will provide the following pattern of cash inflows and synergistic benefits for the next...
-
Stock B A k Number of shares PRICE T T+1 1,000,000 *70 45 50 10,000,000 20 40 30 30,000,000 15 **32 36 *STOCK B HAD A SPLIT AT THE END OF DAY T **STOCK K HAS A STOCK REVERESE BY THE END OF DAY T+1...
-
A rectangular loop of wire 24 cm by 72 cm is bent into an L shape, as shown in FIGURE 23-49. The magnetic field in the vicinity of the loop has a magnitude of 0.035 T and points in a direction...
-
A change in a factor of demand or a factor of supply (or both) will change the point of market equilibrium in a predictable way. Explain what will happen to equilibrium price and equilibrium quantity...
-
The power plant shown in Fig. 11.40 combines a gas-turbine cycle and a steam turbine cycle. The following data are known for the gas-turbine cycle. Air enters the compressor at 100 kPa, 25C, the...
-
Identify the most appropriate approach and then design. Provide a rationale as to why this approach and design would be most appropriate. Develop a hypothetical research scenario that would...
-
Electro Fans has just received an order for one thousand 20-inch fans due week 7. Each fan consists of a housing assembly, two grills, a fan assembly, and an electrical unit- The housing assembly...
-
Create a table in excel showing net present value calculation for the following scenario. You will have a column with time period, future value, and present value included. You can anticipate that...
-
The following condensed balance sheet is for the partnership of Gulian, Singh, and Zahiri, who share profits and losses in the ratio of 4:3:3, respectively: The partners decide to liquidate the...
-
: Suppose that an economy is composed of three individuals with incomes y = 100, Y2 = 50 and y3 = 150. All individuals have an identical utility function u;= In(yi). The government wants to implement...
-
Explain how individuals can make healthier choices if they choose to eat at fast food outlets. Where are the hidden calories in typical fast food menus? What options exist at fast food restaurants...
-
Compose a Claim Letter to one of the Service Providers of Cellphones or Internet service, where you purchased the service, and or a device. You were later disappointed with the service received or...
-
The emails are not according to its rule. Please correct the email maintaining all proper guidelines of writing an email Subject: Dates It's really tough to book rooms for meetings since they fill up...
-
Use the information provided to solve for the face value of the T-bill. Purchase Price on Term Yield Face Value Date of Issue (Days) $140,745.501285 320 7.5% $ Number
-
What ethical dilemmas arise in the pursuit of balancing individual rights with collective interests, particularly in contexts where national security imperatives, public health emergencies, or...
-
What is the difference between a director who is a manager and a director who is a leader in childcare? List 3-5 skills that best describe an effective program director . List 3-5 skills that you...
-
Kims Konstructions has assembled the following data for a proposed straw-reinforced brick maker (SRBM): SRBM Cost: $26,000 Life: 5 years Revenue (p.a.) $11,000 Operating Expenses (p.a.) $3,000...
-
Lloyd and Mario Spaulding entered into a contract to purchase property from Richard and Robert Krajcir. The two Spaulding brothers signed a promissory note to the Krajcir brothers with the following...
-
The Federal Food Stamp Act provided for the distribution of food stamps to needy households. In 1971, section 3(e) of the statute was amended to define households as limited to groups whose members...
-
New Beginnings provides rehabilitation services for alcohol and drug abuse to both adults and adolescents. New Beginnings entered into negotiation with Adbar for the lease of a building in the city...
-
Show that the vector potentials given in Eq. (27.1) imply the magnetic fields given in Eq. (27.2) by evaluating \(\boldsymbol{B}=\boldsymbol{abla} \times \boldsymbol{A}\) in the cylindrical...
-
Prove the result of Eq. (26.10) that a path-dependent representation of a gauge group is sensitive to a gauge transformation only at the endpoints of the path.
-
Use Stokes' theorem [Eq. (27.5)] to prove that Eq. (27.4) leads to Eq. (27.6). Data from Eq. 27.4 Data from Eq. 27.5 Data from Eq. 27.6 = z ) ); A dr. - SA dr) = f A dr.
Study smarter with the SolutionInn App