Sensitivity Analysis Table Template This sensitivity analysis table template helps you predict sales revenue based on changes in input variables including traffic growth, unit price, and sales volume. Below is a screenshot of the sensitivity analysis table template: Download the Free Template Sensitivity Analysis is a tool used in financial modeling to analyze how the different values…
Enterprise Value vs. Equity Value Calculator This enterprise value vs. equity value calculator will allow you to compare the equity value of two companies with the same enterprise value but different capital structures. This is what the enterprise value vs. equity value calculator looks like: Download the Free Template Enterprise Value The enterprise value (which…
Leverage Ratios Template This leverage ratios template helps you calculate five commonly used leverage ratios. Below is a preview of the leverage ratios template: Download the Free Template A leverage ratio is any kind of financial ratio that indicates the level of debt incurred by a business entity against several other accounts in its balance sheet, income statement, or cash…
Market Value of Debt Template This market value of debt template shows you how to calculate the market value of debt given the FV of total debt, interest expense, cost of debt, and weighted average maturity. Below is a preview of the market value of debt template: Download the Free Template Download CFI’s Excel template…
Return on Investment Calculator Return on investment (ROI) is a financial ratio used to calculate the benefit an investor will receive in relation to their investment cost — most commonly measured as net income divided by the original cost of the investment. The higher the ratio, the greater the benefit earned. Investment Growth Calculator Templates…
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…
