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 | |
P1.3A | ||
Table 1 | P1.3A | |
P1.5A | ||
Table 1 | P1.5A | |
P2.4A | ||
Table 1 | P2.4A |
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
P1.3A
Problem 1.3A | ||
Elite Service Co. | ||
(a) | ||
ELITE SERVICE CO. | ||
Income Statement | ||
For the Month Ended June 30, 2022 | ||
1 | Revenues | 1 |
2 | 2 | |
3 | 3 | |
4 | Expenses | 4 |
5 | 5 | |
6 | 6 | |
7 | 7 | |
8 | 8 | |
9 | 9 | |
10 | 10 | |
11 | 11 | |
12 | Net income | 12 |
13 | 13 | |
ELITE SERVICE CO. | ||
Retained Earnings Statement | ||
For the Month Ended June 30, 2022 | ||
1 | 1 | |
2 | 2 | |
3 | 3 | |
4 | 4 | |
5 | 5 | |
6 | 6 | |
ELITE SERVICE CO. | ||
Balance Sheet | ||
June” “30”, “2022 | ||
1 | Assets | 1 |
2 | 2 | |
3 | 3 | |
4 | 4 | |
5 | 5 | |
6 | 6 | |
7 | 7 | |
8 | Liabilities and Stockholders’ Equity | 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 | |
(b) & (c) | ||
1 | (b) | 1 |
2 | 2 | |
3 | 3 | |
4 | 4 | |
5 | 5 | |
6 | (c) | 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
P1.5A
Problem 1.5A | ||
Rojo Corporation | ||
(a) | ||
1 | Items to be included: | 1 |
2 | 2 | |
3 | 3 | |
4 | 4 | |
5 | 5 | |
6 | 6 | |
7 | 7 | |
ROJO CORPORATION | ||
Statement of Cash Flows | ||
For the Year Ended December 31, 2022 | ||
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 | |
(b) | ||
1 | 1 | |
2 | 2 | |
3 | 3 | |
4 | 4 | |
5 | 5 | |
6 | 6 | |
7 | 7 | |
8 | 8 |
&”Helvetica Neue,Regular”&12&K000000&P
P2.4A
Problem 2.4A | ||
Loeb Corporation and Bowsh Corporation | ||
(a) | Loeb Corporation | Bowsh Corporation |
1 | 1 | |
2 | 2 | |
3 | 3 | |
4 | 4 | |
5 | 5 | |
6 | Net income | 6 |
7 | 7 | |
8 | Earnings per share | 8 |
9 | 9 | |
10 | 10 | |
11 | Analysis: | 11 |
12 | 12 | |
13 | 13 | |
14 | 14 | |
15 | 15 | |
16 | (b) | 16 |
17 | 17 | |
18 | 18 | |
19 | Working capital | 19 |
20 | 20 | |
21 | Current ratio | 21 |
22 | 22 | |
23 | 23 | |
24 | 24 | |
25 | Analysis: | 25 |
26 | 26 | |
27 | 27 | |
28 | 28 | |
29 | 29 | |
30 | (c) | 30 |
31 | Debt to assets ratio | 31 |
32 | 32 | |
33 | 33 | |
34 | 34 | |
35 | 35 | |
36 | 36 | |
37 | Free cash flow | 37 |
38 | Analysis: | 38 |
39 | 39 | |
40 | 40 |
&”Helvetica Neue,Regular”&12&K000000&P