H.T.S. Crest Holy Trinity School
BIT1O
Excel Lab 04 - The Balance Sheet

Procedure:

1. Open a Excel Lab 03.xls.

2. Right click on the second tab on the bottom of the spreadsheet (beside the one that says "Income Statement") and rename it "Balance Sheet".

3. Set up the following columns within the spreadsheet. Record the following price, demand and supply figures.

Acme Web Page Designers
Balance Sheet
As at June 30, 2000

ASSETS:    
Cash $600.00  
Office Equipment 3,400.00  
Total Assets:   $4,000.00
    =======
LIABILITIES:    
Bank Loan $300.00  
Accounts Payable 250.00  
Total Liabilities:   550.00
     
OWNERS EQUITY:    
Capital $1,900.00  
(Plus) Net Income 1,700.00  
  3,600.00  
(Less) Drawings 150.00  
Total Owner's Equity:   3,450.00
Total Liabilities & Owner's Equity:   $4,000.00
    =======


4. Note: Some of these numbers simply have to be entered directly, while others need to be calculated. Please USE THE SOFTWARE to perform these calculations! That way, if you need to adjust your figures, your calculated figures will be adjusted automatically.

Figures which need to be calculated in this table include:

  1. Total Assets,
  2. Total Liabilities,
  3. Note: Net Income is linked from your previous Income Statement
  4. Capital plus Net Income (Capital minus Net Loss) Note: This figure has no name associated with it.
  5. Total Owner's Equity, and
  6. Total Liabilities and Owner's Equity

Analyses:

  1. What percentage of the assets do the Owners have equity in?
  2. What could your business do in order to increase the Owner's Equity ratio?




Return to main index.