excel assignment
Sam1409
SarahO3.xlsxSheet2
| Particulars | Unadjusted | Adjustments | Adjusted | Income Statement | Balance Sheet | |||||||
| Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | |||
| Cash | 2,400 | 2,400 | 2,400 | |||||||||
| Commissions receivable | 8,000 | 8,000 | 8,000 | |||||||||
| Supplies | 1,750 | 930 | 820 | 820 | ||||||||
| Prepaid insurance | 1,800 | 1,200 | 600 | 600 | ||||||||
| Equipment | 16,000 | 16,000 | 16,000 | |||||||||
| Accumulated depreciation | 7,600 | 1,500 | 9,100 | 9,100 | This is a credit account | |||||||
| Accounts payable | 550 | 550 | 550 | |||||||||
| Salaries payable | 800 | 800 | 800 | |||||||||
| Unearned commissions | 700 | 600 | 100 | 100 | ||||||||
| Common stock | 4,000 | 4,000 | 4,000 | |||||||||
| Retained earnings | 9,000 | 9,000 | 14,170 | Use the 9000 and it is a credit | ||||||||
| Dividends | 900 | 900 | ||||||||||
| Commissions earned | 18,990 | 600 | 19,590 | 19,590 | ||||||||
| Salaries expense | 6,500 | 800 | 7,300 | 7,300 | ||||||||
| Rent expense | 1,870 | 1,870 | 1,870 | |||||||||
| Advertising expense | 1,000 | 1,000 | 1,000 | |||||||||
| Utilities expense | 620 | 620 | 620 | |||||||||
| Depreciation expense | 1,500 | 1,500 | 1,500 | |||||||||
| Supplies expense | 930 | 930 | 930 | |||||||||
| Insurance expense | 1,200 | 1,200 | 1,200 | |||||||||
| Total | 40,840 | 40,840 | 5,030 | 5,030 | 43,140 | 43,140 | 14,420 | 19,590 | 36,920 | 19,620 | ||
| Net Profit / (Loss) | 5,170 | |||||||||||
| 19,590 | 19,590 | |||||||||||
| you are missing your formal financial statements |
