Creating Balance Sheet using formula page 55

Creating 'Balance Sheet' Report Using Formulas

We need a separate sheet in the file (workbook) to build a Balance Sheet statement. Insert a new sheet and name it appropriately (The name BS is used in this book). The position of the sheet is not important. You can position it anywhere among the other sheets.

A suggested structure for a Balance Sheet report (or statement) is shown below.
All
are derived from data in sheet DATA using formulas. An update in sheet DATA will automatically update this report as well.

1 	SATU DUA (M) SDN BHD
2	BALANCE SHEET FOR THE PERIOD ENDED 31-5-2002
3
4
5
6	CATEGORY	YEAR TO DATE
				MAY-02
7
8	CAPITAL		(11,000,000.00)
9
10 	UNAPPROPRIATED PROFIT
11
12
(19,005,407.06)

13 REPRESENTED BY

(30,005,407.06)

14

15 FIXED ASSET

10

17 INVESTMENT

13,291,438.72

19 INTER-COMPANY

62,500.00

18

20 HOLDING COMPANY

6,423,336,33

21 SUBSIDIARY A

850,668.00

22 ASSOCIATED COMPANY

23

15,274,004.33

24

25 CURRENT ASSETS.

25 STOCK

3,371,885.28

27 TRADE DEBTOR

13,183,467.61

28 OTHER DEBTOR

274,929.23

CASH IN BANK

412,717 17

30 CASH IN HAND

25,429.86

LESS

17,268,429.15

31

CURRENT LIABILITIES.

(10,426,614.53)

TRADE CREDITOR

(1,663,415.99)

PART 3: Create Report

OTHER CREDITOR

55