Multiple Linear Regression Analysis in Excel

In a previous article, we explored Linear Regression Analysis and its application in financial analysis and modeling. You can read our Regression Analysis in Financial Modeling article to gain more insight into the statistical concepts employed in the method and where it finds application within finance. This article will take a practical look at modeling […]

Hypothesis Testing for Complete Beginners

Gathering data in itself is meaningless unless we can analyze it and draw powerful insights. What makes data interesting is the ability to evaluate and interpret it. Hypothesis testing refers to a term in statistics where we, as the analysts, evaluate an assumption related to a data set parameter. Based on the purpose of the […]

How to Run a Two-Way Analysis of Variance (ANOVA) in Excel

Recently, we looked at how to Perform a One-Way Analysis of Variance in Excel. In today’s article, we will take that a step further and a look at a Two-Factor ANOVA. The Two-Way Analysis of Variance (ANOVA) is a statistical test to evaluate the difference between the means of more than two groups. It is […]

Perform a One-Way Analysis of Variance (ANOVA) in Excel

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 and formulas. We will briefly […]

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 […]

How to Calculate the Beta of a Company

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 market, then this asset has […]

Monte Carlo Simulation in Financial Modeling

Whenever we are constructing a financial model, we rely heavily on assumptions. Some, if not all, of those assumptions, have the associated uncertainty and inherent risk. Not being able to predict the future makes it harder to solve and model the probability of different outcomes from our financial models. In such situations, we can apply […]

Least-Squares Method to Estimate the Cost Function

Introduction Linear regression is considered the most accurate method in segregating costs into Fixed and Variable components. Like the High-Low Method and other methods, the Least-Squares Method follows the same simple linear cost function: However, most people consider the Least-Squares Method more accurate, as it computes Fixed and Variable Costs mathematically. When looking into costs, […]

The Altman Z-Score Analysis

Today we are looking at a more complex financial analysis model – the Altman Z-Score Analysis. But I promise, there’s a reward at the end of the article. The Z-score formula for predicting bankruptcy was published in 1968 by Edward Altman, Assistant Professor in the field of Finance in the New York University. In the […]