Building Financial Projections for Your Plan

Financial projections are a critical part of any business plan. They allow you to forecast your revenue, expenses, and profitability over the next 3-5 years. Accurate financial projections will lend credibility to your business plan and provide insight into the financial viability of your business. 

In this comprehensive guide, we’ll walk through the key elements of building financial projections for your startup or small business. We’ll look at the major financial statements you should include, how to forecast sales, estimate expenses, conduct break-even analysis, build financial scenarios, and present your projections visually. With realistic projections in place, you’ll be prepared to seek funding, manage operations, and track the financial performance of your business.

The Importance of Financial Projections

Financial projections are important for several key reasons:

– Test business model viability. Projections allow you to model your revenue and costs to see if your business will be profitable. This helps test assumptions in your business model.

– Secure funding. Most investors or lenders will want to see financial projections to gauge the business’s ability to generate a return on their investment.

– Guide business operations. Once launched, you’ll refer back to your projections to track performance and make adjustments to your operations.

– Attract key hires. Financial projections will help prospective employees and partners understand your growth strategy.

To build credible projections, base your forecasts on market research, industry benchmarks, operating data, and careful financial analysis. Avoid simply guessing or being overly optimistic in your forecasts.

Types of Financial Statements to Include

A complete set of financial projections includes three main documents:

– Income statement

– Balance sheet  

– Cash flow statement

Let’s look at what each statement includes.

Income Statement

The income statement forecasts the revenue earned and expenses incurred over a period of time. It provides an overview of your company’s profitability.

Elements of the income statement include:

– Revenue: All sales and income streams

– Cost of goods sold: Direct costs to produce products/services

– Gross margin: Revenue minus COGS 

– Operating expenses: Rent, payroll, utilities, etc. 

– EBITDA: Earnings before interest, taxes, depreciation, and amortization

– EBT: Earnings before taxes

– Net income: Total profits after taxes

Aim to forecast income statement line items quarterly for the first year and annually thereafter.

Balance Sheet 

The balance sheet provides a snapshot of your company’s financial position at a given point in time. It outlines your assets, liabilities, and equity.

Key elements include:

– Assets: What the company owns, including cash, accounts receivable, inventory, and fixed assets like real estate and equipment

– Liabilities: What the company owes, including accounts payable and long-term debt

– Equity: Owners’ investment and retained earnings

Update your balance sheet projections annually. Ensure assets always equal liabilities plus equity.

Cash Flow Statement

While an income statement shows profitability and a balance sheet depicts financial position, the cash flow statement shows how changes in balance sheet accounts affect cash.

Cash flow statements have three sections:

– Operating activities: How revenue and expenses drive cash inflows/outflows

– Investing activities: Cash used to acquire assets 

– Financing activities: Cash from loans, equity, etc.

Project your cash flow statement annually at minimum. Cash flow statements help anticipate future cash shortfalls.

With an overview of the three key financial statements, let’s look at how to forecast each statement’s components.

Building Your Sales Forecast

Since revenue is a key input across all financial statements, take time to build a realistic sales forecast. Consider these best practices when projecting revenue:

– Start with market research: Estimate market and industry size using reports or tools like IBISWorld. Assess growth factors.  

– Factor in economic conditions: Account for the overall economic climate and business cycle.

– Define pricing strategy: Price products/services based on customer willingness to pay and competitive pricing.

– Estimate market share: Forecast share of the total addressable market you can realistically capture.

– Account for seasonality: Consider how sales may fluctuate at different times of year.

– Project growth rates: Estimate annual growth in a conservative, defensible manner based on industry benchmarks.

– Build revenue scenarios: Create upside/downside cases by adjusting growth rates up or down.

Thoroughly document your sales assumptions to defend your forecast. Phase revenue in gradually in the first year to be realistic.

Estimating Expenses

With revenue projected, forecast major expense categories using historical data, research, and industry metrics.

– Cost of goods sold: Estimate raw material and production costs for each product. Gauge economies of scale.

