Liquidity coverage ratio (LCR) is a requirement under Basel III accords whereby banks must hold sufficient high-quality liquid assets to cover cash outflows for 30 days.

Learn more about the loan-to-value (LTV) ratio, what the ratio measures, and how to calculate the loan-to-value ratio using Microsoft Excel.

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.

How to Calculate the DSCR in Excel Before calculating the ratio, in Excel, we must first create the column and row heading names.

Liquidity corresponds with a company's ability to immediately fulfill short-term obligations. Ratios like the acid test and current ratio help determine a firm's liquidity.