Explore the finance pack / AI businesses

AI businesses.
The numbers behind the decisions.

Does additional usage improve contribution after model and infrastructure costs, and which pricing or provider decisions protect the margin?

Northstar Applied Intelligence — fictional

AI businesses · 31 August 2026 · EUR

Download the full Excel model ↓
Fictional company, records and figures. Real platform names identify example systems, without implying client relationships or partnerships.

CFO review

August usage revenue is €173,250 against €86,178 in model costs. Usage contribution before shared costs is 50.3%.

August EBITDA is €-1,988. The Base case closes December with €1,384,423 cash.

The lowest daily cash stays €989,714 above the reserve.

August revenue€409,215Fictional actuals
August gross margin56.0%After cost of revenue
August EBITDA−€1,988Before depreciation, interest and tax
Lowest daily cash€1,239,7142026-11-25 · Base
Financial performance
MetricAugust actualYTD actualFull-year actual + forecast
Total revenue€409,215€2,513,630€4,477,440
Gross profit€229,212€1,368,313€2,447,067
EBITDA−€1,988−€307,687−€215,733
Net profit−€8,266−€350,495−€301,302

Entirely fictional. €171,000 opening AR is overdue; €27,500 of AP awaits approval, review or hold release.

Performance and budget

The original budget remains fixed when the case changes. Variance is actual minus budget. Positive expense variances are favourable because expenses are negative.

Actual versus fixed original budget
MetricAugust actualAugust budgetVarianceYTD actualYTD budget
Subscription revenue€132,765€144,500−€11,735€861,780€918,000
Usage / onboarding revenue€173,250€205,000−€31,750€1,002,550€1,220,000
Enterprise platform revenue€103,200€101,500€1,700€649,300€658,000
Total revenue€409,215€451,000−€41,785€2,513,630€2,796,000
Support payroll−€46,375−€48,100€1,725−€333,900−€348,400
Hosting / model costs−€86,178−€114,600€28,422−€496,267−€698,400
Cloud commitments and platform costs−€47,450−€48,600€1,150−€315,150−€338,400
Total cost of revenue−€180,003−€211,300€31,297−€1,145,317−€1,385,200
Gross profit€229,212€239,700−€10,488€1,368,313€1,410,800
Gross margin56.0%53.1%2.9%54.4%50.5%
Product development payroll−€113,850−€108,200−€5,650−€814,200−€792,800
Sales payroll−€41,850−€40,800−€1,050−€291,400−€287,200
Acquisition and brand spend−€32,400−€31,000−€1,400−€225,600−€220,000
Administration payroll−€23,600−€23,600€0−€188,800−€188,800
Office and administration−€13,000−€13,000€0−€104,000−€104,000
Professional fees−€6,500−€6,500€0−€52,000−€52,000
Operating expenses−€231,200−€223,100−€8,100−€1,676,000−€1,644,800
EBITDA−€1,988€16,600−€18,588−€307,687−€234,000
EBITDA margin-0.5%3.7%-4.2%-12.2%-8.4%
Depreciation−€5,167−€4,902−€265−€33,167−€32,496
Operating profit−€7,155€11,698−€18,853−€340,853−€266,496
Interest−€1,110−€1,110€0−€9,642−€9,642
Profit before tax−€8,266€10,588−€18,853−€350,495−€276,138
Illustrative current tax€0−€2,118€2,118€0−€2,118
Net profit−€8,266€8,470−€16,736−€350,495−€278,255
Monthly profit and loss
MetricJan-26 AFeb-26 AMar-26 AApr-26 AMay-26 AJun-26 AJul-26 AAug-26 ASept-26 FOct-26 FNov-26 FDec-26 F
Subscription revenue€82,680€89,835€96,990€104,145€111,300€118,455€125,610€132,765€139,920€147,075€154,230€161,385
Usage / onboarding revenue€92,800€98,600€107,300€114,000€125,400€137,200€154,000€173,250€189,000€210,600€233,200€259,700
Enterprise platform revenue€60,200€64,500€73,100€77,400€86,000€90,300€94,600€103,200€107,500€116,100€120,400€124,700
Total revenue€235,680€252,935€277,390€295,545€322,700€345,955€374,210€409,215€436,420€473,775€507,830€545,785
Support payroll−€37,100−€38,425−€39,750−€41,075−€42,400−€43,725−€45,050−€46,375−€47,700−€49,025−€50,350−€51,675
Hosting / model costs−€46,028−€48,562−€52,475−€56,327−€61,517−€68,014−€77,167−€86,178−€95,049−€105,127−€117,719−€130,110
Cloud commitments and platform costs−€34,500−€35,350−€36,200−€37,050−€37,900−€40,100−€46,600−€47,450−€58,300−€59,150−€60,000−€60,850
Total cost of revenue−€117,628−€122,337−€128,425−€134,452−€141,817−€151,839−€168,817−€180,003−€201,049−€213,302−€228,069−€242,635
Gross profit€118,052€130,598€148,965€161,093€180,883€194,116€205,393€229,212€235,371€260,473€279,761€303,150
Gross margin50.1%51.6%53.7%54.5%56.1%56.1%54.9%56.0%53.9%55.0%55.1%55.5%
Product development payroll−€89,700−€93,150−€96,600−€100,050−€103,500−€106,950−€110,400−€113,850−€117,300−€120,750−€124,200−€127,650
Sales payroll−€31,000−€32,550−€34,100−€35,650−€37,200−€38,750−€40,300−€41,850−€43,400−€44,950−€46,500−€48,050
Acquisition and brand spend−€24,000−€25,200−€26,400−€27,600−€28,800−€30,000−€31,200−€32,400−€33,600−€34,800−€36,000−€37,200
Administration payroll−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600
Office and administration−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000
Professional fees−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500
Operating expenses−€187,800−€194,000−€200,200−€206,400−€212,600−€218,800−€225,000−€231,200−€237,400−€243,600−€249,800−€256,000
EBITDA−€69,748−€63,402−€51,235−€45,307−€31,717−€24,684−€19,607−€1,988−€2,029€16,873€29,961€47,150
EBITDA margin-29.6%-25.1%-18.5%-15.3%-9.8%-7.1%-5.2%-0.5%-0.5%3.6%5.9%8.6%
Depreciation−€3,222−€3,458−€3,708−€3,972−€4,250−€4,542−€4,847−€5,167−€5,500−€5,847−€6,208−€6,583
Operating profit−€72,970−€66,860−€54,943−€49,279−€35,967−€29,226−€24,454−€7,155−€7,529€11,026€23,752€40,566
Interest−€1,300−€1,273−€1,246−€1,219−€1,192−€1,165−€1,138−€1,110−€1,083−€1,056−€1,029−€1,002
Profit before tax−€74,270−€68,133−€56,189−€50,498−€37,158−€30,390−€25,591−€8,266−€8,613€9,969€22,723€39,564
Illustrative current tax€0€0€0€0€0€0€0€0€0−€1,994−€4,545−€7,913
Net profit−€74,270−€68,133−€56,189−€50,498−€37,158−€30,390−€25,591−€8,266−€8,613€7,976€18,179€31,651

