Magnimetrics Library
Practical finance, Excel, valuation, and FP&A articles with downloadable working files where relevant.
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 […]
If you are already familiar with the outlined concepts, maybe you would be more interested in taking a look at the Excel model, which you can download below the article. Introduction Long-term (non-current) assets of the company have a long useful life (more than one year). When acquiring capital assets, we aim to use them […]
Introduction to the Dividend Discount Model The Dividend Discount Model (DDM) is used to estimate the price of a company’s stocks. The model is based on the theory that the present value of the stock is equal to the present value of all future dividend payments when discounted back to the present. If the present […]
Introduction The Perpetuity concept refers to the present value (PV) of equal periodic cash flows that investors will receive over an indefinite future period. We need to calculate the present value of perpetual cash flows for a variety of reasons, some being: In business and finance, perpetuity is a regular payout of the same amount […]
Introduction To understand the Time Value of Money, imagine you were offered 100 euros now or 100 euros in three years, what would you prefer? If you are like me, you’d probably prefer the money now. But why is that, when a 100 euros has the same value now and in the future? Having it […]
Introduction The Contribution Margin is a significant financial metric that is sometimes neglected by managers. While profit margin is one we usually hold very important, it gives information only on the amount with which revenues exceed costs. On the other hand, Contribution Margin provides us with a way to see how exactly each separate product […]
What is Materiality The materiality of a transaction amount or a financial statement line item is determined based on the impact of a misstatement of information on the intended users of that information. If the stakeholder is most likely to alter their actions if we presented the information correctly, the mistake is considered material. And, […]
Introduction to Internal Rate of Return Companies undertake various projects with the end goal to either increase earnings or cut down costs. These projects often require that the entities make significant investments. In capital budgeting, the management of the business wants to have an estimation of the returns on such investments. The Internal Rate of […]
Introduction to Sales Trend Analysis Sales Trend Analysis looks at historical revenue data to identify patterns, used extensively in budgeting and forecasting. It is a useful method to detect short-term changes in revenue growth and performance. Trends A Trend is an upwards or downwards shift in the development of a metric over time. It’s useful […]
Introduction to Decision Trees We use Decision Trees to clarify the expected value of capital investment opportunities. Decision Trees can also be helpful in business operations, where companies continuously struggle with big decisions on product development, operations management, human resources, and others. With Decision Tree analysis, we can better evaluate the alternative options. However, we […]
