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 […]
Your Business Needs a Flux Analysis
Flux Analysis is a type of comparison technique that helps us understand the changes in a company’s financials from period to period. It is shortened from Fluctuations Analysis and is also sometimes called Horizontal Analysis. We use the method to evaluate the fluctuations in accounts over time. We usually express such changes in both monetary […]
Understand the Market Value of Equity
The Market Value of Equity of the company, also known as Market Capitalization, is the total monetary value of the firm’s equity. We calculate it as the current stock price multiplied by the number of outstanding shares. Therefore the MVE continually changes, as these two values are quite volatile. Analysts mostly use the Market Value […]
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 […]
Black-Scholes Model: First Steps
Today we take a look at the most popular options pricing model. The Black Scholes Model, also known as the Black-Scholes-Merton method, is a mathematical model for pricing option contracts. It works by estimating the variation in financial instruments. The technique relies on the assumption that prices follow a lognormal distribution. Based on this, it […]
Optimal Portfolios and the Efficient Frontier
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 the least amount of involved […]
Understanding the Binomial Option Pricing Model
The Binomial Option Pricing Model is a risk-neutral method for valuing path-dependent options (e.g., American options). It is a popular tool for stock options evaluation, and investors use the model to evaluate the right to buy or sell at specific prices over time. Under this model, the current value of an option is equal to […]
Weighted Average Cost of Capital (WACC) Case Study: Amazon (AMZN)
With a reach in e-commerce, cloud computing, digital streaming, and artificial intelligence, Amazon is now one of the largest corporations in the world. Analysts often refer to it as one of the most influential economic forces in the world. Alongside Google, Microsoft, and Apple, Amazon is considered one of the Big Four tech companies. In […]