Magnimetrics Library
Practical finance, Excel, valuation, and FP&A articles with downloadable working files where relevant.
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, […]
Introduction The High-Low Method is a technique of cost accounting, which is used to split mixed costs into variable and fixed components. It is essential to note that the High-Low method is not very popular as it relies on extreme values of the population and can distort the cost distribution. However, the technique is one […]
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 […]
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 […]
This week we will take a practical look at creating a Cash Flow Forecast model. What is a Cash Flow Forecast and Why we need one The Cash Flow forecast is a crucial planning tool for financial management. It is the process of preparing an estimate of future financial performance, based on anticipated cash disbursements […]
This week we take a look at Free Cash Flow and how we can use it within a financial analysis setting. What is Free Cash Flow? The Free Cash Flow (FCF) represents the cash generated, after cash outflows to support the operating activities of the business and to maintain its capital assets. It’s a measure […]
Today we take a look at the Absorption Costing Method and how it is used to allocate cost to produced goods. Do not forget to download the Excel working file at the end of the article. What is Absorption Costing? Absorption Costing is a management accounting method for accumulating all costs associated with production in […]
Today we will take a look at Cost-Volume-Profit (CVP) analysis and the Break-even point (BEP) in sales. Cost-Volume-Profit Analysis The Cost-Volume-Profit (CVP) analysis is a method of cost accounting. It looks at the impact of changes in production costs and sales on operating profits. Performing the CVP, we calculate the Break-even point for various sales […]
Today we are looking at how the Discounted Cash Flow (DCF) method is used to evaluate investment opportunities or project alternatives in big companies, like launching a new product, a new assembly line, etc. We can use the DCF method whenever we consider paying now to get more money (or benefits) later. Investors and Investment […]
This article builds upon the theory discussed in Creating a Variance Analysis Model – Part 1. Be sure to read this article before looking at the more practical examples below. Building a Variance Analysis Model in Excel Let’s create an Excel model to perform our variance analysis. For the exercise, we will assume a simple scenario […]
