Escrow Shortage Spread Option Checker
Budget shortage from actual projected minimum escrow versus separately supplied required floor with caller spread/lump-sum policy and explicit ceiling rounding excess; unlike existing cushion checker, this does not derive a statutory cushion or allowable collection option.
Description
An escrow-shortage spread divides a caller-established shortfall across whole monthly payments.
An escrow-shortage spread divides a caller-established shortfall across whole monthly payments. Ceiling rounding can collect slightly more than the exact shortage.1
The returned values include Caller escrow shortage minor, Ceiling rounded monthly shortage payment minor, Total spread collection minor, Spread rounding excess minor, Available lump sum option minor. The How section below explains the calculation, input rules and interpretation.
When to use Escrow Shortage Spread Option Checker
Use Escrow Shortage Spread Option Checker when you need to evaluate the supplied records under the calculation and evidence rules below. No statutory cushion derivation, permitted collection option or escrow legal conclusion is supplied.
Prepare observed financial records and verified caller terms. Use one currency for integer minor-unit money and preserve leading zeros in identifier text. One basis point is 0.01 percentage points. Resolve dates, local clocks, counting rules and evidence flags as specified.
How to use Escrow Shortage Spread Option Checker and understand its results
- Prepare observed financial records and verified caller terms. Use one currency for integer minor-unit money and preserve leading zeros in identifier text. One basis point is 0.01 percentage points. Resolve dates, local clocks, counting rules and evidence flags as specified.
- Enter projectedLowestEscrowBalanceMinor, callerRequiredMinimumBalanceMinor, callerSpreadMonths, callerLumpSumOptionAllowed using the field table and calculation rules, then run the tool.
- Read callerEscrowShortageMinor, ceilingRoundedMonthlyShortagePaymentMinor, totalSpreadCollectionMinor, spreadRoundingExcessMinor, availableLumpSumOptionMinor. The explanation below defines the units, signs, ordering and any flags or placeholder values.
- If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
| Input field | Meaning | Value type; see rules below | Requirement |
|---|---|---|---|
| projectedLowestEscrowBalanceMinor | Projected lowest escrow balance minor | number | Required |
| callerRequiredMinimumBalanceMinor | Caller required minimum balance minor | number | Required |
| callerSpreadMonths | Caller spread months | number | Required |
| callerLumpSumOptionAllowed | Caller lump sum option allowed | boolean | Required |
Enter signed safe-integer projected minimum, nonnegative safe-integer required floor, integer spread months 1–120 and a lump-sum-option boolean. Return shortage, ceiling monthly amount, total collection, rounding excess and lump-sum amount; unavailable lump-sum option is −1. Require safe integer results.
shortage=max(0,requiredFloor−projectedMinimum); monthly=ceil(shortage/months); excess=monthly×months−shortage Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| callerEscrowShortageMinor | Caller escrow shortage minor | number |
| ceilingRoundedMonthlyShortagePaymentMinor | Ceiling rounded monthly shortage payment minor | number |
| totalSpreadCollectionMinor | Total spread collection minor | number |
| spreadRoundingExcessMinor | Spread rounding excess minor | number |
| availableLumpSumOptionMinor | Available lump sum option minor | number |
{
"input": {
"projectedLowestEscrowBalanceMinor": -120,
"callerRequiredMinimumBalanceMinor": 100,
"callerSpreadMonths": 12,
"callerLumpSumOptionAllowed": true
},
"output": {
"callerEscrowShortageMinor": 220,
"ceilingRoundedMonthlyShortagePaymentMinor": 19,
"totalSpreadCollectionMinor": 228,
"spreadRoundingExcessMinor": 8,
"availableLumpSumOptionMinor": 220
}
}Limitations and assumptions
No statutory cushion derivation, permitted collection option or escrow legal conclusion is supplied.
Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.
Alternative or Complementary methods
Use Prepayment Penalty Window Checker: A declared prepayment-penalty window includes its start and excludes expiry. The fee scenario can combine percentage and fixed amounts. For a complementary task, use CD Early Withdrawal Penalty Months Lookup: A nominal-interest CD penalty scales principal by annual rate and penalty months. The supplied cap policy determines whether penalty can invade principal.
References
-
Escrow Shortage Spread Option Checker — tool.io
Similar or alternative tools
- Prepayment Penalty Window Checker
A declared prepayment-penalty window includes its start and excludes expiry. The fee scenario can combine percentage and fixed amounts.
- CD Early Withdrawal Penalty Months Lookup
A nominal-interest CD penalty scales principal by annual rate and penalty months. The supplied cap policy determines whether penalty can invade principal.