All AI spreadsheets

Cash Runway Model - AI SaaS - PLG

A cash runway model for communicating funding requirements to investors during an early-stage financing round. Revenue modeling assumes product-lead-growth and SaaS business model. Can be adapted as needed.

By Atomiq

About

Build a 24-month operating and cash forecast for an AI SaaS startup with product-led growth. The model connects Free, Pro, and Max users to subscription revenue, AI inference costs, marketing spend, hiring, and other operating expenses. Set your opening cash and financing assumptions to review cash burn, ending cash, and funding needs. Compare Base, Upside, and Downside cases as you plan growth and fundraising.

Features

  • A 24-month forecast that links user growth, subscription revenue, expenses, financing, and cash.
  • A Free-to-Pro-to-Max user funnel with acquisition, conversion, upgrade, and churn assumptions.
  • Inputs for plan pricing and AI costs by user tier.
  • An employee-level hiring plan with roles, departments, start dates, salaries, and inclusion flags.
  • Base, Upside, and Downside controls for funding and product-led growth drivers.
  • Outputs for cash-out date, runway, maximum monthly burn, ending cash, MRR, and headcount.
  • Charts for cash on hand, subscription revenue, operating expenses, and paid-user growth.

How to edit in Atomiq

  1. Open your copy

    Open the template in Atomiq or download the Excel workbook.

  2. Set your starting position

    Update the forecast start month, opening cash, and starting user counts on Inputs.

  3. Set pricing and operating costs

    Replace the example pricing, AI costs, and recurring expenses on Inputs with your business assumptions.

  4. Build your hiring plan

    Update employee roles, start dates, salaries, and inclusion flags in the labor plan on Inputs.

  5. Set funding and growth assumptions

    Update the financing amount and growth drivers on Scenarios & Outputs.

  6. Compare the scenarios

    Select Base, Upside, and Downside on Scenarios & Outputs to review each forecast.

  7. Review cash and milestones

    Compare the runway outputs and Charts with the timing of your planned hires, growth targets, and next funding round.

FAQ

Which business model does this template use?

It starts with an AI SaaS business that acquires free users and converts them to Pro and Max subscriptions. Adjust the structure if your tiers or revenue model differ.

How long is the forecast?

The Operating Model contains a 24-month forecast. The forecast start month is an input.

Does the model include AI costs and hiring?

Yes. Inputs includes AI costs for Free, Pro, and Max users, plus an employee-level hiring plan and recurring operating expenses.

Can I compare funding amounts?

Yes. Scenarios & Outputs includes a funding amount for each case. The financing close date is set on Inputs, and the cash forecast reflects the funding assumptions.

Are the example figures ready to use for my company?

The figures are illustrative. Replace them with your opening cash, user counts, pricing, costs, hiring plan, and financing assumptions before using the forecast.