– Operating expenses: Research typical spends for your type/size of business. Weigh fixed vs. variable costs.

– Staffing: Project headcount by role at various growth phases. Calculate payroll, benefits, and HR costs.

– Occupancy: Evaluate real estate options and associated rent and utilities costs.

– Marketing: Budget for initiatives across channels like digital ads, events, content, etc. 

– Professional services: Project one-time and recurring fees for legal, accounting, consulting, etc.

Benchmark against competitors. Consider how expenses may evolve over time as your business scales.

Putting Together an Income Statement

With revenue and expenses forecasted, you can compile your income statement projections. Simple income statement formulas include:

– Gross margin = Revenue – COGS

– EBITDA = Gross margin – operating expenses  

– EBT = EBITDA – depreciation/amortization – interest

– Net income = EBT – taxes

Build your income statement in Excel or using accounting software. Project monthly for the first year and annually thereafter.

Verify net income flows through to the balance sheet and cash flow statement. Make adjustments to improve profitability if needed.

Creating a Balance Sheet 

Your balance sheet will evolve each year as assets, liabilities, and equity change. Consider these tips for forecasting each component:

– Assets: Calculate changes in cash, accounts receivable, inventory, and fixed assets annually. Factor in depreciation.

– Liabilities: Project account payables, debt drawdowns, and repayments over time. Include interest.

– Equity: Model equity injections from founders as well as retained earnings.

Ensure total assets always equal total liabilities plus total equity. Aim for assets to exceed liabilities over time.

Projecting Cash Flows

With income statement and balance sheet projections complete, compile your cash flow statement:

– Operating activities: Start with net income. Add back depreciation. Adjust for changes in accounts receivable, accounts payable, inventory.

– Investing activities: Calculate outlays for fixed asset purchases and disposals.

– Financing activities: Factor in equity injections, new debt, principal repayments, dividends.

Evaluate if you have positive or negative cash flow each period. Adjust operations or financing if needed to maintain adequate cash reserves.

Conducting Break-Even Analysis

An important supplemental projection is your break-even analysis. Here are steps to complete this:

– Calculate fixed costs: Add fixed operating expenses like rent and payroll. Include fixed financing costs.

– Determine variable costs: Identify costs that fluctuate with volume like materials and commissions. State as variable cost per unit.

– Price your product: Establish an appropriate price per unit based on margins and competitive pricing.

– Compute break-even point: Use this formula:

Fixed costs / (Price per unit – Variable cost per unit)

The break-even point shows the volume you need to cover costs and start generating profits. Compare this to your sales forecast. Ensure you forecast profitability well before the break-even point.

Building Different Scenarios

Rather than a static set of projections, consider multiple scenarios for revenue growth, cost assumptions, external events, and other variables:

– Best case: Model projections if variables exceed expectations 

– Worst case: Model projections if assumptions fall short or risks occur

– Most likely case: Base this on realistic, defensible assumptions

Building scenarios allows you to stress test your business model and prepare contingency plans. Make sure even your “worst case” projections put you on a path to sustainability.

Presenting Your Financials Visually

Financial projections are full of complex data. Simplify your projections for readers by presenting them visually:

– Charts showing sales growth  

– Key metrics summaries

– Dashboard highlighting critical projection data

– Dynamic modeling allowing variables to be adjusted

Visualizations make your projections more engaging and easy to digest. Consider using tools like Excel, data visualization software, or financial modeling platforms.

Key Takeaways

Here are some key tips to build accurate, credible financial projections:

– Research rigorously to make reasonable revenue and cost assumptions

– Project 3+ years of income statements, balance sheets, cash flows

– Model best, worst, and most likely case scenarios

– Break-even analysis helps assess profitability

– Present projections visually for easy analysis

– Update projections as actual data comes in

Realistic financial projections will be immensely valuable as you launch and operate your business. Savvy modeling will help you anticipate challenges, capitalize on opportunities, and monitor performance. Take time to thoroughly build and vet your business’s financial projections.