Three Statement Financial Model Services: Scope, Linkages, Selection

Three statement financial model services build one integrated workbook in which the profit and loss statement, balance sheet and cash flow statement move together from a single set of assumptions. In India, that integration carries statutory weight: the output has to map to Schedule III of the Companies Act 2013, compute tax under the Income-tax Act 2025, and treat GST, TDS and MSME payables the way your auditor will. Investors at Series A and beyond increasingly ask for this model in the first diligence request. This article covers what a proper engagement delivers, the India-specific linkages most builds get wrong, and how to choose between building, freelancing and engaging a firm.

What do three statement financial model services include?

Three statement financial model services include an assumptions sheet, a monthly operating build (revenue, payroll, opex, capex), supporting schedules for working capital, fixed assets, debt, equity and tax, and three linked statements where the balance sheet ties to zero every period. A complete engagement adds scenario toggles, a cash runway view, a Schedule III mapped output and model documentation, delivered as an unlocked Excel or Google Sheets file.

How an integrated financial model differs from a revenue forecast

An integrated financial model differs from a revenue forecast because every rupee booked in the P&L has a balance sheet consequence and a cash timing. A revenue forecast stops at EBITDA. A three statement model asks when the customer pays, when GST is remitted, when the vendor is paid, and what that does to closing cash. Most Indian startups we review have the first and believe they have the second.

The practical test is simple. Change one assumption, say debtor days from 45 to 75, and check three things: revenue in the P&L stays the same, trade receivables on the balance sheet rise, and operating cash flow falls by the same amount. If all three do not move together, the model is not integrated.

Founders usually discover the gap at the worst moment. An investor’s analyst changes collection days in the diligence model, cash stays flat, and the credibility of every other number in the deck drops with it.

Revenue forecast vs integrated three statement model

What a three statement model in India must get right

A three statement model in India must reflect Indian statutory treatment in its schedules, not just Indian rupees in its cells. Four areas carry most of the risk: tax, GST, MSME payables and instrument classification. Each one changes cash or the balance sheet materially, and each one is checked in financial and tax diligence.

Tax under the Income-tax Act 2025

From 01/04/2026, the Income-tax Act 2025 governs computation for tax year 2026-27 onwards. The concessional 22% regime for domestic companies, previously section 115BAA of the Income Tax Act 1961, now sits in section 200 of the 2025 Act (base rate 22%, plus 10% surcharge and 4% cess, source: incometaxindia.gov.in). Once exercised, the option cannot be withdrawn (section 200(6)).

For a loss-making startup, the model should still compute tax properly: carry forward of losses, the effect of deferred tax on the balance sheet, and advance tax instalments once profitable. A flat 25% on PBT produces the wrong cash outflow in the first profitable year, which is exactly the year investors scrutinise.

GST input credit and output liability

Revenue in the P&L excludes GST, but cash collected includes it. The model needs an output GST payable, an input tax credit receivable governed by section 16 of the CGST Act 2017, and a monthly set-off. Exporters of services that supply under LUT accumulate credit, and refund timing under section 54 of the CGST Act 2017 becomes a real working capital line. Leaving GST out understates both receivables and payables and can mis-state cash by several weeks of revenue.

MSME payables and tax deductibility

Payments to micro and small enterprises are capped at 45 days under section 15 of the MSMED Act 2006, and tax law disallows the deduction for amounts left unpaid beyond that limit. A model that sets a single creditor days figure of 60 or 90 for all vendors overstates tax deductions and understates tax cash. Split creditor days into MSE and non-MSE vendors.

CCPS, convertibles and Schedule III presentation

Compulsorily convertible preference shares are presented under equity in most Indian startup financials prepared under Indian GAAP, but companies that apply Ind AS (mandatory under Rule 4 of the Companies (Indian Accounting Standards) Rules 2015 for listed companies and unlisted companies with net worth of ₹250 crore or more) may need to classify certain instruments as liabilities depending on conversion terms. The equity schedule should model each round separately, with share capital and securities premium split, so the output maps cleanly to Schedule III, Division I or Division II as applicable.

Related reading: for the broader picture of model types and when each fits, see our complete guide to financial modelling for startups.

Which schedules sit inside a linked P&L, balance sheet and cash flow model?

A linked P&L, balance sheet and cash flow model sits on six supporting schedules. Each schedule is where the integration actually happens; the three statements only summarise them.

1. Assumptions and drivers: pricing, volume, cohorts, hiring plan, cost escalators, all in one input sheet with no hard-coded numbers elsewhere.
2. Working capital: receivables, payables (MSE and non-MSE), inventory, advances, GST and TDS balances, built on days or percentage drivers by revenue stream.
3. Fixed assets and depreciation: capex plan, book depreciation under Schedule II of the Companies Act 2013, and tax depreciation separately, feeding deferred tax.
4. Debt: term loans, venture debt and working capital lines with drawdown, interest, repayment and covenant checks.
5. Equity: each funding round, ESOP pool, CCPS conversion and securities premium.
6. Tax: computed taxable income, loss carry forward, regime choice, advance tax timing and deferred tax.

