financial projections model for business plans

Confirm opening of the external link

Financial projections use existing or estimated financial data to forecast your business’s future income and expenses. They often include different scenarios to see how changes to one aspect of your finances (such as higher sales or lower operating expenses) might affect your profitability.

If you need to create financial projections for a startup or existing business, this free, downloadable template includes all the necessary tools.

What Are Financial Projections Used for?

Financial projections are an essential business planning tool for several reasons.

• If you’re starting a business, financial projections help you plan your startup budget, assess when you expect the business to become profitable, and set benchmarks for achieving financial goals.
• If you’re already in business, creating financial projections each year can help you set goals and stay on track.
• When seeking outside financing, startups and existing businesses need financial projections to convince lenders and investors of the business’s growth potential.

What’s Included in Financial Projections?

This financial projections template pulls together several different financial documents, including:

• Startup expenses
• Payroll costs
• Sales forecast
• Operating expenses for the first 3 years of business
• Cash flow statements for the first 3 years of business
• Income statements for the first 3 years of business
• Balance sheet
• Break-even analysis
• Financial ratios
• Cost of goods sold (COGS), and
• Amortization and depreciation for your business.

You can use this template to create the documents from scratch or pull in information from those you’ve already made. The template also includes diagnostic tools to test the numbers in your financial projections and ensure they are within reasonable ranges.

These areas are closely related, so as you work on your financial projections, you’ll find that changes to one element affect the others. You may want to include a best-case and worst-case scenario for all possibilities. Make sure you know the assumptions behind your financial projections and can explain them to others.

Startup business owners often wonder how to create financial projections for a business that doesn’t exist yet. Financial forecasts are continually educated guesses. To make yours as accurate as possible, do your homework and get help. Use the information you unearthed in researching your business plans, such as statistics from industry associations, data from government sources, and financials from similar businesses. An accountant with experience in your industry can help fine-tune your financial projections. So can business advisors such as SCORE mentors.

Once you complete your financial projections, don’t put them away and forget about them. Compare your projections to your financial statements regularly to see how well your business meets your expectations. If your projections turn out to be too optimistic or too pessimistic, make the necessary adjustments to make them more accurate.

*NOTE: The cells with formulas in this workbook are locked. If changes are needed, the unlock code is "1234." Please use caution when unlocking the spreadsheets. If you want to change a formula, we strongly recommend saving a copy of this spreadsheet under a different name before doing so. 

We recommend downloading the Financial Projections template in English or Spanish.

Do you need help creating your financial projections? Take SCORE’s online course on-demand on financial projections or connect with a SCORE mentor  online or in your community today.

Simple Steps for Starting Your Business: Financial Projections In this online module, you'll learn the importance of financial planning, how to build your financial model, how to understand financial statements and more.

Business Planning & Financial Statements Template Gallery Download SCORE’s templates to help you plan for a new business startup or grow your existing business.

Why Projected Financial Statements Are Essential to the Future Success of Startups Financial statements are vital to the success of any company but particularly start-ups. SCORE mentor Sarah Hadjhamou shares why they are a big part of growing your start-up.

Copyright © 2024 SCORE Association, SCORE.org

Funded, in part, through a Cooperative Agreement with the U.S. Small Business Administration. All opinions, and/or recommendations expressed herein are those of the author(s) and do not necessarily reflect the views of the SBA.

Free Financial Templates for a Business Plan

By Andy Marker | July 29, 2020

• Share on Facebook
• Share on LinkedIn

Link copied

In this article, we’ve rounded up expert-tested financial templates for your business plan, all of which are free to download in Excel, Google Sheets, and PDF formats.

Included on this page, you’ll find the essential financial statement templates, including income statement templates , cash flow statement templates , and balance sheet templates . Plus, we cover the key elements of the financial section of a business plan .

Financial Plan Templates

Download and prepare these financial plan templates to include in your business plan. Use historical data and future projections to produce an overview of the financial health of your organization to support your business plan and gain buy-in from stakeholders

Business Financial Plan Template

Use this financial plan template to organize and prepare the financial section of your business plan. This customizable template has room to provide a financial overview, any important assumptions, key financial indicators and ratios, a break-even analysis, and pro forma financial statements to share key financial data with potential investors.

Download Financial Plan Template

Word | PDF | Smartsheet

Financial Plan Projections Template for Startups

This financial plan projections template comes as a set of pro forma templates designed to help startups. The template set includes a 12-month profit and loss statement, a balance sheet, and a cash flow statement for you to detail the current and projected financial position of a business.

‌ Download Startup Financial Projections Template

Excel | Smartsheet

Income Statement Templates for Business Plan

Also called profit and loss statements , these income statement templates will empower you to make critical business decisions by providing insight into your company, as well as illustrating the projected profitability associated with business activities. The numbers prepared in your income statement directly influence the cash flow and balance sheet forecasts.

Pro Forma Income Statement/Profit and Loss Sample

Use this pro forma income statement template to project income and expenses over a three-year time period. Pro forma income statements consider historical or market analysis data to calculate the estimated sales, cost of sales, profits, and more.

‌ Download Pro Forma Income Statement Sample - Excel

Small Business Profit and Loss Statement

Small businesses can use this simple profit and loss statement template to project income and expenses for a specific time period. Enter expected income, cost of goods sold, and business expenses, and the built-in formulas will automatically calculate the net income.

‌ Download Small Business Profit and Loss Template - Excel

3-Year Income Statement Template

Use this income statement template to calculate and assess the profit and loss generated by your business over three years. This template provides room to enter revenue and expenses associated with operating your business and allows you to track performance over time.

Download 3-Year Income Statement Template

For additional resources, including how to use profit and loss statements, visit “ Download Free Profit and Loss Templates .”

Cash Flow Statement Templates for Business Plan

Use these free cash flow statement templates to convey how efficiently your company manages the inflow and outflow of money. Use a cash flow statement to analyze the availability of liquid assets and your company’s ability to grow and sustain itself long term.

Simple Cash Flow Template

Use this basic cash flow template to compare your business cash flows against different time periods. Enter the beginning balance of cash on hand, and then detail itemized cash receipts, payments, costs of goods sold, and expenses. Once you enter those values, the built-in formulas will calculate total cash payments, net cash change, and the month ending cash position.

Download Simple Cash Flow Template

12-Month Cash Flow Forecast Template

Use this cash flow forecast template, also called a pro forma cash flow template, to track and compare expected and actual cash flow outcomes on a monthly and yearly basis. Enter the cash on hand at the beginning of each month, and then add the cash receipts (from customers, issuance of stock, and other operations). Finally, add the cash paid out (purchases made, wage expenses, and other cash outflow). Once you enter those values, the built-in formulas will calculate your cash position for each month with.

