Get Certified for Financial Modeling (FMVA)®
Gain in-demand industry knowledge and hands-on practice that will help you stand out from the competition and become a world-class financial analyst.
Variance Formula
Calculating the difference between a forecast and the actual result
How to Calculate Variance?
The variance formula is used to calculate the difference between a forecast and the actual result. The variance can be expressed as a percentage or an integer (dollar value or the number of units). Variance analysis and the variance formula play an important role in corporate financial planning and analysis (FP&A) to help evaluate results and make informed decisions for a business going forward.
What is the Variance Formula?
There are two formulas to calculate variance:
Variance % = Actual / Forecast – 1
or
Variance $ = Actual – Forecast
In the following paragraphs, we will break down each of the formulas in more detail.
Percent Variance Formula
As the name implies, the percent variance formula calculates the percentage difference between a forecast and an actual result.
In the example analysis above we see that the revenue forecast was $150,000 and the actual result was $165,721. Therefore, we take $165,721 divided by $150,000, less one, and express that number as a percentage, which is 10.5%.
This is an example of outperformance, a positive variance, or a favorable variance.
Dollar Variance Formula
The formula for dollar variance is even simpler. It’s equal to the actual result subtracted from the forecast number. If the units are dollars, this gives us the dollar variance. This formula can also work for the number of units or any other type of integer.
In the same example as above, the revenue forecast was $150,000 and the actual result was $165,721. We now take $165,721 and subtract $150,000, to get a variance of $15,721.
Download the Free Template
Enter your name and email in the form below and download the free template now!
* By submitting your email address, you consent to receive email messages (including discounts and newsletters) regarding Corporate Finance Institute and its products and services and other matters (including the products and services of Corporate Finance Institute's affiliates and other organizations). You may withdraw your consent at any time.
This request for consent is made by Corporate Finance Institute, #1392 - 1771 Robson Street, Vancouver, BC V6G 3B7, Canada. www.corporatefinanceinstitute.com. [email protected]. Please click here to view CFI`s privacy policy.
Favorable vs. Unfavorable Variance
Since variance analysis is performed on both revenues and expenses, it’s important to carefully distinguish between a positive or negative impact. For this reason, instead of saying positive, negative, over or under, the terms favorable and unfavorable are used, as they clearly make the point.
For example, if a cost has a negative difference to the forecast (lower than expected), that’s a favorable variance since it’s better to have costs lower rather than higher.
Variance in Budgeting and Forecasting
The variance formula is useful in budgeting and forecasting when analyzing results. The job of a financial analyst is to measure results, compare them to the budget/forecast, and explain what caused any difference.
In the Financial Planning & Analysis department at a company, the role of FP&A is to present management with accurate, timely, and insightful information so they can make effective decisions about the business going forward.
Using the variance formula and presenting this type of information is critical in FP&A.
Additional Resources
At CFI, our mission is to help you advance your career. With that goal in mind, we highly recommend these additional free CFI resources:
