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.

The acid-test ratio, also known as the quick ratio, measures the liquidity of a company. Learn how to calculate acid-test ratio here.

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.

Liquidity Ratios Liquidity can be calculated using three standard ratios that show how much in assets a company has available to pay its scheduled bills.

This ratio is calculated by dividing a bank's high-quality liquid assets, or HQLA, into its total net cash over a 30-day period.

The higher the ratio is above 100%, the stronger the bank's liquidity position. Related investing topics For bank management, the process is much more complex. Thankfully, it's easy for investors.