sample projected financial statements for a business plan

• 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.

• 400+ Sample Business Plans
• WHY UPMETRICS?

Customer Success Stories

Business Plan Course

Strategic Planning Templates

E-books, Guides & More

Entrepreneurs & Small Business

Accelerators & Incubators

Business Consultants & Advisors

Educators & Business Schools

Students & Scholars

AI Business Plan Generator

Financial Forecasting

AI Assistance

Ai Pitch Deck Generator

Strategic Planning

See How Upmetrics Works  →

• Sample Plans

Small Business Tools

How to Prepare a Financial Plan for Startup Business (w/ example)

Free Financial Statements Template

Ajay Jagtap

• December 7, 2023

13 Min Read

If someone were to ask you about your business financials, could you give them a detailed answer?

Let’s say they ask—how do you allocate your operating expenses? What is your cash flow situation like? What is your exit strategy? And a series of similar other questions.

Instead of mumbling what to answer or shooting in the dark, as a founder, you must prepare yourself to answer this line of questioning—and creating a financial plan for your startup is the best way to do it.

A business plan’s financial plan section is no easy task—we get that.

But, you know what—this in-depth guide and financial plan example can make forecasting as simple as counting on your fingertips.

Ready to get started? Let’s begin by discussing startup financial planning.

What is Startup Financial Planning?

Startup financial planning, in simple terms, is a process of planning the financial aspects of a new business. It’s an integral part of a business plan and comprises its three major components: balance sheet, income statement, and cash-flow statement.

Apart from these statements, your financial section may also include revenue and sales forecasts, assets & liabilities, break-even analysis , and more. Your first financial plan may not be very detailed, but you can tweak and update it as your company grows.

Key Takeaways

• Realistic assumptions, thorough research, and a clear understanding of the market are the key to reliable financial projections.
• Cash flow projection, balance sheet, and income statement are three major components of a financial plan.
• Preparing a financial plan is easier and faster when you use a financial planning tool.
• Exploring “what-if” scenarios is an ideal method to understand the potential risks and opportunities involved in the business operations.

Why is Financial Planning Important to Your Startup?

Poor financial planning is one of the biggest reasons why most startups fail. In fact, a recent CNBC study reported that running out of cash was the reason behind 44% of startup failures in 2022.

A well-prepared financial plan provides a clear financial direction for your business, helps you set realistic financial objectives, create accurate forecasts, and shows your business is committed to its financial objectives.

It’s a key element of your business plan for winning potential investors. In fact, YC considered recent financial statements and projections to be critical elements of their Series A due diligence checklist .

Your financial plan demonstrates how your business manages expenses and generates revenue and helps them understand where your business stands today and in 5 years.

Makes sense why financial planning is important to your startup, doesn’t it? Let’s cut to the chase and discuss the key components of a startup’s financial plan.

Say goodbye to old-school excel sheets & templates

Make accurate financial plan faster with AI

Plans starting from $7/month

Key Components of a Startup Financial Plan

Whether creating a financial plan from scratch for a business venture or just modifying it for an existing one, here are the key components to consider including in your startup’s financial planning process.

Income Statement

An Income statement , also known as a profit-and-loss statement(P&L), shows your company’s income and expenditures. It also demonstrates how your business experienced any profit or loss over a given time.

Consider it as a snapshot of your business that shows the feasibility of your business idea. An income statement can be generated considering three scenarios: worst, expected, and best.

Your income or P&L statement must list the following:

• Cost of goods or cost of sale
• Gross margin
• Operating expenses
• Revenue streams
• EBITDA (Earnings before interest, tax, depreciation , & amortization )

Established businesses can prepare annual income statements, whereas new businesses and startups should consider preparing monthly statements.

Cash flow Statement

A cash flow statement is one of the most critical financial statements for startups that summarize your business’s cash in-and-out flows over a given time.

This section provides details on the cash position of your business and its ability to meet monetary commitments on a timely basis.

Your cash flow projection consists of the following three components:

✅ Cash revenue projection: Here, you must enter each month’s estimated or expected sales figures.

✅ Cash disbursements: List expenditures that you expect to pay in cash for each month over one year.

✅ Cash flow reconciliation: Cash flow reconciliation is a process used to ensure the accuracy of cash flow projections. The adjusted amount is the cash flow balance carried over to the next month.

Furthermore, a company’s cash flow projections can be crucial while assessing liquidity, its ability to generate positive cash flows and pay off debts, and invest in growth initiatives.

Balance Sheet

Your balance sheet is a financial statement that reports your company’s assets, liabilities, and shareholder equity at a given time.

Consider it as a snapshot of what your business owns and owes, as well as the amount invested by the shareholders.

This statement consists of three parts: assets , liabilities, and the balance calculated by the difference between the first two. The final numbers on this sheet reflect the business owner’s equity or value.

Balance sheets follow the following accounting equation with assets on one side and liabilities plus Owner’s equity on the other:

Here is what’s the core purpose of having a balance-sheet:

• Indicates the capital need of the business
• It helps to identify the allocation of resources
• It calculates the requirement of seed money you put up, and
• How much finance is required?

Since it helps investors understand the condition of your business on a given date, it’s a financial statement you can’t miss out on.

Break-even Analysis

Break-even analysis is a startup or small business accounting practice used to determine when a company, product, or service will become profitable.

For instance, a break-even analysis could help you understand how many candles you need to sell to cover your warehousing and manufacturing costs and start making profits.

Remember, anything you sell beyond the break-even point will result in profit.

You must be aware of your fixed and variable costs to accurately determine your startup’s break-even point.

• Fixed costs: fixed expenses that stay the same no matter what.
• Variable costs: expenses that fluctuate over time depending on production or sales.

A break-even point helps you smartly price your goods or services, cover fixed costs, catch missing expenses, and set sales targets while helping investors gain confidence in your business. No brainer—why it’s a key component of your startup’s financial plan.

Having covered all the key elements of a financial plan, let’s discuss how you can create a financial plan for your startup.

How to Create a Financial Section of a Startup Business Plan?

1. determine your financial needs.

You can’t start financial planning without understanding your financial requirements, can you? Get your notepad or simply open a notion doc; it’s time for some critical thinking.

Start by assessing your current situation by—calculating your income, expenses , assets, and liabilities, what the startup costs are, how much you have against them, and how much financing you need.

Assessing your current financial situation and health will help determine how much capital you need for your startup and help plan fundraising activities and outreach.

Furthermore, determining financial needs helps prioritize operational activities and expenses, effectively allocate resources, and increase the viability and sustainability of a business in the long run.

Having learned to determine financial needs, let’s head straight to setting financial goals.

2. Define Your Financial Goals

Setting realistic financial goals is fundamental in preparing an effective financial plan. So, it would help to outline your long-term strategies and goals at the beginning of your financial planning process.

Let’s understand it this way—if you are a SaaS startup pursuing VC financing rounds, you may ask investors about what matters to them the most and prepare your financial plan accordingly.

However, a coffee shop owner seeking a business loan may need to create a plan that appeals to banks, not investors. At the same time, an internal financial plan designed to offer financial direction and resource allocation may not be the same as previous examples, seeing its different use case.

Feeling overwhelmed? Just define your financial goals—you’ll be fine.

You can start by identifying your business KPIs (key performance indicators); it would be an ideal starting point.

3. Choose the Right Financial Planning Tool

Let’s face it—preparing a financial plan using Excel is no joke. One would only use this method if they had all the time in the world.

Having the right financial planning software will simplify and speed up the process and guide you through creating accurate financial forecasts.

Many financial planning software and tools claim to be the ideal solution, but it’s you who will identify and choose a tool that is best for your financial planning needs.

Create a Financial Plan with Upmetrics in no time

Enter your Financial Assumptions, and we’ll calculate your monthly/quarterly and yearly financial projections.

Start Forecasting

4. Make Assumptions Before Projecting Financials

Once you have a financial planning tool, you can move forward to the next step— making financial assumptions for your plan based on your company’s current performance and past financial records.

You’re just making predictions about your company’s financial future, so there’s no need to overthink or complicate the process.

You can gather your business’ historical financial data, market trends, and other relevant documents to help create a base for accurate financial projections.

After you have developed rough assumptions and a good understanding of your business finances, you can move forward to the next step—projecting financials.

5. Prepare Realistic Financial Projections

It’s a no-brainer—financial forecasting is the most critical yet challenging aspect of financial planning. However, it’s effortless if you’re using a financial planning software.

Upmetrics’ forecasting feature can help you project financials for up to 7 years. However, new startups usually consider planning for the next five years. Although it can be contradictory considering your financial goals and investor specifications.

Following are the two key aspects of your financial projections:

Revenue Projections

In simple terms, revenue projections help investors determine how much revenue your business plans to generate in years to come.

It generally involves conducting market research, determining pricing strategy , and cash flow analysis—which we’ve already discussed in the previous steps.

The following are the key components of an accurate revenue projection report:

• Market analysis
• Sales forecast
• Pricing strategy
• Growth assumptions
• Seasonal variations

