1) Opening Day Balance Sheet – using ONLY the information in the chart found on page 110.
2) Opening Month Expense Spreadsheet – using information from the chart on page 110 and some information that you create.
(i) Known Costs: Use the chart to identify and calculate any known cash-costs & non-cash costs. If they are fixed, enter them and their $ amount under fixed costs. Cash and non-cash costs each have their own subsection. For variable costs, do not enter any dollar value, just name or describe them.
(ii) Predict what some of your other business-related variable costs could be during your first month in operation.
3) Break Even Analysis Worksheet – using information you create that applies to your business’s product or service AND use the ONLY the Total CASH fixed expenses per month from your “Opening Month Expense Spreadsheet.” Do NOT include NON-Cash fixed expenses.
4) Break Even Analysis Spreadsheet – using information from your Worksheet, enter it into the Excel Spreadsheet. The formulas needed are already in the Spreadsheet. Your Break-Even number should match the Break Even number from your Worksheet.
My assignment is a start up surgical and medical supplies in Brooklyn