H.T.S. Crest Holy Trinity School
BIT1O
Excel Lab 03 - The Income Statement

Procedure:

1. Open a new excel spreadsheet file.

2. Save this file as "yourname, Excel Lab 03.xls"

3. Right click on the tab on the bottom of the spreadsheet and rename it "Income Statement".

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

Acme Web Page Designers
Income Statement
For the Month Ended June 30, 2000

REVENUE:    
Fees Earned   $4,500.00
     
EXPENSES:    
Office Supplies Expense $100.00  
Internet Expense $300.00  
Phone Expense 600.00  
Advertising Expense 1,800.00  
Total Expenses:   2,800.00
     
Net Income:   $1,700.00
    =======


5. 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 Expenses, and
  2. Net Income

Analyses:

  1. What is the projected profit / (loss) for this fiscal period?
  2. What could your business do in order to increase it profit (or reduce its loss) for the period?




Return to main index.