This is a critical section for pre-revenue startups, so ensure your projections accurately align with your startup’s financial model and revenue goals.

Expense Projections

Both revenue and expense projections are correlated to each other. As revenue forecasts projected revenue assumptions, expense projections will estimate expenses associated with operating your business.

Accurately estimating your expenses will help in effective cash flow analysis and proper resource allocation.

These are the most common costs to consider while projecting expenses:

• Fixed costs
• Variable costs
• Employee costs or payroll expenses
• Operational expenses
• Marketing and advertising expenses
• Emergency fund

Remember, realistic assumptions, thorough research, and a clear understanding of your market are the key to reliable financial projections.

6. Consider “What if” Scenarios

After you project your financials, it’s time to test your assumptions with what-if analysis, also known as sensitivity analysis.

Using what-if analysis with different scenarios while projecting your financials will increase transparency and help investors better understand your startup’s future with its best, expected, and worst-case scenarios.

Exploring “what-if” scenarios is the best way to better understand the potential risks and opportunities involved in business operations. This proactive exercise will help you make strategic decisions and necessary adjustments to your financial plan.

7. Build a Visual Report

If you’ve closely followed the steps leading to this, you know how to research for financial projections, create a financial plan, and test assumptions using “what-if” scenarios.

Now, we’ll prepare visual reports to present your numbers in a visually appealing and easily digestible format.

Don’t worry—it’s no extra effort. You’ve already made a visual report while creating your financial plan and forecasting financials.

Check the dashboard to see the visual presentation of your projections and reports, and use the necessary financial data, diagrams, and graphs in the final draft of your financial plan.

Here’s what Upmetrics’ dashboard looks like:

8. Monitor and Adjust Your Financial Plan

Even though it’s not a primary step in creating a good financial plan, it’s quite essential to regularly monitor and adjust your financial plan to ensure the assumptions you made are still relevant, and you are heading in the right direction.

There are multiple ways to monitor your financial plan.

For instance, you can compare your assumptions with actual results to ensure accurate projections based on metrics like new customers acquired and acquisition costs, net profit, and gross margin.

Consider making necessary adjustments if your assumptions are not resonating with actual numbers.

Also, keep an eye on whether the changes you’ve identified are having the desired effect by monitoring their implementation.

And that was the last step in our financial planning guide. However, it’s not the end. Have a look at this financial plan example.

Startup Financial Plan Example

Having learned about financial planning, let’s quickly discuss a coffee shop startup financial plan example prepared using Upmetrics.

Important Assumptions

• The sales forecast is conservative and assumes a 5% increase in Year 2 and a 10% in Year 3.
• The analysis accounts for economic seasonality – wherein some months revenues peak (such as holidays ) and wanes in slower months.
• The analysis assumes the owner will not withdraw any salary till the 3rd year; at any time it is assumed that the owner’s withdrawal is available at his discretion.
• Sales are cash basis – nonaccrual accounting
• Moderate ramp- up in staff over the 5 years forecast
• Barista salary in the forecast is $36,000 in 2023.
• In general, most cafes have an 85% gross profit margin
• In general, most cafes have a 3% net profit margin

Projected Balance Sheet

Projected Cash-Flow Statement

Projected Profit & Loss Statement

Break Even Analysis

Start Preparing Your Financial Plan

We covered everything about financial planning in this guide, didn’t we? Although it doesn’t fulfill our objective to the fullest—we want you to finish your financial plan.

Sounds like a tough job? We have an easy way out for you—Upmetrics’ financial forecasting feature. Simply enter your financial assumptions, and let it do the rest.

So what are you waiting for? Try Upmetrics and create your financial plan in a snap.

Build your Business Plan Faster

with step-by-step Guidance & AI Assistance.

Frequently Asked Questions

How often should i update my financial projections.

Well, there is no particular rule about it. However, reviewing and updating your financial plan once a year is considered an ideal practice as it ensures that the financial aspirations you started and the projections you made are still relevant.

How do I estimate startup costs accurately?

You can estimate your startup costs by identifying and factoring various one-time, recurring, and hidden expenses. However, using a financial forecasting tool like Upmetrics will ensure accurate costs while speeding up the process.

What financial ratios should startups pay attention to?

Here’s a list of financial ratios every startup owner should keep an eye on:

• Net profit margin
• Current ratio
• Quick ratio
• Working capital
• Return on equity
• Debt-to-equity ratio
• Return on assets
• Debt-to-asset ratio

What are the 3 different scenarios in scenario analysis?

As discussed earlier, Scenario analysis is the process of ascertaining and analyzing possible events that can occur in the future. Startups or businesses often consider analyzing these three scenarios:

• base-case (expected) scenario
• Worst-case scenario
• best case scenario.

About the Author

Ajay is a SaaS writer and personal finance blogger who has been active in the space for over three years, writing about startups, business planning, budgeting, credit cards, and other topics related to personal finance. If not writing, he’s probably having a power nap. Read more

Reach Your Goals with Accurate Planning

No Risk – Cancel at Any Time – 15 Day Money Back Guarantee

Popular Templates

Original text

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 Guide in English  or  Espanol .

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 Projection and Forecasting Templates

By Andy Marker | January 3, 2024

• Share on Facebook
• Share on LinkedIn

Link copied

We’ve collected the top free financial projection and forecasting templates. These templates enable business owners, CFOs, accountants, and financial analysts to plan future growth, manage cash flow, attract investors, and make informed decisions.  On this page, you'll find many helpful, free, customizable financial projection and forecasting templates, including a  1 2-month financial projection template , a  startup financial projection template , a  3-year financial projection template , and a  small business financial forecast template , among others. You’ll also find details on the  elements in a financial projection template ,  types of financial projection and forecasting templates , and  related financial templates .

Simple Financial Projection Template

Download a Sample Simple Financial Projection Template for 

Excel | Google Sheets  

Download a Blank Simple Financial Projection Template for 

Excel | Google Sheets    

Small business owners and new entrepreneurs are the ideal users for this simple financial projection template. Just input your expected revenues and expenses. This template stands out due to its ease of use and focus on basic, straightforward financial planning, making it perfect for small-scale or early-stage businesses. Available with or without sample text, this tool offers clear financial oversight, better budget management, and informed decision-making regarding future business growth. 

Looking for help with your business plan? Check out these  free financial templates for a business plan to streamline the process of organizing your business's financial information and presenting it effectively to stakeholders.

Financial Forecast Template

Download a Sample Financial Forecast Template for 

Download a Blank Financial Forecast Template for 

This template is perfect for businesses that require a detailed and all-encompassing forecast. Users can input various financial data, such as projected revenues, costs, and market trends, to generate a complete financial outlook. Available with or without example text, this template gives you a deeper understanding of your business's financial trajectory, aiding in strategic decision-making and long-term financial stability. 

These  free cash-flow forecast templates help you predict your business’s future cash inflows and outflows, allowing you to manage liquidity and optimize financial planning.

12-Month Financial Projection Template

Download a Sample 12-Month Financial Projection Template for 

Download a Blank 12-Month Financial Projection Template for 

Use this 12-month financial projection template for better cash-flow management, more accurate budgeting, and enhanced readiness for short-term financial challenges and opportunities. Input estimated monthly revenues and expenses, tracking financial performance over the course of a year. Available with or without sample text, this template is ideal for business owners who need to focus on short-term financial planning. This tool allows you to respond quickly to market shifts and plan effectively for the business's crucial first year. 

Download  free sales forecasting templates to help your business predict future sales, enabling better inventory management, resource planning, and decision-making.

Startup Financial Projection Template

Download a Sample Startup Financial Projection Template for 

Download a Blank Startup Financial Projection Template for 

This dynamic startup financial projection template is ideal for startup founders and entrepreneurs, as it's designed specifically for the unique needs of startups. Available with or without example text, this template focuses on clearly outlining a startup's initial financial trajectory, an essential component for attracting investors. Users can input projected revenues, startup costs, and funding sources to create a comprehensive financial forecast.

3-Year Financial Projection Template

Download a Sample 3-Year Financial Projection Template for 

Download a Blank 3-Year Financial Projection Template for 

This three-year financial projection template is particularly useful for business strategists and financial planners who are looking for a medium-term financial planning tool. Input data such as projected revenues, expenses, and growth rates for the next three years. Available with or without sample text, this template lets you anticipate financial challenges and opportunities in the medium term, aiding in strategic decision-making and ensuring sustained business growth.

5-Year Financial Forecasting Template

Download a Sample 5-Year Financial Forecasting Template for 

Download a Blank 5-Year Financial Forecasting Template for 

CFOs and long-term business planners can use this five-year financial forecasting template to get a clear, long-range financial vision. Available with or without example text, this template allows you to plan strategically and invest wisely, preparing your business for future market developments and opportunities. This unique tool offers an extensive outlook for your business’s financial strategy. Simply input detailed financial data spanning five years, including revenue projections, investment plans, and expected market growth. Visually engaging bar charts of key metrics help turn data into engaging narratives.

Small Business Financial Forecast Template

Download a Sample Small Business Financial Forecast Template for 

