Activity-Based Costing Calculator Template This activity-based costing calculator template is a great tool to break-down overhead costs through activity-based costing. Activity-based costing allocates overhead costs based on the different ‘activities’ that compose the production of goods or services and measures them independently. Here is what the template looks like: Download the Free Template More Free…
Accumulated Depreciation Calculator This Accumulated Depreciation Calculator will help you compute the period accumulated depreciation, given the purchase price, useful life, and salvage value of the equipment. This template is designed for the straight-line depreciation method. Here is what the Accumulated Depreciation Calculator looks like: Download the Free Template More Free Templates For more resources,…
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…
