Question

In: Accounting

Requirements: a.   Copy the trial balance above in the first two columns of a 10-column work...

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

Solutions

Expert Solution

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.

Related Solutions

A six-column table for JKL Company follows. The first two columns contain the unadjusted trial balance...
A six-column table for JKL Company follows. The first two columns contain the unadjusted trial balance for the company as of July 31, 2017. The last two columns contain the adjusted trial balance as of the same date. Unadjusted Trial Balance Adjusted Trial Balance Cash $ 108,120 $ 108,120 Accounts receivable 10,000 20,000 Office supplies 17,200 6,500 Prepaid insurance 7,540 3,160 Office equipment 90,000 90,000 Accum. Depreciation—Office equip. $ 25,000 $ 32,000 Accounts payable 10,100 24,000 Interest payable 0 3,000...
A six-column table for JKL Company follows. The first two columns contain the unadjusted trial balance...
A six-column table for JKL Company follows. The first two columns contain the unadjusted trial balance for the company as of July 31, 2017. The last two columns contain the adjusted trial balance as of the same date. Unadjusted Trial Balance Adjusted Trial Balance Cash $ 34,000 $ 34,000 Accounts receivable 14,000 22,000 Office supplies 16,000 2,000 Prepaid insurance 8,540 2,960 Office equipment 84,000 84,000 Accum. Depreciation—Office equip. $ 14,000 $ 20,000 Accounts payable 9,100 10,000 Interest payable 0 1,000...
A six-column table for JKL Company follows. The first two columns contain the unadjusted trial balance...
A six-column table for JKL Company follows. The first two columns contain the unadjusted trial balance for the company as of July 31, 2017. The last two columns contain the adjusted trial balance as of the same date. Unadjusted Trial Balance Adjusted Trial Balance Cash $ 34,000 $ 34,000 Accounts receivable 14,000 22,000 Office supplies 16,000 2,000 Prepaid insurance 8,540 2,960 Office equipment 84,000 84,000 Accum. Depreciation—Office equip. $ 14,000 $ 20,000 Accounts payable 9,100 10,000 Interest payable 0 1,000...
Use the following information from the Adjustments columns of a 10-column work sheet.    Adjustments No....
Use the following information from the Adjustments columns of a 10-column work sheet.    Adjustments No. Account Title Dr. Cr. 109 Interest receivable (d) $ 571 124 Office supplies (b) $ 1,628 128 Prepaid insurance (a) 878 164 Accumulated depreciation—Office equipment (c) 3,300 209 Salaries payable (e) 651 409 Interest revenue (d) 571 612 Depreciation expense—Office equipment (c) 3,300 620 Office salaries expense (e) 651 636 Insurance expense—Office equipment (a) 421 637 Insurance expense—Store equipment (a) 457 650 Office supplies...
1. The fourth pair of columns on a 10-column work sheet prepared at the end of the period would be the
1. The fourth pair of columns on a 10-column work sheet prepared at the end of the period would be theIncome Statement columns.Adjusted Trial Balance columns.Balance Sheet columns.Adjustments columns.2. The third pair of columns on a 10-column work sheet prepared at the end of the period would be theAdjustments columns.Adjusted Trial Balance columns.Income Statement columns.Balance Sheet columns.3. The owner's equity in a business amounted to $52,000 at the beginning of the year and $100,000 at the end of the year....
The columns of the input file correspond to the point coordinates, for example, the first column...
The columns of the input file correspond to the point coordinates, for example, the first column provides the coordinates of the first point and the column length indicates whether it is 2D vs. 3D. First, compute the area of the triangle (the first line of your output file). Second, using the first two points, construct a line if 2D or a plane if 3D (the bisector of the two points) and find the distance of the third point to that...
Prepare a worksheet that contains the following columns: Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement...
Prepare a worksheet that contains the following columns: Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement and Balance Sheet. From the following transactions as well as add't data, please complete the entire accounting cycle for Parker's Plowing (using the chart of accounts below) for 2018. Jan. 1 Parker invested $10,000 cash and $12,000 worth of snow equipment into the plowing company. Jan. 1 Paid rent for six months in advance for garage space, $6000 Jan. 6 Purchased snow supplies for...
Create a balance sheet The adjusted trial balance columns of the worksheet for Ayayai Company are...
Create a balance sheet The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. Ayayai Company Worksheet (Partial) For the Month Ended April 30, 2019 Adjusted Trial Balance Account Titles Dr. Cr. Cash 11,500 Accounts Receivable 7,620 Prepaid Rent 2,180 Equipment 22,950 Accumulated Depreciation—Equip. 5,000 Notes Payable 5,800 Accounts Payable 4,500 Common Stock 20,500 Retained Earnings 8,550 Dividends 3,500 Service Revenue 15,500 Salaries and Wages Expense 10,800 Rent Expense 700 Depreciation Expense 600 Interest Expense 60...
If the totals of the adjusted trial balance Debit and Credit columns are equal, but the...
If the totals of the adjusted trial balance Debit and Credit columns are equal, but the post closing trial balance does not balance, what is the likely cause of the problem? Answer in a 100 word or more.
The trial balance columns of the worksheet for Crane Company at June 30, 2020, are as...
The trial balance columns of the worksheet for Crane Company at June 30, 2020, are as follows Crane Company Worksheet For the Month Ended June 30, 2020 Trial Balance Account Titles Dr. Cr. Cash 2,500 Accounts Receivable 2,200 Supplies 1,900 Accounts Payable 1,000 Unearned Service Revenue 380 Owner’s Capital 2,710 Service Revenue 3,100 Salaries and Wages Expense 490 Miscellaneous Expense 100        Total 7,190 7,190 Other data: 1. A physical count reveals $600 of supplies on hand. 2. $170 of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT