CFO & Financial Advisory

Hook Sales may look strong on paper, but payroll, supplier invoices, taxes, loan payments, and late customer collections can quickly reduce available cash. Without a clear projection, a small business may discover a funding gap only after it needs the money. Introduction Financial projections connect expected revenue, expenses, profit, cash flow, assets, liabilities, and funding needs into one forward-looking plan. They help owners decide when to hire, increase spending, borrow, preserve cash, or change pricing. A useful projection commonly includes a projected income statement, cash flow statement, and balance sheet. Businesses seeking funding may also need capital expenditure forecasts and detailed assumptions that support the numbers. This guide shows you how to build financial projections from realistic business assumptions, connect the numbers, test different outcomes, and use the forecast for better decisions. Key Takeaways Here is a quick look at the main things you will learn in this guide: Turn sales, pricing, customer, and cost assumptions into forecast numbers. Build projected income, cash flow, and balance sheet figures that connect. Identify potential break-even points and cash shortages. Test results under slower sales, higher costs, and stronger growth. Improve forecasts by comparing projections with actual results. Table of Contents Start With the Numbers You Already Have Build Revenue From Real Sales Drivers Forecast Fixed and Variable Costs Turn Your Assumptions Into a Projected Income Statement Build a Monthly Cash Flow Projection Add Assets, Liabilities and Equity to the Forecast Calculate Break-Even and Funding Needs Test Best-Case, Base-Case and Worst-Case Results Include Taxes, Debt and Major Business Purchases Check Whether Your Financial Projections Make Sense Choose the Right Forecasting Period and Format Update Your Projections as Actual Results Change Start With the Numbers You Already Have Begin with reliable historical figures instead of guessing future results. Your accounting records provide the baseline for realistic assumptions. Review Past Revenue Check monthly sales, customer volumes, pricing, and seasonal patterns. Review Operating Costs Separate recurring costs from costs that change with sales volume. Check Cash Movement Review customer collections, supplier payments, payroll, taxes, and debt payments. Identify Major Changes Record planned hiring, expansion, new contracts, price changes, or financing. Build Revenue From Real Sales Drivers Revenue forecasts work better when you build them from measurable business activity. Start with the drivers that directly create sales. Customers: Estimate new, repeat, and lost customers. Units: Forecast products or services sold. Pricing: Apply expected prices to forecast volumes. Contracts: Include signed and likely recurring contracts. Seasonality: Adjust sales for predictable demand changes. Collections: Estimate when customers will actually pay. Forecast Fixed and Variable Costs Cost forecasts should reflect how each expense behaves as the business grows. Separate stable costs from expenses that move with revenue. Rent: Include recurring property and facility costs. Payroll: Forecast existing staff, raises, and planned hires. Supplies: Link usage and purchasing to expected sales. Marketing: Include planned campaigns and recurring spend. Utilities: Estimate recurring costs and expected changes. Variable Costs: Connect commissions, shipping, materials, and similar costs to sales. Turn Your Assumptions Into a Projected Income Statement The income statement shows how expected revenue and expenses may affect future profit. Build it from operating assumptions rather than applying a single growth percentage to every line. Forecast Revenue Enter expected sales by product, service, customer group, or revenue stream. Forecast Cost of Sales Estimate direct costs required to deliver the projected sales. Forecast Operating Expenses Include payroll, rent, marketing, technology, insurance, and other operating costs. Calculate Expected Profit Subtract projected costs and expenses from revenue to estimate operating and net profit. Build a Monthly Cash Flow Projection Profit does not show when money enters or leaves the bank account. A monthly cash flow projection tracks the timing of those movements. Opening Cash: Start each month with the previous month’s closing balance. Customer Receipts: Record expected collection dates. Operating Payments: Schedule payroll, suppliers, rent, and other payments. Tax Payments: Include expected tax payment dates and amounts. Debt Payments: Add principal and interest payments. Closing Cash: Calculate available cash after all projected movements. Add Assets, Liabilities and Equity to the Forecast The balance sheet completes the financial picture by showing what the business owns, owes, and retains. Each projected balance should connect with the income statement and cash flow forecast. Forecast Working Capital Estimate receivables, inventory, and payables based on expected operating activity. Add Fixed Assets Include equipment, vehicles, technology, property, and other planned purchases. Record Depreciation Apply appropriate depreciation assumptions to forecast asset values and expenses. Forecast Debt Add new borrowing, principal repayments, interest, and closing loan balances. Project Equity Reflect retained earnings, owner contributions, and planned distributions. Check the Accounting Equation Confirm that projected assets equal projected liabilities plus equity. Calculate Break-Even and Funding Needs Break-even analysis shows the sales level needed to cover fixed and variable costs. Funding analysis then shows how much cash the business may need before it reaches that point. Fixed Costs: Identify costs that remain stable over the forecast period. Variable Costs: Calculate costs that change with sales volume. Contribution Margin: Measure the amount each sale contributes toward fixed costs. Break-Even Sales: Calculate the revenue level needed to cover total costs. Cash Shortfall: Identify months where projected cash falls below the required minimum. Funding Requirement: Estimate the amount and timing of external or internal funding. Test Best-Case, Base-Case, and Worst-Case Results A single forecast can hide the effect of changing business conditions. Scenario analysis shows how different assumptions affect revenue, profit, and cash. Base-Case Scenario Use the assumptions that currently have the strongest support. Best-Case Scenario Model stronger sales, improved margins, faster collections, or lower costs. Worst-Case Scenario Model weaker sales, higher expenses, delayed collections, or unexpected costs. Compare Key Results Review revenue, profit, cash balance, break-even timing, and funding needs across each scenario. Include Taxes, Debt, and Major Business Purchases These items can materially change cash requirements even when operating results remain stable. Include them in the forecast instead of treating them as separate calculations. Taxes: Estimate tax liabilities and expected payment dates. Loan Principal: Record scheduled principal […]