IMO - There are too many possible variations of Amount and Term (that effect the APR calculation) to be able to say . . .
" For a 10 year 1st lien loan, this week's APOR plus 1.5 is 6.25 APR = Therefore our maximum Note Rate is X "
For example if you charge a $300 Origination Fee; that would push up the APR on a $10,000 10 year loan
a lot more (maybe .60) than it would push up the APR on a $70,000 10 year loan (maybe .1) ???
As I have struggled with this & how can our loan processors work with this - - - The only answer I have come up with is the worksheet that you describe.
I have a spreadsheet that I will update weekly and it gives the Max APR without becoming a HPML, for our standard loan products.
The processors will just have to work with the Early TIL to determine if it is close & go from there to get the lender to lower the note rate if necessary.
:: Steps up on Soap Box ::
The effect of more government regulations :
1. More community banks will stop lending on Resideces
2. Those who stay in the market will have to lower their desired loan rates to avoid the required escrow = Less Income for the bank