Download a Blank Small Business Financial Forecast Template for 

Excel | Google Sheets 

The small business financial forecast template is tailored specifically for the scale and specific requirements of small enterprises. Business owners and financial managers can simply input data such as projected sales or expenses. Available with or without sample text, this tool offers the ability to do the following: envision straightforward financial planning; anticipate future financial needs and challenges; make informed decisions; and steer the business toward steady growth.

Elements in a Financial Projection Template

The elements in a financial projection template include future sales, costs, profits, and cash flow. This template illustrates expected receivables, payables, and break-even dates. This tool helps you plan for your business's financial future and growth.   

Here are the standard elements in a financial projection template:   

• Revenue Projection: This estimates future income from various sources over a specific period.
• Expense Forecast: This predicts future costs, including both fixed and variable expenses.
• Profit and Loss Forecast:  This projects the profit or loss by subtracting projected expenses from projected revenues.
• Cash-Flow Projection: This assesses the inflows and outflows of cash, indicating liquidity over time.
• Balance Sheet Projection: This predicts the future financial position, showing assets, liabilities, and equity.
• Break-Even Analysis: This calculates the point at which total revenues equal total costs.
• Capital Expenditure Forecast: This estimates future spending on fixed assets such as equipment or property.
• Debt Repayment Plan: This outlines the schedule for paying back any borrowed funds.
• Sales Forecast:  This predicts future sales volume, often broken down by product or service.
• Gross Margin Analysis:  This looks at the difference between revenue and cost of goods sold.

Types of Financial Projection and Forecasting Templates

There are many types of financial projection and forecasting templates: basic templates for small businesses; detailed ones for big companies; special ones for startup businesses; and others. There are also sales forecasts, cash-flow estimates, and profit and loss projections. 

In addition, financial projection and forecasting templates include long-term planning templates, break-even analyses, budget forecasts, and templates made for specific industries such as retail or manufacturing. 

Each template serves different financial planning needs. Determine which one best suits your requirements based on the scale of your business, the complexity of its financial structure, and the specific department that you want to analyze.

Here's a list of the top types of financial projection and forecasting templates:  

• Basic Financial Projection Template: Ideal for small businesses or startups, this template provides a straightforward approach to forecasting revenue, expenses, and cash flow.
• Detailed Financial Projection Template: Best for larger businesses or those with complex financial structures, this template offers in-depth projections, including balance sheets, income statements, and cash-flow statements.
• Startup Financial Projection Template: Tailored for startups, this template focuses on funding requirements and early-stage revenue forecasts, both crucial for attracting investors and planning initial operations. 
• Sales Forecasting Template:  Used by sales and marketing teams to predict future sales, this template helps you set targets and plan marketing strategies. 
• Cash-Flow Forecast Template: Essential for financial managers who need to monitor the liquidity of the business, this template projects cash inflows and outflows over a period. 
• Profit and Loss Forecast Template (P&L):  Useful for business owners and financial officers who need to anticipate profit margins, this template enables you to forecast revenues and expenses.  
• Three-Year / Five-Year Financial Projection Template: Suitable for long-term business planning, these templates provide a broader view of your company’s financial future, improving your development strategy and investor presentations. 
• Break-Even Analysis Template:  Used by business strategists and financial analysts, this template helps you determine when your business will become profitable. 
• Budget Forecasting Template:  Designed for budget managers, this template uses historical financial data to help you plan your future spending. 
• Sector-Specific Financial Projection Template:  Designed for specific industries (such as retail or manufacturing), these templates take into account industry-specific factors and benchmarks.

Related Financial Templates

Check out this list of free financial templates related to financial projections and forecasting. You'll find templates for budgeting, tracking profits and losses, planning your finances, and more. These tools help keep your company’s money matters organized and clear.

Free Project Budget Templates

Use one of these  project budget templates to maintain control over project finances, ensuring costs stay aligned with the allocated budget and improving overall financial management.

Free Monthly Budget Templates

Use one of these  monthly budget templates to effectively track and manage your business’s income and expenses, helping you plan financially and save money.

Free Expense Report Templates

Use one of these  expense report templates to systematically track and document all business-related expenditures, ensuring accurate reimbursement and efficient financial record-keeping.

Free Balance Sheet Templates

Use one of these  balance sheet templates to summarize your company's financial position at a given time.

Free Cash-Flow Forecast Templates

Use one of these  cash-flow forecast templates to predict future cash inflows and outflows, helping you manage liquidity and make informed financial decisions.

Free Cash-Flow Statement Templates

Use one of these  cash-flow statement templates to track the movement of cash in and out of your business, so you can assess your company’s level of liquidity and financial stability.

Free Discounted Cash-Flow (DCF) Templates

Use one of these  discounted cash-flow (DCF) templates to evaluate the profitability of investments or projects by calculating their present value based on future cash flows.

Free Financial Dashboard Templates

Use one of these  financial dashboard templates to get an at-a-glance view of key financial metrics, so you can make decisions quickly and manage finances effectively.

Related Customer Stories

Free financial planning templates.

Use one of these  financial planning templates to strategically organize and forecast future finances, helping you set realistic financial goals and ensure long-term business growth.

Free Profit and Loss (P&L) Templates

Use one of these  profit and loss (P&L) templates to systematically track income and expenses, giving you a clear picture of your company's profitability over a specific period.

Free Billing and Invoice Templates

Use one of these  billing and invoice templates to streamline the invoicing process and ensure that you bill clients accurately and professionally for services or products.

Plan and Manage Your Company’s Financial Future with Financial Projection and Forecasting Templates from Smartsheet

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.

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

Financial Projections for Startups and Small Businesses

What’s on the horizon for your business? Will you need to hire new employees? Invest in new capital expenditures? Or maybe even consider opening a new location? Financial projections provide insight for small businesses and startups to plan for the future, as well as data and information potential lenders and investors need to understand your business.

What Are Financial Projections?

A financial projection is what your business expects to happen, based off hypothetical situations using the facts and data you have available. A financial projection is often prepared to present a course of action for evaluation. It’s a type of pro forma statement. Some examples of pro forma financial statements include projected income statements, balance sheets and cash flow statements.

Projections are based on financial modeling techniques and provide the answers to questions that may come from lenders, investors or other business stakeholders. Essentially, these statements are an answer to the questions, “If we lend you this money, what will you do with it? And how will you pay it back?”

Why Are Financial Projections So Important for Startups and Small Businesses?

Financial projections help you see when you may have financing needs and the best times to make capital expenditures. They help you monitor cash flow, change pricing or alter production plans.

Projections provide all the minutia that lenders might be looking for to better understand your business: how it obtains revenue and where it spends money. Additionally, if your business is ever the target of an acquisition, the financial statements help potential buyers evaluate its worth.

There are subtle differences between the terms projection and forecast. But both describe predictions of future financial performance using financial models. A financial forecast presents predicted outcomes based on the conditions you expect to exist for your business. Projections are financial statements that present an expected financial position given one or more hypothetical assumptions.

For example, Linda’s Linens is growing its sales volume 10% each year, and that growth has been steady for the last 18 months. After examining the financial forecast, it’s reasonable for Linda to assume that growth will continue, and she should plan accordingly. This helps her with inventory planning, hiring decisions and how much to allocate for marketing.

Linda is considering opening a second location. So she prepares a financial projection to show her bank a “what if” scenario to see how much growth she might expect if she received a loan to open another store on the other side of town. The hypothetical situation of opening a new location in the financial projection is what makes it different from the sustained growth she might reasonably suspect in the financial forecast.

What Are Financial Projections Used For?

Financial projections help you realize possible potential in your business. What might happen if you receive outside funding? Or purchase additional equipment? This is where you get to be creative and explore what the future of your business might look like.

Business Plan: Financial projections and business plans go hand-in-hand. It’s a way to show that your company is stable and is financially successful. It’s a good practice to provide quarterly or monthly projections for the first year and annual projections for the four years after that. These include projected income statements, balance sheets, cash flow statements and budgets for capital expenditures. You should be able to explain projections and match them to funding.

Investors: Your potential investors want to know if the business will make money and when they can expect a return on their investment. Some common benchmarks to watch for include how long it will take until the company turns a profit, sales in years three and five, and data showing how your numbers fit in context of your industry.

Loans and Lines of Credit: These are the most common sources of external funding for small businesses. To secure a Small Business Association (SBA) loan, you’ll need a thorough understanding of your finances so you can show the lender how your funds will be used and when the loan will be paid back.

Know your Business: Financial projections show discipline in financial management – and better financial management leads to a much higher chance of business success. By using a financial model to make financial projections, you can see if, when and whether your business will make a profit. You’ll have a better understanding of your cash position to make better decisions about when to hire more people, buy more inventory or make capital investments.

7 Steps to Building a Financial Projection for Your Startup or Small Business

Some common scenarios for projections are monthly projections for year one, quarterly for the next two years and annual thereafter. To build out your financial projections and make them as useful as possible, consider including the following:

