Earnings Per Share Template This earnings per share template helps you calculate basic and diluted EPS given information on common and preferred shares. Below is a preview of the earnings per share template: Download the Free Template Enter your name and email in the form below and download the free template now! Earnings per share…
EV/EBITDA Template This EV/EBITDA template guides you through the calculation of EV/EBITDA using figures from an Income Statement. Below is a preview of the EV/EBITDA template: Download the Free Template Download CFI’s Excel template to advance your finance knowledge and perform better financial analysis. EV/EBITDA is a ratio that looks at a company’s Enterprise Value (EV) and…
What is Return on Assets (ROA)? Return on Assets (ROA) is a financial ratio that measures a company’s profitability relative to its total assets. It shows how effectively a business is using its assets to generate net income over a specific time period. ROA is a valuable tool for comparing performance across companies or tracking…
Accounting Rate of Return Template This accounting rate of return template will demonstrate two examples of ARR calculations. Below is a screenshot of the accounting rate of return template: Download the Free Template Enter your name and email in the form below and download the free template now! Accounting Rate of Return (ARR) is the…
Net Working Capital Template This net working capital template allows you to compute the net working capital using the formula: Net Working Capital = Current Assets (less cash) – Current Liabilities (less debt) Below is a preview of the net working capital template: Download the Free Net Working Capital Template Enter your name and email in…
Tax Shield Example Template This tax shield example template shows how interest tax shield and depreciated tax shield are calculated. Here is what the tax shield example template looks like: Download the Free Template Enter your name and email in the form below and download the free template now! A Tax Shield is an allowable…
Effective Annual Rate Calculator The following effective annual rate calculator will help you compute the effective annual rate given the nominal interest rate and the number of compounding periods. Below is a screenshot of the effective annual rate calculator: Download the Free Template Enter your name and email in the form below and download the…
Effective Annual Interest Rate Calculator This effective annual interest rate calculator helps you calculate the EAR given the nominal interest rate and number of compounding periods. Below is a screenshot of the effective annual interest rate calculator: Download the Free Template Enter your name and email in the form below and download the free template…
Cash Flow Reconciliation Template This cash flow reconciliation template will help you differentiate between EBITDA, CF, FCF, and FCFF. Below is a preview of the cash flow reconciliation template: Download the Free Template Enter your name and email in the form below and download the free template now! EBITDA vs. Cash Flow vs. Free Cash…
WACC Calculator This WACC calculator helps you calculate WACC based on capital structure, cost of equity, cost of debt, and tax rate. Here is a preview of the WACC calculator: Weighted Average Cost of Capital (WACC) represents a company’s blended cost of capital across all sources, including common shares, preferred shares, and debt. The cost of…
