Business scenario analysis

Best, base and worst case P&L and cash

Prompt

Build a 2027 scenario analysis for a regional coffee chain with about $8M in revenue, modeling monthly revenue, costs, profit and cash balance under best, base and worst case assumptions, with a side-by-side comparison.

Make one like this
Source
Ofox

How to use

  1. 1

    Tap “Make one like this”

    Ofox Chat opens with this spreadsheet’s structure ready to go. Sign in first if you haven’t.

  2. 2

    Make it yours

    Edit the highlighted parts of the prompt to swap in your own details.

  3. 3

    Send and create

    Send it and Ofox Chat builds the spreadsheet for you to download. Keep chatting to adjust it.

FAQ

What kind of file do I get?

A downloadable Excel (.xlsx) or CSV file, with charts where they help.

Do I need to provide data?

If you have data, upload it (Excel, CSV or PDF) and Ofox Chat organizes it with this template. If not, send it anyway to set up the structure first.

Can I edit the prompt?

Yes. The prompt goes into the Ofox Chat input box — swap in your own topic, add requirements or drop what you don’t need before sending.

Can I copy and use the prompt directly?

Yes. Tap “Copy” on the prompt card to get the plain text — it works in other AI tools too.

More like this

More Management prompts

Have an idea of your own? Start creating

Describe the image you want in one sentence, and Ofox Chat creates it from scratch.

Start creating