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

## How to Analyze the Accounts Receivable Turnover Ratio

The Accounts Receivable Turnover ratio (AR T/O ratio) is an accounting measure of effectiveness. It is also known as the Debtor’s Turnover ratio, and we use it to gauge how effectively the company manages credits they extend to customers and collection. We calculate the ratio by dividing net sales over Read more…

## How to Perform a Cash Ratio Analysis in Excel

The Cash Ratio represents a measurement of the liquidity of a company. It evaluates the ability of the business to cover short-term obligations with cash and cash equivalents alone. It is particularly useful to creditors when deciding how much money they are willing to loan to a company. Suppliers also Read more…

## Vacation Days and Unused Paid Leave Accrual

When a company hires employees, they provide it with services. In turn, the company, as their employer, reimburses their time spent with a remuneration package. This usually consists mostly of a salary but can include various other benefits, some of which may be mandated by law or local legislation. One Read more…

## How to Perform Net Realizable Value (NRV) Analysis

Accounting standards (IRFS and US GAAP) require that we apply a conservatism principle when we assess the value of assets and transactions. The Net Realizable Value (NRV) is the amount we can realize from an asset, less the disposal costs. The most often use of the method is when we Read more…

## Obsolete Inventory and How to Deal With It

Most companies in the manufacturing and retail industries have Inventory. Slow-moving and obsolete Inventory can have a severe adverse effect on the profitability of the business. When we can’t realize our goods on hand, they lose value and may become useless for the company. To account for this decrease in Read more…

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

## Introduction to Enterprise Value (EV) of the Business

Once you start delving deeper into valuation and especially in the premise of mergers and acquisitions, you notice that Enterprise Value is an essential term in this field. A company’s value consists of its owned assets, but in reality, obtaining their market value can be tedious and resource-intensive. Following the Read more…