Project C: Using $6$ excel spreadsheets, complete the accounting cycle.

Spreadsheet $1-$ Put together the following: A worksheet that includes Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement, Balance Sheet all in one place.

Spreadsheet $2-$ Adjusting Entries in a General Journal.

Spreadsheet $3-$ A ledger.

Spreadsheet $4-$ Closing entries in a General Journal.

Spreadsheet $5-$ An income statement and Retained Earnings Statement

Spreadsheet $6-$ A balance sheet.

The trial balance columns of the worksheet for Martinez on March $31,2019,$ are as follows.

$\backslash$table$[[$Martinez

Worksheet

For the Month Ended March $31,2019],[,$Trial Balance$],[$Account Titles,Dr$.,$Cr$.],[$Cash$,4,800,],[$Accounts Receivable,$3,700,],[$Supplies$,1,810,],[$Equipment$,11,000,],[$Accumulated Depreciation$-$Equipment,,$1,250\mathrm{.}0],[$Accounts Payable,,$2,140],[$Unearned Service Revenue,,$430],[$Common Stock,,$10,140],[$Retained Earnings,,$3,680],[$Dividends$,1,170,],[$Service Revenue,,$6,800],[$Salaries and Wages Expense,$1,500,],[$Miscellaneous Expense,$460,],[,24,440,24,440]]$

Other data:

A physical count reveals only $$500$ of roofing supplies on hand.

Depreciation for March is $$250.$

Unearned service revenue amounted to $$230$ at March $31.$

Accrued salaries are $$700.$

Requirements:

Journalize the adjusting entries from the adjustments columns of the worksheet

Enter the trial balance on a worksheet and complete the worksheet.

Journalize the closing entries from the financial statement columns of the worksheet.

Prepare an income statement for the month of March

Prepare a retained earnings statement for the month of March

Prepare a classified balance sheet on March $31.$