PDA

View Full Version : How to prepare balance sheet in ms excel 2003?


ahsansheikh
Sep 14, 2009, 04:32 AM
Please tell

ROLCAM
Sep 14, 2009, 04:39 AM
Enclosed please find an example of a
Balance Sheet prepared on EXCEL:-


THE PURE WATER COMPANY PTY LIMITED



BALANCE SHEET as at 30th JUNE 2009

2009

CURRENT ASSETS
Cash at Bank - NAB 4,014.87
Loan - DATALEASE P/L 244,565.80
Loan - FAIRFAX 169,000.00
TOTAL CURRENT ASSETS 417,580.67

FIXED ASSETS
The Meadows 1,660,232.69
Stumm road 63,940.91

TOTAL FIXED ASSETS 1,724,173.60

TOTAL ASSETS 2,141,754.27


CURRENT LIABILITIES
Loan - BGA 1,218,374.08
Cash at Bank - Suncorp 695,672.60
Trade Creditor 413,565.80
Sundry Creditor 92,757.38

TOTAL CURRENT LIABILITIES 2,420,369.86

TOTAL NET ASSETS -278,615.59


EQUITY
Share Capital 2.00
Accumulated Losses -278,617.59

TOTAL DEFICIENCY -278,615.59