Apr 8 2020

SBA Paycheck Protection Program (PPP) Loan Estimator

Unsurprisingly, numerous SBA PPP Loan calculators have appeared on the web. Many of them are tied to a specific bank and have various complexity (or simplicity) in determining the amounts available. We’ve tried a few of them for comparison and found the calculations to be inconsistent.

So, we created our own and validated it with a number of accountants and lawyers. As the rules changed (and they continue to change), we updated it so we believe that it is current as of 4/8/20.

I’m going to refer to it as the Mostly Simple, Super Clear, SBA PPP Loan Estimator. It’s a Google Sheet, so if you want to use it, just click the link above, make a copy, and do whatever you want with it.

Please note the Disclaimer: this simplified model is meant to provide a quick, rough estimate the size of potential PPP loans and forgiveness amounts for planning purposes. Actual loan and forgiveness amounts will be determined by your bank based on federal law, regulations and bank implementation policies. Please consult your bank’s calculator and program paperwork to determine actual loan and forgiveness amounts.