Q Ratio
What is the Q Ratio? The Q Ratio, or Tobin’s Q Ratio, is a ratio between a physical asset’s market value and its replacement value. The ratio was developed by James Tobin, a Nobel laureate in economics. Tobin suggested a hypothesis that the combined market value of all companies on the stock market should be...
Enterprise Value (EV) to Revenue Multiple Calculator
Enterprise Value (EV) to Revenue Multiple Calculator This Enterprise Value (EV) to Revenue Multiple Calculator will aid in determining the enterprise value based on both the equity value and debt value, from the EV it will then calculate the EV to Revenue multiple. Here is what the template looks like: Download the Free Template The...
Alpha Calculator
Alpha Calculator This Alpha Calculator will compute the value of alpha based on the Capital Asset Pricing Model. This CAPM-based approach will take the portfolio return, risk-free rate, beta, and market return, and calculate alpha from these elements: Here is a snippet of the alpha calculator template: Download the Free Template Capital Assets Pricing Model...
Coupon Rate Template
Coupon Rate Template This coupon rate template will calculate a bond’s coupon rate based on the total annual coupon payments and the face value of the bond. As is customary with CFI templates the blue values are hardcoded numbers and black numbers are calculations dependent on other cells. Here is a snippet of the template:...
Cash EPS Calculator
Cash EPS Calculator This Cash EPS calculator will help you to calculate the number of shares outstanding, the cash from operations, and from these elements, obtain the cash earnings per share. Looking at the cash EPS of a company and comparing it to its regular EPS can provide great insight when performing fundamental analysis. Here...
