Magnimetrics Library

Magnimetrics

Practical finance, Excel, valuation, and FP&A articles with downloadable working files where relevant.

126 articles
Financial Analysis

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

Financial Analysis

Breaking down the Economic Value Added (EVA) Calculation

Introduction to the Economic Value Added (EVA) The EVA (Economic Value Added) is an indicator of profitability and a measure of financial performance, based on residual wealth. It is the excess profit above the cost of capital, generated by the business, adjusted for taxes, and presented on a cash basis. The consulting firm Stern Value […]

Financial Analysis

Process Costing in Management Accounting

Costing is an essential aspect of operations for companies that want to understand how their production absorbs costs. Only by gaining a solid understanding of the company’s cost structure can we start to control and optimize it. We can often divide the production process into specific jobs and apply the job costing method to them. […]

Financial Analysis

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 Turnover Ratio The ratio, also […]

Financial Analysis

Time Value of Money Explained

Introduction To understand the Time Value of Money, imagine you were offered 100 euros now or 100 euros in three years, what would you prefer? If you are like me, you’d probably prefer the money now. But why is that, when a 100 euros has the same value now and in the future? Having it […]

Financial Analysis

Capital Asset Pricing Model (CAPM)

Introduction The Capital Asset Pricing Model (CAPM) shows us the relationship between systematic risk for an investment and the expected return on it. Analysts and financial professionals use the model widely for pricing risky investments and generating expected returns for assets, considering the risk and cost of capital. The CAPM goal is to see if […]

Financial Analysis

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

Financial Analysis

Terminal Value of the Business

What is Terminal Value? The Terminal Value (TV), or as it is also known, continuing value or horizon value, is the value of an investment or a business at the end of a specific period. A firm or project potentially has an infinite life, meaning its value is the Net Present Value (NPV) of cash […]

Financial Analysis

Value Chain Analysis Break-down

The primary purpose of any business is to produce goods or provide services in a way that they have a higher value for the customers than the original cost for the firm. Companies engage in numerous activities while converting inputs to outputs. Porter’s Value Chain helps us create a clear overview of the internal organization, […]

Financial Analysis

Customer Lifetime Value (CLV) – an Essential Business Metric

When we are trying to optimize the experience for our customers, there are many metrics we can track and aim to improve. The Customer Lifetime Value (CLV) shows us how much money a customer will bring to the business on average over the entire time they remain a paying client. Whether we decide to refer […]