• Sales revenue estimates
• Cost of sales or cost of goods sold (COGs)
• Operating costs
• Capital expenditures
• Gross margin by product line
• Sales increase by product line
• Interest rates on debts
• Income tax rate
• Accounts receivable collection plan
• Accounts payable schedule
• Inventory turnover
• Depreciation schedules
• The usefulness or depreciation of assets

Financial projections will usually have a detailed view in a spreadsheet, as well as a summary of some of the most important information. To create this, your business will need a financial model, or a summary of your company’s expenses and earnings. Some of the basic areas to start building financial projections include:

• Create a sales forecast.

What’s driving your sales? That’s where you should start with your projections. For example, if you have a subscription-based web business, correlate sales with estimated website traffic, and conversion rates with the source of traffic. Like a project management platform that sees 1.5% of its traffic from organic Google searches turn into paying customers. The same project management company should also identify conversion rates for customers who land on the site from ads. That way they can estimate how many new customers an increased ad spend or increased organic searches might attract. And finally, the platform should track their churn rate, or how many customers don’t renew their subscription.

For a business that sells physical products, the sales forecast should estimate the number of units it will sell and the price per unit. It’s also helpful to see where and how the items are being sold: How many stores are carrying the products? How are each of those stores performing? The company should factor in things that might affect sales like seasonality. For example, more ice cream and sunscreen are sold in the summer. Is there a seasonality to your product?

• Create an expense budget.

Expenses will include the costs associated with sales, as well as operating expenses. To forecast cost of sales or cost of goods sold (COGS), take all of the current information on the income statement about product cost, fulfillment expense, customer service and merchant fees. Express assumptions about how that will change as a percentage of revenue. Apply the same idea to operating expenses. Consider how headcount, salaries and benefits as well as expenses like advertising, rent and more will change and express everything (with the exception of headcount) as a percentage.

• Create the income statement projection.

Link those assumptions to formulas built in the income statement. The financial model will forecast revenue, net revenue, COGS, gross profit, gross margin, operating expense, operating profit and operating margin. The output of the financial model is the projected income statement.

• Create the cash flow projection.

The projected income statement shows you, as well as potential lenders and investors, if the company is profitable and/or when it is expected to make a profit. The cash flow projection shows your cash position and provides a more detailed view of monthly inflows and outflows of cash for a specific period of time — 3 months, 6 months, 12 months, etc.

• Create the balance sheet projection.

Where the cash flow projection lets you see when there should be cash influxes and dips, the balance sheet shows or projects the worth of your company at any given time. Cash flow projections appear on your balance sheet as assets. On the liabilities side of the balance sheet, you’ll list things like accounts payable and debt.

• Use projections for planning.

Projections are important when seeking new funding. And they help you know when to make capital expenditures. For planning, projections help with analyzing the impact of different business strategies. For example, what if you charge a higher or lower price? What if you’re able to collect invoices faster? Running and testing these various numbers shows how such decisions could affect finances.

Projected financial statements also help you prepare for best and worst case scenarios. You can use projected financial statements to drill down to the product level and know when it will be profitable, when to ramp up production or even when it no longer makes business sense to continue producing it.

By comparing projections against actual results you can see if you’re on target or need to adjust to reach them. Consider purchasing accounting and planning software for financial projections . Tracking performance is much easier and quicker with dashboards and charts that can show you at-a-glance information.

Plan & Forecast More Accurately

Benefits of Using Accounting and Planning Software for Financial Projections

There are advantages to automating financial modeling. You can handle more complex datasets and certain visualization capabilities, as well as streamline financial projections.

• All lines of businesses are connected to the same data, improving control, visibility and trust in the numbers.
• Drill-through capability means you can spend more time drilling into the data to understand the source of the numbers. Finance then has more time to understand the "why" and can better help the business owners understand how their decisions affect the rest of the company.
• You can easily run what-if-scenario analysis to explore different business opportunities.
• Pre-built reports and dashboards make it easy to compare projected vs. actual results.

Automation can increase accuracy save time, and help you compare actual and forecasted results in charts and dashboards. With so much potential, automation is a growing trend. In fact, a survey by Robert Half, a global human resources consulting firm, found that nearly one quarter of respondents expect to automate processes behind financial forecasting.

But even if the analytics associated with financial projection aren’t automated, using technology to automate other parts of the accounting process that go into building the static financial statements provide savings in terms of speed and accuracy.

To run a business, you need to know not just where you are financially, but where you want to be. There is a correlation between how frequently small businesses examine their financial statements and the financial health of their business. The U.S. Small Business Administration found businesses that only look at financial statements annually have a 25% success rate. But those that do it monthly have a success rate of 75%-85%, and those that do it weekly have a 95% success rate. It takes more than just a good idea and dedication to make your business succeed. And accounting software for financial planning is an important tool to keep your company on track to prosperity.

Financial Management

Small Business Financial Management: Tips, Importance and Challenges

It is remarkably difficult to start a small business. Only about half stay open for five years, and only a third make it to the 10-year mark. That’s why it’s vital to make every effort to succeed. And one of the most fundamental…

More On This

Trending Articles

Learn How NetSuite Can Streamline Your Business

NetSuite has packaged the experience gained from tens of thousands of worldwide deployments over two decades into a set of leading practices that pave a clear path to success and are proven to deliver rapid business value. With NetSuite, you go live in a predictable timeframe — smart, stepped implementations begin with sales and span the entire customer lifecycle, so there’s continuity from sales to services to support.

Before you go...

Discover the products that 37,000+ customers depend on to fuel their growth.

Before you go. Talk with our team or check out these resources.

Want to set up a chat later? Let us do the lifting.

NetSuite ERP

Explore what NetSuite ERP can do for you.

Business Guide

Complete Guide to Cloud ERP Implementation

How to Create a Cash Flow Forecast

10 min. read

Updated May 3, 2024

A good cash flow forecast might be the most important single piece of a business plan . All the strategy, tactics, and ongoing business activities mean nothing if there isn’t enough money to pay the bills.

That’s what a cash flow forecast is about—predicting your money needs in advance.

By cash, we mean money you can spend. Cash includes your checking account, savings, and liquid securities like money market funds. It is not just coins and bills.

Profits aren’t the same as cash

Profitable companies can run out of cash if they don’t know their numbers and manage their cash as well as their profits.

For example, your business can spend money that does not show up as an expense on your  profit and loss statement . Normal expenses reduce your profitability. But, certain spending, such as spending on inventory, debt repayment, and purchasing assets (new equipment, for example) reduces your cash but does not reduce your profitability. Because of this, your business can spend money and still be profitable.

On the sales side of things, your business can make a sale to a customer and send out an invoice, but not get paid right away. That sale adds to the revenue in your profit and loss statement but doesn’t show up in your bank account until the customer pays you.

That’s why a cash flow forecast is so important. It helps you predict how much money you’ll have in the bank at the end of every month, regardless of how profitable your business is.

Learn more about the differences between cash and profits .

• Two ways to create a cash flow forecast

There are several legitimate ways to do a cash flow forecast. The first method is called the “Direct Method” and the second is called the “Indirect Method.” Both methods are accurate and valid – you can choose the method that works best for you and is easiest for you to understand.

Unfortunately, experts can be annoying. Sometimes it seems like as soon as you use one method, somebody who is supposed to know business financials tells you you’ve done it wrong. Often that means that the expert doesn’t know enough to realize there is more than one way to do it.

• The direct method for forecasting cash flow

The direct method for forecasting cash flow is less popular than the indirect method but it can be much easier to use.

The reason it’s less popular is that it can’t be easily created using standard reports from your business’s accounting software. But, if you’re creating a forecast – looking forward into the future – you aren’t relying on reports from your accounting system so it may be a better choice for you.

That downside of choosing the direct method is that some bankers, accountants, and investors may prefer to see the indirect method of a cash flow forecast. Don’t worry, though, the direct method is just as accurate. After we explain the direct method, we’ll explain the indirect method as well.

The direct method of forecasting cash flow relies on this simple overall formula:

Cash Flow = Cash Received – Cash Spent

And here’s what that cash flow forecast actually looks like:

Let’s start by estimating your cash received and then we’ll move on to the other sections of the cash flow forecast.

Brought to you by

Create a professional business plan

Using ai and step-by-step instructions.

Secure funding

Validate ideas

Build a strategy

Forecasting cash received

You receive cash from three primary sources: 

1. Sales of your products and services

In your cash flow forecast, this is the “Cash from Operations” section. When you sell your products and services, some customers will pay you immediately in cash – that’s the “cash sales” row in your spreadsheet. You get that money right away and can deposit it in your bank account. You might also send invoices to customers and then have to collect payment. When you do that, you keep track of the money you are owed in  Accounts Receivable . When customers pay those invoices, that cash shows up on your cash flow forecast in the “Cash from Accounts Receivable” row. The easiest way to think about forecasting this row is to think about what invoices will be paid by your customers and when.

2. New loans and investments in your business

You can also receive cash by getting a new loan from a bank or an investment. When you receive this kind of cash, you’ll track it in the rows for loans and investments. It’s worth keeping these two different types of cash in-flows separate from each other, mostly because loans need to be repaid while investments do not need to be repaid.