‌ Download 12-Month Cash Flow Forecast

3-Year Cash Flow Statement Template Set

Use this cash flow statement template set to analyze the amount of cash your company has compared to its expenses and liabilities. This template set contains a tab to create a monthly cash flow statement, a yearly cash flow statement, and a three-year cash flow statement to track cash flow for the operating, investing, and financing activities of your business.

Download 3-Year Cash Flow Statement Template

For additional information on managing your cash flow, including how to create a cash flow forecast, visit “ Free Cash Flow Statement Templates .”

Balance Sheet Templates for a Business Plan

Use these free balance sheet templates to convey the financial position of your business during a specific time period to potential investors and stakeholders.

Small Business Pro Forma Balance Sheet

Small businesses can use this pro forma balance sheet template to project account balances for assets, liabilities, and equity for a designated period. Established businesses can use this template (and its built-in formulas) to calculate key financial ratios, including working capital.

Download Pro Forma Balance Sheet Template

Monthly and Quarterly Balance Sheet Template

Use this balance sheet template to evaluate your company’s financial health on a monthly, quarterly, and annual basis. You can also use this template to project your financial position for a specified time in the future. Once you complete the balance sheet, you can compare and analyze your assets, liabilities, and equity on a quarter-over-quarter or year-over-year basis.

Download Monthly/Quarterly Balance Sheet Template - Excel

Yearly Balance Sheet Template

Use this balance sheet template to compare your company’s short and long-term assets, liabilities, and equity year-over-year. This template also provides calculations for common financial ratios with built-in formulas, so you can use it to evaluate account balances annually.

Download Yearly Balance Sheet Template - Excel

For more downloadable resources for a wide range of organizations, visit “ Free Balance Sheet Templates .”

Sales Forecast Templates for Business Plan

Sales projections are a fundamental part of a business plan, and should support all other components of your plan, including your market analysis, product offerings, and marketing plan . Use these sales forecast templates to estimate future sales, and ensure the numbers align with the sales numbers provided in your income statement.

Basic Sales Forecast Sample Template

Use this basic forecast template to project the sales of a specific product. Gather historical and industry sales data to generate monthly and yearly estimates of the number of units sold and the price per unit. Then, the pre-built formulas will calculate percentages automatically. You’ll also find details about which months provide the highest sales percentage, and the percentage change in sales month-over-month. 

Download Basic Sales Forecast Sample Template

12-Month Sales Forecast Template for Multiple Products

Use this sales forecast template to project the future sales of a business across multiple products or services over the course of a year. Enter your estimated monthly sales, and the built-in formulas will calculate annual totals. There is also space to record and track year-over-year sales, so you can pinpoint sales trends.

Download 12-Month Sales Forecasting Template for Multiple Products

3-Year Sales Forecast Template for Multiple Products

Use this sales forecast template to estimate the monthly and yearly sales for multiple products over a three-year period. Enter the monthly units sold, unit costs, and unit price. Once you enter those values, built-in formulas will automatically calculate revenue, margin per unit, and gross profit. This template also provides bar charts and line graphs to visually display sales and gross profit year over year.

Download 3-Year Sales Forecast Template - Excel

For a wider selection of resources to project your sales, visit “ Free Sales Forecasting Templates .”

Break-Even Analysis Template for Business Plan

A break-even analysis will help you ascertain the point at which a business, product, or service will become profitable. This analysis uses a calculation to pinpoint the number of service or unit sales you need to make to cover costs and make a profit.

Break-Even Analysis Template

Use this break-even analysis template to calculate the number of sales needed to become profitable. Enter the product's selling price at the top of the template, and then add the fixed and variable costs. Once you enter those values, the built-in formulas will calculate the total variable cost, the contribution margin, and break-even units and sales values.

Download Break-Even Analysis Template

For additional resources, visit, “ Free Financial Planning Templates .”

Business Budget Templates for Business Plan

These business budget templates will help you track costs (e.g., fixed and variable) and expenses (e.g., one-time and recurring) associated with starting and running a business. Having a detailed budget enables you to make sound strategic decisions, and should align with the expense values listed on your income statement.

Startup Budget Template

Use this startup budget template to track estimated and actual costs and expenses for various business categories, including administrative, marketing, labor, and other office costs. There is also room to provide funding estimates from investors, banks, and other sources to get a detailed view of the resources you need to start and operate your business.

Download Startup Budget Template

Small Business Budget Template

This business budget template is ideal for small businesses that want to record estimated revenue and expenditures on a monthly and yearly basis. This customizable template comes with a tab to list income, expenses, and a cash flow recording to track cash transactions and balances.

Download Small Business Budget Template

Professional Business Budget Template

Established organizations will appreciate this customizable business budget template, which  contains a separate tab to track projected business expenses, actual business expenses, variances, and an expense analysis. Once you enter projected and actual expenses, the built-in formulas will automatically calculate expense variances and populate the included visual charts. 

‌ Download Professional Business Budget Template

For additional resources to plan and track your business costs and expenses, visit “ Free Business Budget Templates for Any Company .”

Other Financial Templates for Business Plan

In this section, you’ll find additional financial templates that you may want to include as part of your larger business plan.

Startup Funding Requirements Template

This simple startup funding requirements template is useful for startups and small businesses that require funding to get business off the ground. The numbers generated in this template should align with those in your financial projections, and should detail the allocation of acquired capital to various startup expenses.

Download Startup Funding Requirements Template - Excel

Personnel Plan Template

Use this customizable personnel plan template to map out the current and future staff needed to get — and keep — the business running. This information belongs in the personnel section of a business plan, and details the job title, amount of pay, and hiring timeline for each position. This template calculates the monthly and yearly expenses associated with each role using built-in formulas. Additionally, you can add an organizational chart to provide a visual overview of the company’s structure. 

Download Personnel Plan Template - Excel

Elements of the Financial Section of a Business Plan

Whether your organization is a startup, a small business, or an enterprise, the financial plan is the cornerstone of any business plan. The financial section should demonstrate the feasibility and profitability of your idea and should support all other aspects of the business plan. 

Below, you’ll find a quick overview of the components of a solid financial plan.

