| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
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 | INPUT | Data 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,000 | Health care benefits paid by employer | Obtain Information from your payroll provider and/or health insurance carrier | |||||
12 | $25,000 | Retirement benefits paid by employer | Obtain Information from your payroll provider | |||||
13 | $15,000 | State or Local taxes | Obtain Information from your payroll provider | |||||
14 | $765,000 | Payroll Costs | ||||||
15 | ||||||||
16 | $15,000 | LESS FEDERAL PAYROLL TAXES included in Row 10, if any. | Obtain Information from your payroll provider | |||||
17 | $35,000 | LESS 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,000 | Adjusted payroll costs | ||||||
19 | ||||||||
20 | 12 | Number of months to compute average | ||||||
21 | $59,583 | Average monthly payroll costs | ||||||
22 | ||||||||
23 | 250% | Loan factor (2.5X average monthly payroll costs) | ||||||
24 | $148,958.33 | TOTAL LOAN ELIGIBILITY ESTIMATE | ||||||
25 | ||||||||