Accounting excel sheet due in 24 hours

profilecombs
WRD27e_PR03-5A-1.xlsx
Home>Business & Finance homework help>Accounting homework help>Accounting excel sheet due in 24 hours

Pr. 3-5A

Problem 3-5A # Incorrect N-box and B-box entries COUNTIF(B15:G24,"~*")
Name: 0
Section: # N-box Incorrects due to blanks COUNTIF(B15:AT24," ")
80
Score: 0% # N-box +B-box corrects COUNTIF(B15:AT24," ")
0
Key Code: 2 Total SUM(AD13:AD15)
Instructions 80
Answers are entered in the cells with gray backgrounds. Percentage =(AD16-AD13-AD14)/AD16
Cells with non-gray backgrounds are protected and cannot be edited. 0%
An asterisk (*) will appear to the right of an incorrect entry. Notes:
For correct grading in the trial balance, enter a zero in cells you would otherwise leave blank. If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or blank-entry box is incorrect, returns "*"
1. Account Debit Credit If number-entry or blank-entry box is correct, returns single space, " "
a. Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct.
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Accounts Receivable
b. Accumulated Depreciation - Building
Accumulated Depreciation - Equipment
Cash
c. Depreciation Expense - Building
Depreciation Expense - Equipment
Fees Earned
d. Insurance Expense
Prepaid Insurance
Rent Revenue
e. Salaries and Wages Expense
Salaries and Wages Payable
Supplies
f. Supplies Expense
Unearned Rent
g.
2. PITMAN COMPANY
Adjusted Trial Balance
October 31, 2019
Debit Balances Credit Balances
Cash
Accounts Receivable
Prepaid Insurance
Supplies
Land
Building
Accumulated Depreciation - Building
Equipment
Accumulated Depreciation - Equipment
Accounts Payable
Unearned Rent
Salaries and Wages Payable
Jan Pitman, Capital
Jan Pitman, Drawing
Fees Earned
Rent Revenue
Salaries and Wages Expense
Utilities Expense
Advertising Expense
Repairs Expense
Depreciation Expense - Building
Depreciation Expense - Equipment
Insurance Expense
Supplies Expense
Miscellaneous Expense

Sol

Problem 3-5A
Name: Solution
Section:
Scoring: ON
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. Account Debit Credit
a. Insurance Expense 6,600
Prepaid Insurance 6,600
Accounts Receivable
b. Supplies Expense 1,305 Accumulated Depreciation - Building
Supplies 1,305 Accumulated Depreciation - Equipment
Depreciation Expense - Building
c. Depreciation Expense - Building 12,000 Depreciation Expense - Equipment
Accumulated Depreciation - Building 12,000 Fees Earned
Insurance Expense
d. Depreciation Expense - Equipment 8,600 Prepaid Insurance
Accumulated Depreciation - Equipment 8,600 Rent Revenue
Salaries and Wages Expense
e. Unearned Rent 4,500 Salaries and Wages Payable
Rent Revenue 4,500 Supplies
Supplies Expense
f. Salaries and Wages Expense 2,800 Unearned Rent
Salaries and Wages Payable 2,800
g. Accounts Receivable 10,050
Fees Earned 10,050
2. PITMAN COMPANY
Adjusted Trial Balance
October 31, 2019
Debit Balances Credit Balances
Cash 7,500 -
Accounts Receivable 48,450 -
Prepaid Insurance 600 -
Supplies 675 -
Land 112,500 -
Building 300,250 -
Accumulated Depreciation - Building - 99,550
Equipment 135,300 -
Accumulated Depreciation - Equipment - 106,550
Accounts Payable - 12,150
Unearned Rent - 2,250
Salaries and Wages Payable - 2,800
Jan Pitman, Capital - 371,000
Jan Pitman, Drawing 15,000 -
Fees Earned - 334,650
Rent Revenue - 4,500
Salaries and Wages Expense 196,170 -
Utilities Expense 42,375 -
Advertising Expense 22,800 -
Repairs Expense 17,250 -
Depreciation Expense - Building 12,000 -
Depreciation Expense - Equipment 8,600 -
Insurance Expense 6,600 -
Supplies Expense 1,305 -
Miscellaneous Expense 6,075 -
933,450 933,450