ACCT 201 Upper Iowa University Microsoft Corporation Balance Sheets Worksheet Chapter 4: Ex 4-24, Ex 4-25 , EX 4-26 , PR 4-1A , PR 4-3AChapter 4: Ex 4-24, Ex 4-25 , EX 4-26 , PR 4-1A , PR 4-3A Exercise 4-25
Name:
Student
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank.
ALERT SECURITY SERVICES CO.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2019
Account Title
Cash
Accounts Receivable
Supplies
Prepaid Insurance
Land
Equipment
Accum. Depreciation
Accounts Payable
Wages Payable
Brenda Schultz, Capital
Brenda Schultz, Drawing
Fees Earned
Wages Expense
Rent Expense
Insurance Expense
Utilities Expense
Supplies Expense
Depreciation Expense
Miscellaneous Expense
Adjusted Trial Balance
Dr.
Cr.
12
103
4
2
190
50
8
111
12
10
6
4
3
2
517
7
36
1
260
213
517
Income Statement
Dr.
Cr.
Balance Sheet
Dr.
Cr.
Exercise 4-24
Name:
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank.
ALERT SECURITY SERVICES CO.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2019
Account Title
Cash
Accounts Receivable
Supplies
Prepaid Insurance
Land
Equipment
Accum. Depreciation
Accounts Payable
Wages Payable
Brenda Schultz, Capital
Brenda Schultz, Drawing
Fees Earned
Wages Expense
Rent Expense
Insurance Expense
Utilities Expense
Supplies Expense
Depreciation Expense
Miscellaneous Expense
Unadjusted Trial Balance
Dr.
Cr.
12
90
8
12
190
50
8
110
12
6
2
500
4
36
260
200
500
Adjustments
Dr.
Cr.
Adjusted
Trial Balance
Dr.
Cr.
Problem 4-1A
Name:
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
For correct grading in the trial balance, enter a zero in cells you would otherwise leave blank.
1.
BEACON SIGNALS COMPANY
Income Statement
For the Year Ended December 31, 2019
Revenues:
Total revenues
Expenses:
Total expenses
Net income
2.
BEACON SIGNALS COMPANY
Statement of Owner’s Equity
For the Year Ended December 31, 2019
Sarah Colin, capital, January 1, 2019
Sarah Colin, capital, December 31, 2019
3.
BEACON SIGNALS COMPANY
Balance Sheet
December 31, 2019
Assets
Current assets:
Total current assets
Property, plant, and equipment:
Total property, plant, and equipment
Total assets
Liabilities
Current liabilities:
Total liabilities
Owner’s Equity
Total liabilities and owner’s equity
4.
JOURNAL
Date
Description
2019
Dec. 31
Closing Entries
Debit
Credit
Miscellaneous Expense
Sarah Colin, Capital
31
5.
BEACON SIGNALS COMPANY
Post-Closing Trial Balance
December 31, 2019
Debit
Cash
Accounts Receivable
Prepaid Insurance
Supplies
Land
Building
Accumulated Depreciation – Building
Equipment
Accumulated Depreciation – Equipment
Accounts Payable
Salaries & Wages Payable
Unearned Rent
Sarah Colin, Capital
Credit
Exercise 4-25
Name:
Student
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank.
ALERT SECURITY SERVICES CO.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2019
Account Title
Cash
Accounts Receivable
Supplies
Prepaid Insurance
Land
Equipment
Accum. Depreciation
Accounts Payable
Wages Payable
Brenda Schultz, Capital
Brenda Schultz, Drawing
Fees Earned
Wages Expense
Rent Expense
Insurance Expense
Utilities Expense
Supplies Expense
Depreciation Expense
Miscellaneous Expense
Adjusted Trial Balance
Dr.
Cr.
12
103
4
2
190
50
8
111
12
10
6
4
3
2
517
7
36
1
260
213
517
Income Statement
Dr.
Cr.
Balance Sheet
Dr.
Cr.
Exercise 4-24
Name:
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank.
ALERT SECURITY SERVICES CO.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2019
Account Title
Cash
Accounts Receivable
Supplies
Prepaid Insurance
Land
Equipment
Accum. Depreciation
Accounts Payable
Wages Payable
Brenda Schultz, Capital
Brenda Schultz, Drawing
Fees Earned
Wages Expense
Rent Expense
Insurance Expense
Utilities Expense
Supplies Expense
Depreciation Expense
Miscellaneous Expense
Unadjusted Trial Balance
Dr.
Cr.
12
90
8
12
190
50
8
110
12
6
2
500
4
36
260
200
500
Adjustments
Dr.
Cr.
Adjusted
Trial Balance
Dr.
Cr.
Exercise 4-25
Name:
Student
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank.
ALERT SECURITY SERVICES CO.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2019
Account Title
Cash
Accounts Receivable
Supplies
Prepaid Insurance
Land
Equipment
Accum. Depreciation
Accounts Payable
Wages Payable
Brenda Schultz, Capital
Brenda Schultz, Drawing
Fees Earned
Wages Expense
Rent Expense
Insurance Expense
Utilities Expense
Supplies Expense
Depreciation Expense
Miscellaneous Expense
Adjusted Trial Balance
Dr.
Cr.
12
103
4
2
190
50
8
111
12
10
6
4
3
2
517
7
36
1
260
213
517
Income Statement
Dr.
Cr.
Balance Sheet
Dr.
Cr.
Problem 4-1A
Name:
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
For correct grading in the trial balance, enter a zero in cells you would otherwise leave blank.
1.
BEACON SIGNALS COMPANY
Income Statement
For the Year Ended December 31, 2019
Revenues:
Total revenues
Expenses:
Total expenses
Net income
2.
BEACON SIGNALS COMPANY
Statement of Owner’s Equity
For the Year Ended December 31, 2019
Sarah Colin, capital, January 1, 2019
Sarah Colin, capital, December 31, 2019
3.
BEACON SIGNALS COMPANY
Balance Sheet
December 31, 2019
Assets
Current assets:
Total current assets
Property, plant, and equipment:
Total property, plant, and equipment
Total assets
Liabilities
Current liabilities:
Total liabilities
Owner’s Equity
Total liabilities and owner’s equity
4.
JOURNAL
Date
Description
2019
Dec. 31
Closing Entries
Debit
Credit
Miscellaneous Expense
Sarah Colin, Capital
31
5.
BEACON SIGNALS COMPANY
Post-Closing Trial Balance
December 31, 2019
Debit
Cash
Accounts Receivable
Prepaid Insurance
Supplies
Land
Building
Accumulated Depreciation – Building
Equipment
Accumulated Depreciation – Equipment
Accounts Payable
Salaries & Wages Payable
Unearned Rent
Sarah Colin, Capital
Credit
Problem 4-3A
Name:
Section:
Score:
0%
Key Code:
(Enter key code here)
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
In the general ledger accounts, only normal balance columns will be graded.
For correct grading in the trial balances and work sheet, enter a zero in cells you would otherwise leave blank.
2.
EPICENTER LAUNDRY
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended June 30, 2019
Unadjusted Trial Balance
Account Title
Cash
Laundry Supplies
Prepaid Insurance
Laundry Equipment
Accum. Depreciation
Accounts Payable
Wages Payable
Sophie Perez, Capital
Sophie Perez, Drawing
Laundry Revenue
Wages Expense
Rent Expense
Utilities Expense
Laundry Supplies Exp.
Depreciation Expense
Insurance Expense
Miscellaneous Expense
Dr.
Cr.
11,000
21,500
9,600
232,600
125,400
11,800
105,600
10,000
232,200
125,200
40,000
19,700
5,400
475,000
475,000
Adjusted
Trial Balance
Adjustments
Dr.
Cr.
Dr.
Income
Statement
Cr.
Dr.
Balance
Sheet
Cr.
Dr.
Cr.
JOURNAL
3.
Date
Description
2019
June 30
Adjusting Entries
Debit
30
30
30
1., 3., and 6.
June 30
Balance
June 30
30
Balance
Adjusted Bal.
June 30
30
Balance
Adjusted Bal.
June 30
Balance
GENERAL LEDGER
Cash
11,000
Laundry Supplies
21,500
June 30
Adjusting
Prepaid Insurance
9,600
June 30
Adjusting
Laundry Equipment
232,600
Accumulated Depreciation
June 30
Balance
30
Adjusting
125,400
Credit
30
Accounts Payable
June 30
Wages Payable
June 30
Sophie Perez, Capital
June 30
30
30
Adjusted Bal.
Balance
11,800
Adjusting
June 30
Closing
Balance
Closing
Closing Bal.
June 30
Balance
Sophie Perez, Drawing
10,000
June 30
Closing
June 30
Closing
Laundry Revenue
June 30
Balance
June 30
30
30
Balance
Adjusting
Adjusted Bal.
Wages Expense
125,200
June 30
Closing
June 30
Balance
Rent Expense
40,000
June 30
Closing
June 30
Balance
Utilities Expense
19,700
June 30
Closing
105,600
232,200
Laundry Supplies Expense
June 30
Closing
June 30
Adjusting
June 30
Adjusting
Depreciation Expense
June 30
Closing
June 30
Adjusting
Insurance Expense
June 30
Closing
June 30
Balance
Miscellaneous Expense
5,400
June 30
Closing
4.
EPICENTER LAUNDRY
Adjusted Trial Balance
June 30, 2019
Debit
Balances
Cash
Laundry Supplies
Prepaid Insurance
Laundry Equipment
Accumulated Depreciation
Accounts Payable
Wages Payable
Sophie Perez, Capital
Sophie Perez, Drawing
Laundry Revenue
Wages Expense
Rent Expense
Utilities Expense
Laundry Supplies Expense
Depreciation Expense
Insurance Expense
Miscellaneous Expense
Credit
Balances
5.
EPICENTER LAUNDRY
Income Statement
For the Year Ended June 30, 2019
Revenues:
Expenses:
Total expenses
Net income
EPICENTER LAUNDRY
Statement of Owner’s Equity
For the Year Ended June 30, 2019
Sophie Perez, capital, July 1, 2018
Sophie Perez, capital, June 30, 2019
EPICENTER LAUNDRY
Balance Sheet
June 30, 2019
Assets
Current assets:
Total current assets
Property, plant, and equipment:
Total property, plant, and equipment
Total assets
Liabilities
Current liabilities:
Total liabilities
Owner’s Equity
Total liabilities and owner’s equity
6.
JOURNAL
Date
Description
2019
June 30
Closing Entries
Post.
Ref.
Debit
Miscellaneous Expense
Sophie Perez, Capital
30
7.
EPICENTER LAUNDRY
Post-Closing Trial Balance
June 30, 2019
Debit
Balances
Cash
Laundry Supplies
Prepaid Insurance
Laundry Equipment
Accumulated Depreciation
Accounts Payable
Wages Payable
Sophie Perez, Capital
Credit
Balances
Credit
Exercise 4-24
Name:
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank.
ALERT SECURITY SERVICES CO.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2019
Account Title
Cash
Accounts Receivable
Supplies
Prepaid Insurance
Land
Equipment
Accum. Depreciation
Accounts Payable
Wages Payable
Brenda Schultz, Capital
Brenda Schultz, Drawing
Fees Earned
Wages Expense
Rent Expense
Insurance Expense
Utilities Expense
Supplies Expense
Depreciation Expense
Miscellaneous Expense
Unadjusted Trial Balance
Dr.
Cr.
12
90
8
12
190
50
8
110
12
6
2
500
4
36
260
200
500
Adjustments
Dr.
Cr.
Adjusted
Trial Balance
Dr.
Cr.
Exercise 4-25
Name:
Student
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank.
ALERT SECURITY SERVICES CO.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2019
Account Title
Cash
Accounts Receivable
Supplies
Prepaid Insurance
Land
Equipment
Accum. Depreciation
Accounts Payable
Wages Payable
Brenda Schultz, Capital
Brenda Schultz, Drawing
Fees Earned
Wages Expense
Rent Expense
Insurance Expense
Utilities Expense
Supplies Expense
Depreciation Expense
Miscellaneous Expense
Adjusted Trial Balance
Dr.
Cr.
12
103
4
2
190
50
8
111
12
10
6
4
3
2
517
7
36
1
260
213
517
Income Statement
Dr.
Cr.
Balance Sheet
Dr.
Cr.
Exercise 4-26
Name:
Section:
Score:
0%
Key Code:
2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
ALERT SECURITY SERVICES CO.
Income Statement
For the Year Ended October 31, 2019
Revenues:
Expenses:
Total expenses
Net income
ALERT SECURITY SERVICES CO.
Statement of Owner’s Equity
For the Year Ended October 31, 2019
Brenda Schultz, capital, November 1, 2018
Brenda Schultz, capital, October 31, 2019
ALERT SECURITY SERVICES CO.
Balance Sheet
October 31, 2019
Assets
Current assets:
Total current assets
Property, plant, and equipment:
Total property, plant, and equipment
Total assets
Liabilities
Current liabilities:
Total liabilities
Owner’s Equity
Total liabilities and owner’s equity
Purchase answer to see full
attachment