Integrated financial statements

The operating build feeds all three statements. Retained earnings follow profit; closing cash reconciles to the indirect cash-flow statement.

Negative forecast cash means a funding requirement. Figures exclude VAT/sales tax and foreign exchange; current-tax assumptions are illustrative.

Monthly profit and loss
MetricJan-26 AFeb-26 AMar-26 AApr-26 AMay-26 AJun-26 AJul-26 AAug-26 ASept-26 FOct-26 FNov-26 FDec-26 F
Subscription revenue€82,680€89,835€96,990€104,145€111,300€118,455€125,610€132,765€139,920€147,075€154,230€161,385
Usage / onboarding revenue€92,800€98,600€107,300€114,000€125,400€137,200€154,000€173,250€189,000€210,600€233,200€259,700
Enterprise platform revenue€60,200€64,500€73,100€77,400€86,000€90,300€94,600€103,200€107,500€116,100€120,400€124,700
Total revenue€235,680€252,935€277,390€295,545€322,700€345,955€374,210€409,215€436,420€473,775€507,830€545,785
Support payroll−€37,100−€38,425−€39,750−€41,075−€42,400−€43,725−€45,050−€46,375−€47,700−€49,025−€50,350−€51,675
Hosting / model costs−€46,028−€48,562−€52,475−€56,327−€61,517−€68,014−€77,167−€86,178−€95,049−€105,127−€117,719−€130,110
Cloud commitments and platform costs−€34,500−€35,350−€36,200−€37,050−€37,900−€40,100−€46,600−€47,450−€58,300−€59,150−€60,000−€60,850
Total cost of revenue−€117,628−€122,337−€128,425−€134,452−€141,817−€151,839−€168,817−€180,003−€201,049−€213,302−€228,069−€242,635
Gross profit€118,052€130,598€148,965€161,093€180,883€194,116€205,393€229,212€235,371€260,473€279,761€303,150
Gross margin50.1%51.6%53.7%54.5%56.1%56.1%54.9%56.0%53.9%55.0%55.1%55.5%
Product development payroll−€89,700−€93,150−€96,600−€100,050−€103,500−€106,950−€110,400−€113,850−€117,300−€120,750−€124,200−€127,650
Sales payroll−€31,000−€32,550−€34,100−€35,650−€37,200−€38,750−€40,300−€41,850−€43,400−€44,950−€46,500−€48,050
Acquisition and brand spend−€24,000−€25,200−€26,400−€27,600−€28,800−€30,000−€31,200−€32,400−€33,600−€34,800−€36,000−€37,200
Administration payroll−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600−€23,600
Office and administration−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000−€13,000
Professional fees−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500−€6,500
Operating expenses−€187,800−€194,000−€200,200−€206,400−€212,600−€218,800−€225,000−€231,200−€237,400−€243,600−€249,800−€256,000
EBITDA−€69,748−€63,402−€51,235−€45,307−€31,717−€24,684−€19,607−€1,988−€2,029€16,873€29,961€47,150
EBITDA margin-29.6%-25.1%-18.5%-15.3%-9.8%-7.1%-5.2%-0.5%-0.5%3.6%5.9%8.6%
Depreciation−€3,222−€3,458−€3,708−€3,972−€4,250−€4,542−€4,847−€5,167−€5,500−€5,847−€6,208−€6,583
Operating profit−€72,970−€66,860−€54,943−€49,279−€35,967−€29,226−€24,454−€7,155−€7,529€11,026€23,752€40,566
Interest−€1,300−€1,273−€1,246−€1,219−€1,192−€1,165−€1,138−€1,110−€1,083−€1,056−€1,029−€1,002
Profit before tax−€74,270−€68,133−€56,189−€50,498−€37,158−€30,390−€25,591−€8,266−€8,613€9,969€22,723€39,564
Illustrative current tax€0€0€0€0€0€0€0€0€0−€1,994−€4,545−€7,913
Net profit−€74,270−€68,133−€56,189−€50,498−€37,158−€30,390−€25,591−€8,266−€8,613€7,976€18,179€31,651
Monthly balance sheet
MetricJan-26 AFeb-26 AMar-26 AApr-26 AMay-26 AJun-26 AJul-26 AAug-26 ASept-26 FOct-26 FNov-26 FDec-26 F
Cash / (unfunded requirement)€1,811,977€1,727,902€1,646,747€1,579,822€1,529,238€1,471,990€1,429,346€1,407,072€1,391,999€1,380,597€1,376,399€1,384,423
Receivables€162,500€180,000€197,500€215,000€232,500€250,000€267,500€285,000€366,371€387,278€425,879€442,750
Prepayments€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000
Tax prepayment€0€0€0€0€0€4,000€4,000€4,000€16,000€14,006€9,461€13,549
Current assets€2,004,477€1,937,902€1,874,247€1,824,822€1,791,738€1,755,990€1,730,846€1,726,072€1,804,370€1,811,881€1,841,740€1,870,722
Fixed assets at cost€188,000€196,500€205,500€215,000€225,000€235,500€246,500€258,000€270,000€282,500€295,500€309,000
Accumulated depreciation€51,222€54,681€58,389€62,361€66,611€71,153€76,000€81,167€86,667€92,514€98,722€105,306
Net fixed assets€136,778€141,819€147,111€152,639€158,389€164,347€170,500€176,833€183,333€189,986€196,778€203,694
Total assets€2,141,255€2,079,722€2,021,358€1,977,461€1,950,127€1,920,337€1,901,346€1,902,905€1,987,704€2,001,867€2,038,518€2,074,416
Payables€66,375€74,750€83,125€91,500€99,875€108,250€116,625€125,000€220,186€224,925€245,171€251,193
Payroll accruals€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000
Deferred revenue€45,150€48,375€54,825€58,050€64,500€67,725€70,950€77,400€80,625€87,075€90,300€93,525
Tax payable€18,000€18,000€6,000€6,000€6,000€0€0€0€0€0€0€0
Current operating liabilities€161,525€173,125€175,950€187,550€202,375€207,975€219,575€234,400€332,811€344,000€367,471€376,718
Debt€235,000€230,000€225,000€220,000€215,000€210,000€205,000€200,000€195,000€190,000€185,000€180,000
Total liabilities€396,525€403,125€400,950€407,550€417,375€417,975€424,575€434,400€527,811€534,000€552,471€556,718
Share capital€500,000€500,000€500,000€500,000€500,000€500,000€500,000€500,000€500,000€500,000€500,000€500,000
Retained earnings€1,244,730€1,176,597€1,120,408€1,069,911€1,032,752€1,002,362€976,771€968,505€959,892€967,868€986,046€1,017,698
Equity€1,744,730€1,676,597€1,620,408€1,569,911€1,532,752€1,502,362€1,476,771€1,468,505€1,459,892€1,467,868€1,486,046€1,517,698
Liabilities and equity€2,141,255€2,079,722€2,021,358€1,977,461€1,950,127€1,920,337€1,901,346€1,902,905€1,987,704€2,001,867€2,038,518€2,074,416
Monthly indirect cash flow
MetricJan-26 AFeb-26 AMar-26 AApr-26 AMay-26 AJun-26 AJul-26 AAug-26 ASept-26 FOct-26 FNov-26 FDec-26 F
Net profit−€74,270−€68,133−€56,189−€50,498−€37,158−€30,390−€25,591−€8,266−€8,613€7,976€18,179€31,651
Depreciation add-back€3,222€3,458€3,708€3,972€4,250€4,542€4,847€5,167€5,500€5,847€6,208€6,583
Receivables cash effect−€17,500−€17,500−€17,500−€17,500−€17,500−€17,500−€17,500−€17,500−€81,371−€20,907−€38,601−€16,871
Prepayment cash effect€0€0€0€0€0€0€0€0€0€0€0€0
Payable cash effect€8,375€8,375€8,375€8,375€8,375€8,375€8,375€8,375€95,186€4,738€20,247€6,022
Accrual cash effect€0€0€0€0€0€0€0€0€0€0€0€0
Deferred-revenue cash effect−€44,850€3,225€6,450€3,225€6,450€3,225€3,225€6,450€3,225€6,450€3,225€3,225
Current-tax balance cash effect€0€0−€12,000€0€0−€10,000€0€0−€12,000€1,994€4,545−€4,087
Operating cash flow−€125,023−€70,575−€67,155−€52,425−€35,583−€41,749−€26,644−€5,774€1,928€6,098€13,802€26,524
Capital expenditure−€8,000−€8,500−€9,000−€9,500−€10,000−€10,500−€11,000−€11,500−€12,000−€12,500−€13,000−€13,500
Investing cash flow−€8,000−€8,500−€9,000−€9,500−€10,000−€10,500−€11,000−€11,500−€12,000−€12,500−€13,000−€13,500
Principal repayment−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000
Financing cash flow−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000−€5,000
Net cash change−€138,023−€84,075−€81,155−€66,925−€50,583−€57,249−€42,644−€22,274−€15,072−€11,402−€4,198€8,024
Opening cash€1,950,000€1,811,977€1,727,902€1,646,747€1,579,822€1,529,238€1,471,990€1,429,346€1,407,072€1,391,999€1,380,597€1,376,399
Closing cash€1,811,977€1,727,902€1,646,747€1,579,822€1,529,238€1,471,990€1,429,346€1,407,072€1,391,999€1,380,597€1,376,399€1,384,423

