Modern Finance Playbook: How to improve your AI instructions today



This Week's Sponsor


Inspirational Quote

“Clear is Kind.”

Brene Brown


Brain Teaser of the Week

See the solution at the end of the email

Three people need to cross a river at night. They have one small boat that can carry a maximum of two people at a time.

  • Alex can row across in 1 minute.
  • Blake takes 2 minutes.
  • Charlie takes 5 minutes.

When two people cross together, they travel at the speed of the slower person. The boat cannot cross without someone rowing it back.

What is the minimum time needed for all three people to reach the other side?


Message from Our Sponsor

Is AI giving FP&A time back, or raising the bar?

The more AI your finance team uses, the more time it spends on reporting.

Pigment’s Q3 CFO Index surveyed 2,000 finance leaders. It found 30% of the most AI-mature teams spend over 40 hours a month on executive reporting, versus 17% of early-stage teams.


Opportunities

I have two free live webinars coming up with Ramp and NetSuite, and I'd love for you to join me for either one or both if you can.

Connecting FP&A to Business Strategy

Strategy is one of the most underused skills in FP&A. In fact, one of the first articles I ever wrote, and the one I credit most with starting my journey to becoming The FP&A Guy, was about strategy. Ranga Bodla, GVP of Marketing and Strategic Partnerships at Oracle NetSuite, and I will cover:

  • The 3 phases of strategy: formation, planning, and execution
  • Where FP&A contributes at each stage
  • Practical frameworks for applying strategy to the work you do

📅 Date: Tuesday, November 24

🕐 Time: 12:00 PM Mountain (11:00 AM PT / 2:00 PM ET)


The FP&A Guy's Guide to AI Budgeting

Budgeting AI usage is becoming a major concern for every company, especially after we saw companies like Uber use the full year's budget in 4 months. AI spend moves with usage and model choice, and at many companies, no one owns how AI gets used or what it costs. That gives finance an opening to lead. Ramp's Olivia Garrahan and I will cover:

  • What drives token costs and how you should think about budgeting them
  • Why experimentation belongs in the AI budget as a planned cost of learning
  • How finance can help lead the way when it comes to AI and AI cost management

📅 Date: Tuesday, December 1

🕐 Time: 11 AM Mountain


The FP&A Guy's Tip

This week I want to talk about the role of strategy in FP&A. Nearly ten years ago, I wrote my first article about strategy, where I stated that it is one of the most underused skills in FP&A. In the last ten years, FP&A has come a long way, but I still believe the role of strategy in FP&A is often misunderstood and underutilized. I want to briefly share what strategy is, the 3 roles of strategy, and how FP&A fits into each.

What Strategy Is

As a co-worker of mine put it, Strategy is about knowing what doors to close. As a business, we will always have more opportunities than we have time, and part of strategy is learning what to do with that time. It goes beyond that, as Michael Porter wrote in his famous 1996 Harvard Business Review article “What Is Strategy?”: “Competitive strategy is about being different. It means deliberately choosing a different set of activities to deliver a unique mix of value.”

The bottom line is that strategy is what makes us different and, at the same time, allows us to earn an above-average return for the work we do. Two examples of this include:

  • Ferrari, which deliberately chooses to keep supply below demand to protect exclusivity, has produced margins several times the industry average.
  • For decades, Southwest flew one aircraft type, used point-to-point routes, and skipped assigned seats and meals and earned above-average returns for doing it.

The three phases and FP&A’s role

  • Formation. The CEO and leadership team own this, and FP&A is rarely at the table at a company level. We might be involved at a division level or be needed to tie strategy to a project. FP&A needs to know the frameworks. Porter’s 5 Forces tests an industry's attractiveness and helps validate macro assumptions. SWOT sorts internal strengths and weaknesses against external opportunities and threats, then ranks them by financial impact. VRIO and PESTEL are other options. Formation is not where we spend our time but knowing the frameworks used in this phase is important.
  • Planning. FP&A is most involved here, and it’s also where strategy most often gets lost. During budgeting, ask how each request fits long-term objectives. Otherwise, funding tends to follow political influence. Build models around strategic levers, such as Ferrari’s geographic allocation of cars. Use scenarios to test whether the strategy holds when key assumptions change. The more we tie our planning back to the company strategy, the more valuable we become as FP&A professionals.
  • Execution. We don't execute the strategy, but we help with the reporting that shows whether we're, as a company, executing it successfully. For example, take variance reporting. With variance reporting, one key question is whether the cause is an execution problem that can be fixed without changing the strategy, or a broken assumption that may force leadership to rethink the target or the strategy itself. In addition to variance reporting, several methods are used, such as OKRs, the Balanced Scorecard, and the X-Matrix, to ensure reporting focuses on KPIs tied to the company's strategic objectives.

