KPM

Inventory Management WIP Non-GAAP Metrics Reduce Billing Bottlenecks Auditor Independence Accounting Methods Year-End Financials Auditing Revenue Recognition Inventory Management System Access To Capital M&A Due Diligence What Is Materiality Job-Costing Systems Technology Bank Reconciliation Cybersecurity New Segment Expense Disclosure Rules QuickBooks To Prepare 2024 Budgets Safeguard Organization Assets Offsetting Rules Inventory Count negotiation M&A Accounting Monthly Financial Close Shareholder advance Payroll challenges Prepare for audit QuickBooks income tax Crypto Accounting Percentage-Of-Completion Financial Statement PCAOB Overhead Mileage in QuickBooks UTPs Cross-Train Employee Benefit Plan Audits Accounts Receivable

Four Questions to Guide Your Prospective Financial Statements

CPAs do not just offer assurance services on historical financial results. They also can prepare prospective financial statements predicting how the company will perform in the future. This list of questions can help you make more meaningful assumptions for your forecasts and projections.

  1. How far into the future do you want to plan?

Forecasting is generally more accurate in the short term. The longer the time period, the more likely it is that customer demand or market trends will change.

While quantitative methods, which rely on historical data, are typically the most accurate forecasting methods, they do not work well for long-term predictions. If you are planning to forecast over several years, try qualitative forecasting methods, which rely on expert opinions instead of company-specific data.

  1. How steady is your demand?

Sales can fluctuate for a variety of reasons, including sales promotions and weather. For example, if you sell ice cream, chances are good your sales dip in the winter.

If demand for your products varies, consider forecasting with a quantitative method, such as time-series decomposition, which examines historical data and allows you to adjust for market trends, seasonal trends, and business cycles. You also may want to use forecasting software, which allows you to plug other variables into the equation, such as individual customers’ short-term buying plans.

  1. How much data do you have?

Quantitative forecasting techniques require varying amounts of historical information. For instance, you will need about three years of data to use exponential smoothing, a simple yet fairly accurate method that compares historical averages with current demand.

Want to forecast for something you do not have data for, such as a new product? In that case, use qualitative forecasting or base your forecast on historical data for a similar product in your arsenal.

  1. How do you fill your orders?

Unless you fill custom orders on demand, your forecast will need to establish optimal inventory levels of finished goods. Many companies use multiple forecasting methods to estimate peak inventory levels. It also is important to consider inventory needs at the individual product level and local warehouse level, which will help you ensure speedy delivery.

If you are forecasting demand for a wide variety of products, consider a relatively simple technique, such as exponential smoothing. If you offer only one or two key products, it probably is worth your time and effort to perform a more complex, time-consuming forecast for each one, such as a statistical regression.

Plan to succeed

You may not have a crystal ball, but using the right forecasting techniques will help you gaze into your company’s future with greater accuracy. We can help you establish the forecasting practices that make sense for your business.

Related Articles

Talk with the pros

Our CPAs and advisors are a great resource if you’re ready to learn even more.