ChatGPT Prompts for Financial Modeling: 12 Model Prompts

ChatGPT prompts for financial modeling help you turn your own assumptions into a forecast you can check line by line. The 12 prompts below cover drivers, the monthly model, formulas, break-even, scenarios and sanity checks. Fill in each [variable] with real numbers from your business.

Use only your own figures, check the math for at least one month, and treat the output as a planning model, not financial advice.

Set the drivers

1. Assumptions table

Turn these numbers [paste] into an assumptions table with driver, value and source. Mark anything missing as MISSING.

2. Find the drivers

For a [business model], list the drivers a simple 12-month model needs, and which of them I already gave you in [notes].

Build the forecast

3. Monthly forecast

Build a 12-month table with customers, revenue, variable costs, gross profit, fixed costs, net cash flow and ending cash from [assumptions].

4. Show the math

Show the full calculation for month [number] of this forecast [paste] so I can check it by hand.

5. Cost breakdown

Split my costs [list] into fixed and variable and explain how each one moves when customers grow.

Put it in a spreadsheet

6. Tab layout

Design a two tab spreadsheet, assumptions and forecast, for this model [paste], with cell references for every driver.

7. Formulas to drag

Write the exact formulas for the first two months of this forecast in [Excel or Google Sheets] so I can drag them across 12 columns.

Test the model

8. Break-even

From [price], [variable cost rate] and [fixed costs], work out the break-even customer count and the first month I reach it.

9. Scenario table

Compare 12-month net cash and ending cash for these cases [list], changing only [driver].

10. Cash runway

If growth stops at month [number], how many months does my cash [amount] last at the current burn?

Check before you decide

11. Sanity checks

List three assumptions in this model [paste] that I should test against my real data before making a decision.

12. One page summary

Summarize this model [paste] in one page for [partner or lender]: assumptions, results, risks and what is not included.

Use the full financial model prompt

The flagship Financial Model Prompt: 12-Month Forecast From Your Numbers runs every step from one brief: assumptions, a 12-month table, spreadsheet formulas, break-even, scenarios and sanity checks. Its example is a meal prep subscription in Denver that breaks even at 139 subscribers.

Related prompts

To read past results instead of forecasting, use the financial statement ratio pack prompt or the ChatGPT prompt for financial statement analysis. To build the model faster in a spreadsheet, see the Copilot prompts for Excel and the ChatGPT prompts for Excel data analysis.

Find more in the Finance category, look through Browse, or post your own on Share.