MergedAnalytics Tracking Image - NoScript
International Business Growth Radio Network
  • WELCOME
    • EXEC TEAM
    • CONTACT US
    • PRIVACY
  • RADIO
    • ON AIR NOW
    • LISTENER GUIDE
    • SHOWS ON DEMAND >
      • BUSINESS PODCASTING MADE EASY
      • ECONOMIC NEWS >
        • IBGR.News
      • EXIT STRATEGIES >
        • An Epic Business Exit
        • Catalytic Conversation$
        • Exitology
        • The CFO Perspective
        • The Entrepreneur's Edge
        • The Smart & Savvy Business Exit
      • FINANCE >
        • Business Econ for a Post Pandemic World
        • Economics For Owners
        • Employee Capitalism
        • Money Matters
        • Practical Solutions to Difficult Problems
        • TurboCharge Your Business
        • Your Money Machine
      • HR / PEOPLE SKILLS >
        • Business and Beyond
        • Business Processes & People Talk
        • Equipping Others
        • Staff It!
        • Success Can Be Fun - With Focus!
        • The People Side of Business
        • Women of Business Thriving
      • INTERVIEWS >
        • Get You Noticed!
        • The Referral Guy Interviews Your
        • The Magnetic Voice
      • LEADERSHIP >
        • Compassionate Leaders of Influence
        • Destiny Road
        • Engaging Your People For Success
        • Leadershift with Col Ajai Lal
        • Leadership Powered by Common Sense
        • Influencing for Global Impact
        • Talk Leadership with Cedrick on the Radio
        • Your Corporate Confidante
      • MARKETING >
        • Building A Multilevel Marketing Empire
        • Level-Up Your Marketing
        • No Nonsense Market Domination
        • Buying Customers
        • #Seriously Social
        • Results Oriented Marketing
      • MINDSET >
        • Building Success Habits
        • Building You to Build Your Business
        • Entrepreneurial Mindset
        • Peak Impact Mentorship
        • Guidance To Wealth
        • The Hero Within
      • OPERATIONS >
        • Build It!
        • Building In Front of You
        • Building In Front of Your 2
        • Lead Lean
        • Pencils & Pistons
        • Planning Out Loud
        • Processes Under Control
        • The Ralph Peterson Radio Show
      • SALES >
        • Beyond The Method Selling
        • Inside The Customer
        • Sell It!
        • Serving Up Sales
      • STARTUPS >
        • A Business Primer for Startups
        • A New Business Model For Startups
        • Adulting In My Purpose Business Edition
        • Building Startup Operations
        • Creating A Consulting (Improvement) Business
        • How To Start A Consulting Firm
        • Survival Mode
        • The Geriatric Entrepreneur
        • Your Business 2.0
        • Z Gen Entrepreneurship
      • STRATEGY >
        • #OwnrLife
        • Better Your 4 U
        • Build Your Core for Dynamic Partnerships
        • Grow It!
        • How to Avoid Becoming the 80%
        • How To Become the Top 5%
        • How to Move Beyond the 15%
        • Living the Life .. On YOUR Terms
        • Own It!
        • ReImagine Your Business
        • The Business Owner's Bookshelf
        • The Self Managing Organization
        • Tenacious Top of Mind Business Insights
    • MEET THE HOSTS >
      • Ben Gioia ("joya")
      • Bert Robinson
      • Chris Mayfield
      • Crystal Y. Davis
      • Donna Kunde
      • Doug Thorpe
      • Ellen McIlhenny
      • Glenda Thompson
      • Jason "Wally" Waldron
      • Jeremy Gray
      • Jörn "Joe" Menninger
      • Kevin Beers
      • Lisa Askwith
      • Londina Cruz
      • Mike King
      • Monique McDonald
      • Patty Lawrence
      • RJ Lewis
      • Sarita Johan
      • Steve Sweeney
      • William Eastman
    • JOIN THE TEAM >
      • BECOME A HOST
      • BE A SPONSOR
  • CONSULTING
    • HOST PACKAGES
    • ADVERTISING PACKAGES
    • BUSINESS MAKER PACKAGES
    • FRACTIONAL CONSULTANTS
  • NEWS
    • E-NEWSPAPER
    • NEWS BLOG
    • NEWS PODCASTS
  • RESOURCES
    • START HERE
    • SHOW NOTES
    • GROWTH APP
    • FACEBOOK COMMUNITY
    • LINKEDIN COMMUNITY
    • EVENTS
    • IBGR MERCHANDISE
