When preparing a funding application, one of the most common questions is: what should financial projections in Excel include for a funding application? The answer is structure first, numbers second. Many funding rejections are driven by poor model structure and lack of auditability rather than simple arithmetic errors. Banks, development finance institutions and private investors are not reading a spreadsheet; they are reading a financial argument. Reviewers focus on repayment capacity, integrated assumptions and working-capital timing. If the logic does not hold together from the first assumption cell to the final balance sheet, the model fails before the reviewer gets to the bottom line.
That is the reality of what happens inside funding committees every week. A business owner spends weeks building projections, pulls together impressive revenue figures, submits the application and waits. Then comes the request for revision: “Please provide a fully integrated financial model with supporting assumptions and a cash flow forecast.” At that point, the business has already weakened its credibility with reviewers, sometimes materially so. This guide tells you exactly what your Excel financial projections must include and why each component earns its place in a submission that passes due diligence.
Why the structure of your Excel financial model matters more than the numbers
Funders are not hoping your projections are right. They know projections are estimates. What they are checking is whether the model has been built by someone who actually understands the business, because that signals whether the management team is capable of executing it. A model with aggressive revenue growth and no documented assumptions is a red flag, not an asset. It tells the reviewer that the numbers were reverse-engineered to hit a target rather than derived from logical operating drivers.
Internal consistency is what builds credibility. Every output in a funder-ready model must trace back to a documented, defensible input. Revenue should flow from unit volume and pricing assumptions. Costs should tie back to headcount schedules and cost-of-sales percentages. Debt repayments should link to a standalone loan amortisation schedule. When a reviewer can follow that chain from input to output, the model earns trust. When they cannot, it does not matter how attractive the final profit line looks.
The distinction that matters here is the difference between a financial forecast and a funder-ready model. A forecast answers “what do we think will happen?” A funder-ready model answers “here is our logic, here are the levers, and here is what happens when those levers move.” That second kind of model is what JTB Consulting builds for every funding engagement: driver-based, fully integrated and built from first principles. It is also the kind that consistently passes bank and DFI due diligence scrutiny, while template-filled spreadsheets rarely do.
What should Excel financial projections include: the assumptions schedule
A funder-ready Excel financial model does not start with the income statement. It starts with a dedicated assumptions sheet where every single input lives. This is the most important section of the model, because everything else flows from it. If an assumption changes, the model updates. If an assumption is missing, a formula somewhere is hiding a hard-coded guess.
Revenue drivers, pricing and growth rate assumptions
Your revenue section on the assumptions sheet should document the key inputs that drive your top line. Consider converting the following to a quick reference before building your formulas:
- Units sold or customer count
- Average selling price or average revenue per user
- Conversion rate from leads to customers
- Revenue growth rate by year
- Seasonality adjustments
- Product or service mix being projected
Each assumption must be labelled, unitised and sourced. If the figure comes from historical performance, say so. If it comes from an industry benchmark, reference it. If it is management guidance, state that clearly. Vague assumptions invite challenge; sourced assumptions invite confidence.
These inputs then feed directly into your projected income statement through linked formulas, not hard-coded values. The formatting convention used by most professional modellers is to colour input cells distinctly, typically blue font or a filled background, so that any reviewer can immediately identify where the assumptions sit and where the derived calculations begin. Never embed an assumption inside a formula; that is where models become unauditable.
Cost, capex, payroll and working capital assumptions
The cost side of your assumptions sheet should cover cost of sales (expressed as a percentage of revenue or on a per-unit basis), headcount by function with salary per role and hire timing, and capital expenditure items with timing and useful life for depreciation purposes. Working capital drivers, debtor days, creditor days, and inventory days belong here too. For South African businesses, also include the applicable corporate tax rate and any VAT-related timing considerations that affect cash flow, where relevant to your business model. These inputs are not administrative detail; they are the engine of your three-statement model. Get them right on the assumptions sheet and the rest of the model builds itself.
The income statement projections: what format and content funders expect
The projected income statement is a primary statement funders review, alongside the cash flow forecast, which lenders scrutinise closely for repayment capacity. It needs to show revenue, gross profit, operating expenses, EBITDA, depreciation, interest, tax and net profit on a consistent monthly basis for at least the first two years, then annually for years three to five. For South African banks and DFIs, including the IDC and NEF, a three-to-five-year projection horizon is common for most facilities, with five years typically the safer default for larger expansion or project finance applications, though requirements vary by lender and transaction type.
How to structure revenue lines and gross margin correctly
Do not present revenue as a single line. Break it into meaningful segments: by product line, geography, channel or customer type. Funders want to understand what is driving growth and whether any single revenue stream represents a concentration risk. Below the revenue lines, separate cost of sales clearly from operating expenses so that gross profit and gross margin percentage are visible at each level of the statement. Gross margin is one of the first ratios a reviewer checks. If it is inconsistent with industry benchmarks for your sector, the model will be questioned, regardless of how strong the net profit line looks.
Operating expenses, EBITDA and the path to net profit
Below gross profit, list operating expense categories clearly: staff costs, rent, marketing, professional fees, utilities and insurance at minimum. Display EBITDA as a separate subtotal before depreciation and amortisation, because funders use EBITDA as a proxy for operating cash generation and debt repayment capacity. Depreciation and amortisation should be calculated from the capex schedule and linked through, not manually entered. Interest expense must link to the loan repayment schedule, and tax should be calculated at the applicable South African corporate rate against taxable profit. Every line links back to the assumptions sheet. Nothing is hard-coded.
The cash flow forecast: the statement that makes or breaks a bank application
Profitability does not repay a loan. Cash does. Banks and DFIs will scrutinise your cash flow forecast closely when assessing repayment capacity. A common and costly mistake is submitting an income statement-only model. The cash flow forecast must be built as a separate, fully integrated statement that reconciles to the balance sheet in every period.
Monthly cash flow structure for the first two years
Build the cash flow statement using the indirect method: start from net profit, add back non-cash items like depreciation, then adjust for working capital movements (changes in debtors, creditors and inventory). The result is operating cash flow. Add investing activities (capex) and financing activities (loan drawdowns and repayments) to arrive at the net movement in cash for the period, and the closing cash balance feeds directly into the balance sheet. Monthly granularity is essential for at least the first 24 months. Seasonal cash gaps that are invisible in an annual view become obvious in a monthly forecast, and a bank needs to see those gaps to understand the business’s cash behaviour.
Why funders pay particular attention to cash timing and negative periods
If your closing cash balance goes negative in any period, that is a red flag that must be addressed directly. A negative cash balance means the business cannot meet its obligations from its own resources at that point, and the model must explain how that gap is bridged, whether through a loan drawdown, an equity injection or a working capital facility. For startups and early-stage businesses, cash runway is a critical metric: how many months of operation can the business sustain at its current burn rate before it runs out of cash? The cash flow forecast answers this question directly, and a funder will read it with exactly that question in mind.
The projected balance sheet and why it must reconcile
Many self-built models include an income statement and a cash flow forecast but omit the balance sheet entirely, or include one that does not balance. A projected balance sheet that does not reconcile is a clear signal that the model is not integrated. It tells a funder that the three statements were built separately and not linked, which means the cash flow forecast may not actually reflect the working capital movements shown in the balance sheet. This kind of omission may lead to rejection or requests for resubmission at a South African bank.
What the projected balance sheet must include and how it links to the other statements
Fixed assets on the balance sheet must link to the capex schedule, net of accumulated depreciation. Current assets should include trade debtors calculated from your debtor days assumption, inventory from inventory days and cash from the closing balance of the cash flow statement. On the liabilities side, debt must link to the closing balance of the loan repayment schedule. Equity must reflect opening equity plus retained profit from the income statement for each period. The balance check line, assets equal liabilities plus equity, must hold in every single forecast period. If it does not, something in the model is broken.
The financial ratios that flow from a balanced balance sheet
Once the balance sheet is built correctly, the key solvency ratios calculate automatically. The current ratio (current assets divided by current liabilities) tells a funder whether the business can meet its short-term obligations. The debt-to-equity ratio shows leverage and whether the business is overextended relative to its equity base. For investor-facing models, net asset value per share is also derived from the balance sheet. These ratios are not extras to be added after the fact.
They flow naturally from a properly constructed three-statement model, what many lenders refer to as pro forma financial statements, and are exactly what a funding committee will read off the page.
Break-even analysis and loan repayment schedules
Two components are commonly overlooked in self-built Excel models submitted to South African funders: a properly constructed break-even analysis and a loan repayment schedule. Both are expected by banks, DFIs and institutional investors reviewing South African funding applications, and their absence signals an incomplete model.
How to build and present a break-even analysis in Excel
The break-even point should be expressed in two ways: in units (fixed costs divided by contribution margin per unit) and in revenue (fixed costs divided by contribution margin percentage). Present a break-even chart showing the revenue and total cost lines crossing, and identify the break-even month within your cash flow forecast, the point at which cumulative revenue covers cumulative costs. Funders use the break-even month to assess how long the business needs external support before becoming self-sustaining. It is a direct measure of risk timeline, and a model without it leaves that question unanswered.
Structuring the loan repayment schedule correctly
The loan repayment schedule should be built as a monthly amortisation table. It needs to show the opening loan balance, interest charge at the applicable rate (prime-linked or fixed), principal repayment and closing balance for the full term of the loan. If a moratorium period applies, show the interest-only phase separately before capital repayments begin. The total interest expense must feed directly into the income statement, and the closing loan balance must feed into the balance sheet liabilities section.
Most importantly, calculate the debt service coverage ratio (DSCR) in every period. DSCR is net operating income divided by total debt service, and South African banks commonly require a minimum DSCR of 1.25 times throughout the repayment term. If your model shows periods below that threshold, address them before submission, not after.
What should financial projections in Excel include: KPIs and financial ratios
A well-built Excel model includes a dedicated KPIs or financial summary sheet that pulls the most important ratios into one place by year, with finer granularity, monthly or half-yearly, for the first 24 months, depending on funder expectations. Funders should not have to hunt through multiple tabs to find the metrics they need. A clear summary sheet also demonstrates that you understand which numbers matter most to the people reviewing your model.
What banks and DFIs focus on in a South African funding application
For any debt-funded application, DSCR is the primary ratio. Present it clearly, by period, and make sure it stays above 1.25 throughout the repayment term. Alongside DSCR, include the current ratio, debt-to-equity, gross margin percentage, EBITDA margin and net profit margin. The interest coverage ratio (EBIT divided by interest expense) is a useful secondary check that gives funders an additional read on how comfortably the business services its debt from operating earnings. These ratios are not decoration. They are the metrics the funding committee will discuss when they assess your application.
What equity investors and venture capital funders prioritise
Equity investors ask different questions from banks. They are not primarily concerned with loan repayment; they are assessing scalability and capital efficiency. For an investor-facing model, your KPI sheet should highlight gross margin trajectory over the projection period, EBITDA margin progression, monthly burn rate, cash runway in months, and year-on-year revenue growth rate. For businesses with a customer acquisition model, include customer acquisition cost and payback period. These metrics tell the story of whether the business can grow efficiently, which is the central question for any venture capital or private equity investor reviewing your financial projections.
Sensitivity and scenario analysis: testing your model under pressure
A financial model without sensitivity analysis is an opinion. A model with sensitivity analysis is an argument. Funders know projections are not guaranteed; what they want to know is how bad things can get before the business runs out of cash or cannot service its debt. A model built only for the upside tells a funder that management has not interrogated its own assumptions.
How to structure base, best and worst cases in Excel
Build three clearly labelled scenarios: a base case (your realistic operating projection), a best case (optimistic assumptions) and a worst case (a genuinely stress-tested downside, not a mildly conservative version of base). Control the scenarios through a single switch cell or Excel’s Scenario Manager, so the model structure is identical across all three and only the assumption inputs change. Build a scenario summary output sheet that compares EBITDA, net profit, DSCR, closing cash balance and break-even month across all three scenarios side by side. The base case must be realistic. If it looks like your best case, a funder will notice.
Which variables to stress-test first and how to present a sensitivity table
Start with the top-line drivers that have the most leverage over the outcome: revenue growth rate, average selling price and gross margin percentage. Then move to cost drivers: COGS percentage, payroll and key operating expenses. Finally, test finance assumptions: interest rate, capex timing and total funding requirement. Present a two-variable sensitivity table in Excel showing how DSCR or net profit changes when price and volume move simultaneously across a range of scenarios. South African DFIs, including the IDC and NEF, specifically look for this kind of stress-testing as evidence that management has thought critically about its assumptions rather than simply projecting growth in a straight line upward.
Putting the model together for submission
If you have been wondering what financial projections in Excel should include for a funding application, the answer is an integrated argument, not a collection of tabs. Every number traces back to a documented assumption on the assumptions sheet. The three core statements- income statement, cash flow forecast and balance sheet- link to each other and balance in every forecast period.
The break-even analysis and loan repayment schedule are built in and connected, not copied in separately. The KPI summary sheet pulls the ratios that matter most into one clean view. And the scenario analysis demonstrates that the model holds up when its key inputs are challenged. That level of build quality is what separates a model that passes due diligence from one that is sent back for revision.
The checklist for a submission-ready model looks like this:
- Assumptions sheet with all inputs labelled, unitised and sourced
- Integrated three-statement model (income statement, cash flow forecast, balance sheet) with all periods reconciling
- Monthly detail for at least 24 months, annual summary for years three to five
- Loan repayment schedule with DSCR calculated in every period
- Break-even analysis in units, revenue and months from launch
- KPI and financial ratio summary sheet
- Three-scenario analysis with a summary output comparing key metrics
- Use-of-funds schedule showing how the funding request is deployed and timed
If you would rather have this built once and built correctly, to the standard that South African banks, DFIs and investors actually expect, we at JTB Consulting construct driver-based, fully integrated Excel financial models as part of our funding application packages. Our team has completed projects across a wide range of industries and sectors, building pro forma financial statements that have been submitted to major South African funders, from commercial banks to the IDC, NEF and SEFA, and have held up through their due diligence processes. Reach out for a consultation and get your model built right the first time.
