Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

After examining and analyzing the information provided in the two (2) tables below, use a MS Excel sheet to perform the following exercise. Use a

After examining and analyzing the information provided in the two (2) tables below, use a MS Excel sheet to perform the following exercise. Use a different tab on the worksheet to display each requested part. Carmen Ramos started a business called Perfect Cleaning. The following transactions occurred in January 2020: Transaction Date January 1 Invested $ 10,000 in cash to start the business. January 3 Purchased a business vehicle for $ 12,000 of which $ 3,000 was in cash and the remainder in credit January 3 Purchased cleaning supplies totaling $ 1,500. January 4 she Paid for a $ 2,000 prepayment insurance policy effective January 1. January 5, she Performed a customer service (fee earned) in the amount of $ 2,100. January 10 she paid a credit to the vehicle purchased for $ 500 January 15 Paid salary to employees for $ 1,800. January 16 she did a cleaning job on a building on credit for $ 3,000. January 18, she did cleaning work in an office and collected it in cash for $ 2,500. January 20 The customer who had the job performed on January 16 paid $ 1,200. January 21 she Paid $ 80 for gas for the business vehicle. January 22, she did office cleaning work for $ 1,000 cash. January 25 she Paid $ 20 for gas for the business vehicle. January 28, she paid $ 500 for advertising expense. January 29 she made a withdrawal for personal use in the amount of $ 500. January 30, she paid employee wages of $ 1,800. The following list of accounts (chart of accounts) is used for the accounting books of the Perfect Cleaning company: Account number Account name 111 Cash 112 Accounts receivable (accounts receivable) 128 Cleaning supplies 130 Prepaid insurance 157 Equipment 158 Accumulated depreciation equipment 201 Accounts payable 212 Salaries payable 301 Carmen Ramos, capital 305 Carmen Ramos, retreat (drawing) 350 Income summary 400 Fee earned 632 Gas & oil expense 633 Cleaning supplies expense 710 Depreciation expense 712 Insurance expense 720 Salaries expense Journalize the transactions for the month of January in the general journal. Make (post) the entries in the ledger. Prepare the trial balance without adjustments as of January 31, 2020. Make the following adjustments: to. The depreciation of the equipment for one month is $ 205. b. One month of prepaid insurance expired. c. The cleaning supplies inventory balance at the end of the month is $ 200. d. Salary accrued but not paid to an employee (unpaid employee salary) is $ 600. Prepare the following reports in their corresponding spreadsheet: to. Income statement b. Statement of owner equity c. Balance sheet

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey of Accounting

Authors: Carl S Warren

6th edition

978-113318912, 1133189121, 978-1133189121

More Books

Students also viewed these Accounting questions

Question

Briefly explain the qualities of an able supervisor

Answered: 1 week ago

Question

Define policy making?

Answered: 1 week ago

Question

Define co-ordination?

Answered: 1 week ago

Question

What are the role of supervisors ?

Answered: 1 week ago