discussion

profileDuke2012@

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.

Notes: 

1. 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(s) or service (s) you plan to sell. Attach the completed Excel document before you submit. 

2. A substantive comment is at least 6 substantive sentences in length, sharing examples, your perspective, resources, your experience, making connections, and asking questions, etc. 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 worksheetstart 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 worksheetspecify 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 cop

    • 2 years ago
    • 10
    Answer(0)