microdoft-excel

Create a Startup Budget and first 6 months operating expenses for your new Business using Excel.

The Excel spreadsheet is required to have the following speculations:Create three worksheets:

Startup Costs:your expected expenses for start-up cost.

6 Month Expenses:show your expenses for the first 6 months.

Income vs Expenses:states the Income versus Expenses chart.

Requirements (each worksheet is 10 points):

1.Name the three worksheets on the tab:

First worksheet named: Startup Costs

Second worksheet named:6 Month Expenses

Third worksheet named:Income vs. Expenses

2.First Worksheet contains:

Startup costs you will incur to start your business, such as equipment, supplies, deposits for electric, water, phone, etc. as your line items. Minimum of 5 line items are required.

Sum of each category is done by the Sum Function.

Totals are clearly labeled and the values formatted as Currency with dollar signs ($).

Appropriate labels to identify all categories, columns, row, totals

A multi-row title section at the top of the first worksheet, merging cells as needed.

Column heading cells is Arial 12 point, bold and a background color of your choice.

Title section at top of page is Arial 12 point, bold and a background color of your choice.

Title includes a title for the worksheet, your name, course and section, and the date.

3.Second Worksheet contains:

Example: You have talked to other business owners in the area and know they spend approximately $275 per month for electricity except in the winter months when it increases to roughly $350 per month. You need to hire 5 employees and you will start them out with different monthly salaries and they range from $2500 to $4600 per month.

Estimated monthly expenses for the first 6 months, such as salaries (don’t forget your own salary), electric, water, phone, Internet connection, supplies and anything else you may need.

Must have at a minimum 5 expenses.

Formulas for totals for each month and categories and an overall total for the 6 months.

Appropriate labels to identify all categories, columns, rows, totals and other computed values.

Totals are clearly labeled and the values formatted as Currency with dollar signs ($).

Appropriate labels to identify all categories, columns, row, totals

A multi-row title section at the top of the first worksheet, merging cells as needed.

Column heading cells is Arial 12 point, bold and a background color of your choice.

Title section at top of page is Arial 12 point, bold and a background color of your choice.

Title includes a title for the worksheet, your name, course and section, and the date.

4.Third Worksheet contains:

Copy the values by using Link feature from the Second Worksheet for the Total Income and Expenditure.

Insert a chart to show the total income and expenses of your business as a visual aid.

"Is this question part of your assignment? We can help"

ORDER NOW