Reviewed by David Kindness The debt service coverage ratio (DSCR) is used in corporate finance to measure the amount of a ...

First, we will calculate the GCD, then we will use this GCD value to calculate the ratio. Select the cell in which you want to display the GCD. In our case, it is the cell C2.

Learn how to use Microsoft Excel to calculate the Sharpe ratio, an investing tool used to assess the relationship between risk and return for an asset.

To calculate your LTV ratio using Microsoft Excel for the example above, first right click on columns A, B, and C, select Column Width and change the value to 30 for each of the columns.

How to calculate BMI ratio in Excel BMI is a better index for judging the health of an individual. The syntax for calculating BMI ratio in Excel is as follows: =first cell with the value of weight ...

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.