Percent-of-Sales Method

Percent-of-Sales Method

See Also:
ProForma Financial Statements
Cost Center
Weighted Average Cost of Capital (WACC)
Standard Costing System
Activity Based Costing vs Traditional Costing

Percent-of-Sales Method

The percent-of-sales method is a technique for forecasting financial data. When forecasting financial data for strategic planning, budgeting, or for developing pro forma financial statements, analysts can use the percent-of-sales method of forecasting to create reasonable projections for certain key data.
The idea is to see how a financial statement account item relates historically to sales figures. Then use that relationship to project the value of those financial statement account items based on future sales estimates. This method of forecasting requires the items to be estimated based on relations to sales figures, thus it is necessary that movements in the items to be forecast are highly correlated with fluctuations in the sales figures. Forecast that item using a different technique; especially if there is no clear correlation between the item to be forecast and sales figures.
For example, if, after examining and analyzing historical financial statement data, an analyst determines that inventory levels are typically at 30% of sales. Additionally, the sales forecast for the coming year is for $100,000 dollars in sales. Then according to the percent-of-sales method of forecasting, the analyst can estimate inventory of approximately $30,000, or 30% of the estimated sales figure.
[box][highlight]If you’re still not sure how to accurately project your sales, click here to access your free Goldilocks Sales Method tool. This tool allows you to avoid underestimating or over-projecting sales.[/highlight][/box]

Three Step Process

There are three steps in the percent-of-sales forecasting process. First, use the sales figures to identify the correlated items. Then separate the uncorrelated out. To do this, analyze historical financial statement data. Only the items which are correlated with sales figures can accurately be predicted or forecast using the percent-of-sales method. Estimate items that have no concrete relation to sales figures using a different technique.
Next, forecast sales for the fiscal period in question. Because all projections in the percent-of-sales method of forecasting depend on relationships between financial statement items and sales figures, it is very important to get an accurate sales forecast.
The third step in the percent-of-sales method of forecasting is to forecast the values of certain appropriate financial statement items. You can accomplish this by using the sales forecast from the previous step in combination with the historical relation between the financial statement item and the sales figure.

Percent-of-Sales Method

1. Analyze historic financial statement data
2. Forecast sales for the fiscal period
3. Forecast financial statement items using sales forecast
If you need help creating an accurate sales pipeline, download the Goldilocks Sales Method.
percent-of-sales method

[box]Strategic CFO Lab Member Extra
Access your Flash Report Execution Plan in SCFO Lab. The step-by-step plan you manage your company before you prepare your financial statements.

Click here to access your Execution Plan. Not a Lab Member?
Click here to learn more about SCFO Labs[/box]

Pledged Collateral

ARTICLES YOU MIGHT LIKE

The Struggles of Private Company Accounting

Hiring the right accountant  When I meet a business owner operating at a successful $10 million in revenue, they often mention, “My CPA”… I immediately know that CEO/Entrepreneur is referring to their Tax CPA.  That is because one thing that all Entrepreneurs have in common is that they must file a tax return.  So, from

Read More »

IN CRISIS? GET A STRATEGIC CFO! – CEO Blindspots Podcast

Friend of the firm, Birgit Kamps, recently had Strategic CFO President, Dan Corredor, as a guest on her podcast, CEO Blindspots. CEO BLINDSPOTS HOST: Birgit Kamps. She was speaking five languages by the age of 10, and lived in five countries with her Dutch parents prior to becoming an American citizen. Birgit’s professional experience includes starting

Read More »

SHRM calls ICHRA the 401K for Group Health Benefits

Fed-up with group health insurance? ICHRA is the new way to offer great health benefits and avoid ACA penalties, SHRM calls it the 401K for group health benefits.  In 2020 the Department of Labor, HHS and IRS changed the rules for employer health benefits. They changed the Affordable Care Act mandates and penalties for every

Read More »

JOIN OUR NEXT SERIES

Financial Leadership Workshop

MARCH 28TH-31ST 2022

SHARE THIS ARTICLE

JOIN THE NEXT STRATEGIC CFO™ SERIES

Strategic CFO™ Financial Leadership Workshop
The Art of the CFO®

Days
Hours
Min
Sec

September 12-15th 2022