3. Sales of assets

Assets are things that your business owns, such as vehicles, equipment, or property. When you sell an asset, you’ll usually receive cash from that sale and you track that cash in the “Sales of Assets” section of your cash flow forecast. For example, if you sell a truck that your company no longer needs, the proceeds from that sale would show up in your cash flow statement.

Forecasting cash spent

Similar to how you forecast the cash that you plan on receiving, you’ll forecast the cash that you plan on spending in a few categories:

1. Cash spending and paying your bills

You’ll want to forecast two types of cash spending related to your business’s operations: Cash Spending and Payment of Accounts Payable. Cash spending is money that you spend when you use petty cash or pay a bill immediately. But, there are also bills that you get and then pay later. You track these bills in  Accounts Payable . When you pay bills that you’ve been tracking in accounts payable, that cash payment will show up in your cash flow forecast as “payment of accounts payable”. When you’re forecasting this row, think about what bills you’ll pay and when you’ll pay them. In this section of your cash flow forecast, you exclude a few things: loan payments, asset purchases, dividends, and sales taxes. These will show up in the following sections.

2. Loan Payments

When you make loan repayments, you’ll forecast the repayment of the principal in your cash flow forecast. The interest on the loan is tracked in the “non-operating expense” that we’ll discuss below.

3. Purchasing Assets

Similar to how you track sales of assets, you’ll forecast asset purchases in your cash flow forecast. Asset purchases are purchases of long-lasting, tangible things. Typically, vehicles, equipment, buildings, and other things that you could potentially re-sell in the future. Inventory is an asset that your business might purchase if you keep inventory on hand.

4. Other non-operating expenses and sales tax

Your business may have other expenses that are considered “non-operating” expenses. These are expenses that are not associated with running your business, such as investments that your business may make and interest that you pay on loans. In addition, you’ll forecast when you make tax payments and include those cash outflows in this section. 

Forecasting cash flow and cash balance

In the direct cash flow forecasting method, calculating cash flow is simple. Just subtract the amount of cash you plan on spending in a month from the amount of cash you plan on receiving. This will be your “net cash flow”. If the number is positive, you receive more cash than you spend. If the number is negative, you will be spending more cash than you receive. You can predict your cash balance by adding your net cash flow to your cash balance.

• The indirect method

The indirect method of cash flow forecasting is as valid as the direct and reaches the same results.

Where the direct method looks at sources and uses of cash, the indirect method starts with net income and adds back items like depreciation that affect your profitability but don’t affect the cash balance.

The indirect method is more popular for creating cash flow statements about the past because you can easily get the data for the report from your accounting system.

You create the indirect cash flow statement by getting your Net Income (your profits) and then adding back in things that impact profit, but not cash. You also remove things like sales that have been booked, but not paid for yet.

Here’s what an indirect cash flow statement looks like:

There are five primary categories of adjustments that you’ll make to your profit number to figure out your actual cash flow:

1. Adjust for the change in accounts receivable

Not all of your sales arrive as cash immediately. In the indirect cash flow forecast, you need to adjust your net profit to account for the fact that some of your sales didn’t end up as cash in the bank but instead increased your accounts receivable.

2. Adjust for the change in accounts payable

Very similar to how you make an adjustment for accounts receivable, you’ll need to account for expenses that you may have booked on your income statement but not actually paid yet. You’ll need to add these expenses back because you still have that cash on hand and haven’t paid the bills yet.

3. Taxes & Depreciation

On your income statement, taxes and depreciation work to reduce your profitability. On the cash flow statement, you’ll need to add back in depreciation because that number doesn’t actually impact your cash. Taxes may have been calculated as an expense, but you may still have that money in your bank account. If that’s the case, you’ll need to add that back in as well to get an accurate forecast of your cash flow.

4. Loans and Investments

Similar to the direct method of cash flow, you’ll want to add in any additional cash you’ve received in the form of loans and investments. Make sure to also subtract any loan payments in this row.

5. Assets Purchased and Sold

If you bought or sold assets, you’ll need to add that into your cash flow calculations. This is, again, similar to the direct method of forecasting cash flow.

• Cash flow is about management

Remember: You should be able to project cash flow using competently educated guesses based on an understanding of the flow in your business of sales, sales on credit, receivables, inventory, and payables.

These are useful projections. But, real management is minding the projections every month with plan versus actual analysis so you can catch changes in time to manage them. 

A good cash flow forecast will show you exactly when cash might run low in the future so you can prepare. It’s always better to plan ahead so you can set up a line of credit or secure additional investment so your business can survive periods of negative cash flow.

• Cash Flow Forecasting Tools

Forecasting cash flow is unfortunately not a simple task to accomplish on your own. You can do it with spreadsheets, but the process can be complicated and it’s easy to make mistakes. 

Fortunately, there are affordable options that can make the process much easier – no spreadsheets or in-depth accounting knowledge required.

If you’re interested in checking out a cash flow forecasting tool, take a look at LivePlan for cash flow forecasting. It’s affordable and makes cash flow forecasting simple.

One of the key views in LivePlan is the cash flow assumptions view, as shown below, which highlights key cash flow assumptions in an interactive view that you can use to test the results of key assumptions:

With simple tools like this, you can explore different scenarios quickly to see how they will impact your future cash.

See why 1.2 million entrepreneurs have written their business plans with LivePlan

Tim Berry is the founder and chairman of Palo Alto Software , a co-founder of Borland International, and a recognized expert in business planning. He has an MBA from Stanford and degrees with honors from the University of Oregon and the University of Notre Dame. Today, Tim dedicates most of his time to blogging, teaching and evangelizing for business planning.

Table of Contents

• Profits aren’t the same as cash

Related Articles

10 Min. Read

What Is a Balance Sheet? Definition, Formulas, and Example

8 Min. Read

How to Forecast Personnel Costs in 3 Steps

How to Plan Your Exit Strategy

3 Min. Read

What Is a Break-Even Analysis?

The Bplans Newsletter

The Bplans Weekly

Subscribe now for weekly advice and free downloadable resources to help start and grow your business.

We care about your privacy. See our privacy policy .

The quickest way to turn a business idea into a business plan

Fill-in-the-blanks and automatic financials make it easy.

No thanks, I prefer writing 40-page documents.

Discover the world’s #1 plan building software

Plan Projections

ideas to numbers .. simple financial projections

Home > Financial Projections Template Excel

Financial Projections Template Excel

This free 4 page Excel business plan financial projections template produces annual income statements, balance sheets and cash flow projections for a five year period for any business.

Financial Projections Template Download

What’s included in the financial projection template, 1. income statements.

The first page of the financial projection template shows income statements for the business for 5 years.

2. Balance Sheets

3. Cash Flow Statements

The third page provides the cash flow statements for 5 years.

4. Ratios and Graphs

The final page of the financial projections template contains a selection of useful financial ratios for comparison purposes. In addition it shows revenue, net income, cash balance, and cumulative free cash flow by year in graph form for easy reference.

How to use the Financial Projections Template

If you want to know how to use the financial projections template, then we recommend reading our How to Make Financial Projections post, which explains each step in detail.

More Financial Projections Templates and Calculators

Select a category from the menu to the right or chose one of the templates or calculators below.

Popular Revenue Projection Templates

• Retail Store Revenue Projection
• Drop Shipping Business Revenue Projection
• Sandwich Shop Revenue Projection
• Salon Business Plan Revenue Projection
• Microbrewery Business Plan Revenue Projection

Popular Calculators

• Days Sales Outstanding Calculator
• Return on Investment Calculator
• Sales Forecast Spreadsheet
• Gross Margin Calculator
• Business Operating Expenses Template

Financial projections are critical to the success of your business plan, particularly if the purpose is to raise finance.  Accordingly we have designed our financial projection for startup template to help you test your business idea and create a five year business plan financial projection.

The financial projection template will help you to carry out your own financial projections and test your business idea. Therefore simply amend the highlighted input elements to suit your purposes, and the financial projection template does the rest.

Alternatively, you can use our online calculator to provide a quick and easy way to test the feasibility of your business idea.

About the Author

Chartered accountant Michael Brown is the founder and CEO of Plan Projections. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. Michael has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a BSc from Loughborough University.

Plannit Financial Projections

Take Your Business Plan to the Next Level

Financial projections are a crucial part of any business plan. Plannit AI’s financial projections and income statement generator simplifies the process, allowing entrepreneurs to create accurate, detailed financial forecasts with ease. This feature streamlines the process of generating your initial financial information.

Comprehensive Financial Overview

Our algorithms merge seamlessly with the GPT-4 engine to learn from your revenue model, business information and financial inputs, to automatically generate a comprehensive financial overview for your business plan. This includes an in-depth look at the projected growth rate of the company, the expected revenue, and the anticipated expenses.

10x More Powerful AI

We utilize the GPT-4 engine at our own expense to ensure that you have access to the most powerful AI in the industry. This allows us to provide you with the most accurate and detailed financial overview possible.

Simplified User Experience

Answer a few additional questions to allow us to calculate your financial projections and generate an income statement for your business plan. All in under 30 seconds.