• Financial Overview: This section provides a brief summary of the financial section, and includes key takeaways of the financial statements. If you prefer, you can also add a brief description of each statement in the respective statement’s section.
• Key Assumptions: This component details the basis for your financial projections, including tax and interest rates, economic climate, and other critical, underlying factors.
• Break-Even Analysis: This calculation helps establish the selling price of a product or service, and determines when a product or service should become profitable.
• Pro Forma Income Statement: Also known as a profit and loss statement, this section details the sales, cost of sales, profitability, and other vital financial information to stakeholders.
• Pro Forma Cash Flow Statement: This area outlines the projected cash inflows and outflows the business expects to generate from operating, financing, and investing activities during a specific timeframe.
• Pro Forma Balance Sheet: This document conveys how your business plans to manage assets, including receivables and inventory.
• Key Financial Indicators and Ratios: In this section, highlight key financial indicators and ratios extracted from financial statements that bankers, analysts, and investors can use to evaluate the financial health and position of your business.

Need help putting together the rest of your business plan? Check out our free simple business plan templates to get started. You can learn how to write a successful simple business plan  here . 

Visit this  free non-profit business plan template roundup  or download a  fill-in-the-blank business plan template  to make things easy. If you are looking for a business plan template by file type, visit our pages dedicated specifically to  Microsoft Excel ,  Microsoft Word , and  Adobe PDF  business plan templates. Read our articles offering  startup business plan templates  or  free 30-60-90-day business plan templates  to find more tailored options.

Discover a Better Way to Manage Business Plan Financials and Finance Operations

Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change. 

The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed. 

When teams have clarity into the work getting done, there’s no telling how much more they can accomplish in the same amount of time.  Try Smartsheet for free, today.

Discover why over 90% of Fortune 100 companies trust Smartsheet to get work done.

• Business Planning

Business Plan Financial Projections

Written by Dave Lavinsky

Financial projections are forecasted analyses of your business’ future that include income statements, balance sheets and cash flow statements. We have found them to be an crucial part of your business plan for the following reasons:

• They can help prove or disprove the viability of your business idea. For example, if your initial projections show your company will never make a sizable profit, your venture might not be feasible. Or, in such a case, you might figure out ways to raise prices, enter new markets, or streamline operations to make it profitable. 
• Financial projections give investors and lenders an idea of how well your business is likely to do in the future. They can give lenders the confidence that you’ll be able to comfortably repay their loan with interest. And for equity investors, your projections can give them faith that you’ll earn them a solid return on investment. In both cases, your projections can help you secure the funding you need to launch or grow your business.
• Financial projections help you track your progress over time and ensure your business is on track to meet its goals. For example, if your financial projections show you should generate $500,000 in sales during the year, but you are not on track to accomplish that, you’ll know you need to take corrective action to achieve your goal.

Below you’ll learn more about the key components of financial projections and how to complete and include them in your business plan.

What Are Business Plan Financial Projections?

Financial projections are an estimate of your company’s future financial performance through financial forecasting. They are typically used by businesses to secure funding, but can also be useful for internal decision-making and planning purposes. There are three main financial statements that you will need to include in your business plan financial projections:

1. Income Statement Projection

The income statement projection is a forecast of your company’s future revenues and expenses. It should include line items for each type of income and expense, as well as a total at the end.

There are a few key items you will need to include in your projection:

• Revenue: Your revenue projection should break down your expected sales by product or service, as well as by month. It is important to be realistic in your projections, so make sure to account for any seasonal variations in your business.
• Expenses: Your expense projection should include a breakdown of your expected costs by category, such as marketing, salaries, and rent. Again, it is important to be realistic in your estimates.
• Net Income: The net income projection is the difference between your revenue and expenses. This number tells you how much profit your company is expected to make.

Sample Income Statement

2. cash flow statement & projection.

The cash flow statement and projection are a forecast of your company’s future cash inflows and outflows. It is important to include a cash flow projection in your business plan, as it will give investors and lenders an idea of your company’s ability to generate cash.

There are a few key items you will need to include in your cash flow projection:

• The cash flow statement shows a breakdown of your expected cash inflows and outflows by month. It is important to be realistic in your projections, so make sure to account for any seasonal variations in your business.
• Cash inflows should include items such as sales revenue, interest income, and capital gains. Cash outflows should include items such as salaries, rent, and marketing expenses.
• It is important to track your company’s cash flow over time to ensure that it is healthy. A healthy cash flow is necessary for a successful business.

Sample Cash Flow Statements

3. balance sheet projection.

The balance sheet projection is a forecast of your company’s future financial position. It should include line items for each type of asset and liability, as well as a total at the end.

A projection should include a breakdown of your company’s assets and liabilities by category. It is important to be realistic in your projections, so make sure to account for any seasonal variations in your business.

It is important to track your company’s financial position over time to ensure that it is healthy. A healthy balance is necessary for a successful business.

Sample Balance Sheet

How to create financial projections.

Creating financial projections for your business plan can be a daunting task, but it’s important to put together accurate and realistic financial projections in order to give your business the best chance for success.  

Cost Assumptions

When you create financial projections, it is important to be realistic about the costs your business will incur, using historical financial data can help with this. You will need to make assumptions about the cost of goods sold, operational costs, and capital expenditures.

It is important to track your company’s expenses over time to ensure that it is staying within its budget. A healthy bottom line is necessary for a successful business.

Capital Expenditures, Funding, Tax, and Balance Sheet Items

You will also need to make assumptions about capital expenditures, funding, tax, and balance sheet items. These assumptions will help you to create a realistic financial picture of your business.

Capital Expenditures

When projecting your company’s capital expenditures, you will need to make a number of assumptions about the type of equipment or property your business will purchase. You will also need to estimate the cost of the purchase.

When projecting your company’s funding needs, you will need to make a number of assumptions about where the money will come from. This might include assumptions about bank loans, venture capital, or angel investors.

When projecting your company’s tax liability, you will need to make a number of assumptions about the tax rates that will apply to your business. You will also need to estimate the amount of taxes your company will owe.

Balance Sheet Items

When projecting your company’s balance, you will need to make a number of assumptions about the type and amount of debt your business will have. You will also need to estimate the value of your company’s assets and liabilities.

Financial Projection Scenarios

Write two financial scenarios when creating your financial projections, a best-case scenario, and a worst-case scenario. Use your list of assumptions to come up with realistic numbers for each scenario.

Presuming that you have already generated a list of assumptions, the creation of best and worst-case scenarios should be relatively simple. For each assumption, generate a high and low estimate. For example, if you are assuming that your company will have $100,000 in revenue, your high estimate might be $120,000 and your low estimate might be $80,000.

Once you have generated high and low estimates for all of your assumptions, you can create two scenarios: a best case scenario and a worst-case scenario. Simply plug the high estimates into your financial projections for the best-case scenario and the low estimates into your financial projections for the worst-case scenario.

Conduct a Ratio Analysis

A ratio analysis is a useful tool that can be used to evaluate a company’s financial health. Ratios can be used to compare a company’s performance to its industry average or to its own historical performance.

