For this exercise, you will consider your company’s financials, such as Income Statement, Cash Flow Projections, Balance Sheets.
1. Using your NAB Company Portfolio and the first year of your business plan for the company, complete the Income Statement, Cash Flow Projections, and Balance Sheet sections from the “Business Plan Financials” spreadsheet. (These files are found under the “Course Information” tab). Attach the completed Excel worksheet to the discussion thread.
*Remember to include your marketing costs from the Marketing Plan you
completed in Week 6.
*Use the figures you arrived at in the operations and technology sections
of your plan to help fill out your financial forms.
*Go through the worksheets in order. The Excel worksheets will
automatically enter the numbers into your Income Statement as you
enter them.
2. Develop the following financial sections of your NAB company’s Business
Plan. Attach the completed Word document to the discussion thread.
*Sources and use of funds
*Plan assumptions
*Break-even analysis
3. Provide constructive feedback to at least one (1) other classmate’s post.
Important Notes
- This is considered an academic writing exercise. Quality of response, grammar, and punctuation are considered in your overall grade.
- This exercise does not require the use of APA format or a cover page.
- This exercise uses the “Business Plan Financials” Excel template. Use the “Business Plan Financials Guide” to assist you in completing the required worksheets. (Both documents are also available in the Course Required Files in the course Student Center.)
- It is recommended that students construct their plan using Microsoft Word and Microsoft Excel and then attach the documents to the discussion thread submission area in Blackboard.
