1) Prepare your sales projections for three to five years in Excel. Before submitting your Excel spreadsheet for grading make sure you:
• Check to see that you are not missing any formulas.
• Format each cell with numbers to round up to the nearest dollar
• Format all cells properly – $, %, column width, etc.
• Format page layout properly for orientation, footers, gridlines, etc.
• Format to print – should not be more than two pages, one is more likely.

2) Save your Excel spreadsheet in .xls format and use the following naming convention:
CourseID_U#_Your Last Name_Your First Name_Sales Projections
e.g. MGS 3013_U6_Smith_John_Sales Projections

3) When you are ready to upload your assignment, click on the title of the assignment and attach your spreadsheet. You may leave comments in the Submission text if you have anything you wish to discuss with your instructor about your assignment.

4) You are allowed two attempts on this assignment. Your instructor will provide you with comments on your sales projections and you may submit another attempt if needed.

1. Financial Plan (Sales Projections)
1.1 Forecast
a. key assumptions (Calculation required excel sheet table)
b. revenue by month (Calculation required excel sheet table)
c. expenses by month (Calculation required excel sheet table)
d. net profile (or loss) by year (Calculation required excel sheet table)
1.2 Financing
a. use of funds
b. sources of funds
1.3 Statements
a. Project cash flow (Calculation required excel sheet table)
b. Project Profit and loss (Calculation required excel sheet table)
c. Project Balance Sheet (Calculation required excel sheet table)