There are a number of different ratios that can be used in ratio analysis. Some of the more popular ones include the following:

• Gross margin ratio
• Operating margin ratio
• Return on assets (ROA)
• Return on equity (ROE)

To conduct a ratio analysis, you will need financial statements for your company and for its competitors. You will also need industry average ratios. These can be found in industry reports or on financial websites.

Once you have the necessary information, you can calculate the ratios for your company and compare them to the industry averages or to your own historical performance. If your company’s ratios are significantly different from the industry averages, it might be indicative of a problem.

Be Realistic

When creating your financial projections, it is important to be realistic. Your projections should be based on your list of assumptions and should reflect your best estimate of what your company’s future financial performance will be. This includes projected operating income, a projected income statement, and a profit and loss statement.

Your goal should be to create a realistic set of financial projections that can be used to guide your company’s future decision-making.

Sales Forecast

One of the most important aspects of your financial projections is your sales forecast. Your sales forecast should be based on your list of assumptions and should reflect your best estimate of what your company’s future sales will be.

Your sales forecast should be realistic and achievable. Do not try to “game” the system by creating an overly optimistic or pessimistic forecast. Your goal should be to create a realistic sales forecast that can be used to guide your company’s future decision-making.

Creating a sales forecast is not an exact science, but there are a number of methods that can be used to generate realistic estimates. Some common methods include market analysis, competitor analysis, and customer surveys.

Create Multi-Year Financial Projections

When creating financial projections, it is important to generate projections for multiple years. This will give you a better sense of how your company’s financial performance is likely to change over time.

It is also important to remember that your financial projections are just that: projections. They are based on a number of assumptions and are not guaranteed to be accurate. As such, you should review and update your projections on a regular basis to ensure that they remain relevant.

Creating financial projections is an important part of any business plan. However, it’s important to remember that these projections are just estimates. They are not guarantees of future success.

Business Plan Financial Projections FAQs

What is a business plan financial projection.

A business plan financial projection is a forecast of your company's future financial performance. It should include line items for each type of asset and liability, as well as a total at the end.

What are annual income statements? 

The Annual income statement is a financial document and a financial model that summarize a company's revenues and expenses over the course of a fiscal year. They provide a snapshot of a company's financial health and performance and can be used to track trends and make comparisons with other businesses.

What are the necessary financial statements?

The necessary financial statements for a business plan are an income statement, cash flow statement, and balance sheet.

How do I create financial projections?

You can create financial projections by making a list of assumptions, creating two scenarios (best case and worst case), conducting a ratio analysis, and being realistic.

How to Create Financial Projections for Your Business Plan

Written by Dave Lavinsky

Financial projections, also known as financial models, are forecasts of your company’s expected financial performance, typically over the next 5 years.

Over the past 25+ years, we’ve created financial projections for thousands of startups and existing businesses. In doing so, we’ve found 3 key reasons why financial projections are important:

• They help you determine the viability of your new business ideas and/or your need to make modifications to them. For instance, if your initial financial projections show your business idea isn’t profitable, you’ll know that changes are needed (e.g., raising prices, serving new markets, figuring out how to reduce costs, etc.) to make it viable.
• They are crucial for raising funding. Lenders will always review your financial projections to ensure you can comfortably repay any business loans they issue you. Equity investors will nearly always review your projections in determining whether they can achieve their desired return on their investment in your business.
• They help keep your business financially on track by giving you goals. For instance, if your financial projections state your company should generate 100 new clients this year, and the year is halfway done and you’re only at 30 clients, you’ll know you need to readjust your strategy to achieve your goals.

In the remainder of this article, you’ll learn more about financial projections, how to complete them, and how to incorporate them in your business plan.

Download our Ultimate Business Plan Template Here to Quickly & Easily Complete Your Business Plan & Financial Projections

What are Financial Projections?

Financial projections are financial forecasts or estimations of your company’s future revenues and expenses, serving as a crucial part of business planning. To complete them you must develop multiple assumptions with regards to items like future sales volumes, employee headcount and the cost of supplies and other expenses. Creating financial projections helps you develop better strategies to grow your business.

Your financial projections will be the most analyzed part of your business plan by investors and/or banks. While never a precise prediction of future performance, an excellent financial model outlines the core assumptions of your business and helps you and others evaluate capital requirements, risks involved, and rewards that successful execution will deliver.

Having a solid framework in place also will help you compare your performance to the financial projections and evaluate how your business is progressing. If your performance is behind your projections, you will have a framework in place to assess the effects of lowering costs, increasing prices, or even reimagining your model. In the happy case that you exceed your business projections, you can use your framework to plan for accelerated growth, new hires, or additional expansion investments.

Hence, the use of accurate financial projections is multi-fold and crucial for the success of any business. Your financial projections should include three core financial statements – the income statement, the cash flow statement, and the balance sheet. The following section explains each statement in detail.

Necessary Financial Statements

The three financial statements are the income statement, the cash flow statement, and the balance sheet. You will learn how to create each one in detail below.  

Income Statement Projection

The projected income statement is also referred to as a profit and loss statement and showcases your business’s revenues and expenses for a specific period.

To create an income statement, you first will need to chart out a sales forecast by taking realistic estimates of units sold and multiplying them by price per unit to arrive at a total sales number. Then, estimate the cost of these units and multiply them by the number of units to get the cost of sales. Finally, calculate your gross margin by subtracting the cost of sales from your sales.

Once you have calculated your gross margin, deduct items like wages, rent, marketing costs, and other expenses that you plan to pay to facilitate your business’s operations. The resulting total represents your projected operating income, which is a critical business metric.

Plan to create an income statement monthly until your projected break-even, or the point at which future revenues outpace total expenses, and you reflect operating profit. From there, annual income statements will suffice.

Sample Income Statement

Consider a sample income statement for a retail store below:

Cash Flow Projection

As the name indicates, a cash flow statement shows the cash flowing in and out of your business. The cash flow statement incorporates cash from business operations and includes cash inflows and outflows from investment and financing activities to deliver a holistic cash picture of your company.

Investment activities include purchasing land or equipment or research & development activities that aren’t necessarily part of daily operations. Cash movements due to financing activities include cash flowing in a business through investors and/or banks and cash flowing out due to debt repayment or distributions made to shareholders.

You should total all these three components of a cash flow projection for any specified period to arrive at a total ending cash balance. Constructing solid cash flow projections will ensure you anticipate capital needs to carry the business to a place of sustainable operations.

Sample Cash Flow Statement

Below is a simple cash flow statement for the same retail store:

Balance Sheet Projections

