Reference no: EM132252854
Using the supplied Excel Spreadsheet, the financial component of your business plan includes the following.
1. Projected Sales income statement by product line by month/years (1 to 3)
Sales: Number of units of product/service estimated to be sold each week X price (Example: 10 roses per week X $2 per rose = $20 estimated sales per week) (SalesProj)
2. Staffing Budget by type of employees. (StaffBudj)
3. Marketing Budget by marketing activities (MktBudj)
4. Professional Services Budget (legal, accounting, etc)
5. A projected income statement for the period (IncSt)
6. Projected Cash Flow statement for the period (CshFlw)
7. Equipment list (if applicable)
8. Capital needed to get the business started (use from previous assignment)
Schedule (table) of how much capital is needed and for what (CapInvest)
9. Break-Even Estimate (BrkEvn)
10. Various Financial Ratios (Ratios)