Skip to main content
Many agencies have a default: “we always offer 25% down over 10 months”. You can encode that without any setting on our side, because option ids are deterministic:
opt_25_10 is 25% down over 10 months, on every quote that offers it. The catch is in the last four words: not every quote offers it. This page explains why, and gives you a lookup that always lands on a sensible option.

Why an exact id can be missing

The down payments follow the minimum earned premium

Each quote offers five down payments. They start 10 points below the deal’s premium-weighted minimum earned rate, never below 10%, and step up by 5 points:
The weighted rate is totals.weighted_minimum_earned_rate on the quote, weighted by each policy’s premium. So the rungs move with the deal: A 25% minimum earned, the most common case, does give you a 25% row. But an exact 25% rung exists only when the weighted minimum earned rounds to 20% or less, or to 25%, 30% or 35%. A deal whose weighted minimum earned comes to 27% has no 25% row at all.

The terms follow the policy dates

The longest term always ends before the policies do. A 12-month policy typically gets terms of 6 to 11 months; a shorter policy gets fewer and shorter terms. A policy shorter than 3 months can’t be financed at all.

Some cells are dropped

An option whose APR would exceed the state’s limit (17.9% in Texas) is left out, so the grid can be ragged: a term can exist at one down payment and be missing at another. An ineligible quote has no options at all, and neither does an eligible one where every option was dropped (see eligible, but no options). In both cases options is empty and recommended_option_id is null.

The lookup

Try the exact id. If it’s missing, take the same term at the nearest down payment at or above your target, so the client never puts down less than your rule intends. If that term isn’t offered either, fall back to recommended_option_id.
Match on term_months and down_payment_rate, as above, rather than by taking an id apart. The id format is stable, but the fields are what we document as the values.

A worked example

A single ocean marine policy with a 27% minimum earned, financed over its 12-month term (illustrative figures):
  • 25% over 10 months: opt_25_10 doesn’t exist. The nearest down payment at or above 25% for 10 months is 27%, so the lookup returns opt_27_10.
  • 40% over 10 months: nothing at or above 40%. The lookup returns recommended_option_id, which here is opt_27_10.
  • 25% over 12 months: no 12-month term (the loan has to end before the policy does), so the lookup returns recommended_option_id.
The recommended option is the down payment closest to the weighted minimum earned, at the term we’d suggest for it.

When your client has already chosen

If your client picked an option on the interactive quote, use theirs: selected_option_id on the quote. A house rule is for the default you show first, not for overriding a choice.
The ladder may change. We’re considering a fixed 5% grid of down payments (10, 15, 20, 25 and so on) instead of one that follows the minimum earned. The lookup above is correct either way: exact id first, then the nearest down payment at or above your target for the same term, then the recommended option. Write it once and it keeps working.