Debt to Asset Ratio Template This debt to asset ratio template will show you how to calculate the Debt/Asset ratio given the number of assets, short-term debt, and long-term debt. Here is a preview of the debt to asset ratio template: Download the Free Template The Debt to Asset Ratio, also known as the debt…
Marginal Cost of Production Template This marginal cost of production template will show you how to calculate different types of marginal costs. This is what the marginal cost of production template looks like: Download the Free Template The Marginal Cost of production is the cost to provide one additional unit of a product or service….
Net Present Value Template This net present value template helps you calculate net present value given the discount rate and undiscounted cash flows. Here is a screenshot of the net present value template: Download the Free Template Net Present Value (NPV) is the value of all future cash flows (positive and negative) over the entire life of an…
Depreciation Methods Template This depreciation methods template will show you the calculation of depreciation expenses using four types of commonly used depreciation methods. Below is a preview of the depreciation methods template: Download the Free Excel Template There are several types of depreciation expenses and different formulas for determining the book value of an asset. The most…
Dilution Template This dilution template helps you identify the impact of dilutive securities on the share price. Here is a preview of the dilution template: Download the Free Template Dilution can be caused due to a number of dilutive securities such as stock options, restricted and performance stock units, preferred stock, warrants, and convertible debt. Dilution may cause…
Intrinsic Value Template This intrinsic value template will demonstrate the calculation of intrinsic value using the discount rate method and the certainty factor method. Below is a screenshot of the intrinsic value template: Download the Free Template Download CFI’s free Excel template now to advance your finance knowledge and perform better financial analysis. The intrinsic…
Net Debt Calculator The following net debt calculator helps you compute the net debt using the formula: Net Debt = Short-Term Debt + Long-Term Debt – Cash and Equivalents Below is a screenshot of the net debt calculator: Download the Free Template Net debt is a financial liquidity metric that measures a company’s ability to pay…
Sales Tax Decalculator Template This sales tax decalculator template will help you calculate the pre-tax price of a good or service when the total price and tax rate are known. This is what the sales tax decalculator looks like: Download CFI’s Free Sales Tax Decalculator Template Click the button below to download our free Sales…
CVP Analysis Template This CVP analysis template helps you perform a break-even analysis, calculate the margin of safety and find the degree of operating leverage. Here is a screenshot of the CVP analysis template: Download the Free CVP Analysis Template Cost Volume Profit (CVP analysis), also commonly referred to as Break Even Analysis, is a…
Adjusted EBITDA Template This adjusted EBITDA template will guide you through the calculation of adjusted EBITDA by removing any one-time items from EBITDA. This is a preview of the adjusted EBITDA template: Download the Free Template Adjusted EBITDA is a financial metric that includes the removal of various one-time, irregular, and non-recurring items from EBITDA (Earnings…
