The Analysis of Variance (ANOVA) has many varieties, but in essence, it has the purpose of evaluating whether factors are associated with any outcome values. And factors are categorical variables we use to group the outcome variables. In this article, we will not be focusing on the underlying statistical principles Read more…
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…
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…
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…
Beta is a risk-reward measure from fundamental analysis to determine the volatility of an asset compared to the overall market. We consider the market to have a beta of one. Then all assets are ranked based on their deviation from the market. If an asset’s returns fluctuate more than the Read more…
In finance, one of the popular methods to adjust return rates of investments for risk is the Sharpe Ratio. William F. Sharpe developed the ratio in 1966 and revised it in 1994 to arrive at the formula we use today. Originally he called it the ‘reward-to-variability’ ratio. Later on, finance Read more…
There’s a widespread assumption in investing that more risk equals increased potential returns. The theory behind the Efficient Frontier and Optimal Portfolios states that there’s an optimal combination of risk and return. The theory relies on the assumption that investors prefer portfolios that generate the most substantial possible return with Read more…
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…
In one of our recent articles, we looked into how to set up and run Monte Carlo Simulations in Excel. And we looked at some of the most common probability distributions, which we can apply to illustrate the uncertainty of our model’s variables. When we work on a financial model, Read more…
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…
