Leveraged Finance Template This leveraged finance template shows the calculation of the internal rate of return of an investment with different levels of leverage. This is what the leveraged finance template looks like: Download the Free Template Enter your name and email in the form below and download the free template now! Leveraged finance is the…
Earnings Before Tax Template This earnings before tax template shows you how to calculate the earnings before tax using line items in the income statement. Below is a screenshot of the EBT template: Download the Free Template Enter your name and email in the form below and download the free template now! Earnings before tax…
Net Identifiable Assets Template This net identifiable assets template will show you how to calculate the net identifiable assets given the value of assets and liabilities of an acquired company. This is what the net identifiable assets template looks like: Download the Free Template Enter your name and email in the form below and download…
Funds From Operations Template This funds from operations template allows you to calculate the FFO using the formula: FFO = Net Income + (Depreciation Expense + Amortization Expense + Losses on Sale of Assets) – (Gains on Sale of Assets + Interest Income) Here is a screenshot of the FFO template: Download the Free Template…
Contribution Analysis Template This contribution analysis template helps you calculate the total and per-unit contribution margin. Below is a preview of the contribution analysis template: Download the Free Template Enter your name and email in the form below and download the free template now! Contribution analysis is used in estimating how direct and variable costs…
Capital Gains Yield Calculator This capital gains yield calculator demonstrates how to calculate the capital gains yield using the purchase price and current price of a stock. Below is a screenshot of the capital gains yield calculator: Download the Free Template Enter your name and email in the form below and download the free template…
Days Sales Outstanding Template This days sales outstanding template demonstrates the calculation of the number of days it takes to collect all accounts receivables. This is what the days sales outstanding template looks like: Download the Free Template Enter your name and email in the form below and download the free template now! Days Sales…
Equity Risk Premium Template This equity risk premium template shows you how to calculate equity risk premium given the risk-free rate, beta of stock, and expected return on the market. Here is a screenshot of the equity risk premium template: Download the Free Template Enter your name and email in the form below and download…
Free Cash Flow Template This free cash flow template shows you how to calculate free cash flow using a cash flow statement. Here is a preview of the free cash flow template: Download the Free Cash Flow (FCF) Template Download CFI’s free Excel template now to advance your finance knowledge. Free cash flow (FCF) measures…
Net Income Template This net income template shows you the calculation of net income using line items from an income statement. Below is a screenshot of the net income template: Download the Free Template Enter your name and email in the form below and download the free template now! Net income is the amount of…
