Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the excel spreadsheet also attached to this Canvas page, complete the accounting cycle. Answer all the questions in this problem. The trial balance columns

Using the excel spreadsheet also attached to this Canvas page, complete the accounting cycle. Answer all the questions in this problem. The trial balance columns of the worksheet for Martinez at March 31, 2019, are as follows. Martinez Worksheet For the Month Ended March 31, 2019 Other data: Account Titles Cash Accounts Receivable Supplies Equipment Accumulated Depreciation-Equipment Accounts Payable Unearned Service Revenue Common Stock Retained Earnings Dividends Service Revenue Salaries and Wages Expense Miscellaneous Expense Trial Balance Dr. 4,800 3,700 1,810 11,000 1,170 1,500 460 24,440 Cr. 1,250.0 2,140 430 10,140 3,680 1. A physical count reveals only $500 of roofing supplies on hand. 2. Depreciation for March is $250. 3. Unearned service revenue amounted to $230 at March 31. 4. Accrued salaries are $700. 6,800 24,440 Requirements: 1. Journalize the adjusting entries from the adjustments columns of the worksheet Enter the trial balance on a worksheet and complete the worksheet. 2. 3. Journalize the closing entries from the financial statement columns of the worksheet. 4. Prepare an income statement for the month of March 5. Prepare a retained earnings statement for the month of March 6. Prepare a classified balance sheet at March 31.
image text in transcribed
Using the excel spreadsheet also attached to this Canvas page, complete the accounting cycle. Answer all the questions in this problem. The trial balance columns of the worksheet for Martinez at March 31, 2019, are as follows. Other data: 1. A physical count reveals only $500 of roofing supplies on hand. 2. Depreciation for March is $250. 3. Unearned service revenue amounted to $230 at March 31 . 4. Accrued salaries are $700. Requirements: 1. Journalize the adjusting entries from the adjustments columns of the worksheet 2. Enter the trial balance on a worksheet and complete the worksheet. 3. Joumalize the closing entries from the financial statement columns of the worksheet. 4. Prepare an income statement for the month of March 5. Prepare a retained earnings statement for the month of March 6. Prepare a classified balance sheet at March 31

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

Introduction To Managerial Accounting

Authors: Peter C. Brewer, Ray H. Garrison, Eric W. Noreen

2nd Edition

0072922990, 9780072922998

More Books

Students also viewed these Accounting questions

Question

Distinguish between serial and parallel processing.

Answered: 1 week ago

Question

3. Explain how to conduct an appraisal feedback interview.

Answered: 1 week ago

Question

1. Answer the question, Who should do the appraising?

Answered: 1 week ago