Negative equity calculator

Enter your price, deposit, rate, term, balloon and depreciation to see when the loan balance exceeds your asset’s value.

Loan

Enter 0 if your loan has no balloon.

How the asset loses value

The demo loan and depreciation rates are made up.

Largest negative equity

€1,309
Months in negative equity29
Covered frommonth 37
Monthly payment€461.04

From month 8 to month 36, your loan balance is above the asset’s value by as much as €1,309 in month 16.

Loan to value by year

Start
90.0%
Year 1
105.6%
Year 2
105.8%
Year 3
100.6%
Year 4
87.8%
Year 5
63.9%

Loan balance and asset value

Loan balanceAsset valueNegative equity

Email your result

Set deposit, term and balloon limits by asset type and age in your own decision rules to catch loans that would sit underwater at application. Start your trial

How negative equity is calculated

Each month, your payment reduces the loan balance as the asset loses value, faster in the first year and then at the yearly rate. When the balance is higher, the gap is your negative equity.

Amount lent = Asset price − Deposit
i = Yearly interest rate ÷ 12;  n = Term in months
Monthly payment = (Amount lent − Asset price × Balloon (% of price) ÷ (1 + i)^n) × i ÷ (1 − (1 + i)^−n)
Loan balance (m) = Amount lent × (1 + i)^m − Monthly payment × ((1 + i)^m − 1) ÷ i
Asset value (m) = Asset price × (1 − First-year depreciation)^min(m ÷ 12, 1) × (1 − Depreciation each year after)^max(m ÷ 12 − 1, 0)
Gap (m) = Loan balance (m) − Asset value (m)
Largest negative equity = max Gap (m)
Loan to value by year = Loan balance (m) ÷ Asset value (m)

The worked figures use the month with the largest gap for your numbers above.

€30,000 − €3,000 = €27,000
i = 9% ÷ 12 = 0.75%
€27,000 × (1 + i)^16 − €461.04 × ((1 + i)^16 − 1) ÷ i = €22,622
€30,000 × (1 − 25%)^1 × (1 − 15%)^0.3333 = €21,314
€22,622 − €21,314 = €1,309

Payments are monthly in arrears, and the value falls smoothly with no drop on the day of purchase. Fees, insurance, tax, arrears, and repossession and sale costs are excluded.

Negative equity calculator

Negative equity is when your loan balance is higher than your asset’s value. This calculator compares them month by month using your price, deposit, rate, term, balloon and depreciation.

The result shows how long the loan is in negative equity and the largest gap between the balance and the asset’s value. Use it to see how your deposit, term and balloon limits affect a loan secured on an asset.

Common questions

What is negative equity on a car loan?

Negative equity is when the loan balance is higher than the car’s value. The gap between them is the negative equity amount.

When is my car loan underwater?

Your loan is underwater in any month when its balance is higher than the car’s value. This calculator shows those months across the term.

How do I calculate negative equity?

Subtract the asset’s value from the loan balance for each month. A positive gap means the loan is in negative equity.

How does a balloon affect negative equity?

The balloon is the amount left owing at the end of the term. It affects the balance and monthly payment used in the calculation.

What does loan to value show over time?

Loan to value compares the loan balance with the asset’s value. This calculator shows it at the start and at the end of each year.