Resolve the FHA annual MIP cell
resolve_fha_annual_mipRead-onlyIdempotent
ANSWERS: "what is the FHA annual MIP for a $300,000 loan at 85% LTV over 15 years", "what MIP rate applies to my FHA case". PARAMS: base_loan_amount (USD), ltv_pct (e.g. 96.5), term_years, case_number_date (YYYY-MM-DD). Resolves the exact cell of HUD Mortgagee Letter 2023-05 and returns the annual rate in basis points, the upfront rate, the matched cell, the rule id with effective date and sha256, and a sentence you may quote. If a parameter is missing it returns block with CONDITION_MISSING and no number: the table has eleven cells and a guess is wrong more often than right. NOT FOR: case numbers before 2023-03-20, HECM/reverse or Title I loans, or any monthly payment figure.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ltv_pct | No | Loan-to-value in percent, e.g. 96.5 | |
| term_years | No | Loan term in years | |
| base_loan_amount | No | Base loan amount in USD, before upfront MIP is financed | |
| case_number_date | No | FHA case number assignment date, YYYY-MM-DD |