The cash flow statement is then derived by the indirect method, consistent with Ind AS 7 or AS 3, rather than typed in. The balance check row (total assets less total liabilities and equity) should read zero for every month, with a visible flag if it does not.

Financial model for due diligence: what investors test

A financial model for due diligence is tested on whether it reconciles to audited numbers and whether it breaks under stress. Analysts start from the last audited balance sheet, check the opening balances, then flex the two or three drivers that matter most to see if cash, debt covenants and runway respond logically.

Expect these checks in a typical Series A or B process:

• Opening balance sheet ties to the latest audited or provisional financials, line by line.
• Historical months reconcile to MIS and the trial balance within a tolerance the analyst sets.
• No hard-coded plugs in cash or equity.
• Scenario toggles change outputs without breaking the balance check.
• Tax and GST lines are computed, not assumed.

A model that passes these checks shortens diligence because the investor’s team can build their valuation on top of it rather than rebuilding from the MIS.

Outsourced financial modelling: build in-house, freelancer or firm?

Outsourced financial modelling makes sense when the deadline is a funding round and nobody in-house has built an integrated model under Indian GAAP before. The right choice depends on who will own the model after the round and how much statutory logic the business carries.

Choosing who builds your three statement model

Timelines above are Treelife estimates from engagement experience and vary with data quality; they are not market benchmarks.

Three statement financial model services: the engagement process

Three statement financial model services at Treelife run in five stages. Data quality in stage one decides how fast the rest moves.

1. Scoping (week 1): purpose (equity raise, venture debt, board budget), horizon (usually 36 to 60 months), granularity (monthly for 24 months, quarterly after), and audience.
2. Data intake (week 1): last audited financials, current year trial balance, MIS, payroll register, GST returns (GSTR-1 and GSTR-3B), loan agreements, SHA and cap table.
3. Build (weeks 2 to 3): assumptions, schedules and linked statements, with the balance check live from day one.
4. Review (week 4): founder walkthrough, tax and GST logic reviewed by our tax team, stress tests on the top three drivers.
5. Handover (week 4 or 5): unlocked file, assumptions log, user guide, and an optional monthly actuals refresh under a VCFO retainer.

Common mistakes that cost founders time and money

1. Plugging cash to balance the balance sheet. It happens when the cash flow statement is typed rather than derived. Investors spot it within minutes. Derive cash flow by the indirect method and let the balance check fail visibly until the error is found.

2. One creditor days figure for every vendor. Founders model 90-day payables to stretch runway. MSE vendors carry a statutory 45-day cap under section 15 of the MSMED Act 2006, with interest at three times the bank rate under section 16 and a tax deduction risk. Split vendors.

3. Flat tax on PBT. It ignores loss carry forward and regime choice, so the first profitable year shows the wrong tax cash. Compute taxable income and apply section 200 of the Income-tax Act 2025 where the company has opted for it.

4. Opening balances that do not match audited accounts. Usually because the model was started from a pitch deck. Every diligence team checks this first. Start from the audited balance sheet and roll forward through provisional actuals.

5. Treating GST as outside the model. It understates working capital and, for exporters, hides months of trapped credit. Model output tax, input credit under section 16 of the CGST Act 2017 and refund timing.

Treelife practitioner note

In the three statement financial model services engagements we have run at Treelife, the model rarely fails on revenue logic. It fails on the balance sheet. The pattern is consistent: a founder’s team builds a careful cohort-driven revenue engine, then closes the balance sheet with a cash plug because nobody owns the GST, TDS and payables schedules.

Two details come up in almost every Series A diligence we support. First, TDS receivable. A B2B company collecting from enterprise clients accumulates TDS credit that only converts to cash after the return is processed, sometimes more than a year later. Models that treat it as cash in the month of invoicing overstate runway. Second, CCPS conversion. Where the SHA ties conversion ratio to a future valuation or performance milestone, the equity schedule needs the conversion mechanics, not just the face value, because the investor will run dilution off your model.

The other pattern is timing. Founders commission the model after the term sheet, when diligence clocks are already running. Building it three months earlier, against provisional actuals, lets the model double as the board budget and removes a week from diligence.

We build models that your finance team can run after we hand over. That means fewer macros, no hidden sheets, and an assumptions log that explains every input in a sentence.

Frequently asked questions

Q: What is a three statement financial model?