Detailed 3-Year Income Statement

Based on your revenue model, your business information and your financial inputs, we generate a detailed 3-year income statement for your business plan, formatting your vision into dollars.

Simple, Accurate, and Detailed

Plannit only requires a few additional inputs to generate your detailed financial overview and income statement. It also learns from your revenue model and takes industry standards into account.

Increase Your Chances of Getting Funded

Accurate financial projections.

Plannit AI’s financial projections and income statement generator ensures that your business plan is backed by accurate, detailed financial forecasts. This increases your chances of securing funding and support from investors and lenders.

Professional Income Statement

Download your plan with a professional income statement that is formatted to industry standards and editable. This will help you present your business plan in a professional manner and increase your chances of securing funding.

By leveraging Plannit's financial projections and income statement generator, you can ensure that your business plan is backed by a detailed financial overview that puts numbers behind your vision and provides you with a blueprint for a successful outcome.

Create Your Business Plan Today

Pro Forma Financial Statements (with Templates and Examples)

Bryce Warnes

Reviewed by

Janet Berry-Johnson, CPA

April 21, 2022

This article is Tax Professional approved

Pro forma definition

According to Merriam-Webster , “pro forma” means:

• Made or carried out in a perfunctory manner or as a formality
• Based on financial assumptions or projections

I am the text that will be copied.

Pro forma is actually a Latin term meaning “for form” (or today we might say “for the sake of form, as a matter of form”).

When it comes to accounting, pro forma statements are financial reports for your business based on hypothetical scenarios. They’re a way for you to test out situations you think may happen in the future to help you make business decisions.

There are three major pro forma statements:

• Pro forma income statements
• Pro forma balance sheets
• Pro forma cash flow statements

Pro forma statements look like regular statements, except they’re based on what ifs, not real financial results. As in, “What if my business got a $50,000 loan next year?” Your pro forma statements for that scenario would show what your income, account balances, and cash flow would look like with a $50,000 loan.

Since pro forma statements deal with potential outcomes, they’re not considered GAAP compliant . This is because GAAP compliant reports must be based on historical information.

Pro forma statements don’t need to meet the strictest accounting standards , but must be clearly marked as “pro forma” and can’t be used for things like filing taxes. Using pro forma statements that aren’t marked as such to misrepresent your business to investors, the IRS, or financial institutions can be penalized by the Securities and Exchange Commission).

However, pro forma statements are still extremely useful. They can help you make a business plan, create a financial forecast, and even get funding from potential investors or lenders.

Different but related: you can send clients pro forma invoices to let them know how much their order would be if they placed it today.

Why create pro forma statements?

Creating pro forma statements for future scenarios can help you:

• Get financed, by showing lenders or investors how you would use their money to sustainably grow your business.
• Plan for the future, by considering best, worst, and most likely case scenarios in detail.
• Anticipate changes that may affect your business as it grows, such as entering a new tax bracket.

For these purposes, pro forma statements are typically created as a part of a financial forecast in financial accounting. Big corporations who have in-house accountants use pro forma statements for financial modeling and forecasting different scenarios.

Pro forma statements vs. budgets

It may be tempting to think of a pro forma statement as the same as a business budget . After all, you create both in anticipation of the future. And both help you plan how you’ll use your money. But budgets and pro forma statements are two distinct financial tools.

Think of it this way: A pro forma statement is a prediction, and a budget is a plan. Your budget may be based on the financial information of your pro forma statements—after all, it makes sense to make plans based on your predictions.

For example: Your income this year is $37,000. According to your pro forma annual income statement, your financial projections show it will be $44,000 next year. So, when you create next year’s budget, you can include that extra $7,000—maybe spending $4,000 over the course of the year to pay down the principal on a loan , while adding $3,000 to savings.

Types of pro forma statement

There are four main types of pro forma statements. While they all fall into the same categories—income statement, balance sheet, and cash flow statement—they differ based on the purpose of the financial forecast.

1. Full-year pro forma projection

This type of pro forma projection takes into account all of your financials for the fiscal year up until the present time, then adds projected outcomes for the remainder of the year. That can help you show investors or partners what business finances could look like by the end of the fiscal year.

2. Financing or investment pro forma projection

You may be courting investors or trying to convince your business partners of the value of a capital investment or additional financing. In that case, you can use a financing pro forma projection to make your case. It takes into account an injection of cash from an outside source—plus any interest payments you may need to make—and shows how it will affect your business’s financial position.

3. Historical with acquisition pro forma projection

This type of pro forma projection looks at the past financial statements of your business, plus the past financial statements of a business you want to buy . Then it merges them to show what your financials would have looked like if you made a business combination (or merger) earlier. You can use this scenario as a model of what may happen in the future if you buy the other business and restructure now.

4. Risk analysis pro forma projection

Looking at both best case and worst case scenarios helps you make financial decisions based on challenges you may face in the future. For instance, what happens if your main vendor raises their prices like they did last year? Or how will that proposed transaction of buying new equipment impact you long term? Risk analysis lets you take the future for a test ride, and try out different outcomes.

Pro forma templates

To create a pro forma statement, you can use the same template you’d use for a normal financial statement. You may want to use Bench’s free templates:

• Income statement
• Balance sheet
• Cash flow statement

How to create pro forma statements

The sample pro forma statements below may look different from the statements you create, depending on what your template looks like. But generally, these are the steps you need to take to create them—and the info your pro forma statements should include.

Creating a pro forma income statement

There are five steps to creating a pro forma income statement:

• Set a goal for sales in the period you’re looking at. Let’s say you want to increase your income by $18,000 over the course of one year.
• Set a production schedule that will let you reach your goal, and map it out over the time period you’re covering. In this case, you’ll want to earn an additional $1,500 income every month, for 12 months.
• Plan how you’ll match your production schedule. You could do this by growing your number of sales a fixed amount every month, or gradually increasing the amount of sales you make per month. It’s up to you—trust your experience as a business owner.
• It’s time for the “loss” part of “ Profit and Loss .” Calculate the cost of goods sold for each month in your projection. Then, deduct it from your sales. Deduct any other operating expenses you have, as well.
• Prepare your pro forma income statement using data you’ve compiled in the prior four steps.

One note: your pro forma statements will be much more accurate if your bookkeeping is up to date. That way, when you project future periods, you’re basing it off the reality of your business today.

How Bench can help

To predict the future, you first need to understand the past. With Bench, you get a crystal clear image of your financial history so you can focus on planning your future. We’re America’s largest bookkeeping service helping thousands of business owners better understand the financial health of their operations so they can keep focused on growth and planning. When it comes time to create a pro forma statement, you have reliable numbers and reports to get started. We may not be a crystal ball, but we’re the next best thing. Learn more .

Example pro forma income statement:

Rosalia’s Reliable Recordings

Creating a pro forma cash flow statement

You create a pro forma cash flow statement much the same way you’d create a normal cash flow statement. That means taking info from the income statement, then using the cash flow statement format to plot out where your money is going, and what you’ll have on hand at any one time. This pro forma statement can be part of a larger cash flow forecast used for decision making.

Your projected cash flow can give you a few different insights. If it’s negative, it means you won’t have enough cash on-hand to run your business, according to your current trajectory. You’ll have to make plans to borrow money and pay it off.

On the other hand, if net cash flow is positive, you can plan on having enough extra cash on hand to pay off loans, or save for a big investment.

Example pro forma cash flow statement

Mickie’s Murakami Museum

Creating a pro forma balance sheet

By drawing on info from the income statement and the cash flow statement, you can create pro forma balance sheets. However, you’ll also need previous balance sheets to make this useful—so you can see how your business got from “Balance A” to “Balance B.”

The balance sheet will project changes in your business accounts over time. So you can plan where to move money, when.

Example pro forma balance sheet

Daily Dumpling Deliveries

Once you’ve created your pro forma income statements, and cast your eyes forward to the future of your business, you can start planning how you’ll spend your money. It’s time to create a small business budget .

Related Posts

Modified Cash Basis: What Is It? Who Should Use It?

Just when you thought you had the basics of cash basis and accrual basis accounting covered, there’s a third option to throw into the mix: modified cash basis.

The Basics of Small Business Accounting: A How-to

New to business? Learn the fundamentals of small business accounting, and set your financials up for success.

How to Create a Financial Forecast

A financial forecast tries to predict what your business will look like (financially) in the future—which is key for uncertain, economic times.

Join over 140,000 fellow entrepreneurs who receive expert advice for their small business finances

Get a regular dose of educational guides and resources curated from the experts at Bench to help you confidently make the right decisions to grow your business. No spam. Unsubscribe at any time.

Planning, Startups, Stories

Tim berry on business planning, starting and growing your business, and having a life in the meantime., standard business plan financials: projected balance.

This is another in a series of posts on standard business plan financials, continuing from last week.

“Think of it as your business dashboard, providing a snapshot of the financial health of your company at a specific moment in time. The purpose is simple: balance sheets list assets, liabilities and owner equity, typically in order from shortest- to longest-term assets and liabilities divided on either side of the balance sheet.”

