PPP Loan Estimator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGH
1
2
PPP Loan and Forgiveness Amount Estimator
3
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.
4
To use model - Please download copy as editing is currently disabled. Figures included for illustration only.
5
6
INPUTData Entry
7
8
LOAN ELIGIBILITY ESTIMATE
9
"PAYROLL COSTS" for calendar year 2019.Source
10
$550,000
salaries/wages/Vacation/Parental, family, medical, sick leave/Allowance for dismissal, seperation (all employees)
Use IRS Form 940, Part 2, Box 3.
11
$175,000Health care benefits paid by employer
Obtain Information from your payroll provider and/or health insurance carrier
12
$25,000Retirement benefits paid by employerObtain Information from your payroll provider
13
$15,000State or Local taxesObtain Information from your payroll provider
14
$765,000Payroll Costs
15
16
$15,000LESS FEDERAL PAYROLL TAXES included in Row 10, if any.Obtain Information from your payroll provider
17
$35,000LESS CASH COMPENSATION to individual employees in excess of $100K (enter as positive #)Do a rough estimate of this amount based on your knowledge of compensation. Do NOT include benefit costs when calculating cash payments in excess of $100K.
18
$715,000Adjusted payroll costs
19
20
12Number of months to compute average
21
$59,583Average monthly payroll costs
22
23
250%Loan factor (2.5X average monthly payroll costs)
24
$148,958.33TOTAL LOAN ELIGIBILITY ESTIMATE
25
Loading...