591 wk2 asg1

CoachX
Week2WorkbookTemplate.xlsx
Home>Business & Finance homework help>Accounting homework help>591 wk2 asg1

Export Summary

This document was exported from Numbers. Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel.
Numbers Sheet Name Numbers Table Name Excel Worksheet Name
Instructions
Table 1 Instructions
P3.2A
Table 1 P3.2A
P3.5A
Table 1 P3.5A
E4.14
Table 1 E4.14
E4.15
Table 1 E4.15
E4.19
Table 1 E4.19
E4.21
Table 1 E4.21
E4.22
Table 1 E4.22
E4.23
Table 1 E4.23

Instructions

BUS591 Workbook Template
Tips for using the weekly workbook templates:
1) Locate the assigned exercises or problems at the end of the chapter reading in your textbook.
2) Download and save the workbook to your computer in a location where you will be able to easily find it and retrieve it.
3) The workbook has a separate tab designated for each exercise and problem. Be sure to complete all tabs each week.
4) Each tab is pre-designed to fit the assigned problem. This should save you some time in formatting and allow you to focus on mastering the learning objectives required to successfully complete each problem.
5) Remember that you can use the formula functions within Excel to simplify your computations and reduce opportunities for typographical errors.
6) After you have completed the assignment, save the document, and upload for grading.
*Note: Not all lines on the template will be used for every problem. The template is simply a guide to save you time in formatting. Feel free to modify, add lines, or delete lines as you feel appropriate for each problem.

&"Helvetica Neue,Regular"&12&K000000&P

P3.2A

Problem 3.2A
Curry Consulting Inc.
(a)
CURRY CONSULTING INC.
Assets = Liabilities + Stockholders' Equity
Accounts Notes Accounts Common Retained Earnings
Date Cash + Receivable + Supplies + Equipment = Payable + Payable + Stock + Revenues - Expenses - Dividends Explanation
1 May 1 1
2 2 2
3 3 3
4 5 4
5 9 5
6 12 6
7 15 7
8 17 8
9 20 9
10 23 10
11 26 11
12 29 12
13 30 13
14 14
(b)
CURRY CONSULTING INC.
Income Statement
For the Month Ended May 31, 2022
1 Revenues 1
2 2
3 3
4 Expenses 4
5 5
6 6
7 7
8 8
9 9
10 10
11 Net income 11
12 12
13 13
14 14
(c)
CURRY CONSULTING INC.
Balance Sheet
May" "31", "2022
1 Assets 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 Liabilities and Stockholders' Equity 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20

&"Helvetica Neue,Regular"&12&K000000&P

P3.5A

Problem 3.5A
Ayala Architects Inc.
(a)
Date Account Titles Debit Credit
1 Apr 1 1
2 2
3 3
4 4
5 1 5
6 6
7 2 7
8 8
9 9
10 10
11 3 11
12 12
13 13
14 14
15 15
16 10 16
17 17
18 18
19 19
20 11 20
21 21
22 22
23 23
24 24
25 20 25
26 26
27 27
28 28
29 30 29
30 30
31 31
32 32
33 30 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
(b)
1 CASH COMMON STOCK 1
2 2
3 3
4 4
5 5
6 6
7 7
8 ACCOUNTS RECEIVABLE SERVICE REVENUE 8
9 9
10 10
11 11
12 12
13 13
14 14
15 SUPPLIES SALARIES AND WAGES EXPENSE 15
16 16
17 17
18 18
19 19
20 20
21 21
22 ACCOUNTS PAYABLE RENT EXPENSE 22
23 23
24 24
25 25
26 26
27 27
28 28
29 UNEARNED SERVICE REVENUE 29
30 30
31 31
32 32
33 33
34 34
35 35
(c)
AYALA ARCHITECTS INC.
Trial Balance
April" "30", "2022
1 Debit Credit 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10
11 11
12 12
13 13
14 14
15 15

&"Helvetica Neue,Regular"&12&K000000&P

E4.14

Exercise 4.14
Villa Company
Date Account Titles Debit Credit
1 (a) 1
2 July 10 2
3 3
4 4
5 14 5
6 6
7 7
8 15 8
9 9
10 10
11 20 11
12 12
13 13
14 14
15 15
16 (b) 16
17 July 31 17
18 18
19 19
20 31 20
21 21
22 22
23 31 23
24 24
25 25
26 31 26
27 27
28 28
29 29
30 30

&"Helvetica Neue,Regular"&12&K000000&P

E4.15

Exercise 4.15
Ramon Company
Answer Computation
1 (a) 1
2 2
3 3
4 4
5 5
6 6
7 (b) 7
8 8
9 9
10 10
11 11
12 12
13 13
14 (c) 14
15 15
16 16
17 17
18 18
19 19
20 20
21 (d) 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30

&"Helvetica Neue,Regular"&12&K000000&P

E4.19

Exercise 4.19
Identify Accounting Terms
1 a. Expenses paid in cash before they are used or consumed. 1
2 2
3 b. The difference between the cost of a depreciable asset and its related 3
4 accumulated depreciation. 4
5 5
6 c. A list of accounts and their balances after all adjustments have been made. 6
7 7
8 d. Entries made at the end of an accounting period to ensure that the revenue 8
9 recognition and expense recognition principles are followed. 9
10 10
11 e. Entries at the end of an accounting period to transfer the balances of 11
12 temporary accounts to a permanent stockholders' equity account, Retained 12
13 Earnings. 13
14 14
15 f. Revenue, expense, and dividend accounts whose balances a company 15
16 transfers to Retained Earnings at the end of an accounting period. 16
17 17
18 g. The planned timing of revenues, expenses, gains, and losses to smooth out 18
19 bumps in net income. 19
20 20
21 h. An account that is offset against an asset account on the balance sheet. 21
22 22
23 i. A temporary account used in closing revenue and expense accounts. 23
24 24
25 j. Balance sheet accounts whose balances are carried forward to the next 25
26 accounting period. 26
27 27
28 k. The process of allocating the cost of an asset to expense over its useful life. 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40

&"Helvetica Neue,Regular"&12&K000000&P

E4.21

Exercise 4.21
Tippy Corporation
(a)
Date Account Titles Debit Credit
1 Dec 31 1
2 2
3 3
4 4
5 31 5
6 6
7 7
8 8
9 9
10 10
11 31 11
12 12
13 13
14 31 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 (b) 22
23 Retained Earnings 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40

&"Helvetica Neue,Regular"&12&K000000&P

E4.22

Exercise 4.22
Date Account Titles Debit Credit
1 Aug 31 1
2 2
3 3
4 31 4
5 5
6 6
7 31 7
8 8
9 9
10 31 10
11 11
12 12
13 31 13
14 14
15 15
16 31 16
17 17
18 18
19 19
20 20

&"Helvetica Neue,Regular"&12&K000000&P

E4.23

Exercise 4.23
Ryan Company
RYAN COMPANY
Income Statement
For the Year Ended August 31, 2022
1 Revenue 1
2 2
3 3
4 4
5 5
6 Expenses 6
7 7
8 8
9 9
10 10
11 11
12 12
13 13
14 Net income 14
15 15
RYAN COMPANY
Retained Earnings Statement
For the Year Ended August 31, 2022
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10

&"Helvetica Neue,Regular"&12&K000000&P