CSV column dictionary — version 1.0.0 All monetary columns USD rounded to two decimals. Percent columns are percentage points, e.g.6.5, except contribution_rate which is a fraction, e.g.0.06. Each scenario has three strategies. The JSON retains full-precision output. | Columns | Meaning | | --- | --- | | version, generation_date, methodology_url | Dataset version, dated release generation, canonical future methodology location | | scenario_id, scenario_group | Shared scenario key across three strategy rows; primary or cost-sensitivity | | purchase_price | Original purchase price before any reduction | | price_cut_requested, seller_credit_requested | Common negotiation comparison inputs; not both applied to every strategy | | down_payment_percent, hypothetical_interest_rate | Fixed percentage down and annual hypothetical rate | | loan_term_years, holding_period_years | Fixed term and elapsed amortization horizon | | strategy | baseline, price-cut or seller-credit | | adjusted_purchase_price, down_payment_amount, loan_amount | Strategy purchase price, percentage-based cash down, original principal | | ltv_percent, underwriting_ltv_percent | Raw LTV and whole-percent upward-rounded LTV for contribution band | | contribution_rate, contribution_dollar_limit | Fractional IPC ceiling and dollar allowance on that strategy's price | | modeled_eligible_costs | Hypothetical assumed eligible closing/prepaid/initial escrow input, counted once; real transaction eligibility requires lender confirmation | | maximum_usable_credit | Lesser of costs and program limit, before limiting by offer | | strategy_credit_offered | Zero in baseline/cut; requested credit in seller-credit strategy | | usable_seller_credit, credit_not_provided | Applied amount and remainder excluded by agreed reduction | | monthly_pi, total_pi | Monthly and cumulative principal plus interest only | | modeled_buyer_cash_required | Down payment plus costs minus applied credit | | principal_paid, interest_paid, remaining_balance | Amortization components through holding period | | cash_paid_through_period | Upfront modeled cash plus cumulative P&I | | modeled_price_interest_net_costs | Price+interest+costs−credit; includes remaining debt, not all paid cash | | notes | Hypothetical scope and unused-credit qualification |