Evaluating Asset Based Borrowing Base Formulas in Growth Financing
Evaluating borrowing base availability demands stress testing collateral eligibility carve-outs against dilution and liquidation haircuts.
Dilution Calculation
Meaning
Financial formulas measuring the difference between the face value of an invoice and the actual cash collected account for non cash reductions such as returns and credits. Performing a dilution calculation identifies the gap between what was billed and what was received. Lenders use the result to adjust the advance rate on accounts receivable.
Reserve Adjustment
Standard practice involves calculating the percentage of gross sales lost to dilutions over a rolling twelve month period. This percentage becomes a primary factor in setting the borrowing base limit. If a company generates one million in sales but collects only nine hundred thousand due to early payment discounts and returned products, the dilution rate is ten percent.
Collection Variance
External audits track specific credit memos and write offs to ensure that the reported figures match the historical reality of the ledger. Discrepancies often emerge when a supplier issues bulk credits at the end of a quarter to clear disputed items. These spikes in credit activity force an immediate tightening of the available credit line.
Loss Impact
Higher rates of non cash deductions reduce the recovery value of the collateral in a liquidation scenario. A large increase in returns suggests that the inventory quality is falling or that customer satisfaction is declining. The calculation provides a buffer that ensures the lender does not over-advance against funds that will never be collected.