Calculate collateral coverage ratio, loan amount, or collateral value in dollars by entering any two of the three inputs, with formulas shown.
Customize This Calculator
Build your own version. Describe what you want changed, added, or compared.
Related Calculators
- Benefit to Cost Ratio Calculator
- Equity Percentage Calculator
- Required Rate of Return Calculator
- Cost Of Common Equity Calculator
- All Business Calculators
Collateral Coverage Ratio Formula
The collateral coverage ratio compares the value of pledged collateral to the loan amount. A ratio above 1.00 means the collateral value is greater than the loan amount. A ratio below 1.00 means the collateral value is less than the loan amount.
- CCR = collateral coverage ratio
- VC = value of collateral
- LA = loan amount
The calculator can also rearrange the formula to solve for the missing value.
- To calculate collateral coverage ratio: enter the value of collateral and the loan amount.
- To calculate value of collateral: enter the collateral coverage ratio and the loan amount.
- To calculate loan amount: enter the value of collateral and the collateral coverage ratio.
Collateral Coverage Ratio Benchmarks
Coverage requirements vary by lender, asset type, borrower strength, and loan structure. The table below gives a general way to read the result.
| Collateral Coverage Ratio | Collateral Compared With Loan | General Interpretation |
|---|---|---|
| Below 1.00 | Collateral is less than the loan | The loan is undercollateralized based on the entered value. |
| 1.00 | Collateral equals the loan | The loan is exactly covered before fees, discounts, or liquidation costs. |
| 1.20 | Collateral is 120% of the loan | There is a 20% collateral cushion. |
| 1.50 | Collateral is 150% of the loan | There is a larger collateral cushion. |
Common Ratio Conversions
You can convert the ratio to a percentage by multiplying it by 100. For example, a ratio of 1.25 is 125% collateral coverage.
| Ratio | Coverage Percentage | Meaning |
|---|---|---|
| 0.80 | 80% | $0.80 of collateral for each $1.00 of loan. |
| 1.00 | 100% | $1.00 of collateral for each $1.00 of loan. |
| 1.25 | 125% | $1.25 of collateral for each $1.00 of loan. |
| 1.50 | 150% | $1.50 of collateral for each $1.00 of loan. |
Example Section
Example 1: Calculate the collateral coverage ratio
You have collateral valued at $300,000 and a loan amount of $240,000.
The collateral coverage ratio is 1.25, meaning the collateral value is 125% of the loan amount.
Example 2: Calculate the required collateral value
You need a collateral coverage ratio of 1.30 for a $500,000 loan.
The required collateral value is $650,000.
FAQ Section
What is a good collateral coverage ratio?
A higher ratio generally gives more protection to the lender because the collateral value is greater than the loan amount. A ratio of 1.00 means the collateral equals the loan. Many secured loans require a ratio above 1.00, but the acceptable level depends on the lender, collateral type, credit profile, and how easily the collateral could be sold.
Is collateral coverage ratio the same as loan-to-value?
No. They use the same two inputs but in opposite order. Collateral coverage ratio is collateral value divided by loan amount. Loan-to-value is loan amount divided by collateral value. For example, a $75,000 loan secured by $100,000 of collateral has a collateral coverage ratio of 1.3333 and a loan-to-value ratio of 75%.
Should you use appraised value or market value for collateral?
Use the value required for the analysis you are doing. A lender may use appraised value, discounted value, liquidation value, or another adjusted figure. If you use a higher market value, the ratio will be higher. If you use a conservative or discounted value, the ratio will be lower.