This exercise is considered an academic writing exercise. Quality of response, grammar, and punctuation are considered in your overall grade.

Important Notes
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.
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.
Hints: Your marketing costs should already be included as you created your Marketing Budget in Week 4 and those will be filled in automatically.
Hints: Use the figures you arrived at in the operations and technology sections of your plan to help fill out your financial forms.
Hints: Work through the worksheets in order. The excel worksheets will automatically enter the numbers into your Income Statement.
Develop the following financial sections of your NAB company’s Business Plan. Note: Attach the MS Word document to the discussion thread.
Sources and use of funds
Plan assumptions
Break-even analysis
“For a more comprehensive and detailed Marketing Budget, purchase the Excel Marketing Budget Templates
from PlanningShop.”
Marketing Budget 2013
January February March April May June July August September October November December TOTAL
Professional Assistance
Marketing/PR Consultants $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $42,000
Advertising Agencies $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Social Media Specialists $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $72,000
SEO Specialist $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Graphic/Web Design $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $48,000
Brochures/Leaflets/Flyers $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Signs/Billboards $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $57,600
Merchandising Displays $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sampling/Premiums $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Media Advertising
Print (newspaper, etc.) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Television and Radio $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $24,000
Online $2,350 $2,350 $2,350 $2,350 $2,350 $2,350 $2,350 $2,350 $2,350 $2,350 $2,350 $2,350 $28,200
Other Media $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Phone Directories $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $8,400
Advertising Specialties $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $54,000
Direct Mail $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Website
Development/Programming $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $30,000
Maintenance and Hosting $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $24,000
Trade Shows
Fees and Setup $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $24,000
Travel/Shipping $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $4,800
Exhibits/Signs $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000
Public Relations/Materials $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Informal Marketing / Networking
Memberships/Meetings $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Entertainment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GRAND TOTAL COSTS $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $420,000