Magnimetrics Library
FP&A, valuation, Excel, and financial modeling articles with practical downloadable resources.
In the modern world, reporting is an essential part of running a company. But reporting only allows management to react to what has happened. There’s no outlook for the future. If our business only does reporting, we are already lagging behind. Business Intelligence can help us have smart reporting that gives insights about decisions that […]
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 […]
Lately, I’ve been working on a side project, modeling some financial statements. When I do those, I like to work with full numbers, as I get a better feel of the material items. However, when it’s time to prepare the final deliverables, I always round in thousands. What I have been doing so far is […]
The Cash Flow Statement is one of the three primary financial statements. It outlines the sources & uses of cash by the company and has three main categories of cash flows: The Cash Flow Statement is an integral part of the company’s financial statements, alongside the Income Statement and the Balance Sheet. It adds more […]
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, […]
In one of our recent articles, we looked into how to set up and run Monte Carlo Simulations in Excel. And we looked at some of the most common probability distributions, which we can apply to illustrate the uncertainty of our model’s variables. When we work on a financial model, we face issues with variables […]
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 […]
In my current job in Mergers & Acquisitions, I have to prepare many complex folder structures for targets’ data rooms. It’s a tedious but straightforward process that can take up to an hour, as each Request For Information letter is almost the same but contains slight differences. For example, we may need detailed information of […]
In finance, one of the popular methods to adjust return rates of investments for risk is the Sharpe Ratio. William F. Sharpe developed the ratio in 1966 and revised it in 1994 to arrive at the formula we use today. Originally he called it the ‘reward-to-variability’ ratio. Later on, finance professionals started referring to it […]
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 the time, we use linear […]
