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 ...

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

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.

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

How to Calculate How Much You Can Borrow Using Excel. How much you can borrow is often determined by the bank based on internal qualifiers, such as credit score, debt-to-income ratio, interest ...

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.

To calculate the turnover ratio, you need to know several numbers. First, you need to determine the total number of securities the mutual fund purchased during the period in question.

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.