Question

In: Accounting

1 a b c 2 Aspen Industries INCOME STATEMENT 3 4 2004 2003 5 sales 285000...

1 a b c
2

Aspen Industries

INCOME STATEMENT

3
4 2004 2003
5 sales 285000 190,000
6

cost of goods sold

215000 143000
7 g. profit 70000 47000
8 operating expenses
9 variable expenses 28500 19000
10 fixed exp. 21000 20000
11 depreciation 10000

4500

12 total 59500 43500
13 EBIT 10500 3500
14 INTEREST EXP. 6100 3000
15 EBT 4400 500
16 TAXES 1540 175
17 NET INCOME 2860 325
18
19 NOTE
20 TAX RATE 35%
21 PAYOUT RATON 30%
22 DIVIDENTS 858
A b c
BALANCE SHEET
4 2003 2004
5 ASSETS
6

Cash

4,000

9,000

7

Accounts Receivable

16,000

12,500

8

Inventories

42,500

29,000

9 TOTAL C.A. 62500

50,500

10

Land

26,000

20,000

11

Buildings and Equipment

100,000

70,000

12

Accumulated Depreciation

(38,000)

(28,000)

13

Total Fixed Assets

88,000

62,000

14

Total Assets

150,500

112,500

15
16

Liabilities and Owner's Equity

17

Accounts Payable

22,298

10500
18

Short-term Bank Notes

47,000

17000
19

Total Current Liabilities

69,298

27,500

20

Long-term Debt

22,950

28,750

21

Common Stock

31,500

31,500

22

Retained Earnings

26,752

24,750

23

Total Liabilities and Owner's Equity

150,500

112,500

a. (6 points) Re-create the income statement and balance sheet using formulae wherever possible. Each statement should be on a separate worksheet. Try to duplicate the format exactly.

b. (4 points) On another worksheet, create a statement of cash flows for 2004. Do not enter any numbers directly on this worksheet. All formulae should be linked directly to the source on previous worksheets.

c. (1 point) Using Excel’s outlining feature, create an outline on the statement of cash flows that, when collapsed, shows only the subtotals for each section.

d. (2 points) Suppose that sales were $320,000 in 2004 rather than $285,000 (all other information remains unchanged). What is the 2004 net income and retained earnings?

e. (2 points) Undo the changes from Part d, and change the tax rate to 40% (all other information remains unchanged). What is the 2004 net income and retained earnings?

Solutions

Expert Solution


Related Solutions

Direction ratio of line joining (2, 3, 4) and (−1, −2, 1), are: A. (−3, −5, −3) B. (−3, 1, −3) C. (−1, −5, −3) D. (−3, −5, 5)
Direction ratio of line joining (2, 3, 4) and (−1, −2, 1), are:A. (−3, −5, −3)B. (−3, 1, −3)C. (−1, −5, −3)D. (−3, −5, 5)
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 30,000...
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 30,000 units 5 Selling price per unit $70 per unit 6 Variable expenses per unit $42 per unit 7 Fixed expenses $420,000 8 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the break-even in dollar sales?        (b) What is the margin of safety percentage?        (c) What is the degree of operating leverage? (Round...
A, B, C, D are all matricies A = 2x3 1 2 −3 −1 4 5...
A, B, C, D are all matricies A = 2x3 1 2 −3 −1 4 5 , B = 2x3 3 0 −1 1 2 1 , C = 2x2 2 5 1 2 , D = 3x3 1 −1 1 2 −1 2 4 −3 4 Find each of the following or explain why it does not exist. 1) A + B, 2) 2A − 3B, 3) A + C, 4) A − C, 5) AC, 6) CA, 7)...
1. Evaluate: (a+b)/(c-d) + 9/(a+d) when a=5, b=3, c=8, d=4 a. 6 b. 3 c. 15/2...
1. Evaluate: (a+b)/(c-d) + 9/(a+d) when a=5, b=3, c=8, d=4 a. 6 b. 3 c. 15/2 d. 17/13 2. Solve for x: 5(x+3) = 35 a. 2 b. 7 c. 4 d. -4 3. Acid rain occurs primarily as a result of a. operating a nuclear power plant b. burning coal or oil containing sulfur c. by-products created by operating an oil refinery d. the use of Freon and other refrigerants 4. The "ozone holes" at the polar region arise...
Find the distances: A) Between ?1=〈2+2?,−1+?,−3?〉and ?2=〈4,−5−3?,1+4?〉 . B) Between the planes 2?−?+5?=0 and 2?−?+5?=5 ....
Find the distances: A) Between ?1=〈2+2?,−1+?,−3?〉and ?2=〈4,−5−3?,1+4?〉 . B) Between the planes 2?−?+5?=0 and 2?−?+5?=5 . C) From the point (1,2,3) to the line ?=〈−?,4−?,1+4?〉 .
Find the value of a : b : c : d, if a : b = 2 : 3, b : c = 4 : 5 and c : d = 6 : 7.
Find the value of a : b : c : d, if a : b = 2 : 3, b : c = 4 : 5 and c : d = 6 : 7.
1. The comparative income statement of Lawn Products, Inc. showed sales of $325,000 in 2004 and...
1. The comparative income statement of Lawn Products, Inc. showed sales of $325,000 in 2004 and $494,450 in 2005. Compute the percentage of net change in sales. (Round answer to one decimal place.)a. 52.1%b. 34.3%c. 48.5%d. 65.7% 2. The balance sheet of Food Products, Inc. showed owners' equity of $200,000 in 2001 and $320,000 in 2002. Compute the percentage of increase in owners' equity. (Round answer to one decimal place.)a. 37.5%b. 62.5%c. 60.0%d. 38.4%
Male Female child A 4 3 9 B 3 541 2 C 5 1 f541 D...
Male Female child A 4 3 9 B 3 541 2 C 5 1 f541 D 9 6 4 E 7 9 10 IAQ  6   USING THE TABLE IN IAQ 5,  THE NAMES OF ALL OF THESE PEOPLE ARE PLACED IN A BOX, THEY ARE THORUGHLY MIXED;  THEN ONE NAME IS PULLED FROM THE BOX AT RANDOM;  ; FIND THE PROBABILITY THAT  THE PERSON WAS FEMALE GIVEN  THAT THEY WERE IN GROUP B 3 PLACE DECIMAL     
Hallstead Jewelers; Income Statements for Years Ended January 31 (thousands of dollars) 2003 2004 2006 Sales...
Hallstead Jewelers; Income Statements for Years Ended January 31 (thousands of dollars) 2003 2004 2006 Sales $8,583 $8,102 $10,711 Cost of goods sold 4,326 4,132 5,570 Gross margin $4,257 $3,970 $ 5,141 Expenses Selling expense Salaries 2,021 2,081 3,215 Commissions 429 405 536 Advertising 254 250 257 Administrative expenses 418 425 435 Rent 420 420 840 Depreciation 84 84 142 Miscellaneous expenses 53 93 122 Total expenses $3,679 $3,758 $ 5,547 Net income $ 578 $ 212 $ (406) Exhibit...
Atomicity of phosphorus is (a) 1 (b) 2 (c) 3 (d) 4
Atomicity of phosphorus is ________.(a) 1(b) 2(c) 3(d) 4
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT