Creating Balance Sheet structure 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 figures are derived from data in sheet DATA using formulas. An update in sheet DATA will automatically update this report as well.

	A						B			C
1 	SATU DUA (M) SDN BHD
2	
3	BALANCE SHEET FOR THE PERIOD ENDED 31-5-2002
4
5	CATEGORY							YEAR TO DATE
6										MAY-02
7
8	CAPITAL					A			(11,000,000.00)
9
10 	UNAPPROPRIATED PROFIT	B			(19,005,407.06)
11
12							C=A+B			(30,005,407.06)
13 	REPRESENTED BY:
14
15 	FIXED ASSET				D			13,291,438.72
16
17 	INVESTMENT				E			62,500.00
18
19 	INTER-COMPANY:
20 	HOLDING COMPANY			F			6,423,336,33
21 	SUBSIDIARY A			G			850,668.00
22 	ASSOCIATED COMPANY		H			8,000,000.00
23							I=F+G+H		15,274,004.33
24
25 	CURRENT ASSETS:
26 	STOCK					J			3,371,885.28
27 	TRADE DEBTOR			K			13,183,467.61
28 	OTHER DEBTOR			L			274,929.23
29	CASH IN BANK			M			412,717 17
30 	CASH IN HAND			N			25,429.86
31							O=J+K+L+M+N	17,268,429.15
32	LESS
33
34	CURRENT LIABILITIES:	
35	TRADE CREDITOR			O			(10,426,614.53)
36	OTHER CREDITOR			P			(1,663,415.99)

55