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