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…
Revenue Run Rate Template This revenue run rate template shows you how to calculate the annualized revenue. Below is a screenshot of the revenue run rate template: Download the Free Template Revenue Run Rate is an indicator of financial performance that takes a company’s current revenue in a certain period (a week, month, quarter, etc.)…
Market Capitalization Template This market capitalization template helps you differentiate between market capitalization and enterprise value. This is what the market capitalization template looks like: Download the Free Template Market Capitalization (Market Cap) is the most recent market value of a company’s outstanding shares. The Market Cap is equal to the current share price multiplied by the number…
