Docstoc

Strategic Planning Template with Excel

Document Sample
Strategic Planning Template with Excel Powered By Docstoc
					This is a comprehensive template that will help a company build a strategic plan for their
organization. This strategic plan template can provide the foundation and framework for
a business plan. The sections included in this guide are the elements of a strategic
business plan, the outline template, market analysis, annual income projection, break-
even worksheet, two Excel modules of projected cash flow and a balance sheet, and a
staffing projection worksheet. This template can be used by individuals that want to
open a small business and want to learn more about how to create an effective
business plan.
2010    STRATEGIC PLANNING TEMPLATE

       Fill-in-the-Blank Template that Will Walk You through
       Building a Strategic Plan for Your Organization.




                            |
             Strategic Planning Template
             Table of Contents




Introduction .................................................................................................................................... 2
Elements of a Strategic Business Plan ............................................................................................ 2
Instructions ..................................................................................................................................... 3
Outline Template ............................................................................................................................ 4
Strategic Business Plan Template ................................................................................................... 6
Appendix A: Market Analysis Worksheet .................................................................................... 10
Appendix B: Annual Income Projection Worksheet .................................................................... 11
Appendix C: Break-Even Worksheet ........................................................................................... 12
Appendix D: Projected Cash Flow Statement Template .............................................................. 13
Appendix E: Balance Sheet Template .......................................................................................... 14
Appendix F: Staffing Projection Worksheet ................................................................................. 15




© Copyright 2010 Docstoc Inc.                                                                                                      1
          Strategic Planning Template
          Fill-in-the-Blank Template that Will Walk You through Building a Strategic Plan for Your Organization




Introduction

In today’s economy, it is more important than ever before to create a strategic plan for your organization and to
follow that plan to success. This Strategic Plan Template seeks to simplify the process of building your Plan,
and will provide you with points that you may not previously have considered. A well-built Strategic Plan will
help your organization determine the direction it needs to take while keeping the goals, mission and vision of
the company in the forefront of its long-term goals.

Follow the instructions in each of the sections below, and complete them with as much relevant information as
you are able to obtain in order to build a comprehensive and useful tool that will provide you with insight on the
direction you should take to achieve maximum success and that will better position you to obtain the capital that
you may need to realize that success.

Involve the right people in your organization to assist in the planning process. Think about the people in your
organization who know the ins and outs of each of the elements listed below, and include them in the process of
building your Plan. Parse out the different sections so that the information you include comes directly from the
subject matter expert in that area. When you have your first draft put together, seek the input of the best writer
you have on your staff, even if it’s your assistant – you will want the Plan to be free from spelling,
typographical and grammatical errors, and every set of eyes that you can enlist to proofread can help avoid such
issues.

Finally, when the first draft is complete, put it away for a day or two before proofing it again. When developing
documents such as this, it is easy to become so close that you miss something. Giving yourself a couple of days
away from the project can help you to review it with fresh eyes and ideas the next time.

Elements of a Strategic Business Plan

        Executive Summary

       This should be just what its title implies – a summary. It should include relevant information related to
       the other sections of your Plan, providing highlights of what the reader can expect in the sections that
       follow. This is a critical component of your plan and must be written so as to be engaging and to
       provide incentive for the reader to want to dig deeper into your Plan and learn more about what your
       organization will be able to accomplish.

       Business Details



