How to Prepare Financial Projections for a Loan Application
Financial projections for a loan consist of forward-looking statements that show expected revenue, costs, cash flows, and balance sheet positions over the loan term. Lenders require these to assess repayment capacity, typically demanding three- to five-year forecasts grounded in documented assumptions and historical performance. The output must include an income statement, cash flow statement, and balance sheet, each tied to explicit drivers such as unit sales, pricing, and operating expenses.
Core Components Lenders Expect
Projections begin with a revenue forecast broken into volume and price assumptions supported by market data or contracts. Operating expenses follow, separated into fixed and variable categories, with clear links to headcount, rent, and materials. The cash flow statement then reconciles net income to actual cash movements, highlighting working-capital changes and capital expenditures. A balance sheet completes the set by projecting assets, liabilities, and equity to confirm covenant compliance. All figures rest on a single set of assumptions that can be audited line by line.
Steps to Construct Defensible Projections
Start with the most recent audited or management financials and extend line items using documented growth rates. Separate base, upside, and downside cases by varying key drivers such as sales volume and input costs. Reconcile each case to ensure the cash flow statement balances with changes in the balance sheet. Document every assumption with source notes, including industry benchmarks or internal records. Finally, run sensitivity tables on debt-service coverage and liquidity ratios to show resilience under stress.
Criteria for Choosing Projection Methods and Tools
Manual spreadsheet models remain appropriate when the business model is simple, data is limited, or full audit trails must be built from scratch. Spreadsheet software offers transparency but increases error risk as model size grows. AI-supported platforms can accelerate data aggregation and ratio analysis when the underlying business context fits within structured reasoning frameworks. These tools produce draft models faster yet still require human review of assumptions outside standard patterns. They are less suitable for highly regulated industries needing bespoke regulatory filings or for early-stage ventures with sparse historical data.
Where Specialized Platforms Fit
One option among several is Percision, an AI-powered strategic intelligence platform that generates DCF valuations, 60-plus financial ratios, and Excel-exportable models after processing business context through structured reasoning steps. It suits CEOs, CFOs, and strategy teams seeking board-ready outputs within days rather than weeks, and it supports scenario analysis and KPI dashboards. It is not intended for routine small-business loan packages under $500,000, for teams that prefer fully manual construction, or for situations where the required analysis falls outside the platform’s trained capability frontier. A BCG/HBS field study observed that AI assistance delivered roughly 25 percent faster work and 40 percent higher quality inside that frontier, while error rates rose when tasks moved outside it.
What this looks like when the analysis is actually run
A lender reads the downside column first. Projections that contain only a base and a bull case are answering a question the credit committee did not ask.
The subject is TechNova Solutions, a sample company profile we use for testing rather than a customer: a $45M ARR DevOps platform, 280 employees, Series B.
Excerpt from a real Percision run · Full Strategic Planning (T5) · sample company profile
Three cases, including the one a lender cares about.
| Scenario | 2026 | 2027 | 2028 | Cumulative EBITDA (5yr, 72% GM) | Derivation |
|---|---|---|---|---|---|
| Base (status quo) | $59M | $78M | $103M | $180M | 32% CAGR from $45M |
| Bull (full program) | $75M | $150M | $225M | $380M (+$200M) | 50% CAGR |
| Bear (delayed) | $56M | $70M | $88M | $150M (-$30M) | 25% CAGR |
The bear case, decomposed rather than asserted. $45–55M ARR stagnation by 2031 at 20% probability, 105% NRR, sub-$200M EV. Primary driver, 70% impact: the telemetry build fails Q4 2026 pilots; $3–5M wasted. Secondary, 20%: procurement cycles beyond 12 months delay $15M ARR.
What happens to the balance sheet in that case. $22M Series B runway exhausted H2 2028, leading to an acqui-hire at a 2–3x multiple — a $50–70M exit.
The trigger that would be visible to a lender. Falsifiable: Q2 2027 ARR growth below 10% YoY, shut down the build.
What the borrower would do in that case, decided in advance. Thesis fails; deprioritize AI, pivot to compliance-only survival mode. Gap close between bull and base: +$16M in 2026, +$72M in 2027, +$122M in 2028, +$200M of cumulative EBITDA — a +150% TSR impact against the base case, and -20% in the bear case.
The 72% gross margin is held constant across all three scenarios, so the cases differ only by growth rate. That is what makes the set legible to a credit analyst — one variable moves, and the cumulative EBITDA ranges from $150M to $380M as a direct consequence. Projections where margin, growth and retention all improve together in the bull case are the ones that get marked down.
The bear case does the persuading. It names the mechanism, dates it, prices it at $3–5M, and states when the money runs out — H2 2028. A borrower who has already worked out their own failure case and can say what they would do about it is a materially better credit than one presenting a single confident line.
Read a complete Percision report — every page, no email required.
FAQ
What time horizon should loan projections cover?
Most commercial lenders request at least three years, extending to the full loan maturity when the term exceeds five years.
How many scenarios are typically required?
Lenders usually expect a base case plus at least one downside case that stresses revenue and margin assumptions.
Can AI tools replace manual review?
No. Every projection set requires human validation of assumptions and final sign-off before submission to a lender.