Magnimetrics Library
Practical finance, Excel, valuation, and FP&A articles with downloadable working files where relevant.
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 […]
Let’s start by looking at why businesses need rolling forecasts. When running a business, we need to have a full view of what’s happening so that we can make the proper decisions. The best way to achieve this is to implement a budgeting and planning process. We create an expected standard performance for the business […]
With a reach in e-commerce, cloud computing, digital streaming, and artificial intelligence, Amazon is now one of the largest corporations in the world. Analysts often refer to it as one of the most influential economic forces in the world. Alongside Google, Microsoft, and Apple, Amazon is considered one of the Big Four tech companies. In […]
Whenever we are constructing a financial model, we rely heavily on assumptions. Some, if not all, of those assumptions, have the associated uncertainty and inherent risk. Not being able to predict the future makes it harder to solve and model the probability of different outcomes from our financial models. In such situations, we can apply […]
Introduction Running a business poses the threat of getting lost into the day-to-day issues the company faces. And this can mean we start to miss the bigger picture. Investing time and resources in creating a budget and a business plan is essential to ensure we form a proper long-term strategy for the business. A budget […]
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, […]
Introduction Opportunity cost represents the benefits the business misses out on when picking between alternatives. When we have two desirable options, the benefit from the one not chosen is our opportunity cost. These costs are usually the result of bottlenecks in business processes. Therefore, finance professionals use Opportunity Cost analysis to improve the decision-making process […]
The Net Present Value (NPV) is a profitability measure we use to figure out the present value of all expected future cash flows a project or investment will generate, including the initial capital we invest. It shows us the difference between the current value of cash inflows and outflows over a period. Net Present Value […]
Introduction We perform a liquidity ratio analysis to evaluate the ability of the company to settle its obligations on time. The most common use case is when lenders and creditors want to gain a better understanding of the financial health of a borrower or customer. Analysts use the gained insights to set credit terms and […]
Introduction Investors are continually evaluating different investments, trying to identify the ones that will maximize their returns and wealth. Analysts consider the Compound Annual Growth Rate (CAGR) as one of the most accurate ways to calculate the return for any investment with a value that changes over time. CAGR represents the rate of return an […]
