wk 7

his 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.

o If you are working with the Snack Food Company, input the applicable numbers from the guidelines. o 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. o 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. o 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.

o Make any desired adjustments to these worksheets. Note: Post a brief description of your business (no more than 3 sentences). Specify your company name, what business you are in, and the specific product or service you plan to sell.

To help you get started with Week 7 Discussion-review this! C O L L A P S E

Overall Rating:

 1

 2

 3

 4

 5

 1

 2

 3

 4

 5

For this week discussion: 1. Provide a brief overview of your business. Specify the 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)- no more than 3 sentences.

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.

Overview of the Excel document How to complete the Setup worksheet- start the business the month and year the quarter starts How to complete the Sales Projections worksheet - reach sales of over 1 million by the end of the second year How to complete the Inventory worksheet How to complete the inventory worksheet – with example - the inventory expense must equal the COGS every month and for every product line How to complete the Capital Ex worksheet How to complete the Staff Budgeting worksheet-you should have more managers and employees in the second year than the first as your business is growing. How to complete the Marketing Budget worksheet How to complete the Professional Services worksheet How to complete the Capital Investments worksheet- specify the funds you plan to raise from investors and the equity you plan to give in exchange for these funds. 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 Notes: 1. If you are not selling physical good with your service, you can set the Cost of Goods Sold at zero (on the Sales Projections worksheet). This also means your inventory worksheet will be blank. 2. The income statement and the cash-flow statement must be in the positive (no negative numbers). 3. Do not delete any columns, rows, or cells. If you want to change the number in a cell, just type over. If something does not apply to you, just leave it at zero, but do not delete the column or row, as this will cause the formulas to be deleted, and the document to have errors. If you have REF or VALUE errors showing, you must start over on a clean copy.