Introduction to Microsoft Excel Assignment
Summer, 2012
10 points If you need to learn about spreadsheets, here’s someplace to start: http://spreadsheets.about.com/ . You’ll find introductory information as well as advanced Excel features. For the assignment, you will create a spreadsheet, along with graphs projecting your company’s revenues and income for the five-year period starting in 2013. Assignment: You’ve come up with an idea for a great new company you want to start, and plan to begin operations in 2013. You’ll create a projection of the revenues and earnings of your company for a five year period so you can make presentations to potential investors. Worksheet:
Create the 2013 expected income statement for your company. Keep it simple – you’ll have salaries, rent, utilities, and office expenses to operate. Make sure you have at least six expense categories for your income statement. Then, for the following four years, use formulas based on the 2013 numbers to generate values for the revenues and expenses. These years should not have any numbers you’ve manually entered in the cells. From this basic income statement, create three separate projections: optimistic, pessimistic, and most likely. On the upper left hand corner of the worksheet, create a section that summarizes the revenues and earnings under each of these three scenarios. Provide a brief description of the scenarios: for example “optimistic represents 100 customers, pessimistic is 10 customers, most likely is 50 customers.” Labels should be appropriately justified, and amounts should be noted with “$” or “,” as necessary. Graphs:
-Create a line graph that plots the five years of revenue projections that shows each of the three scenarios.
-Create a second line graph that plots the five years of income projections showing each of the three scenarios.
-Create a pie