Explain the logic behind the calculation of Principal Repay.
The computation follows a logic similar to that of the debt tranche (rows 31 and 32), but the column reference in the required VLOOKUP function points to column 6 (EoP) instead of total payment. This is done to determine the endofperiod balance.