Modern Finance Playbook: 240 month-end meetings taught me this about variances



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 optional; it's necessary to work and thrive in Finance and FP&A. Adoption is accelerating quickly, and below are two training options for you. If you prefer a cohort program from a top university, option 1 is for you. If you prefer self-paced learning from an online training program option 2 is for you. .

Option1: Build practical AI skills for finance

Want to put AI to work beyond prompting? The AI for Business & Finance Certificate from Columbia Business School Executive Education and Wall Street Prep focuses on work finance teams actually do: building predictive models with historical data, running simulations to quantify uncertainty in financial decisions, and automating data extraction from financial documents.

No coding background needed. The program runs online for eight weeks, with about 10 hours of work per week, and offers 65 CPE credits. The next cohort starts November 9.

Save $300 with code THEFPAGUY300.

New AI Finance Professional Certificate from Corporate Finance Institute

AI in finance is about more than writing good prompts. Corporate Finance Institute’s new AI Finance Professional (AIFP™) certification covers cleaning data, analyzing drivers, building forecasts, checking models, and executive reporting, with responsible AI use and sensitive data protection built in.

You can get started now with two online, self-paced courses: AI for Finance Workflows & Governance (2 hours) and Responsible AI Use and Data Handling (4 hours, 30 minutes). CFI plans to make the full certification available for completion on November 9.

Save through November 9: Get 40% off Self Study with code AICERTFPAGUY40, or 50% off Full Immersion with code AICERTFPAGUY50.

​Explore the AI Finance Professional certification or choose a CFI plan and apply the corresponding code at checkout.

Affiliate disclosure: I earn a commission if you purchase using my codes.


The FP&A Guy's Tip

How Finance Leaders Can Build The Skills Their Teams Need For AI

Read my first-ever Forbes article, published this morning. Some of you may already know that Forbes approached me last month to write for the CFO Network. This week, I published my first article on how AI is changing the top technical skills FP&A and finance teams need in the AI era.

The article explains that people no longer believe Excel is the top technical skill. On my podcast last year, 20% said it was Excel, and this year so far, 3% said Excel. In the article, I break down the two skills you should focus on and what leadership should do to develop these skills on their finance teams.


Business Partner's Corner

From Variances to Value: The Art of Excellent Variance Commentary

Business Partnership

I spent 20 years working in Finance. That’s 240 month-end meetings. And I can tell you that far too many of them felt like an endless diatribe of variances.

Revenue was up 3%. Labor costs were over budget by $150K. Travel expenses were down $20K. And on and on we went.

The problem? Many of these variances were immaterial. Others had little connection to what was actually happening in the business. And often, we weren't clear whether a variance was a genuine issue requiring action, a timing difference that would reverse next month, or simply P&L geography.

The result? Lots of numbers, lots of talking, and not a lot of engagement.

Sound familiar?

Today, I have the pleasure of teaching Finance professionals alongside my good friend and FP&A expert, Paul Barnhurst. One of the things we emphasize in our programs is that great variance commentary isn't about explaining every number. It's about helping the business make better decisions.

We use a simple five-step framework to bring this to life.

1. Know Your Audience

Before preparing your commentary, ask yourself one simple question: Who am I speaking to, and what do they care about?

,Your CFO may want to understand the impact on profitability, cash flow and the full-year outlook. Your Sales leader may care about volume, pricing and customer profitability. Your Operations leader may be focused on productivity, waste and labor efficiency.

The numbers might be the same, but the conversation should be different.

Great Finance business partners don't just report numbers. They connect those numbers to what matters most to their stakeholders.

2. Establish Thresholds

Not every variance deserves a conversation.

I remember sitting through meetings where we would spend five minutes discussing a $10K variance and barely touch on a $500K opportunity.

Establish clear materiality thresholds to help your team focus on what matters. These could be based on absolute dollars, percentages or the potential impact on the business.

For example, you might agree to investigate variances greater than $100K or 5% of budget.

But remember, materiality isn't just about size. A relatively small variance could signal a significant emerging trend or business risk.

The goal is to spend less time explaining noise and more time discussing what really moves the needle.

3. Focus on Controllable Expenses

One of the most important questions in variance analysis is: Can we actually do something about this?

If freight costs are rising because of inefficient shipment planning, that's an opportunity for Finance to partner with Operations and find a solution.

