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…
Working Capital Cycle Template This working capital cycle template shows you how to calculate the working capital cycle given the inventory days, receivable days, and payable days. This is what the working capital cycle template looks like: Download the Free Template The Working Capital Cycle for a business is the length of time it takes…
Burn Rate Template This burn rate template demonstrates how to calculate the gross and net burn rate of cash of a company that is earning negative profit. Below is a screenshot of the burn rate template: Download the Template Download CFI’s free Excel template now to advance your finance knowledge and perform better financial analysis….
Liquidation Value Template This liquidation value template helps you compute the liquidation value given a company’s total liabilities and assets in auction value. This is what the liquidation value template looks like: Download the Free Template Liquidation value is an estimation of the final value, which will be received by the holder of financial instruments…
Days Sales in Inventory Template This days sales in inventory template will show you how to find the average number of days or time required for a business to convert its inventory into sales. Below is a screenshot of the days sales in inventory template: Download the Free Template Days Sales in Inventory (DSI), sometimes known…
Contribution Margin Ratio Template The contribution margin ratio template below shows you how to calculate the contribution margin, CM percentage, and break-even point. Here is a screenshot of the contribution margin ratio: Download the Free Template The contribution margin ratio (CM ratio) of a business is equal to its revenue less all variable costs divided by its revenue. It…
Price/Earnings to Growth Ratio Template This price/earnings to growth ratio template shows you the calculation of the PEG ratio given the share price, EPS, and EPS growth rate. Below is a screenshot of the PEG ratio template: Download the Free Template The PEG ratio is a company’s Price/Earnings ratio divided by its earnings growth rate…
Proforma Earnings Per Share Template This proforma earnings per share template shows you how to calculate the earnings per share assuming a merger and acquisition takes place. Here is a preview of the proforma EPS template: Download the Free Template Proforma earnings per share (EPS) is the calculation of EPS assuming a merger and acquisition (M&A) takes place and…