© Copyright 2010 Docstoc Inc.                                                             2
       This is where you begin to get into the nitty-gritty of your Plan, providing detailed specifics on the
       products or services you are offering. It is important to remember that not everyone knows as much
       about your business as you do, so you must write this section in a way that someone wholly unfamiliar
       with what you do can glean understanding from the information. That means that you should spell out
       or provide definitions of any technical terms that you use, and refrain from peppering this section with
       acronyms that those who do not share your level of expertise may not easily understand.

       Market Analysis

       Being able to lend this section substance is going to necessitate some prior research. When analyzing a
       potential market, there are three important considerations: (a) determination of the best market for the
       service or product you offer; (b) how price should be aligned with market conditions; and (c) the nature
       and extent of the competition for your product or service. You may choose to retain the services of a
       professional marketing agency to complete this research on your behalf, or you may opt to take the
       project on yourself. If you do elect to research the market conditions on your own, please see Appendix
       A for a worksheet that will help you get started. (You may further consider using the Competitor
       Analysis Worksheet available on this site.)

       Financing

       If you are seeking capital for your business, this section is going to be critical, and if you are not well-
       versed in accounting principles, you may wish to enlist the support of a certified public accountant.
       That being said, however, preparing your financials yourself can reward you with an extraordinarily
       intricate understanding of your business, and this alone can be reason enough to attempt to pull it
       together on your own. Attached as Appendices B through E are the following worksheets that can assist
       you with this task: (1) Appendix B: Annual Income Projection Worksheet; (2) Appendix C: Break-
       Even Worksheet; (3) Appendix D: Projected Cash Flow Statement; and (4) Appendix E: Balance
       Sheet.

       Management

       This section will demonstrate your structure – who your key players are and why they are the right
       people for their roles; the type of business entity you have structured your organization to be; and what
       your staffing is currently and how you anticipate that staffing will change as your business grows. This
       section provides you with an excellent opportunity to highlight the team you have built to carry out the
       organization’s mission. We have provided a Staffing Projection Worksheet to assist you at Appendix F.

Instructions

   1. Walk through the sections in the outline grid on the following page and fill in the pertinent information.

   2. Use the information you have completed in each section to complete the template that begins on page 8.




© Copyright 2010 Docstoc Inc.                                                           3
Outline Template

                                   EXECUTIVE SUMMARY
Considerations:
    Describe the nature of your business venture.
    What need do you plan to address or fill?
    Why do people need or want your product or service? (Include a brief description of
      your potential market.)
    How is your business organized?
    Describe your management team.
    Include a brief description of your sales and marketing approach.
    How much capital are you seeking?
    What are your calculated sales projections?
    How do you plan to repay a loan?
 Enter your information
                  here:




                                           BUSINESS
Considerations:
    Provide the legal name of your company or organization.
    Provide the physical address of your business headquarters, and list any satellite facilities.
    Describe the exact nature of your business avoiding terminology that is specific to your
      industry – spell it out for those who are not familiar with what you do.
    Describe the ways that your company will provide a better product or service to your
      proposed customers than your competition does or will.
 Enter your information
                   here:




                                     MARKET ANALYSIS
Considerations:
    Use the Marketing Plan you have developed in anticipation of preparing this Strategic
      Plan.
    What is the demand for your product or service?
    Describe in detail the proposed market.
    Detail the trends within the market.
    Provide details of how you intend to price your product.
    Provide details of how you intend to package your product.
    List your organization’s relevant policies, and provide a one or two sentence summary of
      each and which employees the policies apply to.
 Enter your information
                  here:


© Copyright 2010 Docstoc Inc.                                                          4
                                        FINANCING
Considerations:
    Provide information on your current financial backing, including how much of your own
      personal funds you have and are willing to contribute, and the source of your funding.
    Detail the amount of capital you need, and how you plan to repay your debt.
    Include appendices in the form of financial worksheets, or include the worksheets in this
      section. Worksheets should include annual income projections, break-even worksheet,
      projected cash flow statements, and a balance sheet. (Samples of these worksheets can be
      found in Appendices B through E hereto.)
 Enter your information
                   here:
                                      MANAGEMENT
Considerations:
    Describe in detail your organizational structure, and include an organizational chart.
    Provide biographical information on your management team and attach their CVs or
      resumes as appendices.
    Provide information that describes your legal structure, and consider including your
      Articles of Incorporation and Bylaws as an appendix to this section.
    Include a staffing projection worksheet.
 Enter your information
                   here:




