·
This exercise 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”
MS 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 Week 1.)
·
It is recommended that students
construct their deliverable(s) using MS Word / MS Excel and then attach the
document(s) to the discussion thread submission area in Blackboard.
Use the “NAB
Company Portfolio” (see: Course Required Files in Week 1) for reference.
Provide the following information below.
1.
For year one of your NAB
company’s Business Plan, complete the Income Statement, Cash Flow Projections,
and Balance Sheet sections from the “Business Plan Financials” MS Excel
template (see: Course Required Files in Week 1). Note: Attach
the MS Excel worksheet to the discussion thread.
o
Hints: Your marketing costs should already be included
as you created your Marketing Budget in Week 4 and those will be filled in
automatically.
o
Hints: Use the figures you arrived at in the operations
and technology sections of your plan to help fill out your financial forms.
o
Hints: Work through the worksheets in order. The excel
worksheets will automatically enter the numbers into your Income Statement.
2.
Develop the following financial
sections of your NAB company’s Business Plan. Note: Attach
the MS Word document to the discussion thread.
a.
Sources and use of funds
b. Plan assumptions
c.
Break-even analysis
