Archives: Resources

Capital Gains Yield Calculator

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 Capital gains yield (CGY) is the price appreciation on an investment or a security expressed as…

Continue reading

Days Sales Outstanding 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 Days Sales Outstanding (DSO) represents the average number of days it takes credit sales to be converted…

Continue reading

Equity Risk Premium Template

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 Equity Risk Premium is the difference between returns on equity/individual stock…

Continue reading

Free Cash Flow Template

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…

Continue reading

Net Income Template

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 Net income is the amount of accounting profit a company has left over after paying off all its expenses. Net income…

Continue reading

Payback Period Template

Payback Period Template This payback period template will help you visualize and determine the period of time a company takes to recoup its investment. Here is a preview of the payback period template: Download the Free Payback Period Template The Payback Period shows how long it takes for a business to recoup its investment. This…

Continue reading

Geometric Mean Template

Geometric Mean Template This geometric mean template helps you compare investment options by calculating the final value of investments using geometric mean. Below is a preview of the geometric mean template: Download the Free Template The geometric mean is the average growth of an investment computed by multiplying n variables and then taking the n square root.  In…

Continue reading

Economic Order Quantity Template

Economic Order Quantity Template This economic order quantity template helps you identify the optimal order quantity that minimizes the cost of ordering and holding inventory. This is what the economic order quantity template looks like: Download the Free Template Download CFI’s free Excel template now to advance your finance knowledge and perform better financial analysis….

Continue reading

NOPAT Template

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…

Continue reading

Forward P/E Ratio Template

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…

Continue reading
0 search results for ‘