Calculation guide
ratio = 100*loans*(1+lg/100)/(deposits*(1+dg/100))
Inputs
Opening loans
Example entry 800000.0 (in the selected currency).
Opening deposits
Example entry 1000000.0 (in the selected currency). Minimum 1e-12.
Loan growth (%)
Example entry 10.0.
Deposit growth (%)
Example entry 0.0.
Worked example
| Input | Value |
|---|---|
| Opening loans | 800,000 |
| Opening deposits | 1,000,000 |
| Loan growth (%) | 10 |
| Deposit growth (%) | 0 |
| Result | Value |
|---|---|
| Closing loan-to-deposit ratio (%) | 88% |
Calculation steps
Closing loan-to-deposit ratio (%) = (((100 × Opening loans) × (1 + (Loan growth (%) ÷ 100))) ÷ (Opening deposits × (1 + (Deposit growth (%) ÷ 100))))
(((100 × 800,000) × (1 + (10 ÷ 100))) ÷ (1,000,000 × (1 + (0 ÷ 100)))) = 88%
Interpreting the result
A rising ratio means loans are growing faster than their deposit funding base.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening loans | 800,000 | 880,000 | Closing loan-to-deposit ratio (%) | 88% | 96.8% |
| Opening deposits | 1,000,000 | 1,100,000 | Closing loan-to-deposit ratio (%) | 88% | 80% |
| Loan growth (%) | 10 | 11 | Closing loan-to-deposit ratio (%) | 88% | 88.8% |
| Deposit growth (%) | 0 | 1 | Closing loan-to-deposit ratio (%) | 88% | 87.128713% |
