Benchmark Lending Rate Debt Sensitivity Workbench

Simulate debt servicing costs, corporate facility interest loads, and refinancing sensitivity when benchmark rates (LPR, SOFR, EURIBOR) remain on hold or shift across policy cycles.

Effective All-In Rate
4.10%
3.35% Base + 0.75% Spread
Total Debt Service
¥11,093,820
Principal + Cumulative Interest
Cumulative Interest
¥1,093,820
10.9% of Facility Principal
Policy Delta vs Hold
¥0
Unchanged 16-month hold status

Payment Composition & Benchmark Impact per Period

Principal Repaid
Interest Expense
Counterfactual Hold Cost
Tranche Amortization & Cashflow Schedule
5 Annual Periods
Period Opening Principal Benchmark All-In Rate Interest Principal Paid Ending Principal
Simulating debt service on active benchmark curve.

Understanding Benchmark Rate Inaction

Central banks like the People's Bank of China (PBOC) frequently hold benchmark Loan Prime Rates (1-year for corporate credit, 5-year for mortgages/capex) steady during periods of currency stability defense or net interest margin (NIM) pressures at commercial banks.

  • Extended Hold Impact: Borrowers with floating debt continue paying existing margins over fixed benchmarks, creating predictable cashflows but preventing debt-relief benefits from expected easing.
  • Refinancing Cliffs: As short-term working capital loans mature, borrower refinancing risk hinges on whether future policy shifts occur before term expiration.

How to Use This Sensitivity Model

Corporate financial officers, treasury teams, and mortgage borrowers can stress-test payments:

  • Switch Trajectories: Compare an extended "Hold" baseline against an active 50 bps easing cycle or an inflationary tightening shock.
  • Test Structures: Toggle between equal amortizing debt service and bullet/interest-only structures to see interest drag differentials.
  • Export Verified Data: Download full period-by-period cashflow ledgers directly into corporate budgeting and FP&A workflows.
Enjoy this tool? Build your own with Super