80.2K

Verified Solution

Link Copied!

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 Cash Accounts Receivable Supplies Equipment Accumulated Depreciation-Equipment Account Titles Accounts Payable Unearned Service Revenue Common Stock Retained Earnings Dividends Other data: Service Revenue Salaries and Wages Expense Miscellaneous Expense Requirements: 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 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. 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,

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. Joumalize the adjusting entries from the adjustments columns of the worksheet 2. Enter the trial balance on a worksheet and complete the worksheet. 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. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{mim0A} & c & 0 & E & F & & n & 11 & k & t & 4 & n & % & , & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & 1 & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & 5 & Gion & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline- & & & & & & & & & & & & & & \\ \hline & = & & & & & & & & & & & & & \\ \hline- & - & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline - & & & & & & & & & & & & & & \\ \hline & = & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & E & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \hline E & xercise & Adju & ting Entri & 5 & doger & Closing Entrie & 109 Finan & clats & Finar & clats? & & neet1 & + & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer