A twelve-month spreadsheet with hard-coded revenue rarely survives institutional due diligence. This case study explains how APCALLP approached financial modelling for startups for a Bengaluru-based, venture-backed SaaS company, building a 60-month, fully formula-driven model across five revenue verticals with more than 200,000 formulas validated before each delivery.
Executive Summary: Investor-Grade Financial Modelling for a SaaS Startup
What was the challenge? A Bengaluru-based venture-backed SaaS company preparing for an institutional growth capital raise had projections covering only twelve months, with cash and accrual concepts mixed together and revenue assumptions hard-coded. Changes to pricing, sales volumes or team size required substantial manual rework and could create inconsistencies.
What service did the firm provide? APCALLP developed a 60-month, fully formula-driven financial model covering five revenue verticals, monthly P&L, cash flow and balance sheet, an interactive sensitivity framework and an integrated journey-level revenue register. The model connected operating assumptions with hiring, revenue, cash flow, balance sheet and funding analysis.
What was the result? The completed model contained more than 200,000 formulas and was subjected to built-in statement-level checks, including balance-sheet, cash and MRR cohort tie-outs. The model could be flexed through operating assumptions while maintaining linked financial outputs and was designed for both fundraising diligence and ongoing business planning.
Client Overview: A Venture-Backed Fintech SaaS Company in Bengaluru
- Business Type: Venture-backed SaaS company
- Location: Bengaluru
- Industry: Financial Services Infrastructure / Fintech
- Business Activity: Revenue from one-time implementation fees, monthly recurring revenue (MRR) and annual maintenance contracts (AMC) from digital onboarding journeys sold to banks, NBFCs, wealth managers and non-BFSI enterprises.
- Business Context: Approximately 28 employees, enterprise clients and a committed implementation pipeline, with five-year monthly projections required for an institutional fundraising process.
- Problem Summary: The existing projections were not sufficiently integrated to support scenario analysis or investor due diligence without extensive manual intervention.
The Challenge: Twelve-Month, Hard-Coded Projections
The existing projections covered only twelve months and combined cash and accrual thinking. Revenue was also hard-coded, making it difficult to model changes in key operating assumptions.
The resulting issues included:
- Limited projection visibility beyond the first year.
- Revenue assumptions that were not dynamically linked to operating drivers.
- Manual rework whenever pricing, sales volumes or team size changed.
- Inconsistencies arising from repeated manual adjustments.
- Lack of an integrated framework connecting revenue, staffing, cash flow and balance sheet.
The model therefore needed to function as an integrated financial planning system rather than simply as a projections document, a common gap that financial modelling for startups must close before an institutional raise.
Our Approach to Financial Modelling for Startups
Our financial modelling team rebuilt the model around a central assumptions and sensitivity layer. Key operating drivers included:
- Journeys signed by vertical and year.
- Year-wise implementation fees and MRR by category.
- AMC percentage and escalation.
- Collection days.
- Staffing ratios by vertical.
- Salary rates and annual increases.
- Rent per seat.
A journey register was created in which each implementation was assigned a start date. The model then calculated milestone billing, MRR and AMC through formulas. The P&L, cash flow, balance sheet, hiring engine and funding analysis were linked to this register.
This structure allowed operating assumptions to be changed without rebuilding the financial statements manually, which is the core principle behind effective financial modelling for startups preparing to raise capital.
Key Strategies Implemented in the SaaS Financial Model
Interactive Operating Levers
Journey volumes could be changed by vertical and year, with the resulting effect flowing through the 60-month model, including hiring and cash requirements.
Year-Wise Pricing Framework
Manual pricing grids were established for implementation fees and MRR by category instead of relying on blanket escalation percentages.
Integrated Audit Checks
Automated checks were incorporated across the statements, including zero balance-sheet difference, cash tie-out and MRR cohort tie-out across the five-year period.
Revenue Trend Guard
A control was introduced to flag month-on-month or quarter-on-quarter revenue declines when a change in assumptions generated such a movement.
Formula Validation
More than 200,000 formulas were recalculated and checked for errors before each delivery.
Outcome: A 60-Month, Five-Vertical Investor-Grade Model
The engagement resulted in a 60-month, five-vertical financial model with:
- Formula-driven monthly P&L, cash flow and balance sheet.
- Interactive operating and pricing assumptions.
- A journey-level revenue register.
- Integrated hiring and funding analysis.
- Automated balance-sheet, cash and MRR cohort checks.
- Revenue trend monitoring.
- More than 200,000 formulas validated before delivery.
The model also provided a framework that could continue to be used after the fundraising process for budgeting, hiring and pricing decisions. A companion case study covers how this same model fed into the company's wider fundraising readiness and pre-diligence review.
Conclusion: What Good Financial Modelling for Startups Delivers
The engagement demonstrates how an integrated financial model can connect operational assumptions with the financial information required for an institutional fundraising process, and why it forms part of broader investment readiness support.
By placing operating drivers within a controlled assumptions layer and linking them to revenue, hiring, financial statements and funding analysis, the model enabled scenario-based planning without repeated manual reconstruction. The resulting framework served both the immediate fundraising requirement and ongoing financial planning needs, showing that financial modelling for startups works best as a living planning system with built-in controls.
Frequently Asked Questions
Why do investors expect a 60-month model rather than twelve months?
Institutional investors assess how a business scales over several years, not just the next twelve months, so financial modelling for startups raising growth capital typically covers a five-year horizon. A 60-month monthly model shows revenue growth, hiring, cash requirements and funding needs over the full investment horizon, and lets investors test how changes in assumptions affect each of these.
What makes a financial model formula-driven?
All inputs sit in a central assumptions and sensitivity layer, and every output, including the P&L, cash flow and balance sheet, is calculated from those inputs by formula. When pricing, volumes or staffing change, the statements update automatically instead of being rebuilt manually.
What is an MRR cohort tie-out?
It is a check that the monthly recurring revenue built up from individual customer cohorts or journeys reconciles with the MRR reported in the financial statements. In this model, it ran alongside balance-sheet and cash tie-outs across the full five-year period.
How does a journey register help a SaaS model?
Each implementation is given a start date, and the model calculates milestone billing, MRR and AMC from it by formula. This links revenue directly to operating activity, so changes to the sales plan flow through to hiring, cash and funding analysis.
Can the model be reused after the fundraise?
Yes. Because it is driven by operating assumptions rather than fixed numbers, the model was designed to support budgeting, hiring and pricing decisions after the fundraising process as well.
Need an Investor-Grade Model?
APCALLP's startup advisory practice builds formula-driven models for founders in Bengaluru, Kochi and Kozhikode. Contact us to discuss your projections.
