Video · 1:18
Cash & Runway Planner walkthrough
Chapters
Transcript
The video has no sound. This is what it shows, in order: each caption, then what is on screen.
- See how many months the cash covers if a client pays late or leaves. On screen: the Dashboard of the worked example, which opens on the Client leaves scenario. Status SAMPLE; plan Oct 2026 to Sep 2027, in USD.
- In this fictional demo, losing one client cuts 9 months covered to 5. Outlined: months covered of 12, base case 9; Client leaves 5, marked Fewer than the base case.
- Yellow cells: you type. Leave every other cell to the workbook. On screen: the color key on Start Here; the yellow swatch reads Yellow: you type here.
- White cells calculate. Grey cells hold lists and reference values. Outlined: White: calculated, don't type here, and Grey: lists and reference values.
- Start Here has nothing to type. Do this next says what to do. On screen: Start Here, row 5. Do this next is outlined. It reads "See the sample plan on the Dashboard, then clear the sample rows (steps below)." Nothing on Start Here is typed.
- Setup: start Oct 2026 with 48,000.00. Keep at least 15,000.00 at month end. On screen: Setup, the settings column, with currency USD and 4,000.00 already set aside for tax. Outlined: the start month and opening cash, then the minimum cash buffer, 15,000.00.
- Setup complete reads Yes, so Do this next moves on. On screen: Setup complete, row 20, reads Yes and is outlined. The note under it says that Start Here's Do this next reads this line.
- On the Dashboard, change Scenario shown from Base case to Client leaves. On screen: the top of the Dashboard. Scenario shown changes from Base case to Client leaves, and the key figures change with it. The note beside it names the plan, Oct 2026 to Sep 2027, and the currency, USD, and says to change them on Setup.
- Months covered drops from 9 to 5, with cash at -31,250.00 by Sep 2027. On the Dashboard: months covered, base case 9, Client leaves 5; lowest month-end cash -31,250.00, in Sep 2027; cash at end of Sep 2027 -31,250.00, Below zero.
- On Money In, add one row per retainer and one per unpaid invoice. On screen: 13 demo rows, IDs EX-IN-01 to EX-IN-13, for eight fictional clients.
- On Money Out, list each committed cost. Payroll: 3 paydays in October, 24,600.00. On screen: 10 demo costs; payroll is 8,200.00 every 2 weeks from 2 Oct 2026. The month columns show 24,600.00 for Oct 2026 and Apr 2027 and 16,400.00 for the months between.
- July ends at 9,505.00, below the buffer, so the base case covers 9 months. On screen: the Cash Plan base case; Jul 2027 reads Below buffer, and the Covered so far column adds up to 9.
- Scenario columns on Reference: Sample Studio leaves from Jan 2027. On screen: the client list with each client's usual days late; Beacon Legal and Elm Street Hospitality also have extra days late for the Late payment scenario, 45 and 30.
- Nine checks. Only Sample data is flagged, so the status reads SAMPLE. On screen: eight checks read OK; check 10, Sample data, counts 23 sample rows and reads SAMPLE.
- Clear the sample data in three steps, and the status reads OK. The steps on Start Here (steps 1 and 2 are on screen; step 3 is cut at the right edge of the frame and is shown by the next shot): click the Name Box; choose MV_Clear_MoneyIn and press Delete, then do the same for MV_Clear_MoneyOut and MV_Clear_Reference; check the Dashboard. After clearing, the Dashboard status reads OK, every check count is 0 and the key figures are blank. Settings are kept.
- Help: the Guide sheet, and email support. We reply within 1 business day. On screen: the Guide's Support row: [email protected]; include the version, your Excel version, the sheet and row, and what you saw; replies Monday to Friday, Australian Eastern time.
- See every sheet and what is tested at metricvalley.com. End card: Cash & Runway Planner, Excel 365, Google Sheets edition when it ships, metricvalley.com, beside the Dashboard's line chart of cash at month end for the base case, Client leaves and the minimum cash buffer.
- Recording note: Scenario shown was set to Base case before the walkthrough, then switched back to Client leaves, the value the file ships with. Nothing else was changed.