Define a 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). – 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, Size, etc.). Everything must print on 1 sheet of paper in landscape (review print preview).
