Standard templates break down when revenue follows product cycles, costs behave differently, tax runs annually across jurisdictions and inventory is bought before it is sold. This case study explains how APCALLP built an investor-ready financial model for a pre-revenue, cross-border life sciences and regulated wellness products group: 60 months, 20 sheets, three entities and more than 24,000 formula cells, with every accounting identity holding in every month.

Executive Summary: A Purpose-Built 60-Month Financial Model

What was the challenge? A pre-revenue life sciences and regulated wellness products group preparing for an institutional fund raise required a financial model capable of supporting investor scrutiny. The group operated through three entities across three jurisdictions, had 33 products across three regulatory routes, and had revenue, cost, tax and inventory characteristics that could not be represented reliably through a standard financial modelling template.

What service did the firm provide? APCALLP developed a 60-month, 20-sheet, fully formula-driven financial model covering the three entities. The model incorporated revenue, manpower, standalone and consolidated financial statements, cash flow, balance sheet, valuation, unit economics, sensitivity analysis and a dashboard, with all key assumptions centralised on a single input sheet.

What was the result? The completed workbook contained more than 24,000 formula cells, with no broken references or computed errors reported in the source document. The balance sheet tallied across all 60 months, and cash per the balance sheet reconciled with cash per the cash flow statement for every month.

Client Overview: A Three-Entity Life Sciences and Wellness Products Group

  • Business Type: Pre-revenue cross-border life sciences and regulated wellness products group
  • Location: Operations across three jurisdictions
  • Industry: Life sciences and regulated wellness products
  • Business Activity: An intellectual property holding entity, a European manufacturing and supply entity, and an Indian distribution and clinical operations entity, with a defined catalogue of 33 products across three regulatory routes and a founding team of three.
  • Problem Summary: A purpose-built model was needed to support an institutional fund raise. Date-driven product sales cycles, different cost behaviours, annual taxation with loss carry-forward across jurisdictions, and inventory purchases preceding sales made a conventional template unsuitable.

The Challenge: Why a Standard Template Would Not Work

To be an investor-ready financial model, it needed to reflect several features of the underlying business:

  • Date-driven revenue: Revenue did not follow a uniform monthly run rate. Each product had its own start month, delivery cycle and units per cycle, requiring revenue to be driven by a date-based cycle counter.
  • Different cost behaviours: Costs included revenue-linked, cost-of-goods-linked, headcount-linked, fixed and one-time expenses. A single cost assumption would not accurately reflect how the underlying costs behaved.
  • Annual taxation across jurisdictions: Tax had to be calculated annually, incorporating loss carry-forward and different tax rates across three jurisdictions rather than being treated as a simple monthly percentage.
  • Inventory preceding sales: Goods were purchased and shipped before they were sold, so the working capital model needed to position inventory ahead of the associated revenue.
  • Investor-specific questions: The model needed to provide a basis for analysing pre-revenue cash requirements, funding tranches, product-level margins and changes in the consolidated position under different assumptions.

Our Approach to Building an Investor-Ready Financial Model

Drawing on APCALLP's financial modelling services, the model was constructed around four core principles:

  • Centralised assumptions: Every assumption was placed on a single input sheet, with other workbook cells referring back to those assumptions through formulas.
  • Formula-driven outputs: No output sheet contained manually typed numbers. Profit and loss, cash flow, balance sheet, valuation and unit economics outputs were formula-driven.
  • Built-in accounting identities: The balance sheet and other accounting relationships were constructed with dedicated check rows so that inconsistencies became immediately visible.
  • Sequential validation: Analysis layers were added only after the balance-sheet tally, cash tie-out and consolidation reconciliation held across all 60 months.

The workbook was recalculated and re-audited after significant changes, including checks for broken references, computed errors, hardcoded values in output sheets and the relevant accounting identities.

Key Modelling Strategies Implemented

Date-Driven Revenue Engine

A cycle counter compared month-end dates with individual product start dates, allowing revenue timing to update automatically when the model start date changed.

Explicit Cost Behaviour

Revenue-linked, cost-linked, headcount-linked, fixed and one-time costs were separately modelled according to their underlying behaviour.

Annual Tax With Loss Carry-Forward

Tax was calculated and charged in year-end months, with losses carried forward separately by entity and jurisdiction.

Inventory Ahead of Sales

Closing inventory was structured to account for the cost of goods required for the following month, scaled by inventory days, so that the model reflected the requirement to purchase inventory before the associated sales.

Headcount-Driven Salary Model

Salary costs were linked to headcount, salary rates and escalation assumptions, allowing the model to automatically reflect changes in hiring.

Visible Model Health Checks

Dedicated check rows with conditional formatting were used to display the key accounting identities and highlight inconsistencies when they occurred.

Outcome: 24,000+ Formula Cells and Zero Computed Errors

The engagement produced a 60-month, 20-sheet financial model covering three entities, with more than 24,000 formula cells. The source document reports no broken references or computed errors and states that the three accounting identities held in every month.

The investor-ready financial model provided an integrated framework covering:

  • Monthly financial statements for the three entities.
  • Consolidated profit and loss, cash flow and balance sheet.
  • Annual financial statement roll-ups.
  • Product-level revenue and unit economics.
  • Working capital and inventory requirements.
  • Headcount and salary projections.
  • Two valuation sheets.
  • Sensitivity analysis.
  • A financial dashboard.

The formula-driven structure also allowed assumptions to be changed during investor discussions while the corresponding cash position, balance sheet and valuation outputs updated consistently. A companion case study covers how this model supported the group's wider transaction, including valuation and term-sheet review.

Conclusion: What Makes an Investor-Ready Financial Model

The engagement converted a set of business assumptions into a structured, formula-driven financial model capable of testing the underlying business across a 60-month period, an essential part of investor readiness preparation.

An investor-ready financial model is designed not merely to present a plan, but to let the underlying drivers be examined and changed while linkages across the financial statements, valuation and operating assumptions hold. The source document also notes the workbook's potential use as a budgeting and reporting tool after the fund raise.

Frequently Asked Questions

What makes an investor-ready financial model different from a template?

It is built around how the specific business actually works. Here, that meant date-driven product revenue, separately modelled cost behaviours, annual tax with loss carry-forward by jurisdiction and inventory bought ahead of sales, all formula-driven from a single input sheet with visible accounting checks.

Why model tax annually instead of as a monthly percentage?

Tax in the group's jurisdictions is assessed annually and losses can be carried forward. Charging tax in year-end months and tracking losses separately by entity and jurisdiction gives a more accurate picture of cash and profit than applying a flat monthly rate.

How does a date-driven revenue engine work?

A cycle counter compares each month-end date with each product's start date, delivery cycle and units per cycle. Revenue timing therefore updates automatically if a launch date or the model start date moves, instead of requiring manual changes.

Which accounting checks should a fundraising model include?

This model checked that the balance sheet balanced, that cash per the balance sheet matched cash per the cash flow statement, and that consolidated profit reconciled with standalone entity profit, every month for all 60 months.

Can the model be used after the fund raise?

The source document notes its potential use as a budgeting and reporting tool after the fund raise, because the assumptions, statements and valuation remain linked and can be updated as the business develops.

Want a Model That Stands Up to Investor Scrutiny?

From Kochi, Kozhikode and Bengaluru, APCALLP combines modelling with virtual CFO services for growing companies. Get in touch to discuss your financial model.