Below you will see an unadjusted trial balance run at month end followed by information needed to make adjusting entries. Baltimore Glass Company Unadjusted Trial Balance January 31, 2017
| Below you will see an unadjusted trial balance run at month end followed by information needed to make adjusting entries. | |||||
| Baltimore Glass Company | |||||
| Unadjusted Trial Balance | |||||
| January 31, 2017 | |||||
| Acct. | |||||
| No. | Account Title | Debit | Credit | ||
| 101 | Cash | 34,512 | |||
| 110 | Accounts Receivable | 182,610 | |||
| 120 | Merchandise Inventory | 573,987 | |||
| 125 | Supplies on Hand | 3,252 | |||
| 130 | Prepaid Insurance | 6,000 | |||
| 131 | Prepaid Rent | 7,500 | |||
| 150 | Equipment | 270,000 | |||
| 160 | Accumulated Depreciation | 90,000 | |||
| 202 | Accounts Payable | 110,587 | |||
| 210 | Salaries Payable | – | |||
| 215 | Interest Payable | – | |||
| 220 | Current Portion of Long Term Debt | 12,000 | |||
| 240 | Long Term Debt | 120,000 | |||
| 301 | Capital Stock | 220,000 | |||
| 302 | Retained Earnings, 12/31/16 | 211,144 | |||
| 401 | Sales | 348,080 | |||
| 510 | Cost of Goods Sold | – | |||
| 520 | Advertising Expense | 1,000 | |||
| 530 | Sales Salaries Expense | 18,600 | |||
| 531 | Sales Commission Expense | – | |||
| 532 | Supplies Expense | – | |||
| 540 | Office Salaries Expense | 12,950 | |||
| 550 | Utilities Expense | – | |||
| 555 | Insurance Expense | – | |||
| 558 | Rent Expense | – | |||
| 560 | Professional Fees Expense | 1,400 | |||
| 570 | Depreciation Expense | – | |||
| 580 | Interest Expense | – | |||
| 1,111,811 | 1,111,811 | ||||
| Adjusting items and notes: | ||||||||
| 1. The company uses a calendar year. | ||||||||
| 2. Insurance was prepaid at the beginning of the year by paying $6,000 for a 12 month policy. | ||||||||
| 3. It is estimated that supplies on hand equal $2,000 at month end. | ||||||||
| 4. The rent is prepaid quarterly and $7,500 covered the first quarter of 2017. | ||||||||
| 5. Equipment was all purchased at one time and has a life of 10 years with no salvage value. The equipment was 40 months old at the end of October. | ||||||||
| 6. At month end sales commissions of $3,000 were earned but unpaid. The company records sales commission liability as a salary liability. | ||||||||
| 7. The interest rate on long term debt is 6% per year. Interest will actually be paid at the end of each calendar quarter. (don’t forget the current portion of debt) | ||||||||
| 8. It is estimated that electricity usage equaled $800 during January and the company expects to be billed in early February. Bills for utilities are entered into accounts payable. | ||||||||
| 9. The inventory balance includes purchases made during January of $215,000. | ||||||||
| 10. The company has a long history of cost of goods sold and 70% is a reasonable estimate to use for monthly financial statements. | ||||||||
| 11. The company considers sales salaries, commissions, supplies, and advertising to be selling expense and all other expenses to be administrative. | ||||||||
| Do the following requirements below. Create proper headings for each statement. | ||||||||
| 1. Record adjusting journal entries from information above. You will need to calculate cost of goods sold to adjust inventory. Draw T-accounts on your draft to help figure this out. | ||||||||
| 2. Prepare an adjusted trial balance including the adjusting entries made | ||||||||
| 3. Prepare a multi-step income statement. Consider depreciation to be a selling and administrative expense. Include a detailed cost of goods sold section including purchases and goods available for sale. | ||||||||
| 4. Prepare a statement of retained earnings | ||||||||
| 5. Prepare a classified balance sheet | ||||||||
| 6. Prepare closing journal entries including an entry to adjust the inventory balance. Prepare entries to income summary and retained earnings even though this is a month end only. | ||||||||
| Account # | Account Title | debit | credit | |||||
| 555 | Insurance expense | 6,000 | ||||||
| 130 | Prepaid insurance | 6,000 | ||||||
| 532 | Supplies expense | 1,252 | ||||||
| 125 | Supplies on hand | 1,252 | ||||||
| No Entry | ||||||||
| 570 | Depreciation Expense | 180,000 | ||||||
| 160 | Accumulated Depreciation | 180,000 | ||||||
| 530 | Sales Salaries Expense | 15,600 | ||||||
| 210 | Salaries payable | 15,600 | ||||||
| 240 | Long Term Debt | 127,200 | ||||||
| 580 | Interest Expense | 127,200 | ||||||
| Baltimore Glass Company | ||||||||
| Adjusted Trial Balance | ||||||||
| January 31, 2017 | ||||||||
| Acct. | ||||||||
| No. | Account Title | Debit | Credit | |||||
| 101 | Cash | |||||||
| 110 | Accounts Receivable | |||||||
| 120 | Merchandise Inventory | |||||||
| 125 | Supplies on Hand | |||||||
| 130 | Prepaid Insurance | |||||||
| 131 | Prepaid Rent | |||||||
| 150 | Equipment | |||||||
| 160 | Accumulated Depreciation | |||||||
| 202 | Accounts Payable | |||||||
| 210 | Salaries Payable | |||||||
| 215 | Interest Payable | |||||||
| 220 | Current Portion of Long Term Debt | |||||||
| 240 | Long Term Debt | |||||||
| 301 | Capital Stock | |||||||
| 302 | Retained Earnings, 12/31/16 | |||||||
| 401 | Sales | |||||||
| 510 | Cost of Goods Sold | |||||||
| 520 | Advertising Expense | |||||||
| 530 | Sales Salaries Expense | |||||||
| 531 | Sales Commission Expense | |||||||
| 532 | Supplies Expense | |||||||
| 540 | Office Salaries Expense | |||||||
| 550 | Utilities Expense | |||||||
| 555 | Insurance Expense | |||||||
| 558 | Rent Expense | |||||||
| 560 | Professional Fees Expense | |||||||
| 570 | Depreciation Expense | |||||||
| 580 | Interest Expense |