Magnimetrics Library
FP&A, valuation, Excel, and financial modeling articles with practical downloadable resources.
As we discussed in our last article, debt covenants are provisions within financial agreements such as loans or credit lines between lenders and borrowers that restrict certain activities like dividends and asset sales to protect lenders’ interests and maintain their risk exposure at acceptable levels. If you are not familiar with debt covenants, I suggest […]
Excel modeling has become an essential tool for financial analysis, forecasting, and decision-making in today’s data-driven business landscape. However, manually performing complex calculations, formatting data, and managing large datasets can be time-consuming and error-prone. This is where the power of macros and add-ins comes into play. This article will discuss the importance of using macros […]
We all know happy customers come back to do more business with our company. They also provide priceless word-of-mouth marketing by sharing their experience with others. Clients who rate our products and services as highly satisfactory are usually the ones that promote us to their colleagues, friends, and family. This improves both our conversion rates […]
Introduction The Capital Asset Pricing Model (CAPM) shows us the relationship between systematic risk for an investment and the expected return on it. Analysts and financial professionals use the model widely for pricing risky investments and generating expected returns for assets, considering the risk and cost of capital. The CAPM goal is to see if […]
Understanding the Gordon Growth Model for Stock Valuation The Gordon Growth Model (GGM) is a method for the valuation of stocks. Investors use it to determine the relationship between value and return. The model uses the Net Present Value (NPV) of future dividends to calculate assets’ intrinsic value. It’s the most popular variation of the […]
The term value-added represents the enhanced value a company adds to its products and services. You probably notice that products sell for more than it costs to produce them, and services charge more than it costs to render them. This is what value-added represents. The essential purpose of any business is to create value that […]
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 […]
Most companies in the manufacturing and retail industries have Inventory. Slow-moving and obsolete Inventory can have a severe adverse effect on the profitability of the business. When we can’t realize our goods on hand, they lose value and may become useless for the company. To account for this decrease in value, we write down or […]
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 […]
A Debt Amortization Schedule outlines how a company will be settling its debt and interest over time. Businesses often rely on debt capital (loans) to support their growth strategy and expansions. In general, there are two types of loans you would generally see on a company’s balance sheet: Working capital loans would sit in the […]
