Business Lincolnshire Finance Forecast Tool

One-page analysis

Across 12 months, the model shows $356,881 of revenue, $116,771 of net profit, and closing cash of $127,854.

Healthy

Profitability

33% net margin

The plan generates profit by the end of the forecast. Break-even is M2, with gross margin of 72%.

Cash burn

$8,750 peak burn

1 months show negative operating cashflow before financing. Total operating burn is $8,750.

Funding

Committed funding and operating cash are enough to keep the selected cash buffer throughout the forecast.

Revenue mix

3 lines

Core product contributes 48% of revenue. Forecast revenue changes by 83% from month 1 to the final month.

No major red flags: The base case is profitable, funded, and not overly reliant on one warning signal.

Keep tracking actual sales mix, gross margin, collection timing, and monthly cash against this forecast.
Run a downside case with lower volume growth and slower cash collection before committing to spend.

Line	Type	Volume	Revenue	Direct costs	Gross profit	Margin	Revenue share
Core product	Product	2,024	$172,073	$56,683	$115,390	67%	48%
Implementation service	Service	270	$121,709	$32,456	$89,253	73%	34%
Monthly support	Service	664	$63,099	$11,956	$51,143	81%	18%
Total		2,959	$356,881	$101,094	$255,787	72%	100%

Month	Volume	Revenue	Direct costs	Gross profit	Fixed costs	One-off costs	Tax	Net profit
M1	173	$21,625	$6,150	$15,475	$7,900	$12,000	$0	-$4,425
M2	184	$22,827	$6,488	$16,339	$7,900	$0	$1,772	$6,666
M3	195	$24,100	$6,846	$17,254	$7,900	$0	$1,964	$7,389
M4	207	$25,448	$7,225	$18,223	$7,900	$0	$2,168	$8,155
M5	220	$26,877	$7,626	$19,251	$7,900	$0	$2,384	$8,967
M6	234	$28,390	$8,050	$20,340	$7,900	$0	$2,612	$9,828
M7	249	$29,994	$8,499	$21,495	$7,900	$0	$2,855	$10,740
M8	264	$31,695	$8,974	$22,720	$7,900	$0	$3,112	$11,708
M9	281	$33,497	$9,478	$24,019	$7,900	$0	$3,385	$12,734
M10	298	$35,408	$10,010	$25,398	$7,900	$0	$3,675	$13,823
M11	317	$37,435	$10,575	$26,860	$7,900	$0	$3,982	$14,979
M12	337	$39,585	$11,172	$28,412	$7,900	$0	$4,308	$16,205
Total	2,959	$356,881	$101,094	$255,787	$94,800	$12,000	$32,217	$116,771

Month	Opening cash	Cash receipts	Funding in	Operating outflows	Launch and capex	Tax	Net cashflow	Closing cash
M1	$15,000	$17,300	$10,000	$14,050	$12,000	$0	$1,250	$16,250
M2	$16,250	$22,587	$0	$14,388	$6,000	$1,772	$426	$16,676
M3	$16,676	$23,845	$0	$14,746	$0	$1,964	$7,135	$23,811
M4	$23,811	$25,179	$0	$15,125	$0	$2,168	$7,886	$31,696
M5	$31,696	$26,591	$0	$15,526	$0	$2,384	$8,681	$40,378
M6	$40,378	$28,088	$0	$15,950	$0	$2,612	$9,525	$49,903
M7	$49,903	$29,674	$0	$16,399	$0	$2,855	$10,419	$60,322
M8	$60,322	$31,355	$0	$16,874	$0	$3,112	$11,368	$71,690
M9	$71,690	$33,137	$0	$17,378	$0	$3,385	$12,374	$84,064
M10	$84,064	$35,026	$0	$17,910	$0	$3,675	$13,441	$97,505
M11	$97,505	$37,030	$0	$18,475	$0	$3,982	$14,573	$112,079
M12	$112,079	$39,155	$0	$19,072	$0	$4,308	$15,775	$127,854

Forecast and Funding Tool