Magnimetrics Library
Practical finance, Excel, valuation, and FP&A articles with downloadable working files where relevant.
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 […]
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 […]
In finance terms, consolidation refers to the incorporation of the financial statements of all subsidiaries into the financial statements of the parent company. Consolidation of financial statements requires the parent company to integrate and combine all its financials to create a standard-form income statement, balance sheet, and cash flow statement, as part of a set […]
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 […]
What is technical analysis? Technical and Fundamental Analysis are the two most common ways of performing research on any trading vehicle (incl. stocks, commodities, currencies, ETFs). Traders use these tools to evaluate investments and spot trends, which indicate good opportunities for trading. Fundamental analysis tries to weigh all the information in a given market (such […]
In today’s dynamic and uncertain business environment, startups face numerous challenges. Effective financial planning and analysis (FP&A) processes are essential for startups. FP&A helps startups create a comprehensive financial plan, analyze financial data, identify potential risks and opportunities, and make informed decisions that align with their goals. Financial modeling is another crucial tool for startups. […]
Introduction Most significant new projects for a business require investments in Working Capital, and this harms a company’s cash flow. Proper cash management is essential if we want the company to continue to operate in the future. A business can be profitable, but if it can’t keep cash on hand, it won’t survive. Therefore it […]
The core underlying principle of IAS 36 Impairment of Assets is that an asset’s carrying value in the financial statements of the company should not exceed the highest amount the business can recover through its use or sale. The standard applies to all assets for which there are no impairment considerations elsewhere. As an example, […]
Since businesses have gone digital, not just with marketing but also through systems analysis, Business Intelligence (BI) automation has become the next buzzworthy word. But what exactly do we know about it? What are the risks and benefits of shifting towards this new movement in business tech? Let’s discuss these important points today and read […]
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 […]
