Finxora Logo
Sign In
How to Make Financial Projections for a Bank Loan
Back to Blog

How to Make Financial Projections for a Bank Loan

FINXORA
6 min read
financial projections
project report
forecasting
financial modeling
business planning

Create financial projections from sales and cost assumptions, then link profit, cash flow, the balance sheet and loan repayments.

Financial Projections for a Project Report

To make financial projections, estimate sales from operating drivers, forecast the costs of those sales, and connect the projected profit and loss account, balance sheet and cash flow. Add the proposed loan schedule so interest, principal and closing debt agree across the report. This guide uses an Indian business bank-loan context. A consistent forecast supports appraisal; it does not guarantee sanction.

A small example before you build the forecast

Suppose a service business expects to complete 100 jobs at Rs 2,000 each in a month. Sales are Rs 2,00,000. If direct costs are Rs 80,000 and overheads are Rs 60,000, the surplus before interest, depreciation and tax is Rs 60,000. These are illustrative assumptions, not industry benchmarks.

If customers pay only Rs 1,50,000 during that month and the remaining invoices are outstanding, collections differ from sales. Carry the outstanding amount into receivables and use actual expected receipts in the cash forecast. Then model taxes, asset purchases, borrowing and repayments separately. Profit alone cannot establish how much cash remains.

Step 1: Define the Scope and the Loan Tenure

Confirm the projection period and financial-year columns with the lender. Record the proposed loan amount, rate, tenure, disbursement timing, moratorium and repayment frequency, distinguishing indicative terms from confirmed terms. Record any subsidy treatment separately and confirm its timing before including it in funding or cash receipts. Extend the forecast far enough to examine the required repayment period rather than assuming the same number of years suits every application.

Step 2: Gather the Source Data

Collect the inputs that will support the assumptions:

  • Historical financial statements of the promoter or the existing unit.
  • Market research on demand, pricing and competition.
  • Quotations for plant and machinery and construction estimates.
  • Industry benchmarks for margins, ratios and working capital days.
  • Economic and sector outlook for the projection period.

Projections built on these sources are defensible; projections built on a growth percentage are not.

Step 3: Set and Document the Assumptions

Assumptions are the foundation of the projection. Document each one with its basis:

  • Sales growth rate by product or customer, supported by order book or market data.
  • Capacity and utilisation for each year.
  • Selling price and its movement.
  • Raw material cost and other direct costs.
  • Operating expenses as a share of sales or in absolute terms.
  • Working capital days for stock, receivables and payables.
  • Depreciation method and rates.
  • Interest rate, tenure and moratorium.

Write the assumptions into the assumptions section of the report. The credit team will test them, and undocumented assumptions are treated as guesses.

Step 4: Build the Revenue Forecast

Start with capacity and utilisation, then volume, then price. For a manufacturing unit, revenue is capacity times utilisation times selling price; for a service or trading unit, it is volume times price. Look at seasonality: if the business earns only in certain months, spread the annual amount across those months rather than dividing by twelve. Finxora supports month wise and seasonal entry, so the year is not shown as a flat average.

Step 5: Project the Costs

Project direct costs from the revenue and the input prices, and indirect costs from the operating plan. Capital expenditure should be shown in the year it is incurred and depreciated from then. Financing costs must reflect the proposed term loan and any existing borrowings. Keep cost ratios consistent with the historical record unless there is a reason to change them, and state that reason.

Step 6: Build the Operating Statement

Assemble sales, direct costs, gross profit, indirect expenses, EBDIT, interest, depreciation, tax and net profit for every projected year. The interest line must reflect the term loan and any working capital interest. Net profit then flows into the balance sheet and the DSCR, so it must be consistent with both.

Step 7: Build the Projected Balance Sheet

Carry net profit into reserves, fixed assets into the asset side with depreciation, and term loan balances down as principal is repaid. Closing balances carry forward into the next year's opening balances, which keeps depreciation, reserves and loan balances consistent across the whole span. The balance sheet must tally in every year.

Step 8: Build the Cash Flow Statement

The cash flow statement shows inflows from capital, subsidy and borrowings against outflows for assets, interest, principal and drawings. It is the statement that proves the unit generates cash, and it is the input to the DSCR. Prepare it from the same assumptions as the operating statement and balance sheet.

Step 9: Compute DSCR and Repayment

DSCR is receipts divided by repayments, where receipts are net profit plus depreciation plus term loan interest, and repayments are principal plus interest. Compute it for every projected year and show an average DSCR row. The EMI schedule must be month wise, with opening balance, EMI, principal, interest and closing balance for each loan, including the moratorium period if any. DSCR, the EMI schedule and the interest line in the operating statement must all agree.

Step 10: Calculate Break Even and Ratios

Break even shows the sales value at which the unit covers its fixed and variable costs, as a value and a percentage of sales, with the margin of safety above it. Ratio analysis should include current ratio, quick ratio, gross profit percentage, net profit percentage, EBDIT margin, return on capital employed, return on equity, debt equity, interest coverage, TOL to TNW and others. Show each ratio with its formula so the credit team can verify it.

Step 11: Run Sensitivity and Scenario Analysis

Test the projection against a bad year. Change sales, raw material cost or interest rate and show the effect on DSCR, break even and cash flow. Present at least a base case and a downside case. The purpose is to show that the unit survives a stress scenario, not only the expected one.

Step 12: Review, Present and Document

Present the projections clearly, with an executive summary, the assumptions, the financial statements, the DSCR and sensitivity results. Check that every figure ties across statements, that the balance sheet tallies in every year, and that the assumptions are complete. A review by a chartered accountant before submission catches errors that a bank would otherwise raise as queries.

How Finxora Helps

Finxora builds the profit and loss account, projected balance sheet, cash flow, depreciation, EMI schedules, DSCR, ratio analysis, break even, turnover method and MPBF from the inputs you enter, with month wise and seasonal revenue, multiple term loans, subsidy and moratorium support, and export to PDF, Word, Excel and JSON. See the project report software page, the sample reports and project report pricing.

Frequently Asked Questions

Published on February 24, 2026

Updated on November 18, 2026

Back to Blog

Need bank-ready financials? Create a CMA report or a project report with Finxora in minutes.