Financial AnalystReporting and PresentationBeginnerSingle prompt

CFO Dashboard Design AI Prompt

Design a CFO-level financial dashboard for {{company}}. Business model: {{business_model}} Data sources: {{data_sources}} Review cadence: {{cadence}} (weekly / monthly) 1. Dashb... Copy this prompt template, run it in your AI tool, and use related prompts to continue the workflow.

Prompt text
Design a CFO-level financial dashboard for {{company}}.

Business model: {{business_model}}
Data sources: {{data_sources}}
Review cadence: {{cadence}} (weekly / monthly)

1. Dashboard structure (top to bottom):

   Row 1 - P&L Headlines:
   - Revenue: actual vs budget vs prior period (with % variance)
   - Gross Margin %: actual vs budget vs prior period
   - EBITDA: actual vs budget vs prior period
   - Net Income: actual vs budget vs prior period

   Row 2 - Cash and Liquidity:
   - Cash balance: current vs prior month vs minimum covenant
   - Operating cash flow: LTM actual vs budget
   - Free cash flow: LTM
   - Net debt / EBITDA: current vs covenant threshold

   Row 3 - Revenue Quality:
   - ARR / MRR trend (for recurring revenue businesses)
   - New vs expansion vs churn waterfall (if SaaS)
   - Customer count and net adds
   - Revenue concentration: top 10 customer % of total

   Row 4 - Expense and Margin:
   - Opex by category as % of revenue: actual vs budget
   - Headcount: actual vs budget
   - Revenue per employee: trend

2. Alert conditions:
   - Revenue > 10% below budget: red flag
   - Gross margin < {{threshold}}%: red flag
   - Cash runway < 12 months: critical alert
   - Net debt / EBITDA > covenant level: critical alert

3. Drill-down links:
   - Each headline metric links to a detailed supporting schedule
   - Revenue headline: links to revenue by segment and geography
   - Headcount: links to department-level headcount report

Return: dashboard layout specification, metric definitions, alert thresholds, and drill-down structure.

When to use this prompt

Use case 01

Use it when you want to begin reporting and presentation work without writing the first draft from scratch.

Use case 02

Use it when you want a more consistent structure for AI output across projects or datasets.

Use case 03

Use it when you want prompt-driven work to turn into a reusable notebook or repeatable workflow later.

Use case 04

Use it when you want a clear next step into adjacent prompts in Reporting and Presentation or the wider Financial Analyst library.

What the AI should return

The AI should return a structured result that covers the main requested outputs, such as Dashboard structure (top to bottom):, Revenue: actual vs budget vs prior period (with % variance), Gross Margin %: actual vs budget vs prior period. The final answer should stay clear, actionable, and easy to review inside a reporting and presentation workflow for financial analyst work.

How to use this prompt

1

Open your data context

Load your dataset, notebook, or working environment so the AI can operate on the actual project context.

2

Copy the prompt text

Use the copy button above and paste the prompt into the AI assistant or prompt input area.

3

Review the output critically

Check whether the result matches your data, assumptions, and desired format before moving on.

4

Chain into the next prompt

Once you have the first result, continue deeper with related prompts in Reporting and Presentation.

Frequently asked questions

What does the CFO Dashboard Design prompt do?+

It gives you a structured reporting and presentation starting point for financial analyst work and helps you move faster without starting from a blank page.

Who is this prompt for?+

It is designed for financial analyst workflows and marked as beginner, so it works well as a guided starting point for that level of experience.

What type of prompt is this?+

CFO Dashboard Design is a single prompt. You can copy it as-is, adapt it, or use it as one step inside a larger workflow.

Can I use this outside MLJAR Studio?+

Yes. The prompt text works in other AI tools too, but MLJAR Studio is the best fit when you want local execution, visible Python code, and reusable notebooks.

What should I open next?+

Natural next steps from here are Board Financial Package, Investor Presentation Financial Section.