Archives: Resources

Margin of Safety Template

Margin of Safety Template This margin of safety template will allow you to calculate the margin of safety given the profits and break-even point. Below is a preview of the margin of safety template: Download the Free Template Enter your name and email in the form below and download the free template now! The margin…

Continue reading

Diluted EPS Formula Template

Diluted EPS Formula Template This Diluted EPS Formula template shows you how to compute the diluted earnings per share using information from the income statement and an employee option schedule. This is what the diluted EPS formula template looks like: Download the Free Template Enter your name and email in the form below and download…

Continue reading

Quick Ratio Template

Quick Ratio Template This quick ratio template helps you calculate the quick ratio given the amount of cash, marketable securities, accounts receivable, and accounts payable. Below is a screenshot of the quick ratio template: Download the Free Template Enter your name and email in the form below and download the free template now! The Quick…

Continue reading

Debt Equity Ratio Template

Debt-Equity Ratio Template This debt-equity ratio template shows you how to calculate D/E ratio given the amounts of short-term and long-term debt and shareholder’s equity. This is what the debt-equity ratio template looks like: Download the Free Template Enter your name and email in the form below and download the free template now! The Debt-to-Equity…

Continue reading

XIRR vs IRR Template

XIRR vs. IRR Template This XIRR vs. IRR template allows you to differentiate between the use of IRR and XIRR functions to compute the internal rate of return. Below is a screenshot of the XIRR vs. IRR template: Download the Free Template Download CFI’s free Excel template now to advance your finance knowledge and perform…

Continue reading

EBIT vs EBITDA Template

EBIT vs. EBITDA Template This EBIT vs. EBITDA template will help you distinguish between EBIT and EBITDA calculations. This is what the EBIT vs. EBITDA template looks like: Download the Free Template Enter your name and email in the form below and download the free template now! EBIT stands for: Earnings Before Interest and Taxes. EBITDA stands for: Earnings Before Interest, Taxes, Depreciation, and Amortization. The difference…

Continue reading

Perpetuity Calculator

Perpetuity Calculator This perpetuity calculator shows you how to compute the present value of perpetuity and perpetuity with growth. Below is a screenshot of the perpetuity calculator: Download the Free Template Enter your name and email in the form below and download the free template now! Perpetuity in the financial system is a situation where…

Continue reading

Market Risk Premium Template

Market Risk Premium Template This market risk premium template will show you how to compute the market risk premium using the expected rate of return and the risk-free rate. Below is a preview of the market risk premium template: Download the Free Template Enter your name and email in the form below and download the…

Continue reading

Economic Value Added Template

Economic Value Added Template This economic value added template guides you to compute EVA using the amount of capital invested, WACC, and NOPAT. Below is a screenshot of the economic value added template: Download the Free Template Enter your name and email in the form below and download the free template now! Economic Value Added…

Continue reading

EBITDA Margin Template

EBITDA Margin Template This EBITDA margin template shows you how to calculate EBITDA margin using revenue amounts and EBITDA. Here is a preview of the EBITDA margin template: Download the Free Template Enter your name and email in the form below and download the free template now! EBITDA margin is a profitability ratio that measures…

Continue reading
0 search results for ‘