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 Titles | Dr. | Cr. | ||
| Cash | 5,000 | |||
| Accounts Receivable | 2,800 | |||
| Supplies | 1,740 | |||
| Equipment | 11,088 | |||
| Accumulated DepreciationEquipment | 1,260.0 | |||
| Accounts Payable | 2,000 | |||
| Unearned Service Revenue | 440 | |||
| Common Stock | 10,295 | |||
| Retained Earnings | 2,873 | |||
| Dividends | 1,170 | |||
| Service Revenue | 6,500 | |||
| Salaries and Wages Expense | 1,100 | |||
| Miscellaneous Expense | 470 | |||
| 23,368 | 23,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:
- 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.
- An income statement for the month of March
- A retained earnings statement for the month of March
- A classified balance sheet at March 31.








Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
