Archives: Resources

Marginal Revenue Calculator

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…

Continue reading

LTV CAC Ratio Template

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…

Continue reading

Profitability Index Template

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…

Continue reading

Accounts Payable Template

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,…

Continue reading

Coupon Rate Template

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:…

Continue reading

Cash EPS Calculator

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…

Continue reading

Return on Investment Excel Calculator

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…

Continue reading

ROIC Excel Template

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…

Continue reading

Value Added Excel Template

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…

Continue reading

Accounting Test

Accounting Test This Accounting Test is designed to help you assess your knowledge of essential accounting principles and basic concepts. We strongly encourage any students who are planning or are beginning their FMVA certification program to take this test to determine whether you will need to take the prerequisite accounting courses, including Accounting Fundamentals and…

Continue reading
0 search results for ‘