A balance sheet shows your company’s assets, liabilities, and owner’s equity for a certain period and provides a snapshot in time of your business performance. Assets include things of value that the business owns, such as inventory, capital, and land. Liabilities, on the other hand, are legally bound commitments like payables for goods or services rendered and debt. Finally, owner’s equity refers to the amount that is remaining once liabilities are paid off. Assets must total – or balance – liabilities and equity.

Your startup financial documents should include annual balance sheets that show the changing balance of assets, liabilities, and equity as the business progresses. Ideally, that progression shows a reduction in liabilities and an increase in equity over time.

While constructing these varied business projections, remember to be flexible. You likely will need to go back and forth between the different financial statements since working on one will necessitate changes to the others.

Sample Balance Sheet

Below is a simple balance sheet for the retail store:

How to Finish Your Business Plan and Financial Projections in 1 Day!

Don’t you wish there was a faster, easier way to finish your plan and financial projections?

With Growthink’s Ultimate Business Plan Template you can finish your plan in just 8 hours or less!

How to Create Financial Projections

When it comes to financial forecasting, simplicity is key. Making financial projections does not have to be overly sophisticated and complicated to impress, and convoluted projections likely will have the opposite effect on potential investors. Keep your tables and graphs simple and fill them with credible or historical data that inspires confidence in your plan and vision. The below tips will help bolster your financial projections.    

Create a List of Assumptions

Your financial projections should be tied to a list of assumptions. For example, one assumption will be the initial monthly cash sales you achieve. Another assumption will be your monthly growth rate. As you can imagine, changing either of these assumptions will significantly impact your financial projections.

As a result, tie your income statement, balance sheet, and cash flow statements to your assumptions. That way, if you change your assumptions, all of your financial projections automatically update.

Below are the key assumptions to include in your financial model:

For EACH essential product or service you offer:

• What is the number of units you expect to sell each month?
• What is your expected monthly sales growth rate?
• What is the average price that you will charge per product or service unit sold?
• How much do you expect to raise your prices each year?
• How much does it cost you to produce or deliver each unit sold?
• How much (if at all) do you expect your direct product costs to grow each year?

For EACH subscription/membership, you offer:

• What is the monthly/quarterly/annual price of your membership?
• How many members do you have now, or how many members do you expect to gain in the first month/quarter/year?
• What is your projected monthly/quarterly/annual growth rate in the number of members?
• What is your projected monthly/quarterly/annual member churn (the percentage of members that will cancel each month/quarter/year)?
• What is the average monthly/quarterly/annual direct cost to serve each member (if applicable)?

Cost Assumptions

• What is your monthly salary? What is the annual growth rate in your salary?
• What is your monthly salary for the rest of your team? What is the expected annual growth rate in your team’s salaries?
• What is your initial monthly marketing expense? What is the expected annual growth rate in your marketing expense?
• What is your initial monthly rent + utility expense? What is the expected annual growth rate in your rent + utility expense?
• What is your initial monthly insurance expense? What is the expected annual growth rate in your insurance expense?
• What is your initial monthly office supplies expense? What is the expected annual growth rate in your office supplies expense?
• What is your initial monthly cost for “other” expenses? What is the expected annual growth rate in your “other” expenses?

Capital Expenditures, Funding, Tax, and Balance Sheet Items

• How much money do you need for Capital Expenditures in your first year  (to buy computers, desks, equipment, space build-out, etc.)?
• How much other funding do you need right now?
• What percent of the funding will be financed by Debt (versus equity)?
• What Corporate Tax Rate would you like to apply to company profits?
• What is your Current Liabilities Turnover (in the number of days)?
• What are your Current Assets, excluding cash (in the number of days)?
• What is your Depreciation rate?
• What is your Amortization number of Years?
• What is the number of years in which your debt (loan) must be paid back?
• What is your Debt Payback interest rate?

Create Two Financial Projection Scenarios

It would be best if you used your assumptions to create two sets of clear financial projections that exhibit two very different scenarios. One is your best-case scenario, and the other is your worst-case. Investors are usually very interested in how a business plan will play out in both these scenarios, allowing them to better analyze the robustness and potential profitability of a business.    

Conduct a Ratio Analysis

Gain an understanding of average industry financial ratios, including operating ratios, profitability ratios, return on investment ratios, and the like. You can then compare your own estimates with these existing ratios to evaluate costs you may have overlooked or find historical financial data to support your projected performance. This ratio analysis helps ensure your financial projections are neither excessively optimistic nor excessively pessimistic.  

Be Realistic

It is easy to get carried away when dealing with estimates and you end up with very optimistic financial projections that will feel untenable to an objective audience. Investors are quick to notice and question inflated figures. Rather than excite investors, such scenarios will compromise your legitimacy.  

Create Multi-Year Financial Projections

The first year of your financial projections should be presented on a granular, monthly basis. For subsequent years, annual projections will suffice. It is advised to have three- or five-year projections ready when you start attracting investors. Since your plan needs to be succinct, you can add yearly projections as appendices to your main plan.

You should now know how to create financial projections for your business plan. In addition to creating your full projections as their own document, you will need to insert your financial projections into your plan. In your executive summary, Insert your topline projections, that is, just your sales, gross margins, recurring expenses, EBITDA (earnings before interest, taxes, depreciation, and amortization), and net income). In the financial plan section of your plan, insert your key assumptions and a little more detail than your topline projections. Include your full financial model in the appendix of your plan.

Other Helpful Business Plan Articles & Templates

From Idea to Foundation

Master the Essentials: Laying the Groundwork for Lasting Business Success. 

Funding and Approval Toolkit

Shape the future of your business, business moves fast. stay informed..

Discover the Best Tools for Business Plans

Learn from the business planning experts, resources to help you get ahead, financial projections, table of contents.

Financial projections are not just a component of your business plan; they are the beating heart of strategic thinking and analysis in both startups and established businesses. These projections serve as a vital tool for setting targets, assessing key results, and understanding the reasons behind meeting or not meeting these targets. They enable businesses to recalibrate their strategies effectively, ensuring agility and responsiveness to market dynamics.

Essential for Diverse Business Needs

Apart from their critical role in internal analysis and strategy setting, financial projections are indispensable for a variety of external purposes:

• Raising Capital:  Whether you’re a startup aiming for seed funding or an established business seeking expansion capital, clear and well-structured financial projections can significantly increase your chances of securing investment .
• Regulatory and Legal Compliance:  Specific employment and investment visas, licensing, certification, and accreditation processes often require detailed financial projections to demonstrate the viability and potential of your business.
• Understanding Audiences:  Depending on the audience—whether investors, regulatory bodies, or partners—the nature and detail of the financial projections can vary. Our “Understanding Audiences” page provides in-depth insights into tailoring your projections for different stakeholders.

