FINANCIAL PLAN

This week's discussion is worth 70 points. Before completing this discussion post, review these resources:

• Textbook Chapter 16, “The Financials,” pages 289–332.
• Your business plan.

Also review the appropriate guidelines:

• Snack Food Company Guidelines [DOCX].
• Company of Your Choice Guidelines [DOCX].

This Week’s Discussion Post

For this week’s discussion, please respond to the following:

• Complete all worksheets in the Business Plan Financials Excel Template using your business plan and the appropriate set of guidelines for the company, whether it is a startup company of your choosing or based on the snack food company scenario. 
  • If you are working with the Snack Food Company, input the applicable numbers from the guidelines.
  • Completing all these worksheets will enable you to finalize the Income Statement, Cash Flow Projections, and Balance Sheet worksheets in the Business Plan Financials Excel Template.
• Attach the Business Plan Financials Excel Template to the discussion submission area and click Submit.
  • To do this, choose one of these options:
    • Click on the Browse the Computer button under the discussion area.
    • Select the Attachment option within the discussion window.
  • No additional text needed.

Post at least one substantive comment to another student's post.

Notes

• You have already completed the Setup and Marketing Budget worksheets in your Marketing Plan and Budget assignment.
  • Make any desired adjustments to these worksheets.

Note:  Post a brief description of your business (no more than 4 sentences). Specify your company name, what business you are in, and the specific product or service you plan to sell.

For this week discussion: 

1. Provide a brief overview of your business so to clarify your company name, what business you are in, and the specific product lines or service options you offer (a list of what you sell- your sources of revenue). 

2. Attach the entire completed Excel document. All worksheets must be completed using the guidelines provided (snack-food or company of choice).

Use the videos below to help you with completing the worksheets. This tutorial is also posted in the Course Info area or you can download it HERE.

Overview of the Excel document

How to complete the Setup worksheet

How to complete the Sales Projections worksheet

How to complete the Inventory worksheet

How to complete the inventory worksheet – with example

How to complete the Capital Ex worksheet

How to complete the Staff Budgeting worksheet

How to complete the Marketing Budget worksheet

How to complete the Professional Services worksheet

How to complete the Capital Investments worksheet

How to complete the Income Statement worksheet

How to complete the Cash Flow Statement worksheet

How to complete the Balance Sheet worksheet

How to complete the Break-even worksheet

Note: Many businesses selling a service will not sell a physical good with the service they provide. Therefore, they will not have cost of good sold (COGS) on the sales projections, so you can set that at zero. If your COGS is zero, the inventory worksheet will be blank (since you will not have inventory).