Compare debt consolidation into a Canadian mortgage
compare_debt_consolidationRead-only
Use this when a user asks about rolling other debts into a Canadian mortgage (debt consolidation), for example credit-card, car-loan or existing line-of-credit or HELOC balances, each entered with a fixed monthly payment or as interest-only. Compares three scenarios over a common horizon: keep the mortgage and debts, consolidate at the new minimum payment, and consolidate while keeping the same monthly repayment budget. Shows interest, debt left, fees and limits. Monthly mortgage payments only; 1 to 10 debts. Do not use for a new HELOC, additional cash-out or qualification: none is modeled.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| debts | Yes | ||
| penalty | Yes | The penalty amount the lender quoted, in CAD. Never estimate it; use {state:"unknown"} if there is no quote. | |
| mortgage | Yes | ||
| contractCaps | No | ||
| horizonMonths | No | Comparison horizon in months. Defaults to the shortest supplied term, at most 120. | |
| monthlyBudget | No | Total monthly amount the user wants to keep paying after consolidating. Defaults to the current mortgage payment plus the debt payments due in month one. | |
| propertyValue | No | ||
| penaltyFunding | Yes | cash if paid out of pocket; financed if added to the new mortgage. | |
| scheduleWindow | No | ||
| startingBalance | Yes | Mortgage balance now, in CAD, as digits only: no $ sign, no commas, no spaces, for example "412000" or "412000.50". Before any costs are added. | |
| replacementOffer | Yes |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| links | Yes | ||
| scope | Yes | ||
| payoff | No | ||
| status | Yes | ||
| horizon | No | ||
| reasons | Yes | ||
| sources | Yes | ||
| currency | Yes | ||
| schedule | No | ||
| breakEven | No | ||
| scenarios | Yes | ||
| assumptions | Yes | ||
| differences | No | ||
| sensitivity | No | ||
| dateMappings | No | ||
| missingInputs | Yes | ||
| nextQuestions | Yes | ||
| schemaVersion | Yes | ||
| evaluatedThrough | No | ||
| requestedHorizon | No | ||
| illustrativeRatio | No | ||
| calculationVersion | Yes |