NOPAT Template The following NOPAT template shows you how to calculate the net operating profit after tax using the income statement. Below is a preview of the NOPAT template: Download the Free NOPAT Template NOPAT stands for Net Operating Profit After Tax and represents a company’s theoretical income from operations if it had no debt (no interest expense). NOPAT is…
Forward P/E Ratio Template This forward P/E ratio template helps you find out the forward P/E ratio given the share price and earnings per share of stocks. This is what the forward P/E ratio template looks like: Download the Free Template The forward P/E ratio (or forward price-to-earnings ratio) divides the current share price of…
Variance Analysis Template This variance analysis template guides you through the process of variance analysis using the column method. Below is a screenshot of the variance analysis template: Download the Free Excel Template Variance analysis can be summarized as an analysis of the difference between planned and actual numbers. The sum of all variances gives…
Variance Formula Template This variance formula template helps you find out the variance between actual and forecast financial figures. This is what the variance formula template looks like: Download the Free Template The variance formula is used to calculate the difference between a forecast and the actual result. The variance can be expressed as a…
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 The unlevered cost of capital is the implied rate…
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 Fixed Asset Turnover (FAT) is an efficiency ratio that…
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…
