Problems (Group A)
P4-28A Preparing financial statements including a classified balance sheet in report form,
preparing and posting closing entries, and preparing a post-closing trial balance
Learning Objectives 1, 3, 4
1. Net Loss $(8,700)
The adjusted trial balance of Elmo Real Estate Appraisal at June 30, 2016, follows:
Requirements
1. Prepare the company’s income statement for the year ended June 30, 2016.
2. Prepare the company’s statement of retained earnings for the year ended June 30,
2016.
3. Prepare the company’s classified balance sheet in report form at June 30, 2016.
4. Journalize the closing entries.
5. Open the T-accounts using the balances from the adjusted trial balance, and post the closing entries
to the T-accounts.
6. Prepare the company’s post-closing trial balance at June 30, 2016.
SOLUTION
Requirement 1
ELMO REAL ESTATE APPRAISAL
Income Statement
Year Ended June 30, 2016
Revenues:
Service Revenue
$ 48,400
Expenses:
Salaries Expense
Interest Expense
Depreciation ExpenseBuilding
Insurance Expense
Utilities Expense
Supplies Expense
Total Expenses
Net Loss
Requirement 2
ELMO REAL ESTATE APPRAISAL
Statement of Retained Earnings
Year Ended June 30, 2016
Retained Earnings, July 1, 2015
Net loss for the year
Dividends
Retained Earnings, June 30, 2016
P4-28A, cont.
Requirement 3
ELMO REAL ESTATE APPRAISAL
Balance Sheet
June 30, 2016
Assets
Current Assets:
Cash
$ 4,900
Accounts Receivable
4,800
Office Supplies
2,700
Prepaid Insurance
1,900
Total Current Assets
Plant Assets:
Building
Less: Accumulated DepreciationBuilding
(26,600)
Land
Total Plant Assets
Total Assets
Liabilities
Current Liabilities:
Accounts Payable
$ 19,300
Interest Payable
8,300
Salaries Payable
1,700
Unearned Revenue
800
Total Current Liabilities
Long-term Liabilities:
Notes Payable
Total Liabilities
Common Stock
Retained Earnings
1,200
Total Stockholders’ Equity
Total Liabilities and Stockholders Equity
P4-28A, cont.
Requirement 4
Date
Accounts and Explanation
Debit
Credit
Jun. 30
Service Revenue
48,400
Income Summary
48,400
To close revenue.
Income Summary
57,100
Insurance Expense
4,000
Salaries Expense
33,900
Supplies Expense
Interest Expense
8,300
Utilities Expense
2,800
Depreciation ExpenseBuilding
7,900
To close expenses.
Retained Earnings
Income Summary
8,700
To close Income Summary.
Retained Earnings
27,100
Dividends
27,100
To close dividends.
P4-28A, cont.
Requirement 5
Cash
Dividends
Bal.
4,900
Bal.
27,100
27,100
Clos.
Bal.
4,900
Bal.
0
Bal.
4,800
Clos.
57,100
48,400
Clos.
Bal.
Clos.
Bal.
4,800
Bal.
2,700
0
Prepaid Insurance
Insurance Expense
Bal.
1,900
Bal.
4,000
4,000
Clos.
Bal.
1,900
Bal.
0
Bal.
Bal.
Clos.
Bal.
Bal.
26,600
Bal.
Bal.
200
Clos.
Land
Interest Expense
Bal.
12,600
Bal.
8,300
8,300
Clos.
Bal.
0
P4-28A, cont.
Requirement 5, cont.
Accounts Payable
Utilities Expense
19,300
Bal.
Bal.
2,800
2,800
Clos.
19,300
Bal.
Bal.
0
Interest Payable
8,300
Bal.
Bal.
0
1,700
Bal.
Unearned Revenue
800
Bal.
800
Bal.
Notes Payable
42,000
Bal.
42,000
Bal.
6,000
Bal.
6,000
Bal.
Clos.
37,000
Bal.
1,200
Bal.
P4-28A, cont.
Requirement 6
ELMO REAL ESTATE APPRAISAL
Post-Closing Trial Balance
June 30, 2016
Account Title
Balance
Debit
Credit
Cash
$ 4,900
Accounts Receivable
4,800
Office Supplies
2,700
Prepaid Insurance
1,900
Building
Accumulated DepreciationBuilding
Land
Accounts Payable
Interest Payable
Salaries Payable
Unearned Revenue
Notes Payable (long-term)
Common Stock
Retained Earnings
Total
$ 105,900
P4-29A Preparing financial statements including a classified balance sheet in report form,
preparing closing entries, and using the current ratio to evaluate a company
Learning Objectives 1, 3, 6
2. Ending Retained Earnings $61,200
The adjusted trial balance of Bertrand Irrigation System at December 31, 2016, follows:
Requirements
1. Prepare the company’s income statement for the year ended December 31, 2016.
2. Prepare the company’s statement of retained earnings for the year ended December 31, 2016.
3. Prepare the company’s classified balance sheet in report form at December 31, 2016.
4. Journalize the closing entries for Bertrand Irrigation System.
5. Compute the company’s current ratio at December 31, 2016. At December 31, 2015, the current
ratio was 2.4. Did the company’s ability to pay current debts improve or deteriorate, or did it remain
the same?
SOLUTION
Requirement 1
BERTRAND IRRIGATION SYSTEM
Income Statement
Year Ended December 31, 2016
Revenues:
Service Revenue
Expenses:
Salaries Expense
Depreciation ExpenseEquipment
Depreciation ExpenseBuilding
Supplies Expense
Insurance Expense
Interest Expense
Total Expenses
Net Income
Requirement 2
BERTRAND IRRIGATION SYSTEM
Statement of Retained Earnings
Year Ended December 31, 2016
P4-29A, cont.
Requirement 3
BERTRAND IRRIGATION SYSTEM
Balance Sheet
December 31, 2016
Assets
Current Assets:
Cash
$ 43,700
Office Supplies
3,400
Prepaid Insurance
6,100
Total Current Assets
Plant Assets:
Equipment
Less: Accumulated DepreciationEquipment
Building
Less: Accumulated DepreciationBuilding
Total Plant Assets
Total Assets
$ 154,400
Liabilities
Current Liabilities:
Accounts Payable
$ 41,600
Interest Payable
1,200
Salaries Payable
3,600
Unearned Revenue
1,600
Total Current Liabilities
Long-term Liabilities:
Notes Payable
Total Liabilities
Common Stock
Retained Earnings
Total Liabilities and Stockholders’ Equity
$ 154,400
P4-29A, cont.
Requirement 4
Date
Accounts and Explanation
Debit
Credit
Dec. 31
Service Revenue
74,200
Income Summary
74,200
To close revenue.
Income Summary
23,600
Insurance Expense
1,300
Salaries Expense
16,600
Supplies Expense
Interest Expense
1,200
Depreciation ExpenseEquipment
2,000
Depreciation ExpenseBuilding
1,700
To close expenses.
Income Summary
50,600
Retained Earnings
50,600
To close Income Summary.
Retained Earnings
Dividends
2,400
To close dividends.
Requirement 5
Current ratio = Total current assets / Total current liabilities
P4-30A Preparing a worksheet, financial statements, and closing entries
Learning Objectives 1, 2, 3
2. Total Assets $88,000
The unadjusted trial balance of Frank Investment Advisers at December 31, 2016, follows:
Adjustment data at December 31, 2016:
a. Unearned Revenue earned during the year, $100.
b. Office Supplies on hand, $4,000.
c. Depreciation for the year, $7,000.
d. Accrued Salaries Expense, $2,000.
e. Accrued Service Revenue, $6,000.
Requirements
1. Prepare a worksheet for Frank Investment Advisers at December 31, 2016.
2. Prepare the income statement, the statement of retained earnings, and the classified balance sheet in
account format.
3. Prepare closing entries.
SOLUTION: Requirement 1
c.
d.
Dep. ExpenseEquip.
Total
$ 16,100
$ 193,000
$ 133,000
Total
$ 101,100
$ 133,000
$ 133,000
FRANK INVESTMENT ADVISERS
Worksheet
December 31, 2016
Account Names
Unadjusted Trial
Balance
Adjustments
Adjusted Trial
Balance
Income Statement
Balance Sheet
Debit
Credit
Debit
Credit
Debit
Credit
Debit
Credit
Debit
Credit
Cash
$ 28,000
$ 28,000
$ 28,000
P4-30A, cont.
Requirement 2
FRANK INVESTMENT ADVISERS
Income Statement
Year Ended December 31, 2016
Revenues:
Service Revenue
$ 101,100
Expenses:
Salaries Expense
Rent Expense
Depreciation ExpenseEquipment
Insurance Expense
Supplies Expense
Total Expenses
Net Income
$ 41,100
Statement of Retained Earnings
Net income for the year
Dividends
Retained Earnings, December 31, 2016
P4-30A, cont.
Requirement 2, cont.
FRANK INVESTMENT ADVISERS
Balance Sheet
December 31, 2016
Assets
Liabilities
Current Assets:
Current Liabilities:
Cash
$ 28,000
Accounts Payable
$ 16,000
Accounts Receivable
Salaries Payable
Office Supplies
Unearned Revenue
Total Current Assets
Total Current Liabilities
$ 19,900
Plant Assets:
Long-Term Liabilities:
Equipment
Notes Payable
Less: Acc. Depr.Equip.
Total Liabilities
Total Plant Assets
Common Stock
Retained Earnings
Total Assets
Equity
$ 88,000
P4-30A, cont.
Requirement 3
Date
Accounts and Explanation
Debit
Credit
Dec. 31
Service Revenue
101,100
Income Summary
101,100
To close revenue.
Income Summary
Insurance Expense
Salaries Expense
37,000
Supplies Expense
Interest Expense
Rent Expense
Depreciation ExpenseEquipment
To close expenses.
Income Summary
Retained Earnings
41,100
To close Income Summary.
Retained Earnings
Dividends
27,000
To close dividends.
P4-31A Completing the accounting cycle from adjusting entries to post-closing trial balance with
an optional worksheet
Learning Objectives 1, 2, 3, 4, 5, 6
5. Net Income $19,890
The unadjusted trial balance of Williamson Anvils at December 31, 2016, and the data for the
adjustments follow:
Adjustment data:
a. Unearned Revenue still unearned at December 31, $3,300.
b. Prepaid Rent still in force at December 31, $2,400.
c. Office Supplies used, $1,200.
d. Depreciation, $350.
e. Accrued Salaries Expense at December 31, $230.
Requirements
1. Open the T-accounts using the balances in the unadjusted trial balance.
2. Complete the worksheet for the year ended December 31, 2016. (optional)
3. Prepare the adjusting entries, and post to the accounts.
4. Prepare an adjusted trial balance.
5. Prepare the income statement, the statement of retained earnings, and the classified balance sheet in
report form.
6. Prepare the closing entries, and post to the accounts.
7. Prepare a post-closing trial balance.
8. Calculate the current ratio for the company.
SOLUTION
Requirements 1, 3, and 6
Cash
Common Stock
Bal.
16,370
16,000
Bal.
Bal.
16,370
16,000
Bal.
Bal.
16,500
Bal.
Bal.
16,500
Bal.
Bal.
Bal.
1,200
20,500
3,900
Adj.
24,400
Adj.
0
P4-31A, cont.
Requirements 1, 3, and 6, cont.
Accumulated DepreciationEquip.
Rent Expense
10,000
Bal.
Bal.
0
350
Adj.
Adj.
130
Bal.
130
130
Clos.
10,350
Bal.
Bal.
0
Depreciation ExpenseEquip.
Adj.
350
350
6,600
Adj.
Adj.
230
Adj.
3,300
P4-31A, cont.
Requirement 2
WILLIAMSON ANVILS
Worksheet
December 31, 2016
Account Names
Unadjusted Trial Balance
Adjustments
Adjusted Trial Balance
Income Statement
Balance Sheet
Debit
Credit
Debit
Credit
Debit
Credit
Debit
Credit
Debit
Credit
Cash
$ 16,370
$ 16,370
$ 16,370
Salaries
Accounts
16,500
16,500
16,500