As FP&A professionals, we may not set the company's strategy, but we can play a key role in the planning and execution phases. If you are not thinking about how strategy will make you a better FP&A professional, get started by reading your company's strategy and asking yourself how you can incorporate the company strategy into the work you do.


Business Partner's Corner

Build Trust, Then Challenge Constructively

Picture this. You're sitting in a boardroom, watching an enthusiastic Marketing team unveil what they believe will be the company's next big growth opportunity. The slides are polished, the market research is compelling, and the sales projections look fantastic. You can almost feel the excitement in the room.

There's just one catch. They want $5 million to build a brand-new production line.

Many years ago, I was the FP&A Director for a large CPG company. We had a brand that dominated its category, and our Marketing team had an ambitious mandate to expand into adjacent categories.

Their big idea? A new product that they believed could take over the large Alfredo sauce market.

The presentations were slick, the business case was convincing, and the enthusiasm was contagious. But something didn't sit right with me.

Thankfully, I had enough experience, along with our Operations team, to ask some tough questions. What if the product didn't take off? Could we test the market before committing the full investment? Was there another way?

After some healthy debate, we landed on a different solution.

Invest $1 million to produce the product on an existing line, prove its success in the market, and then invest in the new line if demand justified it.

It took some negotiation, but eventually everyone got behind the plan. We had reduced our upfront investment by 80% without giving up the growth opportunity.

But here's the important part of the story. The ability to challenge the proposal didn't start in that meeting. It started long before.

We had spent time building trust with our Marketing colleagues.

We listened to their challenges, got to know them as people, and demonstrated that Finance cared just as much about growing the top line as protecting the bottom line. We built authentic relationships and showed that we were partners, not the department of "No."

That trust gave us permission to challenge their thinking without making it personal.

I wish I had learned this lesson earlier in my career. Too often, Finance professionals focus on getting the analysis right and forget that relationships are just as important.

One book I highly recommend is The First 90 Days by Michael Watkins. It provides a great framework for approaching new roles and building relationships early. I've found that investing time upfront to understand stakeholders, their priorities, and their challenges pays enormous dividends later.

My formula for effective Finance Business Partnering is simple: Build trust first. Then challenge constructively.

So, What Happened to the Alfredo Sauce?

You might be wondering how the story ended.

The product actually had a successful first year, supported by a significant marketing investment. Consumers were willing to give it a try, and the initial sales looked promising.

But there was a problem. Consumers tried the product, but they weren't coming back for more.

Without repeat purchases, the business couldn't sustain its early momentum. By year two, the product was discontinued.

Imagine if we had committed the original $5 million!

The lesson for me wasn't that Finance was right and Marketing was wrong. We were all trying to grow the business. The real win was that we challenged each other constructively and found a way to pursue the opportunity while managing the risk.

Great Finance Business Partners don't just challenge the numbers. They build the trust that allows them to challenge the thinking.

And sometimes, the most valuable contribution Finance can make isn't saying "No." It's finding a smarter way to say "Yes."


Stay Out of Excel Hell

Based on the feedback I received, I'll alternate between Excel Hell and AI Tips. This week, I'll share an easy-to-implement AI tip that will improve how you work with AI.

Instructions in AI

One of the simplest ways to improve the quality of the answers you get from AI is to use instructions. Nearly everyone knows AI has a place where you can enter instructions for your overall AI (Claude, ChatGPT, Copilot). Below is a screenshot of what it looks like in Claude.

If you have not done this and want to get started creating your own instructions for your AI as a whole, drop this prompt into the tool you use, answer the questions, and let it help draft your first set of instructions.

Sample Instruction Prompt:

I'm a [job title] at [organization]. Ask me up to five questions, one at a time, about my role, the work I do most often, the systems I use, and how I like answers formatted. Then write custom instructions I can paste into my AI tool, under 1,500 characters.