© Copyright 2010 Docstoc Inc.                                                      5
                                                                  1.  Text in Gray font throughout
       Strategic Business Plan Template                              the form should be replaced
                                                                     with appropriate specific
 (Place on your company’s letterhead and delete this text box.)
                                                                     information, and the blanks and
                                                                     bracketed words deleted.
                                                                  2. Once complete, highlight all
                                                                     text in the document and change
                                                                     the font color to black.
                                                                  3. Delete this instructional text
                                                                     box.




                                       Strategic Business Plan


       Executive Summary


Mission Statement of ___[Company Name]: [Enter mission statement.]

Vision Statement of ___[Company Name]: [Enter vision statement.]

[Paragraph 1: Description of the business venture, the need you plan to fill and why that need exists; followed
by a brief overview of who wants to purchase your product or service. Include a very brief description of the
potential market.]

[Paragraph 2: Overview of the organizational structure of your business, and a very brief description of your
management team.]

[Paragraph 3: Brief description of your sales and marketing approach, the bottom line estimate of the amount of
capital you seek, and the bottom line of your sales projections. A very concise explanation of how loans are to
be repaid.]


     Details of Our Business

Legal Business Name (as registered): ___[Business Name]

Physical Street Address of Corporate Headquarters:

        ___[Street Address including Suite/Unit Numbers]
        ___[City, State, Zip]

Satellite Facilities are located at the following addresses:

        ___[Street Address including Suite/Unit Numbers]
        ___[City, State, Zip]

© Copyright 2010 Docstoc Inc.                                                         6
       [Add more as necessary.]

What We Do: [Paragraph: Description of the exact nature of your business avoiding terminology that is
specific to your industry – spell it out for those who are not familiar with what you do. Description of the
demand for your product or service.]

[Paragraph (one or more) that describes all the ways that you will be better suited to meet the needs of your
market in order to excel over the competition.]


    Market Considerations


Our Market: There are ___[Number of potential customers] potential customers in our market, who live
primarily in ___[urban or rural areas, or worldwide]. Our main target market consists of ___[men, women,
children, or all] who are between the ages of ___ and ___[age range of potential customers]. [Add any
additional information that provides an idea of your market.]

[Paragraph (one or more): describe the trends in the market – where it started, where it is now, and what it is
anticipated to be six months from now, a year from now, and long-term. Include an explanation of the demand
for your product in your market. Provide an explanation of how your company plans to capitalize on these
trends and meet the changing needs in the market place.]

How Our Product is Priced: [Paragraph (one or more): Detail the pricing of your product, and how you arrived
at the pricing structure. Compare your pricing with that of your competitors. Explain why the product or
service is priced appropriately based on the target market and the market conditions now and in relation to how
the conditions are anticipated to change in the future. Discuss how your company expects to address downturns
in the market or other unanticipated trends that are not currently apparent.]

How We Package Our Product: [Paragraph (one or more): Describe the packaging (whether tangible or, if for a
service, the presentation) of your product or service. Explain why the packaging sets you apart from your
competition, including reasons why it makes your product more convenient for your target market to use or
store than that of your competition. Detail where you obtain your packaging, and why it makes sense
financially to package the product in this manner. Lay out any plans for a change in packaging suppliers or
campaigns that you anticipate may affect the packaging in the future.]

Our Company Policies: [Summarize the reasons specific policies might be required in your industry – for
example, if your business is in healthcare or casino gambling, both highly-regulated industries, you will need to
let the reader know that you have the government-mandated policies in place and that they meet the minimum
regulatory requirements. Provide a contingency statement of how you expect to ensure that your policies are
kept current related to changing laws and requirements. Explain how your policies were developed (who
played a part in putting them together), and what your process is for development, approval, distribution to your
work force, and enforcement.]

[Provide a list of relevant policies, and attach them as Exhibits if it makes sense to do so for your industry.]

Financial Aspects of Our Business


© Copyright 2010 Docstoc Inc.                                                             7
Where Our Money Comes From: [Paragraph (one or more) that details the terms of your financial backing,
including the source of the funding. Include information on how much of your own money you have (or will)
invest into the business.]

