Arkfield Analytics  ·  Financial Modelling & Advisory
Three-Year Financial Model
& Scenario Analysis
Sample SaaS Company  ·  Series A Fundraising Support
Prepared By
Arkfield Analytics
Client
Sample SaaS Company
Date
May 2024
Model Version
v3.2 — Final
Classification
Confidential
Section 01
Executive Summary

Arkfield Analytics was engaged by Sample SaaS Company to develop a three-year integrated financial model in support of its Series A capital raise targeting $4.5M AUD. The model covers revenue forecasting, cost structure analysis, cash flow projections, and scenario modelling across bear, base, and bull cases.

Based on current ARR trajectory, customer acquisition data, and management assumptions, the base case projects the company reaching $8.2M ARR by FY2026 with a path to cash flow breakeven in Q3 FY2025. The Series A proceeds are sufficient to fund operations through to profitability under base and bull scenarios.

FY2026 Base ARR
$8.2M
vs $2.1M at model start
+291% over 3 years
Breakeven (Base Case)
Q3 FY25
Operating cash flow positive
18 months runway post-raise
Series A Requirement
$4.5M
24 months runway at base burn
Sufficient under all scenarios
Section 02
Key Model Assumptions

The following assumptions underpin the base case model. All assumptions were reviewed and agreed with the client's management prior to finalisation. Sensitivity analysis is presented in Section 05.

DriverFY2024 (Base)FY2025 (Base)FY2026 (Base)Basis
New Logos / Month81422Sales headcount ramp + channel partnerships
Average Contract Value$18,400$21,200$24,800Upsell to higher-tier plans + price escalation
Gross Revenue Churn14.0%11.5%9.0%CS investment improving retention
Gross Margin (SaaS)71%74%77%Infrastructure efficiencies at scale
S&M as % Revenue38%32%26%Improving CAC payback as brand matures
R&D as % Revenue22%18%15%Core product maturing, maintenance mode
G&A as % Revenue12%9%7%Fixed cost leverage at scale
Headcount Growth+12 FTE+18 FTE+14 FTESales, CS, and engineering weighted
Section 03
Revenue Model & ARR Bridge

Revenue is modelled on a subscription basis using a cohort-level ARR waterfall. New ARR, expansion ARR, and churned ARR are tracked separately to provide full visibility over net revenue retention and growth quality.

ARR Waterfall — FY2024 to FY2026
New ARR, expansion, and churn by financial year
Monthly Recurring Revenue Trajectory
Base case MRR build over 36 months
Revenue Composition by Type
Subscription, professional services, and usage-based revenue split over projection period
Section 04
Scenario Analysis

Three scenarios are modelled to bound the range of outcomes. The bear case assumes a deterioration in market conditions and slower-than-expected sales ramp. The bull case assumes accelerated channel partnerships and above-plan retention improvement.

🔻 Bear Case
Constrained Growth
FY2026 ARR$5.1M
BreakevenQ1 FY2026
Runway (post-raise)19 months
FY2026 EBITDA-$420K
Additional Raise Needed$800K bridge
📊 Base Case
Management Plan
FY2026 ARR$8.2M
BreakevenQ3 FY2025
Runway (post-raise)24 months
FY2026 EBITDA+$680K
Additional Raise NeededNone
🚀 Bull Case
Accelerated Growth
FY2026 ARR$12.4M
BreakevenQ1 FY2025
Runway (post-raise)28+ months
FY2026 EBITDA+$2.1M
Additional Raise NeededNone
ARR Trajectory — All Scenarios
Monthly ARR under bear, base, and bull assumptions
Section 05
Sensitivity Analysis

The sensitivity table below shows FY2026 EBITDA ($000s) across varying assumptions for monthly new logo growth and gross revenue churn. The highlighted cell represents the base case outcome. Green cells represent profitable scenarios; red cells represent loss-making outcomes.

FY2026 EBITDA ($K) Gross Revenue Churn Rate
6%8%9% (Base)12%15%
28 logos/mo$3,820$3,210$2,890$2,140$1,280
24 logos/mo$2,640$2,020$1,740$980-$120
22 logos/mo (Base)$1,980$1,310$680-$210-$890
18 logos/mo$820-$140-$480-$1,120-$1,840
14 logos/mo-$480-$1,020-$1,380-$2,040-$2,810

Key insight: The model is more sensitive to new logo growth rate than to churn. Even at elevated churn of 12%, the company remains profitable if new logo acquisition hits 24/month. Management should prioritise sales execution over short-term retention fixes.

Section 06
Cash Flow & Runway Analysis

The integrated cash flow model projects monthly operating cash burn against the $4.5M Series A raise. Under the base case, the company maintains a positive cash balance throughout the projection period with a minimum cash buffer of $620K in Q2 FY2025 — representing approximately 3.2 months of operating expenses at that point in time.

Cumulative Cash Position — Base Case
Monthly cash balance post Series A ($4.5M raise at model start)
Monthly Cash Burn Rate
Net operating cash flow — negative = burn, positive = generation
Section 07
Key Risks & Mitigants

The following risks have been identified as material to the model outcomes. Each has been assessed for likelihood and impact, with corresponding mitigants noted.

HIGH
Sales Execution Risk

New logo growth is the primary model driver. Underperformance in sales hiring or productivity would materially impact ARR trajectory and may require a bridge raise in the bear case.

HIGH
Competitive Pressure

The SME SaaS market is competitive. Entry of a well-funded competitor could compress pricing and slow customer acquisition, particularly in the mid-market segment.

MED
Churn Deterioration

Current churn of 14% is above industry benchmark. Failure to improve retention through planned CS investment could sustain elevated churn, suppressing net revenue retention below 100%.

MED
Key Person Dependency

Revenue growth is partially dependent on the founding sales team. Loss of key personnel in the sales function prior to process maturity would create execution risk in FY2025.

LOW
Infrastructure Costs

Cloud hosting costs are modelled conservatively. AWS pricing changes or unexpected usage spikes could compress gross margins, though the impact is bounded at the current scale.

LOW
Regulatory / Compliance

No material regulatory changes are anticipated in the current operating environment. Data privacy compliance costs are included in the G&A assumptions.

Section 08
Conclusion & Recommendations

Arkfield Analytics — Summary Assessment

The financial model supports the company's Series A raise of $4.5M. Under base case assumptions, the raise provides sufficient runway to reach cash flow breakeven without requiring additional capital. The model is well-structured, assumptions are grounded in current trading data, and the ARR growth trajectory is achievable given comparable SaaS companies at this stage.

The primary recommendation is to front-load sales headcount investment in the first two quarters post-raise to maximise the compounding benefit of new ARR cohorts. Delaying sales hiring by two quarters reduces FY2026 ARR by approximately $1.1M under the base case.

A secondary recommendation is to implement a structured customer success programme within 90 days of close to begin reducing gross churn from 14% toward the 9% target embedded in the model. This single lever has the highest risk-adjusted return of any operational initiative in the projection period.