Versatility in Application

Financial projections can be a standalone document or part of a comprehensive business plan. Their structure and emphasis may vary based on the business’s objectives:

• Debt Financing:  For new businesses seeking loans , financial projections within a business plan help in demonstrating the capacity to repay the loan.
• Equity-Based Financing:  For businesses in stages like pre-seed, seed , or series A funding, standalone financial projections are crucial. They provide clarity on startup requirements, burn-rate , and runway , which are key factors investors evaluate.

Foundations of Effective Financial Projections

Crafting impactful financial projections is a detailed and systematic process, grounded in deep research and thorough data collection. To create a robust foundation for these projections, two distinct approaches are recommended, each suited to different types of businesses and their unique needs:

• Ideal for New and Innovative Ventures:  The Pre-Planning Process , detailed under Core Cost Analysis and Startup & Operational Costs in the “Get Started” section of Businessplan.com, is particularly beneficial for businesses that are in their nascent stages or are pioneering new markets.
• First-Movers and Fast-Followers:  For ventures that aim to be first-movers or fast-followers in emerging industries, this comprehensive approach is crucial to understand the uncharted market dynamics.
• Startups Eyeing Investment Capital:  Additionally, startups that plan to seek investment capital will find this process instrumental in laying a solid groundwork for their financial projections, giving potential investors a clear view of the business’s potential.
• Tailored for Established Industries:  Businesses operating within well-established industries, where market dynamics are relatively known and stable, will benefit significantly from using a Model-Based Planning® Worksheet .
• Focus on Speed and Efficiency:  This approach is designed for ventures where rapid planning and execution are prioritized. It provides a streamlined, industry-specific framework that accelerates the planning process.
• Customized to Specific Business Models:  The Worksheet is customized for a wide range of business models and industries, ensuring that the financial projections are relevant and aligned with industry standards and expectations.

By choosing the approach that best aligns with your business’s stage, industry, and goals, you can ensure that your financial projections are not only realistic and well-informed but also highly effective in guiding your business towards success.

Key Sections of Financial Projections

Key assumptions.

In financial planning for businesses, especially startups, the creation of key assumptions is critical. These assumptions form the backbone of your financial projections, influencing every aspect from revenue forecasting to cost management. Their accuracy and realism are crucial for developing a financial model that truly reflects the potential of your business.

The Role of Key Assumptions

Key assumptions serve multiple purposes:

• Simplifying Complexity : By categorizing diverse products or services into manageable units, Key Assumptions help in creating a more readable and practical financial model .
• Guiding Strategic Decisions:  These assumptions are instrumental in shaping business strategies, from marketing to product development.
• Facilitating Communication:  Clear and concise assumptions make your financial projections more understandable to stakeholders, including investors and team members.

Creating Effective Key Assumptions

To craft meaningful and effective Key Assumptions, consider the following steps:

• Understand Your Business Model:  Grasp the intricacies of your business, including product/service offerings, customer behavior, and market trends.
• Use Averages and Ratios:  Simplify complex product lines or service offerings into average sales figures or ratios.
• Research and Validate:  Ground your assumptions in market research or historical data, ensuring they are realistic and defendable.
• Think Creatively and Contextually:  Tailor your assumptions to the unique context of your business, avoiding one-size-fits-all templates.

Personnel Plan

A comprehensive personnel plan is an essential component of your business’s financial projections. It not only outlines the staffing requirements but also encapsulates the associated costs, playing a significant role in the overall financial health of your enterprise.

Part 1: Personnel Forecast

The Personnel Forecast is a detailed table that includes the following elements:

• Specific Roles/Positions:  Identify the various roles and positions needed within your company. This could range from managerial positions to operational staff.
• Average Salary or Hourly Rate:  For each position, determine the average salary or hourly wage. This should be based on industry standards, regional salary averages, and the level of expertise required.
• Headcount:  Specify the number of individuals needed for each role. This will depend on the scale of your operations and business needs.
• Total Payroll per Position:  Calculate the total payroll for each position by multiplying the average salary or hourly rate by the headcount.
• Total Payroll:  Summarize the total payroll expenses, combining the costs from all positions.

Part 2: Personnel-Related Notes for Other Financial Tables

In addition to the Personnel Forecast, certain personnel-related expenses will be input into other financial tables:

• Pre-Launch Training:  Costs associated with training employees before the business launch should be included in the ‘ Sources & Uses of Funds ‘ under ‘Startup Expenses’.
• Ongoing or Post-Launch Training:  Regular training or development costs incurred after the launch should be accounted for in the ‘Expenses’ section of the Pro Forma Profit & Loss statement.
• Total Benefits:  Include costs related to sick leave, vacation, 401K match, health insurance, etc., in the Pro Forma Profit & Loss statement. These benefits form a significant part of employee compensation and affect the overall financial planning.
• Payroll Taxes:  Calculate and include payroll taxes based on state and federal rates in the Pro Forma Profit & Loss statement. These taxes are a mandatory financial obligation and an integral part of payroll expenses.

Projecting Revenue

Projecting revenue is one of the most challenging aspects of business planning, primarily due to the uncertainties inherent in predicting future market behavior. However, strategic tools like Total Addressable Market (TAM) , Serviceable Available Market (SAM), and Serviceable Obtainable Market (SOM) can significantly aid in this process.

Understanding TAM, SAM, and SOM

• Total Addressable Market (TAM):  TAM refers to the total market demand for a product or service. It’s the maximum revenue opportunity available for a product or service, assuming 100% market share.
• S erviceable Available Market (SAM):  SAM is the segment of the TAM targeted by your products and services that is within your geographical reach. It’s more realistic than TAM as it considers the market that is actually serviceable.
• Serviceable Obtainable Market (SOM):  SOM, the most immediate and practical measure, is the portion of SAM that you can capture. It considers factors like competition, your unique value proposition, pricing strategy, and operational capacity. SOM is what you realistically aim to achieve in the short to medium term.

Utilizing Industry Reports for Revenue Projection

Industry reports, like those from IBISWorld , are invaluable in this process. They provide detailed insights, including a section on Cost Structure which outlines the average percentage of revenue spent on various expenses in your industry. Here’s how you can use this data:

• Estimate Revenue Based on Personnel Costs:  Given the detailed personnel plan you have, use the “Wages” percentage from the IBISWorld report. By dividing your total annual personnel costs by this percentage, you get an estimate of the annual revenue required to support your staff.
• Refine with SOM:  This initial estimate is a starting point. Refine it by applying the SOM concept. Assess how your company’s unique factors — like your value proposition , competitive landscape, and sales capacity — will influence your achievable market share. For example, if the SAM for your product is $100 million and you estimate that you can realistically capture 5% of this market based on your unique factors, your SOM would be $5 million.

