Station 03 — Finance & Budgeting

Budget Scenario Analysis

Using Copilot to translate spreadsheet data into narrative clarity for leadership conversations

The Scenario

You work with budgets or need to communicate financial information to leadership or governance bodies. The scenario mirrors a common real-world challenge: you have two versions of a budget and you need to explain the trade-offs clearly without getting lost in the numbers.

The learning goal is to show how Copilot can help translate spreadsheet data into narrative clarity — and how good prompting can shape the tone and format of that output. The emphasis is on helping you understand that the output should feel like preparation for a conversation, not a finished presentation.

Your Starting Prompt

"I have two budget scenarios I need to present to our finance committee. The first is a conservative budget that covers essential operations only. The second includes several strategic investments that aren't required but would positively impact our work. I'm going to share the key line items from both. Please help me identify the key differences, explain where the net gains are in the enhanced scenario, and give me a set of talking points I can use to guide the committee conversation. I don't want a script — just clear, conversational points that help me tell the story of why the investments in version two are worth considering."

What's Provided

  • Two simplified fictional budget summaries (not full spreadsheets) with 10–15 line items each
  • Clearly labeled as Version A (conservative) and Version B (enhanced)
  • A brief annotation on each enhanced line item explaining its intended impact

Goal Output

A set of clear, conversational talking points that identify key differences between the two budget versions, explain where the net gains are in the enhanced scenario, and help guide a productive finance committee conversation — not a script, but preparation for a real dialogue.

Tips for This Station