Discount Factor Template This discount factor template helps you calculate the amount of discounted cash flows using explicit discount factors. Here is what the discount factor template looks like: Download the Free Template A discount factor is a decimal number multiplied by a cash flow value to discount it back to the present value. The discount factor…
Market to Book (Price to Book) Ratio Template This market to book (price to book) ratio template allows you to calculate the Market/Book ratio using the market capitalization and the net book value. Here is a preview of the market to book ratio template: Download the Free Template The Market to Book ratio (or Price…
Equity Beta Asset Beta Conversion Template The following equity beta asset beta conversion template allows you to convert between equity beta and asset beta. Below is a preview of the equity beta asset beta converter: Download the Free Template Unlevered beta (or asset beta) is the beta of a company without the impact of debt….
CAPM Formula Template This CAPM formula template will help you calculate the required rate of return for investing in a security given the risk-free return and risk premium. This is what the CAPM template looks like: Download the Free Template Download CFI’s free Excel template now to advance your finance knowledge. The Capital Asset Pricing…
Cost of Goods Manufactured Template This cost of goods manufactured (COGS) template lays out a schedule of COGM using the amount of direct materials, direct labor, manufacturing overhead, and work in process inventory. Here is a preview of the COGM template: Download the Free Template Cost of Goods Manufactured (COGM) is a term used in…
Marginal Cost Calculator This marginal cost calculator allows you to calculate the additional cost of producing more units using the formula: Marginal Cost = Change in Costs / Change in Quantity Here is a preview of the marginal cost calculator: Download the Free Template Marginal cost represents the incremental costs incurred when producing additional units…
CapEx Formula Template This CapEx formula template helps you calculate the amount of capital expenditures using numbers in the income statement and balance sheet. Below is a screenshot of the CapEx formula template: Download the Free Template CapEx (short for Capital Expenditures) is the money invested by a company in acquiring, maintaining, or improving fixed…
Cohort Analysis Template This cohort analysis template is a useful tool for customer behavior analysis using a large data set. Below is a screenshot of the cohort analysis template: What is Cohort Analysis? Cohort Analysis is a form of behavioral analytics that takes data from a given subset like a SaaS business, game, or e-commerce platform,…
Capitalization Table Template This capitalization table (cap table) template is a helpful tool for a startup company or early-stage venture to list all the company’s securities. Here is a preview of the capitalization table template: Download the Free Capitalization Table Template A capitalization table is a spreadsheet for a startup company or early-stage venture that lists…
Consolidation Model Template This consolidation model template helps you summarize the financial performance of multiple business units into a consolidated model. Below is a screenshot of the consolidation model template: Download the Consolidation Model Template A Consolidation Model is constructed by combining the financial results of multiple business units into one single model. Typically, the first worksheet…
