Open calculator ↗

Loan-to-deposit ratio after balance sheet growth · Calculation guide

Apply independent growth assumptions to opening gross loans and deposits over the same interval.

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

InputValue
Opening loans800,000
Opening deposits1,000,000
Loan growth (%)10
Deposit growth (%)0
ResultValue
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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening loans800,000880,000Closing loan-to-deposit ratio (%)88%96.8%
Opening deposits1,000,0001,100,000Closing loan-to-deposit ratio (%)88%80%
Loan growth (%)1011Closing loan-to-deposit ratio (%)88%88.8%
Deposit growth (%)01Closing loan-to-deposit ratio (%)88%87.128713%
Loan-to-deposit ratio after balance sheet growth →

Sources