IBGR.NETWORK

Show Notes

DOWNLOAD. LISTEN. ENGAGE.

Improving FP&A Forecast Accuracy - Jeremy Gray

7/3/2021

0 Comments

 
Picture
Jeremy Gray – Show 10 Season 4. Improving FP&A Forecast Accuracy

IBGR.Network - PROFIT Radio. Everything a business owner needs to start, grow or exit a business. GROW WITH US.
 
INTRODUCTION
Last week I introduced you to the concept that FP&A should be a profit generator for your business.

The challenge in many companies is that FP&A delivers little more than a budget that quickly grows stale.  That is unacceptable.

The best-performing organizations use FP&A to drive business outcomes, not just to budget spending or forecast sales and expenses.

They do more than predict desirable results; they develop rigorous, well-conceived plans to deliver those results.

One of the keys to that is linking operational and financial planning. To use a simple example, a best practice FP&A company will recognize the relationship between productivity and cost of goods sold (COGS). If the company establishes a target of increasing earnings by a specific dollar amount, it will assess the required productivity gain necessary to reduce COGS and increase profitability.

​This underscores that financial projections aren’t divorced from operational planning. In fact, it’s just the opposite: Financial projections are seen as worthless without an operational plan to achieve them.

In modern thinking FP&A now sits between the financial leader and the operations leader. The CFO and COO in lager organizations. FP&A should support the entire organization. Helping sales in pricing strategies, R&D in goal setting and the management team in decision making.

To be effective FP&A needs to build models that provide a solid basis for making business decisions. Note that I use the word solid rather than accurate. It is almost impossible to be 100% accurate in a forecast. There are just too many variables and external influences to achieve that level of accuracy. What is required are models that are accurate enough to enable the best business decisions to be made using the facts available and your understanding of the business environment.
 
 
Show Objectives - The Why
As your business grows the more complex it becomes and the investments required to move forward become larger both in $ terms and resources needed. Also decisions acquire more momentum and to make changes when needed become more difficult.

Your FP&A team therefore needs to be able to provide you with the best forecast they can, which includes the resources required and form the ROI on your investment. 

ROI should be the return you require above your hurdle rate – that is what it costs you to borrow money from all sources. Shareholders expected returns, bank interest rates, factoring costs – whatever it is costing you to raise funds.
 
Key Issues - Owner Perspective:
As the owner of the business what level of accuracy is acceptable? You need to avoid the well recognized challenge of paralysis by analysis. Where no decision is made as executives ask for one more what if scenario, the inclusion of one more variable into the model. As Voltaire said best is the enemy of good. You have to achieve the right balance between practicality and optimization. The law of diminishing returns applies to financial modeling too.

Strange as it might sound many executives are afraid to make decisions. Making a decision invites consequences so it is tempting to spend hours analyzing a problem. Asking for more analysis can be seen as taking action when in reality it is inaction, As time passes options become fewer until if you wait long enough there is only one option open to you and the decision is made. Likely this is not the optimal decision.  

So as an owner alarm bells should ring when one of your management teams says I have asked the FP&A team to run one more scenario.
 
What You Need to Know - The What
What level of accuracy is acceptable? It may be surprising but in the field of forecasting there is a model called the naïve forecast. At its simplest the naïve forecast assumes that tomorrow is going to be very much like today. That the status quo will continue and nothing much will change. This might seem simplistic or naïve but over the short term it may be an acceptable forecasting technique. If the industry you operate in is relatively stable and change comes slowly the naïve forecast may be all that is required. It is a case of effort over reward, or cost versus benefit. Will a more detailed model deliver a forecast that enables an much better decision and thus outcome?

The level of accuracy required depends on circumstances. In supermarkets the demand forecast accuracy for short shelf life products needs to be more accurate than demand forecast accuracy for products with a longer shelf life. If a can of baked beans sits on a shelf for a couple of weeks there is little harm done much beyond using a  little bit more working capital than needed. If a head of lettuce sits in the chiller for a couple of days it is either going to have to thrown away or marked down significantly to get it sold.

