| Colton's Western Wear |
| Unadjusted Trial Balance |
| As at December 31, 20X4 |
| Account | DR | CR |
| Cash | 146,358.00 | - 0 |
| Accounts receivable — trade | 42,500.00 | - 0 |
| Allowance for doubtful accounts | - 0 | 1,468.00 |
| Prepaid insurance | 11,500.00 | - 0 |
| Inventory — clothing | 30,780.00 | - 0 |
| Inventory — boots | 113,930.00 | - 0 |
| Inventory — related products | 35,550.00 | - 0 |
| Investment in PLZ shares (at FVPL) | 84,240.00 | - 0 |
| Investment in General Company bonds (at amortized cost) | 250,000.00 | - 0 |
| Investment in mortgage option (at FVOCI) | 5,000.00 | - 0 |
| Investment in mortgages (at FVOCI) | 512,000.00 | - 0 |
| Land | 279,400.00 | - 0 |
| Warehouse | 126,000.00 | - 0 |
| Accumulated depreciation — warehouse | - 0 | 27,550.00 |
| Store | 368,400.00 | - 0 |
| Accumulated depreciation — store | - 0 | 78,285.00 |
| Tools and other equipment | 38,850.00 | - 0 |
| Accumulated depreciation — tools and other equipment | - 0 | 24,605.00 |
| Vehicles — delivery, service, sales | 35,000.00 | - 0 |
| Accumulated depreciation — vehicles | - 0 | 14,400.00 |
| Office equipment | 8,500.00 | - 0 |
| Accumulated depreciation — office equipment | - 0 | 3,400.00 |
| Computer equipment | 12,300.00 | - 0 |
| Accumulated depreciation — computer equipment | - 0 | 4,950.00 |
| Customer list | 10,000.00 | - 0 |
| Accumulated amortization — customer list | - 0 | 5,000.00 |
| Accounts payable | - 0 | 109,590.00 |
| Payroll taxes payable | - 0 | 4,240.00 |
| Short-term note payable | - 0 | 3,500.00 |
| Current portion of long-term debt | - 0 | 7,200.00 |
| Long-term debt | - 0 | 36,000.00 |
| Preferred shares (2,000 shares outstanding) | - 0 | 50,000.00 |
| Common shares (750 shares @ $400 / share) | - 0 | 300,000.00 |
| Retained earnings | - 0 | 237,957.00 |
| Revenue — merchandise | - 0 | 2,637,508.00 |
| Revenue — related products | - 0 | 571,577.00 |
| Revenue — clothing | - 0 | 526,225.00 |
| Revenue — other | - 0 | 198,600.00 |
| Cost of goods sold — boots | 1,424,192.00 | - 0 |
| Cost of goods sold — related products | 355,944.00 | - 0 |
| Cost of goods sold — clothing | 310,500.00 | - 0 |
| Advertising | 4,500.00 | - 0 |
| Audit and legal fees | 13,907.00 | - 0 |
| Bad debts | 1,275.00 | - 0 |
| Interest expense — long-term debt | 3,225.00 | - 0 |
| Insurance expense — property, building and casualty | 23,700.00 | - 0 |
| Insurance — automobile | 2,500.00 | - 0 |
| Investment transaction costs | 309.00 | - 0 |
| Janitorial services | 7,800.00 | - 0 |
| Office expenses | 4,800.00 | - 0 |
| Property taxes | 18,600.00 | - 0 |
| Training and development | 3,200.00 | - 0 |
| Telephone | 6,685.00 | - 0 |
| Utilities | 7,200.00 | - 0 |
| Wages, salaries and benefits | 432,000.00 | - 0 |
| Dividend income | - 0 | 2,025.00 |
| Gain (loss) through P&L on Investment in PLZ shares | - 0 | 52,785.00 |
| Mortgage interest income | - 0 | 57,980.00 |
| Gain / loss on sale of property, plant and equipment | - 0 | 800.00 |
| Income tax expense | 225,000.00 | - 0 |
| Total | 4,955,645 | 4,955,645 |
Arun1990
DATA-FILE.xlsx
