Formula to add numbers in a table based on date criteria

I need to calculate short term loan payment balances (12 months). I have included my worksheet and the tables associated with it along with an explanation. I need the formula to calculate the principal payments from each table for the next 12 months after the date in B1 (or the current ending balance if there are less than 12 payments due).

For example, based on the attached, #76 should have short term of $10,582.62 (Feb 23 - Jan 24 principal payments).

Thanks in advance!