Crossover Rate Template This crossover rate template will demonstrate how to calculate the NPV of different projects and plot the NPV profiles to identify the crossover rate. This is what the crossover rate template looks like: Download the Free Template Crossover Rate is the rate of return (alternatively called the weighted average cost of capital)…
Markup Calculator This markup calculator shows you how to compute the markup amount and percentage given the selling price and cost of purchase. Here is a preview of the markup calculator: Download the Free Template The markup percentage is a concept commonly used in managerial/cost accounting work and is equal to the difference between the…
Adjusted Present Value Template This adjusted present value template guides you through the calculation of APV starting with the value of the unlevered project and PV of debt financing. Below is a preview of the adjusted present value template: Download the Free Template Adjusted Present Value (APV) is used for the valuation of projects and companies. It…
Expected Return Template This expected return template will demonstrate the calculation of expected return for a single investment and for a portfolio. Below is a screenshot of the expected return template: Download the Free Template The expected return of an investment is the expected value of the probability distribution of possible returns it can provide…
Present Value of Growth Opportunities Template This present value of growth opportunities template shows you how to calculate the PVGO given the market price of stock, required rate of return, and expected earnings. This is what the PVGO template looks like: Download the Free Template Present Value of Growth Opportunities (PVGO) is a concept that…
Comparable Company Analysis Template This comparable company analysis template demonstrates how to compute and compare the valuation ratios of industry competitors. Below is a screenshot of the comparable company analysis template: Download the Free Template Comparable company analysis (or “comps” for short) is a valuation methodology that looks at ratios of similar public companies and uses them…
Exchange Ratio Template This exchange ratio template shows you how to calculate an exchange ratio using the offer price for the target’s shares and the acquirer’s share price. Here is a screenshot of the exchange ratio template: Download the Free Template In mergers and acquisitions (M&A), the share exchange ratio measures the number of shares the acquiring…
Margin of Safety Template This margin of safety template will allow you to calculate the margin of safety given the profits and break-even point. Below is a preview of the margin of safety template: Download the Free Template The margin of safety is the difference between the amount of expected profitability and the break-even point….
Diluted EPS Formula Template This Diluted EPS Formula template shows you how to compute the diluted earnings per share using information from the income statement and an employee option schedule. This is what the diluted EPS formula template looks like: Download the Free Template The Diluted EPS formula is equal to Net Income less preferred dividends, divided by…
Quick Ratio Template This quick ratio template helps you calculate the quick ratio given the amount of cash, marketable securities, accounts receivable, and accounts payable. Below is a screenshot of the quick ratio template: Download the Free Template The Quick Ratio, also known as the Acid-test or liquidity ratio, measures the ability of a business…
