In: Accounting
Given the following trail Balance and adjustment data for the A Ltd , Your task is prepare a work-sheet for the month of November, the first month of operations in a new fiscal year.
The A Ltd Trial Balance November 30, 2021 | ||
Dr | Cr | |
Cash | 381300 | |
Accounts Receivable | 282000 | |
Prepaid Rent | 85000 | |
Painting Supplies | 92100 | |
Studio Equipment | 598500 | |
Accumulated Depreciation , Studio Equipment | 199500 | |
Accounts payable | 178800 | |
A Ltd , Capital | 582800 | |
Painting Revenue | 781600 | |
Advertising Expense | 51000 | |
Utilities Expense | 27800 | |
Wages Expense | 225000 | |
Totals | 1742700 | 1742700 |
Completing a worksheet
Net income $3690.25
Adjustment data :
1)Painting supplies on hand, $595
2)Prepaid rent represents the first and last months rent on a new office lease singed November 1, 2018.
3)Depreciation on studio equipment is based on straight-line, five year life and a residual value of $480
4)Wages earned but un-paid amounted to 24.5 hours at $10 per hour