Additional Capital Necessary: [Paragraph (one or more) that fully describes how much additional capital you
need, what it will be used for, and how you plan to repay it, referencing the Exhibits you will attach as a
component of your demonstration of solid financials. Explain in detail how funding will be applied to the
organization’s goals, including a description of who has fiduciary responsibility and how that responsibility will
be carried out.]

We have attached the following Exhibits in support of our financial position:

       Exhibit 1: Annual Income Projection

       Exhibit 2: Break-Even Analysis

       Exhibit 3: Projected Cash Flow Statements

       Exhibit 4: Balance Sheet


         Management


[Paragraph (one or more) that describes your organizational structure. Include an Exhibit that shows your
organizational chart.]

[Include one paragraph for each of the members of the top layer of your organization, providing an overview of
each one’s history, qualifications and why they are the best person for the job. Include Exhibits for the resumes
or curricula vitae for each. Explain how this core team works together to realize the organizational goals, and
how each strongly believes in the direction the company is planning to take.]

[Paragraph (one or more) that describes your bylaws and other underlying corporate governance structure.
Attach the bylaws and any other documentation that lends itself to such description as Exhibits.]

[Paragraph (one or more) that describes your current staffing and further details estimates of how staffing
requirements will change as the business grows. Attach an Exhibit that shows a current staffing matrix as well
as a Staffing Projection Worksheet.]

         Summary


[Paragraph (one or two – no more than two) that hits the highlights of the previous sections and offers a
conclusion as to why the business, overall, will be successful if the components of this Plan are followed, and if
the company stands ready to adjust to changing market conditions and priorities without such necessitating
additional capital.]

      List of Exhibits

© Copyright 2010 Docstoc Inc.                                                           8
Exhibit 1: Annual Income Projection

Exhibit 2: Break-Even Analysis

Exhibit 3: Projected Cash Flow Statements

Exhibit 4: Balance Sheet

Exhibit 5: Organizational Chart

Exhibit 5: Resumes / Curricula Vitae for Leadership

Exhibit 6: Bylaws

Exhibit 7: [Any other documentation supporting organizational structure.]




© Copyright 2010 Docstoc Inc.                                               9
Appendix A: Market Analysis Worksheet

Note that the worksheet here shows only the information that you should provide in your Strategic Business
Plan, and will not include much of the detailed information that will be a part of a complete market analysis
report. You should use the information from the more detailed report to complete the sections in the worksheet
below.

Describe your primary industry:




Size of Industry:
                      Historically:

                        Currently:

                        In 5 years:

                       In 10 years:

Industry Characteristics and Trends:
                      Historically:

                        Currently:

                     In the future:

Major Customer Groups:
                         Business:

                     Government:

                       Consumers:




© Copyright 2010 Docstoc Inc.                                                        10
Appendix B: Annual Income Projection Worksheet



Year: __________________________

      Month                Sales   Other Income   Cost of Goods   Operating Expenses
January
February
March
April
May
June
July
August
September
October
November
December
         Totals:
       Averages:




© Copyright 2010 Docstoc Inc.                                           11
Appendix C: Break-Even Worksheet



                         Instructions / Information                                        Figures
                                                                                 FIXED COSTS:
Enter fixed costs (rent, interest on debt, insurance, plant and equipment
expenses, business licenses, salary of permanent full-time employees, etc.):
Enter variable costs (cost of goods sold, sales commissions, shipping and        VARIABLE COSTS:
delivery charges, costs of direct materials and supplies, wages for part-time
or temporary employees, etc.):
                                                                                 COST PER UNIT:
Calculate cost-per-unit (add up variable costs and divide by units sold):

                                                                                 CONTRIBUTION MARGIN:
Calculate break-even point using the following formula:
     Sales price per unit minus variable costs per unit = contribution margin.
                                                                                 CONTRIBUTION MARGIN
   Contribution margin divided by sales price per unit = contribution margin     RATIO:
                                                                       ratio.

                                                                                 BREAKEVEN SALES VOLUME:
Fixed costs divided by contribution margin ratio = Breakeven Sales Volume.




