Ask Experts Questions for FREE Help !
Ask
    ahsansheikh's Avatar
    ahsansheikh Posts: 1, Reputation: 1
    New Member
     
    #1

    Sep 14, 2009, 04:32 AM
    How to prepare balance sheet in ms excel 2003?
    Please tell
    ROLCAM's Avatar
    ROLCAM Posts: 1,420, Reputation: 23
    Ultra Member
     
    #2

    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

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to prepare a balance sheet referring a trial balance [ 5 Answers ]

How to prepare a balance sheet from a trial balance ? Can anybody help me by giving An example Regards alanani

How to prepare balance sheet with trail balance [ 1 Answers ]

How to prepare balance sheet with trail balance

How to prepare a balance sheet? [ 2 Answers ]

Need help in doing a balance sheet.


View more questions Search