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 Cost of Goods Sold (COGS) measures the “direct cost” incurred in the production of any goods or services. It…
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 Weighted average shares outstanding refers to the number of shares of a company calculated after adjusting…
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 Return on Equity (ROE) is a measure of a company’s annual return (net income) divided by the value…
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 With the straight-line depreciation method, the value of an asset is reduced uniformly over each period until it reaches its salvage value. Straight-line depreciation is…
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 Operating income, also referred to as Earnings Before Interest & Taxes (EBIT), is the amount of revenue left after deducting the…
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 Target costing is a management technique where prices are determined by market conditions brought about by several factors – such…
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 The Sharpe ratio is commonly used as a means of calculating the performance…
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 The treasury stock method is a way for companies…
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 Unlevered Free Cash Flow (also known as Free Cash Flow to the Firm…
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 Salvage value is the estimated amount that an asset is worth at the end of its useful life. It is also known as scrap value or residual value…