Usage, pricing and product contribution

Subscriptions, metered usage and enterprise fees have separate economics. Token price, model mix, caching and output-token costs determine usage contribution.

Cloud expense includes the greater of consumption and minimum commitment. Higher usage can reduce profitability if realised price falls faster than unit costs.

Industry operating build
MetricJan-26 AFeb-26 AMar-26 AApr-26 AMay-26 AJun-26 AJul-26 AAug-26 ASept-26 FOct-26 FNov-26 FDec-26 F
Subscription accounts5205656106557007457908358809259701,015
Subscription monthly price€159€159€159€159€159€159€159€159€159€159€159€159
Subscription revenue€82,680€89,835€96,990€104,145€111,300€118,455€125,610€132,765€139,920€147,075€154,230€161,385
Metered million tokens16,00017,00018,50020,00022,00024,50028,00031,50035,00039,00044,00049,000
Realised revenue / million tokens5.85.85.85.75.75.65.55.55.45.45.35.3
Usage revenue€92,800€98,600€107,300€114,000€125,400€137,200€154,000€173,250€189,000€210,600€233,200€259,700
Enterprise workspaces141517182021222425272829
Monthly platform fee€4,300€4,300€4,300€4,300€4,300€4,300€4,300€4,300€4,300€4,300€4,300€4,300
Enterprise revenue€60,200€64,500€73,100€77,400€86,000€90,300€94,600€103,200€107,500€116,100€120,400€124,700
Total recognised revenue€235,680€252,935€277,390€295,545€322,700€345,955€374,210€409,215€436,420€473,775€507,830€545,785
Input million tokens11,84012,58013,69014,80016,28018,13020,72023,31025,90028,86032,56036,260
Output million tokens4,1604,4204,8105,2005,7206,3707,2808,1909,10010,14011,44012,740
Cached input million tokens2,3682,767.63,285.63,8484,558.45,4396,630.47,925.49,32410,966.813,02415,229.2
Uncached input million tokens9,4729,812.410,404.410,95211,721.612,69114,089.615,384.616,57617,893.219,53621,030.8
Uncached input cost€16,102€16,681€17,687€18,618€19,927€21,575€23,952€26,154€28,179€30,418€33,211€35,752
Cached input cost€805€941€1,117€1,308€1,550€1,849€2,254€2,695€3,170€3,729€4,428€5,178
Output model cost€29,120€30,940€33,670€36,400€40,040€44,590€50,960€57,330€63,700€70,980€80,080€89,180
Total model costs€46,028€48,562€52,475€56,327€61,517€68,014€77,167€86,178€95,049€105,127€117,719€130,110
Model cost / million tokens2.882.862.842.822.82.782.762.742.722.72.682.66
Usage contribution before shared costs€46,772€50,038€54,825€57,673€63,883€69,186€76,833€87,072€93,951€105,473€115,481€129,590
Usage contribution margin50.4%50.7%51.1%50.6%50.9%50.4%49.9%50.3%49.7%50.1%49.5%49.9%
Consumed compute cost€15,500€17,670€19,840€22,010€24,180€26,350€28,520€30,690€32,860€35,030€37,200€39,370
Minimum cloud commitment€25,000€25,000€25,000€25,000€25,000€25,000€32,000€32,000€42,000€42,000€42,000€42,000
Cloud expense€25,000€25,000€25,000€25,000€25,000€26,350€32,000€32,000€42,000€42,000€42,000€42,000
Unused cloud commitment€9,500€7,330€5,160€2,990€820€0€3,480€1,310€9,140€6,970€4,800€2,630
Storage security and observability€9,500€10,350€11,200€12,050€12,900€13,750€14,600€15,450€16,300€17,150€18,000€18,850
Invoiced billings€190,830€256,160€283,840€298,770€329,150€349,180€377,435€415,665€439,645€480,225€511,055€549,010
Opening deferred revenue€90,000€45,150€48,375€54,825€58,050€64,500€67,725€70,950€77,400€80,625€87,075€90,300
Closing deferred revenue€45,150€48,375€54,825€58,050€64,500€67,725€70,950€77,400€80,625€87,075€90,300€93,525
August product contribution
ProductRevenueModel costsShared costsContributionMarginAllocation
Subscription€132,765€0−€30,440€102,32577.1%Revenue share
Usage API€173,250−€86,178−€39,723€47,34927.3%Revenue share
Enterprise€103,200€0−€23,662€79,53877.1%Revenue share
Loaded payroll and staffing
MetricJan-26 AFeb-26 AMar-26 AApr-26 AMay-26 AJun-26 AJul-26 AAug-26 ASept-26 FOct-26 FNov-26 FDec-26 F
Support FTE77.257.57.7588.258.58.7599.259.59.75
Monthly loaded support pay€5,300€5,300€5,300€5,300€5,300€5,300€5,300€5,300€5,300€5,300€5,300€5,300
Support payroll€37,100€38,425€39,750€41,075€42,400€43,725€45,050€46,375€47,700€49,025€50,350€51,675
Development FTE1313.51414.51515.51616.51717.51818.5
Monthly loaded development pay€6,900€6,900€6,900€6,900€6,900€6,900€6,900€6,900€6,900€6,900€6,900€6,900
Development payroll€89,700€93,150€96,600€100,050€103,500€106,950€110,400€113,850€117,300€120,750€124,200€127,650
Sales FTE55.255.55.7566.256.56.7577.257.57.75
Monthly loaded sales pay€6,200€6,200€6,200€6,200€6,200€6,200€6,200€6,200€6,200€6,200€6,200€6,200
Sales payroll€31,000€32,550€34,100€35,650€37,200€38,750€40,300€41,850€43,400€44,950€46,500€48,050
Administration FTE444444444444
Monthly loaded administration pay€5,900€5,900€5,900€5,900€5,900€5,900€5,900€5,900€5,900€5,900€5,900€5,900
Administration payroll€23,600€23,600€23,600€23,600€23,600€23,600€23,600€23,600€23,600€23,600€23,600€23,600
Total FTE293031323334353637383940
Total payroll€181,400€187,725€194,050€200,375€206,700€213,025€219,350€225,675€232,000€238,325€244,650€250,975
Active period assumptions
MetricJan-26 AFeb-26 AMar-26 AApr-26 AMay-26 AJun-26 AJul-26 AAug-26 ASept-26 FOct-26 FNov-26 FDec-26 F
Support FTE77.257.57.7588.258.58.7599.259.59.75
Loaded support pay per month€5,300€5,300€5,300€5,300€5,300€5,300€5,300€5,300€5,300€5,300€5,300€5,300
Product development FTE1313.51414.51515.51616.51717.51818.5
Loaded development pay per month€6,900€6,900€6,900€6,900€6,900€6,900€6,900€6,900€6,900€6,900€6,900€6,900
Sales FTE55.255.55.7566.256.56.7577.257.57.75
Loaded sales pay per month€6,200€6,200€6,200€6,200€6,200€6,200€6,200€6,200€6,200€6,200€6,200€6,200
Administration FTE444444444444
Loaded administration pay per month€5,900€5,900€5,900€5,900€5,900€5,900€5,900€5,900€5,900€5,900€5,900€5,900
Acquisition and brand spend€24,000€25,200€26,400€27,600€28,800€30,000€31,200€32,400€33,600€34,800€36,000€37,200
Office and administration€13,000€13,000€13,000€13,000€13,000€13,000€13,000€13,000€13,000€13,000€13,000€13,000
Professional fees€6,500€6,500€6,500€6,500€6,500€6,500€6,500€6,500€6,500€6,500€6,500€6,500
Capital expenditure€8,000€8,500€9,000€9,500€10,000€10,500€11,000€11,500€12,000€12,500€13,000€13,500
Illustrative current tax paid€0€0€12,000€0€0€10,000€0€0€12,000€0€0€12,000
Target receivable days252525252525252525252525
New vendor payable days282828282828282828282828
Opening receivable delay (days)000000000000
Subscription accounts5205656106557007457908358809259701,015
Subscription monthly price€159€159€159€159€159€159€159€159€159€159€159€159
Metered million tokens16,00017,00018,50020,00022,00024,50028,00031,50035,00039,00044,00049,000
Realised revenue / million tokens5.85.85.85.75.75.65.55.55.45.45.35.3
Input share of metered tokens74.0%74.0%74.0%74.0%74.0%74.0%74.0%74.0%74.0%74.0%74.0%74.0%
Input cost / million tokens1.71.71.71.71.71.71.71.71.71.71.71.7
Output cost / million tokens777777777777
Input token cache share20.0%22.0%24.0%26.0%28.0%30.0%32.0%34.0%36.0%38.0%40.0%42.0%
Cached input discount80.0%80.0%80.0%80.0%80.0%80.0%80.0%80.0%80.0%80.0%80.0%80.0%
Enterprise workspaces141517182021222425272829
Enterprise monthly platform fee€4,300€4,300€4,300€4,300€4,300€4,300€4,300€4,300€4,300€4,300€4,300€4,300
Compute hours5,0005,7006,4007,1007,8008,5009,2009,90010,60011,30012,00012,700
Compute hourly cost3.13.13.13.13.13.13.13.13.13.13.13.1
Monthly cloud commitment€25,000€25,000€25,000€25,000€25,000€25,000€32,000€32,000€42,000€42,000€42,000€42,000
Storage security and observability€9,500€10,350€11,200€12,050€12,900€13,750€14,600€15,450€16,300€17,150€18,000€18,850
December usage contribution margin sensitivity
Token price (EUR)Input costsOutput costs −10%Selected output costsOutput costs +10%
4.24€40,93041.7%37.4%33.1%
4.77€40,93048.1%44.3%40.5%
5.3€40,93053.3%49.9%46.5%
5.83€40,93057.6%54.5%51.3%
6.36€40,93061.1%58.2%55.4%

