Unlevered FCF Template This unlevered FCF template will show you how to compute the unlevered free cash flows with EBIT, tax, depreciation & amortization, change in NWC, and CapEx. Below is a preview of the unlevered FCF template: Download the Free Template Enter your name and email in the form below and download the free…
Salvage Value Template This salvage value template shows the calculation of the salvage value of equipment. Here is what the salvage value template looks like: Download the Free Template Enter your name and email in the form below and download the free template now! Salvage value is the estimated amount that an asset is worth at the…
Cost of Preferred Stock Calculator This cost of preferred stock calculator shows you how to calculate the cost of preferred stock given the dividend, stock price, and growth rate. Below is a screenshot of the cost of preferred stock calculator: Download the Free Template Enter your name and email in the form below and download…
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 Enter your name and email in the form below and download the free template now!…
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 Enter your name and email in the form below and download the free template now! The markup percentage is a…
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 Enter your name and email in the form below and download the…
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 Enter your name and email in the form below and download the free template now! The expected return of an…
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 Enter your name and email in the form below and…
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 Enter your name and email in the form below and download the free template now! Comparable company analysis (or “comps”…
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 Enter your name and email in the form below and download the free template…
