13-Week Cash Flow Skill

Builds a 13-week rolling cash flow forecast and runway analysis.

Finance / Treasuryfinancetreasury
by AgentVoltv1.0.0Published 1y ago1 install
Free to sign up · every skill included with AgentVolt Pro

Before & after

Same prompt, same agent — the only difference is the skill.

PromptBuild a 13-week cash forecast so I can stop worrying about runway
Beforegeneric AI agent
A cash flow forecast is a useful tool for understanding your financial runway. You should start by listing all your expected revenue and expenses for the next 13 weeks. Make sure to account for the timing of when revenue actually comes in and when expenses need to be paid. You should include things like payroll, rent, and other operating expenses. It's good to have a conservative estimate and a more optimistic estimate so you can plan for different scenarios. You might want to include a runway calculation showing how many weeks your cash will last. It's helpful to update this regularly as actual results come in. You could create a spreadsheet or use a financial tool to track this. Would you like help setting up the formulas or categories?
Afterwith 13-Week Cash Flow Skill
13-WEEK CASH FLOW MODEL

ASSUMPTIONS
  Current cash: 180,000
  Monthly payroll: 45,000 (6 employees at 7,500 bi-weekly)
  Burn rate: 52,000/month (payroll 45k + ops 7k)
  Revenue timing: 50% week-of-invoice, 50% at 30 days
  Conservative case: Revenue -15%, expenses +10%

WEEK-BY-WEEK BRIDGE (Optimistic)
  Week 1: 180,000 + 18,000 collections - 7,500 payroll - 1,800 ops = 188,700
  Week 2: 188,700 + 22,000 - 7,500 - 1,800 = 201,400
  Week 3: 201,400 + 12,000 - 7,500 - 1,800 = 204,100
  Week 4: 204,100 + 25,000 - 7,500 - 1,800 - 8,000 tax = 212,100
  Continues through week 13...

RUNWAY ANALYSIS
  Optimistic: Cash never below 100,000. Runway if revenue stops: 22+ weeks.
  Conservative: Week 8 dips to 68,000 (below threshold). Runway: 16 weeks if revenue stops.
  Worst case: Payroll delay or 30% revenue miss triggers 12-week alert.

ALERT TRIGGERS
  Cash below 100,000: Reduce OpEx 20% OR accelerate collections
  Cash below 60,000: Cut discretionary spending, extend vendor terms
  Cash below 30,000: Prepare emergency fundraise or credit line

SCENARIOS BUILT
  Base case: Current trends continue
  Upsell case: 3 contracts week 6 (adds 30k/month)
  Recession: 2 customers churn, revenue -35%

NEXT STEPS
  Week 1: Lock Q4 contract with biggest customer (removes downside)
  Week 3: Collect outstanding 30-day invoices (2 customers owe 18k)
  Week 6: Assess if new OpEx hire is still needed (note: illustrative)

About this skill


name: cash-flow-forecast-13w description: Use when Builds a 13-week rolling cash flow forecast and runway analysis.

13-Week Cash Flow Skill

Produces a short-term direct cash flow forecast across 13 weeks, tracking receipts and disbursements, ending cash, and runway, with alerts when cash dips below a threshold.

What you get

  • A 13-week cash model and runway readout.

Customize your output

  • Adapt the assumptions, chart of accounts, and formatting to your company
  • combine with other AgentVolt finance skills.

Example output

A weekly cash bridge with a runway-to-zero estimate.

Best for

Founders, controllers, and CFOs.

SKILL.md preview

SKILL.md
---
name: cash-flow-forecast-13w
description: Use this skill when building a 13-week rolling cash flow forecast and runway analysis.
version: 1.0.0
category: Finance / Treasury
author: AgentVolt
license: proprietary
tags:
  - finance
  - treasury
  - flagship
---

# 13-Week Cash Flow Skill

Builds a direct-method 13-week rolling cash flow forecast, projecting receipts and disbursements week by week to surface runway risk early.

## When to use

… (sign up to view the full skill)
Sign up to view, copy, and install the full skill

Featured in

More finance skills

View all Finance skills →