Estimated Formula
This calculator:
Is based on 12 months of actual expenses
Assumes estimated payroll costs are stable and determined by formula
         
12-Month Period      
     
         
Payroll Costs (1)   Est Exp for 8 Weeks (2)
Number of Pay Periods   Number of Pay Periods
         
COGS Labor   COGS Labor
OH Labor   OH Labor
GA Labor   GA Labor
Compensated Absences (3)   Compensated Absences (3)
State & Local Taxes   State & Local Taxes
Workmen's Comp (4)   Workmen's Comp (4)
Retirement (5)   Retirement (5)
Health Insurance (6)   Health Insurance (6)
Dental Insurance (6)   Dental Insurance (6)
         
Less Wages  >$100,000   Subtotal Payroll Costs (8)
         
Total Annual Payroll Costs   Other Monthly Expenses  
      Rent
Monthly Average (7)   Utilities
      Telephone
250% Payroll Costs   Internet
      Interest
+ Outstanding EIDL    
      Subtotal Other Expenses
- COVID-19 EIDL Advance      
      X 2 months
         
Loan Amount   Total Use of Loan
         
Forgiveness 75%   Forgiveness 75%
         
      Adjusted Monthly Average
         
Forgivable Amount   Not Forgivable
         
1. Actual payroll costs for referenced period.
2. Estimated costs for 8 weeks. May be a formula or direct entry of expected costs.
3. Compensated absences exclude those covered under FFCRA.
4. Workmen's comp is often a prepaid expense that needs to be amortized monthly.
5. Retirement contributions may be discretionary.
6. Health insurance premiums usually paid monthly, not per pay period.
7. Based on 2019 actuals which may have been a good year that included OT or bonuses.
8. Assumes all things equal to #7.
         
We hope this calculator has been helpful. All attempts have been made to ensure its accuracy. However, we cannot guarantee the results provided here. Please consult with your SBA Lender  for more information.
         
        Version 1.01
Estimated User Entry
This calculator:
Is based on 12 months of actual expenses
Assumes estimated payroll costs are entered by user
         
12-Month Period      
     
         
Payroll Costs (1)   Est Exp for 8 Weeks (2)
         
COGS Labor   COGS Labor
OH Labor   OH Labor
GA Labor   GA Labor
Compensated Absences (3)   Compensated Absences (3)
State & Local Taxes   State & Local Taxes
Workmen's Comp (4)   Workmen's Comp (4)
Retirement (5)   Retirement (5)
Health Insurance (6)   Health Insurance (6)
Dental Insurance (6)   Dental Insurance (6)
         
Less Wages  >$100,000   Subtotal Payroll Costs (8)
         
Total Annual Payroll Costs   Other Monthly Expenses  
      Rent
Monthly Average (7)   Utilities
      Telephone
250% Payroll Costs   Internet
      Interest
+ Outstanding EIDL    
      Subtotal Other Expenses
- COVID-19 EIDL Advance      
      X 2 months
         
Loan Amount   Total Use of Loan
         
Forgiveness 75%   Forgiveness 75%
         
      Adjusted Monthly Average
         
Forgivable Amount   Not Forgivable
         
1. Actual payroll costs for referenced period.
2. Estimated costs for 8 weeks. May be a formula or direct entry of expected costs.
3. Compensated absences exclude those covered under FFCRA.
4. Workmen's comp is often a prepaid expense that needs to be amortized monthly.
5. Retirement contributions may be discretionary.
6. Health insurance premiums usually paid monthly, not per pay period.
7. Based on 2019 actuals which may have been a good year that included OT or bonuses.
8. Assumes all things equal to #7.
         
We hope this calculator has been helpful. All attempts have been made to ensure its accuracy. However, we cannot guarantee the results provided here. Please consult with your SBA Lender  for more information.
         
        Version 1.01