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.

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.

Learn how to convert ratios to fractions and percentages, how to share in a given ratio, and explore ratios as fractions, with videos, activities and quizzes.

The dividend payout ratio can be a helpful metric for comparing dividend stocks. This ratio represents the amount of net income that a company pays out to shareholders in the form of dividends ...

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.