Using Validation

4 Using formulas that return and summarize data.

Balance Sheet formatting (including rounding to the thousands), printing, e-mailing, page-numbering methods, and so on, are described in subsequent chapters. Other important subjects, such as the common Balance Sheet and ratio analysis are discussed in the second part of this book, Analyzing Financial Statements and Creating Management Financial Reports.

Chapter 4

E2 Microsoft Excel - Financial Statements

File Edit View Insert Format Tools Data Window Help

December 31j 2003

XYZ Gnrporation Incj_

BALANCE SHEET

J

I

Oecember 31

0

Notes

20D3

2002

3

ASSETS

10

11

Current Assets

Cash

«

l'3Bü-, 134

SÏS,697

13

Accounts Receivable

7

1,653,BSS ■

1,538,494

14

Inventories 8

546,173

520,133

15

Prepaid Expenses

m

13,.552.

;23,659

16

Total Current Assets

2,514,407

2,400,082

1?

18

Property and Equipment (at Cost)

10

8

Land 8c Building

674,019

677,191

w

Machinery and Equipment

HBR14D

326,0^2

21

Furniture and Fixtures

59,410

47,906

M

Total Property and Equipment

l,lld;í6Síi:

1,051,150

23

Less: Accumulated Depreciation

(478,852)

(419,540)

24

Net Book Value

640,717

631,610

25

m-

Other Assets

m

Investment in Revenue Bond

11

.364,32i

300,260

28

Patents, Trademarks and Goodwill

12

BSÈÏÔ

5-2,500

29:

Total Other Assets

416,571

352,760

30

31

TOTAL ASSETS

3,571,695

3,305,352

32

■ 33

LIABILITIES AND STOCKHOLDER'S EQUITY

34

r

Current Liabilities

Line of Credit

ä

476,783

500,8.34

■ 37

Current Portion of Long-Term Debt

40,252

39,506

38-

Accounts Payable

m

547,255

475Í284

'39.

Accrued Expenses

14

234,296

221,291

40

Other Payables

is

19,250

26,937;

41

Total Current Liabilities

1,317,33?

1,263,851

42-

43

Long-Term Liabilities

PE

Note Payable

16

784,2.73

840,105

45

Equipment Leases Payable

17

■185,459

224,965

46

Less: Current Portion Shown Above

(40,252)

(39,506)

47

Total Long-Term Liabilities

929,430

1,025,564

48

49

TOTAL LIABILITIES

2,247,316

2,289,416

50

51

Stockholder's Equity

Capital Stock

151,897

152^523

■■ ;

Retained Earnings

ig

¡Si 7 2,482

943^314

54-

Total Stockholder's Equity

1,324,379

1,095,937

7

56

TOTAL LIABILITIES AMD STOCKHOLDER'S EQUITY

3,571,696

3,385,362

Figure 4-1: Balance Sheet for the Year Ending December 31

0 0

Post a comment