A: An integrated workbook linking the P&L, balance sheet and cash flow statement. Changes to any assumption flow through all three, and the balance sheet ties every period. It is the base layer for valuation, debt sizing and budgeting.

Q: How long does a three statement model take to build?

A: Typically three to five weeks with review (Treelife estimate). Clean audited accounts and MIS shorten it; a messy trial balance or missing GST reconciliations extends it by one to two weeks.

Q: What documents do I need to share?

A: Last audited financials, current year trial balance, monthly MIS, payroll register, GSTR-1 and GSTR-3B, loan agreements, the SHA and the current cap table. The audited balance sheet is the single most important input.

Q: Which tax rate should my model use?

A: The rate under the regime your company has opted for. A domestic company on the concessional regime pays 22% plus 10% surcharge and 4% cess under section 200 of the Income-tax Act 2025. Model taxable income, not PBT.

Q: Does the model need to follow Ind AS?

A: Only if your company is required to apply Ind AS under Rule 4 of the Companies (Indian Accounting Standards) Rules 2015, or has opted in. Most unlisted startups below the ₹250 crore net worth threshold report under Indian GAAP (AS). The model should match whichever standard your auditor applies.

Q: How should GST appear in the model?

A: As output tax payable and input tax credit receivable on the balance sheet, with monthly set-off. Revenue and costs in the P&L stay net of GST. Exporters should model refund timing under section 54 of the CGST Act 2017.

Q: My company has a US parent. Does that change the model?

A: Yes. You may need a consolidated model in USD and a standalone Indian model in INR, with intercompany transfer pricing charges, FEMA-compliant funding flows into the Indian subsidiary and reporting under the FEMA (Non-debt Instruments) Rules 2019 reflected in the equity schedule.

Q: How are co-founder and ESOP shares handled?

A: Through the equity schedule. Founder shares, the ESOP pool and exercises are tracked separately, and ESOP cost is recognised as an expense under the share-based payment standard your company applies (Ind AS 102 or the ICAI guidance note).

Q: Does DPIIT recognition affect the model?

A: It can. A DPIIT-recognised startup certified by the Inter-Ministerial Board may be eligible for a profit-linked deduction for three consecutive years, subject to conditions. The tax schedule should toggle this.

Q: What happens if the funding round falls through?

A: A properly built model shows it in minutes. Turn the funding toggle off and the model shows runway, the cash low point and the cost cuts needed to extend it. That downside case is often more useful to the board than the base case.

Q: Will the investor use my model or build their own?

A: Most Series A and B investors build their valuation on top of a credible founder model rather than rebuild it. If opening balances do not reconcile or cash is plugged, they rebuild and question the rest of the data.

Q: Can the model support a venture debt raise?

A: Yes, and it should. Lenders test interest cover, cash balance covenants and repayment capacity. The debt schedule should compute these monthly and flag any breach.

Q: Should a pre-revenue startup commission a full three statement model?

A: Usually not. A 12 to 18 month cash flow model is enough before revenue. Move to a three statement build once you have receivables, payables and a priced round ahead.

Q: Who owns the model after delivery?

A: You do. We hand over an unlocked file with an assumptions log and user guide. Monthly refresh against actuals is available under a VCFO retainer, but it is optional.

Regulatory references:

• Companies Act 2013, Schedule II (useful lives for depreciation) and Schedule III (format of financial statements)
• Companies (Indian Accounting Standards) Rules 2015, Rule 4
• Income-tax Act 2025, section 200 (concessional 22% regime for domestic companies), in force from 01/04/2026
• Income Tax Act 1961, section 115BAA (predecessor to section 200)
• Central Goods and Services Tax Act 2017, section 16 (input tax credit) and section 54 (refunds)
• Micro, Small and Medium Enterprises Development Act 2006, sections 15 and 16
• Foreign Exchange Management (Non-debt Instruments) Rules 2019
• Ind AS 7, Ind AS 102; AS 3

About the Author

Share

• Link copied to clipboard!
  https://treelife.in/finance/three-statement-financial-model-services/
  
• 
• 
• 
• 

Treelife

Treelife Team | support@treelife.in

We are a legal and finance firm with a deep focus on the startup ecosystem. We offer a wide range of services, including Virtual CFO, Legal Support, Tax & Regulatory, and Global Expansion assistance.

Our goal at Treelife is to provide you with peace of mind and ease in business.

Reviewed By

Jitesh Agarwal

Founder

Leads VCFO, finance, tax, and regulatory functions at Treelife. Advises on GIFT City structuring and strategic financial decisions for startups and scale-ups.

Priya Kapasi Shah

Associate Partner | Tax & Regulatory

Heads Financial Advisory at Treelife, specialising in investment structuring, cross-border transactions, AIF setups, and tax and regulatory advisory.