Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MS Excel - Create a Start up Budget and first 6 months operating expenses for your new Business using MS Excel. The Excel spreadsheet must

MS Excel - Create a Start up Budget and first 6 months operating expenses for your new Business using MS Excel. The Excel spreadsheet must include at a minimum the specifications listed below: a. Create two worksheets. The first worksheet should contain your expected expenses for start-up cost. The second worksheet what you expect it to cost to run your new business for the first 6 months. b. Name the two worksheets on the tab. The first worksheet should be named "Startup Costs" and the second "6 Month Expenses." c. Include the following information on the first worksheet: o Start up costs you might incur to start your business, such as equipment, supplies, deposits for electric, water, phone, etc. You may make up items and values based on your business. Must have at a minimum 5 items. Example: You need 10 laptops and each cost $1,599. Your total would be $15,990 for the computers. Fees to have water turned on might be $250 for a deposit. o Formulas for totals of the Startup cost. o Appropriate labels to identify all categories, columns, row, totals and other computed values. o A multi-row title section at the top of the first worksheet, merging cells as needed. Title should include a title for the worksheet, your name, course and section, and the date. d. Include the following format for the first worksheet: o Column heading cells should have a background color and the text should be in Arial 12 point and bold. o Totals should be clearly labeled and the values formatted with dollar signs ($). o Title section at top of page should be in Font of choice 14 point, bold and a background color of choice. e. Include the following information on the second worksheet: o 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting for Governmental and Nonprofit Entities

Authors: Earl R. Wilson, Jacqueline L Reck, Susan C Kattelus

15th Edition

978-0256168723, 77388720, 256168725, 9780077388720, 978-007337960

More Books

Students also viewed these Accounting questions

Question

=+ d. Income per worker in Richland is actually

Answered: 1 week ago