Excel template business plan financials
Excel template business plan financials
This article provides details of Excel template business plan financials that you can download now.
The financial plan, or "financial forecast", or even "financial business plan", is an encrypted document presenting various tables which highlight business assumptions. The financial plan is supposed to show the general balance expected for the activity (viability, profitability), and the relevance of the commercial and financial assumptions used.
Any business plan involves the development of a financial plan. The forecast financial plan is an element of the business plan or "business plan".
It is particularly important in the event of search for aid or financing since it will be analyzed by the potential financiers and in particular the bankers.
Making a financial plan is a major step in your business creation!
Microsoft Excel software under a Windows environment is required to use this template
These Excel template business plan financials work on all versions of Excel since 2007.
Examples of a ready-to-use spreadsheet: Download this table in Excel (.xls) format, and complete it with your specific information.
To be able to use these models correctly, you must first activate the macros at startup.
The file to download presents five Excel template business plan financials
Creating Your Business Plan
The business plan consists of a narrative and several financial worksheets. Work through the sections in any order that you like, except for the Executive Summary, which should be done last. Skip any questions that do not apply to your type of business.
This plan is designed for the Microenterprise: a business of fewer than 5 employees. Depending on the level of funding requested, the narrative portion of these plans usually run 8-12 pages, plus printouts of the Excel financial sheets and Appendix items. Aim to write clear and concise. Avoid jargon or fluff. Follow the rule, “Don’t tell me, show me” using facts and realistic examples to explain and justify.
The real value of creating a business plan is not in having the finished product in hand; rather, the value lies in the process of researching and thinking about your business. The act of planning helps you to think things through. It takes time now, but avoids costly, perhaps disastrous, mistakes later. Many businesses fail for lack of proper planning. We do not want that to happen to you!
Fortunately, there are a number of helpful resources for small businesses in Spokane. One of them, SNAP’s Microenterprise Program, is specially geared towards low and moderate income entrepreneurs. We provide free business planning classes, personal technical assistance and low cost microloan funding. To determine eligibility, call SNAP at 456-7174.
Executive Summary (1 page)
Write this section last. Include everything that you would cover in a five-minute interview. Make it enthusiastic, professional, complete, and concise.
Explain the basics of your business: What will your product be? Who will your customers be? Who are the owners? What do you think the future holds for your business and your industry?
If applying for a loan, state how much you want, precisely how you are going to use it, and how the money will make your business more profitable.
What business will you be in? What will you do? Briefly, who are your target customers? State your business hours and location.
What is the legal form of ownership: Sole proprietor, Partnership, Corporation, Limited liability corporation (LLC)? Why have you selected this form?
Who are the major owners of the firm? Briefly summarize their qualifications.
Company Goals: Where do you see your business in the first year, in 3-5 years?
Business Philosophy: What is important to you in business? What factors will make the company succeed?
Management and Operations (1-2 pages)
State your company’s name, legal form and ownership: “ABC company will be a sole proprietorship owned solely by Jane Success.”
Provide a brief overview of the owner(s) qualifications for this business. Attach a resume for each owner to the Appendix.
Who will do what functions? If it’s just you, state that you will perform all needed functions: buying, marketing, bookkeeping, customers, inventory, maintenance, etc.
Will you have employees? What will their role be? What qualifications do they need? What will you pay them? Training requirements?
Will you use outside professionals or family members to help? Indicate any Accountants, bookkeepers, attorneys, etc. State family member’s role in your business.
Does your business require any special licensing, bonding or regulations? Is your retail or production location zoned properly? What insurance do you have?
Identify any key suppliers. Do you have back-up suppliers?
What do you know about the industry you’re in? Is it growing? How is it changing? What is the industry/market like where you plan to operate your business?
Describe the “primary target market” for your business. This is your most important type of customer. What are their characteristics (age, gender, income, etc), where are they located? What other “secondary market groups” will you target?
If you are selling wholesale, describe your wholesale customer as well as the consumer who will purchase your product.
List three major direct competitors (those that do exactly what you do).
Will they compete with you across the board, or just for certain products, certain customers, or in certain locations?
What are their advantages over you? How will you deal with these?
What are their weaknesses? How will you take advantage of these?
What niche are you filling the market? (Don’t try to be all things to all customers!)
Describe your major services and/or products. Do you need to categorize your products? The work you do may involve a wide variation of price and time (like plumbing or auto repair), or you may create products that vary a lot (such as craft or artwork). If so, see if you can subtitle your categories and give examples of each.
Include the most important features and benefits.
What special services will you provide? Some examples are delivery, support, follow-up, and refund policy.
How will you get your products to your customer? Are you selling directly to them? Selling wholesale? If so, describe the type of wholesaler. Will you sell on the web?
How will you get the word out to customers? (Include any print advertising: trade shows, a website, brochures, business cards, direct mail, other media, etc.) Itemize all costs and include relevant dates, ad sizes, etc.
What low/no-cost ideas do you have for promoting your business? Examples include: word of mouth (how will you stimulate it?), friends, professionals, guest speaking, workshops, volunteering among your target market, etc.
How will you stay in touch with those who buy from you? E-mail list, direct mail, etc.
You will need to include a promotion/advertising budget for your financials.
How did you decide on your prices? Does your pricing fit your market? How do your prices compare to your competitors?
List your products and prices. For products, include what it actually costs you to make that product (cost of goods). Don’t include your labor. Use a table format if it helps.
For services, list your hourly rate. If you have parts, what is your cost and/or what is your average % mark-up?
If your pricing varies, create an “average price” for each category, or type of service/product. For example: Children’s dresses average $25, average Gold Level auto paint job: $400., average Re-plumbing of basement: $1,000. You will need these averages for your financials.
Where are you running your business? From home? An office, or store? If you do not have a location picked out yet, describe what you are looking for.
If you are working from home, describe briefly how you plan to organize your space to separate out work and home spaces.
If you have a retail location, discuss the value to your customers: Parking, Interior spaces, convenient access, etc. Is this location consistent with your target customer?
Where is the competition located? Is it better for you to be near them (like car dealers or fast food restaurants) or distant (like convenience food stores)?
What regulations, zoning, food handling or other requirements exist?
All businesses, whether start-up or growing, will be required to supply financial data. If you are an established business, you will be required to supply historical data related to your company’s performance. Most creditors require financial data for the past three years, including tax returns.
Your Personal Financial Picture (Optional)
Like children, businesses take time, money and lots of attention to grow. There are often few returns the first year or two.
Is your current income meeting your personal financial expenses? How do you plan to pay for your business expenses before the business earns a profit? What do you want to draw from the business each month?
What is your personal debt situation? Are you paying back any debt under your current personal income? Attach a credit report to the Appendix. Describe the story behind any significant financial problems that may show up on your report.
What are the greatest risks you are taking in starting/running your own business? What would happen if you could no longer do so?
In putting together your financial projections, you will need to make some assumptions about your sales, expenses, operations, etc. Be conservative. You can always do better, but you want to show a realistic business scenario. Make sure your projections match your funding requests.
New businesses will be required to provide monthly projected income statements, balance sheets, and cash flow statements for at least two years.
Be consistent throughout your business plan. If you have made assumptions in your projections, be sure to summarize what you have assumed. Do not leave the reader of your business plan guessing about what you are trying to tell them.
List your average sale and cost of goods for each product or category as covered in the pricing section.
Assume when you will start the business.
State other assumptions (eg. % of sales will be parts, product mark-ups, employees, free services, etc.)
Use the following example to state monthly sales assumptions:
I will average ___ number of sales of Product Y
Product Y sales will increase by ___ per month.
Product Y sales will increase by ___ per month, with an additional __ over the (season).
Startup Expenses and Sources of Capital
Estimate your start-up expenses as best you can. New businesses have a way of costing more than anticipated, include a separate “Contingencies” category equal to 20% of all other total start-up expenses.
List sources of savings and cash you will have to help finance your business.
Use of Funds and Collateral
If you are planning to take out a loan, list all those items from your business plan that you will need funding for. Be specific as to the source, cost and quantity. Use a table format. Include any extensive inventory lists in the Appendix, if necessary.
List any collateral you will use to secure your loan. (eg. Car, house, equipment, etc.)
Cash Flow, Income Statement and Balance Sheet
Business Plan Appendix
These are some frequently requested items to include with your business plan:
- Personal list of liabilities and assets.
- Credit report
- Business license (Washington State, City)
- Quote from insurance company, or current insurance coverage.
- Any detailed inventory list as part of loan request.
- Letter from seller of loan items: car, equipment, etc. stating price, VIN, etc.
- Written bids or estimates on any major loan item, such as equipment.
- Copies of leases or contracts.
- List of assets available as collateral for a loan
- Letters of support from future customers, strategic partners, etc.
- Marketing materials
- Maps and photos of location
- Product photos
- Other support materials needed