Comp25: Excel - Income/Expense Worksheet

Learning Objectives

1. To create a one-year income-expenses forecast for your business using Excel.
2. To learn how to do basic spreadsheet functions (SUM). formulas and formatting.

Steps to Take

1. Start by creating a new Excel spreadsheet. 
   1. Create at least three sources of income for your business beginning in A2, such as Sales, Leasing, Autos, Trucks.
   2. Create a variety of expenses in Column A, below Income,  that your business will be paying, such as Payroll, Advertising, merchandise, etc.  You must have at least eight (8) expense categories
2. Create twelve months of fake data, starting with January in B1 as a template for rest of the year.  Be sure to use shortcuts that you learned in class to make this process take only a few minutes.
3. Use the AutoSum feature to total rows and columns in your budget. 
4. Edit a variety of values for each of your expenses throughout the year.  For example, your advertising budget might go up in the summer and down in the winter.  Perhaps you need to hire more people for the holiday season.  Make a number of edits so that later, when a chart is created of this information, it looks more interesting.  Save your work.
5. At the bottom of your worksheet, create a row for "Profit", that projects your potential profits for the year.
   
6. Use formatting (fonts, number formats, color, borders, alignment, and column width and height) to make your spreadsheet more presentable and easier to read.
7. Adjust your Page Setup settings so that the spreadsheet is in Landscape orientation, and fits to 1 page.
8. Upload your work to Blackboard when you are finished.

Grading Guidelines

This assignment will be graded using the following guidelines: