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.

The dividend payout ratio can be calculated with two formulas, depending on the available information. One way to calculate it is to divide the total amount of dividends paid by the total net income.

Find help with a debt settlement company How to calculate your debt-to-income ratio To determine your debt-to-income ratio, divide your total monthly debt payments by your take-home pay.

How to Calculate Your DTI Ratio You can calculate your DTI ratio by adding up all of your monthly debt payments and then dividing the total by your gross monthly income.

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.

CNBC Select explains how to calculate home equity and what homeowners can do with it.