In this example and many others the balance is between needing accurate forecasts versus adjusting your supply chain to tolerate inaccuracy in forecasts. The ability to respond to variances in forecast accuracy is another factor. If you can quickly respond to an inaccurate forecast at minimal cost the less accurate your forecasting needs to be. Note this does not need to be handled by you if you can pass this challenge on to your supplier.

The challenge to you as the business owner is to strike the right balance between accuracy and resources needed to produce the forecast. 
 
What You Need to Do - The How
 
1. Keep Budgeting and Forecasting Flexible
Rigid forecasts and budgets aren't very useful. Things change as the time progresses, and you need to be able to factor in those changes and how they will affect your business. Continuing to base decisions on the best guesses made months prior can lead to faulty and costly decisions. Keep in mind the inertia basis we have talked about in the past. In addition, holding employees to metrics based on out-of-date information is counterproductive and frustrating. Building flexibility into your budgeting and forecasting will allow for more accuracy and better results in your business. This can be achieved by point 2

2. Implement Rolling Forecasts and Budgets

You can update rolling forecasts and budgets based on present results, not on what a manager thought may happen several months ago. You can use this process to shorten the projection period for example only predict one or two quarters ahead or as I prefer use the latest information to update the predictions for the entire project.

3. Budget to Your Plan

Spending should reflect actual results not planned results. If you do not do this it is easy for spending to get ahead of earnings with disastrous results to you cash flow and eventually your profitability.

4. Communicate Early and Often

As the forecasting and budgeting affects all aspects of the business, you want to keep an open line of communication with all departments throughout the entire process to help minimize issues and to ensure alignment between your company's operational and organizational strategies.

5. Involve Your Entire Team

Budgeting and forecasting should be a team effort so that departments and units have a clearer understanding of their needs. As well as the people in your finance department, having people with their pulse on the various departments can give you the data you need to make accurate predictions and set realistic budgets. Moreover, using your entire team allows you to have multiple perspectives on where your business is now and where it could be in the future.

6. Be Clear About Your Goals

The purpose of forecasting is to predict your company's financial future. Forecasting aids in the making of business decisions and in understanding their impact before you implement them. If you aren't clear on the overall goals of the company, then your ability to accurately forecast your business's financial future falters. Therefore, you should have a clear understanding of what's driving your forecasting predictions; otherwise, they are just random guesses not grounded in the goals of your company. 

7. Plan for Various Scenarios

You can't plan for everything, but you can have an idea of some of the obstacles that could affect your initial forecast and budget. Review external market and economic trends that may negatively or positively impact your company. A rolling forecast is helpful for staying on top of any changes that could impact your business. Rolling forecasts also allow you to pivot as needed based on any new data presented so all decisions are based on what's happening now and not on what happened the previous year.
 
8. Track Everything
Everything needs to be accounted for when budgeting and forecasting for the upcoming fiscal year, whether it's the potential buyout of a competitor or just the office supplies. Don't underestimate the importance of seemingly minor details and their ability to affect the company's financial health. Once a budget is in place, allow for forecasting that looks at the many potential scenarios that may occur. Keep eyes and ears on market trends, client behaviors, and what the competition is up to as the business forecast is being finalized.

9. Include Profit and Cash Flow Goals 

Gene Siciliano a respected author says  "Every budget should have profit targets and cash flow targets because the two bottom line measures are very different, and they require different kinds of attention to control them." If you're not keeping track of these two important metrics of your business, how useful and accurate will your budget be? To keep your company from missing its financial goals, set realistic targets for both your cash and profit flow.

10. Let Excel Go

Don't rely on Excel or other spreadsheet software to do your budgets and forecasts. Planning software can go a long way in making the process easier and less time consuming. If you have the right FP&A team they will be pressing you to implement such software.


Resources:

How to calculate your cost of capital. The link below provides a clear explanation of how to calculate your cost of capital without using complex formulas.

https://www.cleverism.com/calculate-cost-capital-business/#:~:text=First%2C%20you%20can%20calculate%20it,%3A%20%24100%2C000%20x%200.05%20%3D%20%245%2C000.

You can contact me via

Jeremy@business-in-asia.org

Or schedule time via Calendly:

https://calendly.com/3-continents-consulting
 

My websites include:
https://business-in-asia.org/
https://thedentistscfo.com/
My LinkedIn URL
https://www.linkedin.com/in/jeremy-gray1

​

