In: Accounting
Requirements:
a. Copy the trial balance above in the first two columns of a 10-column work sheet.
b. Prepare adjusting journal entries in journal form from the following information (the fiscal year ends December 31).
1. Estimated bad debts, .5% of sales less returns and allowances.
2. Depreciation on building 4% per year; on furniture and fixtures, 10% per year.
3. Insurance expired during the year, $3,900.
4. Interest at 12% is payable on the mortgage on January 1 of each year
5. Sales salaries accrued, December 31, $4,000.
6. Advertising expense paid in advance, $740.
7. Office supplies on hand December 31, $1,600 (charged to Miscellaneous Office Expenses when purchased).
8. Interest accrued on notes payable, December 31, $1,500.
c. Transfer the adjusting entries to the work sheet and complete it.
d. Prepare an income statement, a balance sheet, and a statement of retained earnings.
e. Prepare closing journal entries.
f. Indicate the adjusting entries that would be reversed.
Debit | Credit | |
Cash | 13,600 | |
Accounts Receivable | 64,800 | |
Allowance for Doubtful Accounts | 2,000 | |
Inventory | 76,000 | |
Office Supplies | ||
Land | 40,000 | |
Building | 90,000 | |
Accumulated Depreciation of Building | 14,400 | |
Furniture and Fixtures | 22,000 | |
Accumulated Depreciation of Furniture and Fixtures | 6,600 | |
Prepaid Insurance | 7,800 | |
Prepaid Advertising | ||
Accounts Payable | 34,200 | |
Salaries Payable | ||
Interest Payable | ||
Notes Payable | 30,000 | |
Mortgage Payable | 40,000 | |
Common Stock | 60,000 | |
Retained Earnings | 64,730 | |
Sales | 720,000 | |
Sales Returns and Allowances | 2,800 | |
Sales Discounts | 5,900 | |
Cost of Goods Sold | 533,700 | |
Sales Salaries Expense | 54,000 | |
Advertising Expense | 9,400 | |
Salaries Expense, Office and General | 31,000 | |
Heat, Light, and Water Expense | 15,100 | |
Telephone Expense | 1,700 | |
Miscellaneous Office Expenses | 2,000 | |
Bad Debt Expense | ||
Depreciation Expense | ||
Insurance Expense | ||
Interest Expense | 2,130 | |
Subtotal | ||
Net Income | ||
Totals | 971,930 | 971,930 |
b. Journalise the adjusting entries on Dec. 31 | ||||||
JOURNAL | ||||||
Date | Account | Debit | Credit | |||
Dec. 31 | ||||||
1. | Bad debt expense | 3586 | ||||
Allowance for Doubtful debts | 3586 | |||||
2. | Depreciation Expense | 5800 | ||||
Accumulated Depreciation of Building | 3600 | |||||
Accumulated Depreciation of Furniture and Fixtures | 2200 | |||||
3. | Insurance Expense | 3900 | ||||
Prepaid Insurance | 3900 | |||||
d. | Interest expense | 4800 | ||||
Interest payable | 4800 | |||||
e. | Salary expense | 4000 | ||||
Salary payable | 4000 | |||||
f. | Prepaid Advertising | 740 | ||||
Advertising expense | 740 | |||||
g. | Office Supplies | 1600 | ||||
Miscellaneous office expense | 1600 | |||||
h. | Interest expense | 1500 | ||||
Interest payable | 1500 | |||||
c. Transfer Journal entries to worksheet. | ||||||
Work Sheet | ||||||
Account | Unadjusted Trial Balance | Adjustments | Adjusted Trial Balance | |||
Debit | Credit | Debit | Credit | Debit | Credit | |
Cash | 13600 | 13600 | ||||
Accounts Receivable | 64800 | 64800 | ||||
Allowance for Doubtful accounts | 2000 | 3586 | 5586 | |||
Inventory | 76000 | 76000 | ||||
Office Supplies | 1600 | 1600 | ||||
Land | 40000 | 40000 | ||||
Building | 90000 | 90000 | ||||
Accumulated Depreciation of Building | 14400 | 3600 | 18000 | |||
Furniture & Fixtures | 22000 | 22000 | ||||
Accumulated Depreciation of Furniture and Fixtures | 6600 | 2200 | 8800 | |||
Prepaid Insurance | 7800 | 3900 | 3900 | |||
Prepaid Advertising | 740 | 740 | ||||
Accounts Payable | 34200 | 34200 | ||||
Salary Payable | 4000 | 4000 | ||||
Interest payable | 6300 | 6300 | ||||
Notes payable | 30000 | 30000 | ||||
Mortgage Payable | 40000 | 40000 | ||||
Common Stock | 60000 | 60000 | ||||
Retained earnings | 64730 | 64730 | ||||
Sales | 720000 | 720000 | ||||
Sales Return and Allowances | 2800 | 2800 | ||||
Sales discount | 5900 | 5900 | ||||
Cost of goods sold | 533700 | 533700 | ||||
Sales salaries expense | 54000 | 4000 | 58000 | |||
Advertising expense | 9400 | 740 | 8660 | |||
Salaries expense, Office and general | 31000 | 31000 | ||||
Heat light and water expense | 15100 | 15100 | ||||
Telephone expense | 1700 | 1700 | ||||
Miscelleneous Office expense | 2000 | 1600 | 400 | |||
Bad debt expense | 3586 | 3586 | ||||
Depreciation expense | 5800 | 5800 | ||||
Insurance expense | 3900 | 3900 | ||||
Interest expense | 2130 | 6300 | 8430 | |||
subtotal | ||||||
net income | ||||||
Totals | 971930 | 971930 | 25926 | 25926 | 991616 | 991616 |
d. Prepare an Income statement, a balance sheet and a statement of retained earnings | ||||||
Income Statement | ||||||
For the year ended December 31 | ||||||
Sales | 720000 | |||||
Sales Return and Allowances | -2800 | |||||
Sales discount | -5900 | |||||
Net Sales | 711300 | |||||
Cost of goods sold | 533700 | |||||
Gross Profit | 177600 | |||||
Less: Expenses | ||||||
Advertising expense | 8660 | |||||
Sales salaries expense | 58000 | |||||
Salaries expense, Office and general | 31000 | |||||
Heat light and water expense | 15100 | |||||
Telephone expense | 1700 | |||||
Miscelleneous Office expense | 400 | |||||
Bad debt expense | 3586 | |||||
Depreciation expense | 5800 | |||||
Insurance expense | 3900 | |||||
Interest expense | 8430 | |||||
Total expenses | 136576 | |||||
Net Income | 41024 | |||||
Statement of retained earnings | ||||||
For the year ended December 31 | ||||||
Balance - Beginning | 64730 | |||||
Add: Net Income for the year | 41024 | |||||
Balance - Ending | 105754 | |||||
Balance Sheet | ||||||
As on December 31 | ||||||
Assets | ||||||
Current Assets | ||||||
Cash | 13600 | |||||
Accounts Receivable | 64800 | |||||
Allowance for Doubtful accounts | -5586 | |||||
Inventory | 76000 | |||||
Office Supplies | 1600 | |||||
Prepaid Insurance | 3900 | |||||
Prepaid Advertising | 740 | |||||
Total Current Assets | 155054 | |||||
Property, Plant & Equipment | ||||||
Land | 40000 | |||||
Building | 90000 | |||||
Accumulated Depreciation of Building | -18000 | |||||
Furniture & Fixtures | 22000 | |||||
Accumulated Depreciation of Furniture and Fixtures | -8800 | |||||
Total Property, Plant & Equipment | 125200 | |||||
Total Assets | 280254 | |||||
Liabilties and Stockholder's Equity | ||||||
Current Liabilties | ||||||
Accounts Payable | 34200 | |||||
Salary Payable | 4000 | |||||
Interest payable | 6300 | |||||
Total Current Liabilties | 44500 | |||||
Long term liabilites | ||||||
Notes payable | 30000 | |||||
Mortgage Payable | 40000 | |||||
Total Long term liabilites | 70000 | |||||
Total Liabilities | 114500 | |||||
Stockholder's equity | ||||||
Common Stock | 60000 | |||||
Retained earnings | 105754 | |||||
Total Stockholder's equity | 165754 | |||||
Total Liabilties and Stockholder's Equity | 280254 | |||||
e. Prepare closing Journal entries | ||||||
JOURNAL | ||||||
Date | Account | Debit | Credit | |||
Dec. 31 | ||||||
1. | Sales | 720000 | ||||
Income summary | 720000 | |||||
2. | Income summary | 678976 | ||||
Sales Return and Allowances | 2800 | |||||
Sales discount | 5900 | |||||
Cost of goods sold | 533700 | |||||
Sales salaries expense | 58000 | |||||
Advertising expense | 8660 | |||||
Salaries expense, Office and general | 31000 | |||||
Heat light and water expense | 15100 | |||||
Telephone expense | 1700 | |||||
Miscelleneous Office expense | 400 | |||||
Bad debt expense | 3586 | |||||
Depreciation expense | 5800 | |||||
Insurance expense | 3900 | |||||
Interest expense | 8430 | |||||
3 | Income summary | 41024 | ||||
Retained earnings | 41024 | |||||
f. Indicate the adjusting entries that would be reversed. | ||||||
Following entries will be reversed: | ||||||
4.
Interest at 12% is payable on the mortgage on January 1 of each
year 5. Sales salaries accrued, December 31, $4,000. 6. Advertising expense paid in advance, $740. 7. Office supplies on hand December 31, $1,600 (charged to Miscellaneous Office Expenses when purchased). 8. Interest accrued on notes payable, December 31, $1,500. |