## Forecasts with the Polynomial Regression Model in Excel

Regression analysis aims to model the expected values for a dependent variable (y) based on independent variables (x). The polynomial regression is a statistical technique to fit a non-linear equation to a data set by employing polynomial functions of the independent variable. We can use the model whenever we notice Read more…

## Regression Analysis in Financial Modeling

Regression Analysis represents a set of statistical methods and techniques, which we use to evaluate the relationship between variables. These are one dependent variable (our target) and one or more independent variables (predictors). We have three primary variants of regression – simple linear, multiple linear, and non-linear. However, most of Read more…

## 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 Read more…

## 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 Read more…

## 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 Read more…

## Calculate Value in Use under IAS 36

The core underlying principle of IAS 36 Impairment of Assets is that an asset’s carrying value in the financial statements of the company should not exceed the highest amount the business can recover through its use or sale. The standard applies to all assets for which there are no impairment Read more…

## Rolling Forecasts in Financial Planning

Let’s start by looking at why businesses need rolling forecasts. When running a business, we need to have a full view of what’s happening so that we can make the proper decisions. The best way to achieve this is to implement a budgeting and planning process. We create an expected Read more…

## Understanding The Value of a Budget

Introduction Running a business poses the threat of getting lost into the day-to-day issues the company faces. And this can mean we start to miss the bigger picture. Investing time and resources in creating a budget and a business plan is essential to ensure we form a proper long-term strategy Read more…

## Compound Annual Growth Rate (CAGR) in Financial Modeling

Introduction Investors are continually evaluating different investments, trying to identify the ones that will maximize their returns and wealth. Analysts consider the Compound Annual Growth Rate (CAGR) as one of the most accurate ways to calculate the return for any investment with a value that changes over time. CAGR represents Read more…

## CAPEX, Depreciation and Amortization in Financial Modeling

If you are already familiar with the outlined concepts, maybe you would be more interested in taking a look at the Excel model, which you can download below the article. Introduction Long-term (non-current) assets of the company have a long useful life (more than one year). When acquiring capital assets, Read more…