Once you have done that, you are not done; there are several other areas you can include instructions to improve responses. Nex let us discuss the Microsoft Office Apps you use. I have listed the four most common apps and which AI tools allow custom instructions in which Applications:

  • Microsoft Excel – Claude, ChatGPT, and Copilot all allow personalized instructions
  • Microsoft PowerPoint – Claude and ChatGPT do; Copilot does not allow personalized instructions
  • Microsoft Word – Claude and ChatGPT do; Copilot does not allow personalized instructions
  • Microsoft Outlook – Claude and Copilot do; ChatGPT has a plugin but not an add-in within Outlook. These tools have instructions, and some have additional customizations beyond instructions, such as your writing style and learning to sound like you.

My advice is to make sure these add-ins are available in your Office tools, then add personalized instructions. I would start with Microsoft Excel. Below is a prompt you can use to get you started with Excel, along with my own personalized instructions to give you an idea of what they might look like.

Sample Excel Prompt

I want you to ask me up to five questions about my Excel modeling style to help you better understand how I like to work. Ask them one at a time. After you have run through these questions with me, create a set of instructions I can add to my personal Instructions in Excel under 1,500 characters.

Paul’s Excel Personalization

  • All tables you create should contain a short descriptive name and be prefixed with tbl. For example, tblRevenue or tblExpenses.
  • You should use tables to store raw data when possible.
  • Never merge cells! If you need to center a heading use center across selection instead.
  • Always turn off worksheet gridlines when creating or formatting Excel worksheets.
  • Start new worksheet layouts in B2 by default.
  • When building models, format input cells in blue font, output cells in black font, and linked reference cells in green font.
  • When building models, use Excel formulas and cell references wherever possible. Do not hardcode calculated values. Use hardcoded numbers only for clearly labeled inputs or assumptions; formulas should drive all outputs, schedules, summaries, and checks.
  • When a custom skill gives more specific rules, follow the skill.

In addition to the above, you will want to next make sure any projects, workspaces, and/or agents you have built have the instruction section complete. This gives AI additional context, and getting good results from AI is all about providing it with context so it can better learn how you work.

The next step is to start writing your own instructions as SKILLS for certain tasks you do. We will cover that in the next email.

Feel free to email me and share what you are using as your Excel instructions and how it is working at pbarnhurst@thefpandaguy.com​


Joke of the Day

Exercising can add years to your life. For example, today I ran 2 miles, and now I feel like I’m 84.


Brain Teaser Answer

Answer: 8 minutes

  1. Alex and Blake cross together: 2 minutes
  2. Alex returns with the boat: 1 minute
  3. Alex and Charlie cross together: 5 minutes

Total time: 2 + 1 + 5 = 8 minutes.

All three are now safely across the river!

600 1st Ave, Ste 330 PMB 92768, Seattle, WA 98104-2246
​Unsubscribe · Preferences​

The Modern Finance Playbook

The Modern Finance Playbook is a newsletter for today's finance professionals brought to you by Paul Barnhurst and Ron Monteiro.

Read more from The Modern Finance Playbook

Inspirational Quote “The most important thing in communication is hearing what isn’t said.” - Peter Drucker Brain Teaser of the Week See the solution at the end of the email Three Finance colleagues go out for lunch. The bill comes to $30, so each person contributes $10. The waiter realizes the bill should have been $25 and returns $5. The colleagues each take back $1, and they give the remaining $2 to the waiter as a tip. So each person has now paid $9, for a total of $27. The waiter has the...

Hey Reader, "Your analysis was brilliant, but your presentation lacked." I will never forget my boss's words; they taught me the value of the last mile of analytics. I gave a presentation to my CFO that was a disaster, and it was because I did a poor job of presenting the solid analysis I had done. The last mile of analytics is the key to influencing the business, and a few bad data visualizations can often undo the whole presentation. On Wednesday, November 18, I'm running a free live...

Inspirational Quote “Effective Communication begins and ends with communication.” - Mike Krzyzewski Brain Teaser of the Week See the solution at the end of the email 🧠 A company increases its selling price by 20%, but as a result, sales volume drops by 20%. Assuming all other factors remain unchanged, what happens to total revenue? A) Revenue stays the same B) Revenue increases by 4% C) Revenue decreases by 4% D) Revenue decreases by 20% Upcoming AI Opportunities Learning AI is no longer...