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:...
Return on Investment Excel Calculator
Return on Investment Excel Calculator This Return on Investment Excel Calculator will aid you in calculating the return on investment for different scenarios. Return on investment is one of the most important profitability ratios to assess a company’s performance. Here is a snippet of the template: Download the Free Template CFI is a global provider...
