BTW, as a follow-up to the previous manual calculation, I recognize that using the Box 2 value as each loan amount is not precisely correct. One should use the average of the origination value and the ending value for each period. However, for the purpose of establishing an average over 12 months, it doesn't make a significant difference, as payoff amounts within a fraction of the year don't amount to much. Just saying.