Receivables and payment controls

Opening AR totals €285,000; overdue AR is €171,000. Receipt promises feed the dated cash schedule.

Opening AP totals €125,000. €27,500 remains unscheduled until approval, review and hold conditions are satisfied.

Opening receivables
RecordInvoiceDueOutstandingOverdue daysReceipt
AR-0012026-06-052026-07-05€25,650572026-09-04
AR-0022026-06-072026-07-07€34,200552026-09-11
AR-0032026-06-092026-07-09€37,050532026-09-18
AR-0042026-07-112026-08-11€39,900202026-09-04
AR-0052026-07-132026-08-13€34,200182026-09-11
AR-0062026-08-152026-09-15€39,90002026-09-18
AR-0072026-08-172026-09-17€37,05002026-09-25
AR-0082026-08-192026-09-19€37,05002026-09-25
Payables and approval prerequisites
RecordInvoice totalPaidOutstandingApprovalReviewHoldPayment dateNext action
AP-001€11,250€0€11,250PendingCompleteYesUnscheduledApproval required
AP-002€18,750€3,750€15,000ApprovedCompleteNo2026-09-11Ready
AP-003€16,250€0€16,250ApprovedPendingNoUnscheduledReview required
AP-004€17,500€0€17,500ApprovedCompleteNo2026-09-04Ready
AP-005€17,250€2,250€15,000ApprovedCompleteNo2026-09-11Ready
AP-006€17,500€0€17,500ApprovedCompleteNo2026-09-18Ready
AP-007€16,250€0€16,250ApprovedCompleteNo2026-09-25Ready
AP-008€16,250€0€16,250ApprovedCompleteNo2026-09-25Ready
Working-capital roll-forwards
MetricJan-26 AFeb-26 AMar-26 AApr-26 AMay-26 AJun-26 AJul-26 AAug-26 ASept-26 FOct-26 FNov-26 FDec-26 F
Opening receivables€145,000€162,500€180,000€197,500€215,000€232,500€250,000€267,500€285,000€366,371€387,278€425,879
Invoiced billings€190,830€256,160€283,840€298,770€329,150€349,180€377,435€415,665€439,645€480,225€511,055€549,010
Customer receipts€173,330€238,660€266,340€281,270€311,650€331,680€359,935€398,165€358,274€459,318€472,454€532,139
Closing receivables€162,500€180,000€197,500€215,000€232,500€250,000€267,500€285,000€366,371€387,278€425,879€442,750
Implied AR / billings × month days26.419.6821.5721.5921.921.4821.9721.2625252525
Opening payables€58,000€66,375€74,750€83,125€91,500€99,875€108,250€116,625€125,000€220,186€224,925€245,171
Vendor expenses€124,028€128,612€134,575€140,477€147,717€157,614€174,467€185,528€206,449€218,577€233,219€247,660
Vendor payments€115,653€120,237€126,200€132,102€139,342€149,239€166,092€177,153€111,263€213,839€212,972€241,639
Closing payables€66,375€74,750€83,125€91,500€99,875€108,250€116,625€125,000€220,186€224,925€245,171€251,193
Prepayments€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000
Payroll accruals€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000

