Think Like a CFO: Five Questions That Can Help You Turn Your FP&A Analysis Into Action

There is a difference between answering a question and solving a problem. In FP&A, it is easy to spend years improving Excel skills, building better dashboards, and refining financial models without learning how to help a business make a decision.

Consider a revenue report showing an 8% decline. The analysis may be accurate, beautifully presented, and still leave the most important question unanswered: Should the business do something differently? That is the shift from reporting numbers to thinking like a CFO.

Subscribe to our YouTube Channel for Free Videos on FP&A.

The mindset shift: accuracy is the starting point

An analyst is expected to get the numbers right. Actuals must tie out, variances need explanations, and forecasts should be carefully built. None of that stops mattering as an FP&A professional grows. But a CFO must go further, making a call with imperfect information, limited time, and real consequences.

I think about the distinction this way: reporting explains what happened; business partnership helps determine what should happen next.

Suppose marketing spend rises 18% while revenue grows only 5%. Reporting highlights the gap. Decision-focused FP&A asks what happened to customer acquisition cost, which channels are producing valuable customers, and whether budget should move from weaker channels to those generating greater lifetime value. The same numbers can support a much more useful conversation.

To make that shift consistently, I use five questions.

1. What decision are we actually trying to make?

Start with the decision, not the variance table. Revenue against budget is evidence, but it does not tell a leadership team whether to invest in a product, enter a market, reduce costs, or change its plans.

Imagine a sales director requesting 20 additional salespeople because growth is below target. An FP&A model estimates that the hires could add $5 million in revenue over the next year. That may sound like a strong case until someone asks: Is this a revenue problem or a sales capacity problem?

Those are not necessarily the same thing. Before approving headcount, I would want to know what is preventing the existing team from producing more revenue. A model of what could happen if 20 people are hired is not yet an answer to whether hiring them is the right decision.

2. What will create the most value for the business?

Revenue growth matters, but it is not the only measure of a good decision. I would assess an investment against profitability, cash generation, customer value, strategic positioning, and shareholder returns. Spending more today can create value tomorrow. A cost cut can destroy value if it damages the business.

Return to the hiring request. What would the same investment achieve elsewhere? In this example, marketing identifies a backlog of qualified leads that are not converting. Lead generation is not the immediate issue. The sales process is failing to close opportunities already in the pipeline.

The question changes from “How many people should I hire?” to “What is the best use of this capital to grow revenue?” That is a more valuable FP&A question because it allows the team to compare hiring with improving conversion.

Learn more about CGFPA®

3. What are the biggest risks and assumptions?

A forecast can look convincing because its assumptions are optimistic. I want to know what must be true for a plan to work, what could go wrong, which inputs the result is most sensitive to, and what the downside looks like if the plan misses.

The proposed hiring model assumes new salespeople become fully productive in three months, attrition stays low, and demand remains strong. But the team’s history tells a different story: onboarding has taken six months, and nearly 30% of new hires have left within a year. Those facts do not automatically rule out hiring. They do make the original forecast too optimistic to accept without further testing.

This is why scenario planning is so important in FP&A. It is not an exercise in pessimism. It is a way to show what happens when a critical assumption does not hold, before the business commits to a decision it cannot easily reverse.

4. What is the cash impact?

Profit does not pay salaries. Cash does. A project can look profitable on the income statement and still put the business under pressure if it requires substantial upfront spending, ties up working capital, or delays collections.

Hiring 20 salespeople would bring recruitment costs, salaries, commissions, training, and equipment. In the example, nearly $2 million in cash would go out before any additional revenue came in. Cash flow, rather than the projected revenue opportunity, becomes the immediate constraint.

For every significant proposal, I would ask two simple questions: When does the money leave, and when does it come back? FP&A analysis that considers only the P&L misses a crucial part of the decision.

5. So what should I recommend?

Once the decision, value, risks, and cash impact are clear, I need to make a recommendation. “Revenue declined 8%” is a finding. If the decline is primarily driven by customer churn, recommending a pause in expansion, greater investment in retention, and a 5% downward forecast revision gives leadership something to evaluate and act on.

In the sales example, the stronger recommendation is not to approve all 20 hires immediately. It is to hire eight experienced salespeople, invest in sales enablement and CRM improvements, work on lead conversion first, and review the results after one quarter before expanding further.

In this example, revenue improves over the following six months without the original hiring plan. The business achieves nearly the same growth while spending less cash and taking on less execution risk. The critical distinction is between asking what happens if the company hires 20 people and asking whether that is the best choice.

Three mistakes that weaken an FP&A recommendation

1. Recommending too early

One weak month is not enough reason to freeze hiring or cut marketing. If revenue dips 3% in January, I first need to determine whether the result reflects a trend, a one-off event, seasonality, or simply timing. A confident recommendation based on one unexplained data point can quickly undermine trust.

2. Ignoring trade-offs

Travel is over budget, so cutting travel sounds sensible. But what happens to sales activity, client relationships, or employees who need to visit customers? Every recommendation has a cost, even when its purpose is to save money.

A stronger FP&A recommendation identifies that cost upfront: reduce travel spending by 20%, while protecting visits to the top three client relationships and explaining how other risks will be mitigated. Naming the trade-off demonstrates that I have thought beyond the budget line.

3. Presenting only one option

Executives need confidence that alternatives were considered, not just a single proposal presented as inevitable. I would show the financial impact, assumptions, and risks of each viable option, then explain why my preferred choice offers the best balance of return and risk.

To check whether an FP&A recommendation is ready, I use this five-part structure:

What happened?
Why did it happen?
What options are available?
Which option do I recommend, and why?
What are the risks if I am wrong?

If I cannot answer those questions, I may have completed the reporting, but I have not finished the advice.

Apply the 60-second CFO test to your next report

Before sending an FP&A report, I ask: If the CFO asked what to do, could I answer in one sentence? If the answer is no, I go back and add the recommendation.

For example, “Revenue is down 6% against budget because of lower sales volume” explains the result but stops short of action. A more useful conclusion identifies lower sales volume in the north region, recommends additional promotional spending in the highest-converting channels, and proposes a 3% quarterly forecast revision if the trend continues. The action is specific, and the forecast change is conditional rather than a reaction to one result.

The habit is straightforward. At the bottom of every report I send this month, I would add a Recommendation heading with two or three bullets covering:

What happened.
Why it matters.
What to do next.

Do that consistently for 30 days. The aim is not simply to have an opinion. It is to make a recommendation that can withstand the first follow-up question: “Why?” Evidence, alternatives, and trade-offs are what turn an FP&A report into support for a better decision.

Another chart or a more polished dashboard may improve a report. The greater career shift comes when that report helps someone decide what to do. Start with the next one.

Check out my latest book: The Precision Trap – Stop Chasing Accuracy Start Driving Decisions.

Join the FP&A Community and Keep Learning

If you are serious about FP&A then checkout CGFPA® Certified Global FP&A Professional Program. A six-month in-depth CPD accredited FP&A Certification Download the CGFPA® Brochure. or Become an FPI Member here

You can find more information and bunch of free FP&A resources, including books, courses, and free templates, on the FP&A Professionals Institute website www.fpnaprofessionals.com

Subscribe to Weekly FP&A Jobs Newsletter (every Wednesday)

Subscribe to our YouTube Channel for Free Videos on FP&A. Click here to Subscribe.

Find out about our Weekly Live Webinars: https://fpnaprofessionals.com/