✏️Prompts

Build a cash flow scenario model with formulas you can check Prompt

Prompt

Help me build a 12-month cash flow scenario model in a spreadsheet. Do not calculate the results yourself. Build the structure and formulas so the spreadsheet does the math and I can check every number.

Scenario to model: [DESCRIBE, FOR EXAMPLE: "Our state grant reimbursements arrive 90 days later than usual starting in [MONTH]."]

Please give me:

1. An ASSUMPTIONS table (one input per row, with a label and a cell I can change): starting cash, each revenue source by month, each expense category by month, and the scenario inputs (for example, delay in days or % reduction).
2. A MONTHLY CASH FLOW table for 12 months: beginning cash, inflows by source, outflows by category, net change, ending cash. Every cell after the inputs must be a formula that references the ASSUMPTIONS table. Write formulas in Excel syntax and tell me exactly which cell each table starts in.
3. Two scenario columns or sheets: BASE CASE and SCENARIO, so I can compare them side by side.
4. A small SUMMARY: lowest ending cash month and amount for each case, and how many months of operating expenses that represents. Again, formulas only.
5. A list of every assumption you made about structure, and any information you need from me that I didn't provide.

Use only the figures I provide below. Where a figure is missing, leave the input cell blank and label it [NEEDED].

MY FIGURES:
[PASTE: STARTING CASH, MONTHLY REVENUE BY SOURCE, MONTHLY EXPENSES BY CATEGORY]

Watch out for

Control: Paste the tables into a spreadsheet and let the spreadsheet do the math. Don't rely on numbers AI calculates in the chat.

Used by

Finance TeamsExecutives