How to calculate Payroll Costs | Paycheck Protection Program Loan

How To Calculate Payroll Costs For Your Paycheck Protection Program Loan

how to calculate payroll cost
Calculate Payroll Costs
The Paycheck Protection Program (PPP) got off to a bad start last Friday, creating a lot of frustration and anger. Caught short by an aggressive timeline, many banks still haven’t started taking applications. Even where the program is up and running, banks and applicants are still struggling to understand exactly how the process will work. 




Let’s assume that banks will eventually figure out the details.  Business owners can get ready by gathering the information they’ll need.  And while many elements of the program are still developing, you can count on one thing: The bank you’re working with is going to ask for your payroll costs. They will use them that figure to figure out the maximum amount that they can loan you. 
Sound simple, right?  Not so fast. The new law and regulations expand the definition of payroll in significant ways.  Calculating these costs has gotten more complicated. Let’s look at what you’ll need to include in your payroll calculation.
A lot of this hasn’t been nailed down yet.  Things are changing rapidly. Some of the laws and regulations contradict each other.  But here I’ll give you my best interpretation. Use it as a guide and adjust as necessary for your specific bank application. 
Calculating the maximum amount of your loan
The maximum amount you are allowed to borrow under PPP is the lessor of $10M or 2.5 times your payroll costs. The Interim Final Rule released last Wednesday gave a step-by-step calculation:
  • Step 1: Aggregate payroll costs from the last 12 months for employees whose principal place of residence is the United States.
  • Step 2: Subtract any compensation paid to an employee in excess of an annual salary of $100,000 and/or any amounts paid to an independent contractor or sole proprietor in excess of $100,000 per year.
  • Step 3: Calculate average monthly payroll costs (divide the amount from Step 2 by 12).
  • Step 4: Multiply the average monthly payroll costs from Step 3 by 2.5.
  • Step 5: Add the outstanding amount of an Economic Injury Disaster Loan (EIDL) made between January 31, 2020 and April 3, 2020, less the amount of any “advance” under the EIDL COVID-19 loan because it does not have to be repaid.
The way you calculate your payroll costs depends on how your business is set up. We’ll talk about that in a minute. But a key element to remember is Step 3 is for your average monthly payroll costs and the total after step 5 is the maximum amount of your loan. 
Payroll costs for independent contractors and sole proprietors with no employees
If you’re an independent contractor or sole proprietor with no employees, the calculation is a little easier. The regulation defines “payroll costs” as wage, commissions, income, or net earnings from self-employment or similar compensation. For the majority of you, that number will be your net self-employment income – your income after you deduct your business expenses. 
Let’s say for the previous rolling year, you made $60,000. Going through the steps would look like this: 
  • Step 1: $60,000
  • Step 2: $0
  • Step 3: $60,000/12 = $5,000
  • Step 4: $5,000*2.5 = $12,500
  • Step 5: $0 
  • Total: $12,500
Your average monthly payroll costs are $5000 and the maximum amount of your loan is $12500.  
Now let’s assume your net-self-employment income was $150,000 and you happen to get the EIDL (I’ve yet to hear of anyone getting this, but let’s calculate how it would work conceptually.) Your steps are: 
  • Step 1: $150,000
  • Step 2: $50,000
  • Step 3: $100,000/12 = $8,333.33 
  • Step 4: $8,333.33 * 2.5 = $20,833.33
  • Step 5: $10,000 
  • Total: $30,833.33
You average monthly payroll costs are $8,333.33 and the maximum amount of your loan in this situation would be $30,833. This would also refinanced your EDIL into your PPP loan. The cap makes the calculation pretty straightforward for sole proprietors and independent contractors making over $100,000. The maximum you can get is $20,833, if you’ve not gotten the EIDL loan. 
Before the regulations came out, the language of the CARES Act counted “payments to” independent contractors as payroll costs. However, since then, the regulations have expressly excluded contractor payments as a payroll cost. In somewhat of a contradiction, all applicants must certify that they “had employees for whom it paid salaries and payroll taxes or paid independent contractors, as reported on a Form 1099-Misc.” We hope and expect the government will clarify these contradictions soon. 
Payroll costs for businesses with employees 
For those of you with employees, the calculation has additional variables. Payroll costs for you include.
  • Compensation to employees (whose principal place of residence is in the United States) in the form of salary, wages, commissions, or similar compensation 
  • Cash tips or the equivalent (based on employer records of past tips or, in the absence of such records, a reasonable, good-faith employer estimate of such tips)
  • Payment for vacation, parental, family, medical, or sick leave. 
  • Allowance for separate or dismissal
  • Payment of employee benefits consisting of group health care coverage, including insurance premiums, and retirement 
  • Payment of state and local taxes assessed on compensation of employees