13-week cash and daily exposure

The lowest scheduled end-of-day cash is €1,239,714 on 2026-11-25. The lowest daily cash stays €989,714 above the reserve.

Opening cash includes the complete 31 August bank close. Week 1 covers 1–6 September and week 13 ends 29 November. Cash dates are explicit planning assumptions.

Scheduled weekly closing cash · EUR
Scheduled weekly closing cashW1: €1,455,122; W2: €1,481,522; W3: €1,567,752; W4: €1,365,352; W5: €1,391,999; W6: €1,379,499; W7: €1,489,965; W8: €1,251,640; W9: €1,380,597; W10: €1,367,597; W11: €1,484,364; W12: €1,484,364; W13: €1,376,3990k439k878k1,317k1,756kW1: €1,455,122W1W2: €1,481,522W2W3: €1,567,752W3W4: €1,365,352W4W5: €1,391,999W5W6: €1,379,499W6W7: €1,489,965W7W8: €1,251,640W8W9: €1,380,597W9W10: €1,367,597W10W11: €1,484,364W11W12: €1,484,364W12W13: €1,376,399W13
Closing cashMinimum cash reserve €250,000
Weekly cash forecast
WeekStartEndOpeningReceiptsVendorsPayrollTaxInterestCapexPrincipalClosingHeadroom
W12026-09-012026-09-06€1,407,072€65,550−€17,500€0€0€0€0€0€1,455,122€1,205,122
W22026-09-072026-09-13€1,455,122€68,400−€30,000€0€0€0−€12,000€0€1,481,522€1,231,522
W32026-09-142026-09-20€1,481,522€109,923−€23,693€0€0€0€0€0€1,567,752€1,317,752
W42026-09-212026-09-27€1,567,752€74,100−€32,500−€232,000−€12,000€0€0€0€1,365,352€1,115,352
W52026-09-282026-10-04€1,365,352€40,301−€7,570€0€0−€1,083€0−€5,000€1,391,999€1,141,999
W62026-10-052026-10-11€1,391,999€0€0€0€0€0−€12,500€0€1,379,499€1,129,499
W72026-10-122026-10-18€1,379,499€206,693−€96,227€0€0€0€0€0€1,489,965€1,239,965
W82026-10-192026-10-25€1,489,965€0€0−€238,325€0€0€0€0€1,251,640€1,001,640
W92026-10-262026-11-01€1,251,640€252,625−€117,611€0€0−€1,056€0−€5,000€1,380,597€1,130,597
W102026-11-022026-11-08€1,380,597€0€0€0€0€0−€13,000€0€1,367,597€1,117,597
W112026-11-092026-11-15€1,367,597€212,604−€95,838€0€0€0€0€0€1,484,364€1,234,364
W122026-11-162026-11-22€1,484,364€0€0€0€0€0€0€0€1,484,364€1,234,364
W132026-11-232026-11-29€1,484,364€259,850−€117,135−€244,650€0−€1,029€0−€5,000€1,376,399€1,126,399
Daily cash on transaction dates
DateOpeningReceiptsPaymentsClosingHeadroom
2026-09-04€1,407,072€65,550−€17,500€1,455,122€1,205,122
2026-09-08€1,455,122€0−€12,000€1,443,122€1,193,122
2026-09-11€1,443,122€68,400−€30,000€1,481,522€1,231,522
2026-09-15€1,481,522€32,973−€6,193€1,508,302€1,258,302
2026-09-18€1,508,302€76,950−€17,500€1,567,752€1,317,752
2026-09-21€1,567,752€0−€12,000€1,555,752€1,305,752
2026-09-25€1,555,752€74,100−€264,500€1,365,352€1,115,352
2026-09-28€1,365,352€40,301−€13,653€1,391,999€1,141,999
2026-10-08€1,391,999€0−€12,500€1,379,499€1,129,499
2026-10-15€1,379,499€206,693−€96,227€1,489,965€1,239,965
2026-10-25€1,489,965€0−€238,325€1,251,640€1,001,640
2026-10-28€1,251,640€252,625−€123,668€1,380,597€1,130,597
2026-11-08€1,380,597€0−€13,000€1,367,597€1,117,597
2026-11-15€1,367,597€212,604−€95,838€1,484,364€1,234,364
2026-11-25€1,484,364€0−€244,650€1,239,714€989,714
2026-11-28€1,239,714€259,850−€123,164€1,376,399€1,126,399

