Quota Share Ceding Commission Net Retained Calculator

Reconcile actual quota-share premium/loss and commission on ceded premium, exact separate money rounding; no retrocession attachment waterfall, treaty wording, profit commission or tax/accounting approval.

Description

Quota-share allocation cedes the same stated fraction of premium and loss.

Quota-share allocation cedes the same stated fraction of premium and loss. Ceding commission applies to rounded ceded premium.1

The returned values include Caller ceded premium minor, Caller ceding commission minor, Caller net retained premium minor, Caller ceded loss minor, Caller retained loss minor. The How section below explains the calculation, input rules and interpretation.

When to use Quota Share Ceding Commission Net Retained Calculator

Use Quota Share Ceding Commission Net Retained Calculator when you need to evaluate the supplied records under the calculation and evidence rules below. No treaty interpretation, profit commission, retrocession waterfall or tax/accounting approval is supplied.

Prepare the observed policy, claim or quote evidence and independently verified policy tables. Monetary fields use integer minor units in one currency: for a currency with 100 minor units per major unit, enter 12345 for 123.45. One basis point is 0.01 percentage points, so 10000 basis points represents 100%.

How to use Quota Share Ceding Commission Net Retained Calculator and understand its results

  1. Prepare the observed policy, claim or quote evidence and independently verified policy tables. Monetary fields use integer minor units in one currency: for a currency with 100 minor units per major unit, enter 12345 for 123.45. One basis point is 0.01 percentage points, so 10000 basis points represents 100%.
  2. Enter callerGrossWrittenPremiumMinor, callerIndependentlyCoveredGrossLossMinor, callerQuotaShareCededBasisPoints, callerCedingCommissionBasisPoints using the field table and calculation rules, then run the tool.
  3. Read callerCededPremiumMinor, callerCedingCommissionMinor, callerNetRetainedPremiumMinor, callerCededLossMinor, callerRetainedLossMinor. 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
callerGrossWrittenPremiumMinorCaller gross written premium minornumberRequired
callerIndependentlyCoveredGrossLossMinorCaller independently covered gross loss minornumberRequired
callerQuotaShareCededBasisPointsCaller quota share ceded basis pointsnumberRequired
callerCedingCommissionBasisPointsCaller ceding commission basis pointsnumberRequired

Enter integer premium/loss money 0–10¹² and integer ceded-share/commission basis points 0–10000. Round each allocation separately; return ceded premium, commission, retained premium including commission, ceded loss and gross-minus-ceded retained loss.

cededPremium=roundMinor(grossPremium×share/10000); commission=roundMinor(cededPremium×commissionBps/10000)

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

Output fieldMeaningValue type
callerCededPremiumMinorCaller ceded premium minornumber
callerCedingCommissionMinorCaller ceding commission minornumber
callerNetRetainedPremiumMinorCaller net retained premium minornumber
callerCededLossMinorCaller ceded loss minornumber
callerRetainedLossMinorCaller retained loss minornumber
json
{
  "input": {
    "callerGrossWrittenPremiumMinor": 10000,
    "callerIndependentlyCoveredGrossLossMinor": 8000,
    "callerQuotaShareCededBasisPoints": 4000,
    "callerCedingCommissionBasisPoints": 2500
  },
  "output": {
    "callerCededPremiumMinor": 4000,
    "callerCedingCommissionMinor": 1000,
    "callerNetRetainedPremiumMinor": 7000,
    "callerCededLossMinor": 3200,
    "callerRetainedLossMinor": 4800
  }
}

Limitations and assumptions

No treaty interpretation, profit commission, retrocession waterfall or tax/accounting approval 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 Reserve Paid Outstanding Reconciliation Tool: Claim reserve closure compares incurred with paid plus outstanding. Unknown evidence must be listed separately from genuine zero discrepancies. For a complementary task, use Premium Audit Payroll Exposure Adjustment Tool: Payroll premium audits compare estimated and observed class exposures under verified rates. Class rounding precedes a separately applied total minimum.

References

  1. Quota Share Ceding Commission Net Retained Calculator — tool.io

Similar or alternative tools

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