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 is the measure of dividends paid out to shareholders relative to the company's net income.

Microsoft Excel can calculate a bank's capital-to-risk weighted assets ratio if you know the tier 1 and tier 2 capital and risk-weighted assets.