Supporting schedules and checks

Checks compare the financial statements, dated cash schedule and opening invoice balances. Business calculations do not depend on check results.

All demonstration records are fictional and do not establish client performance.

Financial reconciliation checks
CheckDifferenceResult
Balance sheet equation€0.000000Pass
Cash flow ties to balance sheet€0Pass
Direct to indirect cash€0.000000Pass
Revenue / cohort reconciliation€0Pass
Deferred revenue roll-forward€0Pass
Receivables roll-forward€0Pass
Payables roll-forward€0Pass
Monthly event cash to statements€0.000000Pass
Opening AR records tie to August balance€0Pass
Opening AP records tie to August balance€0Pass
Daily closing cash to week 13€0Pass
November 30 bridge€0.000000Pass
Assets, debt and tax schedules
MetricJan-26 AFeb-26 AMar-26 AApr-26 AMay-26 AJun-26 AJul-26 AAug-26 ASept-26 FOct-26 FNov-26 FDec-26 F
Opening asset cost€180,000€188,000€196,500€205,500€215,000€225,000€235,500€246,500€258,000€270,000€282,500€295,500
Capital expenditure€8,000€8,500€9,000€9,500€10,000€10,500€11,000€11,500€12,000€12,500€13,000€13,500
Closing asset cost€188,000€196,500€205,500€215,000€225,000€235,500€246,500€258,000€270,000€282,500€295,500€309,000
Opening accumulated depreciation€48,000€51,222€54,681€58,389€62,361€66,611€71,153€76,000€81,167€86,667€92,514€98,722
Depreciation charge€3,222€3,458€3,708€3,972€4,250€4,542€4,847€5,167€5,500€5,847€6,208€6,583
Closing accumulated depreciation€51,222€54,681€58,389€62,361€66,611€71,153€76,000€81,167€86,667€92,514€98,722€105,306
Net fixed assets€136,778€141,819€147,111€152,639€158,389€164,347€170,500€176,833€183,333€189,986€196,778€203,694
Opening debt€240,000€235,000€230,000€225,000€220,000€215,000€210,000€205,000€200,000€195,000€190,000€185,000
Principal repayment€5,000€5,000€5,000€5,000€5,000€5,000€5,000€5,000€5,000€5,000€5,000€5,000
Closing debt€235,000€230,000€225,000€220,000€215,000€210,000€205,000€200,000€195,000€190,000€185,000€180,000
Interest€1,300€1,273€1,246€1,219€1,192€1,165€1,138€1,110€1,083€1,056€1,029€1,002
Opening net tax balance€18,000€18,000€18,000€6,000€6,000€6,000−€4,000−€4,000−€4,000−€16,000−€14,006−€9,461
Current tax charge€0€0€0€0€0€0€0€0€0€1,994€4,545€7,913
Current tax paid€0€0€12,000€0€0€10,000€0€0€12,000€0€0€12,000
Net tax liability / (prepayment)€18,000€18,000€6,000€6,000€6,000−€4,000−€4,000−€4,000−€16,000−€14,006−€9,461−€13,549
Working-capital schedules
MetricJan-26 AFeb-26 AMar-26 AApr-26 AMay-26 AJun-26 AJul-26 AAug-26 ASept-26 FOct-26 FNov-26 FDec-26 F
Opening receivables€145,000€162,500€180,000€197,500€215,000€232,500€250,000€267,500€285,000€366,371€387,278€425,879
Invoiced billings€190,830€256,160€283,840€298,770€329,150€349,180€377,435€415,665€439,645€480,225€511,055€549,010
Customer receipts€173,330€238,660€266,340€281,270€311,650€331,680€359,935€398,165€358,274€459,318€472,454€532,139
Closing receivables€162,500€180,000€197,500€215,000€232,500€250,000€267,500€285,000€366,371€387,278€425,879€442,750
Implied AR / billings × month days26.419.6821.5721.5921.921.4821.9721.2625252525
Opening payables€58,000€66,375€74,750€83,125€91,500€99,875€108,250€116,625€125,000€220,186€224,925€245,171
Vendor expenses€124,028€128,612€134,575€140,477€147,717€157,614€174,467€185,528€206,449€218,577€233,219€247,660
Vendor payments€115,653€120,237€126,200€132,102€139,342€149,239€166,092€177,153€111,263€213,839€212,972€241,639
Closing payables€66,375€74,750€83,125€91,500€99,875€108,250€116,625€125,000€220,186€224,925€245,171€251,193
Prepayments€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000€30,000
Payroll accruals€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000€32,000

CFO decisions and follow-through

December usage contribution before shared costs is €129,590 in this case. Review pricing, routing and cloud commitments together.

The lowest daily cash stays €989,714 above the reserve.

Illustrative action register
TopicActionOwnerDueStatus
Usage marginReview realised pricing, cache performance and model routing by workload.Product lead2026-09-04Open
Cloud capacityCompare consumed capacity with minimum commitments before expansion.Engineering lead2026-09-07Open
Enterprise billingSeparate platform fees, usage charges and advances in contracts.Commercial lead2026-09-08Open
CollectionsConfirm receipt promises and resolve disputed balances.Credit control2026-09-03Open
LiquidityReview the Downside cash path before hiring or committing capacity.CFO2026-09-07Open

Inspect the formulas behind the review.

Download the linked statements, assumptions, operating schedules and controls. Change the model inputs to examine the forecast.

Download the Excel model ↓

This example shows the depth available across our finance work. Your engagement defines the models, reports and strategic deliverables included; every advanced module is not automatically included in either starting fee. Compare engagement scope.

Start with a conversation

Build the finance function
your next stage needs.

Tell us where the business stands. We’ll show you how we would run the finance function, the priorities we would address and the team behind the work.

Book a free introductionExplore the engagement and pricing