Financial Post

The Balance Sheet includes spending and income that isn’t in the Profit and Loss. For example, the money you spend to repay a loan or buy new assets doesn’t show up in the Profit and Loss. And the money you take in as a new loan or a new investment doesn’t show up in the Profit and Loss either. The money you are waiting to receive from customers’ outstanding invoices shows up in the Balance Sheet, not the Profit and Loss. The Balance Sheet shows many reasons why profits are not cash, and why cash flow isn’t intuitive. It’s all related to the essential principles of cash flow .

The Balance Sheet shows your financial picture – assets, liabilities, and capital – at some specific moment. It helps to understand that the Profit and Loss shows financial performance over a length of time, like a month, quarter, or year. The Balance, in contrast, is a moment. Usually it’s the end of the month, quarter, or year. Sometimes it’s the end of the business day.

Balancing is a common term associated with bookkeeping, accounting, and finance. We “balance the books.” It’s a lot like reconciling a checkbook: if it isn’t right down to the last penny, then it’s wrong. Assets have to equal liabilities plus capital. Always.

A traditional Balance Sheet statement shows assets on the left side and liabilities and capital on the right side or the bottom, as in this illustration:

The balance sheet involves the other three of the six key financial terms (the ones that aren’t on the Profit and Loss: Assets, Liabilities, and Capital).

• Assets. Cash, accounts receivable, inventory, land, buildings, vehicles, furniture, and other things the company owns. Assets can usually be sold to somebody else. One definition is “anything with monetary value that a business owns.”
• Liabilities. Debts, notes payable, accounts payable, amounts of money owed to be paid back.
• Capital (also called equity). Ownership, stock, investment, retained earnings. Actually there’s an iron-clad and never-broken rule of accounting: Assets = Liabilities + Capital. That means you can subtract liabilities from assets to calculate capital.

Although traditional printed balance sheet statements are usually arranged horizontally, as in the illustration above, balance sheets in financial projections are usually arranged vertically, showing the assets first, then the liabilities, and then the capital. Here, for example, is the balance sheet for the first few months of the bike store I mentioned earlier. It’s the balance sheet associated with the Profit and Loss for the same company, Garrett’s bicycle store:

This is planning, not accounting . It’s one of the primary principles of the lean business planning. To make a powerful and useful cash flow projection, you need to summarize and aggregate the rows of the balance sheet. Resist the temptation to break it down into detail the way you would with a tax report after the fact. This is a tool to help you forecast your cash.

The Link Between Balance and Profit

The balance sheet is so different from the Profit and Loss that there is only one direct link between the two, a vital one that connects them so that when the books are right, the balance balances: That is the direct line from profits (Net Profits) on the Profit and Loss to Earnings and Retained Earnings on the Balance Sheet. The illustration here shows the link with the bicycle store sample:

[…] Balance Sheet that shows your current assets and […]

How can I make a well representable business plan. Which I can be able to look for funding

Darren, that’s what bplans.com is all about. Start here: Business Plan Guide

When creating a business plan, is it important to show a 3 year balance sheet?

Craig, depends on context. Is it for investors? For your own use? For a lean plan, cash flow may be enough, but it’s hard to do cash flow without a summarized balance. If you want a full formal business plan, a summarized balance sheet is part of what we’d call full financials. But of course it depends on the specific context of the plan. Tim

how can i draw a balance sheet for my business plan..since the no activity has started

@Brenda. As soon as you have either capital, assets, or liabilities assigned to your business, you have a balance sheet. Correct double-entry bookkeeping will ensure that the sum of your capital and liabilities are equal to your total assets. For projections, looking ahead, you estimate ahead-of-time what you think will need to happen with your capital, liabilities, and assets. Obviously these are estimated guesses. Then as your business launches, you regularly compare actual results to what you had expected, which helps you manage.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.

The quickest way to turn a business idea into a business plan

Fill-in-the-blanks and automatic financials make it easy.

No thanks, I prefer writing 40-page documents.

Discover the world’s #1 plan building software

• Search Search Please fill out this field.
• Building Your Business
• Becoming an Owner
• Business Plans

6 Small Business Financial Statements for Startup Financing

Financial Statements You'll Need for Your Startup Business Plan

You're ready to start your small business and your're working on a great business plan to take to a bank or other lender. A key part of that plan is the financial statements. These statements will be looked at carefully by the lender, so here are some tips for making these documents SELL your business plan . 

Financial Statements You Will Need

You may need several different types of statements, depending on the requirements of your lender and your own technical expertise. 

The statements you will certainly need are:

• A startup budget or cash flow statement
• A startup costs worksheet
• A pro forma (projected) profit and loss statement
• A pro forma (projected) balance sheet 

Your lender may also want these financial statements: 

• Sources and uses of funds statement
• Break-even analysis

Putting these Statements in Order

First, work on your startup budget and your startup costs worksheet. You'll need to do a lot of estimating.

The trick is to underestimate income and overestimate expenses, so you can create a more realistic picture of your business over the first year or two.

Then work on a profit and loss statement for the first year. A lender will definitely want to see this one. And, even though it's not going to be accurate, lenders like to see a startup balance sheet. 

Some lenders may ask for a break-even analysis, a cash flow statement, or a sources and uses of funds statement. We'll go over these statements so you can quickly provide them if asked.

Business Startup Budget

 A startup budget is like a projected cash flow statement, but with a little more guesswork.

Your lender wants to know your budget - that is, what you expect to bring in and how much to expect to spend each month. Lenders want to know that you can follow a budget and that you will not over-spend. 

They also want to see how much you will need to pay your bills while your business is starting out (working capital), and how long it will take you to have a positive cash flow (bring in more money than you are spending). 

Include some key information on your budget:

• What products or services you are selling, including prices and estimated volumes
• Key drivers for expenses, like how many employees you'll need and your marketing initiatives  

A typical budget worksheet should be carried through three years, so your lender can see how you expect to generate the cash to make your monthly loan payments.

Startup Costs Worksheet

A startup costs worksheet answers the question "What do you need the money for?" In other words, it shows all the purchases you will need to make in order to open your doors for business. This could be called a "Day One" statement  because it's everything you will need on your first day of business. 

• Facilities costs, like deposits on insurance and utilities
• Office equipment, computers, phones
• Supplies and advertising materials like signs and business cards
• Fees to set up your business website and email
• Legal fees licenses and permits

Profit and Loss Statement/Income Statement

After you have completed the monthly budget and you have gathered some other information, you should be able to complete a Profit and Loss  or Income Statement. This statement shows your business activity over a specific period of time, like a month, quarter, or year.

To create this statement, you'll need to list all your sources to get your gross income over that time. Then, list all expenses for the same time.

Because you haven't started yet, this statement is a called a projected P&L, because it projects out your estimates into the future.  

This statement gathers up all your sources of income, including shows your profit or loss for the year and how much tax you estimate having to pay.

Break-Even Analysis

A break-even analysis shows your lender that you know the point at which you will start making a profit or the price that will cover your fixed costs . The break-even analysis is primarily for businesses making or selling products, or to set the right price for a product or service.  

It's usually shown as a graph with sales volume on the X axis and revenue on the Y axis. Then fixed an variable costs (those you must pay) are included. The break-even point marks the place where costs are covered.

This analysis can also be useful for service-type businesses to show an overall profit point for specific services. If you include a break-even analysis, be sure you can explain it.

Beginning Balance Sheet

A startup balance sheet is difficult to prepare, even if there isn't much to include. The balance sheet shows the value of the assets you have purchased for startup, how much you owe to lenders and other creditors, and any initial investments you have made to get started. The date for this spreadsheet is the day you open the business.

Sources and Uses of Funds Statement

Large businesses use Sources and Uses of Funds statements in their annual reports, but you can create a slightly different simple statement to show your lender what you need the money for, what sources you have already, and what's left over to be financed.

To create this statement, list all your startup and working capital(on-going cash needs), how much collateral you will be bringing to the business, other sources of funding, and how much you need to borrow. 

Optional: A Business Requirements Document

 A business requirements document is similar to a proposal document, but for a larger, more complex project or startup. It gives a complete picture of the project or the business plan. It goes into more detail on the project that will be using the financial statements. 

Include Financial Statements in Your Business Plan

You will need a complete startup business plan to take to a bank or other business lender. The financial statements are a key part of this plan. Give the main points in the executive summary and include all the statements in the financial section. 

Finally, Check for Mistakes!

Before you submit your startup business plan and financial statements, check this list. Don't make these  common business plan mistakes !

Check all numbers for accuracy and consistency. Especially make sure the amounts you are requesting are specific and that they are the same throughout all the parts of your business plan.

SCORE.org. " How to Set Up and Maintain a Budget for Your Small Business ." Accessed Sept. 10, 2020.

SCORE.org. " Financial Projections Template ." Accessed Sept. 10, 2020.

Harvard Business Review. " A Quick Guide to Breakeven Analysis ." Accessed Sept. 10, 2020.

Financial Assumptions and Your Business Plan

Written by Dave Lavinsky