In addition to including the additional payroll costs, the Act expressly excludes the following 
  • Compensation of an individual employee in excess of an annual salary of $100,000
  • Federal employment taxes imposed or withheld between February 15, 2020 and June 30, 2020, including the employee’s and employer’s share of FICA and Railroad Retirement Act Taxes, and income taxes required to be withheld from employees
  • Qualified sick and family leave wages for which a credit is allowed under sections 7001 and 7003 of the Families First Coronavirus Response Act (the first stimulus package
In short, this calculation includes wages and benefits. I’ve seen clients already miss the fact that they can add group health coverage and retirement contributions. You’ll also have to make sure you’ll be able to separate out the federal, state and local taxes that you pay on local income. (Some groups are fighting to have federal withholding and employee FICA included as well.)
Many tax and financial professionals are debating whether the $100k compensation requirement includes the benefits paid to individual employees. My take is that it doesn’t because of the words “annual salary.” Salary doesn’t usually include the value of benefits. Additionally, calculating all of the benefits would require you to separate out each employee’s health insurance and state and local taxes.  As with the other gray areas, reasonable minds, including your lender, may differ. 
An example may help here. Let’s say you’ve paid $300,000 in total compensation to employees, none of whom have an annual salary over $100,000. Additionally, you paid $20,000 in health insurance and $10,000 in state and local taxes. And you’ve not received an EIDL loan. Your steps look like  
  • Step 1: $300,000+$20,000+$10,000 = $330,000
  • Step 2: $0
  • Step 3: $330,000/12 = $27,500
  • Step 4: $27,500*2.5 = $68,750
  • Step 5: $0 
  • Total: $68,750
Your average monthly payroll costs are $27,500. The maximum amount of your loan would be $68,750. 
Let’s say you’ve paid $1,000,000 in total compensation to employee, three of whom have an annual salary of $150,000. Additionally, you paid $50,000 in health insurance and $30,000 in state and local taxes. Lastly, you received the $10,000 EIDL loan advance:
  • Step 2: $1,000,000+$50,000+$30,000 = $1,080,000
  • Step 2: $1,080,000 - $150,000 ($50,000*3) = $930,000
  • Step 3: $930,000/12 = $77,500  
  • Step 4: $77,500 * 2.5 = $193,750
  • Step 5: $10,000 (advance)
  • Total: $203,750
Your average monthly payroll costs are $77,500 and the maximum loan amount is $203,750
Pitfalls to avoid 
Obviously, this is not straightforward. Florida Senator Marco Rubio tweeted over the weekend that clearer regulations are coming early next week. However, with more and more bank applications getting up and running, I want you to be as prepared as you can be, as soon as possible.  That’s important because these loans are granted on a first-come, first-serve basis. Here are a couple of issues to watch out for. 
Supporting documents
In addition to being able to calculate your monthly payroll costs, you’ll need to provide supporting documents. These documents include: 
  • Payroll processor record
  • Payroll tax filings
  • Form 1099-Misc
  • Income and Expenses from a sole proprietor (Profit and Loss) 
  • Bank records  
You will also need similar documentation for the loan forgiveness. Remember that in order to be forgiven, no more than 25% of the loan proceeds can be spent on non-payroll costs. 
What time frame do I run my numbers for? 
In section 2(e)(i) of the interim final rule, it instructs borrowers “aggregate payroll costs from the last twelve months,” which presumably means April 1, 2019 – March 31, 2020. However, a little further down in Section 3(b)(iii), the rule instructs lenders to confirm the “average monthly payroll costs for the preceding calendar year.” The final borrower application form also gives that time frame. 
Right now, different banks are asking for different time frames. Bank of America has asked for a payroll report for 2019, payroll from January 1, 2020 through February 15, 2020 and independent contractor costs for 2019 (there’s that independent contractor issue again). 
That means you’ll need to find out what your specific lender is asking for. If you can’t find anything, have 2019 numbers, as well as the last 12 months, so you don’t have to waste precious application time rerunning your profit and loss.


0 Comments