=== Following Your Exact Guidelines for Payoff Calculation ===


Test Case: URL013572
============================================================

Input Data:
  Initial Balance: 6,397,076.00
  Monthly Payment: 177,697.00
  Ded Balance Amount: 5,508,591.00

Step 1: Total Tenure = Initial Balance / Monthly Payment
  6397076 / 177697 = 36 months

Step 2: Remaining Tenure = Ded Balance / Monthly Payment
  5508591 / 177697 = 31 months

Step 3: Installments Paid = Total Tenure - Remaining Tenure
  36 - 31 = 5 months

Step 4: Calculate Principal Balance at Month 5 using Reducing Balance
  Annual Rate: 12%
  Monthly Rate: 1.0000%

  Amortization Schedule:
  Month   Interest       Principal      Balance        
  -----------------------------------------------------
  1       63,970.76      113,726.24     6,283,349.76   
  2       62,833.50      114,863.50     6,168,486.26   
  3       61,684.86      116,012.14     6,052,474.12   
  4       60,524.74      117,172.26     5,935,301.86   
  5       59,353.02      118,343.98     5,816,957.88   

Principal Balance after 5 payments: 5,816,957.88
This is the payoff amount based on reducing balance formula.

============================================================
RESULTS:
  Calculated Payoff: 5,816,957.88
  Expected Payoff: 3,774,876.79
  Difference: 2,042,081.09

Factor needed to match: 0.648943

Alternative Analysis:
  If we use ded_balance_amount directly:
    5508591 × 0.685271 = 3,774,877.66
    This matches the expected payoff!

CONCLUSION:
------------------------------------------------------------
Following your guidelines with standard reducing balance gives: 5,816,957.88
But the expected payoff is: 3,774,876.79

The expected payoff appears to be:
  ded_balance_amount × 0.685271 = payoff
  5508591 × 0.685271 = 3,774,877.66