© Copyright 2010 Docstoc Inc.                                                                        12
Appendix D: Projected Cash Flow Statement Template - (This is an Excel File – Double Click or Right
click to Open & Edit)

                                                         Small Business Cash Flow Projection
                                                                 <Company Name>
Starting date
Cash balance alert minimum                          0        0        0        0        0        0            0        0

                                     Beginning Jan-00   Feb-00   Mar-00   Apr-00   May-00   Jun-00   Jul-00       Aug-00
Cash on hand (beginning of
month)                                              0        0        0        0        0        0            0        0

CASH RECEIPTS
Cash sales
Returns and allowances
Collections on accounts receivable
Interest, other income
Loan proceeds
Owner contributions
TOTAL CASH RECEIPTS                                 0        0        0        0        0        0            0        0
Total cash available                         0      0        0        0        0        0        0            0        0

CASH PAID OUT
Advertising
Commissions and fees
Contract labor
Employee benefit programs
Insurance (other than health)
Interest expense
Materials and supplies (in COGS)
Meals and entertainment
Mortgage interest
Office expense
Other interest expense
Pension and profit-sharing plan
Purchases for resale
Rent or lease
Rent or lease: vehicles, equipment
Repairs and maintenance
Supplies (not in COGS)
Taxes and licenses
Travel
Utilities
Wages (less emp. credits)
Other expenses
Other expenses
Other expenses
Miscellaneous
SUBTOTAL                                            0        0        0        0        0        0            0        0
Loan principal payment
Capital purchases
Other startup costs
To reserve and/or escrow
Owners' withdrawal
TOTAL CASH PAID OUT                                 0        0        0        0        0        0            0        0
Cash on hand (end of month)                  0      0        0        0        0        0        0            0        0

OTHER OPERATING DATA
Sales volume (dollars)
Accounts receivable balance
Bad debt balance



© Copyright 2010 Docstoc Inc.                                                               13
Appendix E: Balance Sheet Template - (This is an Excel File – Double Click or Right click to Open &
Edit)


Balance Sheet

                ASSETS                                           LIABILITIES
Current Assets                                      Current Liabilities
Cash                                                Accounts payable
Accounts receivable                                 Short-term notes
 (less doubtful accounts)                           Current portion of long-term notes
Inventory                                           Interest payable
Temporary investment                                Taxes payable
Prepaid expenses                                    Accrued payroll

 Total Current Assets                     $0         Total Current Liabilities                $0


Fixed Assets                                        Long-term Liabilities
Long-term investments                               Mortgage
Land                                                Other long-term liabilities
Buildings                                            Total Long-Term Liabilities              $0
 (less accumulated depreciation)
Plant and equipment                                 Total Liabilities                         $0
 (less accumulated depreciation)
Furniture and fixtures                                   SHAREHOLDERS' EQUITY
 (less accumulated depreciation)                    Capital stock
 Total Net Fixed Assets                   $0        Retained earnings
                                                     Total Shareholders' Equity               $0



TOTAL ASSETS                              $0        TOTAL LIABILITIES & EQUITY                $0

Balance Sheet Check                      OK

              RATIOS
Current Ratio                            0.00
Quick Ratio                              0.00
Cash Ratio                               0.00
Working Capital                            $0




© Copyright 2010 Docstoc Inc.                                                            14
Appendix F: Staffing Projection Worksheet




                                                               Number of
                                                                           Estimated Start
    Role            Project Responsibility                       Staff                       Duration Required
                                             Skills Required                    Date
                                                               Required




© Copyright 2010 Docstoc Inc.                                                    15

				
DOCUMENT INFO
Description: This is a comprehensive template that will help a company build a strategic plan for their organization. This strategic plan template can provide the foundation and framework for a business plan. The sections included in this guide are the elements of a strategic business plan, the outline template, market analysis, annual income projection, break-even worksheet, two Excel modules of projected cash flow and a balance sheet, and a staffing projection worksheet. This template can be used by individuals that want to open a small business and want to learn more about how to create an effective business plan.
This document is also part of a package Top Marketing and Branding Tools 9 Documents Included