Financial Modelling

What Is Financial Modelling?

Financial modelling is the building of a structured, formula-driven spreadsheet model that represents how a business or project works financially and allows its results to be tested under different assumptions. A typical model has an inputs sheet for assumptions, calculation sheets for revenue, costs, working capital, capital expenditure, funding and tax, and an outputs sheet with projected statements, ratios and returns.

The strength of a model is flexibility. Change the price, volume, cost, funding mix or timing, and the whole model updates. This allows scenario analysis, sensitivity tables, debt sizing, valuation and negotiation of terms. Models are widely used for project finance, fundraising, acquisitions and joint ventures, budgeting and investment decisions.

A financial model is different from a set of static financial projections, which present projected statements in a report. A model is built to be used and re-used. It must also be well built: transparent, consistent and checked, so that the numbers can be trusted by the people who rely on them.

Who Needs Financial Modelling?

• Promoters of large or complex projects seeking debt and equity
• Startups and companies preparing for a fundraising round
• Investors and acquirers valuing a business or evaluating a deal
• Joint venture partners negotiating contributions and returns
• Developers modelling phased projects with construction and sales
• Businesses planning expansion or budgeting
• Lenders and advisers reviewing a borrower's model

When Is Financial Modelling Required?

It is not a legal requirement, but a model is valuable when:

• The project has phased capex, ramp-up and complex funding
• Investors or lenders want to run their own scenarios
• Valuation using discounted cash flow is needed
• Terms such as debt sizing, equity returns or sharing waterfalls are being negotiated
• Several scenarios must be compared
• A static projection is no longer enough for decision-making
• An existing model needs review or correction

What Our Financial Modelling Service Includes

The model is tailored to the purpose and typically includes:

• Understanding the business or project, the users and the decisions the model must support
• Model design and structure: inputs, calculations and outputs separated
• Timeline, revenue build-up and cost modelling
• Working capital, capex and depreciation
• Funding: equity, term loans, interest, repayment and moratorium
• Three statements: profit and loss, balance sheet and cash flow
• Tax and GST at a modelling level
• Returns and metrics: NPV, IRR, payback, DSCR and equity returns
• Scenario switches and sensitivity tables
• Valuation using discounted cash flow, where required
• Cap table or waterfall for investor models
• Integrity checks, documentation and a user guide
• Handover walkthrough

Legal and Practical Considerations

Assumptions are the owner's. The model reflects the assumptions provided and agreed. Responsibility for assumptions and decisions based on the model remains with the client, and the assumptions sheet should be clear.

Model integrity. A reliable model balances (the balance sheet balances and cash reconciles), avoids hard-coded values in formulas and has checks that flag errors. Review of an existing model should test these.

Use with lenders and investors. Lenders and investors often review or rebuild the model and rely on it in decisions. It must be consistent with the project report and other submissions, and information provided to them must be accurate.

Valuation. A DCF model produces an indicative value based on assumptions. It is not a statutory valuation. Where the law requires a valuation by a registered valuer, such as for certain issue or transfer of shares under the Companies Act, 2013 or FEMA, a registered valuer's report is needed.

Tax treatment. The model simplifies tax. Actual tax computation should be confirmed with a tax professional, noting that the Income-tax Act, 2025 applies from 1 April 2026.

Confidentiality and ownership. The model contains sensitive data. Ownership of the file, access and further use should be agreed at the outset.

Common Mistakes in Financial Models

• Mixing inputs, calculations and outputs in the same cells
• Hard-coded numbers inside formulas
• Balance sheet that does not balance
• Circular references without control
• No scenario or sensitivity capability
• Assumptions undocumented
• Overly complex model for a simple decision
• Treating a DCF output as a statutory valuation

Professional Fees, Government Fees and Timeline

Financial modelling carries no government fee. Professional fees depend on the complexity of the business or project, number of scenarios, the level of detail, whether valuation or investor waterfalls are included and the timeline. A model is typically delivered in 7 to 15 working days after assumptions and data are agreed, and complex project finance models may take longer.

Financial Modelling vs Financial Projections vs Valuation

Financial projections present statements in a report. Financial modelling builds a dynamic model for scenarios and decisions. Valuation estimates the worth of a business or shares and, where required by law, must be done by the relevant professional. Related services include Financial Projections, Cash Flow Projection and Financial Feasibility Report.

Need Professional Assistance With Financial Modelling?

A clear, well-built model lets you test decisions before making them. The Legal Bank can help you build or review a model for your project or transaction. Share your requirement to discuss the next steps.