Magnimetrics Library
Practical finance, Excel, valuation, and FP&A articles with downloadable working files where relevant.
Introduction The Pareto Analysis is a statistical technique employed in decision-making to identify a limited set of tasks to produce the most significant effect. We base it on the Pareto Principle, which stipulates that 20% of the work on a project generates 80% of the outputs. The technique is also known as the 80/20 rule, […]
Introduction to Scenario Analysis Scenario Analysis represents the process of calculating an estimation model under a variety of scenarios for the future. The idea behind this analysis method is to assess the effect of risk on values in a financial model. Scenario Analysis helps us outline how realistic are the assumptions in our model and […]
Introduction to Sensitivity Analysis We apply Sensitivity Analysis to a financial model to determine how different values of an independent variable affect a specific dependent variable under a given set of assumptions. We also refer to it as ‘what-if’ or simulation analysis. Performing such analysis helps us predict better the outcome of a decision, based […]
What is the Cash Conversion Cycle The Cash Conversion Cycle is a metric that tells us how long it takes the company to convert capital invested in inventory back to cash. Here’s a cool-looking process diagram to illustrate the cash conversion cycle: Elements of the Cash Conversion Cycle The Cash Conversion Cycle is a combination […]
Introduction to the Activity-Based Costing (ABC) Model The Activity-Based Costing method identifies the activities in the company and assigns their costs to production based on actual consumption. One of the most recognized definitions is of the Chartered Institute of Management Accounting (CIMA) and defines the ABC method as an ‘approach to costing and monitoring of […]
What is a Leveraged Buyout (LBO) Transaction? A Leveraged Buyout (LBO) transaction is the acquisition of an entity using significant amounts of loaned capital to meet the consideration. LBO transactions can go up to 9:1 ratio of Debt to Equity. In a Leveraged Buyout transaction, the target company’s assets become collateral for the loan. LBOs […]
What is Burn Rate? We call Burn Rate the rate at which it spends its raised funds to cover running costs. It is used with new companies and start-ups and is a measure of negative cash flow. Investors and managers usually state Burn Rate per month, but in crisis times, we can measure it on […]
If you haven’t read the article on the Economic Value Added (EVA) metric, please, take a look here, before you read on. Introduction In today’s post, we are doing a short case study, trying to calculate the Economic Value Added (EVA) for Nestlé for FY 2018, using actual data available in the public domain. Nestlé […]
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 […]
Introduction The Weighted Average Cost of Capital (WACC) shows a firm’s blended cost of capital across all sources, including both debt and equity. We weigh each type of financing source by its proportion of total capital and then added together. Financial analysts use WACC widely in financial modeling as the discount rate when calculating the […]
