591 wk4 asg1

CoachX
Week4WorkbookTemplate.xlsx
Home>Business & Finance homework help>Accounting homework help>591 wk4 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
P8.2A
Table 1 P8.2A
P8.6A
Table 1 P8.6A
P9.2A
Table 1 P9.2A
P9.7A
Table 1 P9.7A

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

P8.2A

Problem 8.2A
Suisse Imports
(a)
Date Account Titles Debit Credit
1 1. 1
2 2
3 3
4 2. 4
5 5
6 6
7 3. 7
8 8
9 9
10 4. 10
11 11
12 12
13 5. 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
(b)
1 ALLOWANCE FOR 1
2 ACCOUNTS RECEIVABLE DOUBTFUL ACCOUNTS 2
3 Bal. 600,000 Bal. 37,000 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10
11 11
12 12
(c)
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10
11 Account Titles Debit Credit 11
12 12
13 13
14 14
15 15
(d)
1 Accounts receivables turnover: 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 Average collection period: 10
11 11
12 12
13 13
14 14

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

P8.6A

Problem 8.6A
Harvee Company
Date Account Titles Debit Credit
1 Jan 5 1
2 2
3 3
4 4
5 5
6 6
7 Feb 2 7
8 8
9 9
10 12 10
11 11
12 12
13 13
14 14
15 15
16 26 16
17 17
18 18
19 19
20 20
21 21
22 Apr 5 22
23 23
24 24
25 12 25
26 26
27 27
28 28
29 June 2 29
30 30
31 31
32 32
33 15 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40

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

P9.2A

Problem 9.2A
Arnold Corporation
(a)
Date Account Titles Debit Credit
1 Apr 1 1
2 2
3 3
4 May 1 4
5 5
6 6
7 1 7
8 8
9 9
10 10
11 11
12 Computation of gain/loss on disposal: 12
13 13
14 14
15 15
16 16
17 17
18 18
19 June 1 19
20 20
21 21
22 22
23 July 1 23
24 24
25 25
26 Dec 31 26
27 27
28 28
29 31 29
30 30
31 31
32 Computation of book value: 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
(b) General Journal
Date Account Titles Debit Credit
1 Dec 31 1
2 2
3 3
4 31 4
5 5
6 6
7 Computation of equipment depreciation: 7
8 8
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
(c)
ARNOLD CORPORATION
Balance Sheet (Partial)
December" "31", "2023
1 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
1 LAND 1
2 12/31/22 Bal 3,000,000 2
3 3
4 4
5 5
6 6
7 BUILDINGS 7
8 12/31/22 Bal 26,500,000 8
9 9
10 10
11 11
12 12
13 EQUIPMENT 13
14 12/31/22 Bal 40,000,000 14
15 15
16 16
17 17
18 18
19 19
20 ACCUMULATED DEPRECIATION - BUILDINGS 20
21 12/31/22 Bal 11,925,000 21
22 22
23 23
24 24
25 25
26 26
27 27
28 ACCUMULATED DEPRECIATION - EQUIPMENT 28
29 12/31/22 Bal 5,000,000 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

P9.7A

Problem 9.7A
Blythe Corporation and Jacke Corporation
(a)
Blythe Corp. Jacke Corp.
1 (1) Return on assets: 1
2 2
3 3
4 4
5 5
6 (2) Profit margin: 6
7 7
8 8
9 9
10 10
11 (3) Asset turnover: 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
(b)
1 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