Financial analysis for a business plan: actuals to funding

Financial analysis for a business plan connects actual performance to the revenue, costs and cash requirements of the proposed business. It should let a reader trace each material assumption to evidence and see how a change affects both profit and funding. The deliverable is a financial section with linked statements and an explanation of their drivers.

Start with the financial section you need to produce

For an established business, the SBA's business-plan guidance calls for historical income statements, balance sheets and cash flow statements, followed by prospective statements and capital expenditure budgets. It recommends more detailed projections for the first year and matching those projections to the funding request.

Use that structure as a checklist. Prepare historical results, the assumptions register, projected statements, investment and funding schedules, and a short explanation of the main changes. The operating assumptions must agree with the sales and staffing sections elsewhere in the plan. A sales territory plan, for example, can support assigned account coverage; it does not by itself prove that orders will arrive.

This differs from a business case financial analysis, which compares a proposed change with a baseline. Here the financial section describes the whole business over the plan horizon.

Build the starting point from actual exports

Bring the monthly trial balance, sales register, payroll or operating-cost export, receivables and payables balances, fixed-asset register and debt schedule. Label every row with its period, entity, account and actual-or-plan status. Use one currency and one consistent expense classification.

Reconcile sales to the income statement, closing receivables to the aging report, and cash to the bank reconciliation. Keep the latest closed actual period intact. An unfinished month mixed into a completed year creates a false base for growth.

The finance lead owns these ties. Sales owns volume and realized-price assumptions; operations owns capacity and delivery costs; budget owners confirm spending commitments. Record an owner, supporting document and review date beside each material assumption.

For a simpler monthly review before preparing the plan, use financial analysis for small business. The plan needs that reliable starting point before it adds prospective claims.

Connect operating drivers to the income statement

Consider an illustrative US commercial-services company. Its completed jobs and realized prices reconcile to annual revenue. Put labels in column A, 2025 actuals in B and the 2026 plan in C. Dollar amounts are USD; percentages are rounded to one decimal place.

For planned revenue in C4, enter:

=C2*C3

Cost of services in C6 is =C2*C5, gross profit in C7 is =C4-C6, operating profit in C10 is =C7-SUM(C8:C9), and gross margin in C11 is =C7/C4. Use the equivalent B references for actuals.

Revenue rises by 30.0%, from 1,560,000 / 1,200,000 - 1. The explanation is not simply that management expects growth. Jobs increase by 25.0% and realized price by 4.0%; both need evidence. Check the revenue bridge:

The bridge equals the projected statement. Next check whether staffing and equipment can deliver the planned jobs. Use gross profit margin for the detailed treatment of direct-cost classification rather than changing definitions to improve the plan.

Prove that profit turns into a funded cash plan

The SEC's financial-statement guide explains that income and cash flow are different measures. A profitable projection therefore needs a separate cash bridge.

Here is the simplified annual bridge for the same company. Positive working-capital uses appear as subtractions. Cash interest and taxes are separate because the starting figure is operating profit.

If these effects occupy B2:B10, the closing cash formula is =SUM(B2:B10). With the required minimum cash balance of $10,000 in B12, funding in B13 is:

=MAX(0,B12-SUM(B2:B10))

The result is $40,000, leaving $10,000 after funding. This is an annual check, not a complete funding schedule: a monthly trough may require more. Populate monthly collection, equipment-payment and debt dates before stating the required amount. The financial gap analysis covers that period-by-period check.

Complete the projected balance sheet too. Closing cash must equal the cash schedule, retained earnings must reflect projected net income and distributions, and total assets must equal liabilities plus equity.

Where the financial section goes wrong

• Unsupported growth. Increasing revenue without testing staff capacity, customer demand and realized prices leaves the main driver unproven.
• Profit used as cash. Receivables, equipment purchases and principal repayments belong in the cash schedule even when they do not reduce operating profit.
• Annual totals hide timing. A year-end surplus can follow an unfunded payment earlier in the year.
• Assumptions presented as actuals. Keep historical evidence, signed commitments and management estimates visibly labeled, with the source of each estimate.

Write the financial narrative after the schedules reconcile. Explain the largest changes, who will monitor them, and what response a missed assumption would trigger. The analysis supports a reviewable business plan; it does not establish investment or lending approval.

Review your business-plan figures in Covirage

Upload your actuals and finance-prepared plan workbook so Covirage can map the columns and its tools can compute and check the comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See how this work fits Covirage for finance teams.