Budget
Instructions:
Create a business budget sheet using Microsoft® Excel®. In the budget sheet do the following:
• Create a label called “Income” and add your monthly eBusiness income in the next cell: $42,000 (adjust the monthly incomes so they are a little different each month).
• Add a label called “Rent” and enter the amount in the next cell: -$2,000.
• Add a label called “Product Spending” and enter the amount in the next cell: -$20,000 (change this by +$1,000 for each month).
• Add a label called “Gas” and add the amount in the next cell: -$250.
• Add a label called “Car Payment” and add the amount in the next cell: -$500.
• Add a label called “Electric” and add the amount in the next cell: -$600 (change this by +$75 for each month).
• Add a label called “Insurance” and add the amount in the next cell: -$500.
• Add a label called “Website hosting” and add the amount in the next cell: -$20.
• Add a label called “Cloud Storage” and add the amount in the next cell: -$10.
• Add a label called “Paypal Charges” and add the formula/function in the next cell: (cell contents MUST be a “function”: 2% of the monthly income cell).
Create 2 charts (a chart for your business annual income and another chart for the annual expenses).
Formating:
– Header: Enter title, student name.
– Footer: Enter Page #, date.
– Set borders around the cells you enter data into.
– Set the page settings (Page layout, Print Area, Margins.
