## How to use the Asset Turnover Ratio

The Asset Turnover Ratio measures how efficiently management uses the company’s assets to generate sales revenue. The ratio compares the amount of net sales to its total assets. It’s a standard efficiency ratio, as it gives investors an idea of how well management runs the company. What is the Asset 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…

## Accounts Receivable Aging Report in Excel

The Receivables Aging (or Ageing, if you prefer British English) report is a tool that lists all unpaid customer balances by pre-defined date ranges (buckets). It shows the relationship between open invoices and their due dates. It is the primary tool to determine overdue balances for collection. It’s useful for Read more…

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

## What are Capital Expenditures (CAPEX)?

Capital Expenditures, or CAPEX for short, are cash or credit payments to acquire goods or services that we capitalize in balance sheet assets. From the company’s perspective, we consider those to be an investment. Here we include all expenses that are not shown on the Income Statement and do not 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…