While no method guarantees perfect revenue projections, using TAM, SAM, and SOM provides a structured approach to estimate potential sales. Industry reports like those from IBISWorld further refine these projections by grounding them in real-world data, making them more realistic and achievable. Always remember, these are estimates meant to guide planning and strategy, and they should be regularly reviewed and adjusted as your business grows and market conditions evolve.

Pro Forma Profit & Loss Statement

A Pro Forma Profit & Loss (P&L) Statement is a crucial financial document that projects your business’s revenues and expenses over a specific period. While industry reports like those from IBISWorld offer a high-level view of common expenses, creating a detailed and realistic P&L statement requires a deeper dive into your unique fixed and variable costs .

Utilizing Industry Reports with Caution

Industry reports provide average percentages for various cost categories such as marketing, depreciation, profit, rent, utilities, wages, and others. However, it’s vital to remember that these figures are averages derived from a wide range of companies. Your specific costs may differ significantly based on your business model, location, and operational strategy.

Steps to Develop a Pro Forma P&L Statement

• Rent:  Engage in preliminary discussions with landlords or commercial brokers to ascertain expected rent costs. Location and space requirements will significantly impact this expense.
• Marketing and Promotion:  Detail the components of your marketing, promotional, sales, and customer service strategies. Refer to the ‘ Strategy & Implementation ‘ section on Businessplan.com for guidance. Assess the costs associated with each element, considering both traditional and digital marketing channels.
• Operational Costs:  Identify and quantify your fixed and variable operational costs. Fixed costs might include utilities, insurance, and salaries, while variable costs could be tied to production levels, such as raw materials and shipping.
• Utilize your revenue projections (based on TAM, SAM, and SOM analyses) to estimate sales.
• List and quantify all anticipated expenses, separating them into fixed and variable categories. This is a good time to thoroughly review the Key Activities, Key Resources, and Key Partners in your business model.
• Gross Profit:  Subtract the cost of goods sold (COGS) from your total revenue.
• Net Profit:  Deduct all operational expenses, including fixed and variable costs, from the gross profit.
• Account for depreciation of assets and any applicable taxes to determine the final net profit.

A detailed Pro Forma P&L statement is a vital tool for any business. While industry reports offer a starting point, the specificity and accuracy of your projections will come from a deep understanding of your unique business costs and revenue potential. Regularly revisiting and updating this document is key to maintaining its relevance and usefulness as your business evolves.

Projected Cash Flow

A projected cash flow statement is an essential financial tool that helps map out the flow of cash in and out of your business. It’s a forecast of your company’s cash income and expenditures over a specific period and is crucial for managing liquidity and ensuring financial stability.

Creating a Cash Flow Projection

Estimate Cash Inflows:  Include all sources of income, such as sales revenue, investment income, and any other cash receipts. Consider the timing of these inflows, as delays in payment can significantly affect your cash flow.

Estimate Cash Outflows:  List all expected cash payments, including operating expenses, loan repayments, purchases of assets, and other expenditures. Timing is crucial here as well, particularly for seasonal businesses or those with irregular payment cycles.

Project Net Cash Flow:  Calculate the net cash flow for each period (monthly, quarterly, etc.) by subtracting cash outflows from cash inflows. This gives you a clear picture of when and where cash shortages or surpluses might occur.

Include Opening and Closing Balances:  Start with your opening cash balance (beginning of the period). Add the net cash flow to this opening balance to arrive at the closing balance (end of the period).

Projected Balance Sheet

The projected balance sheet is a financial statement that provides a snapshot of your company’s financial position at a future date. It includes assets , liabilities , and owner’s equity , projecting how these elements will change over time.

Preparing a Projected Balance Sheet

• Current Assets:  Include cash, accounts receivable , inventory , and other assets that are expected to be converted to cash within a year.
• Long-term Assets:  Include property, plant, equipment, and other assets that provide value over a longer period.
• Current Liabilities:  These are obligations due within a year, like accounts payable, short-term loans, and accrued expenses.
• Long-term Liabilities:  Include long-term debts, lease obligations, and other liabilities not due within the next year.
• Calculate Owner’s Equity:  Owner’s equity is the residual interest in the assets of the business after deducting liabilities. It includes initial investment, retained earnings, and any other equity contributions.
• Ensure the Fundamental Accounting Equation:  The balance sheet must follow the equation: Assets = Liabilities + Owner’s Equity. This equation must balance, which means the total value of the assets must equal the combined value of liabilities and owner’s equity.

Break-Even Analysis

Break-even analysis is a critical financial tool used to determine when a business will be able to cover all its expenses and start generating profit. Understanding the break-even point is vital for both new and existing businesses, as it informs pricing strategies, cost management, and funding requirements.

Break-Even for Different Business Types

• Established Market Entrants:  Businesses entering established markets (restaurants, dental offices, dry cleaners, etc.), possibly with debt financing like an SBA loan, typically have shorter break-even periods. These range from 6 to 18 months, depending on business complexity and market penetration strategies. For these businesses, the break-even point is crucial to manage debt and establish a foothold in the market.
• Venture-Backed Companies:  For startups (first-movers or fast-followers) creating new markets with novel solutions, the path to break-even is often longer. This is by design, as venture capitalists invest in these companies with the understanding that establishing or growing a new market takes time. These companies may operate for extended periods without breaking even, focusing on market creation and growth rather than immediate profitability.

Calculating the Break-Even Point

• The break-even point is calculated by dividing total fixed costs by the difference between unit price and variable cost per unit.
• Understanding fixed costs (like rent, salaries) and variable costs (costs that change with production volume) is essential for accurate calculation.

Sensitivity Analysis

Sensitivity analysis is a technique used to predict the outcome of a decision given a certain range of variables. In financial modeling , it involves testing how different values of an independent variable affect a particular dependent variable under a given set of assumptions.

Application in Revenue Projections

• Adjusting Revenue Projections:  Commonly, sensitivity analysis in business planning involves altering top-line revenue projections by a certain percentage. This helps in understanding how changes in sales will impact the business’s financial health.
• Scenarios for Sensitivity Analysis:  For example, a business may test how their financials would look if revenues are 15% lower than projected. Assessing different scenarios helps in preparing for various market conditions.
• Importance in Debt Financing:  Banks and financial institutions often use sensitivity analysis to determine if a business can still maintain a debt service coverage ratio above a certain threshold (e.g., 1.3) even if revenues fall short of projections. This analysis is crucial for businesses seeking loans, as it impacts the lender’s confidence in the business’s ability to repay debt.

