Loan Renewal Lead Time Working Weeks Calculator

Count backward on caller supplied working days strictly before loan expiry to resolve renewal lead policy; no fixed five-day week assumption or invented date when earlier coverage is absent.

Description

Working-day lead differs from calendar weeks.

Working-day lead differs from calendar weeks. The supplied calendar must cover the requested days strictly before expiry.

Count backward on caller supplied working days strictly before loan expiry to resolve renewal lead policy; no fixed five-day week assumption or invented date when earlier coverage is absent.

When to use Loan Renewal Lead Time Working Weeks Calculator

Use this tool to count backward on caller supplied working days strictly before loan expiry to resolve renewal lead policy; no fixed five-day week assumption or invented date when earlier coverage is absent.

Prepare the collection, exposure, scheduling or financial records required for this calculation. Keep row order and the declared units consistent.

How to use Loan Renewal Lead Time Working Weeks Calculator and understand its results

  1. Prepare the collection, exposure, scheduling or financial records required for this calculation. Keep row order and the declared units consistent.
  2. Enter loanExpiryDayOrdinal, callerRenewalLeadWorkingDays, suppliedWorkingDayOrdinals using the field table and calculation rules, then run the tool.
  3. Read latestModeledRenewalStartOrdinal, sufficientCalendarLeadCoverage. The explanation below defines the units, signs, ordering and any flags or placeholder values.
  4. 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 fieldMeaningValue type; see rules belowRequirement
loanExpiryDayOrdinalLoan expiry day ordinalintegerRequired
callerRenewalLeadWorkingDaysCaller renewal lead working daysintegerRequired
suppliedWorkingDayOrdinalsSupplied working day ordinalslist of numberRequired

Use nonnegative integer expiry and lead, with increasing nonnegative integer working-day ordinals. Count backward through days strictly before expiry. Return −1 and false when coverage is insufficient.1

Each sequence checked for increasing order must contain at least two strictly increasing values.

start = nth supplied working day before expiry; zero lead = expiry

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output fieldMeaningValue type
latestModeledRenewalStartOrdinalLatest modeled renewal start ordinalnumber
sufficientCalendarLeadCoverageSufficient calendar lead coverageboolean
json
{
  "input": {
    "loanExpiryDayOrdinal": 20,
    "callerRenewalLeadWorkingDays": 2,
    "suppliedWorkingDayOrdinals": [
      10,
      11,
      14,
      15,
      18,
      19,
      20
    ]
  },
  "output": {
    "latestModeledRenewalStartOrdinal": 18,
    "sufficientCalendarLeadCoverage": true
  }
}

Limitations and assumptions

No fixed five-day week or invented earlier calendar is assumed.

Numbers and computed results must be finite; overflow produces an error. Numeric lists are limited to 100,000 entries; the rules above may require smaller limits. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors. A successfully returned false flag is an evaluated outcome; its meaning is explained above.

Alternative or Complementary methods

Use Export Licence Delay Working Days Estimator: Schedule sequential caller export-licence workflow stages on explicitly supplied working-day calendar; incomplete calendar yields -1, not authority processing time or legal permission. For a complementary task, use Loan Out Duration Months Standard Limit Checker: Audit actual/planned loans in continuous whole-month ordinals against per-loan caller limits; partial-month convention must already be resolved, no standard lawful duration.

References

  1. Loan Renewal Lead Time Working Weeks Calculator — tool.io

Similar or alternative tools

Don't forget to set a bookmark for tool.io!
Privacy | Imprint | Cookies