Financial assumptions are an integral part of a well-written business plan. You can’t accurately forecast the future without them. Invest the time to write solid assumptions so you have a good foundation for your financial forecast.

Download our Ultimate Business Plan Template here

What are Financial Assumptions?

Financial assumptions are the guidelines you give your business plan to follow. They can range from financial forecasts about costs, revenue, return on investment, and operating and startup expenses. Basically, financial assumptions serve as a forecast of what your business will do in the future. You need to include them so that anyone reading your plan will have some idea of how accurate its projections may be.

Of course, your financial assumptions should accurately reflect the information you’ve given in your business plan and they should be reasonably accurate. You need to keep this in mind when you make them because if you make outlandish claims, it will make people less likely to believe any part of your business plan including other financial projections that may be accurate.

That’s why you always want to err on the side of caution when it comes to financial assumptions for your business plan. The more conservative your assumptions are the more likely you’ll be able to hit them, and the less likely you’ll be off by so much that people will ignore everything in your plan.

Why are Financial Assumptions Important?

Many investors skip straight to the financial section of your business plan. It is critical that your assumptions and projections in this section be realistic. Plans that show penetration, operating margin, and revenues per employee figures that are poorly reasoned; internally inconsistent, or simply unrealistic greatly damage the credibility of the entire business plan. In contrast, sober, well-reasoned financial assumptions and projections communicate operational maturity and credibility.

For instance, if the company is categorized as a networking infrastructure firm, and the business plan projects 80% operating margins, investors will raise a red flag. This is because investors can readily access the operating margins of publicly-traded networking infrastructure firms and find that none have operating margins this high.

As much as possible, the financial assumptions should be based on actual results from your or other firms. As the example above indicates, it is fairly easy to look at a public company’s operating margins and use these margins to approximate your own. Likewise, the business plan should base revenue growth on other firms. 

Many firms find this impossible, since they believe they have a breakthrough product in their market, and no other company compares. In such a case, base revenue growth on companies in other industries that have had breakthrough products. If you expect to grow even faster than they did (maybe because of new technologies that those firms weren’t able to employ), you can include more aggressive assumptions in your business plan as long as you explain them in the text.

The financial assumptions can either enhance or significantly harm your business plan’s chances of assisting you in the capital-raising process. By doing the research to develop realistic assumptions, based on actual results of your or other companies, the financials can bolster your firm’s chances of winning investors. As importantly, the more realistic financials will also provide a better roadmap for your company’s success.

    Finish Your Business Plan Today!

Financial assumptions vs projections.

Financial Assumptions – Estimates of future financial results that are based on historical data, an understanding of the business, and a company’s operational strategy.

Financial Projections – Estimates of future financial results that are calculated from the assumptions factored into the financial model.

The assumptions are your best guesses of what the future holds; the financial projections are numerical versions of those assumptions. 

Key Assumptions By Financial Statement

Below you will find a list of the key business assumptions by the financial statement:

Income Statement

The income statement assumptions should include revenue, cost of goods sold, operating expenses, and depreciation/amortization, as well as any other line items that will impact the income statement.

When you are projecting future operating expenses, you should project these figures based on historical information and then adjust them as necessary with the intent to optimize and/or minimize them.

Balance Sheet

The balance sheet assumptions should include assets, liabilities, and owner’s equity, as well as any other line items that will impact the balance sheet. One of the most common mistakes is not including all cash inflows and outflows.

Cash Flow Statement

Cash flow assumptions should be made, but they do not impact the balance sheet or income statement until actually received or paid. You can include the cumulative cash flow assumption on the financial model to be sure it is included with each year’s projections. 

The cumulative cash flow assumption is useful for showing your investors and potential investors how you will spend the money raised. This line item indicates how much of the initial investment will be spent each year, which allows you to control your spending over time.

Notes to Financial Statements

The notes to financial statements should explain assumptions made by management regarding accounting policies, carrying value of long-lived assets, goodwill impairment testing, contingencies, and income taxes. It is important not only to list these items within the notes but also to provide a brief explanation.

What are the Assumptions Needed in Preparing a Financial Model?

In our article on “ How to Create Financial Projections for Your Business Plan ,” we list the 25+ most common assumptions to include in your financial model. Below are a few of them:

For EACH key 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?

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?

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?

Assumptions related to 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 is the number of years in which your debt (loan) must be paid back

Properly Preparing Your Financial Assumptions

So how do you prepare your financial assumptions? It’s recommended that you use a spreadsheet program like Microsoft Excel. You’ll need to create separate columns for each line item and then fill in the cells with the example information described below.

Part 1 – Current Financials

Year to date (YTD) units sold and units forecast for next year. This is the same as YTD revenue, but you divide by the number of days in the period to get an average daily amount. If your plan includes a pro forma financial section, your financial assumptions will be projections that are consistent with the pro forma numbers.

Part 2 – Financial Assumptions

Estimated sales forecasts for next year by product or service line, along with the associated margin. List all major items in this section, not just products. For instance, you might include “Professional Services” as a separate item, with revenue and margin information.

List the number of employees needed to support this level of business, including yourself or key managers, along with your cost assumptions for compensation, equipment leasing (if applicable), professional services (accounting/legal/consultants), and other line items.

Part 3 – Projected Cash Flow Statement and Balance Sheet

List all key assumptions like: sources and uses of cash, capital expenditures, Planned and Unplanned D&A (depreciation & amortization), changes in operating assets and liabilities, along with those for investing activities. For example, you might list the assumptions as follows:

• Increases in accounts receivable from customers based on assumed sales levels
• Decreases in inventory due to increased sales
• Increases in accounts payable due to higher expenses for the year
• Decrease in unearned revenue as evidenced by billings received compared with those projected (if there is no change, enter 0)
• Increase/decrease in other current assets due to changes in business conditions
• Increase/decrease in other current liabilities due to changes in business conditions
• Increases in long term debt (if necessary)
• Cash acquired from financing activities (interest expense, dividends paid, etc.)

You make many of these assumptions based on your own experience. It is also helpful to look at the numbers for public companies and use those as a benchmark.

Part 4 – Future Financials

This section is for more aggressive financial projections that can be part of your plan, but which you cannot necessarily prove at the present time. This could include:

• A projection of earnings per share (EPS) using the assumptions above and additional information such as new products, new customer acquisition, expansion into new markets
• New product lines or services to be added in the second year. List the projected amount of revenue and margin associated with these items
• A change in your gross margins due to a specific initiative you are planning, such as moving from a high volume/low margin business to a low volume/high margin business

Part 5 – Calculations

Calculate all critical financial numbers like:

• Cash flow from operating activities (CFO)
• Operating income or loss (EBITDA)  (earnings before interest, taxes, depreciation, and amortization)
• EBITDA margin (gross profits divided by revenue less cost of goods sold)
• Adjusted EBITDA (CFO plus other cash changes like capital expenditure, deferred taxes, non-cash stock compensation, and other items)
• Net income or loss before tax  (EBT)
• Cash from financing activities (increase/decrease in debt and equity)

Part 6 – Sensitivity Analysis

If your assumptions are reasonably accurate, you will have a column for “base case” and a column for “worst case.”  If you have a lot of variables with different possible outcomes, just list the potential range in one cell.

Calculate both EBITDA margins and EPS ranges at each level.

Part 7 – Section Highlights

Just list the two or three key points you want to make. If it is hard to distill them down, you need to go back and work on Part 3 until it makes sense.

Part 8 – Financial Summary

Include all the key numbers from your assumptions, section highlights, and calculations. In one place, you can add up CFO, EPS at different levels, and EBITDA margins under both base case and worst-case scenarios to give a complete range for each assumption.

The key to a successful business plan is being able to clearly communicate your financial assumptions. Be sure to include your assumptions in the narrative of your plan so you can clearly explain why you are making them. If you are using the business plan for financing or other purposes, it may also be helpful to include a separate “financials” section so people unfamiliar with your industry can quickly find and understand key information.

How to Finish Your Business Plan in 1 Day!

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

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

It includes a full financial model. It lists all the key financial assumptions and you simply need to plug in answers to the assumptions and your complete financial projections (income statement, balance sheet, cash flow statement, charts and graphs) are automatically generated!

Click here to see how Growthink’s professional business plan consulting services can create your business plan for you.

OR, Let Us Develop Your Plan For You

Since 1999, Growthink has developed business plans for thousands of companies who have gone on to achieve tremendous success.

Click here to see how our professional business plan writers can create your business plan for you.

If you just need a financial model for your business plan, learn more about our financial modeling services .  

Other Resources for Writing Your Business Plan

• How to Write an Executive Summary
• How to Expertly Write the Company Description in Your Business Plan
• How to Write the Market Analysis Section of a Business Plan
• The Customer Analysis Section of Your Business Plan
• Completing the Competitive Analysis Section of Your Business Plan
• How to Write the Management Team Section of a Business Plan + Examples
• How to Create Financial Projections for Your Business Plan
• Everything You Need to Know about the Business Plan Appendix
• Business Plan Conclusion: Summary & Recap

Other Helpful Business Plan Articles & Templates