Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started