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

You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.

Learn more about the loan-to-value (LTV) ratio, what the ratio measures, and how to calculate the loan-to-value ratio using Microsoft Excel.

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.

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.