Fair-lending analysis preparation

Fair-lending analysis preparation is a free browser tool that produces traceable formula results, complete task output tables and source-linked unknowns from supplied application outcomes and approved descriptive lending metrics. Calculations use supplied observations and explicitly approved methods.

Free. No account or payment needed.

Your browser is preparing this tool.

What does the fair-lending analysis preparation produce?

Validate supplied application outcomes and prepare approved descriptive lending metrics.

Use the exact local files and task-specific inputs listed below. Preparation and review stay in this browser. Inspect all findings before preparing the finalized pack.

What do you need before you start?

  • Define the authorized source population and your review rules.
  • Keep the unchanged original files and record the snapshot and exclusions.
  • Review missing and invalid inputs before preparing the finalized pack.

What information do you enter?

Select the actual local sources and freeze the task-specific inputs below. Keep source files and complete findings private.

  • Supplied application outcomes. Exact headings application_id, group, qualified, approved, source_ref.
  • Approved descriptive lending metrics. Exact headings group, reference_group, selection_gap_limit_pp, tpr_gap_limit_pp, fpr_gap_limit_pp, minimum_group_size, model_version, approval_ref.
  • Analysis reference. Customer-controlled review reference.
  • Analysis owner. Responsible reviewer of method and evidence.
  • Observation date. Real YYYY-MM-DD date. Future source observations are unresolved.
  • Population and method scope. Name source population, selected period, approved model and known omissions.
  • Population declaration. Select the explicit approved working method.
Field guidance. The fictional example is invented. Replace it with your own reviewed facts.
FieldWhat to enterFictional example
Analysis referenceRequiredCustomer-controlled review reference.
Analysis ownerRequiredResponsible reviewer of method and evidence.
Observation dateRequiredReal YYYY-MM-DD date. Future source observations are unresolved.2026-10-09
Population and method scopeRequiredName source population, selected period, approved model and known omissions.
Population declarationRequiredSelect the explicit approved working method.Choose from Selected records only, Your declared complete sources.Selected records only

What you can download

Every result must identify its supplied facts, assumptions and unresolved items.

Free resultIncluded downloads

Enter your information, inspect the on-screen result and keep a browser backup.

Editing and direct copies of your entered information stay free.

  • Traceable formula results, complete task output tables and source-linked unknowns. Free full result JSON, findings CSV and working datasets.
  • Nine files. Formal PDF and DOCX, complete Excel source populations and calculations, findings CSV, frozen inputs/results JSON, delivered-file hashes, instructions and two exact originals.
  • Validated browser backup ZIP, local reload, exact-byte restore and separate preserved earlier forms, calculator drafts, source files and historical purchases.

These supported outputs are free. No checkout is required.

Fictional review report (PDF). Editable review (DOCX). Complete fictional pack (ZIP). Requires tailoring and responsible review. Samples use the finalized renderer.

How does the fair-lending analysis preparation work?

  1. 1
    Select the actual sources

    Supplied application outcomes. Exact headings application_id, group, qualified, approved, source_ref.

  2. 2
    Freeze the review rules

    Count complete supplied binary outcomes by your exact declared group. Calculate selection rate, true positive rate and false positive rate. Compare absolute percentage-point gaps with the explicit reference group and approved thresholds. Show denominators, small groups and undefined metrics. Missing or invalid records prevent complete group comparisons. No protected attribute, causation, statistical significance or legal standard is inferred.

  3. 3
    Inspect complete findings

    Review all source-linked results and unresolved items. Free JSON and CSV preserve complete results.

  4. 4
    Keep recoverable work

    Exact source files and input strings save in this browser. Backups verify tool identity, input schema, hashes and parsed bytes before replacing current work. Prior checkpoints and historical purchases stay separate.

  5. 5
    Prepare the finalized pack

    Prepare nine complete files, including both exact originals, then download them free. Review the fictional sample below.

Method and sources

Apply the steps above to the supported inputs. Use the listed source sections to review the rule basis, assumptions and limits.

Common questions

What information does the fair-lending analysis preparation need?

Enter supplied application outcomes. Exact headings application_id, group, qualified, approved, source_ref; approved descriptive lending metrics. Exact headings group, reference_group, selection_gap_limit_pp, tpr_gap_limit_pp, fpr_gap_limit_pp, minimum_group_size, model_version, approval_ref; analysis reference. Customer-controlled review reference; analysis owner. Responsible reviewer of method and evidence; observation date. Real YYYY-MM-DD date. Future source observations are unresolved. Define the authorized source population and your review rules.

What does the fair-lending analysis preparation produce?

Traceable formula results, complete task output tables and source-linked unknowns. Free full result JSON, findings CSV and working datasets. Nine files. Formal PDF and DOCX, complete Excel source populations and calculations, findings CSV, frozen inputs/results JSON, delivered-file hashes, instructions and two exact originals. Validated browser backup ZIP, local reload, exact-byte restore and separate preserved earlier forms, calculator drafts, source files and historical purchases. Review unresolved findings and limitations before use.

Who makes the final decision?

A responsible person reviews the result. Calculations use supplied observations and explicitly approved methods. Original files and prior work remain in this browser. Results do not establish source authenticity, population completeness, causation, regulatory compliance or approval to make a customer, supplier, lending or model decision.

Is this tool free?

Yes. The on-screen result and listed downloads are free. No checkout is required. Keep local backups and review the stated method and limits.

Can I use the fair-lending analysis preparation for this task?

Validate datasets and calculate metrics without making lending decisions. Calculations use supplied observations and explicitly approved methods. Original files and prior work remain in this browser. Results do not establish source authenticity, population completeness, causation, regulatory compliance or approval to make a customer, supplier, lending or model decision.

What still needs review?

Calculations use supplied observations and explicitly approved methods. Original files and prior work remain in this browser. Results do not establish source authenticity, population completeness, causation, regulatory compliance or approval to make a customer, supplier, lending or model decision.

qualified is your supplied actual label and approved is your supplied positive outcome. Both are exactly true or false. This workpaper never determines qualifications, discrimination or lending decisions.

Source limits are 10 MB, 5000 rows, 50 fields, 100000 cells and 5000000 parsed characters per file. Plain decimal inputs support 12 whole digits and 6 fractional digits.

Calculations use exact rational arithmetic and round displayed values half away from zero to six fractional places unless an explicit payment rounding rule applies. Decisions compare unrounded values.

Complete results support at most 20000 findings and 15000000 characters. Formal reports show the first 25 rows per calculation output, 1000 characters per calculation preview, and the first 100 named checks with 400 characters per check field. Excel and JSON retain all values.