If costs are higher because of an unavoidable external event, the conversation might focus on mitigation rather than assigning blame.

We also need to distinguish between structural issues and timing differences. Is the variance going to stick? Will it reverse next month? Is it simply a reclassification between P&L accounts?

These distinctions are critical because they determine whether action is required.

Excellent variance commentary directs attention toward what the business can influence, rather than simply explaining what happened.

4. Use What, So What, Now What

This is my favorite part of the framework and one of the most powerful tools we teach in our Finance workshops.

Too often, Finance teams stop at the What. They explain the variance, perhaps even identify the root cause, and then move on.

But that's only part of our job.

Here's a simple example:

  • WHAT: Overtime costs were $200K above budget, driven by additional weekend shifts at our largest manufacturing facility.
  • SO WHAT: The additional shifts were required to address production inefficiencies. If this continues, we expect a $600K unfavorable impact on our full-year forecast.
  • NOW WHAT: Finance and Operations will review the three largest drivers of overtime, identify opportunities to improve scheduling and productivity, and agree on a recovery plan within two weeks. We'll track overtime hours and costs weekly.

Notice the difference?

We've moved from reporting a problem to understanding its business impact and recommending a course of action.

The What informs. The So What creates understanding. The Now What drives action.

That's where Finance earns its seat at the table.

5. Track Progress

Here's something I've seen far too often: We identify an issue, have a great discussion, agree on some actions ... and then revisit the exact same problem the following month.

Sound familiar?

Great business partners close the loop.

Every significant action should have a clear owner, a deadline and a measurable outcome.

If we agreed to reduce overtime, did it actually happen? If we implemented a pricing initiative, did margins improve? If we expected a timing variance to reverse, did it?

And importantly, what have we learned?

Variance analysis shouldn't be a monthly exercise in explaining the past. It should be an ongoing process of improving the future.

The Bottom Line: Less Reporting, More Business Partnership

When I think back to those 240 month-end meetings, I realize how much opportunity we had to create more meaningful conversations.

Imagine replacing 60 minutes of variance explanations with 15 minutes focused on the three biggest business issues, their implications and the actions required.

Imagine business leaders looking forward to their monthly Finance discussions because they know they'll walk away with valuable insights and practical recommendations.

That's the Finance function we should all be striving to build.

And it's why Paul and I are so passionate about helping Finance professionals move beyond the numbers.

The next time you're preparing your month-end commentary, ask yourself three questions:

  1. Am I focusing on what really matters to my audience?
  2. Have I clearly explained the business implications?
  3. Have I recommended a specific action that will improve performance?

If you can answer yes to all three, you're well on your way to becoming a world-class Finance business partner.

Remember: Our job isn't just to explain the numbers. It's to help change them.


Stay Out of Excel Hell

Building a sensitivity table for Price elasticity of Demand.

Build a Dynamic Price Elasticity Model in Excel

"What happens to revenue if we raise prices 5%?" The answer depends on how customers react, and that is what Price Elasticity of demand tells you.

​Download the Template and follow along as we build it together​

Today I want to walk you through how to build a dynamic price elasticity Sensitivity model in Excel. I like building dynamic models because dynamic formulas update answers instantly, resize scenarios automatically, and reduce copying errors.

Step 1: Set up the assumptions block

The model starts by setting up our assumptions, just like any good financial model. The assumption block for this model consists of five inputs (shaded) and two calculated cells (white):

,The table below explains what each assumption is in our model. We will build the actual dropdown lists for the assumption block in step 2, so at the moment values will be blank, but the above shows you what they will look like when we are done.

The two calculated cells are as follows: Rows is =C8*2+1 and Base Revenue is =C4*C5.

Step 2: Build dropdown lists with SEQUENCE

The lists used to adjust each assumption in the model are dynamic. Each list is built using the SEQUENCE function. The SEQUENCE function consists of four arguments: number of rows, number of columns, starting value, and step.

Let's go through the first one, Base Price. The formula reads:

=SEQUENCE(C4,C7,C5,C6):

1st Argument (Rows): C4 – this is the number 25 and is the number of rows we want

2nd Argument (Columns): C7 – this is the # of Columns we want, which is the number 1

3rd Argument (Start): C5 – this is the starting value, which is the starting price of $10.00

