lending
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseLending Analysis
借贷分析
Purpose
用途
Analyze lending products including mortgages, HELOCs, and personal loans. This skill covers loan comparison, qualification assessment, fixed vs adjustable rate analysis, amortization with extra payments, and home equity line of credit evaluation.
分析包括抵押贷款、HELOC、个人贷款在内的借贷产品。本技能覆盖贷款对比、资质评估、固定利率与可调利率分析、含额外还款的摊销计算,以及房屋净值信贷额度评估。
Layer
层级
6 — Personal Finance
6 — 个人理财
Direction
适用方向
both
双向
When to Use
适用场景
- Shopping for a mortgage and comparing loan offers (fixed vs ARM, 15-year vs 30-year)
- Computing monthly payments, total interest, and amortization schedules
- Evaluating the impact of extra principal payments on loan term and interest savings
- Deciding whether to buy points (prepaid interest) and computing breakeven
- Comparing APR vs interest rate across loan offers
- Assessing loan qualification (FICO, DTI, LTV, reserves)
- Analyzing HELOC options and combined loan-to-value ratios
- Evaluating PMI costs and strategies to eliminate PMI
- 选购抵押贷款并对比贷款方案(固定利率vs ARM、15年期vs30年期)
- 计算月供、总利息和摊销时间表
- 评估额外本金还款对贷款期限和利息节省的影响
- 决定是否购买贴现点(预付利息)并计算盈亏平衡点
- 对比不同贷款方案的APR与利率
- 评估贷款资质(FICO、DTI、LTV、储备金)
- 分析HELOC选项和综合贷款价值比
- 评估PMI成本和消除PMI的策略
Core Concepts
核心概念
Fixed-Rate Mortgage
固定利率抵押贷款(Fixed-Rate Mortgage)
The interest rate and monthly payment remain constant for the life of the loan:
- Advantages: Predictable payments, protection against rising rates, simpler budgeting
- Disadvantages: Higher initial rate than ARM, no benefit if rates decline (must refinance)
- Most common terms: 30-year and 15-year fixed
贷款利率和月供在贷款整个期限内保持恒定:
- 优势: 还款额可预测,抵御利率上涨风险,预算规划更简单
- 劣势: 初始利率高于ARM,利率下降时无法直接获益(必须refinance)
- 最常见的期限:30年期和15年期固定
Adjustable-Rate Mortgage (ARM)
可调利率抵押贷款(Adjustable-Rate Mortgage, ARM)
Rate is fixed for an initial period, then adjusts periodically based on an index plus a margin:
- Notation: 5/1 ARM = fixed for 5 years, adjusts annually thereafter; 7/1, 10/1 similarly
- Fully indexed rate: Index (e.g., SOFR, 1-year Treasury) + margin (e.g., 2.75%)
- Rate caps protect against extreme adjustments:
- Initial adjustment cap (e.g., 2%): maximum first adjustment
- Periodic cap (e.g., 2%): maximum change per adjustment period
- Lifetime cap (e.g., 5%): maximum total increase over initial rate
- When ARM may be appropriate: Planning to sell or refinance before the fixed period ends, expecting rates to decline, or comfortable with rate variability
利率在初始期限内固定,之后基于指数加利差定期调整:
- 命名规则: 5/1 ARM = 前5年利率固定,之后每年调整;7/1、10/1规则类似
- 完全指数化利率: 指数(例如SOFR、1年期国债利率)+ 利差(例如2.75%)
- 利率上限 避免利率调整幅度过大:
- 首次调整上限(例如2%):首次调整的最大上浮幅度
- 周期调整上限(例如2%):每个调整周期的最大变动幅度
- 终身上限(例如5%):相较初始利率的最大总上浮幅度
- 适合选择ARM的场景: 计划在固定期限结束前出售房产或refinance、预期利率下降,或能接受利率波动
Monthly Payment Calculation
月供计算
The standard amortization formula for a fixed-rate loan:
- PMT = P × [r(1+r)^n] / [(1+r)^n - 1]
- Where: P = principal (loan amount), r = monthly interest rate (annual rate / 12), n = total number of payments (term in months)
- Each payment splits into interest (decreasing) and principal (increasing) components:
- Interest portion: remaining balance × monthly rate
- Principal portion: PMT - interest portion
固定利率贷款的标准摊销公式:
- PMT = P × [r(1+r)^n] / [(1+r)^n - 1]
- 其中:P = 本金(贷款金额),r = 月利率(年利率 / 12),n = 总还款次数(期限按月计算)
- 每笔还款分为利息(递减)和本金(递增)两部分:
- 利息部分:剩余本金 × 月利率
- 本金部分:PMT - 利息部分
Total Interest Paid
总利息支付
- Total interest = (n × PMT) - P
- For a $400K, 30-year loan at 6.5%: PMT = $2,528, total payments = $910,178, total interest = $510,178
- 总利息 = (n × PMT) - P
- 举例:40万美元、30年期、利率6.5%的贷款:PMT = 2528美元,总还款额 = 910178美元,总利息 = 510178美元
Extra Payments
额外还款
Additional principal payments reduce the outstanding balance, shorten the loan term, and reduce total interest:
- Each extra dollar goes entirely to principal reduction
- Impact compounds: earlier extra payments save more interest than later ones
- Methods: lump sum, fixed monthly extra, biweekly payments (26 half-payments = 13 full payments per year)
额外的本金还款会减少未偿余额、缩短贷款期限、减少总利息:
- 每多还1美元都全部用于抵扣本金
- 影响会复利计算:越早还额外本金,节省的利息越多
- 还款方式:一次性大额还款、每月固定多还、双周还款(26次半额还款=每年13次全额还款)
Mortgage Points
抵押贷款贴现点(Mortgage Points)
Prepaid interest that reduces the loan's interest rate:
- 1 point = 1% of the loan amount (e.g., 1 point on $400K = $4,000)
- Typically reduces the rate by approximately 0.25% (varies by lender and market)
- Breakeven calculation: Points cost / monthly savings = months to recoup
- Points make sense when: planning to hold the loan beyond breakeven, itemizing deductions (points may be tax-deductible in year of purchase)
用于降低贷款利率的预付利息:
- 1个点 = 贷款金额的1%(例如40万美元贷款的1个点=4000美元)
- 通常可以降低约0.25%的利率(具体取决于贷款机构和市场)
- 盈亏平衡点计算: 贴现点成本 / 每月节省金额 = 回收成本所需月数
- 适合购买贴现点的情况:计划持有贷款的时间超过盈亏平衡点、申报分项扣除(贴现点可在购房当年抵扣税款)
APR vs Interest Rate
APR vs 利率
- Interest rate: The cost of borrowing the principal, expressed annually
- APR (Annual Percentage Rate): Includes the interest rate plus certain fees and costs (origination fees, points, PMI), annualized over the loan term
- APR > interest rate (always, when there are fees)
- APR is the better metric for comparing loan offers with different fee structures
- 利率: 借入本金的成本,按年计算
- APR(年度百分比率): 包含利率加上特定费用和成本(贷款发放费、贴现点、PMI),在贷款期限内按年折算的综合成本
- APR 始终高于利率(存在费用的情况下)
- 对比不同费用结构的贷款方案时,APR是更合理的指标
HELOC (Home Equity Line of Credit)
HELOC(房屋净值信贷额度)
A revolving credit line secured by home equity:
- Combined LTV (CLTV): (First mortgage balance + HELOC limit) / home value
- Most lenders require CLTV ≤ 80-90%
- Draw period (typically 10 years): borrow and repay flexibly, often interest-only payments
- Repayment period (typically 20 years): no new draws, fully amortizing payments
- Variable rate: Typically prime rate + margin; rate fluctuates with market
- Use cases: Home improvements, debt consolidation, emergency backup (but not as primary emergency fund)
- Risk: Home is collateral — default means foreclosure
以房屋净值为抵押的循环信贷额度:
- 综合贷款价值比(CLTV):(第一抵押贷款余额 + HELOC额度)/ 房产价值
- 大多数贷款机构要求CLTV ≤ 80-90%
- 提款期(通常10年):可灵活借款和还款,通常只需还利息
- 还款期(通常20年):不能再提款,需按完全摊销方式还款
- 浮动利率: 通常为最优惠利率 + 利差,利率随市场波动
- 适用场景: 房屋翻新、债务合并、应急备用金(但不适合作为主要应急基金)
- 风险: 房屋是抵押物 — 违约会被没收房产
Loan Qualification Criteria
贷款资质标准
- FICO score: 620+ for conventional, 580+ for FHA, 700+ for best rates
- DTI: Front-end ≤ 28%, back-end ≤ 36-43% (varies by program)
- LTV (Loan-to-Value): Loan amount / property value; lower LTV = lower risk = better terms
- Reserves: Months of payments held in liquid assets after closing (2-6 months typical)
- Employment/income: Stable income history, typically 2 years documentation
- FICO 分数: 传统贷款要求620+,FHA贷款要求580+,700+可获得最优利率
- DTI: 前端DTI ≤ 28%,后端DTI ≤ 36-43%(根据项目不同有所差异)
- LTV(贷款价值比): 贷款金额 / 房产价值;LTV越低 = 风险越低 = 条款越优
- 储备金: 过户后流动资产可覆盖的还款月数(通常要求2-6个月)
- 就业/收入: 稳定的收入历史,通常需要2年的证明材料
PMI (Private Mortgage Insurance)
PMI(私人抵押贷款保险)
Required when conventional loan LTV exceeds 80%:
- Cost: 0.5-1.5% of loan amount annually, added to monthly payment
- Removal: Automatic at 78% LTV (based on original amortization), requestable at 80% LTV
- Avoidance strategies: 20% down payment, piggyback loan (80/10/10), lender-paid PMI (higher rate), VA loan (no PMI)
- PMI benefits the lender, not the borrower — it is pure cost to the borrower
当传统贷款的LTV超过80%时要求购买:
- 成本: 每年为贷款金额的0.5-1.5%,加入到月供中
- 移除: LTV达到78%时自动移除(基于原始摊销时间表),LTV达到80%时可申请移除
- 规避策略: 首付20%、叠加贷款(80/10/10)、贷款机构支付PMI(利率更高)、VA贷款(无需PMI)
- PMI保障的是贷款机构而非借款人 — 对借款人来说是纯成本支出
15-Year vs 30-Year Comparison
15年期vs30年期对比
- 15-year: Higher monthly payment, lower interest rate (typically 0.5-0.75% less), dramatically less total interest, builds equity faster
- 30-year: Lower required payment, more flexibility, higher total interest cost
- Hybrid approach: Take a 30-year for flexibility, make extra payments as if it were a 15-year
- 15年期: 月供更高,利率更低(通常低0.5-0.75%),总利息大幅减少,积累净值更快
- 30年期: 要求的月供更低,灵活性更高,总利息成本更高
- 混合方案: 选择30年期贷款获得灵活性,按15年期的标准额外还款
Key Formulas
核心公式
| Formula | Expression | Use Case |
|---|---|---|
| Monthly payment | PMT = P × [r(1+r)^n] / [(1+r)^n - 1] | Fixed-rate loan payment |
| Total interest | n × PMT - P | Total cost of borrowing |
| Remaining balance after k payments | B_k = P × [(1+r)^n - (1+r)^k] / [(1+r)^n - 1] | Balance at any point |
| Points breakeven | Cost of points / monthly savings | Months to recoup points |
| LTV | Loan amount / property value | Risk and PMI assessment |
| CLTV | (First mortgage + HELOC) / home value | Combined leverage |
| ARM fully indexed rate | Index + margin | Rate after fixed period |
| 公式 | 表达式 | 适用场景 |
|---|---|---|
| 月供 | PMT = P × [r(1+r)^n] / [(1+r)^n - 1] | 固定利率贷款还款计算 |
| 总利息 | n × PMT - P | 总借贷成本 |
| 还款k次后的剩余余额 | B_k = P × [(1+r)^n - (1+r)^k] / [(1+r)^n - 1] | 任意时间点的剩余余额 |
| 贴现点盈亏平衡点 | 贴现点成本 / 每月节省金额 | 回收贴现点成本所需月数 |
| LTV | 贷款金额 / 房产价值 | 风险和PMI评估 |
| CLTV | (第一抵押贷款 + HELOC) / 房产价值 | 综合杠杆率 |
| ARM完全指数化利率 | 指数 + 利差 | 固定期限结束后的利率 |
Worked Examples
计算示例
Example 1: 30-year vs 15-year mortgage comparison
示例1:30年期vs15年期抵押贷款对比
Given: Home price $500K, down payment $100K, loan amount $400K. 30-year rate: 6.5%. 15-year rate: 5.9%.
Calculate: Monthly payments, total interest, and interest savings.
Solution:
- 30-year monthly payment: PMT = $400,000 × [0.005417 × (1.005417)^360] / [(1.005417)^360 - 1]
- r = 6.5%/12 = 0.005417, n = 360
- PMT = $2,528/month
- 30-year total interest: 360 × $2,528 - $400,000 = $510,178
- 15-year monthly payment: PMT = $400,000 × [0.004917 × (1.004917)^180] / [(1.004917)^180 - 1]
- r = 5.9%/12 = 0.004917, n = 180
- PMT = $3,357/month
- 15-year total interest: 180 × $3,357 - $400,000 = $204,299
- Payment difference: $3,357 - $2,528 = $829/month more for 15-year.
- Interest savings: $510,178 - $204,299 = $305,879 saved by choosing 15-year.
- The 15-year costs 33% more per month but saves 60% in total interest.
已知条件: 房价50万美元,首付10万美元,贷款金额40万美元。30年期利率:6.5%。15年期利率:5.9%。
计算: 月供、总利息、利息节省额。
解答:
- 30年月供: PMT = $400,000 × [0.005417 × (1.005417)^360] / [(1.005417)^360 - 1]
- r = 6.5%/12 = 0.005417, n = 360
- PMT = $2,528/月
- 30年总利息: 360 × $2,528 - $400,000 = $510,178
- 15年月供: PMT = $400,000 × [0.004917 × (1.004917)^180] / [(1.004917)^180 - 1]
- r = 5.9%/12 = 0.004917, n = 180
- PMT = $3,357/月
- 15年总利息: 180 × $3,357 - $400,000 = $204,299
- 月供差额: $3,357 - $2,528 = 每月多付$829(选择15年期)
- 利息节省: $510,178 - $204,299 = 选择15年期可节省$305,879
- 15年期每月还款额高33%,但总利息节省60%。
Example 2: Extra payment impact
示例2:额外还款的影响
Given: $300K 30-year mortgage at 6.5% (payment = $1,896/mo). Borrower adds $200/month extra to principal.
Calculate: Years saved and interest saved.
Solution:
- Without extra payments: 30 years (360 months), total interest = $282,632.
- With $200/month extra ($2,096 total): Solve for n: n = -ln(1 - ($300,000 × 0.005417) / $2,096) / ln(1.005417)
- n ≈ 274 months = 22.8 years (saves ~7.2 years).
- Total payments with extra: 274 × $2,096 = $574,304. Total interest = $574,304 - $300,000 = $274,304.
- Wait — we must account for the extra payments reducing principal faster. Using iterative amortization:
- Actual payoff: approximately 272 months (22 years 8 months)
- Total interest paid: approximately $210,000
- Interest saved: $282,632 - $210,000 ≈ $72,600 saved with just $200/month extra.
- Total extra paid: 272 × $200 = $54,400. Return on extra payments: $72,600 / $54,400 = 133% return.
已知条件: 30万美元30年期抵押贷款,利率6.5%(月供$1,896)。借款人每月多还$200本金。
计算: 节省的年限和利息。
解答:
- 无额外还款: 30年(360个月),总利息 = $282,632。
- 每月多还$200(总还款$2,096): 求解n: n = -ln(1 - ($300,000 × 0.005417) / $2,096) / ln(1.005417)
- n ≈ 274个月 = 22.8年(节省约7.2年)。
- 额外还款下总还款额: 274 × $2,096 = $574,304。总利息 = $574,304 - $300,000 = $274,304。
- 注意 — 我们需要考虑额外还款更快减少本金的影响。通过迭代摊销计算:
- 实际结清时间:约 272个月(22年8个月)
- 总支付利息:约 $210,000
- 利息节省: $282,632 - $210,000 ≈ 每月仅多还$200就可节省$72,600
- 总额外还款额:272 × $200 = $54,400。额外还款的回报率:$72,600 / $54,400 = 133%。
Common Pitfalls
常见误区
- Comparing interest rate instead of APR — APR captures fees and gives a truer cost comparison
- ARM teaser rates creating payment shock when the fixed period ends and rates adjust upward
- Points breakeven: buying points is not worth it if selling or refinancing before the breakeven point
- HELOC variable rate risk during rising rate environments — budget for rate increases
- PMI costs making high-LTV loans more expensive than they appear — factor PMI into total monthly cost
- Ignoring opportunity cost: extra mortgage payments at 3-4% vs investing at 7-10% expected return
- Not shopping multiple lenders — rate quotes can vary 0.5%+ for the same borrower
- Resetting to a 30-year term when refinancing — extends total payoff even if rate is lower
- Ignoring closing costs in refinancing decisions (see debt-management refinance breakeven)
- 对比利率而非APR — APR包含费用,能提供更真实的成本对比
- ARM的初始优惠利率在固定期限结束、利率上浮时会造成还款冲击
- 贴现点盈亏平衡:如果在盈亏平衡点前出售房产或refinance,购买贴现点不划算
- 利率上升环境下HELOC的浮动利率风险 — 要为利率上涨预留预算
- PMI成本会让高LTV贷款的实际成本比看起来更高 — 要把PMI计入总月供成本
- 忽略机会成本:额外还3-4%利率的抵押贷款,对比投资预期收益7-10%的产品哪个更划算
- 不对比多家贷款机构 — 同一借款人的利率报价可能相差0.5%以上
- refinance时重置为30年期 — 即使利率更低也会延长总还款期限
- 做refinance决策时忽略过户成本(参考债务管理的refinance盈亏平衡点计算)
Cross-References
交叉参考
- debt-management (wealth-management plugin, Layer 6): refinancing analysis, debt payoff vs investing decisions, DTI calculations
- emergency-fund (wealth-management plugin, Layer 6): adequate reserves required for loan qualification and financial safety
- tax-efficiency (wealth-management plugin, Layer 5): mortgage interest deductibility, points deduction
- savings-goals (wealth-management plugin, Layer 6): down payment saving is a common goal-based savings target
- liquidity-management (wealth-management plugin, Layer 6): mortgage payments are the largest fixed obligation in most household cash flow plans
- debt-management(财富管理插件,层级6):refinance分析、还债vs投资决策、DTI计算
- emergency-fund(财富管理插件,层级6):贷款资质和财务安全要求充足的储备金
- tax-efficiency(财富管理插件,层级5):抵押贷款利息抵扣、贴现点抵扣
- savings-goals(财富管理插件,层级6):存首付是常见的目标储蓄指标
- liquidity-management(财富管理插件,层级6):抵押贷款还款是大多数家庭现金流计划中最大的固定支出
Reference Implementation
参考实现
See for computational helpers.
scripts/lending.py计算辅助工具见 。
scripts/lending.py