Up Next: Strategy & Implementation

It’s essential to remember the critical role financial projections play in writing a business plan and guiding your business towards sustainable growth and success. Projections, built on a foundation of diligent research and detailed analysis, enable you to navigate the complexity of fundraising or business management with greater confidence and precision.

Financial projections empower you to set realistic targets, assess key results, and adapt strategies effectively in response to market dynamics. Your financial projections are not just numbers on a page; they are a reflection of your business’s potential and a roadmap for its future.

We encourage you to revisit and refine your financial projections regularly, aligning them with your evolving business landscape and market conditions. And remember, the journey doesn’t end here. To continue enhancing your business acumen and strategic planning, we invite you to explore the next critical step in the Plan & Pitch section: Strategy & Implementation . Here, you’ll get deeper into formulating effective strategies and actionable plans that will further elevate your business’s trajectory. Embrace this journey with the knowledge and tools you’ve acquired, and watch your business vision come to life, one well-planned step at a time.

Proceed to Strategy & Implementation

Welcome to Businessplan.com

Currently in beta test mode.

Products available for purchase are placeholders and no orders will be processed at this time.

Let’s craft the ultimate business planning platform together.

Have questions, suggestions, or want a sneak peek at upcoming tools and resources? Connect with us on X or join “On the Right Foot” on Substack .

This site uses cookies from Google to deliver its services and to analyze traffic.

Ok, Got It.

Privacy Policy

ZenBusinessPlans

Home » Business Plans

How to Write a Business Plan Financial Projection [Sample Template]

How do you prepare a business plan financial statement? Do you need help developing business plan financial projections? Do you need a business plan projections template? Then i advice you read on because this article is for you.

What is a Business Plan Financial Statement?

The financial statement is a distinct section of your business plan because it outlines your financial projections. A business lives and dies based on its financial feasibility and most importantly its profitability. Regardless of how hard you work or how much you have invested of your time and money, people, at the end of the day, only want to support something that can return their investments with profits.

Your executive summary may be brilliantly crafted, and your market or industry analysis may be the bomb. But your business plan isn’t just complete without a financial statement to justify it with good figures on the bottom line.

Your financial statement is what makes or mars your chances of obtaining a bank loan or attracting investors to your business. Even if you don’t need financing from a third party, compiling a financial statement will help you steer your business to success. So, before we dig further into how to prepare a financial statement, you need to understand what a financial statement is not.

What’s the Difference Between a Financial Projection Statement and Accounting Statement?

However, you need to keep in mind that the financial statement is not the same as an accounting statement. Granted, a financial statement includes financial projections such as profit and loss, balance sheets, and cash flow, all of which makes it look similar to an accounting statement.

But the major difference between them is that an accounting statement deals with the past, while the financial projections statement of your business plan outlines your future spending and earnings. Having made this point clear, let’s now look at the steps involved on preparing a financial statement for your business plan.

So what exactly do you have to include in this section? You will need to include three statements:

• Income Statement
• Balance Sheet
• Cash-Flow Statement

Now, let’s briefly discuss each.

Components of a Business Plan Financial Statement

Income statement.

This beautiful composition of numbers tells the reader what exactly your sources of revenue are and which expenses you spent your money on to arrive at the bottom line. Essentially, for a given time period, the income statement states the profit or loss ( revenue-expenses ) that you made.

Balance sheet

The key word here is “ balance, ” but you are probably wondering what exactly needs to be weighed, right? On one side you should list all your assets ( what you own ) and on the other side, all your liabilities ( what you owe ), thereby giving a snapshot of your net worth ( assets – liabilities = equity ).

Cash flow statement

This statement is similar to your income statement with one important difference; it takes into account just when revenues are actually collected and when expenses are paid. When the cash you have coming in ( collected revenue ) is greater than the cash you have going out ( disbursements ), your cash flow is said to be positive.

And when the opposite scenario is true, your cash flow is negative. Ideally, your cash flow statement will allow you to recognize where cash is low, when you might have a surplus, and how to be on top of your game when operating in an uncertain environment.

How to Prepare a Business Plan Financial Projections Statement

1. Start by preparing a revenue forecast and a forecast profit and loss statement

Also, prepare supporting schedules with detailed information about your projected personnel and marketing costs. If your business has few fixed assets or it’s just a cash business without significant receivables, you don’t need a forecast balance sheet.

2. Using your planned revenue model, prepare a spreadsheet

Set the key variables in such a way that they can be easily changed as your calculations chain through. To ensure that your projected revenues are realistic and attainable, run your draft through a number of iterations. For each year covered in your business plan, prepare a monthly forecast of revenues and spending.

3. If you plan to sell any goods, then include a forecast of goods sold

This applies the most to manufacturing businesses. Give a reasonable estimate for this cost. And be of the assumption that the efficiency of your products would increase with time and the cost of goods sold as a percentage of sales will decline.

4. Quantify your marketing plan

Look at each marketing strategy you outlined in the business plan and attach specific costs to each of them. That is, if you are looking at billboard advertising, TV advertising, and online marketing methods such as pay-per-click advertising and so on; then you should estimate the cost of each medium and have it documented.

5. Forecast the cost of running the business, including general and administrative costs

Also, forecast the cost of utilities, rents, and other recurring costs. Don’t leave out any category of expenses that is required to run your business. And don’t forget the cost of professional services such as accounting and legal services.

6. In the form of a spreadsheet, forecast the payroll

This outlines each individual that you plan to hire, the month they will start work, and their salary. Also include the percentage salary increases (due to increased cost of living and as reward for exemplary performance) that will come in the second and subsequent years of the forecast.

Additional tips for Writing a Business Plan Financial Statement

• Don’t stuff your pages with lots of information, and avoid large chunks of text. Also, use a font size that is large enough. Even if these would spread out your statement into more pages, don’t hesitate to spread it out. Legibility matters!
• After completing the spreadsheets in the financial statement, you should summarize the figures in the narrative section of your business plan.
• Put a table near the front of your financial statement that shows projected figures, pre-tax profit, and expenses. These are the figures you want the reader to remember. You can help the reader retain these figures in memory by including a bar chart of these figures, too.

As a final note, you should keep in mind that a financial statement is just an informed guess of what will likely happen in the future. In reality, the actual results you will achieve will vary. In fact, this difference may be very far from what you have forecast.

So, if your business is a start-up, prepare more capital than your projections show that you will need. Entrepreneurs have a natural tendency to project a faster revenue growth than what is realistic. So, don’t let this instinct fool you.

More on Business Plans