This week’s discussion is worth 70 points. Before completing this discussion post, review these resources:
Textbook Chapter 16, The Financials, pages 289332.
Your business plan.
Also review the appropriate guidelines:
Snack Food Company Guidelines [DOCX].
Company of Your Choice Guidelines [DOCX].
This Weeks Discussion Post
For this weeks 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 yourcompany 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 itHERE.
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).
