Presenting Two Different Periods

To present two periods by choosing each ending period separately, add a second Combo Box object to the worksheet.

Figure 4-12 shows two Combo Boxes at the top of each column.

Microsoft Excel - Financial Statements

File Edit View Insert Format Tools Data Window Help

Microsoft Excel - Financial Statements

File Edit View Insert Format Tools Data Window Help

A

E

C

D

1

2

April 30, 2003 V

1 December 31, 2002

3

4

XYZ Corporation Inc.

5

BALANCE SHEET

S

7

April 3G

December 31

3

Motes

2003

2002

9

ASSETS

10

11

Current Assets

ÎÉ

Cash

S

269,506

310,697

Accounts Receivable

7

1,479,934

1,538,494

14

Inventories

S

488,825

520,133

15

Prepaid Expenses

9

12,129

23,659

1G

Total Current Assets

2,250,394

2,400,982

17

16

Property and Equipment (at Cost)

IG

19

Land & Building

50.3,247

677,191

20

Machinery and Equipment

345,595

326,052

21

Furniture and Fixtures

53,172

47,906

22

Total Property and Eouiprnent

1,002,014

1,051,130

23

Less: Accumulated Depreciation

428,573

419,540

24

Net Book Value

573,441

531,610

25

26

Other Assets

27

Investment in Revenue Bond

12

326,060

300,260

26

Patents, Trademark's and Goodwill

13

46,754

52,500

29

Total Other Assets

372,831

352,760

30

31

TOTAL ASSETS

3,196,007

3,305,352

0 0

Post a comment