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.

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

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.

How to calculate your debt-to-income ratio Sure, you can use a debt-to-income ratio calculator to determine your number, but it’s relatively simple to calculate it for yourself.

How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

The times interest earned (TIE) ratio is a measure of a company's ability to meet its debt obligations based on its current ...

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

Debt-to-income ratio explained, plus how to calculate yours Your debt-to-income ratio is an important factor lenders look at when approving you for new credit.