Gross Margin Ratio Calculator This Gross Margin Ratio Calculator template will compute the gross profit margin given the Revenue and the Cost of Goods Sold. The ratio indicates the percentage of revenue that the company retains as gross profit. Here is a snippet of the template: Download the Free Template Gross Margin Ratio Formula The formula for…
Marginal Revenue Calculator This Marginal Revenue Calculator will aid you in calculating the marginal revenue when given the units of production for two consecutive periods. Here is a snippet of the Marginal Revenue Calculator: Download the Free Template Calculator Marginal Revenue Formula Marginal revenue is easy to calculate. All you need to remember is that marginal revenue is…
LTV/CAC Ratio Template This LTV/CAC Ratio Template will help calculate both the LTV and CAC of a company’s user base. These will then be used to obtain the LTV/CAC ratio. LTV stands for “LifeTime Value” per customer and CAC stands for “Customer Acquisition Cost.” The LTV/CAC ratio is a good metric to see how much…
Profitability Index Template This Profitability Index (PI) template will help visualize the present value of future cash flows, which will then be used to calculate the PI of the project. The PI measures the ratio between the present value of future cash flows to the initial investment. Other names for profitability ratio are Profit Investment…
Accounts Payable Template This Accounts Payable Template highlights where this balance sheet element is located on the statement of financial position. It also has some ratio analysis on accounts payable. Fundamental Ratios are very valuable for fundamental analysis. Here is a snippet of the template: Download the Free Template More Free Templates For more resources,…
Coupon Rate Template This coupon rate template will calculate a bond’s coupon rate based on the total annual coupon payments and the face value of the bond. As is customary with CFI templates the blue values are hardcoded numbers and black numbers are calculations dependent on other cells. Here is a snippet of the template:…
Cash EPS Calculator This Cash EPS calculator will help you to calculate the number of shares outstanding, the cash from operations, and from these elements, obtain the cash earnings per share. Looking at the cash EPS of a company and comparing it to its regular EPS can provide great insight when performing fundamental analysis. Here…
Return on Investment Excel Calculator This Return on Investment Excel Calculator will aid you in calculating the return on investment for different scenarios. Return on investment is one of the most important profitability ratios to assess a company’s performance. Here is a snippet of the template: Download the Free Template CFI is a global provider…
ROIC Excel Template This ROIC Excel Template will aid you in calculating the NOPAT and Book Value of Invested Capital, and from these elements calculate the period ROIC. Here is a snippet of the template: Download the Free Template Download CFI’s Excel template to advance your finance knowledge and perform better financial analysis. The ROIC…
Value Added Excel Template This Value Added Excel Template is a free tool provided by the Corporate Finance Institute. It will help you understand the important concept of Value added for Finance and Accounting. Here is a snippet of the template: Download the Free Template and take a look at an applied example of a…
