E4-13 - Analyze adjusted data
This is a partial adjusted trial balance of Barone Company
| |
BARONE COMPANY |
|
|
Adjusted Trial Balance |
|
|
31-Jan-14 |
|
| |
|
|
| |
Debit |
Credit |
| Supplies |
$700 |
|
| Prepaid Insurance |
1,560 |
|
| Salaries and Wages Payable |
|
$1,060 |
| Unearned Service Revenue |
|
750 |
| Supplies Expense |
950 |
|
| Insurance Expense |
520 |
|
| Salaries and Wages Expense |
1,800 |
|
| Service Revenue |
|
4,000 |
Instructions
Answer these questions, assuming the year begins January 1.
(a) If the amount in Supplies Expense is the January 31 adjusting entry, and $300 of supplies was purchased in January, what was the balance in Supplies on January 1?
(b) If the amount in Insurance Expense is the January 31 adjusting entry, and the original insurance premium was for 1 year, what was the total premium and when was the policy purchased?
(c ) If $2,500 of salaries was paid in January, what was the balance in Salaries and Wages Payable at December 31, 2013?
(d) If $1,800 was received in January for services performed in January, what was the balance in Unearned Service Revenue at December 31, 2013?
NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" .
E4-16 Prepare adjusting entries from analysis of trial balance
|
BERE OMPANY
|
|
Trial Balance
|
|
August 31, 2014
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Before
|
After
|
|
|
|
|
|
Adjustment
|
Adjustment
|
|
|
|
|
|
Dr.
|
Cr.
|
Dr.
|
Cr.
|
|
Cash
|
|
|
|
$10,900
|
|
$10,900
|
|
|
Accounts Receivable
|
|
8,800
|
|
9,400
|
|
|
Supplies
|
|
|
|
2,500
|
|
500
|
|
|
Prepaid Insurance
|
|
|
4,000
|
|
2,500
|
|
|
Equipment
|
|
|
16,000
|
|
16,000
|
|
|
Accumulated Depreciation - Equipment
|
3,600
|
|
4,800
|
|
Accounts Payable
|
|
|
|
5,800
|
|
5,800
|
|
Salaries and Wages Payable
|
|
|
0
|
|
1,100
|
|
Unearned Rent Revenue
|
|
|
1,800
|
|
800
|
|
Common Stock
|
|
|
|
10,000
|
|
10,000
|
|
Retained Earnings
|
|
|
|
5,500
|
|
5,500
|
|
Dividends
|
|
|
2,800
|
|
2,800
|
|
|
Service Revenue
|
|
|
|
34,000
|
|
34,600
|
|
Rent Revenue
|
|
|
|
12,100
|
|
13,100
|
|
Salaries and Wages Expense
|
|
17,000
|
|
18,100
|
|
|
Supplies Expense
|
|
|
0
|
|
2,000
|
|
|
Rent Expense
|
|
|
10,800
|
|
10,800
|
|
|
Insurance Expense
|
|
|
0
|
|
1,500
|
|
|
Depreciation Expense
|
|
0
|
|
1,200
|
|
|
|
|
|
|
$72,800
|
$72,800
|
$75,700
|
$75,700
|
The trial balance shown below are before and after adjustment for Bere Company at the end of its fiscal year.
Instructions
Prepare the adjusting entries that were made
NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" .
P4-1A Record transactions on accrual basis; convert revenue to cash receipts
The following selected data are taken from the comparative financial statements of American Curling Club. The club prepares its financial statements using the accrual basis of accounting.
|
September 30
|
|
2014
|
|
2013
|
|
|
Accounts receivable for member dues
|
|
$ 15,000
|
|
$ 19,000
|
|
|
Unearned sales revenue
|
|
|
20,000
|
|
23,000
|
|
|
Service revenue (from member dues)
|
|
151,000
|
|
135,000
|
|
Dues are billed to members based upon their use of the club's facilities. Unearned sales revenues arise from the sale of tickets to events, such as the Skins Game.
Instructions
(Hint: You will find it helpful to use T-accounts to analyze the following data. You must analyze these data sequentially, as missing information must first be deduced before moving on. Post your journal entries as you progress, rather than waiting until the end.)
(a) Prepare journal entries for each of the following events that took place during 2014.
1. Dues receivable from members from 2013 were all collected during 2014.
2. During 2014, goods were provided for all of the unearned sales revenue at the end of 2013.
3. Additional tickets were sold for $44,000 cash during 2014, a portion of these were used by the purchasers during the year. The entire balance remaining in Unearned
Sales Revenue relates to the upcoming Skins Game in 2014.
4. Dues for the 2013-2014 fiscal year were billed to members.
5. Dues receivable for 2014 (i.e., those billed in item (4) above ) were partially collected.
(b) Determine the amount of cash received by American from the above transactions during the year ended September 30, 2014.
NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?".
Excel spread sheets completed. I really need assistance with this.