Every business plan contains a number. The difference between a company that raises capital on good terms and one that spends nine months explaining itself is usually not the quality of the business — it is whether that number can be traced back to assumptions a stranger can test. Investors do not reject models because the projections are ambitious. They reject them because they cannot find where the growth rate comes from, or because the balance sheet stops balancing in year three.
N D Savla & Associates builds financial models for Indian companies raising capital, sizing debt, evaluating acquisitions and running internal planning. We build integrated three-statement models, DCF valuations, project finance models with full debt schedules, fundraising models with dilution waterfalls, and rolling budget models that finance teams can actually maintain after we leave. Every model is built to be opened by a third party, understood in twenty minutes and stress-tested without breaking.
We work as chartered accountants rather than as spreadsheet specialists, which changes the output. Depreciation follows the Companies Act schedule and the Income Tax Act separately where that matters, tax is computed with MAT and carried-forward losses rather than as a flat rate, GST cash flow timing is modelled rather than ignored. Our teams operate from Andheri East, Charni Road, Vashi, Thane, New Panvel and Goa, and models are frequently built alongside our due diligence support and fundraising advisory engagements.
What Is Financial Modelling?
Financial modelling is the construction of a structured, assumption-driven representation of a business that projects its financial statements forward under stated conditions. A well-built model separates inputs, calculations and outputs so that any assumption can be changed and its full consequence observed immediately across the profit and loss account, balance sheet and cash flow statement.
The discipline rests on a single principle: the model is a tool for thinking, not a device for producing a target. In most businesses two or three variables — customer acquisition cost, gross margin, collection days, capacity utilisation — determine the result, and everything else is detail. Structurally, a competent model has four separated layers: inputs (colour-coded assumptions), calculations (schedules), outputs (three linked statements), and checks (balance sheet balance test, cash flow reconciliation, circularity control) — the layer that separates a model from a spreadsheet.
Who Needs Financial Modelling Services?
Companies Raising Equity Capital
Institutional investors rebuild the revenue line from drivers, test the downside case, and check the funding requirement against the ask.
Businesses Seeking Debt or Project Finance
Lenders focus on DSCR through the worst projected year, security cover, and sensitivity of cash flow to key variables.
Startups and Early-Stage Companies
Unit economics — contribution per customer, payback period, cohort retention, burn multiple — carry more weight than a five-year revenue figure.
Companies Evaluating Acquisitions
Combine standalone projections, transaction structure and synergy assumptions tested separately from the base case.
Established Businesses Running Annual Planning
A planning model connected to actual accounting data allows monthly variance analysis and rolling reforecast.
How Has Financial Modelling Evolved in India?
Before 1991, forward-looking financial analysis had limited practical application under the industrial licensing regime, where capacity was allocated administratively and long-term project finance came from development financial institutions on terms shaped by industrial policy. Liberalisation removed the licensing constraint — the abolition of the Controller of Capital Issues in 1992 meant issue pricing had to be justified, creating demand for valuation analysis, and foreign institutional investors brought DCF-based frameworks into Indian merchant banking practice.
The infrastructure programme of the 1990s and 2000s pushed project finance modelling considerably further, with models running twenty to thirty years and detailed debt sizing and sensitivity cases. More recently, Ind AS convergence changed the accounting a model must replicate, and the venture capital cycle introduced cohort-based unit economics modelling, followed by a post-2022 correction that shifted investor attention to path-to-profitability. Companies seeking recognition can review the framework at the Startup India government portal.
Step-by-Step Financial Modelling Process
- Define Purpose and Audience — A model for a bank credit committee, a PE investor and an internal budget process require different structures.
- Establish the Historical Base — Three years of audited financials rebuilt into the model's format, normalised and reconciled. Our accounting and tax compliance work provides a clean starting point.
- Build the Operating Driver Model — Revenue constructed from volume, price, customers, capacity — not a growth percentage.
- Construct the Supporting Schedules — Working capital, fixed assets, debt schedule, and tax computation including MAT and brought-forward losses.
- Integrate the Three Statements — Every schedule linked into P&L, balance sheet and cash flow, with the balance sheet tested to balance every period.
- Run Scenarios and Sensitivities — Base, upside and downside cases as switchable scenarios, feeding directly into de-risking the business.
- Review, Document and Hand Over — An independent reviewer tests the logic; we document every assumption and train the finance team to maintain it.
Practical tip: never hardcode a number inside a formula. Every assumption belongs in the input sheet, colour-coded.
Which Model Type Fits Which Purpose?
| Model Type | Primary Purpose | Core Output |
|---|
| Three-Statement Model | Integrated planning and control | Linked P&L, balance sheet and cash flow |
| DCF Valuation Model | Enterprise valuation | Free cash flow, WACC, terminal value |
| Fundraising Model | Investor diligence and pricing | Projections, unit economics, dilution waterfall |
| Project Finance Model | Debt sizing and lender approval | DSCR, IRR, drawdown and repayment schedule |
| Budget and Forecast Model | Operating control | Variance against plan, rolling reforecast |
| M&A Model | Transaction evaluation | Accretion or dilution, synergy sensitivity |
A model that does not balance is not a model. Before any projection is used for a funding decision, confirm the balance sheet check row is zero in every period and closing cash ties to the balance sheet.
How Does Financial Modelling Differ by Sector?
Manufacturing and Industrial
Capacity, utilisation and yield drive revenue; capex phasing and working capital build during ramp-up determine funding needs, intersecting with capital structuring.
Technology and SaaS
Cohort retention, MRR, churn, CAC and payback period replace conventional revenue build; deferred revenue under Ind AS 115 modelled separately from cash.
Financial Services and NBFCs
Balance-sheet-led models — loan book growth, yield, cost of funds, NIM, ECL provisioning and capital adequacy. Fund vehicles need separate treatment alongside our fund structuring work.
Real Estate and Infrastructure
Project-level cash flow with construction phasing, milestone-linked collections, RERA escrow restrictions and concession terms.
Why Choose N D Savla & Associates for Financial Modelling?
- Accounting accuracy, not spreadsheet decoration — Companies Act/Income Tax Act depreciation, MAT, carried-forward losses, GST timing and Ind AS treatment modelled correctly.
- Built for interrogation — clean structure, visible assumptions and working checks keep a funding process moving.
- Transaction context — built within live IPO advisory, fundraising and M&A processes.
- Handover you can maintain — documented assumptions and team training.
- Senior involvement and continuity — partner-reviewed work delivered from six offices across the Mumbai region and Goa.
Most Common Financial Modelling Errors
- Revenue built as a growth percentage rather than from volume and price.
- Hardcoded values buried inside formulas.
- A balance sheet that stops balancing — usually a cash flow item omitted or a schedule not fully linked.
- Tax modelled as a flat percentage of profit before tax, ignoring MAT and carried-forward losses.
- Working capital assumed rather than benchmarked to actual collection performance.
- A base case that is really the best case, with no genuine downside.
- Circular references resolved by disabling the check rather than a controlled iterative switch.
- No version control — multiple "final" files circulating with different numbers.
Frequently Asked Questions
What is a financial model and what is it used for?
A financial model is a structured spreadsheet that translates business assumptions into projected profit and loss, balance sheet and cash flow statements. It is used to raise capital, value a business, size and service debt, evaluate an acquisition, plan capacity and test whether a strategy survives a downturn.
What is a three-statement financial model?
A three-statement model links the profit and loss account, balance sheet and cash flow statement so every assumption flows through all three and the balance sheet balances in every period without manual adjustment.
How many years should a financial projection cover in India?
Five years is the standard horizon for fundraising and internal planning models. Project finance and infrastructure models run to the tenor of the debt, commonly ten to twenty years. DCF valuations typically use an explicit five-year forecast followed by a terminal value.
What makes investors reject a financial model?
Hardcoded numbers inside formulas, revenue built as a growth percentage rather than from drivers, a balance sheet that does not balance or a cash flow statement that does not tie out, and a base case that is really the best case with no downside scenario.
Can a financial model be used for valuation under Indian tax and FEMA rules?
A model can support a valuation, but the statutory report itself must come from an appropriately qualified valuer. Issues to residents above fair market value engage Section 56(2)(viib) and require a registered valuer or merchant banker report, while issues to non-residents must meet FEMA pricing guidelines.