Question: Using the excel spreadsheet finish the accounting cycle. The trial balance columns of the worksheet for Marigold at March 31, 2019, are as follows. Marigold

Using the excel spreadsheet finish the accounting cycle.

The trial balance columns of the worksheet for Marigold at March 31, 2019, are as follows.

Marigold Worksheet For the Month Ended March 31, 2019
Trial Balance
Account TitlesDr.Cr.
Cash5,000
Accounts Receivable2,800
Supplies1,740
Equipment11,088
Accumulated DepreciationEquipment1,260.0
Accounts Payable2,000
Unearned Service Revenue440
Common Stock10,295
Retained Earnings2,873
Dividends1,170
Service Revenue6,500
Salaries and Wages Expense1,100
Miscellaneous Expense470
23,36823,368

Other data:

1.A physical count reveals only $400 of roofing supplies on hand.
2.Depreciation for March is $252.
3.Unearned service revenue amounted to $220 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. Journalize the closing entries from the financial statement columns of the worksheet.
  4. An income statement for the month of March
  5. A retained earnings statement for the month of March
  6. A classified balance sheet at March 31.
Using the excel spreadsheet finish the accountingUsing the excel spreadsheet finish the accountingUsing the excel spreadsheet finish the accountingUsing the excel spreadsheet finish the accountingUsing the excel spreadsheet finish the accountingUsing the excel spreadsheet finish the accountingUsing the excel spreadsheet finish the accountingUsing the excel spreadsheet finish the accounting
Adjusted Trial Balance Adjustments Trial Balance Income Statement Account Titles Balance Sheet Dr. Cr. Dr. Cr. Dr. Cr Dr. Cr Dr. Cr. K Exercise Adjusting Entries Ledger Closing Entries Financials Financials 2 Sheet1 +General Journal Date Account Titles Debit Credit 16 18 32 Exercise Adjusting Entries Ledger Closing Entries Fin\fIncome Statement For the Month Ended March 31, 2019 4 co - 10 14 15 16 18 Retained Earnings Statement For the Month Ended March 31, 2019 IN > Exercise Adjusting Entries Ledger Closing Entries Financials FinaBalance Sheet March 31, 2019 Assets CO 10 12 13 Liabilities and Stockholders Equity 15 16 19 24 25 > Exercise Adjusting Entries Ledger Closing Entries Financials Financials 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!