Create a business budget sheet using microsoftreg excelreg


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.

Solution Preview :

Prepared by a verified Expert
Business Management: Create a business budget sheet using microsoftreg excelreg
Reference No:- TGS01717383

Now Priced at $50 (50% Discount)

Recommended (91%)

Rated (4.3/5)