F3.10.4AA

0 Comments



Leave a Reply.

    new choice for BUSINESS SEARCH

    Archives

    February 2023
    January 2023
    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020

    Categories

    All
    Aaron Lee
    Ajai Lal
    Ally Nitschke
    Angela Chaney
    Angela Hooper Menifield
    Arthie-moore
    Ben Gioia ("joya")
    Bert Robinson
    Bijay Kumar Khandal
    Bill Kelly
    Bishop Cummings
    Bob DiGiacomo
    Brandon Souba
    Building Success Habits
    Business Podcasting Made Easy
    Cedrick Lafleur
    Celia Powell
    Charles George
    Crystal Y Davis
    Damian Johnson
    David Wilson
    Donna Kunde
    Ellen Mcilhenny
    Fady-g-bader
    Florin Lungu
    Gaby Awad
    James Bryant
    Jan Robberts
    Jeremy Gray
    Johanna Rincon
    John-richards
    Kasfia Rashid
    Kevin Beers
    Laura Bell
    Lisa Askwith
    Londina Cruz
    Monique McDonald
    News
    Nicole Rankine
    Patty Lawrence
    Prerona Roy
    Raj Kapur
    Ramdas Shenoyy
    Ravin Papiah
    Rick Carter
    RJ Lewis
    Russell Colbourne
    Sadika Kebbi
    Sarita Johan
    Scott Geller
    Season 10 Executive
    Season 10 Finance
    Season 10 Operations
    Season 10 People
    Season 11 Executive
    Season 11 Finance
    Season 11 Operations
    Season 11 - Operations
    Season 11 People
    Season 12 Customers
    Season 12 Finance
    Season 12 Operations
    Season 12 People
    Season 1 Coaching
    Season 1 Consulting
    Season 1 Customers
    Season 1 Executive
    Season 1 Finance
    Season 1 Operations
    Season 1 People
    Season 1 Strategy
    Season 2 Customers
    Season 2 Executive
    Season 2 Finance
    Season 2 Operations
    Season 2 People
    Season 3 Consulting
    Season 3 Customers
    Season 3 Executive
    Season 3 Finance
    Season 3 Operations
    Season 3 People
    Season 4 Customers
    Season 4 Executive
    Season 4 Finance
    Season 4 Operations
    Season 4 People
    Season 5 Customers
    Season 5 Executive
    Season 5 Finance
    Season 5 Operations
    Season 5 People
    Season 6 Consulting
    Season 6 Customers
    Season 6 Executive
    Season 6 Finance
    Season 6 Operations
    Season 6 People
    Season 7 Customers
    Season 7 Executive
    Season 7 Finance
    Season 7 Operations
    Season 7 People
    Season 8 Finance
    Season 8 Operations
    Season 8 People
    Season 9 Customers
    Season 9 Executive
    Season 9 Finance
    Season 9 Operations
    Season 9 People
    Simone Douglas
    START HERE
    Steve Sweeney
    Teena Ogbugoh
    Tracie Hines Lashley
    Vicki Abraham
    Wendy Dickinson
    William Eastman

    RSS Feed

Radio

Become a Host
Get the Listener Guide
Contact Us​

SOCIAL MEDIA

Join our Facebook Group
​Connect on LinkedIn
BTS on YouTube

365 Business Maker

Grow Your Business
Apply to Work With Us
Network and CONNECT

free resources

Download the Growth App
Download the Checklist
Download the Podcasts

Listen Live ON THE FOLLOWING APPS & NETWORKS

Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture

Search IBGR On These Podcast Platforms

Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture
Picture

SPONSORS & AFFILIATES

