Seasonality and Trend Forecast with Regression in Excel

In our last article, we discussed Seasonality in Financial Modeling and Analysis. We went over an example Excel model of calculating a forecast with seasonality indexes. Today we will use regression analysis in Excel to forecast a data set with both seasonality and trend. Let’s look at the quarterly sales revenue of the electronic cameras […]

Introduction to Seasonality in Financial Analysis and Modeling

Seasonality is a characteristic of time-series where the data has predictable and somewhat regular fluctuations that repeat year over year. It is safe to assume that any pattern of data changes over one-year periods represents seasonality. It is usually driven by weather or commercial seasons. We have to differentiate the term from cyclical data, as […]

Forecast Sales Performance and Seasonality

We are approaching the second half of the year, and before we know it, it will be the time of year to start working on our projections for next year and the company’s annual budget. There are many complex and detailed models that we can utilize to forecast the sales performance of the business for […]

Performing Contribution Margin Analysis

Introduction The Contribution Margin is a significant financial metric that is sometimes neglected by managers. While profit margin is one we usually hold very important, it gives information only on the amount with which revenues exceed costs. On the other hand, Contribution Margin provides us with a way to see how exactly each separate product […]

The Absorption Costing Method

Today we take a look at the Absorption Costing Method and how it is used to allocate cost to produced goods. Do not forget to download the Excel working file at the end of the article. What is Absorption Costing? Absorption Costing is a management accounting method for accumulating all costs associated with production in […]

Cost-Volume-Profit Analysis and Break-even point

Today we will take a look at Cost-Volume-Profit (CVP) analysis and the Break-even point (BEP) in sales. Cost-Volume-Profit Analysis The Cost-Volume-Profit  (CVP) analysis is a method of cost accounting. It looks at the impact of changes in production costs and sales on operating profits. Performing the CVP, we calculate the Break-even point for various sales […]