Unlevered Cost of Capital Template This unlevered cost of capital template shows you how to compute the unlevered cost of capital given the risk-free rate, unlevered beta, and expected market return. Below is a screenshot of the unlevered cost of capital template: Download the Free Template Enter your name and email in the form below…
Fixed Asset Turnover Template This fixed asset turnover template teaches you how to calculate the fixed asset turnover ratio using the formula: Fixed Asset Turnover = Net Sales / Average Fixed Assets. Here is a preview of the fixed asset turnover template: Download the Free Template Enter your name and email in the form below…
Cost of Goods Sold (COGS) Template This cost of goods sold template demonstrates three methods of COGS accounting: FIFO, LIFO, and weighted average. Below is a screenshot of the COGS template: Download the Free Excel Template Enter your name and email in the form below and download the free template now! Cost of Goods Sold…
Weighted Average Shares Outstanding Template This weighted average shares outstanding template shows you how to calculate the weighted average shares outstanding using quarterly data. Below is a preview of the weighted average shares outstanding template: Download the Free Template Enter your name and email in the form below and download the free template now! Weighted…
Return on Equity Template This return on equity template helps you calculate the ROE using the formula: ROE = Net Income / Shareholder’s Equity This is what the return on equity template looks like: Download the Free Template Enter your name and email in the form below and download the free template now! Return on Equity…
Straight-Line Depreciation Template This straight-line depreciation template demonstrates how to calculate depreciation expense using the straight-line depreciation method. Below is a screenshot of the straight-line depreciation template: Download the Free Template Enter your name and email in the form below and download the free template now! With the straight-line depreciation method, the value of an…
Operating Income Template This operating income template shows you how to calculate operating income using line items from the income statement. This is what the operating income template looks like: Download the Free Template Enter your name and email in the form below and download the free template now! Operating income, also referred to as…
Target Costing Template This target costing template shows you how to find the target cost given the selling price and profit margin. Below is a screenshot of the target costing template: Download the Free Template Enter your name and email in the form below and download the free template now! Target costing is a management…
Sharpe Ratio Calculator Template This Sharpe ratio calculator template demonstrates the calculation of the Sharpe ratio (using the arithmetic mean) to determine an investment’s performance relative to risk. Below is a preview of the Sharpe ratio calculator template: Download the Free Template Enter your name and email in the form below and download the free…
Treasury Stock Method Calculator This treasury stock method calculator helps you find the additional shares outstanding using the formula: Additional Shares Outstanding = Additional Shares (1 – Strike Price / Average Price) Here is a screenshot of the treasury stock method calculator: Download the Free Template Enter your name and email in the form below…