4th Argument (Step): C6 – this is how much we want to increase the price by each time we go down a row, which is 10 cents.

We will build similar SEQUENCE functions for each of the 5 categories in the image, and it will follow the same logic as Base Price; it will just use a different column. For example, the Base Volume would be D4, D7, D5, D6 inside the Sequence Function. Once you have built the Sequence functions, you build the Data Validation list for each of the 5 elements in the assumption block.

Choose Data > Data Validation > List and reference the dynamic dropdown lists you just built. For example ='Price Elasticity List'!$C$9#.

When you reference the source, add the # sign at the end, as the formula box will not add it when you copy the range; you will have to add it manually. Once you have done this for all assumptions, you will have completed the data input range.

Step 3: Generate the price changes with one formula

The next part is the key to the whole model. You need to create the range of potential price changes that you want to use for your price elasticity of demand. This is the only formula that uses a SEQUENCE in the model, and everything else is built off of it.

=SEQUENCE(C9, 1, -$C$8*$C$7, $C$7)

The SEQUENCE formula will live in cell B14 and the arguments re as follows

1st Argument (Rows): ,C9 – This will equal the prices for each side; in this example, it equals 21. The reason it is 21 because you want 10 price changes below 0 and 10 above, and 0. So if we change the price by 0.5% each time, we would have a range from -5% in price up to 5% which is 21 rows.

2nd Argument (Columns): 1 – This will be the number one as you want it to spill down one column

3rd Argument (Start Value): -C8*C7– This argument takes the steps each side, which is 10, puts a negative in front, and then multiplies it by .5. This is so we start with -5% in the Price change list

4th Argument (Steps): C7 – This is .5% and is the amount the starting value will be incremented for each row, so -5.0%,-4.5% and so on.

Step 4: Build the rest of the formulas with Spill references

Each of the remaining columns (i.e., Scenario Price, Volume Change,…) will be built with spill references. Spill references use the # symbol and make the formula spill down the entire reference. Notice that for Price Change we reference B14#, which refers to the entire spilled range starting at B14 and going down 21 rows.

Every remaining column in the model will have a # spill operator so that when any input changes in the model every single column in the model will dynamically adjust across every row.

In the actual model build, we use conditional formatting to highlight the base case row in blue (0% price change) and shade revenue gains green and losses red.

Reading the table above, we see that a 10% price increase with an elasticity of −0.20 means demand is inelastic. That means a 10% price increase only costs 2% of volume, so revenue rises 7.8%, from $2,020,000 to $2,177,560.

Step 5: Chart the indexes

The model has three indexes: price index, volume index, and revenue index. The Indexes put price, volume, and revenue on one scale (base = 100). Chart the three index columns as lines, using price change for the x-axis. Plot the three indexes on a chart to see how price, volume, and revenue change at different price points.

Step 6: Adjust the Inputs and see how the model adapts.

Test more price-sensitive demand: select −1.50 in the elasticity dropdown. The same formulas produce a different story:

A 10% price increase now lowers revenue 6.5%; a 10% cut raises it 3.5%. Revenue peaks around a 15% cut, so deeper discounts are not always better.

The useful question becomes: "Which elasticity do we believe, and what evidence supports it?" Test the assumption before recommending a price change.

Warning: Remember that in the real world, price elasticity will only hold for a certain range of volume, and then it may behave differently. At a certain price increase, volume may drop sharply, and at another point, a price drop may not increase volume at all. You need understanding and judgment to determine the range over which price elasticity holds.

Try it yourself

Download the model here and try building it yourself


Joke of the Day

"A woman was told she only had 6 months to live.

'Oh My!' she said.

'What shall I do?'

'Marry an accountant,' suggested the doctor.

'Why?' asked the woman. 'Will that make me live longer?'

'No,' replied the doctor. 'But it will SEEM longer.'


Brain Teaser Answer

Answer:

C) Revenue decreases by 4%

Let's assume the company originally sold 100 units at $10 each.

  • Original revenue: 100 × $10 = $1,000
  • New price: $12 (20% increase)
  • New volume: 80 units (20% decrease)
  • New revenue: 80 × $12 = $960

Revenue actually falls by 4%!

The Finance lesson: A 20% price increase and a 20% volume decline don't cancel each other out. Understanding the interaction between price and volume is critical to making better business decisions.

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

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...

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...