Picture
Southern Virginia Regional Chamber
Picture
Picture
Influence With A Heart
Picture
Picture
Book Design and More
Picture
Picture
Startup Raven
Picture
Picture
Coach Accountable
Picture
Black Links Global
Picture
Click Funnels
Picture
Picture
Airmeet
Picture
SCHEDULE A NO-RISK, NO OBLIGATION CONSULTATION WITH THE IBGR TEAM
866.4ME.IBGR (866.463.4247)
IBGR.Network is Veteran owned and operated. 
Site powered by Weebly. Managed by Radio.co, Designed by gWORX Media.
  • WELCOME
    • EXEC TEAM
    • CONTACT US
    • PRIVACY
  • RADIO
    • ON AIR NOW
    • LISTENER GUIDE
    • SHOWS ON DEMAND >
      • BUSINESS PODCASTING MADE EASY
      • ECONOMIC NEWS >
        • IBGR.News
      • EXIT STRATEGIES >
        • An Epic Business Exit
        • Catalytic Conversation$
        • Exitology
        • The CFO Perspective
        • The Entrepreneur's Edge
        • The Smart & Savvy Business Exit
      • FINANCE >
        • Business Econ for a Post Pandemic World
        • Economics For Owners
        • Employee Capitalism
        • Money Matters
        • Practical Solutions to Difficult Problems
        • TurboCharge Your Business
        • Your Money Machine
      • HR / PEOPLE SKILLS >
        • Business and Beyond
        • Business Processes & People Talk
        • Equipping Others
        • Staff It!
        • Success Can Be Fun - With Focus!
        • The People Side of Business
        • Women of Business Thriving
      • INTERVIEWS >
        • Get You Noticed!
        • The Referral Guy Interviews Your
        • The Magnetic Voice
      • LEADERSHIP >
        • Compassionate Leaders of Influence
        • Destiny Road
        • Engaging Your People For Success
        • Leadershift with Col Ajai Lal
        • Leadership Powered by Common Sense
        • Influencing for Global Impact
        • Talk Leadership with Cedrick on the Radio
        • Your Corporate Confidante
      • MARKETING >
        • Building A Multilevel Marketing Empire
        • Level-Up Your Marketing
        • No Nonsense Market Domination
        • Buying Customers
        • #Seriously Social
        • Results Oriented Marketing
      • MINDSET >
        • Building Success Habits
        • Building You to Build Your Business
        • Entrepreneurial Mindset
        • Peak Impact Mentorship
        • Guidance To Wealth
        • The Hero Within
      • OPERATIONS >
        • Build It!
        • Building In Front of You
        • Building In Front of Your 2
        • Lead Lean
        • Pencils & Pistons
        • Planning Out Loud
        • Processes Under Control
        • The Ralph Peterson Radio Show
      • SALES >
        • Beyond The Method Selling
        • Inside The Customer
        • Sell It!
        • Serving Up Sales
      • STARTUPS >
        • A Business Primer for Startups
        • A New Business Model For Startups
        • Adulting In My Purpose Business Edition
        • Building Startup Operations
        • Creating A Consulting (Improvement) Business
        • How To Start A Consulting Firm
        • Survival Mode
        • The Geriatric Entrepreneur
        • Your Business 2.0
        • Z Gen Entrepreneurship
      • STRATEGY >
        • #OwnrLife
        • Better Your 4 U
        • Build Your Core for Dynamic Partnerships
        • Grow It!
        • How to Avoid Becoming the 80%
        • How To Become the Top 5%
        • How to Move Beyond the 15%
        • Living the Life .. On YOUR Terms
        • Own It!
        • ReImagine Your Business
        • The Business Owner's Bookshelf
        • The Self Managing Organization
        • Tenacious Top of Mind Business Insights
    • MEET THE HOSTS >
      • Ben Gioia ("joya")
      • Bert Robinson
      • Chris Mayfield
      • Crystal Y. Davis
      • Donna Kunde
      • Doug Thorpe
      • Ellen McIlhenny
      • Glenda Thompson
      • Jason "Wally" Waldron
      • Jeremy Gray
      • Jörn "Joe" Menninger
      • Kevin Beers
      • Lisa Askwith
      • Londina Cruz
      • Mike King
      • Monique McDonald
      • Patty Lawrence
      • RJ Lewis
      • Sarita Johan
      • Steve Sweeney
      • William Eastman
    • JOIN THE TEAM >
      • BECOME A HOST
      • BE A SPONSOR
  • CONSULTING
    • HOST PACKAGES
    • ADVERTISING PACKAGES
    • BUSINESS MAKER PACKAGES
    • FRACTIONAL CONSULTANTS
  • NEWS
    • E-NEWSPAPER
    • NEWS BLOG
    • NEWS PODCASTS
  • RESOURCES
    • START HERE
    • SHOW NOTES
    • GROWTH APP
    • FACEBOOK COMMUNITY
    • LINKEDIN COMMUNITY
    • EVENTS
    • IBGR MERCHANDISE